public static string ProcessOver(string id) { string r = ""; BusiWorkFlowBll snsb = new BusiWorkFlowBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { CB_ProductionProcess p = new CB_ProductionProcess(); p.id = Convert.ToInt32(id); p.odate = DateTime.Now.ToString(); p.gstate = 1; CB_ProductionProcess pp = cbppb.Query(" and id=" + id + ""); if (cbppb.Update(p)) { //if (pp.jtype == "h") //{ // cosb.UpState(pp.sid, "ifactorydeliver", 1); //} r = "S"; } else { r = "F"; } } else { r = iv.badstr; } return(r); }
public static ArrayList QueryNextProcess(string id, string emcode, string tabcode) { ArrayList r = new ArrayList(); DataTable lsr = new DataTable(); StringBuilder where = new StringBuilder(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); int rcount = 0; int pcount = 0; Sys_ViewTable svt = svtb.QuerySelCols(emcode, tabcode, iv.u.rcode); if (svt == null) { } else { CB_ProductionProcess copp = cbppb.Query(" and id=" + id + ""); if (copp != null) { where.Append(" and sid='" + copp.sid + "'"); } where.Append(CommonBll.SqlWhereReplace(iv.u, svt.sqlcondition)); string sfield = svt.sqlcols; lsr = cbppb.QueryList(1, 15, sfield, where.ToString(), " scode desc", ref rcount, ref pcount); if (lsr != null) { foreach (DataRow dr in lsr.Rows) { ArrayList al = new ArrayList(); al.Add(bebb.QueryBtnListItems(emcode, iv.u.rcode, "LX", dr[1].ToString())); foreach (DataColumn column in lsr.Columns) { if (column.Caption == "gstate") { int i = Convert.ToInt32(dr[column].ToString()); al.Add(bppb.ProduceProcessState(i)); } else { al.Add(dr[column].ToString()); } } r.Add(al); } } } } else { r.Add(iv.badstr); } return(r); }