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)));
}
