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