/// <summary> /// 将ORDER01记录实体(SubSonic实体)转换为普通的实体(DataAccess.Model.ORDER01) /// </summary> /// <param name="model">SubSonic插件生成的实体</param> /// <returns>DataAccess.Model.ORDER01</returns> public DataAccess.Model.ORDER01 Transform(ORDER01 model) { if (model == null) { return(null); } return(new DataAccess.Model.ORDER01 { Id = model.Id, SHOP_ID = model.SHOP_ID, ORDER_ID = model.ORDER_ID, SNo = model.SNo, PROD_ID = model.PROD_ID, QUANTITY = model.QUANTITY, ON_QUAN = model.ON_QUAN, QUAN1 = model.QUAN1, QUAN2 = model.QUAN2, COST_PRICE = model.COST_PRICE, STD_UNIT = model.STD_UNIT, STD_CONVERT = model.STD_CONVERT, STD_QUAN = model.STD_QUAN, STD_PRICE = model.STD_PRICE, Memo = model.Memo, CRT_DATETIME = model.CRT_DATETIME, CRT_USER_ID = model.CRT_USER_ID, MOD_DATETIME = model.MOD_DATETIME, MOD_USER_ID = model.MOD_USER_ID, }); }
/// <summary> /// 添加与编辑ORDER01记录 /// </summary> /// <param name="page">当前页面指针</param> /// <param name="model">ORDER01表实体</param> /// <param name="content">更新说明</param> /// <param name="isCache">是否更新缓存</param> /// <param name="isAddUseLog">是否添加用户操作日志</param> public void Save(Page page, ORDER01 model, string content = null, bool isCache = true, bool isAddUseLog = true) { try { //保存 model.Save(); //判断是否启用缓存 if (CommonBll.IsUseCache() && isCache) { SetModelForCache(model); } if (isAddUseLog) { if (string.IsNullOrEmpty(content)) { content = "{0}" + (model.Id == 0 ? "添加" : "编辑") + "ORDER01记录成功,ID为【" + model.Id + "】"; } //添加用户访问记录 UseLogBll.GetInstence().Save(page, content); } } catch (Exception e) { var result = "执行ORDER01Bll.Save()函数出错!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } }
/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="id">主键Id</param> /// <returns>DataAccess.Model.ORDER01</returns> public DataAccess.Model.ORDER01 GetModelForCache(long id) { try { //从缓存中读取指定Id记录 var model = GetModelForCache(x => x.Id == id); if (model == null) { //从数据库中读取 var tem = ORDER01.SingleOrDefault(x => x.Id == id); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取ORDER01表记录时出现异常", e); return(null); } }
/// <summary> /// 获取指定Id记录 /// </summary> /// <param name="id">主键Id</param> /// <param name="isCache">是否从缓存中读取</param> /// <returns>DataAccess.Model.ORDER01</returns> public DataAccess.Model.ORDER01 GetModel(long id, bool isCache = true) { //判断是否使用缓存 if (CommonBll.IsUseCache() && isCache) { //从缓存中获取List var list = GetList(); if (list == null) { return(null); } else { //在List查询指定主键Id的记录 return(list.SingleOrDefault(x => x.Id == id)); } } else { //从数据库中直接读取 var model = ORDER01.SingleOrDefault(x => x.Id == id); if (model == null) { return(null); } else { //对查询出来的实体进行转换 return(Transform(model)); } } }
public void Prod_Edit(string SNos) { string id = SNos + ""; string order_id = hidId.Text; if (id != "0") { int id_ = ConvertHelper.Cint0(SNos); //读取资料 var model_0 = new ORDER00(x => x.ORDER_ID == order_id); var model = new ORDER01(x => x.ORDER_ID == order_id && x.SNo == id_); // model.SHOP_ID = model_0.SHOP_ID;//分店编号 // FineUI.DropDownList ddlPROD_NAME1 = Window2.FindControl("ddlPROD_NAME1") as FineUI.DropDownList; // FineUI.TextBox ttxtPROD_ID = Window2.FindControl("txtPROD_ID") as FineUI.TextBox; var model_ = new PRODUCT00(x => x.PROD_ID == model.PROD_ID); // 读取商品主表 var model_0_ = new PRODUCT01(x => x.PROD_ID == model.PROD_ID); //读商品子表 // FineUI.TextBox ttxtPROD_SPEC = Window2.FindControl("txtPROD_SPEC") as FineUI.TextBox; // FineUI.TextBox ttxtON_QUAN = Window2.FindControl("txtON_QUAN") as FineUI.TextBox; // FineUI.TextBox ttxtPROD_UNIT = Window2.FindControl("txtPROD_UNIT") as FineUI.TextBox; // FineUI.TextBox ttxtU_Cost = Window2.FindControl("txtU_Cost") as FineUI.TextBox; // FineUI.TextBox ttxtTotal = Window2.FindControl("txtTotal") as FineUI.TextBox; // FineUI.TextBox ttxtOrder_QUAN = Window2.FindControl("txtOrder_QUAN") as FineUI.TextBox; // FineUI.TextBox ttxtMemo = Window2.FindControl("txtMemo") as FineUI.TextBox; ddlPROD_NAME1.SelectedValue = model.PROD_ID + ""; // ddlPROD_NAME1.SelectedItem.Text = model_.PROD_NAME1; txtPROD_SPEC.Text = model_.PROD_SPEC; // txtOrder_QUAN.Text = model_.Order_QUAN.ToString(); txtPROD_ID.Text = model.PROD_ID; txtON_QUAN.Text = ConvertHelper.Cint0(model.ON_QUAN.ToString()).ToString(); txtTotal.Text = model.QUAN1.ToString(); txtPROD_UNIT.Text = model.STD_UNIT; txtU_Cost.Text = model.STD_PRICE.ToString(); txtMemo.Text = model.Memo; } }
/// <summary> /// 判断指定主键Id的记录是否存在——在IIS缓存或数据库中查找 /// </summary> /// <param name="id">主键Id</param> /// <returns></returns> public bool Exist(int id) { if (id <= 0) { return(false); } //判断是否启用缓存 if (CommonBll.IsUseCache()) { return(Exist(x => x.Id == id)); } //从数据库中查找 return(ORDER01.Exists(x => x.Id == id)); }
/// <summary> /// 获取数据表中的某个值——从数据库中查询,如果使用了缓存,删除成功后会清空本表的所有缓存记录,然后重新加载进缓存 /// </summary> /// <param name="page">当前页面指针</param> /// <param name="expression">条件语句</param> /// <param name="isAddUseLog">是否添加用户操作日志</param> public void Delete(Page page, Expression <Func <ORDER01, bool> > expression, bool isAddUseLog = true) { //执行删除 ORDER01.Delete(expression); //判断是否启用缓存 if (CommonBll.IsUseCache()) { //清空当前表所有缓存记录 DelAllCache(); //重新载入缓存 GetList(); } if (isAddUseLog) { //添加用户操作记录 UseLogBll.GetInstence().Save(page, "{0}删除了ORDER01表记录!"); } }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { //判断 if (ddlShop.SelectedValue == "0") { return(ddlShop.Label + "不能为空!"); } if (ddlOUT_SHOP.SelectedValue == "0") { return(ddlOUT_SHOP.Label + "不能为空!"); } if (ddlORDER_DEP.SelectedValue == "0") { return(ddlORDER_DEP.Label + "不能为空!"); } //订单编号 if (txtORDER_ID.Text == "") { Random ran = new Random(); txtORDER_ID.Text = ddlShop.SelectedValue + "OR" + DateTime.Now.ToString("yyyy-MM-dd").Replace("-", "") + ran.Next(1000, 9999); } string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 txtAPP_USER.Text = manager_LoginName; txtAPP_DATE.SelectedDate = DateTime.Now; string ORDER_ID = txtORDER_ID.Text; // GridViewHelper.GetSelectedKey(Grid2, true); //获取价格区域 string shop_id = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); var model_SHOP = new SHOP00(x => x.SHOP_ID == shop_id); string prcarea_id = model_SHOP.SHOP_Price_Area; // 复制原始表格的结构 DataTable newTable = GetSourceData(ORDER_ID, prcarea_id).Clone(); DataRow newRow; JArray mergedData = Grid1.GetMergedData(); int i = 0; foreach (JObject mergedRow in mergedData) { string status = mergedRow.Value <string>("status"); int rowIndex = mergedRow.Value <int>("index"); JObject values = mergedRow.Value <JObject>("values"); i = i + 1; newRow = newTable.NewRow(); newRow[0] = rowIndex;//i;////j;// rowIndex; // 将行标识符设置为行索引号 newRow[1] = values.Value <string>("PROD_NAME1"); newRow[2] = values.Value <string>("PROD_ID"); newRow[3] = values.Value <string>("PROD_SPEC"); newRow[4] = values.Value <string>("PROD_UNIT"); newRow[5] = values.Value <string>("ON_QUAN"); newRow[6] = values.Value <string>("STD_PRICE"); newRow[7] = values.Value <string>("QUAN1"); newTable.Rows.Add(newRow); } // 更新数据源 Session[KEY_FOR_DATASOURCE_SESSION] = newTable; labResult.Text = ""; // String.Format("用户修改的数据:<pre>{0}</pre>", Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.Indented)); // MessageBox.Show(this,String.Format("用户修改的数据:<pre>{0}</pre>", Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.Indented))); // DataTable table = GetSourceData(); Grid1.DataSource = (DataTable)Session[KEY_FOR_DATASOURCE_SESSION];// table; Grid1.DataBind(); #region 数据验证 //判断列表 DataTable dt = (DataTable)Session[KEY_FOR_DATASOURCE_SESSION]; if (dt.Rows.Count <= 0 || Session[KEY_FOR_DATASOURCE_SESSION] == null) { return("要货明细不能为空!"); } #endregion //改变界面 ddlStatus.SelectedValue = "1" + ""; #region 赋值 主表 var model = new ORDER00(x => x.ORDER_ID == ORDER_ID); model.SHOP_ID = ddlShop.SelectedValue; model.ORDER_ID = txtORDER_ID.Text; model.INPUT_DATE = DateTime.Now; // ConvertHelper.StringToDatetime(txtINPUT_DATE.Text); model.ORD_USER = txtORD_USER.Text; model.EXPECT_DATE = DateTime.Now; // ConvertHelper.StringToDatetime(txtEXPECT_DATE.Text); model.STATUS = 1; model.ORD_TYPE = ConvertHelper.Cint0(ddlORD_TYPE.SelectedValue); model.OUT_SHOP = ddlOUT_SHOP.SelectedValue; model.EXPORTED_ID = txtEXPORTED_ID.Text; model.EXPORTED = ConvertHelper.StringToByte(txtEXPORTED.Text); model.APP_USER = txtAPP_USER.Text; model.APP_DATE = DateTime.Now;//ConvertHelper.StringToDatetime(txtAPP_DATE.Text); model.Memo = txtMemo.Text; model.LOCKED = ConvertHelper.StringToByte(cbLOCKED.Checked.ToString()); model.ORD_DEP_ID = ddlORDER_DEP.SelectedValue; model.CRT_DATETIME = DateTime.Now; //ConvertHelper.StringToDatetime(txtCRT_DATETIME.Text); model.CRT_USER_ID = txtCRT_USER_ID.Text; model.MOD_DATETIME = DateTime.Now; //ConvertHelper.StringToDatetime(txtMOD_DATETIME.Text); model.MOD_USER_ID = txtMOD_USER_ID.Text; model.LAST_UPDATE = DateTime.Now; //ConvertHelper.StringToDatetime(txtLAST_UPDATE.Text); model.Trans_STATUS = 0; #endregion //---------------------------------------------------------- //存储到数据库 ORDER00Bll.GetInstence().Save(this, model); //清空子表 ORDER00Bll.GetInstence().Delete(model.ORDER_ID); #region 添加子表 JArray mergedData1 = Grid1.GetMergedData(); int f = mergedData.Count; int k = 0; foreach (JObject mergedRow in mergedData1) { string status = mergedRow.Value <string>("status"); int rowIndex = mergedRow.Value <int>("index"); JObject values = mergedRow.Value <JObject>("values"); k = k + 1; var model_1 = new ORDER01(x => x.SNo == k && x.ORDER_ID == txtORDER_ID.Text.Trim()); model_1.SNo = k;// rowIndex + 1; model_1.SHOP_ID = ddlShop.SelectedValue; model_1.ORDER_ID = txtORDER_ID.Text.Trim(); model_1.PROD_ID = values.Value <string>("PROD_ID"); model_1.QUANTITY = 0; model_1.ON_QUAN = ConvertHelper.StringToDecimal(values.Value <string>("ON_QUAN")); model_1.QUAN1 = ConvertHelper.StringToDecimal(values.Value <string>("QUAN1"));//小计 model_1.QUAN2 = 0; model_1.COST_PRICE = ConvertHelper.StringToDecimal(values.Value <string>("STD_PRICE")); model_1.STD_UNIT = values.Value <string>("PROD_UNIT"); model_1.STD_CONVERT = 0; model_1.STD_QUAN = ConvertHelper.StringToDecimal(values.Value <string>("ON_QUAN")); model_1.STD_PRICE = ConvertHelper.StringToDecimal(values.Value <string>("STD_PRICE")); model_1.Memo = ""; model_1.CRT_DATETIME = DateTime.Now; model_1.CRT_USER_ID = txtCRT_USER_ID.Text; model_1.MOD_DATETIME = DateTime.Now; model_1.MOD_USER_ID = txtMOD_USER_ID.Text; //---------------------------------------------------------- //存储到数据库 ORDER01Bll.GetInstence().Save(this, model_1); } ///grid2 conditionList = new List <ConditionFun.SqlqueryCondition>(); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER00Table.SHOP_ID, Comparison.Equals, shop_id, false, false)); // ORDER00Bll.GetInstence().BindGrid(Grid2, 0, sortList); // bll.BindGrid(Grid2, 0, sortList); ORDER00Bll.GetInstence().BindGrid(Grid2, 0, 0, conditionList, sortList); #endregion } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; string order_id = hidId.Text; try { #region 数据验证 if (ddlPROD_NAME1.Text.Trim() == "请选择商品名称") { return(ddlPROD_NAME1.Label + "请选择商品名称!"); } if (string.IsNullOrEmpty(txtPROD_ID.Text.Trim())) { return(txtPROD_ID.Label + "不能为空!"); } if (string.IsNullOrEmpty(txtPROD_UNIT.Text.Trim())) { return(txtPROD_UNIT.Label + "不能为空!"); } if (string.IsNullOrEmpty(txtU_Cost.Text.Trim())) { return(txtU_Cost.Label + "不能为空!"); } if (string.IsNullOrEmpty(txtOrder_QUAN.Text.Trim())) { return(txtOrder_QUAN.Label + "不能为空!"); } #endregion #region 赋值 int id = ConvertHelper.Cint0(RequestHelper.GetQueryString("Id")); //读取资料 var model_0 = new ORDER00(x => x.ORDER_ID == order_id); var model = new ORDER01(x => x.ORDER_ID == order_id && x.Id == id); model.SHOP_ID = model_0.SHOP_ID;//分店编号 //序号 conditionList = new List <ConditionFun.SqlqueryCondition>(); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER01Table.ORDER_ID, Comparison.Equals, order_id, false, false)); model.SNo = ORDER01Bll.GetInstence().GetRecordCount(conditionList) + 1; model.PROD_ID = txtPROD_ID.Text.Trim(); model.ORDER_ID = order_id; model.ON_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text.Trim()); model.QUAN1 = 0; model.QUAN2 = 0; model.COST_PRICE = 0; model.STD_UNIT = txtPROD_UNIT.Text; model.STD_CONVERT = 0; model.QUANTITY = model.STD_QUAN * model.STD_CONVERT; model.STD_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text); model.STD_PRICE = ConvertHelper.StringToDecimal(txtU_Cost.Text); model.Memo = txtMemo.Text; model.CRT_DATETIME = DateTime.Now; model.CRT_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName(); model.MOD_DATETIME = DateTime.Now; model.MOD_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName(); #endregion //---------------------------------------------------------- //存储到数据库 ORDER01Bll.GetInstence().Save(this, model); // PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 // CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; string order_id = hidId.Text; try { #region 数据验证 // FineUI.DropDownList dddlPROD_NAME1 = Window2.FindControl("ddlPROD_NAME1") as FineUI.DropDownList; if (ddlPROD_NAME1.SelectedText == "请选择") { return(ddlPROD_NAME1.Label + "请选择!"); } // FineUI.TextBox ttxtPROD_ID = Window2.FindControl("txtPROD_ID") as FineUI.TextBox; if (string.IsNullOrEmpty(txtPROD_ID.Text.Trim())) { return(txtPROD_ID.Label + "不能为空!"); } // FineUI.TextBox ttxtPROD_UNIT = Window2.FindControl("txtPROD_UNIT") as FineUI.TextBox; if (string.IsNullOrEmpty(txtPROD_UNIT.Text.Trim())) { return(txtPROD_UNIT.Label + "不能为空!"); } // FineUI.TextBox ttxtTotal = Window2.FindControl("txtTotal") as FineUI.TextBox; if (string.IsNullOrEmpty(txtTotal.Text.Trim())) { return(txtTotal.Label + "不能为空!"); } // FineUI.TextBox ttxtU_Cost = Window2.FindControl("txtU_Cost") as FineUI.TextBox; if (string.IsNullOrEmpty(txtU_Cost.Text.Trim())) { return(txtU_Cost.Label + "不能为空!"); } // FineUI.TextBox ttxtOrder_QUAN = Window2.FindControl("txtOrder_QUAN") as FineUI.TextBox; if (string.IsNullOrEmpty(txtOrder_QUAN.Text.Trim())) { return(txtOrder_QUAN.Label + "不能为空!"); } // FineUI.TextBox ttxtON_QUAN = Window2.FindControl("txtON_QUAN") as FineUI.TextBox; if (string.IsNullOrEmpty(txtON_QUAN.Text.Trim()) || txtON_QUAN.Text == "0") { return(txtON_QUAN.Label + "不能为空或者0!"); } // FineUI.TextBox ttxtMemo = Window2.FindControl("txtMemo") as FineUI.TextBox; #endregion #region 赋值 int id = ConvertHelper.Cint0(SNo.Text); //读取资料 var model_0 = new ORDER00(x => x.ORDER_ID == order_id); //序号 conditionList = new List <ConditionFun.SqlqueryCondition>(); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER01Table.ORDER_ID, Comparison.Equals, order_id, false, false)); if (IsEdit) { id = ConvertHelper.Cint0(GridViewHelper.GetSelectedKey(Grid2, true)); } else { id = ORDER01Bll.GetInstence().GetRecordCount(conditionList) + 1; } var model = new ORDER01(x => x.ORDER_ID == order_id && x.SNo == id); model.SHOP_ID = model_0.SHOP_ID;//分店编号 model.SNo = id; model.PROD_ID = txtPROD_ID.Text.Trim(); model.ORDER_ID = order_id; model.ON_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text.Trim()); model.QUAN1 = ConvertHelper.StringToDecimal(txtTotal.Text); model.QUAN2 = 0; model.COST_PRICE = 0; model.STD_UNIT = txtPROD_UNIT.Text; model.STD_CONVERT = 0; model.QUANTITY = model.STD_QUAN * model.STD_CONVERT; model.STD_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text); model.STD_PRICE = ConvertHelper.StringToDecimal(txtU_Cost.Text); model.Memo = txtMemo.Text; model.CRT_DATETIME = DateTime.Now; model.CRT_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName(); model.MOD_DATETIME = DateTime.Now; model.MOD_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName(); #endregion //---------------------------------------------------------- //存储到数据库 ORDER01Bll.GetInstence().Save(this, model); // Window2.Hidden = true; BindGrid2(); MessageBox.Show(this, "保存成功!"); // PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 // CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 从IIS缓存中获取ORDER01表记录 /// </summary> /// <param name="isCache">是否从缓存中读取</param> public IList <DataAccess.Model.ORDER01> GetList(bool isCache = true) { try { //判断是否使用缓存 if (CommonBll.IsUseCache() && isCache) { //检查指定缓存是否过期——缓存当天有效,第二天自动清空 if (CommonBll.CheckCacheIsExpired(const_CacheKey_Date)) { //删除缓存 DelAllCache(); } //从缓存中获取DataTable var obj = CacheHelper.GetCache(const_CacheKey); //如果缓存为null,则查询数据库 if (obj == null) { var list = GetList(false); //将查询出来的数据存储到缓存中 CacheHelper.SetCache(const_CacheKey, list); //存储当前时间 CacheHelper.SetCache(const_CacheKey_Date, DateTime.Now); return(list); } //缓存中存在数据,则直接返回 else { return((IList <DataAccess.Model.ORDER01>)obj); } } else { //定义临时实体集 IList <DataAccess.Model.ORDER01> list = null; //获取全表缓存加载条件表达式 var exp = GetExpression <ORDER01>(); //如果条件为空,则查询全表所有记录 if (exp == null) { //从数据库中获取所有记录 var all = ORDER01.All(); list = all == null ? null : Transform(all.ToList()); } else { //从数据库中查询出指定条件的记录,并转换为指定实体集 var all = ORDER01.Find(exp); list = all == null ? null : Transform(all); } return(list); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取ORDER01表记录时出现异常", e); } return(null); }
/// <summary> /// 更新IIS缓存中指定Id记录 /// </summary> /// <param name="model">记录实体</param> public void SetModelForCache(ORDER01 model) { SetModelForCache(Transform(model)); }
/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="conditionColName">条件列名</param> /// <param name="value">条件值</param> /// <returns>DataAccess.Model.ORDER01</returns> public DataAccess.Model.ORDER01 GetModelForCache(string conditionColName, object value) { try { //从缓存中获取List var list = GetList(); DataAccess.Model.ORDER01 model = null; Expression <Func <ORDER01, bool> > expression = null; //返回指定条件的实体 switch (conditionColName) { case "Id": model = list.SingleOrDefault(x => x.Id == (int)value); expression = x => x.Id == (int)value; break; case "SHOP_ID": model = list.SingleOrDefault(x => x.SHOP_ID == (string)value); expression = x => x.SHOP_ID == (string)value; break; case "ORDER_ID": model = list.SingleOrDefault(x => x.ORDER_ID == (string)value); expression = x => x.ORDER_ID == (string)value; break; case "SNo": model = list.SingleOrDefault(x => x.SNo == (int)value); expression = x => x.SNo == (int)value; break; case "PROD_ID": model = list.SingleOrDefault(x => x.PROD_ID == (string)value); expression = x => x.PROD_ID == (string)value; break; case "QUANTITY": model = list.SingleOrDefault(x => x.QUANTITY == (decimal)value); expression = x => x.QUANTITY == (decimal)value; break; case "ON_QUAN": model = list.SingleOrDefault(x => x.ON_QUAN == (decimal)value); expression = x => x.ON_QUAN == (decimal)value; break; case "QUAN1": model = list.SingleOrDefault(x => x.QUAN1 == (decimal)value); expression = x => x.QUAN1 == (decimal)value; break; case "QUAN2": model = list.SingleOrDefault(x => x.QUAN2 == (decimal)value); expression = x => x.QUAN2 == (decimal)value; break; case "COST_PRICE": model = list.SingleOrDefault(x => x.COST_PRICE == (decimal)value); expression = x => x.COST_PRICE == (decimal)value; break; case "STD_UNIT": model = list.SingleOrDefault(x => x.STD_UNIT == (string)value); expression = x => x.STD_UNIT == (string)value; break; case "STD_CONVERT": model = list.SingleOrDefault(x => x.STD_CONVERT == (int)value); expression = x => x.STD_CONVERT == (int)value; break; case "STD_QUAN": model = list.SingleOrDefault(x => x.STD_QUAN == (decimal)value); expression = x => x.STD_QUAN == (decimal)value; break; case "STD_PRICE": model = list.SingleOrDefault(x => x.STD_PRICE == (decimal)value); expression = x => x.STD_PRICE == (decimal)value; break; case "Memo": model = list.SingleOrDefault(x => x.Memo == (string)value); expression = x => x.Memo == (string)value; break; case "CRT_DATETIME": model = list.SingleOrDefault(x => x.CRT_DATETIME == (DateTime)value); expression = x => x.CRT_DATETIME == (DateTime)value; break; case "CRT_USER_ID": model = list.SingleOrDefault(x => x.CRT_USER_ID == (string)value); expression = x => x.CRT_USER_ID == (string)value; break; case "MOD_DATETIME": model = list.SingleOrDefault(x => x.MOD_DATETIME == (DateTime)value); expression = x => x.MOD_DATETIME == (DateTime)value; break; case "MOD_USER_ID": model = list.SingleOrDefault(x => x.MOD_USER_ID == (string)value); expression = x => x.MOD_USER_ID == (string)value; break; default: return(null); } if (model == null) { //从数据库中读取 var tem = ORDER01.SingleOrDefault(expression); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取ORDER01表记录时出现异常", e); return(null); } }