private void tscSelect_Click(object sender, EventArgs e) { _arkCode = teShipmentNo.Text.Trim(); _status = cbeStatus.Text.Trim(); _palletNo = tePalletNo.Text.Trim(); GroupArkEntity queryEntity = new GroupArkEntity(); DataSet dsReturn = queryEntity.QueryInf(_arkCode, _status, _palletNo); DataTable dt = new DataTable(); dt = dsReturn.Tables[0]; if (dt.Rows.Count > 0) { if (!dt.Columns.Contains("ROWNUMBER")) { dt.Columns.Add("ROWNUMBER"); } for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["ROWNUMBER"] = i + 1; } gcList.DataSource = dt; } else { gcList.DataSource = null; } }
private void cbeArkCode_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == 13) { gcArk.DataSource = null; GroupArkEntity arkEntity = new GroupArkEntity(); DataSet ds = arkEntity.GetArkNumber(cbeArkCode.Text.Trim()); if (ds.Tables[0].Rows.Count > 1) { MessageService.ShowMessage("柜号存在重复或不存在请重新输入", "${res:Global.SystemInfo}"); return; } if (ds.Tables[0].Rows.Count == 1) { //查询明细表中柜主键为同一个且托状态为可用的托号 DataSet dsCdetail = arkEntity.GetContainerDetailInf(ds.Tables[0].Rows[0]["CONTAINER_KEY"].ToString().Trim()); if (dsCdetail != null) { //根据查询出来的托号,在包装表中查询托对应的详细信息 DataSet dsWipCInf = arkEntity.GetWipConInf(dsCdetail); DataTable dt01 = new DataTable(); dt01 = dsWipCInf.Tables[0]; for (int i = 0; i < dt01.Rows.Count; i++) { DataRow dr = dt01.Rows[i]; string grade = Convert.ToString(dr[WIP_CONSIGNMENT_FIELDS.FIELDS_GRADE]); dr[WIP_CONSIGNMENT_FIELDS.FIELDS_GRADE] = GetProductGradeDisplayText(grade); } if (gvArk.DataSource == null) { if (dt01 != null) { if (!dt01.Columns.Contains("ROWNUMBER")) { dt01.Columns.Add("ROWNUMBER"); } for (int i = 0; i < dt01.Rows.Count; i++) { dt01.Rows[i]["ROWNUMBER"] = i + 1; } gcArk.DataSource = dt01; } else { gcArk.DataSource = null; } } } cbeArkCode.Enabled = false; } else if (ds.Tables[0].Rows.Count < 1) { gcArk.DataSource = null; cbeArkCode.Enabled = false; } } }
private void tsbAllSplit_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(cbeArkCode.Text.ToString().Trim())) { MessageService.ShowMessage("请输入柜号。", "${res:Global.SystemInfo}"); return; } _ArkCode = cbeArkCode.Text.ToString().Trim(); //获取对应柜号主键,然后修改明细表信息,保存界面托信息,修改包装表中状态为已组柜 GroupArkEntity arkEntity = new GroupArkEntity(); DataSet ds = arkEntity.GetArkNumber(_ArkCode); SplitArkEntity splitEntity = new SplitArkEntity(); if (ds.Tables[0].Rows.Count < 1) { MessageService.ShowMessage("该柜未组柜不可拆柜。", "${res:Global.SystemInfo}"); return; } //查询明细表中柜主键为同一个且托状态为可用的托号 DataSet dsCdetail = arkEntity.GetContainerDetailInf(ds.Tables[0].Rows[0]["CONTAINER_KEY"].ToString().Trim()); DataTable dtCdetail = dsCdetail.Tables[0]; if (dtCdetail.Rows.Count < 1) { MessageService.ShowMessage("该柜不存在可拆托信息。", "${res:Global.SystemInfo}"); return; } if (MessageService.AskQuestion("你确定要整柜拆除么?", "整柜拆柜")) { if (ds != null) { if (ds.Tables[0].Rows.Count > 1) { MessageService.ShowMessage("柜号存在重复或不存在请重新输入", "${res:Global.SystemInfo}"); return; } if (ds.Tables[0].Rows.Count == 1) { bool bo = splitEntity.SplitArk(ds); if (bo) { MessageService.ShowMessage("整柜拆柜成功", "${res:Global.SystemInfo}"); BindArkCode(); gcArk.DataSource = null; } } } } }
//方法定义 public void BindArkCode() { cbeArkCode.Properties.Items.Clear(); GroupArkEntity arkEntity = new GroupArkEntity(); DataSet ds = arkEntity.GetArkNumber(""); if (ds != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { cbeArkCode.Properties.Items.Add(ds.Tables[0].Rows[i]["CONTAINER_CODE"]); } } }
private void tscSelect_Click(object sender, EventArgs e) { _teEntryNo = teEntryNo.Text.Trim(); _lciStatus = txtArkCode.Text.Trim(); GroupArkEntity queryEntity = new GroupArkEntity(); DataSet dsReturn = queryEntity.QueryInfHaveArked(_teEntryNo, _lciStatus); DataTable dt = new DataTable(); dt = dsReturn.Tables["AWMS_WH_ENTRY"]; if (dt.Rows.Count > 0) { //if (!dt.Columns.Contains("ROWNUMBER")) // dt.Columns.Add("ROWNUMBER"); //for (int i = 0; i < dt.Rows.Count; i++) //{ // dt.Rows[i]["ROWNUMBER"] = i + 1; //} gcList.DataSource = dt; gcList.MainView = gvList; } }
private void gvList_MasterRowGetChildList(object sender, DevExpress.XtraGrid.Views.Grid.MasterRowGetChildListEventArgs e) { DataRow dr = this.gvList.GetDataRow(e.RowHandle); string Key = Convert.ToString(dr["ZMBLNR"]); GroupArkEntity queryEntity = new GroupArkEntity(); DataSet dsReturn = queryEntity.QueryInfHaveArked(Key, _lciStatus); DataTable dt = new DataTable(); dt = dsReturn.Tables["ARK_PALLET"]; if (dt.Rows.Count > 0) { //if (!dt.Columns.Contains("ROWNUMBER")) // dt.Columns.Add("ROWNUMBER"); //for (int i = 0; i < dt.Rows.Count; i++) //{ // dt.Rows[i]["ROWNUMBER"] = i + 1; //} e.ChildList = dt.DefaultView; } }
private void tsbSave_Click(object sender, EventArgs e) { _ArkCode = cbeArkCode.Text.Trim(); if (string.IsNullOrEmpty(cbeArkCode.Text.ToString().Trim())) { MessageService.ShowMessage("柜号不能为空。", "${res:Global.SystemInfo}"); return; } //获取对应柜号主键,然后修改明细表信息,保存界面托信息,修改包装表中状态为已组柜 GroupArkEntity arkEntity = new GroupArkEntity(); DataSet ds = arkEntity.GetArkNumber(_ArkCode); if (ds.Tables[0].Rows.Count < 1) { MessageService.ShowMessage("该柜未组柜不可拆柜。", "${res:Global.SystemInfo}"); return; } if (MessageService.AskQuestion("你确定要保存吗?", "拆柜")) { int flag = 0; DataTable dt = new DataTable(); //获取界面数据表信息 if (gvArk.DataSource != null) { dt = ((DataView)gvArk.DataSource).Table.GetChanges(DataRowState.Modified); } else { dt = null; } //查询明细表中柜主键为同一个且托状态为可用的托号 DataSet dsCdetail = arkEntity.GetContainerDetailInf(ds.Tables[0].Rows[0]["CONTAINER_KEY"].ToString().Trim()); DataTable dtCdetail = dsCdetail.Tables[0]; dtCdetail.TableName = "DETAILPALLNO"; if (dtCdetail == null) { MessageService.ShowMessage("该柜不存在可拆托信息。", "${res:Global.SystemInfo}"); return; } DataSet dsIn = new DataSet(); dsIn.Merge(dtCdetail); Hashtable hashTable = new Hashtable(); hashTable.Add("CREATOR", PropertyService.Get(PROPERTY_FIELDS.USER_NAME)); hashTable.Add("CONTAINER_CODE", _ArkCode); DataTable tableParam = SolarViewer.Hemera.Share.Common.CommonUtils.ParseToDataTable(hashTable); tableParam.TableName = "HASH"; dsIn.Merge(tableParam); DataTable dtArkKey = ds.Tables[0]; dtArkKey.TableName = "ARKKEY"; dsIn.Merge(dtArkKey); bool bo = arkEntity.UpdateArkInf(dsIn, dt, flag); if (bo) { MessageService.ShowMessage("保存成功。", "${res:Global.SystemInfo}"); BindArkCode(); gcArk.DataSource = null; //清空datasource } else { MessageService.ShowMessage("保存失败。", "${res:Global.SystemInfo}"); } } }
public void SelectInf() { _ArkCode = cbeArkCode.Text.ToString().Trim(); if (string.IsNullOrEmpty(_ArkCode)) { MessageService.ShowMessage("请输入柜号。", "${res:Global.SystemInfo}"); return; } gcArk.DataSource = null; GroupArkEntity arkEntity = new GroupArkEntity(); DataSet ds = arkEntity.GetArkNumber(_ArkCode); if (ds.Tables[0].Rows.Count > 1) { MessageService.ShowMessage("柜号存在重复或不存在请重新输入", "${res:Global.SystemInfo}"); return; } if (ds.Tables[0].Rows.Count == 1) { //查询明细表中柜主键为同一个且托状态为可用的托号 DataSet dsCdetail = arkEntity.GetContainerDetailInf(ds.Tables[0].Rows[0]["CONTAINER_KEY"].ToString().Trim()); if (dsCdetail.Tables[0] != null) { //根据查询出来的托号,在包装表中查询托对应的详细信息 DataSet dsWipCInf = arkEntity.GetWipConInf(dsCdetail); DataTable dt01 = new DataTable(); dt01 = dsWipCInf.Tables[0]; for (int i = 0; i < dt01.Rows.Count; i++) { DataRow dr = dt01.Rows[i]; string grade = Convert.ToString(dr[WIP_CONSIGNMENT_FIELDS.FIELDS_GRADE]); dr[WIP_CONSIGNMENT_FIELDS.FIELDS_GRADE] = GetProductGradeDisplayText(grade); } if (gvArk.DataSource == null) { if (dt01 != null) { if (!dt01.Columns.Contains("ROWNUMBER")) { dt01.Columns.Add("ROWNUMBER"); } for (int i = 0; i < dt01.Rows.Count; i++) { dt01.Rows[i]["ROWNUMBER"] = i + 1; } gcArk.DataSource = dt01; } else { gcArk.DataSource = null; } } } else { MessageService.ShowMessage("柜号中不存在托信息,请重新选择柜信息。", "${res:Global.SystemInfo}"); return; } } else { MessageService.ShowMessage("不存在柜信息。", "${res:Global.SystemInfo}"); return; } }
//方法定义 public void GetPalletInf() { GroupArkEntity gae = new GroupArkEntity(); string strPalletNo = txtPalletNo.Text.Trim(); //判定是否输入信息为空 if (string.IsNullOrEmpty(txtPalletNo.Text.ToString())) { MessageService.ShowMessage("请输入托号!", "${res:Global.SystemInfo}"); return; } //判断输入的托号是否重复? DataView dv = gvArk.DataSource as DataView; if (dv != null) { int length = dv.Table.Select("PALLET_NO='" + strPalletNo + "'").Length; if (length > 0) { MessageService.ShowMessage("列表中已存在托号为[" + strPalletNo + "]的信息,不能重复添加。", "${res:Global.SystemInfo}"); return; } } //判定托是否存在 DataTable dt = gae.GetPalletInf(strPalletNo).Tables[0]; if (dt.Rows.Count > 0) { //判定输入托号是否已经入库根据托状态信息栏判定 if (dt.Rows[0]["CS_DATA_GROUP"].ToString().Trim() == "3") { if (dt.Rows[0]["ARK_FLAG"].ToString().Trim() == "0") { DataTable dt01 = new DataTable(); dt01 = dt; for (int i = 0; i < dt01.Rows.Count; i++) { DataRow dr = dt01.Rows[i]; string grade = Convert.ToString(dr[WIP_CONSIGNMENT_FIELDS.FIELDS_GRADE]); dr[WIP_CONSIGNMENT_FIELDS.FIELDS_GRADE] = GetProductGradeDisplayText(grade); } if (gvArk.DataSource == null) { dt01 = dt; if (!dt01.Columns.Contains("ROWNUMBER")) { dt01.Columns.Add("ROWNUMBER"); } dt01.Rows[0]["ROWNUMBER"] = 1; gcArk.DataSource = dt01; } else if (gvArk.DataSource != null) { dt01 = ((DataView)gvArk.DataSource).Table; dt01.ImportRow(dt.Rows[0]); if (!dt01.Columns.Contains("ROWNUMBER")) { dt01.Columns.Add("ROWNUMBER"); } for (int i = 1; i < dt01.Rows.Count + 1; i++) { dt01.Rows[i - 1]["ROWNUMBER"] = i.ToString(); } gcArk.DataSource = dt01; } else { gcArk.DataSource = dt; } txtPalletNo.Text = ""; } else { MessageService.ShowMessage("托号[" + strPalletNo + "]已经组柜,不能添加。", "${res:Global.SystemInfo}"); } } else { MessageService.ShowMessage("托号[" + strPalletNo + "]未入库或已出库,不能添加。", "${res:Global.SystemInfo}"); return; } } else { MessageService.ShowMessage("没有[" + strPalletNo + "]的托号,请重新输入。", "${res:Global.SystemInfo}"); return; } }