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