private void butSave_Click(object sender, System.EventArgs e)
{
if (this.textBox2.Text.Trim().Length == 0)
{
baseForm.CreateMessageBox(Public_MessageBox.Warning, System.Windows.Forms.MessageBoxButtons.OK, "警告信息", "请先输入箱号");
return;
}
int cartonNo = int.Parse(textBox2.Text);
////201306 George --Begin
if (cartonDt.Rows.Count <= 0)
{
// baseForm.CreateMessageBox(Public_MessageBox.Warning , MessageBoxButtons.OK, null, "没有输入数据");
// return ;
DialogResult result = baseForm.CreateMessageBox(Public_MessageBox.Question,
MessageBoxButtons.YesNo,
null, "没有输入数据,你是否要装空箱?");
if (result == DialogResult.Yes)
{ //空箱装，但要输入密码验证
frmLineCheck frm = new frmLineCheck();
DialogResult res = frm.ShowDialog();
if (res == System.Windows.Forms.DialogResult.Cancel)
{
return;
}
else
{
////装空箱
if (saveCarton(cartonNo + ""))
{
this.txtOpened.Text = (int.Parse(txtOpened.Text) + 1) + "";
baseForm.CreateMessageBox(Public_MessageBox.Error, MessageBoxButtons.OK,
null, "保存成功！");
return;
}
else
{
return;
}
}
}
else
{ //空箱不装，返回
return;
}
}
////201306 George --End
String checkresult = "";
#region check with original info
wsPAD.IwsPADClient client = new wsPAD.IwsPADClient();
try
{
#region 构造当前箱
DataTable curentCarton = (from p in boxDt.AsEnumerable()
where p.Field<string>("cartonNumber") == cartonNo.ToString()
select p).CopyToDataTable();
curentCarton.TableName = "curentCarton";
curentCarton.Columns.Add(new DataColumn("poid", typeof(System.String)));
curentCarton.Columns.Add(new DataColumn("customerid", typeof(System.String)));
foreach (DataRow item in curentCarton.Rows)
{
item["poid"] = poID;
item["customerid"] = customerid;
}
#endregion
//check 条件
checkresult = client.PackBoxCheckGroup(curentCarton);
if (checkresult == "OK")
{
List<string> status = (from p in cartonDt.AsEnumerable()
where p.Field<string>("cartonNumber") == cartonNo.ToString()
select p.Field<string>("valid")).ToList<string>();
if (status[0] == "否")
{
#region 不满箱
string[] butText = { "直接封箱", "暂时保存" };
DialogResult result = baseForm.CreateMessageBox(Public_MessageBox.Question,
MessageBoxButtons.YesNo,
null, "本箱不满箱，是否要封箱?", butText);
if (result == DialogResult.No)
{
this.saveTempInfo(curentCarton);
#region 修改为已经保存
for (int i = 0; i < cartonDt.Rows.Count; i++)
{
if (cartonDt.Rows[i]["cartonNumber"].ToString() == textBox2.Text)
{
cartonDt.Rows[i]["status"] = "已保存(暂存线上)";
break;
}
}
#endregion
}
else
{
////201307 George --Begin
// frmLineCheck frm = new frmLineCheck();
// DialogResult res = frm.ShowDialog();
// if (res == System.Windows.Forms.DialogResult.Cancel)
// {
// return;
// }
////201307 George --End
saveCarton(curentCarton);
#region 修改为已经保存
for (int i = 0; i < cartonDt.Rows.Count; i++)
{
if (cartonDt.Rows[i]["cartonNumber"].ToString() == textBox2.Text)
{
cartonDt.Rows[i]["status"] = "已保存";
break;
}
}
////201306 George --begin
this.txtOpened.Text = (int.Parse(txtOpened.Text) + 1) + "";
////201306 George --end
}
#endregion
#endregion
}
else
{
#region 满箱
saveCarton(curentCarton);
#region 修改为已经保存
for (int i = 0; i < cartonDt.Rows.Count; i++)
{
if (cartonDt.Rows[i]["cartonNumber"].ToString() == textBox2.Text)
{
cartonDt.Rows[i]["status"] = "已保存";
break;
}
}
////201306 George --begin
this.txtOpened.Text = (int.Parse(txtOpened.Text) + 1) + "";
////201306 George --end
#endregion
}
#endregion
}
else
{
baseForm.CreateMessageBox(Public_MessageBox.Error,
MessageBoxButtons.OK,
null, checkresult);
}
}
catch (Exception ex)
{
MESMsgBox.ShowError(ExceptionParser.Parse(ex));
}
finally
{
baseForm.ResetCursor();
baseForm.CloseWCF(client);
}
#endregion
}
private void butSaveRow_Click(object sender, EventArgs e)
{
if (textBox2.Text.Length == 0 || textType.Text.Length == 0 || textSize.Text.Length == 0 || textPairQty.Text.Length == 0 || textColor.Text.Length == 0)
{
baseForm.CreateMessageBox(Public_MessageBox.Error, System.Windows.Forms.MessageBoxButtons.OK, "输入错误", "款号，颜色，尺码，数量必须输入");
}
try
{
#region create table if it's null
if (cartonDt == null)
{
cartonDt = new DataTable("carton");
cartonDt.TableName = "carton";
cartonDt.Columns.Add(new DataColumn("cartonNumber", typeof(System.String)));
cartonDt.Columns.Add(new DataColumn("qty", typeof(System.Int32)));
cartonDt.Columns.Add(new DataColumn("qty2", typeof(System.Int32)));
cartonDt.Columns.Add(new DataColumn("valid", typeof(System.Int32)));
cartonDt.Columns.Add(new DataColumn("status", typeof(System.String)));
}
if (boxDt == null)
{
boxDt = new DataTable("box");
boxDt.TableName = "box";
boxDt.Columns.Add(new DataColumn("cartonNumber", typeof(System.String)));
boxDt.Columns.Add(new DataColumn("type", typeof(System.String)));
boxDt.Columns.Add(new DataColumn("color", typeof(System.String)));
boxDt.Columns.Add(new DataColumn("size", typeof(System.String)));
boxDt.Columns.Add(new DataColumn("qty", typeof(System.Int32)));
boxDt.Columns.Add(new DataColumn("qty2", typeof(System.Int32)));
}
#endregion
#region check befor save
#region 构造当前箱
DataTable checkCarton = new DataTable("box");
checkCarton.TableName = "box";
checkCarton.Columns.Add(new DataColumn("cartonNumber", typeof(System.String)));
checkCarton.Columns.Add(new DataColumn("type", typeof(System.String)));
checkCarton.Columns.Add(new DataColumn("color", typeof(System.String)));
checkCarton.Columns.Add(new DataColumn("size", typeof(System.String)));
checkCarton.Columns.Add(new DataColumn("qty", typeof(System.Int32)));
checkCarton.Columns.Add(new DataColumn("qty2", typeof(System.Int32)));
checkCarton.Columns.Add(new DataColumn("poid", typeof(System.String)));
checkCarton.Columns.Add(new DataColumn("customerid", typeof(System.String)));
DataRow dr3 = checkCarton.NewRow();
dr3["cartonNumber"] = textBox2.Text;
dr3["type"] = textType.Text;
dr3["color"] = textColor.Text;
dr3["size"] = textSize.Text;
dr3["qty"] = int.Parse(textPairQty.Text); ;
dr3["qty2"] = int.Parse(textPairQty.Text);
dr3["poid"] = poID;
dr3["customerid"] = customerid;
checkCarton.Rows.Add(dr3);
#endregion
wsPAD.IwsPADClient client = new wsPAD.IwsPADClient();
try
{
//check 条件
string checkresult = client.PackBoxCheckGroup(checkCarton);
if (checkresult != "OK")
{
//检查条件不通过
baseForm.CreateMessageBox(Public_MessageBox.Error,
MessageBoxButtons.OK,
null, checkresult);
return;
}
}
catch (Exception ex)
{
MESMsgBox.ShowError(ExceptionParser.Parse(ex));
}
finally
{
baseForm.ResetCursor();
baseForm.CloseWCF(client);
}
#endregion
#region 获得开箱信息
int openQtyGroup = 0;
int openQtyBox = 0;
string cartonNumber = textBox2.Text;
DataSet rs = getOpenDetail(cartonNumber);
if (rs != null)
{
var resultGroup1 = (from p in rs.Tables[0].AsEnumerable()
where p.Field<string>("styleno") == textType.Text
&& p.Field<string>("color") == textColor.Text
&& p.Field<string>("size") == textSize.Text
select p).ToList();
if (resultGroup1.Count != 0)
{
DataRow currentGroup = resultGroup1[0];
openQtyGroup = int.Parse(currentGroup["pairqty"].ToString());
}
var openQtyOfCarton = (from p in rs.Tables[0].AsEnumerable()
// where p.Field<string>("styleno") == textType.Text
// && p.Field<string>("color") == textColor.Text
// && p.Field<string>("size") == textSize.Text
select p.Field<Decimal>("pairqty")).Sum();
if (openQtyOfCarton != 0)
{
openQtyBox = (int)openQtyOfCarton;
}
}
#endregion
#region 封箱与开箱数量不符
if (openQtyBox == 0) //没有开箱
{
baseForm.CreateMessageBox(Public_MessageBox.Error, System.Windows.Forms.MessageBoxButtons.OK,
"提示信息", "没有开箱数据 ");
return;
}
else
{
//已经开箱，但与开箱数量不符
if (openQtyGroup != int.Parse(textPairQty.Text))
{
DialogResult resultDlg = baseForm.CreateMessageBox(Public_MessageBox.Question, System.Windows.Forms.MessageBoxButtons.YesNo, "提示信息", "输入的数据与开箱数据不一致，是否继续？");
if (resultDlg == DialogResult.No)
{
return; //放弃本次输入
} ////201306 George --begin
else
{
frmLineCheck frm = new frmLineCheck();
DialogResult res = frm.ShowDialog();
if (res == System.Windows.Forms.DialogResult.Cancel)
{
return;
}
}
////201306 George --end
}
}
#endregion
#region WIP 不够Move
int wip = getWIPQty(textType.Text, textColor.Text, textSize.Text);
if (wip < int.Parse(textPairQty.Text))
{
baseForm.CreateMessageBox(Public_MessageBox.Error, System.Windows.Forms.MessageBoxButtons.OK,
"提示信息", "线上没有这么多制品，你输入的数量不对");
return;
}
#endregion
#region if carton don't exists, insert it
var result = (from p in cartonDt.AsEnumerable()
where p.Field<string>("cartonNumber") == textBox2.Text
select p).ToList();
if (result == null || result.Count == 0)
{
//put data to new table
DataRow dr = cartonDt.NewRow();
dr["cartonNumber"] = textBox2.Text;
dr["qty"] = openQtyBox;
dr["qty2"] = 0;
dr["valid"] = "";
dr["status"] = "未保存";
cartonDt.Rows.Add(dr);
}
else
{
//如已经保存到数据库，不可以再修改//////////
string status = result[0]["status"].ToString();
if (status == "已保存")
{
baseForm.CreateMessageBox(Public_MessageBox.Warning, MessageBoxButtons.OK, "警告信息", "已经保存到数据库，不可以修改！");
return;
}
////////////////////////////////////////////
}
#endregion
#region if group exists, update qty, else insert
var resultGroup = (from p in boxDt.AsEnumerable()
where p.Field<string>("cartonNumber") == textBox2.Text
&& p.Field<string>("type") == textType.Text
&& p.Field<string>("color") == textColor.Text
&& p.Field<string>("size") == textSize.Text
select p);
if (resultGroup.ToList().Count > 0)
{
foreach (DataRow item in resultGroup)
{
item["qty2"] = int.Parse(textPairQty.Text);
}
}
else
{
DataRow dr2 = boxDt.NewRow();
dr2["cartonNumber"] = textBox2.Text;
dr2["type"] = textType.Text;
dr2["color"] = textColor.Text;
dr2["size"] = textSize.Text;
dr2["qty"] = openQtyGroup;
dr2["qty2"] = int.Parse(textPairQty.Text);
boxDt.Rows.Add(dr2);
}
#endregion
#region update shoes qty of this carton
var curentCarton = (from p in cartonDt.AsEnumerable()
where p.Field<string>("cartonNumber") == textBox2.Text
select p).ToList();
var qtyOfCarton = (from p in boxDt.AsEnumerable()
where p.Field<string>("cartonNumber") == textBox2.Text
select p.Field<Int32>("qty2")).Sum();
DataRow currentCarton = curentCarton[0];
currentCarton["qty2"] = qtyOfCarton;
currentCarton["status"] = "未保存";
if (qtyOfCarton == openQtyBox)
{
currentCarton["valid"] = "是";
}
else
{
currentCarton["valid"] = "否";
}
#endregion
#region bind data
try
{
this.ultraGrid1.SetDataBinding(ds, "");
}
catch (Exception ex)
{
;// MicroMESMsgBox.ShowError(ExceptionParser.Parse(ex));
}
#endregion
#region 展开当前箱，闭合其他箱
foreach (UltraGridRow row in this.ultraGrid1.Rows)
{
if (null != row.ChildBands)
{
string carton1 = row.GetCellValue("cartonNumber").ToString();
if (carton1 == textBox2.Text)
{
row.Activate();
row.ExpandAll();
}
else
{
row.CollapseAll();
}
}
}
#endregion
System.Windows.Forms.ToolTip toolTip2 = new System.Windows.Forms.ToolTip();
toolTip2.IsBalloon = true;
toolTip2.UseAnimation = true;
toolTip2.UseFading = true;
toolTip2.ToolTipIcon = System.Windows.Forms.ToolTipIcon.Info;
toolTip2.SetToolTip(butSave, "如果是本箱数据已经输入完成，请单击这里保存");
toolTip2.Show("如果是本箱数据已经输入完成，请单击这里保存", butSave, 1000);
toolTip.SetToolTip(panelType, "如果本箱还没完成，请继续选择款号");
toolTip.Show("如果本箱还没完成，请继续选择款号", panelType, 2000);
}
catch (Exception ex)
{
return;
}
finally
{
;
}
}