/// <summary> /// 将ORDER00记录实体(SubSonic实体)转换为普通的实体(DataAccess.Model.ORDER00) /// </summary> /// <param name="model">SubSonic插件生成的实体</param> /// <returns>DataAccess.Model.ORDER00</returns> public DataAccess.Model.ORDER00 Transform(ORDER00 model) { if (model == null) { return(null); } return(new DataAccess.Model.ORDER00 { Id = model.Id, SHOP_ID = model.SHOP_ID, ORDER_ID = model.ORDER_ID, INPUT_DATE = model.INPUT_DATE, ORD_USER = model.ORD_USER, EXPECT_DATE = model.EXPECT_DATE, STATUS = model.STATUS, ORD_TYPE = model.ORD_TYPE, OUT_SHOP = model.OUT_SHOP, EXPORTED_ID = model.EXPORTED_ID, EXPORTED = model.EXPORTED, APP_USER = model.APP_USER, APP_DATE = model.APP_DATE, Memo = model.Memo, LOCKED = model.LOCKED, ORD_DEP_ID = model.ORD_DEP_ID, CRT_DATETIME = model.CRT_DATETIME, CRT_USER_ID = model.CRT_USER_ID, MOD_DATETIME = model.MOD_DATETIME, MOD_USER_ID = model.MOD_USER_ID, LAST_UPDATE = model.LAST_UPDATE, Trans_STATUS = model.Trans_STATUS, }); }
/// <summary> /// 添加与编辑ORDER00记录 /// </summary> /// <param name="page">当前页面指针</param> /// <param name="model">ORDER00表实体</param> /// <param name="content">更新说明</param> /// <param name="isCache">是否更新缓存</param> /// <param name="isAddUseLog">是否添加用户操作日志</param> public void Save(Page page, ORDER00 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 ? "添加" : "编辑") + "ORDER00记录成功,ID为【" + model.Id + "】"; } //添加用户访问记录 UseLogBll.GetInstence().Save(page, content); } } catch (Exception e) { var result = "执行ORDER00Bll.Save()函数出错!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } }
/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="id">主键Id</param> /// <returns>DataAccess.Model.ORDER00</returns> public DataAccess.Model.ORDER00 GetModelForCache(long id) { try { //从缓存中读取指定Id记录 var model = GetModelForCache(x => x.Id == id); if (model == null) { //从数据库中读取 var tem = ORDER00.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缓存中获取ORDER00表记录时出现异常", e); return(null); } }
/// <summary> /// 获取指定Id记录 /// </summary> /// <param name="id">主键Id</param> /// <param name="isCache">是否从缓存中读取</param> /// <returns>DataAccess.Model.ORDER00</returns> public DataAccess.Model.ORDER00 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 = ORDER00.SingleOrDefault(x => x.Id == id); if (model == null) { return(null); } else { //对查询出来的实体进行转换 return(Transform(model)); } } }
/// <summary> /// 主表保存 /// </summary> /// <returns></returns> public string MAINEdit() { string _OUT_ID = tbxOUT_ID.Text; try { var model = new OUT00(x => x.OUT_ID == _OUT_ID); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); string _SHOP_ID = ddlSHOP_NAME.SelectedValue; if (String.IsNullOrEmpty(_OUT_ID)) { model.SetIsNew(true); model.CRT_DATETIME = DateTime.Now; model.CRT_USER_ID = OlUser.Manager_LoginName; DataTable dt = new DataTable(); dt = (DataTable)SPs.Get_ORDER_SEED(_SHOP_ID, "OUT00").ExecuteDataTable(); _OUT_ID = dt.Rows[0]["PLANE_ID"].ToString(); tbxOUT_ID.Text = _OUT_ID; //var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == _Pur00_id); } model.SHOP_ID = _SHOP_ID; model.OUT_ID = _OUT_ID.ToString(); model.STATUS = ConvertHelper.Cint(ddlStatus.SelectedValue); model.INPUT_DATE = ConvertHelper.StringToDatetime(dpINPUT_DATE.SelectedDate.ToString()); model.IN_SHOP = ddlIN_SHOP.SelectedValue; model.STOCK_ID = ddlSTOCK_ID.SelectedValue; model.USER_ID = OlUser.Manager_LoginName; model.APP_USER = OlUser.Manager_LoginName; model.APP_DATETIME = tbxAPP_DATETIME.Text == "" ? DateTime.Parse("1900-01-01 00:00:00") : DateTime.Now; model.EXPECT_DATE = ConvertHelper.StringToDatetime(dpEXPECT_DATE.SelectedDate.ToString()); model.Exported = ConvertHelper.StringToByte(cbExported.Checked ? "1" : "0"); model.Exported_ID = tbxExported_ID.Text; string _RELATE_ID = tbxRELATE_ID.Text; model.RELATE_ID = _RELATE_ID; if (!String.IsNullOrEmpty(_RELATE_ID)) { var modelOrder = new ORDER00(x => x.ORDER_ID == _RELATE_ID); modelOrder.EXPORTED = 1; modelOrder.Save(); } model.Memo = tbxMemo.Text; model.LOCKED = ConvertHelper.StringToByte(ckLOCKED.Checked ? "1" : "0"); model.MOD_DATETIME = DateTime.Now; model.MOD_USER_ID = OlUser.Manager_LoginName; model.LAST_UPDATE = DateTime.Now; model.Trans_STATUS = 0; OUT00Bll.GetInstence().Save(this, model); LoadMAIN(); } catch (Exception err) { return(err.Message); } return(""); }
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(ORDER00.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 <ORDER00, bool> > expression, bool isAddUseLog = true) { //执行删除 ORDER00.Delete(expression); //判断是否启用缓存 if (CommonBll.IsUseCache()) { //清空当前表所有缓存记录 DelAllCache(); //重新载入缓存 GetList(); } if (isAddUseLog) { //添加用户操作记录 UseLogBll.GetInstence().Save(page, "{0}删除了ORDER00表记录!"); } }
/// <summary> /// 判断出货订单是否已经引入要货单,如果已经引入,则子表按钮禁用 /// </summary> /// <param name="model"></param> public void OrderStatus1(OUT00 model) { var _OUT_ID = model.OUT_ID; var model2 = new ORDER00(x => x.EXPORTED_ID == _OUT_ID); if (model2.Id > 0) { ButtonYR.Enabled = true; ButtonYR.Text = "取消引入"; Toolbar21111.Enabled = false; return; } else { ButtonYR.Text = "引入"; ButtonYR.Enabled = true; Toolbar21111.Enabled = true; return; } }
public override void Approval() { string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 txtAPP_USER.Text = manager_LoginName; txtAPP_DATE.SelectedDate = DateTime.Now; ddlStatus.SelectedValue = "2"; string ORDER_ID = txtORDER_ID.Text.Trim(); var model = new ORDER00(x => x.ORDER_ID == ORDER_ID); model.APP_USER = txtAPP_USER.Text; model.APP_DATE = ConvertHelper.StringToDatetime(txtAPP_DATE.SelectedDate.ToString()); model.STATUS = 2; ORDER00Bll.GetInstence().Save(this, model); ButtonPowers(); }
/// <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; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 //if (string.IsNullOrEmpty(txtAREA_NAME.Text.Trim())) //{ // return txtAREA_NAME.Label + "不能为空!"; //} //var sName = StringHelper.Left(txtName.Text, 50); //if (BranchBll.GetInstence().Exist(x => x.Name == sName && x.Id != id)) //{ // return txtName.Label + "已存在!请重新输入!"; //} //if (string.IsNullOrEmpty(txtId.Text.Trim())) //{ // return txtId.Label + "不能为空!"; //} //var sUrl = StringHelper.Left(txtUrl.Text, 400); //if (BranchBll.GetInstence().Exist(x => x.Url == sUrl && x.Id != id)) //{ // return txtUrl.Label + "已存在!请重新输入!"; //} #endregion #region 赋值 //读取资料 var model = new ORDER00(x => x.Id == id); model.SHOP_ID = txtSHOP_ID.Text; 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 = ConvertHelper.Cint0(ddlStatus.SelectedValue); 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 = ddlBranch.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 = ConvertHelper.StringToByte(txtTrans_STATUS.Text); #endregion //---------------------------------------------------------- //存储到数据库 ORDER00Bll.GetInstence().Save(this, model); } 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缓存中获取ORDER00表记录 /// </summary> /// <param name="isCache">是否从缓存中读取</param> public IList <DataAccess.Model.ORDER00> 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.ORDER00>)obj); } } else { //定义临时实体集 IList <DataAccess.Model.ORDER00> list = null; //获取全表缓存加载条件表达式 var exp = GetExpression <ORDER00>(); //如果条件为空,则查询全表所有记录 if (exp == null) { //从数据库中获取所有记录 var all = ORDER00.All(); list = all == null ? null : Transform(all.ToList()); } else { //从数据库中查询出指定条件的记录,并转换为指定实体集 var all = ORDER00.Find(exp); list = all == null ? null : Transform(all); } return(list); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取ORDER00表记录时出现异常", e); } return(null); }
/// <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> /// 更新IIS缓存中指定Id记录 /// </summary> /// <param name="model">记录实体</param> public void SetModelForCache(ORDER00 model) { SetModelForCache(Transform(model)); }
/// <summary> /// 从IIS缓存中获取指定Id记录 /// </summary> /// <param name="conditionColName">条件列名</param> /// <param name="value">条件值</param> /// <returns>DataAccess.Model.ORDER00</returns> public DataAccess.Model.ORDER00 GetModelForCache(string conditionColName, object value) { try { //从缓存中获取List var list = GetList(); DataAccess.Model.ORDER00 model = null; Expression <Func <ORDER00, 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 "INPUT_DATE": model = list.SingleOrDefault(x => x.INPUT_DATE == (DateTime)value); expression = x => x.INPUT_DATE == (DateTime)value; break; case "ORD_USER": model = list.SingleOrDefault(x => x.ORD_USER == (string)value); expression = x => x.ORD_USER == (string)value; break; case "EXPECT_DATE": model = list.SingleOrDefault(x => x.EXPECT_DATE == (DateTime)value); expression = x => x.EXPECT_DATE == (DateTime)value; break; case "STATUS": model = list.SingleOrDefault(x => x.STATUS == (int)value); expression = x => x.STATUS == (int)value; break; case "ORD_TYPE": model = list.SingleOrDefault(x => x.ORD_TYPE == (int)value); expression = x => x.ORD_TYPE == (int)value; break; case "OUT_SHOP": model = list.SingleOrDefault(x => x.OUT_SHOP == (string)value); expression = x => x.OUT_SHOP == (string)value; break; case "EXPORTED_ID": model = list.SingleOrDefault(x => x.EXPORTED_ID == (string)value); expression = x => x.EXPORTED_ID == (string)value; break; case "EXPORTED": model = list.SingleOrDefault(x => x.EXPORTED == (byte)value); expression = x => x.EXPORTED == (byte)value; break; case "APP_USER": model = list.SingleOrDefault(x => x.APP_USER == (string)value); expression = x => x.APP_USER == (string)value; break; case "APP_DATE": model = list.SingleOrDefault(x => x.APP_DATE == (DateTime)value); expression = x => x.APP_DATE == (DateTime)value; break; case "Memo": model = list.SingleOrDefault(x => x.Memo == (string)value); expression = x => x.Memo == (string)value; break; case "LOCKED": model = list.SingleOrDefault(x => x.LOCKED == (byte)value); expression = x => x.LOCKED == (byte)value; break; case "ORD_DEP_ID": model = list.SingleOrDefault(x => x.ORD_DEP_ID == (string)value); expression = x => x.ORD_DEP_ID == (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; case "LAST_UPDATE": model = list.SingleOrDefault(x => x.LAST_UPDATE == (DateTime)value); expression = x => x.LAST_UPDATE == (DateTime)value; break; case "Trans_STATUS": model = list.SingleOrDefault(x => x.Trans_STATUS == (byte)value); expression = x => x.Trans_STATUS == (byte)value; break; default: return(null); } if (model == null) { //从数据库中读取 var tem = ORDER00.SingleOrDefault(expression); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取ORDER00表记录时出现异常", e); return(null); } }