private DataTable GetData(string section, string groupNo) { Query q1 = new Query(typeof(FNCART_CTLEntity)); q1.AddAttribute(FNCART_CTLEntity.__BUCKET_NO); q1.AddAttribute(FNCART_CTLEntity.__LINE); q1.AddAttribute(FNCART_CTLEntity.__ITEM_CODE); q1.AddAttribute(FNCART_CTLEntity.__QTY); q1.AddAttribute(FNCART_CTLEntity.__WEIGHT); q1.AddAttribute(FNCART_CTLEntity.__COLOR_CODE); Condition c1 = q1.GetQueryCondition(); c1.AddEqualTo(FNCART_CTLEntity.__REGISTER_FLG, "1"); c1.AddEqualTo(FNCART_CTLEntity.__SECTION, section); c1.AddEqualTo(FNCART_CTLEntity.__GROUPNO, groupNo); Query q2 = new Query(typeof(FMZKEYEntity)); q2.AddAttribute(FMZKEYEntity.__ZAIKEY); q2.AddAttribute(FMZKEYEntity.__ZKNAME1); Condition c2 = q2.GetQueryCondition(); c2.AddEqualTo(FMZKEYEntity.__MANAGE_ITEM_FLAG, "0"); q1.AddJoinQuery(FNCART_CTLEntity.__ITEM_CODE, q2, FMZKEYEntity.__ZAIKEY); q1.OrderBy(FNCART_CTLEntity.__SEQ_NO); DataTable dt = q1.Execute(); return(dt); }
public bool GetSwitchState(string nick,string switchtype) { if (nick == null) { return false; } Query qUS = new Query(typeof(tb_User_SwitchEntity)); qUS.AddAttribute(tb_User_SwitchEntity.__STATE); Query qS = new Query(typeof(tb_AutoSwitchEntity)); Condition cS = qS.GetQueryCondition(); cS.AddEqualTo(tb_AutoSwitchEntity.__SWITCH, switchtype); Query qU = new Query(typeof(tb_UserEntity)); Condition cU = qU.GetQueryCondition(); cU.AddEqualTo(tb_UserEntity.__NICK, nick); qUS.AddJoinQuery(tb_User_SwitchEntity.__SWITCH_ID, qS, tb_AutoSwitchEntity.__ID); qUS.AddJoinQuery(tb_User_SwitchEntity.__USER_ID, qU, tb_UserEntity.__ID); object state = qUS.ExecuteScalar(); if (state == null) { return false; } return (bool)state; }
public string GetTraderContext(string nick) { if (nick == "") { return ""; } Query qU=new Query(typeof(tb_UserEntity)); Condition c=qU.GetQueryCondition(); c.AddEqualTo(tb_UserEntity.__NICK,nick); Query qT=new Query(typeof(tb_TraderateContextEntity)); qT.AddAttribute(tb_TraderateContextEntity.__CONTEXT); qT.AddJoinQuery(tb_TraderateContextEntity.__USER_ID,qU,tb_UserEntity.__ID); object o = qT.ExecuteScalar(); if (o != null) { return o.ToString(); } else { return ""; } }
public DataTable GetContext(string nick) { DataTable dt = new DataTable(); if (nick == "") { return dt; } Query qU = new Query(typeof(tb_UserEntity)); Condition cU = qU.GetQueryCondition(); cU.AddEqualTo(tb_UserEntity.__NICK,nick); Query qT = new Query(typeof(tb_TraderateContextEntity)); qT.AddAttribute(AttributeType.All); qT.AddJoinQuery(tb_TraderateContextEntity.__USER_ID, qU, tb_UserEntity.__ID); dt=qT.Execute(); return dt; }
public bool GetSwitchPropertyState(string nick, string switchpro) { Query qUS = new Query(typeof(tb_User_SwitchPropertyEntity)); qUS.AddAttribute(tb_User_SwitchPropertyEntity.__STATE); Query qS = new Query(typeof(tb_SwitchPropertyEntity)); Condition cS = qS.GetQueryCondition(); cS.AddEqualTo(tb_SwitchPropertyEntity.__PRONAME, switchpro); Query qU = new Query(typeof(tb_UserEntity)); Condition cU = qU.GetQueryCondition(); cU.AddEqualTo(tb_UserEntity.__NICK, nick); qUS.AddJoinQuery(tb_User_SwitchPropertyEntity.__SWITCHPROERTY_ID, qS, tb_SwitchPropertyEntity.__ID); qUS.AddJoinQuery(tb_User_SwitchPropertyEntity.__USER_ID,qU,tb_UserEntity.__ID); object state = qUS.ExecuteScalar(); if (state == null) { return false; } return (bool)state; }
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(); } } }