/// <summary>
/// 获取該掃描明細的訊息
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.doc_PackListScan> GetPackListScan(string cartonbarcode)
{
string sql = @"
select *
from doc_PackListScan
where CartonBarcode=@CartonBarcode order by ScanNO
";
SqlParameter[] ps =
{
new SqlParameter("@CartonBarcode", cartonbarcode)
};
DataTable dt = SqlHelper.ExcuteTable(sql, ps);
List <MODEL.doc_PackListScan> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.doc_PackListScan>();
foreach (DataRow row in dt.Rows)
{
MODEL.doc_PackListScan c = new MODEL.doc_PackListScan();
LoadDataToList(row, c);
lists.Add(c);
}
}
return(lists);
}
/// </summary>
/// <param>"order"></param>
/// <returns></returns>
public int AddPackList(MODEL.doc_PackListScan packlist)
{
string sql = @"
insert into doc_PackListScan(Guid,CartonBarcode,InnerBarcode,ScanTime,SizeName,CustomStyleCode,OrderDate,ScanCount,ScanNO,ScanOut,Part)
values(@Guid,@CartonBarcode,@InnerBarcode,@ScanTime,@SizeName,@CustomStyleCode,@OrderDate,@ScanCount,@ScanNO,@ScanOut,@Part)";
SqlParameter[] ps =
{
new SqlParameter("@Guid", SqlDbType.UniqueIdentifier)
{
Value = SqlHelper.ToDbValue(packlist.Guid)
},
new SqlParameter("@CartonBarcode", SqlDbType.NVarChar)
{
Value = SqlHelper.ToDbValue(packlist.CartonBarcode)
},
new SqlParameter("@InnerBarcode", SqlDbType.NVarChar)
{
Value = SqlHelper.ToDbValue(packlist.InnerBarcode)
},
new SqlParameter("@ScanTime", SqlDbType.DateTime)
{
Value = SqlHelper.ToDbValue(packlist.ScanTime)
},
new SqlParameter("@SizeName", SqlDbType.NVarChar)
{
Value = SqlHelper.ToDbValue(packlist.SizeName)
},
new SqlParameter("@CustomStyleCode", SqlDbType.NVarChar)
{
Value = SqlHelper.ToDbValue(packlist.CustomStyleCode)
},
new SqlParameter("@OrderDate", SqlDbType.NVarChar)
{
Value = SqlHelper.ToDbValue(packlist.OrderDate)
},
new SqlParameter("@ScanCount", SqlDbType.Int)
{
Value = SqlHelper.ToDbValue(packlist.ScanCount)
},
new SqlParameter("@ScanNO", SqlDbType.Int)
{
Value = SqlHelper.ToDbValue(packlist.ScanNO)
},
new SqlParameter("@ScanOut", SqlDbType.Int)
{
Value = SqlHelper.ToDbValue(packlist.ScanOut)
},
new SqlParameter("@Part", SqlDbType.NVarChar)
{
Value = SqlHelper.ToDbValue(packlist.Part)
}
};
return(SqlHelper.ExecuteNonQuery(sql, ps));
}
/// <summary>
/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList1(DataRow dr, MODEL.doc_PackListScan pscan)
{
pscan.CartonBarcode = (string)SqlHelper.FromDbValue(dr["CartonBarcode"]);
pscan.InnerBarcode = (string)SqlHelper.FromDbValue(dr["InnerBarcode"]);
pscan.CustomStyleCode = (string)SqlHelper.FromDbValue(dr["CustomStyleCode"]);
pscan.SizeName = (string)SqlHelper.FromDbValue(dr["SizeName"]);
pscan.ScanTime = (DateTime)SqlHelper.FromDbValue(dr["ScanTime"]);
pscan.OrderDate = (string)SqlHelper.FromDbValue(dr["OrderDate"]);
pscan.ScanCount = (int)SqlHelper.FromDbValue(dr["ScanCount"]);
pscan.ScanNO = (int)SqlHelper.FromDbValue(dr["ScanNO"]);
pscan.Part = (string)SqlHelper.FromDbValue(dr["Part"]);
}
/// <summary>
/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList(DataRow dr, MODEL.doc_PackListScan pscan)
{
pscan.SizeName = (string)SqlHelper.FromDbValue(dr["SizeName"]);
pscan.ScanNO = (int)SqlHelper.FromDbValue(dr["ScanNO"]);
}
/// </summary>
/// <param>"order"></param>
/// <returns></returns>
public int AddPackList(MODEL.doc_PackListScan packlistscan)
{
return(plss.AddPackList(packlistscan));
}
private void scanInner(string scanno)
{
//dpllist = null;
MODEL.doc_PackListScan dpls = new MODEL.doc_PackListScan();
dpllist = dplm.GetInnerBarcode(scanno, lblCarton.Text);
// this.dgvBarcode.DataSource = dpllist;
if (dpllist != null)
{
if (lblNo.Text == "OK")
{
msgDiv.MsgDivShow(" 已經刷好了", 60);
return;
}
else
{
frm.BackColor = System.Drawing.Color.White;
dpls.Guid = Guid.NewGuid();
dpls.CartonBarcode = lblCarton.Text;
dpls.InnerBarcode = scanno;
dpls.ScanTime = DateTime.Now;
dpls.SizeName = dpllist[0].SizeName;
dpls.CustomStyleCode = dpllist[0].CustomStyleCode;
dpls.OrderDate = dpllist[0].OrderDate;
dpls.ScanCount = 1;
string hname = Dns.GetHostName(); //得到本机的主机名
dpls.Part = "QA" + "." + hname;
scannolist.Add(scanno);
// sizeCount 箱的size号码
int sizeCount = dplm.GetPackListSizeCount(dpls.CartonBarcode, dpls.InnerBarcode);
Dictionary <string, int> list = new Dictionary <string, int>();
for (int i = 0; i < scannolist.Count; i++)
{
if (list.ContainsKey(scannolist[i]))
{
list[scannolist[i]]++; //相同元素值加1 相同元素个数加1
}
else
{
list.Add(scannolist[i], 1);//加入不同元素 值不相等
}
}
int msscanno = 0;
for (int j = 0; j < list.Count; j++)
{
msscanno = list[scanno];
if (msscanno > sizeCount)
{
MessageBox.Show("該外箱的" + dpls.SizeName + "號數量已經刷滿");
return;
}
}
dpls.ScanOut = msscanno;
int lblnostr = 0;
if (lblNo.Text == "0" || lblNo.Text == "")
{
lblnostr = 0;
}
else
{
lblnostr = int.Parse(lblNo.Text);
}
int scancount = lblnostr + 1;
lblNo.Text = scancount.ToString();//
dpls.ScanNO = scancount;
// dplsm.AddPackList(dpls);
innerMark(scancount, dpllist[0].SizeName);
int mycount = (int)dpllist[0].BarcodeCount + 1; // 下一筆
int mtotal = dplm.GetPackListCartonCount(dpls.CartonBarcode);
if (mtotal == scancount)
{
lblNo.Text = "OK";
lblStyle.Text = "";
msgDiv.MsgDivShow("太棒了,刷条码成功", 60);
frm.BackColor = System.Drawing.Color.DarkGreen;
txtPwd.Enabled = false;
}
};
}
else
{
//該外箱沒有內盒的條碼,再判斷是否為別的外箱條碼.
if (dplm.IsCartonBarcodetExisits(scanno) >= 1)
{ //新外箱
if (lblNo.Text != "" && lblNo.Text != "0")
{
MessageBox.Show("请先刷完本箱、或按\"刷新箱重新刷\"按钮之后再换箱");
return;
}
else
{
scanCarton(scanno);
}
}
else
{
MessageBox.Show("非此外箱内盒", "错误了", MessageBoxButtons.OK, MessageBoxIcon.Error);
frm.BackColor = System.Drawing.Color.DarkRed;
txtPwd.Enabled = false;
}
}
}
