public ActionResult deleterece(int id)
{
var row = ServiceDB.Instance.ExecuteSqlCommand("update MsgRece set isDelete=1 where receId=" + id);
ReturnValue r = new ReturnValue();
r.status = row == 1;
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult deletesend(Guid id)
{
var row = ServiceDB.Instance.ExecuteSqlCommand("update MsgSend set isDelete=1 where msgId='" + id + "'");
ReturnValue r = new ReturnValue();
r.status = row == 1;
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult autopost()
{
ReturnValue r = new ReturnValue();
r.status = true;
r.message = SessionHelper.SessionId;
Session["autopostsession"] = r.message;
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult checksupplierprice(int? priceid,int to)
{
try
{
if (!priceid.HasValue || !Masterpage.CheckRight("manage_supplier_pricecheck")) return Json(new ReturnValue { status = false, message = "非法权限" }, JsonRequestBehavior.AllowGet);
var row = ServiceDB.Instance.ExecuteSqlCommand("update MaterialPrice set status=" + to + ",endDate="+(to==2?"'"+DateTime.Now.ToString("yyyy-MM-dd")+"'":"NULL")+" where priceid=" + priceid.Value);
ReturnValue r = new ReturnValue() { status = (row == 1), message = "删除" + (row == 1 ? "成功" : "失败") };
return Json(r, JsonRequestBehavior.AllowGet);
}
catch (Exception ex) { return Json(new ReturnValue { status = false, message = "删除失败" + ex.Message }, JsonRequestBehavior.AllowGet); }
}
public ActionResult savebomcost()
{
ReturnValue back = new ReturnValue { status = false };
if (!Masterpage.CheckRight("bomcost_update"))
{
back.message = "非法权限！";
}
else
{
var id = WebRequest.GetInt("costsn", 0);
var bomId = WebRequest.GetInt("bom", 0);
var mybom = WebRequest.GetInt("mybom", 0);
var price = WebRequest.GetFloat("price", 0);
var amount = WebRequest.GetFloat("amount", 0);
var oldprice = WebRequest.GetFloat("oldprice", 0);
var remark = WebRequest.GetString("remark", true);
int row = 0;
if (id == 0)
row = ServiceDB.Instance.ExecuteSqlCommand("insert into BomCost values(" + mybom + "," + price + ",getdate(),'" + remark + "')");
else
row = ServiceDB.Instance.ExecuteSqlCommand("update BomCost set price=" + price + ",remark='remark' where costId=" + id);
if (row != 1) back.message = "价格更新失败！";
else
{
var egx = amount * price - amount * oldprice;
var row2 = ServiceDB.Instance.ExecuteSqlCommand("update BomMain set rootCost=rootCost+" + egx + " where bomId=" + bomId);
if (row != 1) back.message = "总成本更新失败！";
else back.status = true;
}
}
return Json(back, JsonRequestBehavior.AllowGet);
}
public ActionResult bomoptdelete(string type, string no, int sn)
{
ReturnValue r = new ReturnValue();
switch (type)
{
case "requrie":
r = bomService.DeletePurcharseRequire(no, sn, Masterpage.CurrUser.staffid, Masterpage.CurrUser.depId);
break;
case "delegate":
r = bomService.DeleteDelegate(no, sn, Masterpage.CurrUser.staffid, Masterpage.CurrUser.depId);
break;
case "produce":
r = bomService.DeleteProduce(no, sn, Masterpage.CurrUser.staffid, Masterpage.CurrUser.depId);
break;
default:
r.status = false;
r.message = "操作类别有误";
break;
}
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult bomvalid()
{
int id = WebRequest.GetInt("id", 0);
int valid = WebRequest.GetInt("valid", 0);
string sql = "";
if (valid == 0) sql = "update BomMain set status=" + valid + ",endDate='" + DateTime.Now.ToString() + "' where bomId=" + id;
else sql = "update BomMain set status=" + valid + ",startDate='" + DateTime.Now.ToString() + "',endDate=null where bomId=" + id;
var row = ServiceDB.Instance.ExecuteSqlCommand(sql);
ReturnValue rv = new ReturnValue();
rv.status = row == 1;
return Json(rv, JsonRequestBehavior.AllowGet);
}
public ActionResult saveouttsell_2( string pricelist, string remarklist, string materiallist, string amountlist)
{
string no = WebRequest.GetString("no", true);
string type = WebRequest.GetString("type", true);
string remark = WebRequest.GetString("remark", true);
string deport = WebRequest.GetString("deport", true);
int supplier = WebRequest.GetInt("supplier", 0);
string express = WebRequest.GetString("express", true);
string expresscode = WebRequest.GetString("expresscode", true);
string date = WebRequest.GetString("date", true);
ReturnValue r = new ReturnValue() { status = false };
string[] remarkl = remarklist.Split(',');
string[] materiall = materiallist.Split(',');
string[] pricel = pricelist.Split(',');
string[] amountl = amountlist.Split(',');
if (amountl.Length < 1 || materiall.Length != pricel.Length)
{
r = new ReturnValue { status = false, message = "未提交任何明细" };
}
else
{
var head = 0;
if (type == "add")
{
string backno = stockoutService.GetStockOutNo();
if (backno != "")
{
head = ServiceDB.Instance.ExecuteSqlCommand(
"INSERT INTO [dbo].[StockOut] values('" + backno + "'," + Masterpage.CurrUser.staffid + "," + Masterpage.CurrUser.depId + "," + supplier
+ ",'',null,4,'',0,0,0,getdate(),1,0,0,'','" + remark + "','" + deport+"','"+express+"','"+expresscode+"',"+(date==""?"null":"'"+date+"'")+",0)");
no = backno;
}
}
else if (type == "edit")
{
head = ServiceDB.Instance.ExecuteSqlCommand("update [dbo].[StockOut] set deportStaff='" + deport + "',remark='" + remark + "',express='" + express + "',expresscode='" + expresscode + "',outDate= " + (date == "" ? "null" : "'" + date + "'") + " where stockoutNo='" + no + "'");
}
if (head > 0)
{
#region 修改明细
if (type == "edit") ServiceDB.Instance.ExecuteSqlCommand("delete StockOutDetail where stockoutNo='" + no + "'");
head = 0;
List<string> delgno = new List<string>();
for (int i = 0; i < materiall.Length; i++)
{
if (materiall[i] == "" || pricel[i] == "" || pricel[i] == "0" || amountl[i] == ""|| amountl[i] == "0") continue;
var haddetail = ServiceDB.Instance.QueryOneModel<StockOutDetail>("select * from StockOutDetail where stockoutNo='" + no + "' and materialNo='" + materiall[i] + "'");
var addone = 0;
if (haddetail != null)
{
addone = ServiceDB.Instance.ExecuteSqlCommand("update INTO [dbo].[StockOutDetail] set outAmount+=" + amountl[i] + ", outPrice=" + pricel[i] + " where detailSn=" + haddetail.orderSn);
}
else
{
addone = ServiceDB.Instance.ExecuteSqlCommand("INSERT INTO [dbo].[StockOutDetail] VALUES('" + no + "','" + materiall[i] + "',2,null,null," + amountl[i] + ",0," + pricel[i] + ",'','" + remarkl[i] + "')");
}
head += addone;
}
if (head < 1)
{
ServiceDB.Instance.ExecuteSqlCommand("delete StockOut where stockoutNo='" + no + "'");
}
#endregion
r.status = true;
}
}
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult savepullone(string no)
{
string type = WebRequest.GetString("type", true);
string backdate = WebRequest.GetString("backdate", true);
string pulldate = WebRequest.GetString("pulldate", true);
string remark = WebRequest.GetString("remark", true);
string deport = WebRequest.GetString("deport", true);
string productno = WebRequest.GetString("productno", true);
string pullamount = WebRequest.GetString("pullamount", true);
string material = WebRequest.GetString("material", true);
string product = WebRequest.GetString("product", true);
string amount = WebRequest.GetString("amount", true);
string jsamount = WebRequest.GetString("jsamount", true);
string remarks = WebRequest.GetString("remarks", true);
string[] listmaterial = material.Split(',');
string[] listproduct = product.Split(',');
string[] listamount = amount.Split(',');
string[] listremarks = remarks.Split(',');
string[] listjsamount = jsamount.Split(',');
ReturnValue r = new ReturnValue() { status = false };
if (listmaterial.Length < 1 || listmaterial.Length != listamount.Length)
{
r = new ReturnValue { status = false, message = "未提交任何明细" };
}
else
{
var head = 0;
if (type == "add")
{
string backno = bomService.GetProductPullNo();
if (backno != "")
{
head = ServiceDB.Instance.ExecuteSqlCommand(
"INSERT INTO [dbo].[ProductPull] values('" + backno + "'," + Masterpage.CurrUser.staffid + "," + Masterpage.CurrUser.depId + ",'" + productno
+ "'," + pullamount + ",'" + pulldate + "','" + backdate + "',0,1,1,0,0,'',null,'" + deport + "',getdate(),'" + remark + "')");
no = backno;
}
}
else if (type == "edit")
{
head = ServiceDB.Instance.ExecuteSqlCommand("update [dbo].[ProductPull] set makeAmount=" + pullamount + ",backDate='" + backdate + "',pullDate='" + pulldate + "',remark='" + remark + "',deportStaff='" + deport + "' where pullNo='" + no + "'");
}
if (head > 0)
{
#region 修改明细
if (type == "edit") ServiceDB.Instance.ExecuteSqlCommand("delete ProductPullDetail where pullNo='" + no + "'");
head = 0;
List<string> delgno = new List<string>();
for (int i = 0; i < listmaterial.Length; i++)
{
if (listmaterial[i] == "" || listamount[i] == "" || listamount[i] == "0") continue;
var addone = ServiceDB.Instance.ExecuteSqlCommand("INSERT INTO [dbo].[ProductPullDetail] VALUES('" + no + "'," + listproduct[i] + ",'" + listmaterial[i] + "'," + listjsamount[i] + "," + listamount[i] + ",'" + listremarks[i] + "')");
head += addone;
}
if (head < 1)
{
ServiceDB.Instance.ExecuteSqlCommand("delete ProductPull where pullNo='" + no + "'");
}
else
{
var hadd = ServiceDB.Instance.QueryOneModel<Production>("select * from Production where produceNo='" + productno + "' and canfs=1");
if (hadd != null) ServiceDB.Instance.ExecuteSqlCommand("update Production set canfs=0 where produceNo='" + productno + "'");
}
#endregion
r.status = true;
}
}
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult uppwd(string oldpwd, string newpwd)
{
ReturnValue r = new ReturnValue();
if (newpwd.Length < 6 || newpwd.Length > 20)
{
r = new ReturnValue { message = "新密码长度需为6到12位", status = false };
}
else
{
r = accountService.UpdatePwd(Masterpage.CurrUser.staffid, MD5Helper.MD5_32(oldpwd), MD5Helper.MD5_32(newpwd));
}
return Json(r);
}
public ActionResult saveoutsell()
{
string no = WebRequest.GetString("no", true);
string type = WebRequest.GetString("type", true);
string remark = WebRequest.GetString("remark", true);
int supplier = WebRequest.GetInt("supplier", 0);
string deport = WebRequest.GetString("deport", true);
ReturnValue r = new ReturnValue() { status = false };
List<StockDetailModel> temp = (List<StockDetailModel>)SessionHelper.GetSession("WO1" + no + Masterpage.CurrUser.staffid);
if (temp == null || temp.Count < 1)
{
r.message = "不存在出库明细";
}
else if (supplier==0)
{
r.message = "未选择客户";
}
else
{
if (type == "add")
{
string backno = stockoutService.AddStockOut(Masterpage.CurrUser.staffid, Masterpage.CurrUser.depId, supplier, 1, remark,deport);
if (backno == "")
{
r.message = "出库单生成失败";
}
else
{
r = stockoutService.SaveStockOutDetail(backno, temp, 0, remark, deport);
}
}
else if (type == "edit")
{
r = stockoutService.SaveStockOutDetail(no, temp, 0, remark, deport);
}
}
SessionHelper.Del("WO1" + no + Masterpage.CurrUser.staffid);
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult savemsg(string title, string cate, string forids, string fornames, string remark,string attrname,string attrguid)
{
Guid msg = Guid.NewGuid();
MsgSend send = new MsgSend();
send.createDate = DateTime.Now;
send.isDelete = false;
send.msgcate = cate;
send.hadAttr = false;
send.msgcontent = remark;
send.msgId = msg;
send.receIds = forids;
send.receNames = fornames;
send.staffId = Masterpage.CurrUser.staffid;
send.title = title;
if (attrname != null && attrname != "" && attrguid != null && attrguid != "")
{
send.hadAttr = true;
ServiceDB.Instance.ExecuteSqlCommand("insert into Attachment values(newid(),'" + msg + "','" + attrguid + "','" + attrname + "','',getdate())");
}
bool exc = manageService.SaveSendMessage(send);
int rececount = 0;
if (exc)
{
string[] rece = forids.Split(',');
foreach (var item in rece)
{
if (item != "")
{
var row = ServiceDB.Instance.ExecuteSqlCommand("insert into MsgRece values('" + msg + "'," + item + ",0,null,0,null)");
rececount += row;
}
}
}
ReturnValue r = new ReturnValue();
r.status = rececount > 0;
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult deletebomselect()
{
string forids = WebRequest.GetString("forids");
string[] ids = forids.Split(',');
int count = 0;
foreach (string item in ids)
{
if (item == "") continue;
var bom = ServiceDB.Instance.QueryOneModel<BomMain>("select * from bommain where bomid=" + item);
if (bom != null && bom.bomId > 0)
{
var del = bomService.DeleteBom(bom.bomId);
if (del.status) count++;
}
}
ReturnValue r = new ReturnValue();
r.status = count > 0;
r.message = r.status ? "" : "BOM节点删除失败，BOM已引用，禁止删除";
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult gosettle()
{
ReturnValue back = new ReturnValue { status = false };
string no = WebRequest.GetString("no", true);
string forids = WebRequest.GetString("forids", true);
string costs = WebRequest.GetString("costs", true);
string date = WebRequest.GetString("date", true);
string remark = WebRequest.GetString("remark", true);
float cost = WebRequest.GetFloat("cost", 0);
var one = ServiceDB.Instance.QueryOneModel<Settlement>(" select * from Settlement where settleNo='" + no + "'");
if (one == null)
{
back.message = "不存在结算单";
return Json(back, JsonRequestBehavior.AllowGet);
}
string[] snlist = forids.Split(',');
string[] costlist = costs.Split(',');
if (snlist.Length != costlist.Length || snlist.Length < 1)
{
back.message = "传入参数数组有误";
return Json(back, JsonRequestBehavior.AllowGet);
}
string sql = "";
#region sql集合
sql += "insert into SettlementCapital values('" + one.settleNo + "'," + one.supplierId + ",'" + one.supplierName + "','" + date + "','" + Masterpage.CurrUser.name + "'," + cost + ",0,0,getdate(),'" + remark + "');";
sql += "update Settlement set realCost+=" + cost + " where settleNo='" + no + "';";
for (int i = 0; i < snlist.Length; i++)
{
sql += "update SettlementDetail set isSettle=1,realCost=" + costlist[i] + " where detailSn=" + snlist[i] + ";";
}
#endregion
try
{
var insert3 = ServiceDB.Instance.ExecuteSqlCommand(sql);
if (insert3 > 0)
{
var list = ServiceDB.Instance.QueryModelList<SettlementDetail>(" select * from SettlementDetail where settleNo='" + no + "' and isSettle=0").ToList();
if (list == null || list.Count < 1)
{
ServiceDB.Instance.ExecuteSqlCommand("update Settlement set isover=1, status=2 where settleNo='" + no + "';");
}
}
back.status = true;
return Json(back, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
back.status = false;
back.value = ex.Message;
return Json(back, JsonRequestBehavior.AllowGet);
}
}
public ActionResult saveinproduct()
{
string no = WebRequest.GetString("no", true);
string type = WebRequest.GetString("type", true);
string remark = WebRequest.GetString("remark", true);
string deport = WebRequest.GetString("deport", true);
ReturnValue r = new ReturnValue() { status = false };
List<StockDetailModel> temp = (List<StockDetailModel>)SessionHelper.GetSession("WE2" + no + Masterpage.CurrUser.staffid);
if (temp == null || temp.Count < 1)
{
r.message = "不存在入库明细";
}
else
{
if (type == "add")
{
string backno = stockinService.AddStockIn(Masterpage.CurrUser.staffid, Masterpage.CurrUser.depId, 0, 2, remark, deport);
if (backno == "")
{
r.message = "入库单生成失败";
}
else
{
r = stockinService.SaveStockInDetail(backno, temp, 0, remark, deport);
}
}
else if (type == "edit")
{
r = stockinService.SaveStockInDetail(no, temp, 0, remark, deport);
}
}
SessionHelper.Del("WE2" + no + Masterpage.CurrUser.staffid);
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult savesneedin(string no)
{
string type = WebRequest.GetString("type", true);
string supplier = WebRequest.GetString("supplier", true);
int i_supplier = Convert.ToInt32(supplier);
string remark = WebRequest.GetString("remark", true);
string deport = WebRequest.GetString("deport", true);
ReturnValue r = new ReturnValue() { status = false };
var list = new List<StockDetailModel>();
list = (List<StockDetailModel>)SessionHelper.GetSession("WE1" + no + Masterpage.CurrUser.staffid);
if (list.Count == 0)
{
r = new ReturnValue { status = false, message = "未提交任何订单明细" };
}
else
{
if (type == "add")
{
string backno = stockinService.AddStockIn(Masterpage.CurrUser.staffid, Masterpage.CurrUser.depId, i_supplier, 1, remark, deport);
if (backno == "")
{
r.message = "入库单生成失败";
}
else
{
r = stockinService.SaveStockInDetail(backno, list, 0, remark, deport);
}
}
else if (type == "edit")
{
r = stockinService.SaveStockInDetail(no, list, 0, remark, deport);
}
}
SessionHelper.Del("WE1" + no + Masterpage.CurrUser.staffid);
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult savesemione()
{
string no = WebRequest.GetString("no", true);
string type = WebRequest.GetString("type", true);
string date = WebRequest.GetString("date", true);
ReturnValue r = new ReturnValue() { status = false };
List<ProductSemi> temp = (List<ProductSemi>)SessionHelper.GetSession("WE4" + no + Masterpage.CurrUser.staffid);
if (temp == null || temp.Count < 1)
{
r.message = "不存在半成品明细";
}
else
{
string semino = no;
int count = 0;
if (type == "add")
{
semino = stockinService.GetStockSemiNo();
}
else if (type == "edit")
{
semino = no;
}
foreach (var item in temp)
{
string sql = "";
if (item.semiId <= 0) { sql = "insert into ProductSemi values('" + semino + "','" + item.proName + "','" + item.proModel + "'," + item.amount + "," + item.price + ",'" + item.remark + "'," + Masterpage.CurrUser.staffid + ",'" + Masterpage.CurrUser.name + "',getdate(),'" + date + "','',null,0)"; }
else { sql = "update ProductSemi set proName='" + item.proName + "',proModel='" + item.proModel + "',amount=" + item.amount + ",price=" + item.price + ",remark='" + item.remark + "',staffId=" + Masterpage.CurrUser.staffid + ",staffName='" + Masterpage.CurrUser.name + "',semiDate='" + date + "' where semiId=" + item.semiId; }
ServiceDB.Instance.ExecuteSqlCommand(sql);
count++;
}
r.status = count > 0;
}
SessionHelper.Del("WE4" + no + Masterpage.CurrUser.staffid);
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult saverolemenu(int id)
{
ReturnValue rv = new ReturnValue();
try
{
string addstr = WebRequest.GetString("add", true);
string delstr = WebRequest.GetString("del", true);
if (addstr.EndsWith("#")) addstr = addstr.Substring(0, addstr.Length - 1);
if (delstr.EndsWith("#")) delstr = delstr.Substring(0, delstr.Length - 1);
string[] add = addstr.Split('#');
string[] del = delstr.Split('#');
bool b = systemService.SaveRoleMenu(id, add, del);
if (b) rv = new ReturnValue { status = true, message = "" };
else rv = new ReturnValue { status = false, message = "保存失败" };
}
catch (Exception ex)
{
rv = new ReturnValue { status = false, message = "程序异常:" + ex.Message };
}
return Json(rv, JsonRequestBehavior.AllowGet);
}
public ActionResult fileuploadactin(string filetype)
{
ReturnValue r = new ReturnValue() { status = true };
var res = ConfigurationManager.AppSettings["FilePath"].ToString();//c:\Res\
var directory = "";
var httpfile = Request.Files["myfile"];
if (httpfile != null)
{
var fn = httpfile.FileName;
var exn = fn.Substring(fn.LastIndexOf("."));
var filename = "";
if (fn.Contains("\\")) filename = fn.Substring(fn.LastIndexOf("\\")).Replace("\\", "");
else filename = fn;
if (filetype == "material")
{
#region 物料图片
directory = res + "\\material\\";
#region 上传
if (!Directory.Exists(directory)) Directory.CreateDirectory(directory);
if (exn.ToLower() != ".png" && exn.ToLower() != ".jpg" && exn.ToLower() != ".bmp" && exn.ToLower() != ".jpeg" && exn.ToLower() != ".gif")
{
r.status = false;
r.message= "请上传图片格式文件（jpg,jpeg,png,bmp,gif）";
}
else
{
var newname = Guid.NewGuid().ToString() + exn;
try
{
httpfile.SaveAs(directory + newname);
}
catch
{
r.status = false;
r.message = "上传失败";
}
r.status = true;
r.value = newname;
r.value2 = filename;
}
#endregion
#endregion
}
else if (filetype == "message")
{
#region 站内消息附件
directory = res + "\\message\\";
#region 上传
if (!Directory.Exists(directory)) Directory.CreateDirectory(directory);
if (exn.ToLower() == ".exe" || exn.ToLower() == ".dll" || exn.ToLower() == ".js" || exn.ToLower() == ".ms" || exn.ToLower() == ".php")
{
r.status = false;
r.message = "请上传正确的文档文件";
}
else
{
var newname = Guid.NewGuid().ToString() + exn;
try
{
httpfile.SaveAs(directory + newname);
}
catch
{
r.status = false;
r.message = "上传失败";
}
r.status = true;
r.value = newname;
r.value2 = filename;
}
#endregion
#endregion
}
else
{
var str2 = JsonHelper.ToJson(new { status = false, message = "文件上传类型错误" });
return Content(str2);
}
}
else
{
r.status = false;
r.message = "未上传文件";
}
var str = JsonHelper.ToJson(r);
return Content(str);
}
public ActionResult savepurchase()
{
//no: no, sn: sn, remark: bz, date: date, km: km, cost: cost
string no = WebRequest.GetString("no", true);
ReturnValue back = new ReturnValue { status = true };
string remark = WebRequest.GetString("remark", true);
var insert3 = ServiceDB.Instance.ExecuteSqlCommand("update BillCost set remark='" + remark + "' where billNo='" + no + "'");
return Json(back, JsonRequestBehavior.AllowGet);
}
public ActionResult checkdata(string key, string no, int status)
{
ReturnValue back = new ReturnValue { status = true };
if (key == "require")
{
#region 采购申请
back.status = purchaseService.ChangeRequireStatus(no, status, Masterpage.CurrUser.name);
#endregion
}
else if (key == "purchase")
{
back.status = purchaseService.ChangePurchaseStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "stockin")
{
back.status = stockinService.ChangeStockInStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "stockout")
{
back = stockoutService.ChangeStockOutStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "stockchange")
{
back = stockoutService.ChangeChangeOtNStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "orderreturn")
{
back = stockinService.ChangeReturnStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "stockreturn")
{
back = stockoutService.ChangeStockReturnStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "bomorder")
{
back = bomService.ChangeBomOrderStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "bill")
{
back.status = manageService.ChangeBillStatus(no, status, Masterpage.CurrUser.staffid);
}
else if (key == "settle" || key == "pay")
{
back.status = manageService.ChangeSettleStatus(no, status, Masterpage.CurrUser.staffid);
}
else if (key == "delegate")
{
back = bomService.ChangeDelegateStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "produce")
{
back = bomService.ChangeProductionStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "delegatesend")
{
back = bomService.ChangeDelegateSendStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "delegateback")
{
back = bomService.ChangeDelegateBackStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "producepull")
{
back = bomService.ChangeProductPullStatus(no, status, Masterpage.CurrUser.name);
}
else if (key == "producegive")
{
back = bomService.ChangeProductGiveStatus(no, status, Masterpage.CurrUser.name);
}
return Json(back, JsonRequestBehavior.AllowGet);
}
public ActionResult savepurchasedetail()
{
//no: no, sn: sn, remark: bz, date: date, km: km, cost: cost
string no = WebRequest.GetString("no", true);
string km = WebRequest.GetString("km", true);
string bz = WebRequest.GetString("bz", true);
string date = WebRequest.GetString("date", true);
string cost = WebRequest.GetString("cost", true);
string amount = WebRequest.GetString("amount", true);
int sn = WebRequest.GetInt("sn", 0);
ReturnValue back = new ReturnValue { status = false };
string title = WebRequest.GetString("title", true);
string remark = WebRequest.GetString("remark", true);
string type = WebRequest.GetString("type", true);
if (type == "add")
{
var newno = manageService.GetTCNo();
var insert = ServiceDB.Instance.ExecuteSqlCommand("insert into BillCost (billno,title,staffmake,depid,status,valid,isover,billtype,remark,createdate) values('" + newno + "',''," + Masterpage.CurrUser.staffid + "," + Masterpage.CurrUser.depId + ",0,1,0,1,'" + remark + "',getdate())");
if (insert != 1)
{
back.message = "采购单创建失败，请刷新当前页重试";
return Json(back, JsonRequestBehavior.AllowGet);
}
no = newno;
}
#region 添加明细
var had = ServiceDB.Instance.QueryOneModel<BillCostDetail>("select * from BillCostDetail where billNo='" + no + "' and billTitle='" + km + "' and remark=" + remark);
if (sn == 0)
{
#region 添加
if (had != null)
{
back.message = "采购单明细已存在";
return Json(back, JsonRequestBehavior.AllowGet);
}
else
{
var insert2 = ServiceDB.Instance.ExecuteSqlCommand("insert into BillCostDetail values('" + no + "','" + km + "'," + amount + "," + cost + ",'" + date + "','" + bz + "')");
if (insert2 != 1)
{
back.message = "采购单明细创建失败，请刷新当前页重试";
return Json(back, JsonRequestBehavior.AllowGet);
}
var me = ServiceDB.Instance.QueryOneModel<BillCostDetail>("select * from BillCostDetail where billNo='" + no + "' and billTitle='" + km + "' and price=" + cost);
if (me == null)
{
back.message = "采购单明细创建失败";
}
else
{
back.status = true;
back.value2 = no;
back.value = me.detailSn.ToString();
}
}
#endregion
}
else
{
#region 修改
if (had != null && sn != had.detailSn)
{
back.message = "采购单明细已存在";
return Json(back, JsonRequestBehavior.AllowGet);
}
else
{
var insert3 = ServiceDB.Instance.ExecuteSqlCommand("update BillCostDetail set billTitle='" + km + "',amount=" + amount + ",price=" + cost + ",billDate='" + date + "',remark='" + bz + "' where detailSn=" + sn);
if (insert3 != 1)
{
back.message = "采购单明细修改失败，请刷新当前页重试";
return Json(back, JsonRequestBehavior.AllowGet);
}
back.status = true;
back.value2 = no;
back.value = sn.ToString();
}
#endregion
}
#endregion
return Json(back, JsonRequestBehavior.AllowGet);
}
public ActionResult saveoutold2new()
{
string no = WebRequest.GetString("no", true);
string type = WebRequest.GetString("type", true);
string remark = WebRequest.GetString("remark", true);
string deport = WebRequest.GetString("deport", true);
ReturnValue r = new ReturnValue() { status = false };
List<StockDetailModel> temp = (List<StockDetailModel>)SessionHelper.GetSession("ON1" + no + Masterpage.CurrUser.staffid);
if (temp == null || temp.Count < 1)
{
r.message = "不存在以旧换新明细";
}
else
{
var inlist = temp.Where(p => p.changeType == 0).ToList();
var outlist = temp.Where(p => p.changeType == 1).ToList();
if (inlist.Count < 1 || outlist.Count < 1)
{
r.message = "旧物料入库、新物料出库均不能为空";
}
else
{
if (type == "add")
{
string backno = stockoutService.AddChangeOtN(Masterpage.CurrUser.staffid, Masterpage.CurrUser.depId, remark, deport);
if (backno == "")
{
r.message = "以旧换新单生成失败";
}
else
{
r = stockoutService.SaveChangeOtNDetail(backno, inlist, outlist, remark, deport);
}
}
else if (type == "edit")
{
r = stockoutService.SaveChangeOtNDetail(no, inlist, outlist, remark, deport);
}
else
{
r.message = "操作类别错误";
}
}
}
SessionHelper.Del("ON1" + no + Masterpage.CurrUser.staffid);
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult updatebomcost()
{
string forids = WebRequest.GetString("forids");
string[] ids = forids.Split(',');
int count = 0;
foreach (string item in ids)
{
if (item == "") continue;
System.Data.SqlClient.SqlParameter[] param = new System.Data.SqlClient.SqlParameter[1];
System.Data.SqlClient.SqlParameter sp = new System.Data.SqlClient.SqlParameter("@bomid", item);
param[0] = sp;// new System.Data.SqlClient.SqlParameter { Direction = System.Data.ParameterDirection.Input, Value = item, };
var bom = ServiceDB.Instance.ExecuteSqlCommand("exec usp_update_bomcost @bomid ", param);
count++;
}
ReturnValue r = new ReturnValue();
r.status = count > 0;
r.message = r.status ? "" : "BOM成本更新失败";
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult saveoutsell_2(string outsnlist, string ordersnlist, string remarklist, string materiallist, string depotlist, string amountlist)
{
string no = WebRequest.GetString("no", true);
string type = WebRequest.GetString("type", true);
string remark = WebRequest.GetString("remark", true);
int supplier = WebRequest.GetInt("supplier", 0);
string deport = WebRequest.GetString("deport", true);
string order = WebRequest.GetString("order", true);
string date = WebRequest.GetString("date", true);
ReturnValue r = new ReturnValue() { status = false };
string[] outsnl = outsnlist.Split(',');
string[] ordersnl = ordersnlist.Split(',');
string[] remarkl = remarklist.Split(',');
string[] materiall = materiallist.Split(',');
string[] depotl = depotlist.Split(',');
string[] amountl = amountlist.Split(',');
if (type == "add")
{
string backno = stockoutService.AddStockOut(Masterpage.CurrUser.staffid, Masterpage.CurrUser.depId, supplier, 1, remark, deport);
if (backno == "")
{
r.message = "出库单生成失败";
}
else
{
try
{
ServiceDB.Instance.ExecuteSqlCommand("update StockOut set outDate='" + date + "', bomOrderNo='" + order + "' where stockoutNo='" + backno + "'");
for (int i = 0; i < ordersnl.Length; i++)
{
var od = ServiceDB.Instance.QueryOneModel<BomOrderDetail>("select * from BomOrderDetail where detailSn=" + ordersnl[i]);
ServiceDB.Instance.ExecuteSqlCommand("insert into StockOutDetail values('" + backno + "','" + materiall[i] + "'," + depotl[i] + "," + ordersnl[i] + ",null," + amountl[i] + ",0," + od.Price + ",null,'" + remarkl[i] + "')");
}
r.status = true;
}
catch (Exception x)
{ r.message = "添加明细失败:" + x.Message; }
}
}
else if (type == "edit")
{
try
{
for (int i = 0; i < ordersnl.Length; i++)
{
if (outsnl[i] == "0")
ServiceDB.Instance.ExecuteSqlCommand("insert into StockOutDetail values('" + no + "','" + materiall[i] + "'," + depotl[i] + "," + ordersnl[i] + ",null," + amountl[i] + ",0,0,null,'" + remarkl[i] + "')");
else if (outsnlist[i] > 0 && amountlist[i] == 0) ServiceDB.Instance.ExecuteSqlCommand("delete StockOutDetail where detailSn=" + outsnlist[i]);
else ServiceDB.Instance.ExecuteSqlCommand("update StockOutDetail set depotId=" + depotl[i] + ",outAmount=" + amountl[i] + ",remark='" + remarkl[i] + "', outDate='" + date + "' where detailSn=" + outsnl[i]);
}
r.status = true;
}
catch (Exception x)
{ r.message = "修改明细失败:" + x.Message; }
}
else r.message = "操作类别有误";
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult updatebomnode()
{
//id: id,mybom: mybom, forbom: bomid, type: type,name:name,amount: amount, price: price, remark: rmk
int id = WebRequest.GetInt("id", 0);
int mybomid = WebRequest.GetInt("mybom", 0);
int forbom = WebRequest.GetInt("forbom", 0);
var type = WebRequest.GetString("type", true);
var name = WebRequest.GetString("name", true);
var remark = WebRequest.GetString("remark", true);
var amount = WebRequest.GetFloat("amount", 0f);
var price = WebRequest.GetFloat("price", 0f);
var bom = ServiceDB.Instance.QueryOneModel<BomMain>("select * from BomMain where bomid=" + forbom);
var row = 0; double newcost = 0f;
ReturnValue r = new ReturnValue { status = false };
#region 更新
if (type == "addk")
{
row = ServiceDB.Instance.ExecuteSqlCommand("insert into BomVirtual values(" + forbom + ",'" + name + "'," + amount + "," + price + ",'" + remark + "')");
if (row == 1)
{
newcost = bom.rootCost + amount * price;
r.status = true; r.message = "新项目添加成功";
}
}
else if (type == "addm")
{
var mybom = ServiceDB.Instance.QueryOneModel<BomMain>("select * from BomMain where bomid=" + mybomid);
row = ServiceDB.Instance.ExecuteSqlCommand("insert into BomCost values(" + mybomid + "," + price + ",getdate(),'" + remark + "')");
if (row == 1)
{
newcost = bom.rootCost + amount * price;//
r.status = true; r.message = "新BOM单价添加成功";
}
}
else if (type == "updk")
{
var old = ServiceDB.Instance.QueryOneModel<BomVirtual>("select * from BomVirtual where virtualId=" + id);
row = ServiceDB.Instance.ExecuteSqlCommand("update BomVirtual set virtualName='" + name + "',vAmount=" + amount + ",vPrice=" + price + ",remark='" + remark + "' where virtualId=" + id);
if (row == 1)
{
newcost = bom.rootCost + (amount * price - old.vAmount * old.vPrice);
r.status = true; r.message = "项目修改成功";
}
}
else if (type == "updm")
{
var mybom = ServiceDB.Instance.QueryOneModel<BomMain>("select * from BomMain where bomid=" + mybomid);
var old = ServiceDB.Instance.QueryOneModel<BomCost>("select * from BomCost where costId=" + id);
row = ServiceDB.Instance.ExecuteSqlCommand("update BomCost set price=" + price + ",remark='" + remark + "' where costId=" + id);
if (row == 1)
{
newcost = bom.rootCost + (amount * price - old.price * amount);
r.status = true; r.message = "BOM单价修改成功";
}
}
else if (type == "delm")
{
var mybom = ServiceDB.Instance.QueryOneModel<BomMain>("select * from BomMain where bomid=" + mybomid);
var old = ServiceDB.Instance.QueryOneModel<BomCost>("select * from BomCost where costId=" + id);
row = ServiceDB.Instance.ExecuteSqlCommand("delete BomCost where costId=" + id);
if (row == 1)
{
newcost = bom.rootCost - (old.price * amount);
r.status = true; r.message = "BOM单价删除成功";
}
}
else if (type == "delk")
{
var old = ServiceDB.Instance.QueryOneModel<BomVirtual>("select * from BomVirtual where virtualId=" + id);
row = ServiceDB.Instance.ExecuteSqlCommand("delete BomVirtual where virtualId=" + id);
if (row == 1)
{
newcost = bom.rootCost - (old.vPrice * old.vAmount);
r.status = true; r.message = "BOM成本项目删除成功";
}
}
else { r.status = false; r.message = type + "操作类别错误"; }
if (r.status)
{
if (newcost < 0) newcost = 0;
ServiceDB.Instance.ExecuteSqlCommand("update BomMain set rootCost=" + newcost + " where bomid=" + forbom);
r.value = Math.Round(newcost, 4).ToString();
}
#endregion
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult savecanreturn(string no)
{
string type = WebRequest.GetString("type", true);
string remark = WebRequest.GetString("remark", true);
string deport = WebRequest.GetString("deport", true);
var returntype = WebRequest.GetInt("returntype", 0);
ReturnValue r = new ReturnValue() { status = false };
var list = new List<StockReturnDetailModel>();
list = (List<StockReturnDetailModel>)SessionHelper.GetSession("SR" + no + Masterpage.CurrUser.staffid);
if (list.Count == 0)
{
r = new ReturnValue { status = false, message = "未提交任何退单明细" };
}
else
{
if (type == "add")
{
string backno = stockoutService.AddStockReturn(Masterpage.CurrUser.staffid, Masterpage.CurrUser.depId, remark, deport, returntype);
if (backno == "")
{
r.message = "领料单生成失败";
}
else
{
r = stockoutService.SaveStockReturnDetail(backno, list, remark, deport);
}
}
else if (type == "edit")
{
r = stockoutService.SaveStockReturnDetail(no, list, remark, deport);
}
}
SessionHelper.Del("SR" + no + Masterpage.CurrUser.staffid);
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult showmsg(int id)
{
var msg = ServiceDB.Instance.QueryOneModel<MsgReceModel>("select * from MsgReceModel where receId=" + id + " and recestaffid=" + Masterpage.CurrUser.staffid);
ReturnValue r = new ReturnValue();
if (msg != null)
{
if (!msg.isRead) ServiceDB.Instance.QueryOneModel<MsgReceModel>("update msgrece set isread=1,readdate=getdate() where receId=" + id);
r.status = true;
r.message = msg.msgcontent;
r.value = msg.title;
}
else { r.status = false; }
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult savesneedbuy(string no)
{
string type = WebRequest.GetString("type", true);
string supplier = WebRequest.GetString("supplier", true);
int i_supplier = Convert.ToInt32(supplier);
string remark = WebRequest.GetString("remark", true);
//deport, datesend: datesend, dateback
string deport = WebRequest.GetString("deport", true);
string datesend = WebRequest.GetString("datesend", true);
string dateback = WebRequest.GetString("dateback", true);
ReturnValue r = new ReturnValue() { status = false };
var list = new List<V_DelegateSendDetailModel>();
list = (List<V_DelegateSendDetailModel>)SessionHelper.GetSession("DS" + no + Masterpage.CurrUser.staffid);
if (list.Count == 0)
{
r = new ReturnValue { status = false, message = "未提交任何发货明细" };
}
else
{
var head = 0;
if (type == "add")
{
string backno = bomService.GetDelegateSendNo();// purchaseService.AddPurchase("", Masterpage.CurrUser.staffid, Masterpage.CurrUser.depId, i_supplier, 1, 0, remark);
if (backno != "")
{
head = ServiceDB.Instance.ExecuteSqlCommand("INSERT INTO [dbo].[DelegateSend] values('" + backno + "'," + Masterpage.CurrUser.staffid + "," + Masterpage.CurrUser.depId + "," + i_supplier
+ ",'" + datesend + "','" + dateback + "',getdate(),'" + remark + "',0,1,1,0,0,'','" + deport + "')");
no=backno;
}
}
else if (type == "edit")
{
head = ServiceDB.Instance.ExecuteSqlCommand("update [dbo].[DelegateSend] set sendDate='" + datesend + "',needDate='" + dateback + "',remark='" + remark + "',deportStaff='" + deport + "' where sendNo='" + no + "'");
}
if (head>0)
{
#region 修改明细
if (type == "edit") ServiceDB.Instance.ExecuteSqlCommand("delete DelegateSendDetail where sendNo='" + no + "'");
head = 0;
List<string> delgno = new List<string>();
foreach (var item in list)
{
var addone = ServiceDB.Instance.ExecuteSqlCommand("INSERT INTO [dbo].[DelegateSendDetail] VALUES('" + no + "','" + item.delegateNo + "'," + item.productAmount + "," + item.price + ",0,'" + item.materialNo + "'," + item.bomId + "," + item.delegateDetailSn + "," + item.theoryAmount + "," + item.realAmount + ",'" + item.remark + "')");
if (!delgno.Contains(item.delegateNo))
{
var hadd = ServiceDB.Instance.QueryOneModel<DelegateOrder>("select * from DelegateOrder where delegateNo='" + item.delegateNo + "' and canfs=1");
if (hadd != null) ServiceDB.Instance.ExecuteSqlCommand("update DelegateOrder set canfs=0 where delegateNo='" + item.delegateNo + "'");
delgno.Add(item.delegateNo);
}
head += addone;
}
#endregion
if (head == list.Count) r.status = true;
else r.message = "保存失败";
}
}
SessionHelper.Del("DS" + no + Masterpage.CurrUser.staffid);
return Json(r, JsonRequestBehavior.AllowGet);
}
public ActionResult showmsg2(Guid id)
{
var msg = ServiceDB.Instance.QueryOneModel<MsgSendModel>("select * from MsgSendModel where msgId='" + id + "' and staffid=" + Masterpage.CurrUser.staffid);
ReturnValue r = new ReturnValue();
if (msg != null)
{
r.status = true;
r.message = msg.msgcontent;
r.value = msg.title;
r.value2 = msg.receNames;
}
else { r.status = false; }
return Json(r, JsonRequestBehavior.AllowGet);
}
