private void reprintBtn_Click(object sender, EventArgs e)
{
try
{
if (sijis != null)
{
if (sijis.Count > 0)
{
UpdateCriteria uc = new UpdateCriteria(typeof(FNLABELEntity));
foreach (FNSIJIEntity siji in sijis)
{
Condition c = uc.GetNewCondition();
c.AddEqualTo(FNLABELEntity.__LABEL_KEY, siji.LABEL_KEY);
}
uc.AddAttributeForUpdate(FNLABELEntity.__PRINTING_FLAG, "1");
uc.AddAttributeForUpdate(FNLABELEntity.__UPDATE_DATETIME, DateTime.Now.ToString("yyyyMMddHHmmss"));
uc.Perform();
MessageBox.Show("É趨³É¹¦");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static void SetChudan(string flag)
{
UpdateCriteria uc = new UpdateCriteria(typeof(FNSTATIONEntity));
Condition c = uc.GetNewCondition();
c.AddEqualTo(FNSTATIONEntity.__STNO, GlobalAccess.StationNo);
uc.AddAttributeForUpdate(FNSTATIONEntity.__CHUDANFLG, flag);
uc.Perform();
}
private void okBtn_Click(object sender, EventArgs e)
{
try
{
string stationNo = string.Empty;
if (GlobalAccess.StationNo == "1202")
{
stationNo = "1105";
}
else if (GlobalAccess.StationNo == "2209")
{
stationNo = "2104";
}
else if (GlobalAccess.StationNo == "2206")
{
stationNo = "2103";
}
else if (GlobalAccess.StationNo == "3202")
{
stationNo = "3101";
}
else if (GlobalAccess.StationNo == "3205")
{
stationNo = "3102";
}
else if (GlobalAccess.StationNo == "1212")
{
stationNo = "1106";
}
else if (GlobalAccess.StationNo == "1215")
{
stationNo = "1107";
}
else if (GlobalAccess.StationNo == "1218")
{
stationNo = "1108";
}
UpdateCriteria uc = new UpdateCriteria(typeof(FNHANSOEntity));
Condition c = uc.GetNewCondition();
c.AddEqualTo(FNHANSOEntity.__MOTOSTNO, stationNo);
c.AddEqualTo(FNHANSOEntity.__HJYOTAIFLG, "0");
uc.AddAttributeForUpdate(FNHANSOEntity.__HJYOTAIFLG, "1");
uc.Perform();
DbAccess.callAfterStockin(string.Empty);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static void UpdateFngset(string scheduleNo)
{
IDataParameter[] paras = new IDataParameter[3];
OleDbParameter para = (OleDbParameter)Query.GetParameter("ykk");
para.OleDbType = OleDbType.VarChar;
para.ParameterName = "@io_datetime";
para.Value = 0;
para.Size = 14;
para.Direction = ParameterDirection.InputOutput;
paras[0] = para;
para = (OleDbParameter)Query.GetParameter("ykk");
para.OleDbType = OleDbType.Integer;
para.ParameterName = "@io_return_code";
para.Value = 0;
para.Size = 9;
para.Direction = ParameterDirection.InputOutput;
paras[1] = para;
para = (OleDbParameter)Query.GetParameter("ykk");
para.OleDbType = OleDbType.VarChar;
para.ParameterName = "@io_return_message";
para.Value = string.Empty;
para.Size = 255;
para.Direction = ParameterDirection.InputOutput;
paras[2] = para;
Query.RunProcedure("get_system_datetime", paras, "ykk");
if (Int32.Parse(paras[1].Value.ToString()) != 0)
{
throw new Exception(paras[2].Value.ToString());
}
string datetime = paras[0].Value.ToString();
if (String.IsNullOrEmpty(scheduleNo))
{
return;
}
UpdateCriteria uc = new UpdateCriteria(typeof(FNGSETEntity));
Condition c = uc.GetNewCondition();
c.AddEqualTo(FNGSETEntity.__SCHNO, scheduleNo);
uc.AddAttributeForUpdate(FNGSETEntity.__SYORIFLG, "1");
uc.AddAttributeForUpdate(FNGSETEntity.__SAKUSEIHIJI, datetime);
uc.Perform();
}
private void Do()
{
Query q1 = new Query(typeof(FNCART_CTLEntity));
q1.AddAttribute(FNCART_CTLEntity.__STNO);
q1.AddAttribute(FNCART_CTLEntity.__SECTION);
q1.AddAttribute(FNCART_CTLEntity.__GROUPNO);
Condition c1 = q1.GetQueryCondition();
c1.AddEqualTo(FNCART_CTLEntity.__REGISTER_FLG, "1");
q1.GroupBy(FNCART_CTLEntity.__STNO);
q1.GroupBy(FNCART_CTLEntity.__GROUPNO);
q1.GroupBy(FNCART_CTLEntity.__SECTION);
Query q2 = new Query(typeof(FNRETRIEVAL_STEntity));
q2.AddAttribute(FNRETRIEVAL_STEntity.__RETRIEVAL_STATION);
q2.AddAttribute(FNRETRIEVAL_STEntity.__CART_TICKET_PRINTFLG);
q2.AddAttribute(FNRETRIEVAL_STEntity.__PRINTER_NO_CART);
q2.GroupBy(FNRETRIEVAL_STEntity.__RETRIEVAL_STATION);
q2.GroupBy(FNRETRIEVAL_STEntity.__PRINTER_NO_CART);
q2.GroupBy(FNRETRIEVAL_STEntity.__CART_TICKET_PRINTFLG);
q1.AddJoinQuery(FNCART_CTLEntity.__STNO, q2, FNRETRIEVAL_STEntity.__UNIT_STNO);
q1.OrderBy(FNCART_CTLEntity.__STNO);
q1.OrderBy(FNCART_CTLEntity.__GROUPNO);
DataTable dt = q1.Execute(); //sql1
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
string printflag = dr[FNRETRIEVAL_STEntity.__CART_TICKET_PRINTFLG].ToString();
decimal printNo = Convert.ToDecimal(dr[FNRETRIEVAL_STEntity.__PRINTER_NO_CART]);
string printName = GetPrintName(printNo);
string retrievalStation = dr[FNRETRIEVAL_STEntity.__RETRIEVAL_STATION].ToString();
string groupNo = dr[FNCART_CTLEntity.__GROUPNO].ToString();
string section = dr[FNCART_CTLEntity.__SECTION].ToString();
try
{
if (printflag == "1") //要打印
{
DataTable dt1 = GetData(section, groupNo);
if (dt1 != null && dt1.Rows.Count > 0)
{
if (retrievalStation == "24") //组立
{
AssemblyHead head = new AssemblyHead();
head.Section = section;
List <AssemblyDetail> details = new List <AssemblyDetail>();
for (int j = 0; j < dt1.Rows.Count; j++)
{
DataRow dr1 = dt1.Rows[j];
AssemblyDetail detail = new AssemblyDetail();
detail.BucketNo = dr1[FNCART_CTLEntity.__BUCKET_NO].ToString();
detail.ColorCode = dr1[FNCART_CTLEntity.__COLOR_CODE].ToString();
detail.ItemCode = dr1[FNCART_CTLEntity.__ITEM_CODE].ToString();
detail.ItemName = dr1[FMZKEYEntity.__ZKNAME1].ToString();
detail.Qty = dr1[FNCART_CTLEntity.__QTY].ToString();
detail.Weight = dr1[FNCART_CTLEntity.__WEIGHT].ToString();
details.Add(detail);
}
pc.DoPrint(printName, head, details);
}
else if (retrievalStation == "11" || retrievalStation == "21") //SI
{
SIHead head = new SIHead();
head.Section = section;
List <SIDetail> details = new List <SIDetail>();
for (int j = 0; j < dt1.Rows.Count; j++)
{
DataRow dr1 = dt1.Rows[j];
SIDetail detail = new SIDetail();
detail.BucketNo = dr1[FNCART_CTLEntity.__BUCKET_NO].ToString();
detail.Line = dr1[FNCART_CTLEntity.__LINE].ToString();
detail.ItemCode = dr1[FNCART_CTLEntity.__ITEM_CODE].ToString();
detail.ItemName = dr1[FMZKEYEntity.__ZKNAME1].ToString();
detail.Qty = dr1[FNCART_CTLEntity.__QTY].ToString();
detail.Weight = dr1[FNCART_CTLEntity.__WEIGHT].ToString();
details.Add(detail);
}
pc.DoPrint(printName, head, details);
}
}
}
}
catch (Exception ex)
{
WriteLog(ex.Message);
}
//update
UpdateCriteria uc = new UpdateCriteria(typeof(FNCART_CTLEntity));
Condition c = uc.GetNewCondition();
c.AddEqualTo(FNCART_CTLEntity.__SECTION, section);
c.AddEqualTo(FNCART_CTLEntity.__GROUPNO, groupNo);
c.AddEqualTo(FNCART_CTLEntity.__REGISTER_FLG, "1");
uc.AddAttributeForUpdate(FNCART_CTLEntity.__REGISTER_FLG, "3");
uc.Perform();
}
}
}
