/// <summary>
/// 拆包只针对已经完成的
/// </summary>
/// <param name="pcode"></param>
/// <returns></returns>
public TPCResult <List <CItem> > GetItemsByPCode(string pcode)
{
TPCResult <List <CItem> > result = new TPCResult <List <CItem> >();
string sql = "select name, pcode, ccode, p_date, status from vw_packing where pcode = @pcode "
+ "and status = 1 "
+ "order by ccode";
List <DbParameter> parameters = new List <DbParameter>();
parameters.Add(new DbParameter("@pcode", DbType.AnsiString, pcode));
TPCResult <DataTable> dt = Database.Query(sql, parameters);
if (dt.State == RESULT_STATE.NG)
{
result.State = RESULT_STATE.NG;
result.Message = dt.Message;
return(result);
}
result.Value = new List <CItem>();
foreach (DataRow row in dt.Value.Rows)
{
CItem item = new CItem();
item.Name = row["name"].ToString();
item.PCode = row["pcode"].ToString();
item.Code = row["ccode"].ToString();
item.Date = Convert.ToDateTime(row["p_date"]);
item.Status = Convert.ToInt32(row["status"]);
result.Value.Add(item);
}
return(result);
}
/// <summary>
/// 检索以装盘的carton信息
/// </summary>
/// <param name="pallet_no">pallet Code</param>
/// <returns></returns>
public TPCResult <List <CItem> > GetPalletedItems(string pallet_no)
{
TPCResult <List <CItem> > result = new TPCResult <List <CItem> >();
string sql = "select pallet_id, carton_id, p_date, status from pnt_pallet where pallet_id = @pallet_no and (status = 0 or status = 1) order by carton_id";
List <DbParameter> parameters = new List <DbParameter>();
parameters.Add(new DbParameter("@pallet_no", DbType.AnsiString, pallet_no));
TPCResult <DataTable> dt = Database.Query(sql, parameters);
if (dt.State == RESULT_STATE.NG)
{
result.State = RESULT_STATE.NG;
result.Message = dt.Message;
return(result);
}
result.Value = new List <CItem>();
foreach (DataRow row in dt.Value.Rows)
{
CItem item = new CItem();
item.PCode = row["pallet_id"].ToString();
item.Code = row["carton_id"].ToString();
item.Date = Convert.ToDateTime(row["p_date"]);
item.Status = Convert.ToInt32(row["status"]);
result.Value.Add(item);
}
return(result);
}
private void txtUnpackItemCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Return)
{
//获得扫描的编码
m_CCode = txtUnpackItemCode.Text;
txtUnpackItemCode.Text = "";
//从列表中找到对应的item，并将其设置为Canceled
foreach (ListViewItem it in lstUnpackItems.Items)
{
CItem item = it.Tag as CItem;
if (item != null && item.Code.Equals(m_CCode))
{
it.UseItemStyleForSubItems = false;
item.Status = (int)ITEM_STATUS.CANCELED;
it.SubItems[3].Text = "CANCELED";
it.SubItems[3].ForeColor = Color.Red;
it.SubItems[3].BackColor = Color.Yellow;
}
}
m_CCode = "";
}
}
