public ActionResult Audite() { string CompanyID = this.CompanyID; string SnNum = WebUtil.GetFormValue <string>("SnNum"); int Status = WebUtil.GetFormValue <int>("Status"); string Reason = WebUtil.GetFormValue <string>("Reason"); ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", SnNum); dic.Add("Status", Status.ToString()); dic.Add("Reason", Reason); dic.Add("AuditUser", this.LoginUser.UserNum); dic.Add("OperateType", ((int)EOpType.PC).ToString()); dic.Add("EquipmentNum", ""); dic.Add("EquipmentCode", ""); string result = client.Execute(SaleApiName.SaleApiName_Audite, dic); return(Content(result)); }
public ActionResult GetProductStoreList() { string CompanyID = this.CompanyID; string BarCode = WebUtil.GetFormValue <string>("BarCode", string.Empty); string ProductName = WebUtil.GetFormValue <string>("ProductName", string.Empty); 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); string result = client.Execute(LocalProductApiName.LocalProductApiName_GetLocalProduct, dic); return(Content(result)); }
public ActionResult InStorage() { string SnNum = WebUtil.GetQueryStringValue <string>("SnNum"); PurchaseEntity entity = null; if (!SnNum.IsEmpty()) { ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", SnNum); string result = client.Execute(PurchaseApiName.PurchaseApiName_GetOrder, dic); DataResult <PurchaseEntity> dataResult = JsonConvert.DeserializeObject <DataResult <PurchaseEntity> >(result); entity = dataResult.Result; } entity = entity.IsNull() ? new PurchaseEntity() : entity; ViewBag.Entity = entity; return(View()); }
public ActionResult GetList() { 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 CateNum = WebUtil.GetFormValue<string>("CateNum"); string CateName = WebUtil.GetFormValue<string>("CateName"); string Remark = WebUtil.GetFormValue<string>("Remark"); dic.Add("CompanyID", CompanyID); dic.Add("PageIndex", PageIndex.ToString()); dic.Add("PageSize", PageSize.ToString()); dic.Add("CateName", CateName); dic.Add("CateNum", CateNum); dic.Add("Remark", Remark); string result = client.Execute(ProductCategoryApiName.ProductCategoryApiName_GetPage, dic); return Content(result); }
public ActionResult AdminEditPass() { string UserNum = WebUtil.GetFormValue <string>("UserNum", string.Empty); string NewPass = WebUtil.GetFormValue <string>("NewPass", string.Empty); string ConfirmPass = WebUtil.GetFormValue <string>("ConfirmPass", string.Empty); DataResult dataResult = new DataResult(); if (UserNum.IsEmpty()) { dataResult.Code = (int)EResponseCode.Exception; dataResult.Message = "该非法操作已经被禁止"; return(Content(JsonHelper.SerializeObject(dataResult))); } if (NewPass.IsEmpty()) { dataResult.Code = (int)EResponseCode.Exception; dataResult.Message = "新密码不能为空"; return(Content(JsonHelper.SerializeObject(dataResult))); } if (NewPass != ConfirmPass) { dataResult.Code = (int)EResponseCode.Exception; dataResult.Message = "密码和确认密码不一致"; return(Content(JsonHelper.SerializeObject(dataResult))); } ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", this.CompanyID); dic.Add("UserNum", UserNum); dic.Add("NewPass", NewPass); dic.Add("ConfirmPass", ConfirmPass); string result = client.Execute(UserApiName.UserApiName_AdminEditPass, dic); return(Content(result)); }
public ActionResult Add() { string SnNum = WebUtil.GetQueryStringValue <string>("SnNum"); OutStorageEntity entity = null; List <OutStoDetailEntity> list = null; if (!SnNum.IsEmpty()) { ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", SnNum); string result = client.Execute(OutStorageApiName.OutStorageApiName_GetOrder, dic); DataResult <OutStorageEntity> dataResult = JsonConvert.DeserializeObject <DataResult <OutStorageEntity> >(result); entity = dataResult.Result; result = client.Execute(OutStorageApiName.OutStorageApiName_GetDetail, dic); DataResult <List <OutStoDetailEntity> > dataList = JsonConvert.DeserializeObject <DataResult <List <OutStoDetailEntity> > >(result); list = dataList.Result; } if (entity.IsNull()) { entity = new OutStorageEntity(); entity.CreateUser = this.LoginUser.UserNum; entity.CreateUserName = this.LoginUser.UserName; entity.CreateTime = DateTime.Now; entity.SendDate = DateTime.Now; } ViewBag.Entity = entity; list = list.IsNull() ? new List <OutStoDetailEntity>() : list; Session[SessionKey.SESSION_OUTSTORAGE_DETAIL] = list; ViewBag.OutType = EnumHelper.GetOptions <EOutType>(entity.OutType); return(View()); }
public ActionResult Add() { string SN = WebUtil.GetQueryStringValue <string>("SN", string.Empty); MeasureEntity entity = null; ITopClient client = new TopClientDefault(); if (!SN.IsEmpty()) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SN", SN); string result = client.Execute(MeasureApiName.MeasureApiName_Single, dic); DataResult <MeasureEntity> dataResult = JsonConvert.DeserializeObject <DataResult <MeasureEntity> >(result); entity = dataResult.Result; } entity = entity.IsNull() ? new MeasureEntity() : entity; ViewBag.Entity = entity; return(View()); }
public ActionResult AddRec() { string CompanyID = this.CompanyID; string SnNum = WebUtil.GetQueryStringValue <string>("SnNum", string.Empty); FinanceBillEntity entity = null; if (!SnNum.IsEmpty()) { ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", SnNum); string result = client.Execute(FinanceBillApiName.FinanceBillApiName_Single, dic); if (!result.IsEmpty()) { DataResult <FinanceBillEntity> dataResult = JsonConvert.DeserializeObject <DataResult <FinanceBillEntity> >(result); entity = dataResult.Result; } } if (entity.IsNull()) { entity = new FinanceBillEntity(); entity.CreateTime = DateTime.Now; entity.CreateUser = this.LoginUser.UserNum; entity.CreateUserName = this.LoginUser.UserName; entity.LastTime = DateTime.Now.AddMonths(2); } entity.FromName = entity.FromName.IsEmpty() ? "公司" : entity.FromName; ViewBag.Entity = entity; string CateList = DropDownHelper.GetFinanceCate(entity.CateNum, this.CompanyID); ViewBag.CateList = CateList; return(View()); }
public ActionResult Add() { InStorageEntity entity = WebUtil.GetFormObject <InStorageEntity>("Entity"); List <InStorDetailEntity> listDetail = Session[SessionKey.SESSION_INSTORAGE_DETAIL] as List <InStorDetailEntity>; string CompanyID = this.CompanyID; if (listDetail.IsNullOrEmpty()) { DataResult <string> dataResult = new DataResult <string>() { Code = (int)EResponseCode.Exception, Message = "请选择要入库的产品" }; return(Content(JsonHelper.SerializeObject(dataResult))); } string ApiName = InStorageApiName.InStorageApiName_Add; if (!entity.SnNum.IsEmpty()) { ApiName = InStorageApiName.InStorageApiName_Edit; } entity.CreateUser = this.LoginUser.UserNum; entity.CreateTime = DateTime.Now; entity.IsDelete = (int)EIsDelete.NotDelete; entity.Status = (int)EAudite.Wait; entity.StorageNum = this.DefaultStorageNum; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("Entity", JsonConvert.SerializeObject(entity)); dic.Add("List", JsonConvert.SerializeObject(listDetail)); ITopClient client = new TopClientDefault(); string result = client.Execute(ApiName, dic); return(Content(result)); }
public ActionResult Carrier() { string SnNum = WebUtil.GetQueryStringValue <string>("SnNum"); OutStorageEntity entity = null; if (!SnNum.IsEmpty()) { ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", SnNum); string result = client.Execute(OutStorageApiName.OutStorageApiName_GetOrder, dic); DataResult <OutStorageEntity> dataResult = JsonConvert.DeserializeObject <DataResult <OutStorageEntity> >(result); entity = dataResult.Result; } entity = entity.IsNull() ? new OutStorageEntity() : entity; ViewBag.Entity = entity; ViewBag.Carrier = DropDownHelper.GetCarrier(entity.CarrierNum, this.CompanyID); return(View()); }
public ActionResult GetList() { string CompanyID = this.CompanyID; int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1); int PageSize = WebUtil.GetFormValue <int>("PageSize", 10); 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); return(Content(result)); }
public ActionResult Add() { string SnNum = WebUtil.GetQueryStringValue <string>("SnNum", string.Empty); EquipmentEntity entity = 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(EquipmentApiName.EquipmentApiName_Single, dic); DataResult <EquipmentEntity> dataResult = JsonConvert.DeserializeObject <DataResult <EquipmentEntity> >(result); entity = dataResult.Result; } entity = entity.IsNull() ? new EquipmentEntity() : entity; ViewBag.Entity = entity; ViewBag.EquipmentStatus = EnumHelper.GetOptions <EEquipmentStatus>(entity.Status); return(View()); }
public ActionResult GetList() { 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 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); return(Content(result)); }
public ActionResult GetList() { 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 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); double Area = WebUtil.GetFormValue <double>("Area"); string Address = WebUtil.GetFormValue <string>("Address"); string Contact = WebUtil.GetFormValue <string>("Contact"); string Phone = WebUtil.GetFormValue <string>("Phone"); 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); return(Content(result)); }
public ActionResult GetList() { string StorageNum = WebUtil.GetFormValue <string>("StorageNum", string.Empty); string LocalName = WebUtil.GetFormValue <string>("LocalName", string.Empty); int LocalType = WebUtil.GetFormValue <int>("LocalType", 0); int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1); int PageSize = WebUtil.GetFormValue <int>("PageSize", 10); StorageNum = this.DefaultStorage.SnNum; 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("StorageNum", StorageNum); dic.Add("LocalName", LocalName); dic.Add("LocalType", LocalType.ToString()); string result = client.Execute(CapacityApiName.CapacityApiName_GetList, dic); return(Content(result)); }
public ActionResult AddPay() { string SnNum = WebUtil.GetFormValue <string>("SnNum"); string BillNum = WebUtil.GetFormValue <string>("BillNum"); string BillSnNum = WebUtil.GetFormValue <string>("BillSnNum"); int PayType = WebUtil.GetFormValue <int>("PayType"); string BankName = WebUtil.GetFormValue <string>("BankName"); double Amount = WebUtil.GetFormValue <double>("Amount"); DateTime PayTime = WebUtil.GetFormValue <DateTime>("PayTime", DateTime.Now); FinancePayEntity entity = new FinancePayEntity(); entity.SnNum = SnNum; entity.BillSnNum = BillSnNum; entity.PayType = PayType; entity.BankName = BankName; entity.Amount = Amount; entity.PayTime = PayTime; entity.CompanyID = this.CompanyID; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", this.CompanyID); dic.Add("Entity", JsonConvert.SerializeObject(entity)); ITopClient client = new TopClientDefault(); string ApiName = FinancePayApiName.FinancePayApiName_Add; if (!SnNum.IsEmpty()) { ApiName = FinancePayApiName.FinancePayApiName_Edit; } string result = client.Execute(ApiName, dic); return(Content(result)); }
public ActionResult Add() { string SnNum = WebUtil.GetQueryStringValue <string>("SnNum", string.Empty); StorageEntity entity = 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(StorageApiName.StorageApiName_Single, dic); DataResult <StorageEntity> dataResult = JsonHelper.DeserializeObject <DataResult <StorageEntity> >(result); entity = dataResult.Result; } entity = entity.IsNull() ? new StorageEntity() : entity; ViewBag.Entity = entity; ViewBag.DepartNum = DropDownHelper.GetDepart(entity.DepartNum, this.CompanyID); ViewBag.StorageType = EnumHelper.GetOptions <EStorageType>(entity.StorageType); return(View()); }
public ActionResult Add() { ITopClient client = new TopClientDefault(); string CompanyID = this.CompanyID; SupplierEntity entity = WebUtil.GetFormObject <SupplierEntity>("Entity"); entity.CreateTime = DateTime.Now; entity.CreateUser = this.LoginUserNum; entity.CompanyID = this.CompanyID; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("Entity", JsonConvert.SerializeObject(entity)); string ApiName = SupplierApiName.SupplierApiName_Add; if (!entity.SnNum.IsEmpty()) { ApiName = SupplierApiName.SupplierApiName_Edit; } string result = client.Execute(ApiName, dic); return(Content(result)); }
public ActionResult Delete() { List <string> list = WebUtil.GetFormObject <List <string> >("List"); if (list.IsNullOrEmpty()) { DataResult dataResult = new DataResult(); dataResult.Code = (int)EResponseCode.Exception; dataResult.Message = "请选择要删除的项"; return(Content(JsonHelper.SerializeObject(dataResult))); } string content = string.Empty; foreach (string SnNum in list) { ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", this.CompanyID); dic.Add("SnNum", SnNum); content = client.Execute(CarrierApiName.CarrierApiName_Delete, dic); } return(Content(content)); }
public ActionResult Add() { string SnNum = WebUtil.GetQueryStringValue <string>("SnNum", string.Empty); SupplierEntity entity = null; if (!SnNum.IsEmpty()) { ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", SnNum); string result = client.Execute(SupplierApiName.SupplierApiName_Single, dic); DataResult <SupplierEntity> dataResult = JsonConvert.DeserializeObject <DataResult <SupplierEntity> >(result); entity = dataResult.Result; } entity = entity.IsNull() ? new SupplierEntity() : entity; ViewBag.Entity = entity; entity.SupType = entity.SupType == 0 ? (int)ESupType.Cooperation : entity.SupType; ViewBag.SupplierType = EnumHelper.GetOptions <ESupType>(entity.SupType); return(View()); }
public ActionResult Add() { string SnNum = WebUtil.GetQueryStringValue <string>("SnNum"); InventoryOrderEntity entity = null; List <InventoryDetailEntity> list = null; if (!SnNum.IsEmpty()) { ITopClient client = new TopClientDefault(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", SnNum); string result = client.Execute(CheckApiName.CheckApiName_GetOrder, dic); DataResult <InventoryOrderEntity> dataResult = JsonConvert.DeserializeObject <DataResult <InventoryOrderEntity> >(result); entity = dataResult.Result; result = client.Execute(CheckApiName.CheckApiName_GetDetail, dic); DataResult <List <InventoryDetailEntity> > dataList = JsonConvert.DeserializeObject <DataResult <List <InventoryDetailEntity> > >(result); list = dataList.Result; } if (entity == null) { entity = new InventoryOrderEntity(); entity.CreateUser = this.LoginUser.UserNum; entity.CreateUserName = this.LoginUser.UserName; } ViewBag.Entity = entity; list = list.IsNull() ? new List <InventoryDetailEntity>() : list; Session[SessionKey.SESSION_CHECK_DETAIL] = list; return(View()); }
public ActionResult Add() { ITopClient client = new TopClientDefault(); string CateNum = WebUtil.GetFormValue <string>("CateNum"); string CateName = WebUtil.GetFormValue <string>("CateName"); string SnNum = WebUtil.GetFormValue <string>("SnNum"); string CompanyID = this.CompanyID; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("SnNum", SnNum); dic.Add("CateNum", CateNum); dic.Add("CateName", CateName); string ApiName = FinanceCateApiName.FinanceCateApiName_Add; if (!SnNum.IsEmpty()) { ApiName = FinanceCateApiName.FinanceCateApiName_Edit; } string result = client.Execute(ApiName, dic); return(Content(result)); }
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(InStorageApiName.InStorageApiName_GetDetailList, dic); string returnValue = string.Empty; if (!result.IsEmpty()) { DataListResult <InStorDetailEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <InStorDetailEntity> >(result); List <InStorDetailEntity> 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 (InStorDetailEntity 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.InType); row[9] = t.SupName; row[10] = t.CreateUserName; row[11] = t.CreateTime.To("yyyy-MM-dd"); row[12] = EnumHelper.GetEnumDesc <EAudite>(t.Status); row[13] = t.AuditeUserName; row[14] = 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 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() { string BarCode = WebUtil.GetFormValue <string>("BarCode", string.Empty); string ProductName = WebUtil.GetFormValue <string>("ProductName", string.Empty); string BatchNum = WebUtil.GetFormValue <string>("BatchNum", string.Empty); int Type = WebUtil.GetFormValue <int>("Type", 0); string FromStorageNum = WebUtil.GetFormValue <string>("FromStorageNum"); string OrderNum = WebUtil.GetFormValue <string>("OrderNum"); string ContactOrder = WebUtil.GetFormValue <string>("ContactOrder"); string BeginTime = WebUtil.GetFormValue <string>("BeginTime"); string EndTime = WebUtil.GetFormValue <string>("EndTime"); 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); dic.Add("BatchNum", BatchNum); dic.Add("Type", Type.ToString()); dic.Add("FromStorageNum", FromStorageNum); dic.Add("OrderNum", OrderNum); dic.Add("ContactOrder", ContactOrder); dic.Add("BeginTime", BeginTime); dic.Add("EndTime", EndTime); string result = client.Execute(InventoryApiName.InventoryApiName_GetList, dic); string returnValue = string.Empty; if (!result.IsEmpty()) { DataListResult <InventoryBookEntity> dataResult = JsonHelper.DeserializeObject <DataListResult <InventoryBookEntity> >(result); List <InventoryBookEntity> 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("日期")); foreach (InventoryBookEntity 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] = EnumHelper.GetEnumDesc <EChange>(t.Type); row[5] = t.Num; row[6] = t.UnitName; row[7] = t.FromStorageName; row[8] = t.FromLocalName; row[9] = t.ToStorageName; row[10] = t.ToLocalName; row[11] = 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 ToSaleReportListExcel() { string BarCode = WebUtil.GetFormValue <string>("BarCode"); string ProductName = WebUtil.GetFormValue <string>("ProductName"); 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 = 1; int PageSize = Int32.MaxValue; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("CompanyID", CompanyID); dic.Add("BarCode", BarCode); dic.Add("ProductName", ProductName); 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(SaleApiName.SaleApiName_GetDetailList, dic); string returnValue = string.Empty; if (!result.IsEmpty()) { DataListResult <SaleDetailEntity> dataResult = JsonConvert.DeserializeObject <DataListResult <SaleDetailEntity> >(result); List <SaleDetailEntity> 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 (SaleDetailEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = t.ProductName; row[1] = t.BarCode; row[2] = t.Size; row[3] = t.OrderNum; row[4] = t.Num.ToString("0.00"); row[5] = t.Price.ToString("0.00"); row[6] = t.Amount.ToString("0.00"); row[7] = t.CusName; 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 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()); }
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 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))); }
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))); }