摘要：AddOperationColum public void AddOperationColum() { if (!isOpen) return; GridColumn NewColumn = this.gridView1.Columns.AddField("Operation"); NewColumn.VisibleIndex = this.gridView1.Columns.Count; NewColumn.UnboundType = DevExpress.D... 阅读全文

摘要：btnCalc_Clickprivate void btnCalc_Click(object sender, EventArgs e) { double total = 0.0d; string ctypeStr = icmbCtype.SelectedItem.ToString(); css = DXSLFactory.CashFactory.CreateCashSuper(ctypeStr); double d = css.AcceptCash(double.Parse(txtMoney.... 阅读全文

摘要：oracle 中测试成功--找出表中的重复数据 select * from vav_groupbrand_casn where ccasn in ( select ccasn from vav_groupbrand_casn group by ccasn having count(*)>1 ) order by ccasn--找出表中的重复数据 select * from vav_groupbrand_casn a, vav_groupbrand_casn b where a.cgroupbranid =b.cgroupbranid and a.ccasn=b.ccasn and a.c 阅读全文

摘要：一、构造3个对象的集合 List<VAV_AREA> arealist = new List<VAV_AREA>(); List<VAV_CORP> corplist = new List<VAV_CORP>(); List<VAV_CITY> citylist = new List<VAV_CITY>();二、得到集合数据三、linq处理2个list to linq left join var v = from area in arealist join corp in corplist.DefaultIfEmpty() 阅读全文

摘要：Oracle 时间差计算两个Date类型字段：START_DATE，END_DATE，计算这两个日期的时间差（分别以天，小时，分钟，秒，毫秒）：天：ROUND(TO_NUMBER(END_DATE - START_DATE))小时：ROUND(TO_NUMBER(END_DATE - START_DATE) * 24)分钟：ROUND(TO_NUMBER(END_DATE - START_DATE) * 24 * 60)秒：ROUND(TO_NUMBER(END_DATE - START_DATE) * 24 * 60 * 60)毫秒：ROUND(TO_NUMBER(END_DATE - ST 阅读全文