public static ArrayList QueryListExp(string rcode)
{
ArrayList r = new ArrayList();
Sys_RemarkConditionBll srcb = new Sys_RemarkConditionBll();
List <Sys_RemarkCondition> lsf = new List <Sys_RemarkCondition>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
lsf = srcb.QueryList(" and rcode='" + rcode + "'");
if (lsf != null)
{
foreach (Sys_RemarkCondition s in lsf)
{
ArrayList al = new ArrayList();
al.Add(s.rccode);
al.Add(s.rtype);
al.Add(s.rbottomv);
al.Add(s.rtopv);
al.Add(s.rxtext);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string InitRemarkExp(string rccode)
{
string r = "";
Sys_RemarkCondition src = new Sys_RemarkCondition();
Sys_RemarkConditionBll srcb = new Sys_RemarkConditionBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_RemarkCondition csr = srcb.Query(" and rccode='" + rccode + "'");
if (csr != null)
{
r = js.Serialize(csr);
}
else
{
src.rcname = "";
src.rccode = srcb.CreateCode().ToString().PadLeft(4, '0');
src.id = 0;
r = js.Serialize(src);
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string DelRemarksExp(string rccode)
{
string r = "";
Sys_RemarkConditionBll srb = new Sys_RemarkConditionBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (srb.Delete(" and rccode='" + rccode + "'"))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveRemarkExp(string bottomv, string rccode, string rcid, string rcname, string rcode, string rctext, string rctype, string topv)
{
string r = "";
Sys_RemarkConditionBll srcb = new Sys_RemarkConditionBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_RemarkCondition sr = new Sys_RemarkCondition();
sr.rcname = rcname;
sr.rccode = rccode;
sr.rtype = rctype;
sr.rcode = rcode;
sr.rbottomv = Convert.ToInt32(bottomv);
sr.rtopv = Convert.ToInt32(topv);
sr.rxtext = rctext;
sr.cdate = DateTime.Now.ToString();
sr.marker = iv.u.ename;
if (rcid == "0")
{
if (!srcb.Exists(" and rcname='" + rcname + "'"))
{
if (srcb.Add(sr) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = "T";
}
}
else
{
if (!srcb.Exists(" and rcname='" + rcname + "' and rccode<>'" + rccode + "'"))
{
if (srcb.Update(sr))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = "T";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
