public static ArrayList QueryList(string ocode)
{
ArrayList r = new ArrayList();
Sys_OverConditionBll cocb = new Sys_OverConditionBll();
List <Sys_OverCondition> lsf = new List <Sys_OverCondition>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
StringBuilder where = new StringBuilder();
lsf = cocb.QueryList(" and ocode='" + ocode + "'");
if (lsf != null)
{
foreach (Sys_OverCondition s in lsf)
{
ArrayList al = new ArrayList();
al.Add(s.ccode);
al.Add(s.oname);
al.Add(s.cname);
al.Add(s.cattr);
al.Add(s.bvalue);
al.Add(s.tvalue);
al.Add(s.cfstr);
al.Add(s.cfscale);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string InitOverCondition(string ocode, string ccode)
{
string r = "";
Sys_OverComputeCategoryBll snsb = new Sys_OverComputeCategoryBll();
Sys_OverConditionBll cocb = new Sys_OverConditionBll();
Sys_OverCondition soc = new Sys_OverCondition();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_OverCondition csns = cocb.Query(" and ccode='" + ccode + "'");
if (csns != null)
{
r = js.Serialize(csns);
}
else
{
soc.ocode = ocode;
soc.oname = snsb.Query(" and ocode='" + ocode + "'").oname;
soc.ccode = cocb.CreateCode().ToString().PadLeft(4, '0');
soc.id = 0;
r = js.Serialize(soc);
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveOverCondition(string tattr, string tbvalue, string tcity, string tcode, string tid, string tjs, string tlcode, string tlname, string tname,
string tprice, string tsz, string ttvalue, string ttype, string txs
)
{
string r = "";
Sys_OverConditionBll snsb = new Sys_OverConditionBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_OverCondition s = new Sys_OverCondition();
s.oname = tlname;
s.ocode = tlcode;
s.cname = tname;
s.ccode = tcode;
s.bvalue = Convert.ToInt32(tbvalue);
s.tvalue = Convert.ToInt32(ttvalue);;
s.cattr = tattr;
s.cfscale = Convert.ToDecimal(tsz);
s.cfstr = tjs;
s.cxs = Convert.ToDecimal(txs);
s.cpricetype = tprice;
s.cdate = DateTime.Now.ToString();
s.pcity = tcity;
s.maker = iv.u.ename;
if (tid == "0")
{
if (snsb.Add(s) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
if (snsb.Update(s))
{
r = "S";
}
else
{
r = "F";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string GetProductionOc(string icode, string ocode)
{
string r = "";
Sys_OverConditionBll cocb = new Sys_OverConditionBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r = cocb.GetProductionOcEx(icode, ocode);
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SetProductionOc(string icode, string pcode, string ocode)
{
string r = "";
Sys_OverConditionBll cocb = new Sys_OverConditionBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (cocb.SetProductionOc(icode, pcode, ocode) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string DelOverCondition(string ccode)
{
string r = "";
Sys_OverConditionBll cocb = new Sys_OverConditionBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (cocb.Delete(" and ccode='" + ccode + "'"))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
