public static void WholeUpdateSoState(int soId, int userid, SoStatesEnum state) { List <string> strSqls = new List <string>(); if (state == SoStatesEnum.Approved) { strSqls.Add(string.Format("update so set soStates={0},approverId={1},approveDate='{2}' where soId={3}", (int)state, userid, DateTime.Now.ToShortDateString(), soId)); strSqls.Add(string.Format("update soItems set soItemState={0} where soId={1}", new SoItemApprove().GetStateValue(), soId)); } else if (state == SoStatesEnum.Rejected || state == SoStatesEnum.Cancel || state == SoStatesEnum.Closed) { strSqls.Add(string.Format("update so set soStates={0} where soId={1}", (int)state, soId)); int value = 0; if (state == SoStatesEnum.Rejected) { value = new SoItemRejected().GetStateValue(); } else if (state == SoStatesEnum.Cancel) { value = new SoItemCancelled().GetStateValue(); } else { value = new SoItemClose().GetStateValue(); } strSqls.Add(string.Format("update soItems set soItemState={0} where soId={1}", value, soId)); } else { strSqls.Add(string.Format("update so set soStates={0} where soId={1}", (int)state, soId)); } db.ExecDataBySqls(strSqls); }
public static void WholeUpdateSoState(int soId, int userid, SoStatesEnum state) { List<string> strSqls = new List<string>(); if (state ==SoStatesEnum.Approved) { strSqls.Add(string.Format("update so set soStates={0},approverId={1},approveDate='{2}' where soId={3}", (int)state, userid, DateTime.Now.ToShortDateString(), soId)); strSqls.Add(string.Format("update soItems set soItemState={0} where soId={1}",new SoItemApprove().GetStateValue(),soId)); } else if (state == SoStatesEnum.Rejected || state == SoStatesEnum.Cancel||state==SoStatesEnum.Closed) { strSqls.Add(string.Format("update so set soStates={0} where soId={1}", (int)state, soId)); int value = 0; if (state == SoStatesEnum.Rejected) value = new SoItemRejected().GetStateValue(); else if (state == SoStatesEnum.Cancel) value = new SoItemCancelled().GetStateValue(); else value = new SoItemClose().GetStateValue(); strSqls.Add(string.Format("update soItems set soItemState={0} where soId={1}",value,soId)); } else { strSqls.Add(string.Format("update so set soStates={0} where soId={1}", (int)state, soId)); } db.ExecDataBySqls(strSqls); }