/// <summary> /// 颜色改变 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e) { try { DateTime time1 = SysConvert.ToDateTime(gridView1.GetRowCellValue(e.RowHandle, "InDate")); DateTime time2 = SysConvert.ToDateTime(DateTime.Now.Date); e.Appearance.BackColor = DeviationStatus.GetGridRowBackColor(time1, time2); } catch (Exception E) { this.ShowMessage(E.Message); } }
private void ProcDt(DataTable p_dt) { foreach (DataRow dr in p_dt.Rows)//计算中止率 { TimeSpan Day = System.DateTime.Now - SysConvert.ToDateTime(dr["InDate"]); double dDay = Day.TotalDays; Decimal Days = SysConvert.ToDecimal(SysConvert.ToDecimal(dDay), 2); dr["LKDate"] = Days.ToString(); DateTime time1 = SysConvert.ToDateTime(dr["InDate"]); DateTime time2 = SysConvert.ToDateTime(DateTime.Now.Date); string DeviationStatusName = DeviationStatus.GetGridCellStatusName(time1, time2); dr["DeviationStatusName"] = DeviationStatusName.ToString(); } }
/// <summary> /// 数据初始化(填写表名、绑定控制、初始化界面属性等) /// </summary> public override void IniData() { this.HTDataTableName = "WH_Storge"; this.HTDataList = gridView1; ParamSetRule rule = new ParamSetRule(); // iLKParamSet = SysConvert.ToInt32(rule.RShowIntByCode((int)ParamSetEnum.留库天数)); Common.BindVendor(drpQVendorID, new int[] { (int)EnumVendorType.客户, (int)EnumVendorType.工厂 }, true);//客户 Common.BindWHType(drpQWHTypeID, false); Common.BindWH(drpQWHID, true); new ItemProcLookUp(drpQItemCode, new int[] { 1 }, true, true);//(int)ItemType.纱线 DeviationStatus.ProcCondition("WH_Storge"); DeviationStatus.ColorIniTextBox(groupControlSOColor); SetTabIndex(0, groupControlQuery); }