public static ArrayList CustQueryList() { ArrayList r = new ArrayList(); Sys_OverComputeFunctionBll srb = new Sys_OverComputeFunctionBll(); List <Sys_OverComputeFunction> lsf = new List <Sys_OverComputeFunction>(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r.Add(iv.badstr); lsf = srb.QueryList(" and dcode='" + iv.u.dcode.Substring(0, 8) + "'"); if (lsf != null) { foreach (Sys_OverComputeFunction s in lsf) { ArrayList al = new ArrayList(); al.Add(s.fcode); al.Add(s.fname); al.Add(s.fattr); al.Add(s.fstr); r.Add(al); } } } else { r.Add(iv.badstr); } return(r); }
public static string CustSaveOComputeMethod(string fcode, string fgs, string fid, string flx, string fname, string ftx) { string r = ""; Sys_OverComputeFunction sr = new Sys_OverComputeFunction(); Sys_OverComputeFunctionBll srb = new Sys_OverComputeFunctionBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { sr.fname = fname; sr.fcode = fcode; sr.fattr = flx; sr.fstr = fgs; sr.ftx = ""; sr.dcode = iv.u.dcode.Substring(0, 8); sr.cdate = DateTime.Now.ToString(); sr.maker = iv.u.ename; if (fid == "0") { if (!srb.Exists(" and fname='" + fname + "'")) { if (srb.Add(sr) > 0) { r = "S"; } else { r = "F"; } } else { r = "T"; } } else { if (!srb.Exists(" and fname='" + fname + "' and fcode<>'" + fcode + "'")) { if (srb.Update(sr)) { r = "S"; } else { r = "F"; } } else { r = "T"; } } } else { r = iv.badstr; } return(r); }
public static string InitOComputeMethod(string fcode) { string r = ""; Sys_OverComputeFunction sr = new Sys_OverComputeFunction(); Sys_OverComputeFunctionBll srb = new Sys_OverComputeFunctionBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_OverComputeFunction csr = srb.Query(" and fcode='" + fcode + "'"); if (csr != null) { r = js.Serialize(csr); } else { sr.fname = ""; sr.fcode = srb.CreateCode().ToString().PadLeft(4, '0'); sr.id = 0; r = js.Serialize(sr); } } else { r = iv.badstr; } return(r); }
public static string GetProductionOcm(string pcode) { string r = ""; Sys_OverComputeFunctionBll srb = new Sys_OverComputeFunctionBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { r = srb.GetProductionOcm(pcode); } else { r = iv.badstr; } return(r); }
public static string DelComputeMethod(string fcode) { string r = ""; Sys_OverComputeFunctionBll srb = new Sys_OverComputeFunctionBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { if (srb.Delete(" and fcode='" + fcode + "'")) { r = "S"; } else { r = "F"; } } else { r = iv.badstr; } return(r); }