public JsonResult InitSizeFormat(string sfccode, string sfcode)
{
JsonData d = new JsonData();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_SizeFomatCondition sal = new Sys_SizeFomatCondition();
if (sfccode != "")
{
sal = sscb.Query(" and sfccode='" + sfccode + "'");
}
else
{
Sys_SizeFormatCate sb = ssfcb.Query(" and sfcode='" + sfcode + "'");
if (sb != null)
{
sal.sfcode = sb.sfcode;
sal.sfname = sb.sfname;
}
sal.sfccode = sscb.CreateCode().ToString().PadLeft(4, '0');
sal.id = 0;
}
d.d = js.Serialize(sal);
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public JsonResult InitSizeCollection(string sfccode, string btype)
{
JsonData d = new JsonData();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
ArrayList r = new ArrayList();
Sys_SizeFomatCondition sal = new Sys_SizeFomatCondition();
if (sfccode != "")
{
List <Sys_SizeFormatPart> lsf = ssfpb.QueryList(" and bjtype='" + btype + "'");
if (lsf != null)
{
foreach (Sys_SizeFormatPart sp in lsf)
{
ArrayList al = new ArrayList();
al.Add(sp.bjcode);
al.Add(sp.bjcname);
al.Add(sp.bjname);
Sys_SizeFormatCollection sc = ssfb.Query(" and bjcode='" + sp.bjcode + "' and sfccode='" + sfccode + "'");
if (sc != null)
{
al.Add(sc.hstr);
al.Add(sc.wstr);
al.Add(sc.dstr);
al.Add(sc.bjnum);
al.Add(sc.bjtj);
al.Add(sc.ftype);
}
else
{
al.Add("0");
al.Add("0");
al.Add("0");
al.Add("0");
al.Add("");
al.Add("");
}
al.Add(sp.bjattr);
al.Add(sp.bjattrex);
r.Add(al);
}
}
}
d.d = js.Serialize(r);
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public JsonResult SaveSizeFormat(string ctype, string dlv, string dtv, string hlv, string htv, string isms, string isqy, string pccode, string pcname, string tcode, string tid, string tname, string wlv, string wtv)
{
JsonData d = new JsonData();
Sys_SizeFomatCondition sb = new Sys_SizeFomatCondition();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
sb.sfname = pcname;
sb.sfcode = pccode;
sb.dlv = Convert.ToInt32(dlv);
sb.dtv = Convert.ToInt32(dtv);
sb.fixd = "";
sb.hlv = Convert.ToInt32(hlv);
sb.htv = Convert.ToInt32(htv);
sb.isms = isms == "0" ? false : true;
sb.sfccode = tcode;
sb.sfcname = tname;
sb.used = isqy == "0" ? false : true;
sb.wlv = Convert.ToInt32(wlv);
sb.wtv = Convert.ToInt32(wtv);
sb.maker = iv.u.ename;
sb.ctype = ctype;
sb.cdate = DateTime.Now.ToString();
if (tid == "0")
{
if (sscb.Add(sb) > 0)
{
d.d = "S";
}
else
{
d.d = "F";
}
}
else
{
if (sscb.Update(sb))
{
d.d = "S";
}
else
{
d.d = "F";
}
}
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public JsonResult CopySizeFormat(string sfccode)
{
JsonData d = new JsonData();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
string r = "";
Sys_SizeFomatCondition sc = sscb.Query(" and sfccode='" + sfccode + "'");
if (sc != null)
{
sc.sfccode = sscb.CreateCode().ToString().PadLeft(4, '0');
if (sscb.Add(sc) > 0)
{
List <Sys_SizeFormatCollection> lf = ssfb.QueryList(" and sfccode ='" + sfccode + "'");
if (lf != null)
{
foreach (Sys_SizeFormatCollection sl in lf)
{
sl.sfcode = sc.sfcode;
sl.sfname = sc.sfname;
sl.sfccode = sc.sfccode;
sl.sfcname = sc.sfcname;
if (ssfb.Add(sl) > 0)
{
r = "S";
}
else
{
r = "F";
break;
}
}
}
if (r == "F")
{
sscb.Delete(sc.sfccode);
}
}
}
d.d = r;
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public JsonResult ReSetSizeFormat(string icode, string pcode)
{
JsonData d = new JsonData();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
ArrayList r = new ArrayList();
Sys_SizeFomatCondition sal = new Sys_SizeFomatCondition();
if (pcode == "" || pcode == null)
{
if (ssfcb.ReSetSizeFormat(icode, ""))
{
d.d = "S";
}
else
{
d.d = "F";
}
}
else
{
if (ssfcb.ReSetSizeFormat("", pcode))
{
d.d = "S";
}
else
{
d.d = "F";
}
}
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public JsonResult SaveSizeCollection(string fpcode, string fpname, object[][] plist)
{
string r = "";
JsonData d = new JsonData();
Sys_SizeFomatCondition sb = new Sys_SizeFomatCondition();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
List <Sys_SizeFormatCollection> al = new List <Sys_SizeFormatCollection>();
if (plist != null)
{
foreach (object[] o in plist)
{
if (Convert.ToInt32(o[6].ToString()) > 0)
{
Sys_SizeFormatPart sp = ssfpb.Query(" and bjcode='" + o[1].ToString() + "'");
Sys_SizeFomatCondition sal = sscb.Query(" and sfccode='" + fpcode + "'");
Sys_SizeFormatCollection sc = new Sys_SizeFormatCollection();
if (sp != null)
{
sc.bjname = sp.bjname;
sc.bjcode = sp.bjcode;
sc.bjattr = sp.bjattr;
sc.bjattrex = sp.bjattrex;
sc.bjpname = sp.bjcname;
sc.bjtype = sp.bjctype;
}
else
{
sc.bjname = "";
sc.bjcode = "";
sc.bjattr = "";
sc.bjattrex = "";
sc.bjpname = "";
sc.bjtype = "";
}
sc.hstr = o[3].ToString();
sc.wstr = o[4].ToString();
sc.dstr = o[5].ToString();
sc.bjnum = Convert.ToInt32(o[6].ToString());
sc.ftype = o[8].ToString();
sc.sfccode = fpcode;
sc.sfcname = fpname;
if (sal != null)
{
sc.sfcode = sal.sfcode;
sc.sfname = sal.sfname;
}
else
{
sc.sfcode = "";
sc.sfname = "";
}
sc.bjtj = o[7].ToString();
al.Add(sc);
}
}
}
if (al.Count() > 0)
{
if (ssfb.AddList(fpcode, al))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = "F";
}
d.d = r;
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
