public ActionResult printsale(string no)
{
dynamic data = new System.Dynamic.ExpandoObject();
PrintHeadModel pm = new PrintHeadModel();
Supplier sup = new Supplier();
List <string> datas = new List <string>();
#region 分支
if (Masterpage.CheckRight("stockout_print"))
{
pm = stockoutService.StockOutList(no).Where(p => p.datatype == 1 || p.datatype == 4).Select(x => new PrintHeadModel {
checkStaff = x.checkStaff, date = x.createDate, depName = x.supplierName, makeStaff = x.staffName, No = x.stockNo, showdeport = true, deportStaff = x.deportStaff, supplierid = x.supplierId
}).FirstOrDefault();
sup = manageService.GetSupplierList("").FirstOrDefault(p => p.supplierId == pm.supplierid);
if (Masterpage.CheckRight("sellmoney_print"))
{
datas = stockoutService.StockOutDetailList(no).ToList().Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.amount + "," + x.price.ToString("N").Replace(",", "") + "," + (x.amount * x.price).ToString("N").Replace(",", "") + "," + x.remark).ToList();
}
else
{
datas = stockoutService.StockOutDetailList(no).ToList().Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.amount + "," + x.remark).ToList();
}
}
#endregion
data.pm = pm;
data.sup = sup;
data.showPrice = Masterpage.CheckRight("sellmoney_print");
data.datas = datas;
return(View(data));
}
public ActionResult savecustomerprice(int id, int?priceid, string material, double price, string date, string remark)
{
if (!priceid.HasValue || (priceid.Value == 0 && !Masterpage.CheckRight("manage_supplier_priceadd")) || (priceid.Value >= 0 && !Masterpage.CheckRight("manage_supplier_priceupdate")))
{
return(Json(new ReturnValue {
status = false, message = "非法权限"
}, JsonRequestBehavior.AllowGet));
}
ReturnValue r = new ReturnValue {
status = false
};
var row = 0;
try
{
if (priceid.Value == 0)
{
row = ServiceDB.Instance.ExecuteSqlCommand("insert into MaterialPrice values(" + id + ",'" + material + "'," + Masterpage.CurrUser.staffid + "," + price + ",'" + date + "',null,getdate(),0,'" + remark + "')");
}
else
{
row = ServiceDB.Instance.ExecuteSqlCommand("update MaterialPrice set materialNo='" + material + "',price=" + price + ",startDate='" + date + "',remark='" + remark + "' where priceid=" + priceid.Value);
}
r.status = row == 1; r.message = "操作失败！";
}
catch (Exception ex) { r.status = false; r.message = (priceid.Value == 0 ? "添加" : "修改") + "失败！" + ex.Message; }
return(Json(r, JsonRequestBehavior.AllowGet));
}
public ActionResult changeclient(string code)
{
var fcode = Request.Form["code"].ToString();
var fname = Request.Form["name"].ToString();
Masterpage.SetShowClient(fcode, fname);
LogHelper.Info(Masterpage.CurrUser.alias, "101011:切换客户，由" + Masterpage.CurrUser.client_code + "切换到" + fcode);
return(Content("ok"));
}
public ActionResult webhead()
{
var json = Masterpage.GetClientsJson();
var showcode = Masterpage.CurrUser.client_code;
var showname = Masterpage.CurrUser.client_name;
dynamic data = new System.Dynamic.ExpandoObject();
data.json = json;
data.showcode = showcode;
data.showname = showname;
return(PartialView(data));
}
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 checkcustomerprice(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 deletecustomerprice(int?priceid)
{
try
{
if (!priceid.HasValue || !Masterpage.CheckRight("manage_supplier_pricedelete"))
{
return(Json(new ReturnValue {
status = false, message = "非法权限"
}, JsonRequestBehavior.AllowGet));
}
var row = ServiceDB.Instance.ExecuteSqlCommand("delete MaterialPrice 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 bomcostview(string type, int id)
{
if (type == "edit" && !Masterpage.CheckRight("bomcost_update"))
{
return(RedirectToAction("login", "account"));
}
if (type == "view" && !Masterpage.CheckRight("bomcost_view"))
{
return(RedirectToAction("login", "account"));
}
dynamic data = new System.Dynamic.ExpandoObject();
string bomjson = "";
var one = ServiceDB.Instance.QueryOneModel <V_BomCostModel>(" select * from V_BomCostModel where bomid=" + id);
var child = ServiceDB.Instance.QueryModelList <V_BomCostModel>(" select * from V_BomCostModel where parent_Id=" + id).ToList();
var list = bomService.GetChildBomCost(child, Convert.ToDouble(1), 1);
//var virtuals=ServiceDB.Instance.QueryModelList<BomVirtual>("select * from BomVirtual where bomid=" + id).ToList();
//if (virtuals != null && virtuals.Count > 0)
//{
// List<object> nvs = new List<object>();
// foreach (var item in virtuals)
// {
// var nvi = new { km = 1, id = 0, sn = item.virtualId, no = "其他科目", name = item.virtualName, model = "", amount = item.vAmount, price = item.vPrice.ToString("N"), cost = (item.vPrice * item.vAmount).ToString("N"), unit = "", unit2 = "", amount2 = "", remark = item.remark, index = 0 };
// list.Add(nvi);
// }
// //var nv = new { km = 0, id = 0, sn = 0, no = "其他科目", name = "", model = "", amount = "", price = "", cost = "", unit = "", unit2 = "", amount2 = "", remark = "", index = 0, children = nvs };
// //list.Add(nv);
//}
bomjson = JsonHelper.ToJson(list);
data.one = one;
data.bomjson = bomjson;
data.type = type;
return(View(data));
}
public ActionResult printa4(string title, string key, string no)
{
dynamic data = new System.Dynamic.ExpandoObject();
PrintHeadModel pm = new PrintHeadModel();
List <string> datas = new List <string>();
#region 分支
switch (key)
{
case "order":
if (Masterpage.CheckRight("order_print"))
{
pm = purchaseService.PurchaseList(no).Select(x => new PrintHeadModel {
checkStaff = x.checkStaff, date = x.createDate, depName = x.suppliername, makeStaff = x.staffName, No = x.purchaseNo
}).FirstOrDefault();
if (Enterprise.Invoicing.Web.Masterpage.CheckRight("purchasemoney_print"))
{
datas = purchaseService.PurchaseDetailList(no).Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.poAmount + "," + x.materialUnit + "," + x.poPrice.ToString().Replace(",", "") + "," + (x.poAmount * x.poPrice).ToString().Replace(",", "") + "," + (x.sendDate < DateTime.Now.AddYears(5) ? x.sendDate.ToString("yyyy-MM-dd") : "") + "," + x.remark).ToList();
}
else
{
datas = purchaseService.PurchaseDetailList(no).Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.poAmount + "," + x.materialUnit + "," + (x.sendDate < DateTime.Now.AddYears(5) ? x.sendDate.ToString("yyyy-MM-dd") : "") + "," + x.remark).ToList();
}
}
break;
default:
break;
}
#endregion
data.key = key;
data.showPrice = Enterprise.Invoicing.Web.Masterpage.CheckRight("purchasemoney_print");
data.title = title;
data.pm = pm;
data.datas = datas;
return(View(data));
}
public ActionResult customerprice(int?id)
{
if (!Masterpage.CheckRight("manage_supplier_price") || !id.HasValue)
{
return(Content("非法操作！"));
}
dynamic data = new System.Dynamic.ExpandoObject();
var page = WebRequest.GetString("page", true);
var name = WebRequest.GetString("name", true);
var model = WebRequest.GetString("model", true);
data.id = id;
data.page = page;
data.name = name;
data.model = model;
Supplier one = ServiceDB.Instance.QueryOneModel <Supplier>("select * from supplier where type=1 and supplierid=" + id.Value);
if (one == null)
{
return(Content("客户不存在！"));
}
string where = "";
if (!string.IsNullOrEmpty(name))
{
where += " and (materialno like '%" + name + "%' or materialname like '%" + name + "%' or tunumber like '%" + name + "%' or pinyin like '%" + name + "%' )";
}
if (!string.IsNullOrEmpty(model))
{
where += " and materialmodel like '%" + model + "%'";
}
var list = ServiceDB.Instance.QueryModelList <V_MaterialPriceModel>("select * from V_MaterialPriceModel where supplierid=" + id.Value + where + " order by materialname asc ");
data.canadd = Masterpage.CheckRight("manage_supplier_priceadd") ? 1 : 0;
data.canedit = Masterpage.CheckRight("manage_supplier_priceupdate") ? 1 : 0;
data.list = list;
data.suppler = one.supplierName;
return(View(data));
}
public ActionResult printwin(string title, string key, string no)
{
dynamic data = new System.Dynamic.ExpandoObject();
PrintHeadModel pm = new PrintHeadModel();
List <string> datas = new List <string>();
bool showPrice = false;
#region 分支
switch (key)
{
case "require":
if (Masterpage.CheckRight("require_print"))
{
pm = purchaseService.RequireList(no).Where(p => p.requireNo == no).Select(x => new PrintHeadModel {
checkStaff = x.checkStaff, date = x.createDate, depName = "部门：" + x.depName, makeStaff = x.staffName, No = x.requireNo, showdeport = false
}).FirstOrDefault();
datas = purchaseService.RequireDetailList(no).Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.orderAmount.ToString("N") + "," + x.materialUnit + "," + (x.needdate < DateTime.Now.AddYears(5) ? x.needdate.ToString("yyyy-MM-dd") : "") + "," + x.remark).ToList();
}
break;
case "delegate":
if (Masterpage.CheckRight("delegate_print"))
{
var one = ServiceDB.Instance.QueryOneModel <V_DelegateOrderModel>(" select * from V_DelegateOrderModel where delegateNo='" + no + "'");
pm = new PrintHeadModel {
checkStaff = one.checkStaff, date = one.createDate, depName = "订单：" + one.bomOrderNo, makeStaff = one.staffName, No = one.delegateNo, showdeport = true, deportStaff = "产品：" + one.productNo + " " + one.productName + " " + one.productModel
};
datas = ServiceDB.Instance.QueryModelList <V_DelegateOrderDetail>(" select * from V_DelegateOrderDetail where delegateNo='" + no + "'").ToList().Select(x => x.materialNo + "," + x.materialName + "," + x.materialModel + "," + x.detailAmount.Value.ToString("N") + "," + x.unit + "," + x.detailRemark).ToList();
}
break;
case "produce":
if (Masterpage.CheckRight("produce_print"))
{
var one = ServiceDB.Instance.QueryOneModel <V_ProductionModel>(" select * from V_ProductionModel where produceNo='" + no + "'");
pm = new PrintHeadModel {
checkStaff = one.checkStaff, date = one.createDate.Value, depName = "订单：" + one.bomOrderNo, makeStaff = one.staffName, No = one.produceNo, showdeport = true, deportStaff = "产品：" + one.productNo + " " + one.productName + " " + one.productModel
};
datas = ServiceDB.Instance.QueryModelList <V_ProductionDetailModel>(" select * from V_ProductionDetailModel where produceNo='" + no + "'").ToList().Select(x => x.materialNo + "," + x.materialName + "," + x.materialModel + "," + x.amount.Value.ToString("N") + "," + x.outAmount.Value.ToString("N") + "," + x.unit + "," + x.remark).ToList();
}
break;
case "producepull":
if (Masterpage.CheckRight("producepull_print"))
{
var one = ServiceDB.Instance.QueryOneModel <V_ProductPullModel>(" select * from V_ProductPullModel where pullNo='" + no + "'");
pm = new PrintHeadModel {
checkStaff = one.checkStaff, date = one.createDate, depName = "工单：" + one.produceNo, makeStaff = one.staffName, No = one.pullNo, showdeport = true, deportStaff = "产品：" + one.materialNo + " " + one.materialName + " " + one.materialModel
};
datas = ServiceDB.Instance.QueryModelList <V_ProductPullDetail>(" select * from V_ProductPullDetail where pullNo='" + no + "'").ToList().Select(x => x.materialNo + "," + x.materialName + "," + x.materialModel + "," + x.theoryAmount.ToString("N") + "," + x.realAmount.ToString("N") + "," + x.unit + "," + x.remark).ToList();
}
break;
case "producegive":
if (Masterpage.CheckRight("producegive_print"))
{
var one = ServiceDB.Instance.QueryOneModel <V_ProductGiveModel>(" select * from V_ProductGiveModel where giveNo='" + no + "'");
pm = new PrintHeadModel {
checkStaff = one.checkStaff, date = one.createDate, depName = "工单：" + one.pullNo, makeStaff = one.staffName, No = one.giveNo, showdeport = true, deportStaff = "产品：" + one.materialNo + " " + one.materialName + " " + one.materialModel + " 交货数：" + one.giveAmount
};
datas = ServiceDB.Instance.QueryModelList <V_ProductGiveDetail>(" select * from V_ProductGiveDetail where giveNo='" + no + "'").ToList().Select(x => x.materialNo + "," + x.materialName + "," + x.materialModel + "," + x.realAmount.ToString("N") + "," + x.giveAmount.ToString("N") + "," + x.unit + "," + x.remark).ToList();
}
break;
case "order":
if (Masterpage.CheckRight("order_print"))
{
pm = purchaseService.PurchaseList(no).Select(x => new PrintHeadModel {
checkStaff = x.checkStaff, date = x.createDate, depName = "供应商：" + x.suppliername, makeStaff = x.staffName, No = x.purchaseNo, showdeport = false
}).FirstOrDefault();
if (Masterpage.CurrUser.showPrice)
{
datas = purchaseService.PurchaseDetailList(no).Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.poAmount + "," + x.materialUnit + "," + x.poPrice + "," + (x.poAmount * x.poPrice) + "," + (x.sendDate < DateTime.Now.AddYears(5) ? x.sendDate.ToString("yyyy-MM-dd") : "") + "," + x.remark).ToList();
}
else
{
datas = purchaseService.PurchaseDetailList(no).Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.poAmount + "," + x.materialUnit + "," + (x.sendDate < DateTime.Now.AddYears(5) ? x.sendDate.ToString("yyyy-MM-dd") : "") + "," + x.remark).ToList();
}
}
break;
case "stockin":
if (Masterpage.CheckRight("stockin_print"))
{
pm = stockinService.StockInList(no).Select(x => new PrintHeadModel {
checkStaff = x.checkStaff, date = x.createDate, depName = "部门：" + x.depName, makeStaff = x.staffName, No = x.stockNo, showdeport = true, deportStaff = "仓库：" + x.deportStaff
}).FirstOrDefault();
datas = stockinService.StockInDetailList(no).ToList().Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.amount + "," + x.materialUnit + "," + x.depotName + "," + x.purchaseNo + "," + x.remark).ToList();
}
break;
case "stockout":
if (Masterpage.CheckRight("stockout_print"))
{
pm = stockoutService.StockOutList(no).Where(p => p.datatype != 1).Select(x => new PrintHeadModel {
checkStaff = x.checkStaff, date = x.createDate, depName = "部门：" + x.depName, makeStaff = x.staffName, No = x.stockNo, showdeport = true, deportStaff = "仓库：" + x.deportStaff
}).FirstOrDefault();
datas = stockoutService.StockOutDetailList(no).ToList().Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.amount + "," + x.materialUnit + "," + x.depotName + "," + x.remark).ToList();
}
break;
case "change":
if (Masterpage.CheckRight("stockout_old2new_print"))
{
pm = stockoutService.ChangeOtNList(no).Select(x => new PrintHeadModel {
checkStaff = x.checkStaff, date = x.createDate, depName = "部门：" + x.depName, makeStaff = x.staffName, No = x.stockNo, showdeport = true, deportStaff = "仓库：" + x.deportStaff
}).FirstOrDefault();
List <string> l1 = new List <string>(); List <string> l2 = new List <string>();
l1 = stockoutService.ChangeOtNInList(no).ToList().Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.amount + "," + x.materialUnit + ",入库," + x.depotName + "," + x.remark).ToList();
l2 = stockoutService.ChangeOtNOutList(no).ToList().Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.amount + "," + x.materialUnit + ",出库," + x.depotName + "," + x.remark).ToList();
datas.AddRange(l1);
datas.AddRange(l2);
}
break;
case "orderreturn":
if (Masterpage.CheckRight("stockin_return_print"))
{
pm = stockinService.ReturnModelList(no).Select(x => new PrintHeadModel {
checkStaff = x.checkStaff, date = x.createDate, depName = "供应商：" + x.supplierName, makeStaff = x.staffName, No = x.returnNo, showdeport = true, deportStaff = "供应商："
}).FirstOrDefault();
datas = stockinService.ReturnDetailList(no).ToList().Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.returnAmount + "," + x.materialUnit + "," + x.purchaseNo + "," + x.depotName + "," + x.remark).ToList();
}
break;
case "stockreturn":
if (Masterpage.CheckRight("stockout_return_print"))
{
pm = stockoutService.ReturnModelList(no).Select(x => new PrintHeadModel {
checkStaff = x.checkStaff, date = x.createDate, depName = "部门：" + x.depName, makeStaff = x.staffName, No = x.returnNo, showdeport = true, deportStaff = "仓库：" + x.deportStaff
}).FirstOrDefault();
datas = stockoutService.StockReturnDetailList(no).ToList().Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.outAmoutn + "," + x.returnAmount + "," + x.materialUnit + "," + x.stockoutNo + "," + x.todepotName + "," + x.remark).ToList();
}
break;
case "bomorder":
if (Masterpage.CheckRight("bomorder_print"))
{
showPrice = Masterpage.CheckRight("ordermoney_print");
pm = bomService.BomOrderList(no).Select(x => new PrintHeadModel {
checkStaff = x.checkStaff, date = x.createDate, depName = "部门：" + x.depName, makeStaff = x.staffName, No = x.bomOrderNo, showdeport = true, deportStaff = "仓库：" + x.deportStaff
}).FirstOrDefault();
if (showPrice)
{
datas = bomService.BomOrderDetailList(no).ToList().Select(x => x.materialNo + "," + x.materialName + "," + x.materialModel + "," + x.Amount + "," + x.Price.ToString("N").Replace(",", "") + "," + (x.Amount * x.Price).ToString("N").Replace(",", "") + "," + (x.sendDate.HasValue ? x.sendDate.Value.ToString("yyyy-MM-dd") : "") + "," + x.remark).ToList(); // + x.Price.ToString("N").Replace(",", "") + "," + (x.Amount * x.Price).ToString("N").Replace(",", "") + ","
}
else
{
datas = bomService.BomOrderDetailList(no).ToList().Select(x => x.materialNo + "," + x.materialName + "," + x.materialModel + "," + x.Amount + "," + (x.sendDate.HasValue ? x.sendDate.Value.ToString("yyyy-MM-dd") : "") + "," + x.remark).ToList(); // + x.Price.ToString("N").Replace(",", "") + "," + (x.Amount * x.Price).ToString("N").Replace(",", "") + ","
}
}
break;
case "bomorderdetail":
if (Masterpage.CheckRight("bomorder_print"))
{
var sn = Convert.ToInt32(no);
var detail = bomService.BomOrderDetailOne(sn);
pm = bomService.BomOrderList(detail.bomOrderNo).Select(x => new PrintHeadModel {
checkStaff = x.checkStaff, date = x.createDate, depName = "部门：" + x.depName, makeStaff = x.staffName, No = x.bomOrderNo, showdeport = true, deportStaff = "仓库：" + x.deportStaff
}).FirstOrDefault();
datas = bomService.GetBomOrderBomDetailList(sn).ToList().Select(x => x.materialNo + "<br>" + x.materialName + "," + x.materialModel + "," + x.materialCate + "," + x.bomAmount + "," + (x.sendDate.HasValue ? x.sendDate.Value.ToString("yyyy-MM-dd") : "") + "," + x.remark).ToList();
}
break;
case "bill":
if (Masterpage.CheckRight("bill_print"))
{
var model = ServiceDB.Instance.QueryOneModel <V_BillCost>(" select * from V_BillCost where billNo='" + no + "'");
var list = ServiceDB.Instance.QueryModelList <V_BillCostDetail>(" select * from V_BillCostDetail where billNo='" + no + "'").ToList();
pm = new PrintHeadModel {
checkStaff = model.checkName, makeStaff = model.makeName, bossStaff = model.bossName, cfoStaff = model.cfoName, date = model.createDate, depName = "部门：" + model.depName, No = model.billNo, showdeport = false
};
datas = list.Select(x => x.billTitle + "," + x.cost + "," + x.billDate.ToString("yyyy-MM-dd") + "," + x.remark).ToList();
}
break;
case "purchase2":
if (Masterpage.CheckRight("purchase2_print"))
{
var model = ServiceDB.Instance.QueryOneModel <V_BillCost>(" select * from V_BillCost where billNo='" + no + "'");
var list = ServiceDB.Instance.QueryModelList <V_BillCostDetail>(" select * from V_BillCostDetail where billNo='" + no + "'").ToList();
pm = new PrintHeadModel {
checkStaff = model.checkName, makeStaff = model.makeName, bossStaff = model.bossName, cfoStaff = model.cfoName, date = model.createDate, depName = "部门：" + model.depName, No = model.billNo, showdeport = false
};
datas = list.Select(x => x.billTitle + "," + x.amount + "," + x.cost + "," + x.cost * x.amount + "," + x.billDate.ToString("yyyy-MM-dd") + "," + x.remark).ToList();
}
break;
case "delegateback":
if (Masterpage.CheckRight("delegateback_print"))
{
var model = ServiceDB.Instance.QueryOneModel <V_DelegateBackModel>(" select * from V_DelegateBackModel where backNo='" + no + "'");
var list = ServiceDB.Instance.QueryModelList <V_DelegateBackDetail>(" select * from V_DelegateBackDetail where backNo='" + no + "'").ToList();
pm = new PrintHeadModel {
checkStaff = model.checkStaff, date = model.backDate, depName = "供应商：" + model.supplierName, makeStaff = model.staffName, No = model.backNo, showdeport = true, deportStaff = "仓库：" + model.deportStaff, bossStaff = model.supplierName
};
datas = list.Select(x => (x.isProduct ? "货品" : "原料") + "," + x.materialNo + "," + x.materialName + "," + x.materialModel + "," + x.backAmount + "," + x.fromDelegateNo + "," + x.remark).ToList();
}
break;
case "stocksemi":
if (Masterpage.CheckRight("stockin_semi_print"))
{
showPrice = Masterpage.CheckRight("semishowmoney_print");
var model = ServiceDB.Instance.QueryOneModel <ProductSemi>(" select * from ProductSemi where semiNo='" + no + "'");
var list = ServiceDB.Instance.QueryModelList <ProductSemi>(" select * from ProductSemi where semiNo='" + no + "'").ToList();
var dep = ServiceDB.Instance.QueryOneModel <Department>("select d.* from Department as d inner join Employee as e on d.depId=e.depId where e.staffId=" + model.staffId);
pm = new PrintHeadModel {
checkStaff = model.checkStaff, makeStaff = model.staffName, bossStaff = "", cfoStaff = "", date = model.createDate, depName = dep != null ? "部门：" + dep.depName : "", No = model.semiNo, showdeport = false
};
datas = list.Select(x => x.proName + "," + x.proModel + "," + x.amount + "," + (showPrice?x.price.ToString():"") + "," + (showPrice?Math.Round((decimal)x.amount * x.price, 4).ToString():"") + "," + x.createDate.ToString("yyyy-MM-dd") + "," + x.remark).ToList();
}
break;
case "delegatesend":
if (Masterpage.CheckRight("delegate_send_print"))
{
showPrice = Masterpage.CheckRight("delegatesendshowmoney_print");
var model = ServiceDB.Instance.QueryOneModel <V_DelegateSendModel>(" select * from V_DelegateSendModel where sendNo='" + no + "'");
var list = ServiceDB.Instance.QueryModelList <V_DelegateSendDetailModel>(" select * from V_DelegateSendDetailModel where sendNo='" + no + "'").ToList();
//pm = new PrintHeadModel { checkStaff = model.checkStaff, makeStaff = model.staffName, bossStaff = "", cfoStaff = "", date = model.createDate, depName = model.depName, No = model.sendNo, showdeport = true };
//datas = list.Select(x => x.materialNo + "," + x.materialName + "," + x.materialModel + "," + x.realAmount + "," + (showPrice ? x.price.ToString() : "") + "," + (showPrice ? Math.Round((decimal)x.productAmount * x.price, 4).ToString() : "") + "," + x.remark).ToList();
var delegatenos = ServiceDB.Instance.QueryModelList <string>("select distinct delegateNo from DelegateSendDetail where sendNo='" + no + "' ").ToList();
data.showPrice = showPrice;
data.delegatenos = delegatenos;
data.title = title;
data.pm = model;
data.list = list;
return(View("~/Views/main/delegatesendprint.cshtml", data));
}
break;
default:
break;
}
#endregion
data.showPrice = showPrice;
data.title = title;
data.key = key;
data.pm = pm;
data.datas = datas;
return(View(data));
}
public App()
{
//InitializeComponent();
MainPage = new Masterpage();
}
