using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using Core.Mes.Client.Comm.Control; using System.Collections; using Core.Mes.Client.Comm.Server; using Core.StlMes.Client.YdmBase; using Core.Mes.Client.Comm.Tool; using Infragistics.Win.UltraWinGrid; using Core.StlMes.Client.PipeLeaveFactory.YdmObject; using Core.Mes.Client.Comm.Format; using Core.StlMes.Client.PipeLeaveFactory.Tool; using Infragistics.Win; namespace Core.StlMes.Client.PipeLeaveFactory { public partial class frmShipmentDayApp : FrmBase { /// /// 用户销售组织权限 /// private string[] _salgPermissions = null; private string posit = "";//定位 ArrayList pram = new ArrayList(); private string departid;//对应部门ID private string departname;//对应部门 private string management_no;//对应科室id private string management_name;//对应科室 public frmShipmentDayApp() { InitializeComponent(); this.IsLoadUserView = true; } private void frmShipmentDayApp_Load(object sender, EventArgs e) { ClsBaseInfo.SetComboItemHeight(cmbAppFalg); DateTime now = DateTime.Now; DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天 DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天 billNoStime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); BillNoEtime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); DelvryTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); _salgPermissions = InitPermissions(); EntityHelper.ShowGridCaption(ultraGridBillC.DisplayLayout.Bands[0]); //收货单位 BaseHelper.InitOrderUnit(ComRevice, _salgPermissions, this.ob); //专用线 YdmBaseClass.InitComboEditor(TxtLine, "com.steering.pss.ydm.pipeleavefactory.FrmPipeSendList.queryPrivateSid", "SPCL_LN_NO", ob, false); //到站 YdmBaseClass.InitComboEditor(ComStation, "com.steering.pss.ydm.pipeleavefactory.FrmPipeSendList.queryArriveStation", "STATION_NO", ob, false); InAskDay(); management_no = this.UserInfo.GetDeptid(); management_name = this.UserInfo.GetDepartment(); departid = ClsBaseInfo.GetDepartIdBySectionId(UserInfo.GetDeptid(), this.ob); departname = ClsBaseInfo.GetDepartBySectionId(UserInfo.GetDeptid(), this.ob); } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": doQuery(); break; case "Add": doAdd(); break; case "Delete": doDelete(); break; case "Update": doUpdate(); break; case "App": doApp(); break; case "DeleteApp": doDeleteApp(); break; case "Export": GridHelper.ulGridToExcel(ultraGrid1, "铁运日请车批车"); break; case "Close": this.Close(); break; } } /// /// 查询请车批车号 /// private void InAskDay() { DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryAskDay", new object[] { DateTime.Now.ToString("yyyy-MM-dd") }, ob); ComAskDay.DataSource = dt; ComAskDay.ValueMember = "ASK_DAY_NO"; Object[] obj = new Object[] { "" }; DataRow dr = dt.NewRow(); dr.ItemArray = obj; dt.Rows.Add(dr); } /// /// 查询 /// private void doQuery() { if (ultraTabControl1.SelectedTab.Key.Equals("1")) { string strFalg = "";//审批状态 string strStrattime = ""; string strEndtime = ""; string strAskDay = ""; if (chkDate.Checked) { strStrattime = DelvryTime.Value.ToString(); strEndtime = EndTime.Value.ToString(); if (DateTime.Parse(DelvryTime.Value.ToString()) > DateTime.Parse(EndTime.Value.ToString())) { MessageUtil.ShowTips("您所选择时间区间不正确,请重新选择!"); return; } } if (chkFlag.Checked) { strFalg = cmbAppFalg.Value.ToString(); } if (ChkAskDay.Checked) { if (txtAskDay.Text.Trim() == "") { MessageUtil.ShowTips("日请车批车不能为空!"); return; } strAskDay = txtAskDay.Text.Trim(); } pram.Clear(); pram.Add(strAskDay); pram.Add(strFalg); pram.Add(strStrattime); pram.Add(strStrattime); pram.Add(strStrattime); pram.Add(strEndtime); pram.Add(strEndtime); DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQuery", new object[] { pram, this.ValidDataPurviewIds }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true); for (int i = 0; i < ultraGrid1.Rows.Count; i++) { string strindex = ultraGrid1.Rows[i].Cells["ASK_DAY_PK"].Value.ToString(); if (strindex == posit) { UltraGridRow row = ultraGrid1.Rows[i]; row.Activate(); } } } else { ArrayList param = new ArrayList(); string BillStartTime = ""; string BillEndTime = ""; if (ChcBillTime.Checked) { BillStartTime = billNoStime.Value.ToString(); BillEndTime = BillNoEtime.Value.ToString(); if (DateTime.Parse(BillStartTime) > DateTime.Parse(BillEndTime)) { MessageUtil.ShowTips("您所选择时间区间不正确,请重新选择!"); return; } } string order=""; if (ChcOrderNo1.Checked) { order = TxtOrderNo1.Text.Trim(); } //string status = ""; //if (ChcStatus.Checked) { status = ComStatus.Value.ToString(); } string station = ""; if (ChcStation.Checked && ComStation.Value != null) { station = ComStation.Value.ToString(); } string spcl = ""; if (ChcLine.Checked && TxtLine.Value != null) { spcl = TxtLine.Value.ToString(); } string reciveNm = ""; if (ChcRecive.Checked) { reciveNm = ComRevice.Text.Trim(); } param.Add(BillStartTime); param.Add(BillStartTime); param.Add(BillStartTime); param.Add(BillEndTime); param.Add(BillEndTime); param.Add(order); param.Add(station); param.Add(spcl); param.Add(reciveNm); DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryBilM", new object[] { param, this.ValidDataPurviewIds }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref BillTable, true); if (dt.Rows.Count <=0) { List listBillC = EntityHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmPipeTrainBill.queryBillC", new object[] { "" }, this.ob); ydmZcBillCEntityBindingSource.DataSource = listBillC; } for (int i = 0; i < ultraGridBillM.Rows.Count; i++) { string strindex = ultraGridBillM.Rows[i].Cells["BILL_NO"].Value.ToString(); if (strindex == posit) { UltraGridRow row = ultraGridBillM.Rows[i]; row.Activate(); } } InAskDay(); ComAskDay.Text = ""; } posit = ""; } /// /// 新增日请车 /// private void doAdd() { ultraGridBillM.UpdateData(); UltraGridRow ugr = ultraGridBillM.ActiveRow; if (ugr == null) { MessageUtil.ShowTips("无数据,不能进行此操作!"); return; } int isSelect = 0; ArrayList list = new ArrayList(); string strTime = DateTime.Now.ToString(); string askDay = ""; if (ComAskDay.Text.Trim() == "") { doAskDayNo(); } askDay = ComAskDay.Text.Trim(); foreach (UltraGridRow row in ultraGridBillM.Rows) { if (Convert.ToBoolean(row.Cells["CHK"].Text) == true) { isSelect += 1; if (row.Cells["VEHICLE_DAY_NUM"].Text.Trim() == "0" || row.Cells["VEHICLE_DAY_NUM"].Text.Trim().Equals("")) { MessageUtil.ShowTips("请输日请车数!"); return; } string spclNo = "N"; if (!row.Cells["SPCL_LN_NO"].Value.ToString().Equals("")) { spclNo = row.Cells["SPCL_LN_NO"].Value.ToString(); } pram.Clear(); pram.Add(askDay); pram.Add(row.Cells["ASK_MONTH_NO"].Value.ToString()); pram.Add(row.Cells["BILL_NO"].Value.ToString()); pram.Add(row.Cells["STATION_NO"].Value.ToString()); pram.Add(spclNo); pram.Add(row.Cells["RECEIV_NO"].Value.ToString()); DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryFalg", new object[] { pram }, ob); if (dt.Rows.Count > 0) { if (dt.Rows[0]["APP_FLAG"].ToString().Equals("1")) { MessageUtil.ShowTips("您要请车的该条数据已日请车审批,请重新选择!"); return; } } YdmZcAskDayEntity ydm = new YdmZcAskDayEntity(); ydm.AskDayNo = askDay; ydm.AskMonthNo = row.Cells["ASK_MONTH_NO"].Text.Trim(); ydm.BillNo = row.Cells["BILL_NO"].Text.Trim(); ydm.WagonsPlanNo = row.Cells["WAGONS_PLAN_NO"].Text.Trim(); ArrayList listmonth = new ArrayList(); listmonth.Add(row.Cells["ASK_MONTH_NO"].Text.Trim()); listmonth.Add(row.Cells["BILL_NO"].Value.ToString()); listmonth.Add(row.Cells["STATION_NO"].Text.Trim()); listmonth.Add(spclNo); listmonth.Add(row.Cells["RECEIV_NO"].Text.Trim()); DataTable dtDay = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryDayAsk", new object[] { listmonth }, this.ob); string strwaflag = "1"; if (dtDay.Rows.Count > 0) { if (dtDay.Rows[0]["ASK_DAY_NO"].ToString() != askDay) { //if (MessageUtil.ShowYesNoAndQuestion("该请车记录已存在,是否继续添加补充请车?") == DialogResult.No) return; strwaflag = "2"; } } ydm.WagonsFlag = strwaflag; ydm.SpclLnNm = row.Cells["SPCL_LN_NM"].Text.Trim(); ydm.SpclLnNo = row.Cells["SPCL_LN_NO"].Text.Trim(); ydm.StationNm = row.Cells["STATION_NM"].Text.Trim(); ydm.StationNo = row.Cells["STATION_NO"].Text.Trim(); ydm.ReceivNm = row.Cells["RECEIV_NM"].Text.Trim(); ydm.ReceivNo = row.Cells["RECEIV_NO"].Text.Trim(); ydm.PurName = this.UserInfo.GetUserName(); ydm.PurTime = strTime; ydm.DepartmentCode = departid; ydm.DepartmentDesc = departname; ydm.ManagementName = management_name; ydm.ManagementNo = management_no; ydm.CreateName = this.UserInfo.GetUserName(); ydm.CreateTime = strTime; ydm.VehicleDayNum = row.Cells["VEHICLE_DAY_NUM"].Text.Trim(); ydm.Memo = row.Cells["MEMODAY"].Text.Trim(); ydm.SendPlanNo = row.Cells["ASK_MONTH_PK"].Value;//月请车PK值 list.Add(JSONFormat.Format(ydm)); } } if (isSelect==0) { MessageUtil.ShowTips("请选择要操作的数据!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否新增日请车?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp"; ccp.MethodName = "doAdd"; ccp.ServerParams = new object[] { list }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("新增请车成功!") || ccp.ReturnInfo.Equals("修改请车成功!")) { MessageUtil.ShowTips(ccp.ReturnInfo); posit = ugr.Cells["BILL_NO"].Text.Trim(); doQuery(); } } } /// /// 取消日请车 /// private void doDelete() { ultraGrid1.UpdateData(); UltraGridRow ugr = ultraGrid1.ActiveRow; if (ugr == null) { MessageUtil.ShowTips("无数据,不能进行此操作!"); return; } int isSelect = 0; ArrayList list1 = new ArrayList(); foreach (UltraGridRow row in ultraGrid1.Rows) { if (Convert.ToBoolean(row.Cells["CHK"].Text) == true) { isSelect += 1; pram.Clear(); pram.Add(row.Cells["ASK_DAY_PK"].Value.ToString()); DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryFalgAsk", new object[] { pram }, ob); if (dt.Rows.Count > 0) { if (dt.Rows[0]["APP_FLAG"].ToString().Equals("1")) { MessageUtil.ShowTips("您选择的该条数据已日请车审批,请重新选择!"); return; } } ArrayList list = new ArrayList(); list.Add(row.Cells["ASK_DAY_PK"].Value.ToString()); list1.Add(list); } } if (isSelect == 0) { MessageUtil.ShowTips("请选择要操作的数据!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否取消日请车?") == DialogResult.No) return; int count = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doDelete", new object[] { list1 }, ob); if (count > 0) { MessageUtil.ShowTips("取消请车成功!"); doQuery(); } } /// /// 修改 /// private void doUpdate() { ultraGrid1.UpdateData(); ArrayList listUp = new ArrayList(); UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr == null) return; int isSelect = 0;//修改,审批 string strtime = ""; foreach (UltraGridRow row in ultraGrid1.Rows) { if (Convert.ToBoolean(row.Cells["CHK"].Text)==true) { isSelect += 1; if (!doQueryFalg(row)) return; if (row.Cells["BATCH_DAY_NUM"].Value.ToString() == "") { MessageUtil.ShowTips("批复数不能为空,请重新输入!"); return; } ArrayList list = new ArrayList(); list.Add(row.Cells["BATCH_DAY_NUM"].Value.ToString()); list.Add(row.Cells["ACT_DAY_60NUM"].Value.ToString()); list.Add(row.Cells["ACT_DAY_70NUM"].Value.ToString()); list.Add(this.UserInfo.GetUserName()); list.Add(strtime); list.Add(row.Cells["ASK_DAY_PK"].Text.Trim()); listUp.Add(list); } } if (isSelect == 0) { MessageUtil.ShowTips("请选择您要操作的记录!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.No) return; int count = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doUpdate", new object[] { listUp }, ob); if(count>0) { MessageUtil.ShowTips("修改成功!"); posit = ugr.Cells["ASK_DAY_PK"].Text.Trim(); doQuery(); } } /// /// 审批 /// private void doApp() { ArrayList listUp = new ArrayList(); UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr == null) return; int isSelect = 0;//修改,审批 string strTime = DateTime.Now.ToString(); foreach (UltraGridRow row in ultraGrid1.Rows) { if (Convert.ToBoolean(row.Cells["CHK"].Text)==true) { isSelect += 1; pram.Clear(); pram.Add(row.Cells["ASK_DAY_PK"].Value.ToString()); DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryFalgAsk", new object[] { pram }, ob); if (dt.Rows.Count > 0) { if (dt.Rows[0]["APP_FLAG"].ToString().Equals("1")) { MessageUtil.ShowTips("您选中的记录已审批,请重新选择!"); return; } if (dt.Rows[0]["BATCH_DAY_NUM"].ToString().Equals("0")) { MessageUtil.ShowTips("您输入的批复数大于日请车数,不能进行此操作!"); return; } } else { MessageUtil.ShowTips("您选中的记录已不存在,请重新选择!"); return; } ArrayList list = new ArrayList(); list.Add(this.UserInfo.GetUserName()); list.Add(strTime); list.Add(row.Cells["ASK_DAY_PK"].Value.ToString()); string spcl = "N"; if (!row.Cells["SPCL_LN_NO"].Value.ToString().Equals("")) { spcl = row.Cells["SPCL_LN_NO"].Value.ToString(); } list.Add(row.Cells["BATCH_DAY_NUM"].Value.ToString()); list.Add(row.Cells["STATION_NO"].Value.ToString()); list.Add(spcl); list.Add(row.Cells["RECEIV_NO"].Value.ToString()); list.Add(row.Cells["ASK_MONTH_NO"].Value.ToString()); listUp.Add(list); } } if (isSelect == 0) { MessageUtil.ShowTips("请选择您要操作的记录!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认审批?") == DialogResult.No) return; int count = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doApp", new object[] { listUp }, ob); if (count > 0) { MessageUtil.ShowTips("审批通过!"); posit = ugr.Cells["ASK_DAY_PK"].Text.Trim(); doQuery(); } } /// /// 取消审批 /// private void doDeleteApp() { ArrayList listUp = new ArrayList(); UltraGridRow ugr = this.ultraGrid1.ActiveRow; if (ugr == null) return; int isSelect = 0; string strTime = DateTime.Now.ToString(); foreach (UltraGridRow row in ultraGrid1.Rows) { if (Convert.ToBoolean(row.Cells["CHK"].Text)==true) { isSelect += 1; pram.Clear(); pram.Add(row.Cells["ASK_DAY_PK"].Value.ToString()); DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryFalgAsk", new object[] { pram }, ob); if (dt.Rows.Count > 0) { if (dt.Rows[0]["APP_FLAG"].ToString().Equals("0")) { MessageUtil.ShowTips("您选中的记录未审批,请重新选择!"); return; } if (double.Parse(dt.Rows[0]["ACT_DAY_NUM"].ToString()) > 0) { MessageUtil.ShowTips("您选中的记录批复数已被占用,请重新选择!"); return; } } else { MessageUtil.ShowTips("您选中的记录已不存在,请重新选择!"); return; } ArrayList list = new ArrayList(); list.Add(this.UserInfo.GetUserName()); list.Add(strTime); list.Add(row.Cells["ASK_DAY_PK"].Value.ToString()); string spcl = "N"; if (!row.Cells["SPCL_LN_NO"].Value.ToString().Equals("")) { spcl = row.Cells["SPCL_LN_NO"].Value.ToString(); } list.Add(row.Cells["BATCH_DAY_NUM"].Value.ToString()); list.Add(row.Cells["STATION_NO"].Value.ToString()); list.Add(spcl); list.Add(row.Cells["RECEIV_NO"].Value.ToString()); list.Add(row.Cells["ASK_MONTH_NO"].Value.ToString()); listUp.Add(list); } } if (isSelect == 0) { MessageUtil.ShowTips("请选择您要操作的记录!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确认取消审批?") == DialogResult.No) return; int count = ServerHelper.SetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doDeleteApp", new object[] { listUp }, ob); if (count > 0) { MessageUtil.ShowTips("取消成功!"); posit = ugr.Cells["ASK_DAY_PK"].Text.Trim(); doQuery(); } } /// /// 判断修改,审批条件 /// /// 选中的行ultraGrid1.ActiveRow /// 返回true之通过,flase不通过 private bool doQueryFalg(UltraGridRow ugr) { pram.Clear(); pram.Add(ugr.Cells["ASK_DAY_PK"].Value.ToString()); DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryFalgAsk", new object[] { pram }, ob); if (dt.Rows.Count > 0) { if (dt.Rows[0]["APP_FLAG"].ToString().Equals("1")) { MessageUtil.ShowTips("您选中的记录已审批,请重新选择!"); return false; } if (ugr.Cells["BATCH_DAY_NUM"].Text=="") { MessageUtil.ShowTips("批复数不能为空,不能进行此操作!"); return false; } if (double.Parse(dt.Rows[0]["VEHICLE_DAY_NUM"].ToString()) < double.Parse(ugr.Cells["BATCH_DAY_NUM"].Value.ToString())) { MessageUtil.ShowTips("您输入的批复数大于日请车数,不能进行此操作!"); return false; } } else { MessageUtil.ShowTips("您选中的记录已不存在,请重新选择!"); return false; } return true; } /// /// Check选择事件 /// /// /// private void Chk_CheckedChanged(object sender, EventArgs e) { if (chkDate.Checked) { DelvryTime.Enabled = true; EndTime.Enabled = true; } else { DelvryTime.Enabled = false; EndTime.Enabled = false; } if (chkFlag.Checked) { cmbAppFalg.Enabled = true; } else { cmbAppFalg.Enabled = false; } if (ChkAskDay.Checked) { txtAskDay.Enabled = true; } else { txtAskDay.Enabled = false; } if (ChcBillTime.Checked) { billNoStime.Enabled = true; BillNoEtime.Enabled = true; } else { billNoStime.Enabled = false; BillNoEtime.Enabled = false; } if (ChcOrderNo1.Checked) { TxtOrderNo1.Enabled = true; } else { TxtOrderNo1.Enabled = false; } //if (ChcStatus.Checked) { ComStatus.Enabled = true; } else { ComStatus.Enabled = false; } if (ChcStation.Checked) { ComStation.Enabled = true; } else { ComStation.Enabled = false; } if (ChcLine.Checked) { TxtLine.Enabled = true; } else { TxtLine.Enabled = false; } if (ChcRecive.Checked) { ComRevice.Enabled = true; } else { ComRevice.Enabled = false; } } /// /// 获取用户的销售组织权限 /// /// private string[] InitPermissions() { ArrayList list = new ArrayList(); string[] userDptIds = this.ValidDataPurviewIds; for (int i = 0; i < userDptIds.Length; i++) { string userDptId = userDptIds[i]; if (userDptId.Length < 6) { if (!list.Contains("100101")) { list.Add("100101"); } if (!list.Contains("100102")) { list.Add("100102"); } if (!list.Contains("100103")) { list.Add("100103"); } string[] strs = new string[list.Count]; for (int j = 0; j < list.Count; j++) { strs[j] = list[j].ToString(); } return strs; } else { if (userDptId.StartsWith("002002")) { if (!list.Contains("100102")) { list.Add("100102"); } } else { if (userDptId.Length < 9) { if (!list.Contains("100101")) { list.Add("100101"); } if (!list.Contains("100103")) { list.Add("100103"); } } else { if (userDptId.StartsWith("002001004")) { if (!list.Contains("100101")) { list.Add("100101"); } } else { if (!list.Contains("100103")) { list.Add("100103"); } } } } } } if (list.Count == 0) { return null; } else { string[] strs = new string[list.Count]; for (int i = 0; i < list.Count; i++) { strs[i] = list[i].ToString(); } return strs; } } private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { //try //{ // ultraGrid1.UpdateData(); // foreach (UltraGridRow r in ultraGrid1.Rows) // { // r.Cells["CHK"].Value = r.Selected; // } //} //catch { } foreach (UltraGridRow uRow in ultraGrid1.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHK"].Value = true; } } } private void ultraGridBillM_AfterRowActivate(object sender, EventArgs e) { UltraGridRow ugr = ultraGridBillM.ActiveRow; if (ugr == null) { return; } List listBillC = EntityHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmPipeTrainBill.queryBillC", new object[] { ugr.Cells["BILL_NO"].Text }, this.ob); ydmZcBillCEntityBindingSource.DataSource = listBillC; } /// /// 日请车批车号 /// private void doAskDayNo() { string strTallyLoad = ""; DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipeleavefactory.FrmShipmentDayApp.doQueryAskDay", new object[] { DateTime.Now.ToString("yyyy-MM-dd") }, ob); if (dt.Rows.Count <= 0) { strTallyLoad = DateTime.Now.ToString("yyyyMMdd") + "001"; } else { string dtAsk = dt.Rows[0]["ASK_DAY_NO"].ToString(); string AskDay = dtAsk.Substring(8, 3); string strLsh = "";//流水号 if (double.Parse(AskDay) < 9) { strLsh = "00" + Convert.ToDouble(double.Parse(AskDay) + 1).ToString(); } else if (double.Parse(AskDay) < 99) { strLsh = "0" + Convert.ToDouble(double.Parse(AskDay) + 1).ToString(); } else { strLsh = Convert.ToDouble(double.Parse(AskDay) + 1).ToString(); } strTallyLoad = DateTime.Now.ToString("yyyyMMdd") + strLsh; } DataTable dt2 = (DataTable)ComAskDay.DataSource; Object[] obj = new Object[] { strTallyLoad }; DataRow dr = dt2.NewRow(); dr.ItemArray = obj; if (dt2.Rows.Count > 0) { if (strTallyLoad != dt2.Rows[0]["ASK_DAY_NO"].ToString()) { dt2.Rows.InsertAt(dr, 0); } } else { dt2.Rows.InsertAt(dr, 0); } ComAskDay.SelectedIndex = 0; } private void ultraGridBillM_AfterSelectChange(object sender, AfterSelectChangeEventArgs e) { //try //{ // ultraGridBillM.UpdateData(); // foreach (UltraGridRow r in ultraGridBillM.Rows) // { // r.Cells["CHK"].Value = r.Selected; // } //} //catch { } foreach (UltraGridRow uRow in ultraGridBillM.Selected.Rows) { if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow)) { uRow.Cells["CHK"].Value = true; } } } /// /// Grid内置按钮点击 /// /// /// private void ultraGridBillM_ClickCellButton(object sender, CellEventArgs e) { ultraGridBillM.UpdateData(); UltraGridRow ugr = ultraGridBillM.ActiveRow; string statin = ugr.Cells["STATION_NO"].Value.ToString(); string receiv = ugr.Cells["RECEIV_NO"].Value.ToString(); string spLine = ugr.Cells["SPCL_LN_NO"].Value.ToString(); FrmPleDayCar fpdc = new FrmPleDayCar(statin, receiv, spLine, ob); fpdc.AutoSize = true; fpdc.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fpdc.Text = "月请车信息"; fpdc.ShowDialog(); if (fpdc.DialogResult == System.Windows.Forms.DialogResult.OK) { //获取弹出窗体的属性值 ugr.Cells["ASK_MONTH_NO"].Value = fpdc.AskMonth; ugr.Cells["WAGONS_PLAN_NO"].Value = fpdc.Wagons; ugr.Cells["VEHICLE_MONTH_NUM"].Value = fpdc.VelMonth; ugr.Cells["BATCH_MONTH_NUM"].Value = fpdc.BathMonth; ugr.Cells["WAGONS_FLAG"].Value = fpdc.Wagflag; ugr.Cells["ACT_MONTH_NUM"].Value = fpdc.ActMonthNum; ugr.Cells["ASK_MONTH_PK"].Value = fpdc.AskDayNoPk; } } /// /// Grid列内容改变事件 /// /// /// private void ultraGridBillM_CellChange(object sender, CellEventArgs e) { if (e.Cell.Column.Key.Equals("VEHICLE_DAY_NUM")) { if (e.Cell.Row.Cells["BATCH_MONTH_NUM"].Text.Equals("")) { MessageUtil.ShowTips("月批复数不能为空!"); e.Cell.Row.Cells["VEHICLE_DAY_NUM"].Value = "0"; return; } } } /// /// 初始化隐藏按钮 /// /// /// private void frmShipmentDayApp_Shown(object sender, EventArgs e) { if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("App")) { toolMenu.Toolbars[0].Tools["App"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DeleteApp")) { toolMenu.Toolbars[0].Tools["DeleteApp"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.False; } } /// /// 切换Tab隐藏按钮 /// /// /// private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (toolMenu == null) return; if (e.Tab.TabControl.SelectedTab.Key.Equals("0")) { if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("App")) { toolMenu.Toolbars[0].Tools["App"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("DeleteApp")) { toolMenu.Toolbars[0].Tools["DeleteApp"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.False; } } else { if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Update")) { toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("App")) { toolMenu.Toolbars[0].Tools["App"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("DeleteApp")) { toolMenu.Toolbars[0].Tools["DeleteApp"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.True; } } } /// /// 按回车键触发查询按钮 /// /// /// private void ContPublic_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { doQuery(); } } } }