public ActionResult ToExcel()
{
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
string CompanyID = this.CompanyID;
int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1);
int PageSize = WebUtil.GetFormValue <int>("PageSize", Int32.MaxValue);
string EquipmentName = WebUtil.GetFormValue <string>("EquipmentName");
string Remark = WebUtil.GetFormValue <string>("Remark", string.Empty);
string EquipmentNum = WebUtil.GetFormValue <string>("EquipmentNum", string.Empty);
int Status = WebUtil.GetFormValue <int>("Status", 0);
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("EquipmentName", EquipmentName);
dic.Add("Remark", Remark);
dic.Add("EquipmentNum", EquipmentNum);
dic.Add("Status", Status.ToString());
string result = client.Execute(EquipmentApiName.EquipmentApiName_GetPage, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <EquipmentEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <EquipmentEntity> >(result);
List <EquipmentEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("编号"));
dt.Columns.Add(new DataColumn("名称"));
dt.Columns.Add(new DataColumn("是否授权"));
dt.Columns.Add(new DataColumn("授权标识符"));
dt.Columns.Add(new DataColumn("状态"));
dt.Columns.Add(new DataColumn("备注"));
foreach (EquipmentEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.EquipmentNum;
row[1] = t.EquipmentName;
row[2] = EnumHelper.GetEnumDesc <EBool>(t.IsImpower);
row[3] = t.Flag;
row[4] = EnumHelper.GetEnumDesc <EEquipmentStatus>(t.Status);
row[5] = t.Remark;
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("设备管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("设备管理", "设备管理", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
/// <summary>
/// 查询销售订单分页列表
/// </summary>
/// <returns></returns>
public ActionResult GetOrderList()
{
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1);
int PageSize = WebUtil.GetFormValue <int>("PageSize", 10);
string OrderNum = WebUtil.GetFormValue <string>("OrderNum");
int OrderType = WebUtil.GetFormValue <int>("OrderType", 0);
string CusNum = WebUtil.GetFormValue <string>("CusNum");
string CusName = WebUtil.GetFormValue <string>("CusName");
string Contact = WebUtil.GetFormValue <string>("Contact");
string Phone = WebUtil.GetFormValue <string>("Phone");
string ContractOrder = WebUtil.GetFormValue <string>("ContractOrder");
string ContractSn = WebUtil.GetFormValue <string>("ContractSn");
int AuditeStatus = WebUtil.GetFormValue <int>("AuditeStatus", -1);
int Status = WebUtil.GetFormValue <int>("Status", 0);
string BeginTime = WebUtil.GetFormValue <string>("BeginTime");
string EndTime = WebUtil.GetFormValue <string>("EndTime");
string BeginOrderTime = WebUtil.GetFormValue <string>("BeginOrderTime");
string EndOrderTime = WebUtil.GetFormValue <string>("EndOrderTime");
string BeginSendTime = WebUtil.GetFormValue <string>("BeginSendTime");
string EndSendTime = WebUtil.GetFormValue <string>("EndSendTime");
Bill <SaleOrderEntity, SaleDetailEntity> bill = new SaleOrder(CompanyID);
SaleOrderEntity entity = new SaleOrderEntity();
entity.CompanyID = CompanyID;
entity.OrderNum = OrderNum;
entity.OrderType = OrderType;
entity.CusNum = CusNum;
entity.CusName = CusName;
entity.Contact = Contact;
entity.Phone = Phone;
entity.ContractOrder = ContractOrder;
entity.ContractSn = ContractSn;
entity.AuditeStatus = AuditeStatus;
entity.Status = Status;
entity.BeginTime = BeginTime;
entity.EndTime = EndTime;
entity.BeginOrderTime = BeginOrderTime;
entity.EndOrderTime = EndOrderTime;
entity.BeginSendTime = BeginSendTime;
entity.EndSendTime = EndSendTime;
PageInfo pageInfo = new PageInfo()
{
PageIndex = PageIndex, PageSize = PageSize
};
List <SaleOrderEntity> listResult = bill.GetList(entity, ref pageInfo);
DataListResult <SaleOrderEntity> dataResult = new DataListResult <SaleOrderEntity>()
{
Code = (int)EResponseCode.Success,
Message = "响应成功",
Result = listResult,
PageInfo = pageInfo
};
return(Content(JsonHelper.SerializeObject(dataResult)));
}
public ActionResult ToExcel()
{
string CompanyID = this.CompanyID;
int PageIndex = 1;
int PageSize = Int32.MaxValue;
string OrderNum = WebUtil.GetFormValue <string>("OrderNum");
int Status = WebUtil.GetFormValue <int>("Status", 0);
string ContractOrder = WebUtil.GetFormValue <string>("ContractOrder", string.Empty);
string BeginTime = WebUtil.GetFormValue <string>("BeginTime", string.Empty);
string EndTime = WebUtil.GetFormValue <string>("EndTime", string.Empty);
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("OrderNum", OrderNum);
dic.Add("StorageNum", this.DefaultStorageNum);
dic.Add("Status", Status.ToString());
dic.Add("ContractOrder", ContractOrder);
dic.Add("BeginTime", BeginTime);
dic.Add("EndTime", EndTime);
string result = client.Execute(CheckApiName.CheckApiName_GetOrderList, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <InventoryOrderEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <InventoryOrderEntity> >(result);
List <InventoryOrderEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("盘点单号"));
dt.Columns.Add(new DataColumn("盘点类型"));
dt.Columns.Add(new DataColumn("关联单号"));
dt.Columns.Add(new DataColumn("状态"));
dt.Columns.Add(new DataColumn("制单人"));
dt.Columns.Add(new DataColumn("制单时间"));
foreach (InventoryOrderEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.OrderNum;
row[1] = EnumHelper.GetEnumDesc <ECheckType>(t.Type);
row[2] = t.ContractOrder;
row[3] = EnumHelper.GetEnumDesc <EAudite>(t.Status);
row[4] = t.CreateUserName;
row[5] = t.CreateTime.To("yyyy-MM-dd");
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("盘点管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("盘点管理", "盘点单", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
public ActionResult ToExcel()
{
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
string CompanyID = this.CompanyID;
int PageIndex = 1;
int PageSize = Int32.MaxValue;
string BillNum = WebUtil.GetFormValue <string>("BillNum", string.Empty);
string CateNum = WebUtil.GetFormValue <string>("CateNum", string.Empty);
int BillType = (int)EFinanceType.BillReceivable;
string FromName = WebUtil.GetFormValue <string>("FromName", string.Empty);
string ToName = WebUtil.GetFormValue <string>("ToName", string.Empty);
string Title = WebUtil.GetFormValue <string>("Title", string.Empty);
string ContractNum = WebUtil.GetFormValue <string>("ContractNum", string.Empty);
string BeginTime = WebUtil.GetFormValue <string>("BeginTime", string.Empty);
string EndTime = WebUtil.GetFormValue <string>("EndTime", string.Empty);
int Status = WebUtil.GetFormValue <int>("Status", 0);
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("BillNum", BillNum);
dic.Add("CateNum", CateNum);
dic.Add("BillType", BillType.ToString());
dic.Add("Status", Status.ToString());
dic.Add("FromName", FromName);
dic.Add("ToName", ToName);
dic.Add("Title", Title);
dic.Add("ContractNum", ContractNum);
dic.Add("BeginTime", BeginTime);
dic.Add("EndTime", EndTime);
string result = client.Execute(FinanceBillApiName.FinanceBillApiName_GetPage, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <FinanceBillEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <FinanceBillEntity> >(result);
List <FinanceBillEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("流水号"));
dt.Columns.Add(new DataColumn("名称"));
dt.Columns.Add(new DataColumn("分类"));
dt.Columns.Add(new DataColumn("付款方"));
dt.Columns.Add(new DataColumn("应收金额"));
dt.Columns.Add(new DataColumn("实收金额"));
dt.Columns.Add(new DataColumn("剩余金额"));
dt.Columns.Add(new DataColumn("状态"));
dt.Columns.Add(new DataColumn("创建时间"));
foreach (FinanceBillEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.BillNum;
row[1] = t.Title;
row[2] = t.CateName;
row[3] = t.FromName;
row[4] = t.Amount.ToString("0.00");
row[5] = t.RealPayAmount.ToString("0.00");
row[6] = t.LeavAmount.ToString("0.00");
row[7] = EnumHelper.GetEnumDesc <EFinanceStatus>(t.Status);
row[8] = t.CreateTime.To("yyyy-MM-dd");
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("应收管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("应收管理", "应收管理", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
public ActionResult ToOutReportListExcel()
{
string BarCode = WebUtil.GetFormValue <string>("BarCode");
string ProductName = WebUtil.GetFormValue <string>("ProductName");
string StorageNum = this.DefaultStorageNum;
string CusNum = WebUtil.GetFormValue <string>("CusNum");
string CusName = WebUtil.GetFormValue <string>("CusName");
string BeginTime = WebUtil.GetFormValue <string>("BeginTime");
string EndTime = WebUtil.GetFormValue <string>("EndTime");
int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1);
int PageSize = WebUtil.GetFormValue <int>("PageSize", 10);
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("BarCode", BarCode);
dic.Add("ProductName", ProductName);
dic.Add("StorageNum", StorageNum);
dic.Add("CusNum", CusNum);
dic.Add("CusName", CusName);
dic.Add("BeginTime", BeginTime);
dic.Add("EndTime", EndTime);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
ITopClient client = new TopClientDefault();
string result = client.Execute(OutStorageApiName.OutStorageApiName_GetDetailList, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <OutStoDetailEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <OutStoDetailEntity> >(result);
List <OutStoDetailEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("产品名称"));
dt.Columns.Add(new DataColumn("产品编号"));
dt.Columns.Add(new DataColumn("产品规格"));
dt.Columns.Add(new DataColumn("产品批次"));
dt.Columns.Add(new DataColumn("入库单号"));
dt.Columns.Add(new DataColumn("数量"));
dt.Columns.Add(new DataColumn("单价"));
dt.Columns.Add(new DataColumn("总价"));
dt.Columns.Add(new DataColumn("客户"));
dt.Columns.Add(new DataColumn("出库时间"));
foreach (OutStoDetailEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.ProductName;
row[1] = t.BarCode;
row[2] = t.Size;
row[3] = t.BatchNum;
row[4] = t.OrderNum;
row[5] = t.Num.ToString("0.00");
row[6] = t.OutPrice.ToString("0.00");
row[7] = t.Amount.ToString("0.00");
row[8] = t.CusName;
row[9] = t.CreateTime.To("yyyy-MM-dd");
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("出库单详细报表{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("出库单详细报表", "出库单详细报表", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
public ActionResult ToExcel()
{
DataResult returnResult = null;
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
string CompanyID = this.CompanyID;
int PageIndex = 1;
int PageSize = Int32.MaxValue;
string StorageNum = WebUtil.GetFormValue <string>("StorageNum");
string StorageName = WebUtil.GetFormValue <string>("StorageName", string.Empty);
string StorageType = WebUtil.GetFormValue <string>("StorageType", string.Empty);
string DepartNum = WebUtil.GetFormValue <string>("DepartNum", string.Empty);
int Status = WebUtil.GetFormValue <int>("Status", 0);
int IsForbid = WebUtil.GetFormValue <int>("IsForbid", -1);
int IsDefault = WebUtil.GetFormValue <int>("IsDefault", -1);
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("StorageNum", StorageNum);
dic.Add("StorageName", StorageName);
dic.Add("StorageType", StorageType);
dic.Add("DepartNum", DepartNum);
dic.Add("Status", Status.ToString());
dic.Add("IsForbid", IsForbid.ToString());
dic.Add("IsDefault", IsDefault.ToString());
string result = client.Execute(StorageApiName.StorageApiName_GetPage, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <StorageEntity> dataResult = JsonHelper.DeserializeObject <DataListResult <StorageEntity> >(result);
List <StorageEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("仓库编号"));
dt.Columns.Add(new DataColumn("仓库名称"));
dt.Columns.Add(new DataColumn("租赁时间"));
dt.Columns.Add(new DataColumn("所属部门"));
dt.Columns.Add(new DataColumn("仓库类型"));
dt.Columns.Add(new DataColumn("是否禁用"));
dt.Columns.Add(new DataColumn("是否默认"));
dt.Columns.Add(new DataColumn("地址"));
dt.Columns.Add(new DataColumn("面积"));
dt.Columns.Add(new DataColumn("联系人"));
dt.Columns.Add(new DataColumn("电话"));
foreach (StorageEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.StorageNum;
row[1] = t.StorageName;
row[2] = t.LeaseTime.To("yyyy-MM-dd");
row[3] = t.DepartName;
row[4] = EnumHelper.GetEnumDesc <EStorageType>(t.StorageType);
row[5] = EnumHelper.GetEnumDesc <EBool>(t.IsForbid);
row[6] = EnumHelper.GetEnumDesc <EBool>(t.IsDefault);
row[7] = t.Address;
row[8] = t.Area.ToString("0.00");
row[9] = t.Contact;
row[10] = t.Phone;
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("仓库管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("仓库管理", "仓库", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
public ActionResult ToExcel()
{
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
string CompanyID = this.CompanyID;
int PageIndex = 1;
int PageSize = Int32.MaxValue;
string CateName = WebUtil.GetFormValue <string>("CateName", string.Empty);
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("CateName", CateName);
string result = client.Execute(FinanceCateApiName.FinanceCateApiName_GetPage, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <FinanceCateEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <FinanceCateEntity> >(result);
List <FinanceCateEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("类别编号"));
dt.Columns.Add(new DataColumn("类别名称"));
dt.Columns.Add(new DataColumn("创建时间"));
foreach (FinanceCateEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.CateNum;
row[1] = t.CateName;
row[2] = t.CreateTime.To("yyyy-MM-dd");
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("财务分类管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("财务分类管理", "财务分类", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
public ActionResult ToExcel()
{
string CompanyID = this.CompanyID;
int PageIndex = 1;
int PageSize = Int32.MaxValue;
string CusNum = WebUtil.GetFormValue <string>("CusNum", string.Empty);
string CusName = WebUtil.GetFormValue <string>("CusName", string.Empty);
string Phone = WebUtil.GetFormValue <string>("Phone", string.Empty);
int CusType = WebUtil.GetFormValue <int>("CusType", -1);
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("CusNum", CusNum);
dic.Add("CusName", CusName);
dic.Add("Phone", Phone);
dic.Add("CusType", CusType.ToString());
string result = client.Execute(CustomerApiName.CustomerApiName_GetAddressPage, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <CusAddressEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <CusAddressEntity> >(result);
List <CusAddressEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("客户编号"));
dt.Columns.Add(new DataColumn("客户名称"));
dt.Columns.Add(new DataColumn("地址"));
dt.Columns.Add(new DataColumn("联系人"));
dt.Columns.Add(new DataColumn("电话"));
dt.Columns.Add(new DataColumn("备注"));
dt.Columns.Add(new DataColumn("邮箱"));
dt.Columns.Add(new DataColumn("传真"));
dt.Columns.Add(new DataColumn("创建时间"));
foreach (CusAddressEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.CusNum;
row[1] = t.CusName;
row[2] = t.Address;
row[3] = t.Contact;
row[4] = t.Phone;
row[5] = t.Remark;
row[6] = t.Email;
row[7] = t.Fax;
row[8] = t.CreateTime.To("yyyy-MM-dd");
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("客户管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("客户管理", "客户", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
public ActionResult ToExcel()
{
string CompanyID = this.CompanyID;
int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1);
int PageSize = Int32.MaxValue;
string ReportNum = WebUtil.GetFormValue <string>("ReportNum");
string ReportName = WebUtil.GetFormValue <string>("ReportName");
int ReportType = WebUtil.GetFormValue <int>("ReportType", 0);
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("ReportNum", ReportNum);
dic.Add("ReportName", ReportName);
dic.Add("ReportType", ReportType.ToString());
string result = client.Execute(ReportApiName.ReportApiName_GetList, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <ReportsEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <ReportsEntity> >(result);
List <ReportsEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("编号"));
dt.Columns.Add(new DataColumn("报表名称"));
dt.Columns.Add(new DataColumn("报表类型"));
dt.Columns.Add(new DataColumn("是否禁用"));
dt.Columns.Add(new DataColumn("备注"));
dt.Columns.Add(new DataColumn("数据源类型"));
dt.Columns.Add(new DataColumn("数据源"));
dt.Columns.Add(new DataColumn("文件路径"));
foreach (ReportsEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.ReportNum;
row[1] = t.ReportName;
row[2] = EnumHelper.GetEnumDesc <EReportType>(t.ReportType);
row[3] = EnumHelper.GetEnumDesc <EBool>(t.Status);
row[4] = t.Remark;
row[5] = EnumHelper.GetEnumDesc <EDataSourceType>(t.DsType);
row[6] = t.DataSource;
row[7] = t.FileName;
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("自定义报表{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("自定义报表", "报表", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
public ActionResult ToExcel()
{
string UserCode = WebUtil.GetFormValue <string>("UserCode", string.Empty);
string UserName = WebUtil.GetFormValue <string>("UserName", string.Empty);
string RoleNum = WebUtil.GetFormValue <string>("RoleNum", string.Empty);
string DepartNum = WebUtil.GetFormValue <string>("DepartNum", string.Empty);
string CompanyID = this.CompanyID;
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("pageIndex", "1");
dic.Add("pageSize", Int32.MaxValue.ToString());
dic.Add("UserCode", UserCode);
dic.Add("UserName", UserName);
dic.Add("RoleNum", RoleNum);
dic.Add("DepartNum", DepartNum);
string result = client.Execute(UserApiName.UserApiName_GetList_Page, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <AdminEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <AdminEntity> >(result);
List <AdminEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("用户名"));
dt.Columns.Add(new DataColumn("工号"));
dt.Columns.Add(new DataColumn("真名"));
dt.Columns.Add(new DataColumn("邮箱"));
dt.Columns.Add(new DataColumn("手机"));
dt.Columns.Add(new DataColumn("固定电话"));
dt.Columns.Add(new DataColumn("创建时间"));
dt.Columns.Add(new DataColumn("登录次数"));
dt.Columns.Add(new DataColumn("部门"));
dt.Columns.Add(new DataColumn("角色"));
dt.Columns.Add(new DataColumn("备注"));
foreach (AdminEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.UserName;
row[1] = t.UserCode;
row[2] = t.RealName;
row[3] = t.Email;
row[4] = t.Mobile;
row[5] = t.Phone;
row[6] = t.CreateTime.To("yyyy-MM-dd");
row[7] = t.LoginCount;
row[8] = t.DepartName;
row[9] = t.RoleName;
row[10] = t.Remark;
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("用户管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("用户管理", "用户管理", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
public ActionResult ToExcel()
{
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
string CompanyID = this.CompanyID;
int PageIndex = 1;
int PageSize = Int32.MaxValue;
string TabName = WebUtil.GetFormValue <string>("TabName", string.Empty);
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("TabName", TabName);
string result = client.Execute(SequenceApiName.SequenceApiName_GetOrderList, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <SequenceEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <SequenceEntity> >(result);
List <SequenceEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("表名"));
dt.Columns.Add(new DataColumn("类型1"));
dt.Columns.Add(new DataColumn("规则1"));
dt.Columns.Add(new DataColumn("长度1"));
dt.Columns.Add(new DataColumn("连接符"));
dt.Columns.Add(new DataColumn("类型2"));
dt.Columns.Add(new DataColumn("规则2"));
dt.Columns.Add(new DataColumn("长度2"));
foreach (SequenceEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.TabName;
row[1] = EnumHelper.GetEnumDesc <ESequence>(t.FirstType);
row[2] = t.FirstRule;
row[3] = t.FirstLength;
row[4] = t.JoinChar;
row[5] = EnumHelper.GetEnumDesc <ESequence>(t.SecondType);
row[6] = t.SecondRule;
row[7] = t.SecondLength;
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("标识符管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("标识符管理", "标识符管理", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
/// <summary>
/// 用户登录
/// </summary>
/// <returns></returns>
public ActionResult Login()
{
string CompanyNum = WebUtil.GetFormValue <string>("CompanyNum", string.Empty);
string UserName = WebUtil.GetFormValue <string>("UserName", string.Empty);
string PassWord = WebUtil.GetFormValue <string>("PassWord", string.Empty);
Dictionary <string, string> dic = new Dictionary <string, string>();
ITopClient client = new TopClientDefault();
dic.Add("CompanyNum", CompanyNum);
string result = client.Execute(CompanyApiName.CompanyApiName_GetSingle, dic);
if (result.IsEmpty())
{
DataResult dataResult = new DataResult()
{
Code = (int)EResponseCode.Exception, Message = "公司不存在或公司编号错误"
};
return(Content(JsonHelper.SerializeObject(dataResult)));
}
DataResult <CompanyEntity> CompanyResult = JsonConvert.DeserializeObject <DataResult <CompanyEntity> >(result);
CompanyEntity CompanyEntity = CompanyResult.Result;
if (CompanyEntity.IsNull())
{
DataResult dataResult = new DataResult()
{
Code = (int)EResponseCode.Exception, Message = "公司不存在或公司编号错误"
};
return(Content(JsonHelper.SerializeObject(dataResult)));
}
string CompanyID = CompanyEntity.CompanyID;
dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("UserName", UserName);
dic.Add("PassWord", PassWord);
result = client.Execute(UserApiName.UserApiName_Login, dic);
DataResult <AdminEntity> adminResult = JsonConvert.DeserializeObject <DataResult <AdminEntity> >(result);
AdminEntity entity = adminResult.Result;
if (entity == null)
{
DataResult dataResult = new DataResult()
{
Code = (int)EResponseCode.Exception, Message = "用户名或密码错误"
};
return(Content(JsonHelper.SerializeObject(dataResult)));
}
else
{
this.LoginUser = entity;
this.Company = CompanyEntity;
//查询仓库
dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", "1");
dic.Add("PageSize", "100");
result = client.Execute(StorageApiName.StorageApiName_GetPage, dic);
if (result.IsNotEmpty())
{
DataListResult <StorageEntity> dataStorageResult = JsonConvert.DeserializeObject <DataListResult <StorageEntity> >(result);
List <StorageEntity> listStorage = dataStorageResult.Result;
if (!listStorage.IsNullOrEmpty())
{
Session[SessionKey.SESSION_STORAGE_LIST] = listStorage;
this.DefaultStorage = listStorage[0];
//查询默认库位 当只有默认仓库 默认仓库的时候使用这段代码
//dic = new Dictionary<string, string>();
//int PageIndex = 1;
//int PageSize = Int32.MaxValue;
//dic.Add("CompanyID", CompanyID);
//dic.Add("PageIndex", PageIndex.ToString());
//dic.Add("PageSize", PageSize.ToString());
//dic.Add("StorageNum", this.DefaultStorageNum);
//result = client.Execute(LocationApiName.LocationApiName_GetPage, dic);
//string returnValue = string.Empty;
//if (!result.IsEmpty())
//{
// DataListResult<LocationEntity> localResult = JsonConvert.DeserializeObject<DataListResult<LocationEntity>>(result);
// List<LocationEntity> listResult = localResult.Result;
// if (!listResult.IsNullOrEmpty())
// {
// this.DefaultLocation = listResult[0];
// }
//}
}
}
DataResult dataResult = new DataResult()
{
Code = (int)EResponseCode.Success, Message = "登录成功"
};
return(Content(JsonHelper.SerializeObject(dataResult)));
}
}
/// <summary>
/// 查询采购订单详细分页
/// </summary>
/// <returns></returns>
public ActionResult GetDetailList()
{
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
string BarCode = WebUtil.GetFormValue <string>("BarCode");
string ProductName = WebUtil.GetFormValue <string>("ProductName");
string OrderNum = WebUtil.GetFormValue <string>("OrderNum");
string OrderSnNum = WebUtil.GetFormValue <string>("OrderSnNum");
string SupNum = WebUtil.GetFormValue <string>("SupNum");
string SupName = WebUtil.GetFormValue <string>("SupName");
string Contact = WebUtil.GetFormValue <string>("Contact");
string Phone = WebUtil.GetFormValue <string>("Phone");
string ContractOrder = WebUtil.GetFormValue <string>("ContractOrder");
string ContractSn = WebUtil.GetFormValue <string>("ContractSn");
int Status = WebUtil.GetFormValue <int>("Status", 0);
int AuditeStatus = WebUtil.GetFormValue <int>("AuditeStatus", -1);
int HasReturn = WebUtil.GetFormValue <int>("HasReturn", -1);
string CreateUser = WebUtil.GetFormValue <string>("CreateUser");
string BeginTime = WebUtil.GetFormValue <string>("BeginTime");
string EndTime = WebUtil.GetFormValue <string>("EndTime");
int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1);
int PageSize = WebUtil.GetFormValue <int>("PageSize", 10);
PurchaseDetailEntity entity = new PurchaseDetailEntity();
entity.CompanyID = CompanyID;
entity.BarCode = BarCode;
entity.ProductName = ProductName;
entity.OrderNum = OrderNum;
entity.OrderSnNum = OrderSnNum;
entity.SupNum = SupNum;
entity.SupName = SupName;
entity.Contact = Contact;
entity.Phone = Phone;
entity.ContractOrder = ContractOrder;
entity.ContractSn = ContractSn;
entity.Status = Status;
entity.AuditeStatus = AuditeStatus;
entity.HasReturn = HasReturn;
entity.CreateUser = CreateUser;
entity.BeginTime = BeginTime;
entity.EndTime = EndTime;
PageInfo pageInfo = new PageInfo()
{
PageIndex = PageIndex, PageSize = PageSize
};
Bill <PurchaseEntity, PurchaseDetailEntity> bill = new PurchaseOrder(CompanyID);
List <PurchaseDetailEntity> listResult = bill.GetDetailList(entity, ref pageInfo);
DataListResult <PurchaseDetailEntity> dataResult = new DataListResult <PurchaseDetailEntity>()
{
Code = (int)EResponseCode.Success,
Message = "响应成功",
Result = listResult,
PageInfo = pageInfo
};
return(Content(JsonHelper.SerializeObject(dataResult)));
}
public ActionResult ToExcel()
{
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
string CompanyID = this.CompanyID;
int PageIndex = 1;
int PageSize = Int32.MaxValue;
string LocalBarCode = WebUtil.GetFormValue <string>("LocalBarCode");
string LocalName = WebUtil.GetFormValue <string>("LocalName", string.Empty);
string StorageNum = WebUtil.GetFormValue <string>("StorageNum", string.Empty);
int StorageType = WebUtil.GetFormValue <int>("StorageType", 0);
List <int> listLocalType = WebUtil.GetFormObject <List <int> >("ListLocalType", null);
int IsForbid = WebUtil.GetFormValue <int>("IsForbid", -1);
int IsDefault = WebUtil.GetFormValue <int>("IsDefault", -1);
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("LocalBarCode", LocalBarCode);
dic.Add("LocalName", LocalName);
dic.Add("StorageNum", StorageNum);
dic.Add("StorageType", StorageType.ToString());
dic.Add("ListLocalType", JsonHelper.SerializeObject(listLocalType));
dic.Add("IsForbid", IsForbid.ToString());
dic.Add("IsDefault", IsDefault.ToString());
string result = client.Execute(LocationApiName.LocationApiName_GetPage, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <LocationEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <LocationEntity> >(result);
List <LocationEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("库位编号"));
dt.Columns.Add(new DataColumn("库位名称"));
dt.Columns.Add(new DataColumn("库位类型"));
dt.Columns.Add(new DataColumn("仓库"));
dt.Columns.Add(new DataColumn("是否禁用"));
dt.Columns.Add(new DataColumn("是否默认"));
dt.Columns.Add(new DataColumn("创建时间"));
dt.Columns.Add(new DataColumn("备注"));
foreach (LocationEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.LocalBarCode;
row[1] = t.LocalName;
row[2] = EnumHelper.GetEnumDesc <ELocalType>(t.LocalType);
row[3] = t.StorageName;
row[4] = EnumHelper.GetEnumDesc <EBool>(t.IsForbid);
row[5] = EnumHelper.GetEnumDesc <EBool>(t.IsDefault);
row[6] = t.CreateTime.To("yyyy-MM-dd");
row[7] = t.Remark;
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("库位管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("库位管理", "库位管理", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
public ActionResult ToExcel()
{
string BarCode = WebUtil.GetFormValue <string>("BarCode");
string ProductName = WebUtil.GetFormValue <string>("ProductName");
string BatchNum = WebUtil.GetFormValue <string>("BatchNum");
string StorageNum = WebUtil.GetFormValue <string>("StorageNum");
string Day = WebUtil.GetFormValue <string>("Day");
int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1);
int PageSize = WebUtil.GetFormValue <int>("PageSize", 10);
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("BarCode", BarCode);
dic.Add("ProductName", ProductName);
dic.Add("BatchNum", BatchNum);
dic.Add("StorageNum", StorageNum);
dic.Add("Day", Day);
string result = client.Execute(BalanceBookApiName.BalanceBookApiName_GetList, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <BalanceBookEntity> dataResult = JsonHelper.DeserializeObject <DataListResult <BalanceBookEntity> >(result);
List <BalanceBookEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("日期"));
dt.Columns.Add(new DataColumn("产品名称"));
dt.Columns.Add(new DataColumn("产品编号"));
dt.Columns.Add(new DataColumn("产品规格"));
dt.Columns.Add(new DataColumn("产品批次"));
dt.Columns.Add(new DataColumn("单位"));
dt.Columns.Add(new DataColumn("仓库"));
dt.Columns.Add(new DataColumn("期初"));
dt.Columns.Add(new DataColumn("入库"));
dt.Columns.Add(new DataColumn("出库"));
dt.Columns.Add(new DataColumn("期末"));
foreach (BalanceBookEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.Day;
row[1] = t.ProductName;
row[2] = t.BarCode;
row[3] = t.Size;
row[4] = t.BatchNum;
row[5] = t.UnitName;
row[6] = t.StorageName;
row[7] = t.BeginNum;
row[8] = t.InNum;
row[9] = t.OutNum;
row[10] = t.EndNum;
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("期初期末{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("期初期末", "期初期末", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
private void ExecuteCopyXML(DataListResult dataListResult)
{
Clipboard.SetText("rashid");
}
public ActionResult ToExcel()
{
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
string CompanyID = this.CompanyID;
int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1);
int PageSize = WebUtil.GetFormValue <int>("PageSize", 10);
string BarCode = WebUtil.GetFormValue <string>("BarCode");
string ProductName = WebUtil.GetFormValue <string>("ProductName");
string UnitNum = WebUtil.GetFormValue <string>("UnitNum");
string CateNum = WebUtil.GetFormValue <string>("CateNum");
string Size = WebUtil.GetFormValue <string>("Size");
string Color = WebUtil.GetFormValue <string>("Color");
string StorageNum = WebUtil.GetFormValue <string>("StorageNum");
string DefaultLocal = WebUtil.GetFormValue <string>("DefaultLocal");
string CusNum = WebUtil.GetFormValue <string>("CusNum");
string SupNum = WebUtil.GetFormValue <string>("SupNum");
string Display = WebUtil.GetFormValue <string>("Display");
string Remark = WebUtil.GetFormValue <string>("Remark");
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("BarCode", BarCode);
dic.Add("ProductName", ProductName);
dic.Add("UnitNum", UnitNum);
dic.Add("CateNum", CateNum);
dic.Add("Size", Size);
dic.Add("Color", Color);
dic.Add("StorageNum", StorageNum);
dic.Add("DefaultLocal", DefaultLocal);
dic.Add("CusNum", CusNum);
dic.Add("SupNum", SupNum);
dic.Add("Display", Display);
dic.Add("Remark", Remark);
string result = client.Execute(ProductApiName.ProductApiName_GetPage, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <ProductEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <ProductEntity> >(result);
List <ProductEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("产品编号"));
dt.Columns.Add(new DataColumn("产品名称"));
dt.Columns.Add(new DataColumn("厂商编码"));
dt.Columns.Add(new DataColumn("内部编码"));
dt.Columns.Add(new DataColumn("规格"));
dt.Columns.Add(new DataColumn("类别"));
dt.Columns.Add(new DataColumn("存储单位"));
dt.Columns.Add(new DataColumn("预警(下)"));
dt.Columns.Add(new DataColumn("预警(上)"));
dt.Columns.Add(new DataColumn("包装类型"));
dt.Columns.Add(new DataColumn("价格"));
dt.Columns.Add(new DataColumn("重量"));
dt.Columns.Add(new DataColumn("显示名"));
dt.Columns.Add(new DataColumn("默认供应商"));
dt.Columns.Add(new DataColumn("默认客户"));
dt.Columns.Add(new DataColumn("备注"));
foreach (ProductEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.BarCode;
row[1] = t.ProductName;
row[2] = t.FactoryNum;
row[3] = t.InCode;
row[4] = t.Size;
row[5] = t.CateName;
row[6] = t.UnitName;
row[7] = t.MinNum;
row[8] = t.MaxNum;
row[9] = EnumHelper.GetEnumDesc <EProductPackage>(t.IsSingle);
row[10] = t.AvgPrice;
row[11] = t.NetWeight;
row[12] = t.Display;
row[13] = t.SupName;
row[14] = t.CusName;
row[15] = t.Remark;
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("产品管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("产品管理", "产品", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
private async void LoadFromXml()
{
await Task.Run(() =>
{
List <DataListResult> temp = null;
//string source = @"C:\Users\rvayalil001\Documents\Rashid\P66\ConfigurationData\System\DataListConfiguration.config";
string source = @"C:\Users\rvayalil001\Documents\Rashid\P66\ConfigurationData\System\Override\DataListConfiguration.config";
string dataLists = File.ReadAllText(source);
XmlDocument doc = new XmlDocument();
doc.LoadXml(dataLists);
if (doc.HasChildNodes)
{
foreach (XmlNode item in doc.ChildNodes)
{
if (item.Name.Equals("DataListConfiguration"))
{
temp = new List <DataListResult>();
if (item.HasChildNodes)
{
foreach (XmlNode dataListNode in item.ChildNodes)
{
if (dataListNode.Name.Equals("SqlDataList"))
{
DataListResult dataList = new DataListResult();
if (dataListNode.HasChildNodes)
{
foreach (XmlNode child in dataListNode.ChildNodes)
{
if (child.InnerText.Trim() != String.Empty)
{
if (child.Name.Equals("DataListName"))
{
dataList.DataListName = child.InnerText.Trim();
}
else if (child.Name.Equals("DisplayName"))
{
dataList.DisplayName = child.InnerText.Trim();
}
else if (child.Name.Equals("CommandText"))
{
dataList.CommandText = child.InnerText.Trim();
}
else if (child.Name.Equals("CacheBehavior"))
{
dataList.CacheBehavior = child.InnerText.Trim();
}
else if (child.Name.Equals("KeyColumnName"))
{
dataList.KeyColumnName = child.InnerText.Trim();
}
else if (child.Name.Equals("DefaultDisplayColumnName"))
{
dataList.DefaultDisplayColumnName = child.InnerText.Trim();
}
}
}
}
temp.Add(dataList);
}
}
}
}
}
}
if (temp != null && temp.Count > 0)
{
DataListResultSet = new ObservableCollection <DataListResult>(temp);
OriginalDataListSet = temp;
}
}
);
}
public ActionResult Add()
{
string SnNum = WebUtil.GetQueryStringValue <string>("SnNum");
AllocateOrderEntity entity = null;
List <AllocateDetailEntity> list = null;
ITopClient client = new TopClientDefault();
if (!SnNum.IsEmpty())
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("SnNum", SnNum);
string result = client.Execute(AllocateApiName.AllocateApiName_GetOrder, dic);
DataResult <AllocateOrderEntity> dataResult = JsonConvert.DeserializeObject <DataResult <AllocateOrderEntity> >(result);
entity = dataResult.Result;
result = client.Execute(AllocateApiName.AllocateApiName_GetDetail, dic);
DataResult <List <AllocateDetailEntity> > dataList = JsonConvert.DeserializeObject <DataResult <List <AllocateDetailEntity> > >(result);
list = dataList.Result;
}
if (entity.IsNull())
{
entity = new AllocateOrderEntity();
entity.CreateUser = this.LoginUser.UserNum;
entity.CreateUserName = this.LoginUser.UserName;
entity.CreateTime = DateTime.Now;
}
ViewBag.Entity = entity;
list = list.IsNull() ? new List <AllocateDetailEntity>() : list;
Session[SessionKey.SESSION_ALLOCATE_DETAIL] = list;
ViewBag.AllocateType = EnumHelper.GetOptions <EAllocateType>(entity.AllocateType);
//加载仓库
Dictionary <string, string> dicStorage = new Dictionary <string, string>();
dicStorage.Add("CompanyID", CompanyID);
dicStorage.Add("PageIndex", "1");
dicStorage.Add("PageSize", "100");
string storageResult = client.Execute(StorageApiName.StorageApiName_GetPage, dicStorage);
string StorageList = string.Empty;
string defautStorageNum = list.Count > 0 ? list[0].ToStorageNum : "";
if (storageResult.IsNotEmpty())
{
DataListResult <StorageEntity> dataStorage = JsonConvert.DeserializeObject <DataListResult <StorageEntity> >(storageResult);
List <StorageEntity> listStorage = dataStorage.Result;
StringBuilder sb = new StringBuilder();
sb.Append("<option value=''>请选择</option>");
if (!listStorage.IsNullOrEmpty())
{
foreach (StorageEntity item in listStorage)
{
sb.AppendFormat("<option value='{0}' {1}>{2}</option>", item.SnNum, item.SnNum == defautStorageNum ? "selected='selected'" : "", item.StorageName);
}
}
StorageList = sb.ToString();
}
ViewBag.Storage = StorageList;
return(View());
}
private bool CanExecuteCopyText(DataListResult dataListResult)
{
return(dataListResult != null);
}
public ActionResult ToExcel()
{
string CompanyID = this.CompanyID;
int PageIndex = 1;
int PageSize = Int32.MaxValue;
string OrderNum = WebUtil.GetFormValue <string>("OrderNum");
int OrderType = WebUtil.GetFormValue <int>("OrderType", 0);
string BarCode = WebUtil.GetFormValue <string>("BarCode");
string ProductName = WebUtil.GetFormValue <string>("ProductName");
string SupNum = WebUtil.GetFormValue <string>("SupNum", string.Empty);
string SupName = WebUtil.GetFormValue <string>("SupName", string.Empty);
int Status = WebUtil.GetFormValue <int>("Status", 0);
int AuditeStatus = WebUtil.GetFormValue <int>("AuditeStatus", -1);
string ContractOrder = WebUtil.GetFormValue <string>("ContractOrder", string.Empty);
string BeginTime = WebUtil.GetFormValue <string>("BeginTime", string.Empty);
string EndTime = WebUtil.GetFormValue <string>("EndTime", string.Empty);
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("OrderNum", OrderNum);
dic.Add("BarCode", BarCode);
dic.Add("ProductName", ProductName);
dic.Add("OrderType", OrderType.ToString());
dic.Add("SupNum", SupNum);
dic.Add("SupName", SupName);
dic.Add("Status", Status.ToString());
dic.Add("AuditeStatus", AuditeStatus.ToString());
dic.Add("ContractOrder", ContractOrder);
dic.Add("BeginTime", BeginTime);
dic.Add("EndTime", EndTime);
string result = client.Execute(PurchaseApiName.PurchaseApiName_GetDetailList, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <PurchaseDetailEntity> dataResult = JsonHelper.DeserializeObject <DataListResult <PurchaseDetailEntity> >(result);
List <PurchaseDetailEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("订单号"));
dt.Columns.Add(new DataColumn("产品名称"));
dt.Columns.Add(new DataColumn("产品编号"));
dt.Columns.Add(new DataColumn("产品规格"));
dt.Columns.Add(new DataColumn("单价"));
dt.Columns.Add(new DataColumn("单位"));
dt.Columns.Add(new DataColumn("数量"));
dt.Columns.Add(new DataColumn("总额"));
dt.Columns.Add(new DataColumn("供应商编号"));
dt.Columns.Add(new DataColumn("供应商名称"));
dt.Columns.Add(new DataColumn("订单总额"));
dt.Columns.Add(new DataColumn("状态"));
dt.Columns.Add(new DataColumn("是否入账"));
dt.Columns.Add(new DataColumn("退货"));
dt.Columns.Add(new DataColumn("创建时间"));
foreach (PurchaseDetailEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.OrderNum;
row[1] = t.ProductName;
row[2] = t.BarCode;
row[3] = t.Size;
row[4] = t.Price;
row[5] = t.UnitName;
row[6] = t.Num;
row[7] = t.Amount;
row[8] = t.SupNum;
row[9] = t.SupName;
row[10] = t.OrderAmount;
row[11] = EnumHelper.GetEnumDesc <EPurchaseStatus>(t.OrderStatus);
row[12] = EnumHelper.GetEnumDesc <EBool>(t.AuditeStatus);
row[13] = EnumHelper.GetEnumDesc <EBool>(t.HasReturn);
row[14] = t.CreateTime.ToString("yyyy-MM-dd");
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("采购订单{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("采购订单", "采购订单", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
private void ExecuteCopyText(DataListResult dataListResult)
{
Clipboard.SetText(dataListResult.CommandText);
}
public ActionResult ToExcel()
{
string CompanyID = this.CompanyID;
int PageIndex = 1;
int PageSize = Int32.MaxValue;
string OrderNum = WebUtil.GetFormValue <string>("OrderNum");
int InType = WebUtil.GetFormValue <int>("InType", 0);
string SupName = WebUtil.GetFormValue <string>("SupName", string.Empty);
string SupNum = WebUtil.GetFormValue <string>("SupNum", string.Empty);
int Status = WebUtil.GetFormValue <int>("Status", 0);
string ContractOrder = WebUtil.GetFormValue <string>("ContractOrder", string.Empty);
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("OrderNum", OrderNum);
dic.Add("InType", InType.ToString());
dic.Add("SupName", SupName);
dic.Add("SupNum", SupNum);
dic.Add("Status", Status.ToString());
dic.Add("ContractOrder", ContractOrder);
string result = client.Execute(OutStorageApiName.OutStorageApiName_GetDetailList, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <OutStoDetailEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <OutStoDetailEntity> >(result);
List <OutStoDetailEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("订单号"));
dt.Columns.Add(new DataColumn("产品名称"));
dt.Columns.Add(new DataColumn("产品编号"));
dt.Columns.Add(new DataColumn("批次"));
dt.Columns.Add(new DataColumn("规格"));
dt.Columns.Add(new DataColumn("数量"));
dt.Columns.Add(new DataColumn("仓库"));
dt.Columns.Add(new DataColumn("库位"));
dt.Columns.Add(new DataColumn("出库类型"));
dt.Columns.Add(new DataColumn("客户"));
dt.Columns.Add(new DataColumn("承运商"));
dt.Columns.Add(new DataColumn("物流单号"));
dt.Columns.Add(new DataColumn("制单人"));
dt.Columns.Add(new DataColumn("制单时间"));
dt.Columns.Add(new DataColumn("状态"));
dt.Columns.Add(new DataColumn("审核人"));
dt.Columns.Add(new DataColumn("审核时间"));
foreach (OutStoDetailEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.OrderNum;
row[1] = t.ProductName;
row[2] = t.BarCode;
row[3] = t.BatchNum;
row[4] = t.Size;
row[5] = t.Num.ToString("0.00");
row[6] = t.StorageName;
row[7] = t.LocalName;
row[8] = EnumHelper.GetEnumDesc <EInType>(t.OutType);
row[9] = t.CusName;
row[10] = t.CarrierName;
row[11] = t.LogisticsNo;
row[12] = t.CreateUserName;
row[13] = t.CreateTime.To("yyyy-MM-dd");
row[14] = EnumHelper.GetEnumDesc <EAudite>(t.Status);
row[15] = t.AuditeUserName;
row[16] = t.AuditeTime.To("yyyy-MM-dd");
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("出库管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("出库管理", "出库单", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
public ActionResult ToProductStoreExcel()
{
string CompanyID = this.CompanyID;
string BarCode = WebUtil.GetFormValue <string>("BarCode", string.Empty);
string ProductName = WebUtil.GetFormValue <string>("ProductName", string.Empty);
int PageIndex = 1;
int PageSize = Int32.MaxValue;
ITopClient client = new TopClientDefault();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("CompanyID", CompanyID);
dic.Add("PageIndex", PageIndex.ToString());
dic.Add("PageSize", PageSize.ToString());
dic.Add("BarCode", BarCode);
dic.Add("ProductName", ProductName);
string result = client.Execute(LocalProductApiName.LocalProductApiName_GetLocalProduct, dic);
string returnValue = string.Empty;
if (!result.IsEmpty())
{
DataListResult <V_LocalProductEntity> dataResult = JsonHelper.DeserializeObject <DataListResult <V_LocalProductEntity> >(result);
List <V_LocalProductEntity> listResult = dataResult.Result;
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("产品名称"));
dt.Columns.Add(new DataColumn("产品编号"));
dt.Columns.Add(new DataColumn("产品规格"));
dt.Columns.Add(new DataColumn("类别"));
dt.Columns.Add(new DataColumn("库存"));
dt.Columns.Add(new DataColumn("单位"));
foreach (V_LocalProductEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.ProductName;
row[1] = t.BarCode;
row[2] = t.Size;
row[3] = t.CateName;
row[4] = t.Num;
row[5] = t.UnitName;
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFile/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("可出库存{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
NPOIExcel excel = new NPOIExcel("可出库存", "可出库存", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
returnValue = ("/UploadFile/" + filename).Escape();
}
}
DataResult returnResult = null;
if (!returnValue.IsEmpty())
{
returnResult = new DataResult()
{
Code = 1000, Message = returnValue
};
}
else
{
returnResult = new DataResult()
{
Code = 1001, Message = "没有任何数据导出"
};
}
return(Content(JsonHelper.SerializeObject(returnResult)));
}
