public JsonResult InitAttr(string acode)
{
JsonData d = new JsonData();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_ProductionAttrEx sal = new Sys_ProductionAttrEx();
if (acode != "")
{
sal = spaeb.Query(" and acode='" + acode + "'");
}
else
{
sal.acode = spaeb.CreateCode().ToString().PadLeft(4, '0');
sal.id = 0;
}
d.d = js.Serialize(sal);
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public JsonResult SaveAttr(string acode, string aid, string amoney, string aname, string asql)
{
JsonData d = new JsonData();
Sys_ProductionAttrEx sb = new Sys_ProductionAttrEx();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
sb.aname = aname;
sb.acode = acode;
sb.bdcode = iv.u.dcode.Substring(0, 8);
sb.csql = asql;
sb.price = Convert.ToDecimal(amoney);
sb.maker = iv.u.ename;
sb.cdate = DateTime.Now.ToString();
if (aid == "0")
{
if (spaeb.Add(sb) > 0)
{
d.d = "S";
}
else
{
d.d = "F";
}
}
else
{
if (spaeb.Update(sb))
{
d.d = "S";
}
else
{
d.d = "F";
}
}
}
else
{
d.d = iv.badstr;
}
return(Json(d));
}
public static string SaveProduction(string alist, string blcode, string blname, string cavetype, string ctcode, string ctcz, string ctlxcz, string ctname, string cttbcz,
string direction, string fix, string floor, string gnum, string hjcode, string hjcz, string hjname,
string invcate, string isjc, string locks, string locktype, string mscode, string mscz, string msname, string msts, string mtbcode, string mtbcz, string mtbname, string mtcode, string mtcz, string mtlxcz,
string mtname, string mttbcz, string mtts, string optype, string pbz, string pdeep, string place, string plength, string pnum, string psize,
string pwidth, string qtcode, string qtcz, string qtname, string sid, string sjcode, string sjname,
string slblcode, string slblname, string wjcode, string wjname, string ykcode, string ykcz, string yklxcz, string ykname, string yktbcz, string zsize
)
{
string r = "";
//bool tjFlag = false;
List <B_GroupProduction> lbgp = new List <B_GroupProduction>();
B_GroupProduction ms = new B_GroupProduction();
B_GroupProduction mt = new B_GroupProduction();
B_GroupProduction ct = new B_GroupProduction();
B_GroupProduction yk = new B_GroupProduction();
B_GroupProduction wj = new B_GroupProduction();
B_GroupProduction qt = new B_GroupProduction();
B_GroupProduction bl = new B_GroupProduction();
B_GroupProduction slbl = new B_GroupProduction();
B_GroupProduction sj = new B_GroupProduction();
B_GroupProduction hj = new B_GroupProduction();
B_GroupProduction mtb = new B_GroupProduction();
int wjgnum = 1000;
string egnum = "0";
invcate = invcate.Substring(8, 3);
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
string gsid = CommonBll.GetSid();
Sys_SizeTransformR sc = scb.Query(" and rcode='" + cavetype + "'");
pbz = pbz.Replace(",", " ");
if (gnum == "" || gnum == "0")
{
egnum = bgpb.GetGnum(" and sid='" + sid + "' and gnum<1000").ToString();
wjgnum = wjgnum + bgpb.GetGnum(" and sid='" + sid + "' and gnum>1000");
if (invcate == "004")
{
gnum = wjgnum.ToString();
}
else
{
gnum = egnum.ToString();
}
}
else
{
if (invcate == "004" && Convert.ToInt32(gnum) < 1000)
{
wjgnum = wjgnum + bgpb.GetGnum(" and sid='" + sid + "' and gnum>1000");
}
if (invcate != "004" && Convert.ToInt32(gnum) >= 1000)
{
egnum = bgpb.GetGnum(" and sid='" + sid + "' and gnum<1000").ToString();
}
if (invcate == "004" && Convert.ToInt32(gnum) >= 1000)
{
wjgnum = Convert.ToInt32(gnum);
}
if (invcate != "004" && Convert.ToInt32(gnum) < 1000)
{
egnum = gnum;
}
}
#region//门扇
if (mscode != "")
{
Sys_InventoryDetail ims = sidb.Query(" and icode='" + mscode + "'");
Sys_ProduceImg spi = spib.QueryInvImg(mscode);
ms.sid = sid;
ms.tsid = "";
ms.gsid = gsid;
ms.psid = CommonBll.GetSid();
ms.itype = invcate;
ms.fix = fix;
ms.direction = direction;
ms.place = place;
ms.inum = Convert.ToDecimal(pnum);
ms.gnum = Convert.ToInt32(egnum);
ms.locktype = locktype;
ms.mname = mscz;
ms.icode = mscode;
ms.iname = msname;
ms.uname = ims == null ? "" : ims.iunit;
ms.height = Convert.ToInt32(plength);
ms.width = Convert.ToInt32(pwidth);
ms.deep = Convert.ToInt32(pdeep);
ms.fsize = Convert.ToInt32(psize);
ms.zsize = Convert.ToInt32(zsize);
ms.maker = iv.u.ename;
ms.ptype = "ms";
ms.isjc = isjc;
ms.allprice = 0;
ms.serverprice = 0;
ms.cdate = DateTime.Now.ToString();
ms.locks = locks;
ms.floor = floor;
ms.msts = msts;
if (spi != null)
{
ms.pic = spi.iurl;
ms.picname = spi.iname;
}
else
{
ms.pic = "";
ms.picname = "";
}
ms.idiscount = bsdb.CheckDiscount(sid, mscode) == true ? 1 : 0;
ms.czyy = smcb.QueryEx(mscode);
ms.zjname = "";
ms.zjcode = "";
ms.zjmname = "";
ms.zsize = 0;
ms.tbcz = "";
ms.lxcz = "";
if (mscode != "")
{
ms.ps = srb.QueryGByIcode(mscode) + pbz.Replace(",", "，");
}
if (sc != null)
{
ms.cavecode = sc.rcode;
ms.cavename = sc.rname;
}
}
#endregion
#region//门套
if (mtcode != "")
{
Sys_InventoryDetail imt = sidb.Query(" and icode='" + mtcode + "'");
mt.sid = sid;
mt.gsid = gsid;
mt.tsid = "";
mt.psid = CommonBll.GetSid();
mt.itype = invcate;
mt.fix = fix;
mt.direction = direction;
mt.place = place;
mt.inum = Convert.ToDecimal(pnum);
mt.gnum = Convert.ToInt32(egnum);
mt.locktype = locktype;
mt.mname = mtcz;
mt.icode = mtcode;
mt.iname = mtname;
mt.ptype = "mt";
mt.isjc = isjc;
mt.uname = imt == null ? "" : imt.iunit;
mt.height = Convert.ToInt32(plength);
mt.width = Convert.ToInt32(pwidth);
mt.deep = Convert.ToInt32(pdeep);
mt.fsize = Convert.ToInt32(psize);
mt.zsize = Convert.ToInt32(zsize);
mt.maker = iv.u.ename;
mt.locks = locks;
mt.allprice = 0;
mt.tbcz = mttbcz;
mt.lxcz = mtlxcz;
mt.serverprice = 0;
mt.cdate = DateTime.Now.ToString();
mt.idiscount = bsdb.CheckDiscount(sid, mtcode) == true ? 1 : 0;
mt.floor = floor;
mt.mtts = mtts;
if (slblcode != "")
{
mt.zjname = slblname;
mt.zjcode = slblcode;
mt.zjmname = "";
}
if (mtbcode != "")
{
mt.zjname = mtbname;
mt.zjcode = mtbcode;
mt.zjmname = mtbcz;
}
if (mtcode != "")
{
mt.ps = pbz.Replace(",", "，");
}
}
#endregion
#region//窗套
if (ctcode != "")
{
Sys_InventoryDetail ict = sidb.Query(" and icode='" + ctcode + "'");
ct.sid = sid;
ct.tsid = "";
ct.gsid = gsid;
ct.psid = CommonBll.GetSid();
ct.itype = invcate;
ct.fix = fix;
ct.direction = direction;
ct.place = place;
ct.inum = Convert.ToDecimal(pnum);
ct.gnum = Convert.ToInt32(egnum);
ct.locktype = locktype;
ct.mname = ctcz;
ct.icode = ctcode;
ct.iname = ctname;
ct.ptype = "ct";
ct.isjc = isjc;
ct.uname = ict == null ? "" : ict.iunit;
ct.height = Convert.ToInt32(plength);
ct.width = Convert.ToInt32(pwidth);
ct.deep = Convert.ToInt32(pdeep);
ct.fsize = Convert.ToInt32(psize);
ct.allprice = 0;
ct.serverprice = 0;
ct.maker = iv.u.ename;
ct.cdate = DateTime.Now.ToString();
ct.idiscount = bsdb.CheckDiscount(sid, ctcode) == true ? 1 : 0;
ct.zjname = "";
ct.zjcode = "";
ct.zjmname = "";
ct.zsize = 0;
ct.tbcz = cttbcz;
ct.lxcz = ctlxcz;
ct.floor = floor;
if (ctcode != "")
{
ct.ps = srb.QueryGByIcode(ctcode) + pbz;
}
}
#endregion
#region//垭口
if (ykcode != "")
{
Sys_InventoryDetail iyk = sidb.Query(" and icode='" + ykcode + "'");
yk.sid = sid;
yk.tsid = "";
yk.gsid = gsid;
yk.psid = CommonBll.GetSid();
yk.itype = invcate;
yk.fix = fix;
yk.direction = direction;
yk.place = place;
yk.inum = Convert.ToDecimal(pnum);
yk.gnum = Convert.ToInt32(egnum);
yk.locktype = locktype;
yk.mname = ykcz;
yk.icode = ykcode;
yk.iname = ykname;
yk.ptype = "yk";
yk.isjc = isjc;
yk.uname = iyk == null ? "" : iyk.iunit;
yk.height = Convert.ToInt32(plength);
yk.width = Convert.ToInt32(pwidth);
yk.deep = Convert.ToInt32(pdeep);
yk.fsize = Convert.ToInt32(psize);
yk.maker = iv.u.ename;
yk.allprice = 0;
yk.serverprice = 0;
yk.cdate = DateTime.Now.ToString();
yk.idiscount = bsdb.CheckDiscount(sid, ykcode) == true ? 1 : 0;
yk.zjname = "";
yk.zjcode = "";
yk.zjmname = "";
yk.zsize = 0;
yk.tbcz = yktbcz;
yk.lxcz = yklxcz;
yk.floor = floor;
if (ykcode != "")
{
yk.ps = srb.QueryGByIcode(ykcode) + pbz;
}
}
#endregion
#region//玻璃
if (blcode != "")
{
Sys_InventoryDetail ibl = sidb.Query(" and icode='" + blcode + "'");
bl.sid = sid;
bl.tsid = "";
bl.gsid = gsid;
bl.psid = CommonBll.GetSid();
bl.itype = invcate;
bl.fix = fix;
bl.direction = direction;
bl.place = place;
bl.inum = Convert.ToDecimal(pnum);
bl.gnum = Convert.ToInt32(egnum);
bl.locktype = locktype;
bl.mname = "";
bl.icode = blcode;
bl.iname = blname;
bl.height = 0;
bl.width = 0;
bl.deep = 0;
bl.fsize = 0;
bl.ptype = "bl";
bl.isjc = isjc;
bl.uname = ibl == null ? "" : ibl.iunit;
bl.maker = iv.u.ename;
bl.allprice = 0;
bl.serverprice = 0;
bl.cdate = DateTime.Now.ToString();
bl.idiscount = bsdb.CheckDiscount(sid, blcode) == true ? 1 : 0;
bl.zjname = "";
bl.zjcode = "";
bl.zjmname = "";
bl.zsize = 0;
bl.tbcz = "";
bl.lxcz = "";
bl.floor = floor;
if (blcode != "")
{
bl.ps = srb.QueryGByIcode(blcode) + pbz;
}
}
#endregion
#region//锁具
if (sjcode != "")
{
Sys_InventoryDetail isj = sidb.Query(" and icode='" + sjcode + "'");
sj.sid = sid;
sj.tsid = "";
sj.gsid = gsid;
sj.psid = CommonBll.GetSid();
sj.itype = invcate;
sj.fix = fix;
sj.direction = direction;
sj.place = place;
sj.inum = Convert.ToDecimal(pnum);
sj.gnum = Convert.ToInt32(egnum);
sj.locktype = locktype;
sj.mname = "";
sj.ptype = "sj";
sj.icode = sjcode;
sj.iname = sjname;
sj.uname = isj == null ? "" : isj.iunit;
sj.height = 0;
sj.width = 0;
sj.deep = 0;
sj.fsize = 0;
sj.isjc = isjc;
sj.allprice = 0;
sj.serverprice = 0;
sj.maker = iv.u.ename;
sj.cdate = DateTime.Now.ToString();
sj.idiscount = bsdb.CheckDiscount(sid, sjcode) == true ? 1 : 0;
sj.zjname = "";
sj.zjcode = "";
sj.zjmname = "";
sj.zsize = 0;
sj.tbcz = "";
sj.lxcz = "";
sj.floor = floor;
if (sjcode != "")
{
sj.ps = srb.QueryGByIcode(sjcode) + pbz;
}
}
#endregion
#region//五金
if (wjcode != "")
{
Sys_InventoryDetail iwj = sidb.Query(" and icode='" + wjcode + "'");
wj.sid = sid;
wj.tsid = "";
wj.gsid = gsid;
wj.psid = CommonBll.GetSid();
wj.itype = invcate;
wj.fix = fix;
wj.direction = direction;
wj.place = place;
wj.inum = Convert.ToDecimal(pnum);
wj.gnum = Convert.ToInt32(wjgnum);
wj.locktype = locktype;
wj.mname = "";
wj.icode = wjcode;
wj.iname = wjname;
wj.height = 0;
wj.ptype = "wj";
wj.width = 0;
wj.deep = 0;
wj.fsize = 0;
wj.isjc = isjc;
wj.allprice = 0;
wj.serverprice = 0;
wj.uname = iwj == null ? "" : iwj.iunit;
wj.maker = iv.u.ename;
wj.cdate = DateTime.Now.ToString();
if (wjcode != "")
{
wj.ps = srb.QueryGByIcode(wjcode) + pbz;
}
wj.zjname = "";
wj.zjcode = "";
wj.zjmname = "";
wj.zsize = 0;
wj.tbcz = "";
wj.lxcz = "";
wj.idiscount = bsdb.CheckDiscount(sid, wjcode) == true ? 1 : 0;
wj.floor = floor;
}
#endregion
#region//护角
if (hjcode != "")
{
Sys_InventoryDetail ihj = sidb.Query(" and icode='" + hjcode + "'");
hj.sid = sid;
hj.tsid = "";
hj.gsid = gsid;
hj.psid = CommonBll.GetSid();
hj.itype = invcate;
hj.fix = fix;
hj.direction = direction;
hj.place = place;
hj.inum = Convert.ToDecimal(pnum);
hj.gnum = Convert.ToInt32(egnum);
hj.locktype = locktype;
hj.mname = hjcz;
hj.icode = hjcode;
hj.iname = hjname;
hj.uname = ihj == null ? "" : ihj.iunit;
hj.ptype = "hj";
hj.isjc = isjc;
hj.height = Convert.ToInt32(plength);
hj.width = Convert.ToInt32(pwidth);
hj.deep = Convert.ToInt32(pdeep);
hj.fsize = Convert.ToInt32(psize);
hj.allprice = 0;
hj.serverprice = 0;
hj.maker = iv.u.ename;
hj.cdate = DateTime.Now.ToString();
hj.idiscount = bsdb.CheckDiscount(sid, hjcode) == true ? 1 : 0;
hj.zjname = "";
hj.zjcode = "";
hj.zjmname = "";
hj.zsize = 0;
hj.tbcz = "";
hj.lxcz = "";
hj.floor = floor;
if (hjcode != "")
{
hj.ps = srb.QueryGByIcode(hjcode) + pbz;
}
}
#endregion
#region//其他
if (qtcode != "")
{
Sys_InventoryDetail iqt = sidb.Query(" and icode='" + qtcode + "'");
qt.sid = sid;
qt.tsid = "";
qt.gsid = gsid;
qt.psid = CommonBll.GetSid();
qt.itype = invcate;
qt.fix = fix;
qt.direction = direction;
qt.place = place;
qt.inum = Convert.ToDecimal(pnum);
qt.gnum = Convert.ToInt32(egnum);
qt.locktype = locktype;
qt.mname = qtcz;
qt.icode = qtcode;
qt.iname = qtname;
qt.ptype = "qt";
qt.isjc = isjc;
qt.uname = iqt == null ? "" : iqt.iunit;
qt.height = Convert.ToInt32(plength);
qt.width = Convert.ToInt32(pwidth);
qt.deep = Convert.ToInt32(pdeep);
qt.fsize = Convert.ToInt32(psize);
qt.allprice = 0;
qt.serverprice = 0;
qt.maker = iv.u.ename;
qt.cdate = DateTime.Now.ToString();
if (qtcode != "")
{
qt.ps = srb.QueryGByIcode(qtcode) + pbz;
}
qt.zjname = "";
qt.zjcode = "";
qt.zjmname = "";
qt.zsize = 0;
qt.tbcz = "";
qt.lxcz = "";
qt.idiscount = bsdb.CheckDiscount(sid, qtcode) == true ? 1 : 0;
qt.floor = floor;
}
#endregion
if (invcate == "010")
{
lbgp.Add(ms);
lbgp.Add(mt);
lbgp.Add(sj);
lbgp.Add(bl);
lbgp.Add(slbl);
lbgp.Add(mtb);
}
if (invcate == "001")
{
lbgp.Add(ms);
lbgp.Add(bl);
}
if (invcate == "002")
{
lbgp.Add(mt);
lbgp.Add(slbl);
lbgp.Add(mtb);
}
if (invcate == "006")
{
lbgp.Add(ct);
}
if (invcate == "004")
{
lbgp.Add(wj);
}
if (invcate == "005")
{
lbgp.Add(bl);
}
if (invcate == "007")
{
lbgp.Add(yk);
}
if (invcate == "008")
{
lbgp.Add(hj);
}
if (invcate == "009")
{
lbgp.Add(qt);
}
bgpmb.Delete(" and sid='" + sid + "' and gnum=" + gnum + "");
if (bgpb.SaveList(lbgp, sid, Convert.ToInt32(gnum)) > 0)
{
if (alist != "")
{
List <B_GroupProductionAttr> lbpa = new List <B_GroupProductionAttr>();
if (alist != null)
{
string[] pl = alist.Split(';');
for (int i = 0; i < pl.Length; i++)
{
Sys_ProductionAttrEx spae = spab.Query(" and acode='" + pl[i] + "'");
B_GroupProductionAttr ba = new B_GroupProductionAttr();
ba.sid = sid;
ba.gsid = gsid;
ba.acode = spae.acode;
ba.aname = spae.aname;
ba.amoney = spae.price;
ba.cdate = DateTime.Now.ToString();
ba.maker = iv.u.ename;
lbpa.Add(ba);
}
bgpab.AddList(lbpa, gsid);
}
}
if (invcate == "004")
{
bcpb.InvComputePrice(sid, Convert.ToInt32(wjgnum), iv.u.dcode, "gh");
r = "S";
}
else
{
bcpb.InvComputePrice(sid, Convert.ToInt32(egnum), iv.u.dcode, "gh");
r = "S";
}
bpib.SaveItemList(bistfb.CreateTranFormList(sid, Convert.ToInt32(gnum), iv.u.ename));
}
else
{
r = "F";
}
if (optype == "f")
{
r = gnum;
}
}
else
{
r = iv.badstr;
}
return(r);
}