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;
}
}
