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 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 T_XSDModels()
{
base.XSMXList = base.XSMXList ?? new List <T_XSMX>();
T_XSMXModel = new T_XSMX();
}
