public void Save(T_RKMXModels model)
{
int result = 0;
string guid = string.Empty;
try
{
if (model.Tag == "Add")
{
model.DataModel.GUID = Guid.NewGuid().ToString("N");
guid = model.DataModel.GUID;
result = T_RKMXDomain.GetInstance().AddModelByRkdh(model.DataModel, model.RKDH);
}
else if (model.Tag == "Edit")
{
result = T_RKMXDomain.GetInstance().UpdateModel(model.DataModel, model.DataModel.MXID);
}
}
catch { }
Response.ContentType = "text/json";
if (result > 0)
{
string resultStr = JsonConvert.SerializeObject(new { statusCode = "200", message = "操作成功", guid = guid });
Response.Write(resultStr);
}
//Response.Write("{\"statusCode\":\"200\", \"message\":\"操作成功\",\"callbackType\":\"closeCurrentReloadTab\",\"forwardUrl\":\"/T_RKD/Index\"}");
else
{
Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}");
}
}
public ActionResult Index(T_RKMXModels evalModel, string id)
{
try
{
evalModel.currentPage = int.Parse(Request["pageNum"].ToString());
}
catch { }
string order = "";
try
{
order = Request["orderField"].ToString();
}
catch { }
if (order.Trim() == "${param.orderField}")
{
order = "";
}
ViewBag.RKDID = id;
int pagesize = Convert.ToInt32(evalModel.pageSize);
int pagecount = Convert.ToInt32(evalModel.pagecount);
int currentPage = Convert.ToInt32(evalModel.currentPage);
evalModel.DataModel = evalModel.DataModel ?? new T_RKMX();
evalModel.DataList = T_RKMXDomain.GetInstance().PageT_RKMX(evalModel.DataModel, evalModel.StartTime, evalModel.EndTime, currentPage, pagesize, out pagecount, out resultCount).Where(p => p.RKID == int.Parse(id)).ToList();
evalModel.resultCount = resultCount;
ViewData["ParaStr"] = ExportExcelPR(int.Parse(id));
return(View("~/Views/T_RKMX/Index.cshtml", evalModel));
}
public ActionResult Details(System.Int32 id)
{
T_RKDModels model = new T_RKDModels();
model.DataModel = T_RKDDomain.GetInstance().GetModelById(id);
model.RKMXList = T_RKMXDomain.GetInstance().GetT_RKMXByRkid(id);
CurUser = Session["UserModel"] as SysUser;
T_Person person = new T_Person();
person.PsQYID = (int)CurUser.UserCompanyID;
List <T_Person> personList = T_PersonDomain.GetInstance().GetAllT_Person(person);
////申请人
//if (!string.IsNullOrEmpty(model.DataModel.SQPE))
//{
// var sqr = personList.Where(p => p.PsID.ToString() == model.DataModel.SQPE).FirstOrDefault();
// model.SQRMC = (sqr != null && !string.IsNullOrEmpty(sqr.PsMZ)) ? sqr.PsMZ : "";
//}
////仓库管理人
//if (!string.IsNullOrEmpty(model.DataModel.CKGLRY))
//{
// var ckr = personList.Where(p => p.PsID.ToString() == model.DataModel.CKGLRY).FirstOrDefault();
// model.CKRMC = (ckr != null && !string.IsNullOrEmpty(ckr.PsMZ)) ? ckr.PsMZ : "";
//}
ViewData["ParaStr"] = ExportExcelPR(id);
return(View("~/Views/T_RKD/Details.cshtml", model));
}
public ActionResult Save(System.Int32 id, string tag)
{
T_RKMXModels model = new T_RKMXModels();
model.DataModel = new T_RKMX();
Int32 did = id;
if (tag != "Add")
{
model.DataModel = T_RKMXDomain.GetInstance().GetModelById(id);
did = model.DataModel.CKID;
}
//加载仓库列表
T_CKModels ckmode = new T_CKModels();
ckmode.DataModel = ckmode.DataModel ?? new T_CK();
ckmode.DataList = T_CKDomain.GetInstance().GetAllT_CK(ckmode.DataModel);
ViewData["CK"] = new SelectList(ckmode.DataList, "CKID", "CKMC");
//加载产品列表
T_YLCPModels ylcpQymode = new T_YLCPModels();
ylcpQymode.DataModel = ylcpQymode.DataModel ?? new T_YLCP();
ylcpQymode.DataList = T_YLCPDomain.GetInstance().GetAllT_YLCP(ylcpQymode.DataModel).Where(p => p.CPStatus == Convert.ToInt32("1")).ToList();
ViewData["YLCP"] = new SelectList(ylcpQymode.DataList, "CPID", "CPMC");
//加载入库单列表
T_RKDModels rkdQymode = new T_RKDModels();
rkdQymode.DataModel = rkdQymode.DataModel ?? new T_RKD();
T_RKD rkd = T_RKDDomain.GetInstance().GetModelById(did);
rkdQymode.DataList = new List <T_RKD>();
rkdQymode.DataList.Add(rkd);
ViewData["RKD"] = new SelectList(rkdQymode.DataList, "RKID", "RKMC");
//if (id != 0)
//{
// model.DataModel = T_RKMXDomain.GetInstance().GetModelById(id);
//}
model.Tag = tag;
return(View("~/Views/T_RKMX/Save.cshtml", model));
}
public void Delete(string guid)
{
int result = T_RKMXDomain.GetInstance().DeleteModelByGuid(guid);
Response.ContentType = "text/json";
if (result > 0)
{
Response.Write("{\"statusCode\":\"200\", \"message\":\"操作成功\",\"callbackType\":\"forward\",\"forwardUrl\":\"/T_RKD/Index\"}");
}
else
{
Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}");
}
}
public ActionResult Save(System.Int32 id, string tag)
{
//加载验收单
List <T_YSD> ysdList = new List <T_YSD>();
ysdList = T_YSDDomain.GetInstance().GetAllT_YSD(new T_YSD()).OrderByDescending(p => p.YSDH).ToList();
ViewData["YSD"] = new SelectList(ysdList, "YSDH", "YSDH");
//加载仓库列表
T_CKModels ckmode = new T_CKModels();
ckmode.DataModel = ckmode.DataModel ?? new T_CK();
ckmode.DataList = T_CKDomain.GetInstance().GetAllT_CK(ckmode.DataModel);
ViewData["CK"] = new SelectList(ckmode.DataList, "CKID", "CKMC");
//加载企业列表
T_SupQYModels supmode = new T_SupQYModels();
supmode.DataModel = supmode.DataModel ?? new T_SupQY();
supmode.DataList = T_SupQYDomain.GetInstance().GetAllT_SupQY(supmode.DataModel).Where(p => p.SupStatus == 1).ToList();
ViewData["SupID"] = new SelectList(supmode.DataList, "SupID", "SupMC");
T_RKDModels model = new T_RKDModels();
model.DataModel = new T_RKD();
CurUser = Session["UserModel"] as SysUser;
if (id != 0)
{
model.DataModel = T_RKDDomain.GetInstance().GetModelById(id);
model.RKMXList = T_RKMXDomain.GetInstance().GetT_RKMXByRkid(id);
}
else
{
model.DataModel.RKDH = T_RKDDomain.GetInstance().GetRkOrderNum(CurUser);
model.DataModel.RKCJR = CurUser.UserAccount;
model.DataModel.RKCJRQ = DateTime.Now;
}
//获取本企业下的人员列表
T_Person person = new T_Person();
person.PsQYID = (int)CurUser.UserCompanyID;
ViewBag.Persons = new SelectList(T_PersonDomain.GetInstance().GetAllT_Person(person), "PsMZ", "PsMZ");
model.Tag = tag;
model.RoleCode = GetRoleCode();
return(View("~/Views/T_RKD/Save.cshtml", model));
}
public ActionResult RKMXTable(System.Int32 id, string rkdh, int canEdit)
{
T_RKDModels model = new T_RKDModels();
if (id != 0)
{
model.RKMXList = T_RKMXDomain.GetInstance().GetT_RKMXByRkid(id);
}
else
{
model.RKMXList = T_RKMXDomain.GetInstance().GetT_RKMXByRkdh(rkdh);
}
ViewData["ISSH"] = canEdit;
return(View("~/Views/T_RKMX/RKMXTable.cshtml", model));
}
public void Delete(System.Int32 id)
{
Expression <Func <T_RKMX, bool> > where = p => (p.CKID == id);
var lst = T_RKMXDomain.GetInstance().GetAllModels <int>(where);
if (lst != null && lst.Count > 0)
{
Response.Write("{\"statusCode\":\"300\", \"message\":\"该仓库已有入库数据，不能删除！\"}");
return;
}
Expression <Func <T_CKMX, bool> > whereCKMX = p => (p.CKID == id);
var lstCKMX = T_CKMXDomain.GetInstance().GetAllModels <int>(whereCKMX);
if (lstCKMX != null && lstCKMX.Count > 0)
{
Response.Write("{\"statusCode\":\"300\", \"message\":\"该仓库已有出库数据，不能删除！\"}");
return;
}
Expression <Func <T_KC, bool> > whereKC = p => (p.CKID == id);
var lstKC = T_KCDomain.GetInstance().GetAllModels <int>(whereKC);
if (lstKC != null && lstKC.Count > 0)
{
Response.Write("{\"statusCode\":\"300\", \"message\":\"该仓库已有库存数据，不能删除！\"}");
return;
}
int result = T_CKDomain.GetInstance().DeleteModelById(id);
Response.ContentType = "text/json";
if (result > 0)
{
Response.Write("{\"statusCode\":\"200\", \"message\":\"操作成功\",\"callbackType\":\"forward\",\"forwardUrl\":\"/T_CK/Index\"}");
}
else
{
Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}");
}
}
public string ExportExcelPR(System.Int32 id)
{
//接收需要导出的数据
T_RKD ckdinfo = new T_RKD();
List <T_RKD> list = T_RKDDomain.GetInstance().GetListModelById(id);
if (list.Count > 0)
{
ckdinfo = list[0];
}
//采购单名称
string xsqyName = ckdinfo.YSDH;
List <T_RKMX> ckmxList = T_RKMXDomain.GetInstance().GetListModelById(id);
//命名导出表格的StringBuilder变量
StringBuilder sHtml = new StringBuilder(string.Empty);
//打印表头
sHtml.Append("<table border=\"0\" width=\"100%\">");
sHtml.Append("<tr height=\"40\"><td colspan=\"10\" align=\"center\" style='font-size:24px'><b>入库单" + "</b></td></tr>");
sHtml.Append("<tr height=\"40\"><td colspan=\"8\" align=\"left\">购买单位：" + xsqyName + "</td><td align=\"right\">日期：" + DateTime.Now.ToString("yyyy-MM-dd") + "</td><td align=\"right\">单据编号：" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + "</td></tr>");
sHtml.Append("</table>");
sHtml.Append("<table border=\"1\" width=\"100%\">");
//sHtml.Append("<tr height=\"40\"><td colspan=\"10\" align=\"center\" style='font-size:24px'><b>出库单" + "</b></td></tr>");
//sHtml.Append("<tr height=\"40\"><td colspan=\"8\" align=\"left\"> 购买单位：" + xsqyName + "</td><td align=\"right\">日期：" + DateTime.Now.ToString("yyyy-MM-dd") + "</td><td align=\"right\">单据编号：" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + "</td></tr>");
//打印列名
sHtml.Append("<tr height=\"30\" align=\"center\" ><td>商品名称</td><td>规格</td><td>生产厂家</td><td>单位</td><td>数量</td><td>单价</td>"
+ "<td>金额</td><td>批号</td><td>生产日期</td><td>注册证号</td></tr>");
//合计
double total = 0.0;
for (int i = 0; i < ckmxList.Count; i++)
{
T_RKMX ckmx = ckmxList[i];
//产品名称
string cpName = ckmx.T_YLCP.CPMC;
//规格
string cpGg = ckmx.T_YLCP.CPGG ?? "";
//单位
string cpDw = ckmx.T_YLCP.CPDW ?? "";
//数量
double cpDj = ckmx.CPNUM ?? 0;
//生成批号
string scPh = ckmx.T_YLCP.CPPH ?? "";
//生产日期
string scRq = "";
if (ckmx.T_YLCP.CPSCSJ != null)
{
scRq = ckmx.T_YLCP.CPSCSJ.Value.ToLongDateString();
}
//生产企业
string cpScqy = ckmx.T_YLCP.CPSCQY ?? "";
//单价
double cpPrice = ckmx.T_YLCP.CPPrice ?? 0.0;
//产品总价
double rowTotal = cpDj * cpPrice;
total = total + rowTotal;
//注册证号
string cpzczh = ckmx.T_YLCP.CPZCZ;
sHtml.Append("<tr height=\"30\" align=\"center\"><td>" + cpName
+ "</td><td>" + cpGg + "</td><td>" + cpScqy
+ "</td><td>" + cpDw + "</td><td>" + cpDj.ToString()
+ "</td><td>" + cpPrice.ToString() + "</td><td>" + rowTotal.ToString() + "</td><td>" + scPh + "</td><td>" + scRq
+ "</td><td>" + cpzczh
+ "</td></tr>");
}
//循环读取List集合
for (int i = 0; i < list.Count; i++)
{
}
//打印表尾
sHtml.Append("<tr height=\"40\" align=\"center\"><td>合计：</td><td colspan=\"9\">" + total + "</td></tr>");
sHtml.Append("</table>");
sHtml.Append("<table border=\"0\" width=\"100%\">");
sHtml.Append("<tr height=\"40\" align=\"center\"><td colspan=\"7\" align=\"left\">制单人：  </td><td align=\"right\">审核人：  </td><td align=\"right\">采购员：  </td><td align=\"center\">质检员：  </td></tr>");
sHtml.Append("</table>");
//调用输出Excel表的方法
return(sHtml.ToString());
//ExportToExcel("application/vnd.ms-excel", "出库单.xls", sHtml.ToString());
}
public string ExportExcelPR(System.Int32 id)
{
//获取需要打印的数据
T_RKD ckdinfo = new T_RKD();
List <T_RKD> list = T_RKDDomain.GetInstance().GetListModelById(id);
if (list.Count > 0)
{
ckdinfo = list[0];
}
//验收单号
string rkysdh = ckdinfo.YSDH;
//供货企业名称
T_RKMX rkdinfo = new T_RKMX();
List <T_RKMX> rkmxList = T_RKMXDomain.GetInstance().GetListModelById(id);
if (rkmxList.Count > 0)
{
rkdinfo = rkmxList[0];
}
string ghqy = rkdinfo.T_SupQY == null ? "" : rkdinfo.T_SupQY.SupMC;
//命名导出表格的StringBuilder变量
StringBuilder sHtml = new StringBuilder(string.Empty);
//打印表头
sHtml.Append("<table border=\"0\" width=\"100%\">"); //
sHtml.Append("<tr height=\"40\"><td colspan=\"12\" align=\"center\" style='font-size:24px'><b>入库单" + "</b></td></tr>");
sHtml.Append("<tr height=\"40\"><td colspan=\"6\" align=\"left\">供货企业：" + ghqy + "</td><td align=\"center\" colspan=\"4\">日期：" + DateTime.Now.ToString("yyyy-MM-dd") + "</td><td align=\"right\" colspan=\"2\">入库单号：" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + "</td></tr>");
sHtml.Append("</table>");
sHtml.Append("<table border=\"1\" width=\"100%\" style='border-collapse:collapse;border:1px solid black;'>"); // width=\"100%\"
sHtml.Append("<tr height=\"30\" align=\"center\" ><td>产品名称</td><td>产品规格</td><td>生产厂家</td><td>生产日期</td><td>单位</td><td>数量</td><td>单价</td>"
+ "<td>金额</td><td>产品批号</td><td>产品有效期</td><td>经营许可证号</td><td>注册证号</td></tr>");
//合计
double total = 0.0;
for (int i = 0; i < rkmxList.Count; i++)
{
T_RKMX rkmx = rkmxList[i];
//产品名称
string cpName = rkmx.T_YLCP.CPMC;
//规格
string cpGg = rkmx.T_YLCP.CPGG ?? "";
//单位
string cpDw = rkmx.T_YLCP.CPDW ?? "";
//数量
double cpDj = rkmx.CPNUM ?? 0;
//产品批号
string scPh = rkmx.CPPH ?? "";
//产品有效期
string yxq = "";
if (rkmx.CPYXQ != null)
{
yxq = rkmx.CPYXQ.Value.ToString("yyyyMMdd");
}
var scrq = "";
if (rkmx.CPSCRQ != null)
{
scrq = rkmx.CPSCRQ.Value.ToString("yyyyMMdd");
}
//生产企业
string cpScqy = rkdinfo.T_SupQY1 == null ? "" : rkdinfo.T_SupQY1.SupMC;
//单价
double cpPrice = Math.Round(rkmx.T_YLCP.CPPrice ?? 0.0, 2);
//产品总价
double rowTotal = Math.Round(cpDj * cpPrice, 2);
total = total + rowTotal;
//注册证号
string cpzczh = rkmx.T_YLCP.CPZCZ;
//经营许可证号
string xkzbh = rkmx.T_SupQY.SupXKZBH;
sHtml.Append("<tr height=\"30\" align=\"center\"><td>" + cpName
+ "</td><td>" + cpGg + "</td><td>" + cpScqy
+ "</td><td>" + scrq
+ "</td><td>" + cpDw + "</td><td>" + cpDj.ToString()
+ "</td><td>" + cpPrice.ToString("0.00") + "</td><td>" + rowTotal.ToString("0.00") + "</td><td>" + scPh + "</td><td>" + yxq
+ "</td><td>" + xkzbh
+ "</td><td>" + cpzczh
+ "</td></tr>");
}
//打印表尾
sHtml.Append("<tr height=\"40\" align=\"center\"><td colspan=\"5\">合计金额：（大写）" + MoneySmallToBig(total.ToString()) + "</td><td colspan=\"7\">（小写）" + total.ToString("0.00") + "</td></tr>");
sHtml.Append("</table>");
sHtml.Append("<table border=\"0\" width=\"100%\">"); // width =\"100%\"
Expression <Func <T_YSD, bool> > where = p => p.YSDH == ckdinfo.YSDH;
var ysd = T_YSDDomain.GetInstance().GetAllModels <int>(where).FirstOrDefault();
var cgdModel = new T_CGD();
if (ysd != null && ysd.YSID != 0 && !string.IsNullOrEmpty(ysd.CGDH))
{
Expression <Func <T_CGD, bool> > where1 = p => p.CGDH == ysd.CGDH;
cgdModel = T_CGDDomain.GetInstance().GetAllModels <int>(where1).FirstOrDefault();
}
sHtml.Append("<tr height=\"40\" align=\"center\"><td colspan=\"2\" align=\"left\">制单人： " + ckdinfo.RKCJR + "</td><td align=\"left\" colspan=\"4\">审核人： " + cgdModel.SHR + "</td><td align=\"left\" colspan=\"3\">采购员： " + cgdModel.CGPERSON + "</td><td align=\"left\" colspan=\"3\">质检员： </td></tr>");
sHtml.Append("</table>");
return(sHtml.ToString());
}