public void Save(T_XSMXModels 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_XSMXDomain.GetInstance().AddModelByXsdh(model.DataModel, model.XSDH);
}
else if (model.Tag == "Edit")
{
result = T_XSMXDomain.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_XSD/Index\"}");
else
{
Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}");
}
}
public JsonResult GetYLCPDetailsByMXID(int mxid)
{
var mxModel = T_XSMXDomain.GetInstance().GetModelById(mxid);
if (mxModel != null)
{
T_YLCP cp = T_YLCPDomain.GetInstance().GetCpDetailsById(mxModel.CPID);
if (cp != null)
{
string resultStr = JsonConvert.SerializeObject(new
{
CPID = cp.CPID,
CPBH = cp.CPBH,
SCQYMC = (cp.T_SupQY1 != null && !string.IsNullOrEmpty(cp.T_SupQY1.SupMC)) ? cp.T_SupQY1.SupMC : "",
CPGG = cp.CPGG,
CPXH = cp.CPXH,
CPDW = cp.CPDW,
XKZH = (cp.T_SupQY1 != null && !string.IsNullOrEmpty(cp.T_SupQY1.SupXKZBH)) ? cp.T_SupQY1.SupXKZBH : "",
ZCZH = cp.CPZCZ,
SCQYID = cp.CPSCQYID,
CPPrice = mxModel.XSJG,
SUPQYID = cp.CPGYSID,
SUPQYMC = (cp.T_SupQY != null && !string.IsNullOrEmpty(cp.T_SupQY.SupMC)) ? cp.T_SupQY.SupMC : "",
XSJG = cp.XSJG,
CPMC = cp.CPMC,
CPNUM = mxModel.CPSL,
CYTJ = cp.CCTJ
});
return(Json(resultStr));
}
}
return(Json(""));
}
public ActionResult Index(T_XSMXModels 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.XSDID = 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_XSMX();
evalModel.DataList = T_XSMXDomain.GetInstance().PageT_XSMX(evalModel.DataModel, evalModel.StartTime, evalModel.EndTime, currentPage, pagesize, out pagecount, out resultCount).Where(p => p.XSID == int.Parse(id)).ToList();
evalModel.resultCount = resultCount;
return(View("~/Views/T_XSMX/Index.cshtml", evalModel));
}
public void GetYLCP(string xsdid)
{
string result1 = "";
Dictionary <string, string> dict = new Dictionary <string, string>();
try
{
StringBuilder result = new StringBuilder();
result.Append("[[\"\",\"请选择\"]");
//result.Append("[");
if (string.IsNullOrEmpty(xsdid))
{
result.Append("]");
result1 = result.ToString();
}
T_XSMX xsmx = new T_XSMX();
xsmx.XSID = int.Parse(xsdid);
var list = T_XSMXDomain.GetInstance().GetAllT_XSMX(xsmx);
foreach (var item in list)
{
result.Append(",[");
result.Append("\"" + item.T_YLCP.CPID + "\",");
result.Append("\"" + item.T_YLCP.CPMC + "\"");
result.Append("]");
}
result.Append("]");
result1 = result.ToString();
}
catch (Exception ex)
{
}
Response.ContentType = "text/json";
Response.Write(result1);
}
public ActionResult Save(System.Int32 id, string tag)
{
//加载购买商商企业列表
T_CusQYModels cusQymode = new T_CusQYModels();
cusQymode.DataModel = cusQymode.DataModel ?? new T_CusQY();
cusQymode.DataList = T_CusQYDomain.GetInstance().GetAllT_CusQY(cusQymode.DataModel).Where(p => p.CusStatus == Convert.ToInt32("1")).ToList();
ViewData["CusQY"] = new SelectList(cusQymode.DataList, "CusID", "CusMC");
//加载销售人员列表
T_PersonModels perQymode = new T_PersonModels();
perQymode.DataModel = perQymode.DataModel ?? new T_Person();
perQymode.DataList = T_PersonDomain.GetInstance().GetAllT_Person(perQymode.DataModel);
ViewData["Person"] = new SelectList(perQymode.DataList, "PsMZ", "PsMZ");
//加载销售合同列表
//T_XSHTModels xshtQymode = new T_XSHTModels();
//xshtQymode.DataModel = xshtQymode.DataModel ?? new T_XSHT();
//xshtQymode.DataList = T_XSHTDomain.GetInstance().GetAllT_XSHT(xshtQymode.DataModel);
//ViewData["XSHT"] = new SelectList(xshtQymode.DataList, "HTID", "HTMC");
//加载产品列表
T_YLCPModels ylcpmode = new T_YLCPModels();
ylcpmode.DataModel = ylcpmode.DataModel ?? new T_YLCP();
ylcpmode.DataList = T_YLCPDomain.GetInstance().GetAllT_YLCP(ylcpmode.DataModel).Where(p => p.CPStatus == 1).ToList();
ViewData["YLCP"] = new SelectList(ylcpmode.DataList, "CPID", "CPMC");
T_XSDModels model = new T_XSDModels();
model.DataModel = new T_XSD();
CurUser = Session["UserModel"] as SysUser;
if (id != 0)
{
model.DataModel = T_XSDDomain.GetInstance().GetModelById(id);
model.XSMXList = T_XSMXDomain.GetInstance().GetT_XSMXByXsid(id);
}
else
{
model.DataModel.XSDH = T_XSDDomain.GetInstance().GetXsOrderNum(CurUser);
model.DataModel.XSCJR = CurUser.UserAccount;
model.DataModel.XSCJRQ = DateTime.Now;
}
model.RoleCode = GetRoleCode();
model.Tag = tag;
return(View("~/Views/T_XSD/Save.cshtml", model));
}
public void Delete(string guid)
{
int result = T_XSMXDomain.GetInstance().DeleteModelByGuid(guid);
Response.ContentType = "text/json";
if (result > 0)
{
Response.Write("{\"statusCode\":\"200\", \"message\":\"操作成功\",\"callbackType\":\"forward\",\"forwardUrl\":\"/T_XSD/Index\"}");
}
else
{
Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}");
}
}
public ActionResult Save(System.Int32 id, string tag)
{
T_XSMXModels model = new T_XSMXModels();
model.DataModel = new T_XSMX();
Int32 did = id;
if (tag != "Add")
{
model.DataModel = T_XSMXDomain.GetInstance().GetModelById(id);
did = model.DataModel.XSID ?? 0;
}
//加载销售单列表
T_XSDModels xsdmode = new T_XSDModels();
xsdmode.DataModel = xsdmode.DataModel ?? new T_XSD();
// xsdmode.DataList = T_XSDDomain.GetInstance().GetAllT_XSD(xsdmode.DataModel);
//加载产品列表
T_YLCPModels ylcpmode = new T_YLCPModels();
ylcpmode.DataModel = ylcpmode.DataModel ?? new T_YLCP();
ylcpmode.DataList = T_YLCPDomain.GetInstance().GetAllT_YLCP(ylcpmode.DataModel).Where(p => p.CPStatus == Convert.ToInt32("1")).ToList();
ViewData["YLCP"] = new SelectList(ylcpmode.DataList, "CPID", "CPMC");
T_XSD rkd = T_XSDDomain.GetInstance().GetModelById(did);
xsdmode.DataList = new List <T_XSD>();
xsdmode.DataList.Add(rkd);
ViewData["XSD"] = new SelectList(xsdmode.DataList, "XSID", "XSMC");
//if (id != 0)
//{
// model.DataModel = T_XSMXDomain.GetInstance().GetModelById(id);
//}
model.Tag = tag;
return(View("~/Views/T_XSMX/Save.cshtml", model));
}
public ActionResult XSMXTable(System.Int32 id, string xsdh, int canEdit, int isSH)
{
T_XSDModels model = new T_XSDModels();
model.DataModel = new T_XSD();
model.DataModel.XSFLAG = isSH;
if (id != 0)
{
model.XSMXList = T_XSMXDomain.GetInstance().GetT_XSMXByXsid(id);
}
else
{
model.XSMXList = T_XSMXDomain.GetInstance().GetT_XSMXByXsdh(xsdh);
}
ViewData["canEdit"] = canEdit;
return(View("~/Views/T_XSMX/XSMXTable.cshtml", model));
}
public ActionResult XSDSPIndex(System.Int32 id, string tag)
{
//加载购买商商企业列表
T_CusQYModels cusQymode = new T_CusQYModels();
cusQymode.DataModel = cusQymode.DataModel ?? new T_CusQY();
cusQymode.DataList = T_CusQYDomain.GetInstance().GetAllT_CusQY(cusQymode.DataModel).Where(p => p.CusStatus == Convert.ToInt32("1")).ToList();
ViewData["CusQY"] = new SelectList(cusQymode.DataList, "CusID", "CusMC");
//加载销售人员列表
T_PersonModels perQymode = new T_PersonModels();
perQymode.DataModel = perQymode.DataModel ?? new T_Person();
perQymode.DataList = T_PersonDomain.GetInstance().GetAllT_Person(perQymode.DataModel);
ViewData["Person"] = new SelectList(perQymode.DataList, "PsID", "PsMZ");
T_XSDModels model = new T_XSDModels();
model.DataModel = new T_XSD();
T_XSMX xsmodel = new T_XSMX();
if (id != 0)
{
model.DataModel = T_XSDDomain.GetInstance().GetModelById(id);
model.XSMXList = T_XSMXDomain.GetInstance().GetAllT_XSMX(xsmodel);
if (model.XSMXList.Count > 0)
{
model.XSMXList = model.XSMXList.Where(p => p.XSID == id).ToList();
}
}
model.Tag = tag;
return(View("~/Views/T_XSD/XSDSPIndex.cshtml", model));
}
public void ExportExcel(ExcelModel eModel)
{
var curModel = new T_XSMX();
if (eModel.SCQYID != null)
{
T_SupQY qycp = new T_SupQY();
qycp.SupID = (int)eModel.SCQYID;
curModel.T_YLCP.T_SupQY1 = qycp;
}
if (eModel.CPID != null)
{
curModel.CPID = (int)eModel.CPID;
}
int pagesize = eModel.PageSize;
int pagecount = 0;
int currentPage = eModel.PageNum;
var DataList = T_XSMXDomain.GetInstance().PageT_XSMX(curModel, eModel.StartDate, eModel.EndDate, currentPage, pagesize, out pagecount, out resultCount);
var str = ExportExcelPR(DataList);
//调用输出Excel表的方法
ExportToExcel("application/vnd.ms-excel", "销售汇总.xls", str);
}
public ActionResult Details(ExcelModel eModel)
{
var curModel = new T_XSMX();
if (eModel.SCQYID != null)
{
T_SupQY qycp = new T_SupQY();
qycp.SupID = (int)eModel.SCQYID;
curModel.T_YLCP.T_SupQY1 = qycp;
}
if (eModel.CPID != null)
{
curModel.CPID = (int)eModel.CPID;
}
int pagesize = eModel.PageSize;
int pagecount = 0;
int currentPage = eModel.PageNum;
var DataList = T_XSMXDomain.GetInstance().PageT_XSMX(curModel, eModel.StartDate, eModel.EndDate, currentPage, pagesize, out pagecount, out resultCount);
ViewData["ParaStr"] = ExportExcelPR(DataList);
return(View("~/Views/T_XSHZ/Details.cshtml", eModel));
}
public int resultCount = 0; // 总条数
// GET: T_XSHZ
public ActionResult Index(T_XSMXModels evalModel)
{
try
{
evalModel.currentPage = int.Parse(Request["pageNum"].ToString());
}
catch { }
string order = "";
string qyid = "";
try
{
order = Request["orderField"].ToString();
}
catch { }
if (order.Trim() == "${param.orderField}")
{
order = "";
}
evalModel.DataModel = evalModel.DataModel ?? new T_XSMX();
evalModel.DataModel.T_YLCP = evalModel.DataModel.T_YLCP ?? new T_YLCP();
//加载产品生产企业
T_SupQYModels qymode = new T_SupQYModels();
qymode.DataModel = qymode.DataModel ?? new T_SupQY();
qymode.DataList = T_SupQYDomain.GetInstance().GetAllT_SupQY(qymode.DataModel);
ViewData["QY"] = new SelectList(qymode.DataList, "SupID", "SupMC");
if (Request["QYList"] != null)
{
qyid = Request["QYList"].ToString();
if (!String.IsNullOrEmpty(qyid))
{
T_SupQY qycp = new T_SupQY();
qycp.SupID = int.Parse(qyid);
evalModel.DataModel.T_YLCP.T_SupQY1 = qycp;
}
}
ViewData["QYList"] = qyid;
Expression <Func <T_YLCP, bool> > where = PredicateBuilder.True <T_YLCP>();
var lst = T_YLCPDomain.GetInstance().GetAllModels <int>(where);
ViewData["XSHZ_YLCP"] = new SelectList(lst, "CPID", "CPMC");
var cpid = "";
if (Request["XSHZ_CPID"] != null)
{
cpid = Request["XSHZ_CPID"].ToString();
if (!String.IsNullOrEmpty(cpid))
{
evalModel.DataModel.CPID = int.Parse(cpid);
}
}
ViewData["XSHZ_CPID"] = cpid;
int pagesize = Convert.ToInt32(evalModel.pageSize);
int pagecount = Convert.ToInt32(evalModel.pagecount);
int currentPage = Convert.ToInt32(evalModel.currentPage);
evalModel.DataModel = evalModel.DataModel ?? new T_XSMX();
evalModel.DataList = T_XSMXDomain.GetInstance().PageT_XSMX(evalModel.DataModel, evalModel.StartTime, evalModel.EndTime, currentPage, pagesize, out pagecount, out resultCount);
evalModel.resultCount = resultCount;
var totalNum = 0;
if (evalModel.DataList != null && evalModel.DataList.Count > 0)
{
evalModel.DataList.ForEach(p =>
{
totalNum += (p.CPSL ?? 0);
});
}
ViewBag.TotalNum = totalNum;
return(View("~/Views/T_XSHZ/Index.cshtml", evalModel));
}
