public static ArrayList CustQueryList()
{
ArrayList r = new ArrayList();
Sys_RemarkBll srb = new Sys_RemarkBll();
List <Sys_Remark> lsf = new List <Sys_Remark>();
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_Remark s in lsf)
{
ArrayList al = new ArrayList();
al.Add(s.rcode);
al.Add(s.rname);
al.Add(s.rchangtext);
al.Add(s.rfixtext);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string InitRemark(string rcode)
{
string r = "";
Sys_Remark sr = new Sys_Remark();
Sys_RemarkBll srb = new Sys_RemarkBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_Remark csr = srb.Query(" and rcode='" + rcode + "'");
if (csr != null)
{
r = js.Serialize(csr);
}
else
{
sr.rname = "";
sr.rcode = srb.CreateCode().ToString().PadLeft(4, '0');
sr.id = 0;
r = js.Serialize(sr);
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string CustSaveRemark(string bcode, string bid, string bname, string changebz, string context)
{
string r = "";
Sys_RemarkBll srb = new Sys_RemarkBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_Remark sr = new Sys_Remark();
sr.rname = bname;
sr.rcode = bcode;
sr.rchangtext = changebz;
sr.rfixtext = context;
sr.cdate = DateTime.Now.ToString();
sr.maker = iv.u.ename;
sr.dcode = iv.u.dcode.Substring(0, 8);
if (bid == "0")
{
if (!srb.Exists(" and rname='" + bname + "'"))
{
if (srb.Add(sr) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = "T";
}
}
else
{
if (!srb.Exists(" and rname='" + bname + "' and rcode<>'" + bcode + "'"))
{
if (srb.Update(sr))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = "T";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string GetProductionRemarks(string pcode)
{
string r = "";
Sys_RemarkBll srb = new Sys_RemarkBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r = srb.GetProductionBz(pcode);
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SetProductionRemarks(string pcode, string rcode)
{
string r = "";
Sys_RemarkBll srb = new Sys_RemarkBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (srb.SetProductionBz(pcode, rcode) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string DelRemarks(string rcode)
{
string r = "";
Sys_RemarkBll srb = new Sys_RemarkBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (srb.Delete(" and rcode='" + rcode + "'"))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
