public ActionResult Get(int pageSize, int pageNum)
{
return(Json(workCodeTypeOper.Get(
delegate(object sender, ICriteria criteria)
{
criteria.AddOrder(Order.Desc("ModDate"));
}
, pageSize, pageNum)));
}
public ActionResult DownLoadDept()
{
string fileName = Server.MapPath("/") + @"Files\Temp\" + "1.xlsx";
IList <ExcelField> fields = new List <ExcelField>();
ExcelField ef = null;
ef = new ExcelField("Code", "代码");
fields.Add(ef);
ef = new ExcelField("Name", "名字");
fields.Add(ef);
ef = new ExcelField("TestExcel", "测试Excel");
fields.Add(ef);
TbBaseOper <Department> departmentOper = new TbBaseOper <Department>(HibernateOper, typeof(Department));
IList <Department> list = departmentOper.Get();
//ExportExcel ee = new ExportExcel(fileName, "abc", fields);
ExportExcel ee = new ExportExcel(fileName, typeof(Department));
ee.Save(list);
//返回文件
return(File(fileName, "xlsx", "1.xlsx"));
}
public ActionResult Get(int pageSize, int pageNum, string checkStockID, string goodsID, string sysQty, string qty, string profitLoss)
{
return(Json(checkStockDetailOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(checkStockID))
{
ICriterion criterion = Restrictions.Eq("CheckStockID", PojoUtil.InitPojo <CheckStock>(checkStockID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(goodsID))
{
ICriterion criterion = Restrictions.Eq("GoodsID", PojoUtil.InitPojo <GoodsInfo>(goodsID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(sysQty))
{
ICriterion criterion = Restrictions.Like("SysQty", sysQty, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(qty))
{
ICriterion criterion = Restrictions.Like("Qty", qty, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(profitLoss))
{
ICriterion criterion = Restrictions.Like("ProfitLoss", profitLoss, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("CheckStockID"));
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string cstmrName, string contact, string phoneNum)
{
return(Json(workOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(cstmrName))
{
ICriterion criterion = Restrictions.Like("Cstmr.Name", cstmrName, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(contact))
{
ICriterion criterion = Restrictions.Like("Contact", contact, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(phoneNum))
{
ICriterion criterion = Restrictions.Like("PhoneNum", phoneNum, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Desc("ModDate"));
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string retOrderID, string goodsID, string price, string qty)
{
return(Json(retOrderDetailOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(retOrderID))
{
ICriterion criterion = Restrictions.Eq("RetOrderID", PojoUtil.InitPojo <RetOrder>(retOrderID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(goodsID))
{
ICriterion criterion = Restrictions.Eq("GoodsID", PojoUtil.InitPojo <GoodsInfo>(goodsID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(price))
{
ICriterion criterion = Restrictions.Like("Price", price, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(qty))
{
ICriterion criterion = Restrictions.Like("Qty", qty, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("RetOrderID"));
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string goodsCode, string goodsName, string barCode, string goodsTypeID, string modelNum)
{
return(Json(goodsInfoOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(goodsCode))
{
ICriterion criterion = Restrictions.Like("GoodsCode", goodsCode, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(goodsName))
{
ICriterion criterion = Restrictions.Like("GoodsName", goodsName, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(barCode))
{
ICriterion criterion = Restrictions.Like("BarCode", barCode, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(goodsTypeID))
{
ICriterion criterion = Restrictions.Eq("GoodsType", PojoUtil.InitPojo <GoodsType>(goodsTypeID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(modelNum))
{
ICriterion criterion = Restrictions.Like("ModelNum", modelNum, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("GoodsName"));
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string pId, string unitDesc, string goodsTypeCode, string goodsTypeName)
{
return(Json(goodsTypeOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(pId))
{
ICriterion criterion = Restrictions.Eq("PId", new Guid(pId));
criteria.Add(criterion);
}
else
{
ICriterion criterion = Restrictions.Eq("PId", Guid.Empty);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(unitDesc))
{
ICriterion criterion = Restrictions.Like("UnitDesc", unitDesc, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(goodsTypeCode))
{
ICriterion criterion = Restrictions.Like("GoodsTypeCode", goodsTypeCode, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(goodsTypeName))
{
ICriterion criterion = Restrictions.Like("GoodsTypeName", goodsTypeName, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("GoodsTypeCode"));
}
, pageSize, pageNum)));
}
//查找地址码
public ActionResult Search(string code)
{
//得到地址码的级别
int level = GetCodeLevel(code);
IList <AddrCode> retVal = null;
if (level >= 0)
{
retVal = addrCodeOper.Get(
delegate(object sender, ICriteria criteria)
{
//模糊查找当前代码
ICriterion criterion = Restrictions.Like("Code", code + "__%");
criteria.Add(criterion);
//查找当前代码的一下级
criterion = Restrictions.Eq("Level", (byte)(level + 1));
criteria.Add(criterion);
criteria.AddOrder(Order.Asc("Code"));
}
);
}
else
{
retVal = new List <AddrCode>();
}
return(Json(retVal));
}
public ActionResult Get(int pageSize, int pageNum, string roleFlag, string roleId, string modId)
{
return(Json(empModOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(roleFlag))
{
ICriterion criterion = Restrictions.Eq("RoleFlag", roleFlag);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(roleId))
{
ICriterion criterion = Restrictions.Eq("RoleId", new Guid(roleId));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(modId))
{
ICriterion criterion = Restrictions.Eq("Mod", PojoUtil.InitPojo <Mod>(modId));
criteria.Add(criterion);
}
//创建对象属性别名
criteria.CreateAlias("Mod", "m");
criteria.AddOrder(Order.Asc("m.Name"));
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string pId, string code, string name, string addr)
{
return(Json(departmentOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(pId))
{
ICriterion criterion = Restrictions.Eq("PId", new Guid(pId));
criteria.Add(criterion);
}
else
{
ICriterion criterion = Restrictions.Eq("PId", Guid.Empty);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(code))
{
ICriterion criterion = Restrictions.Eq("Code", code);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(name))
{
ICriterion criterion = Restrictions.Like("Name", name, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(addr))
{
ICriterion criterion = Restrictions.Like("Addr", addr, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("Code"));
}
, pageSize, pageNum)));
}
public ActionResult Get()
{
return(Json(companyOper.Get(
delegate(object sender, ICriteria criteria)
{
}
, 1, 1)));
}
//由工号与密码获取用户
private Employee GetEmpForCodeAndPwd(string code, string pwd)
{
Employee retVal = null;;
IList <Employee> emps = employeeOper.Get(
delegate(object sender, ICriteria criteria)
{
ICriterion criterion = Restrictions.Eq("Code", code);
criteria.Add(criterion);
criterion = Restrictions.Eq("PwdWeb", pwd);
criteria.Add(criterion);
}
);
if (emps != null && emps.Count > 0)
{
retVal = emps[0];
emps.Clear();
}
return(retVal);
}
public ActionResult GetWorkDetail(int pageSize, int pageNum, string workSubId)
{
return(Json(workDetailOper.Get(
delegate(object sender, ICriteria criteria)
{
ICriterion criterion = Restrictions.Eq("WorkSub", PojoUtil.InitPojo <WorkSub>(workSubId));
criteria.Add(criterion);
criteria.AddOrder(Order.Desc("ModDate"));
}
, pageSize, pageNum)));
}
public ActionResult GetCustomerScore(int pageSize, int pageNum, string workId)
{
return(Json(customerScoreOper.Get(
delegate(object sender, ICriteria criteria)
{
ICriterion criterion = Restrictions.Eq("Work", PojoUtil.InitPojo <Work>(workId));
criteria.Add(criterion);
criteria.AddOrder(Order.Desc("ModDate"));
}
, pageSize, pageNum)));
}
public ActionResult Upload()
{
IList <File> retVal = new List <File>();
string path = Server.MapPath("/") + @"Files\";
//文件上传，一次上传1M的数据，防止出现大文件无法上传
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
//保存上传的文件
File file = SaveHttpPostFile(files[i], path);
//查找是否存在过相同MD5值的文件，如果是则不保存到数据库
IList <File> searchFiles = fileOper.Get(
delegate(object sender, ICriteria criteria)
{
criteria.Add(Restrictions.Eq("Md5", file.Md5));
}
);
if (searchFiles.Count > 0)
{
//删除上传的文件并把数据库相同文件信息返回
DelFile(file.RealPath);
file = searchFiles[0];
}
else
{
//保存文件到数据库
fileOper.Add(file);
}
retVal.Add(file);
}
return(Json(retVal));
}
public ActionResult Get(int pageSize, int pageNum, string unitName)
{
return(Json(unitOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(unitName))
{
ICriterion criterion = Restrictions.Like("UnitName", unitName, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("UnitName"));
}
, pageSize, pageNum)));
}
public ActionResult Login(string code, string pwd)
{
IList <Employee> emps = empOper.Get(
delegate(object sender, ICriteria criteria)
{
ICriterion criterion = Restrictions.Eq("Code", code);
criteria.Add(criterion);
criterion = Restrictions.Eq("Pwd", pwd);
criteria.Add(criterion);
}
);
if (emps != null && emps.Count > 0)
{
Session["Employee"] = emps[0];
emps.Clear();
}
else
{
// throw new Exception("UserNameOrPwdError");//用户名或密码错误
}
return(Json("true"));
}
public ActionResult Get(int pageSize, int pageNum, string retOrderCode, string vendorID, string storeHouseID, string retMember, string approvalID, string approvalTime, string state, string totalMoney)
{
return(Json(retOrderOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(retOrderCode))
{
ICriterion criterion = Restrictions.Like("RetOrderCode", retOrderCode, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(vendorID))
{
ICriterion criterion = Restrictions.Eq("VendorID", PojoUtil.InitPojo <VendorInfo>(vendorID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(storeHouseID))
{
ICriterion criterion = Restrictions.Eq("StoreHouseID", PojoUtil.InitPojo <Storehouse>(storeHouseID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(retMember))
{
ICriterion criterion = Restrictions.Like("RetMember", retMember, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(approvalID))
{
ICriterion criterion = Restrictions.Eq("ApprovalID", PojoUtil.InitPojo <Employee>(approvalID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(approvalTime))
{
ICriterion criterion = Restrictions.Like("ApprovalTime", approvalTime, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(state))
{
ICriterion criterion = Restrictions.Like("State", state, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(totalMoney))
{
ICriterion criterion = Restrictions.Like("TotalMoney", totalMoney, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("RetOrderCode"));
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string reqOrderCode, string srcHouseID, string destHouseID, string carrier, string approvalID, string oPerTime, string approvalTime, string state)
{
return(Json(reqOrderOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(reqOrderCode))
{
ICriterion criterion = Restrictions.Like("ReqOrderCode", reqOrderCode, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(srcHouseID))
{
ICriterion criterion = Restrictions.Eq("SrcHouseID", PojoUtil.InitPojo <Storehouse>(srcHouseID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(destHouseID))
{
ICriterion criterion = Restrictions.Eq("DestHouseID", PojoUtil.InitPojo <Storehouse>(destHouseID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(carrier))
{
ICriterion criterion = Restrictions.Like("Carrier", carrier, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(approvalID))
{
ICriterion criterion = Restrictions.Eq("ApprovalID", PojoUtil.InitPojo <Employee>(approvalID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(oPerTime))
{
ICriterion criterion = Restrictions.Like("OPerTime", oPerTime, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(approvalTime))
{
ICriterion criterion = Restrictions.Like("ApprovalTime", approvalTime, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(state))
{
ICriterion criterion = Restrictions.Like("State", state, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("ReqOrderCode"));
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string cls)
{
return(Json(modFuncOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(cls))
{
ICriterion criterion = Restrictions.Eq("Cls", cls);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("Cls"));
}
, pageSize, pageNum)));
}
public IList <EmpModFunc> GetEmpModFuncs(EmpModFunc.RoleFlagVal roleFlag, Guid id)
{
IList <EmpModFunc> retVal = empModFuncOper.Get(
delegate(object sender, ICriteria criteria)
{
ICriterion criterion = null;
string strRoleFlag = EmpModFunc.RoleFlagValStr(roleFlag);
criterion = Restrictions.Eq("RoleFlag", strRoleFlag);
criteria.Add(criterion);
criterion = Restrictions.Eq("RoleId", id);
criteria.Add(criterion);
}
);
return(retVal);
}
public ActionResult Get(int pageSize, int pageNum, string storehouseID, string goodsID)
{
return(Json(sellPriceInfoOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(storehouseID))
{
ICriterion criterion = Restrictions.Eq("Storehouse", PojoUtil.InitPojo <Storehouse>(storehouseID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(goodsID))
{
ICriterion criterion = Restrictions.Eq("Goods", PojoUtil.InitPojo <GoodsInfo>(goodsID));
criteria.Add(criterion);
}
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string name, string nickname, string phoneNum, string tel, string qq, string weiXin, string email)
{
return(Json(customerOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(name))
{
ICriterion criterion = Restrictions.Like("Name", name, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(nickname))
{
ICriterion criterion = Restrictions.Like("Nickname", nickname, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(phoneNum))
{
ICriterion criterion = Restrictions.Like("PhoneNum", phoneNum, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(tel))
{
ICriterion criterion = Restrictions.Like("Tel", tel, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(qq))
{
ICriterion criterion = Restrictions.Like("QQ", qq, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(weiXin))
{
ICriterion criterion = Restrictions.Like("WeiXin", weiXin, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(email))
{
ICriterion criterion = Restrictions.Like("Email", email, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Desc("ModDate"));
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string roleFlag, string roleId)
{
return(Json(photoOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(roleFlag))
{
ICriterion criterion = Restrictions.Eq("RoleFlag", roleFlag);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(roleId))
{
ICriterion criterion = Restrictions.Eq("RoleId", new Guid(roleId));
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("RoleFlag"));
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string storehouseId, string goodsId)
{
return(Json(stockInitOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(storehouseId))
{
ICriterion criterion = Restrictions.Eq("Storehouse", PojoUtil.InitPojo <Storehouse>(storehouseId));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(goodsId))
{
ICriterion criterion = Restrictions.Eq("Goods", PojoUtil.InitPojo <GoodsInfo>(goodsId));
criteria.Add(criterion);
}
//创建对象属性别名
criteria.CreateAlias("Storehouse", "sh");
criteria.AddOrder(Order.Asc("sh.StoreName"));
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string name, string addr)
{
return(Json(gardenOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(name))
{
ICriterion criterion = Restrictions.Like("Name", name, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(addr))
{
ICriterion criterion = Restrictions.Like("Addr", addr, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Desc("ModDate"));
criteria.AddOrder(Order.Asc("AddrCode"));
// ICriterion criterion = Restrictions.Eq("Name", "测试123");
// criteria.Add(criterion);
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string sellOrderCode, string storeHouseID, string salespersonID, string salespersonDeptID, string sellDateTime, string totalMoney)
{
return(Json(sellOrderOper.Get(
delegate(object sender, ICriteria criteria) {
if (!string.IsNullOrEmpty(sellOrderCode))
{
ICriterion criterion = Restrictions.Like("SellOrderCode", sellOrderCode, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(storeHouseID))
{
ICriterion criterion = Restrictions.Eq("StoreHouseID", PojoUtil.InitPojo <Storehouse>(storeHouseID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(salespersonID))
{
ICriterion criterion = Restrictions.Eq("SalespersonID", PojoUtil.InitPojo <Employee>(salespersonID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(salespersonDeptID))
{
ICriterion criterion = Restrictions.Eq("SalespersonDeptID", PojoUtil.InitPojo <Department>(salespersonDeptID));
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(sellDateTime))
{
ICriterion criterion = Restrictions.Like("SellDateTime", sellDateTime, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(totalMoney))
{
ICriterion criterion = Restrictions.Like("TotalMoney", totalMoney, MatchMode.Anywhere);
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("SellOrderCode"));
}
, pageSize, pageNum)));
}
public ActionResult Get(int pageSize, int pageNum, string storeCode, string storeName, string deptID)
{
return(Json(storehouseOper.Get(
delegate(object sender, ICriteria criteria)
{
if (!string.IsNullOrEmpty(storeCode))
{
ICriterion criterion = Restrictions.Like("StoreCode", storeCode, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(storeName))
{
ICriterion criterion = Restrictions.Like("StoreName", storeName, MatchMode.Anywhere);
criteria.Add(criterion);
}
if (!string.IsNullOrEmpty(deptID))
{
ICriterion criterion = Restrictions.Eq("Dept", PojoUtil.InitPojo <Department>(deptID));
criteria.Add(criterion);
}
criteria.AddOrder(Order.Asc("StoreName"));
}
, pageSize, pageNum)));
}
public ActionResult DownLoadDept()
{
string fileName = Server.MapPath("/") + @"Files\Temp\"+"1.xlsx";
IList<ExcelField> fields=new List<ExcelField>();
ExcelField ef=null;
ef=new ExcelField("Code","代码");
fields.Add(ef);
ef = new ExcelField("Name", "名字");
fields.Add(ef);
ef = new ExcelField("TestExcel", "测试Excel");
fields.Add(ef);
TbBaseOper<Department> departmentOper = new TbBaseOper<Department>(HibernateOper, typeof(Department));
IList<Department> list=departmentOper.Get();
//ExportExcel ee = new ExportExcel(fileName, "abc", fields);
ExportExcel ee = new ExportExcel(fileName,typeof(Department));
ee.Save(list);
//返回文件
return File(fileName, "xlsx", "1.xlsx");
}
public ActionResult Get(int pageSize, int pageNum)
{
return(Json(modOper.Get(Get_OnCriteria, pageSize, pageNum)));
}