public MyResponseBase Execute() { //SoftProjectAreaEntity LoginInfo = HttpContext.Current.Session["LoginInfo"] as SoftProjectAreaEntity; #region 设置创建人、创建时间、更新人、更新时间 if (LoginInfo != null) { Item.CreateUserID = LoginInfo.Sys_LoginInfoID; Item.CreateUserName = LoginInfo.UserName; Item.UpdateUserID = LoginInfo.Sys_LoginInfoID; Item.UpdateUserName = LoginInfo.UserName; } #endregion Item.CreateDate = DateTime.Now; Item.UpdateDate = DateTime.Now; MyResponseBase response = new MyResponseBase(); if (!RAInfo.bError) { //数据库存操作 MyADORepository dal = new MyADORepository(this); dal.Execute(response); } return(response); }
/// <summary> /// 参数由配置文件完成 /// </summary> /// <returns></returns> public MyResponseBase AddSave() { var resp = new MyResponseBase(); SoftProjectAreaEntityDomain_Domain(); #region (2)添加 using (var scope = new TransactionScope()) { try { var DBFieldVals = Design_ModularOrFun.TSql; resp = AddSave(DBFieldVals); //if (Item.NextVisitDate != null) //{ // var sql = string.Format("Update Pre_User SET NextVisitDate='{0}' WHERE Pre_UserID={1}", Item.NextVisitDate.Format_yyyy_MM_dd(), Item.Pre_UserID); // Query16(sql, 1); //} scope.Complete(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } #endregion return(resp); }
/// <summary> /// 添加保存 /// </summary> /// <returns></returns> public MyResponseBase Fra_Activity_Add() { var resp = new MyResponseBase(); var sbsql = new StringBuilder(); sbsql.AppendLine("SELECT TOP 1 *"); sbsql.AppendLine("FROM [dbo].[Act_ActivityFlow]"); sbsql.AppendLine("WHERE ActivityFlowStatuID=1"); sbsql.AppendLine("ORDER BY ActivityFlowSort DESC"); resp = Query16(sbsql.ToString(), 4); resp.Item.ActivityFlowContext = resp.Item.ActivityFlowContext; sbsql = new StringBuilder(); sbsql.AppendLine("SELECT TOP 1 *"); sbsql.AppendLine("FROM Act_SurveyTemplate"); sbsql.AppendLine("WHERE SurveyTemplateStatuID=1"); sbsql.AppendLine("ORDER BY SurveyTemplateSort DESC"); var resp1 = Query16(sbsql.ToString(), 4); resp.Item.Act_SurveyTemplateID = resp1.Item.Act_SurveyTemplateID; resp.Item.ActivitySelfAtudyTable = resp1.Item.SurveyTemplateTitleContext; resp.Item.ApplyDate = DateTime.Now; resp.Item.ApplyPersonID = LoginInfo.Sys_LoginInfoID; resp.Item.ApplyPerson = LoginInfo.UserName; resp.Item.Pre_CompanyID = LoginInfo.CompanyID; return(resp); }
public ActionResult AuthorizationPanel() { MenuCode = "AuthorizationPanel"; var resp = new MyResponseBase(); return(View("SubPanel", resp)); }
public ActionResult Login(SoftProjectAreaEntityDomain domain) { //LoginInfo ss = new SoftProject.CellModel.SoftProjectAreaEntity(); var resp = new MyResponseBase(); resp.Item = domain.Item; if (domain.Item.MobilePhone != null) { try { resp = domain.Login(); Session["LoginInfo"] = resp.Item; if (resp.Item.LoginCategoryID == 1) { SoftProjectAreaEntityDomain.Sys_OperLogDetail_AddSave(1, 1, "登录", resp.Item.CompanyID, resp.Item.Sys_LoginInfoID, resp.Item.UserName, resp.Item.Sys_LoginInfoID, "登录"); } else { SoftProjectAreaEntityDomain.Sys_OperLogDetail_AddSave(2, 1, "登录", resp.Item.CompanyID, resp.Item.Sys_LoginInfoID, resp.Item.UserName, resp.Item.Sys_LoginInfoID, "登录"); } return(RedirectToAction("Index", "Home")); } catch (Exception e) { resp.Item.ErrorMessage = e.Message; return(View(resp)); } } return(View(resp)); }
/// <summary> /// 添加保存 /// </summary> /// <returns></returns> public MyResponseBase Pre_User_AddCompCPSave() { var resp = new MyResponseBase(); var bAddProduct = true;//是否添加加盟商零售价格商品 //(1)查询Sql语句 var sqlBC_PartnerProductPriceAddProduct = ProjectCache.Sys_HOperControls.Where(p => p.OperCode == "BC_Partner.BC_PartnerProductPriceAddProductPrice").FirstOrDefault().DBTSql; var sql = string.Format("SELECT * FROM Pre_Company WHERE Pre_CompanyID={0}", LoginInfo.CompanyID); var OperatingItemIDs = Query16(sql, 4).Item.OperatingItemIDs; if (string.IsNullOrEmpty(OperatingItemIDs)) { bAddProduct = false; } #region 添加加盟商 ValidateMobilePhoneAdd(); ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p => { resp = AddSaveNotTran(); if (bAddProduct) { sqlBC_PartnerProductPriceAddProduct = string.Format(sqlBC_PartnerProductPriceAddProduct, Item.Pre_CompanyID, resp.Item.Pre_UserID, OperatingItemIDs); Query16(sqlBC_PartnerProductPriceAddProduct, 1); } })); #endregion return(resp); }
/// <summary> /// 编辑保存 /// </summary> /// <returns></returns> public MyResponseBase C_Order_EditSave() { if (Item.C_OrderID == null) { throw new Exception("顾客订单ID:不能为空"); } #region 查询原订单金额 var sql = string.Format("SELECT * FROM C_Order WHERE C_OrderID={0}", Item.C_OrderID); var respOld = Query16(sql, 4); #endregion //编辑保存 var resp = new MyResponseBase(); Item.OrderAmount = Item.Items.Sum(p => p.CustomerSpecificationsPrice * p.Number); var OderAmountNew = Item.OrderAmount; ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p => { resp = EditSaveNotTran(); C_OrderDetail_AddEditDelete(); //更新数据库:用户帐户余额 sql = string.Format("UPDATE Pre_User SET FundBalance=ISNULL(FundBalance,0)-{0}+{1} WHERE Pre_UserID={2}", OderAmountNew, respOld.Item.OrderAmount, respOld.Item.Pre_UserID); Query16(sql, 1); //更新缓存:用户账户余额 var userItem = SoftProjectAreaEntityDomain.Pre_UserRoleAll.Where(o => o.Pre_UserID == respOld.Item.Pre_UserID).FirstOrDefault(); var OrderAmount = (userItem.FundBalance != null ? userItem.FundBalance : 0) - OderAmountNew + respOld.Item.OrderAmount; userItem.FundBalance = OrderAmount; })); return(resp); }
/// <summary> /// 添加管理员 /// </summary> /// <returns></returns> public MyResponseBase Pre_User_AddAdminSave() { var resp = new MyResponseBase(); //查询企业类型为2的管理员角色 var Pre_RoleID = SoftProjectAreaEntityDomain.Pre_Roles.Where(p => p.LoginCategoryID == 2 && p.BAdmin == 1).FirstOrDefault().Pre_RoleID; if (Pre_RoleID == null) { throw new Exception("企业管理员角色还不有添加"); } //(1)验证 ValidateMobilePhoneAdd(); ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p => { Pre_User_Domain(); Sys_HOperControl = null; Item.Pre_RoleID = Pre_RoleID; Item.UserCategoryID = 1; Item.UserStatuID = 1; Item.LoginCategoryID = 2; OperCode = "Pre_User.AddAdminSave"; Item.UserName = Item.PreCompanyName2; resp = Execute(); })); //(3)添加到缓存 Item.Pre_UserID = resp.Item.Pre_UserID; Pre_User_AddCache(); return(resp); }
public ActionResult IndexEdit(SoftProjectAreaEntityDomain domain) { //domain.Querys.Add(new Query { QuryType = 0, FieldName = "P_ProductID___equal", Value = domain.Item.P_ProductID.ToString() }); //ModularOrFunCode = "ProductAreas.P_ProductAttachment.IndexEdit"; //domain.Design_ModularOrFun = Design_ModularOrFun; //var resp = domain.QueryIndex(); //if (Request.IsAjaxRequest()) // return View(Design_ModularOrFun.PartialView, resp); //resp.ViewContextName = Design_ModularOrFun.PartialView; //return View(Design_ModularOrFun.MainView, resp); ////////////////////////////////////////////////// var resp = new MyResponseBase(); ModularOrFunCode = "ProductAreas.P_ProductAttachment.IndexEdit"; domain.Design_ModularOrFun = Design_ModularOrFun; if (!string.IsNullOrEmpty(domain.Item.ImageFileNameGuid)) { domain.Querys.Add(new Query { QuryType = 0, FieldName = "RefPKTableGuid___equal", Value = domain.Item.ImageFileNameGuid }); resp = domain.QueryIndex(); } if (Request.IsAjaxRequest()) { return(View(Design_ModularOrFun.PartialView, resp)); } resp.ViewContextName = Design_ModularOrFun.PartialView; return(View(Design_ModularOrFun.MainView, resp)); }
/// <summary> /// 编辑保存 /// </summary> /// <returns></returns> public MyResponseBase O_OrderDetail_EditSave() { //编辑保存 var resp = new MyResponseBase(); O_OrderDetail_PKCheck(); #region (2)编辑 using (var scope = new TransactionScope()) { try { O_OrderDetail_Domain(); //string DBFieldVals = "编辑的字段"; //resp = EditSave(DBFieldVals); OperCode = "O_OrderDetail.EditSave"; resp = Execute(); scope.Complete(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } #endregion return(resp); }
/// <summary> /// 编辑保存,包含更新企业管理员信息 /// </summary> /// <returns></returns> public MyResponseBase MG_MemberGrade_AddSave() { var resp = new MyResponseBase(); var bAddProduct = true;//是否添加加盟商零售价格商品 //添加加盟商零售价格表的商品并设置有效值 //(1)查询Sql语句 var sqlFra_ProductPriceAddProduct = ProjectCache.Sys_HOperControls.Where(p => p.OperCode == "MG_MemberGrade.Fra_ProductPriceAddProduct").FirstOrDefault().DBTSql; //(2)查找加盟商授权的商品类别 var sql = string.Format("SELECT * FROM Pre_Company WHERE Pre_CompanyID={0}", Item.Pre_CompanyID); var OperatingItemIDs = Query16(sql, 4).Item.OperatingItemIDs; if (string.IsNullOrEmpty(OperatingItemIDs)) { bAddProduct = false; } ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p => { resp = AddSaveNotTran(); if (bAddProduct) { sqlFra_ProductPriceAddProduct = string.Format(sqlFra_ProductPriceAddProduct, Item.Pre_CompanyID, resp.Item.MG_MemberGradeID, OperatingItemIDs); Query16(sqlFra_ProductPriceAddProduct, 1); } })); return(resp); }
/// <summary> /// 添加保存 /// </summary> /// <returns></returns> public MyResponseBase O_OrderDetail_AddSave() { //添加保存 var resp = new MyResponseBase(); #region (2)添加 using (var scope = new TransactionScope()) { try { O_OrderDetail_Domain(); //string DBFieldVals = "添加的字段"; //resp = AddSave(DBFieldVals); OperCode = "O_OrderDetail.AddSave"; Sys_HOperControl = null; resp = Execute(); scope.Complete(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } #endregion return(resp); }
/// <summary> /// 根据页面ID查询页面字段 /// </summary> /// <returns></returns> public MyResponseBase BC_OrderDetail_Rows() { //Item.Fra_ProductPriceIDs MyResponseBase resp = new MyResponseBase(); if (Item.BC_PartnerProductPriceID == null) { throw new Exception("合作商商品价格ID主键不能为空!"); } string sql = string.Format("SELECT * FROM V_BC_PartnerProductPrice WHERE BC_PartnerProductPriceID={0} ", Item.BC_PartnerProductPriceID); resp = Query16(sql, 2); //清空价格 // 订单明细ID(tddata)、商品ID(tddata)、数量(text)、单价(只读)、规格价格(隐藏)、总价(标签:后台计算)、 resp.Items.ForEach(p => { p.Number = 1; //p.CustomerProductPrice = p.CustomerProductPrice; //p.CustomerSpecificationsPrice = p.CustomerSpecificationsPrice; //p.BCProductPrice = p.BCProductPrice; //p.BCSpecificationsPrice=BCSpecificationsPrice; p.PriceTotal = p.Number * p.BCSpecificationsPrice; }); return(resp); }
/// <summary> /// 最后1个订单 /// </summary> /// <returns></returns> public MyResponseBase C_Recharge_EditSave() { if (Item.C_RechargeID == null) { throw new Exception("充值记录ID不能为空"); } #region 查询原记录 var sql = string.Format("SELECT * FROM C_Recharge WHERE C_RechargeID={0}", Item.C_RechargeID); var respOld = Query16(sql, 4); #endregion var resp = new MyResponseBase(); ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p => { resp = EditSaveNotTran(); //更新数据库:用户帐户余额 sql = string.Format("UPDATE Pre_User SET FundBalance=ISNULL(FundBalance,0)+{0}-{1} WHERE Pre_UserID={2}", Item.Amount, respOld.Item.Amount, respOld.Item.Pre_UserID); Query16(sql, 1); //更新缓存:用户账户余额 var userItem = SoftProjectAreaEntityDomain.Pre_UserRoleAll.Where(o => o.Pre_UserID == respOld.Item.Pre_UserID).FirstOrDefault(); userItem.FundBalance = (userItem.FundBalance != null? userItem.FundBalance:0) + Item.Amount - respOld.Item.Amount; })); return(resp); }
public ActionResult FraMagerIndex() { MyResponseBase resp = new MyResponseBase(); var domain = new SoftProjectAreaEntityDomain(); resp = domain.Doc_Docment_Home(); return(View(resp)); }
/// <summary> /// 操作日志--根据类别主键查询 /// </summary> /// <returns></returns> public MyResponseBase Sys_OperLogDetail_Index() { OperCode = "Sys_OperLogDetail.Index"; resp = Execute(); //resp.Item = new Sys_OperLogView(this.Item); return(resp); }
/// <summary> /// 默认Model对象 /// </summary> public MyResponseBase Default() { var resp = new MyResponseBase { Item = new SoftProjectAreaEntity() }; return(resp); }
/// <summary> /// 操作日志--根据类别主键查询 /// </summary> /// <returns></returns> public MyResponseBase Sys_OperLogDetail_ByOperLogIdent() { OperCode = "Sys_OperLogDetail.ByOperLogIdent"; resp = Execute(); //resp.Item = new Sys_OperLogView(this.Item); return(resp); }
/// <summary> /// 查询:根据ID查询 /// </summary> /// <returns></returns> public MyResponseBase Sys_OperLogDetail_GetByID() { if (Sys_OperLogDetail_PKCheck()) { this.OperCode = "Sys_OperLogDetail.ByID"; resp = Execute(); } return(resp); }
/// <summary> /// 用户管理--显示修改修改密码页面 /// </summary> /// <param name="domain"></param> /// <returns></returns> public ActionResult ChangePass(SoftProjectAreaEntityDomain domain) { var resp = new MyResponseBase(); resp.FunNameEn = "Edit"; ModularOrFunCode = "AuthorizationAreas.Pre_User.ChangePass"; resp.ViewContextName = Design_ModularOrFun.PartialView; return(View(Design_ModularOrFun.MainView, resp)); }
/// <summary> /// 编辑保存 /// </summary> /// <returns></returns> public MyResponseBase Pre_User_EditByMySave() { var resp = new MyResponseBase(); ValidateMobilePhoneUpdate(); resp = EditSave(); Pre_User_UpdateCacheByMy(); return(resp); }
/// <summary> /// 添加保存 /// </summary> /// <returns></returns> public MyResponseBase Pre_User_AddSave() { var resp = new MyResponseBase(); ValidateMobilePhoneAdd(); resp = AddSave(); Item.Pre_UserID = resp.Item.Pre_UserID; Pre_User_AddCache(); return(resp); }
/// <summary> /// 为缓存 /// </summary> /// <returns></returns> public List <SoftProjectAreaEntity> Ba_Area_GetAll() { var resp = new MyResponseBase(); StringBuilder sbSql = new StringBuilder(); string sql = "SELECT * FROM Ba_Area Order By AreaCode"; resp = Query16(sql, 2); return(resp.Items); }
/// <summary> /// 编辑保存 /// </summary> /// <returns></returns> public MyResponseBase Pre_Role_EditSave() { var resp = new MyResponseBase(); resp = ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p => { resp = EditSaveNotTran(); Pre_RolePremSet_AddUpdateDeleteSaves(); })); Pre_Role_UpdateCache();//更新缓存 return(resp); }
/// <summary> /// 编辑单个对象,参数由配置文件完成 /// </summary> /// <param name="DBFieldVals"></param> /// <returns></returns> public MyResponseBase EditSave() { MyResponseBase resp = new MyResponseBase(); SoftProjectAreaEntityDomain_Domain(); #region 主键检查 //var PKFieldValue = 0; if (string.IsNullOrEmpty(PKField)) { throw new Exception(ModularName + "主键字段名:不能为空!"); } var type = Item.GetType(); //获取类型 PropertyInfo propertyInfo = type.GetProperty(PKField); var PrimaryKeyItem = propertyInfo.GetValue(Item, null); if (PrimaryKeyItem == null || PrimaryKeyItem == DBNull.Value) { throw new Exception(ModularName + "主键值:不能为空!"); } #endregion #region (2)编辑 using (var scope = new TransactionScope()) { try { //Comp_Company_Domain(); var DBFieldVals = Design_ModularOrFun.TSql; var hOperControl = new SoftProjectAreaEntity { DBOperType = 2, DBSelectResultType = 1, DBSqlParam = DBFieldVals }; Sys_HOperControl = hOperControl; resp = Execute(); scope.Complete(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } #endregion return(resp); }
/// <summary> /// 根据页面ID查询页面字段 /// </summary> /// <returns></returns> public MyResponseBase Design_ModularPageField_Rows() { MyResponseBase resp = new MyResponseBase(); //string sql = "SELECT * FROM V_Design_ModularPageField Order By TableInfoSort"; string sql = string.Format("SELECT * FROM Design_ModularField WHERE Design_ModularFieldID IN({0}) ", Item.Design_ModularFieldIDs); resp = Query16(sql, 2); ////(2)查询模块编码字段 //var ModularFields = Design_ModularField_GetModularPageOrQueryField(Item.Design_ModularOrFunID); //resp.Item.Design_ModularFields = ModularFields; return(resp); }
public MyResponseBase Design_ModularOrFunBtnControll_Rows() { MyResponseBase resp = new MyResponseBase(); string sql = string.Format("SELECT * FROM Design_ModularOrFunControll WHERE Design_ModularOrFunControllID IN({0}) ", Item.Design_ModularOrFunControllIDs); resp = Query16(sql, 2); ////(2)查询模块编码字段 //var ModularFields = Design_ModularField_GetModularPageOrQueryField(Item.Design_ModularOrFunID); //resp.Item.Design_ModularFields = ModularFields; return(resp); }
/// <summary> /// sql语句由数据库年提供 /// </summary> /// <returns></returns> public MyResponseBase EditSaves() { MyResponseBase resp = new MyResponseBase(); Sys_HOperControl = null; foreach (var item in Items) { Item = item; resp = Execute(); } return(resp); }
/// <summary> /// 编辑保存,包含更新企业管理员信息 /// </summary> /// <returns></returns> public MyResponseBase Pre_Company_EditSave() { var resp = new MyResponseBase(); #region 数据处理 if (Item.Ba_AreaID1 != null) { Item.AreaName1 = SoftProjectAreaEntityDomain.Ba_Area_GetByAreaID(Item.Ba_AreaID1).AreaName; Item.AreaName = Item.AreaName1; } if (Item.Ba_AreaID2 != null) { Item.AreaName2 = SoftProjectAreaEntityDomain.Ba_Area_GetByAreaID(Item.Ba_AreaID2).AreaName; Item.AreaName += Item.AreaName2; } if (Item.Ba_AreaID3 != null) { Item.AreaName3 = SoftProjectAreaEntityDomain.Ba_Area_GetByAreaID(Item.Ba_AreaID3).AreaName; Item.AreaName += Item.AreaName3; } //经营项目:字符串 if (!string.IsNullOrEmpty(Item.OperatingItemIDs))// != null && Item.OperatingItemIDs.Count > 0) { Item.OperatingItemIDs = Item.OperatingItemIDs.Substring(0, Item.OperatingItemIDs.Length - 1); var arrs = Item.OperatingItemIDs.Split(','); var OperatingItemNames = ""; foreach (var s in arrs) { OperatingItemNames += SoftProjectAreaEntityDomain.P_Categorys.Where(p => p.P_CategoryID.ToString() == s).FirstOrDefault().PCategoryName + ","; } Item.OperatingItemName = OperatingItemNames.Substring(0, OperatingItemNames.Length - 1); } #endregion //更新加盟商零售价格表的商品为有效值 var sqlProductPrice = ProjectCache.Sys_HOperControls.Where(p => p.OperCode == "Pre_Company.Fra_ProductPriceByUpdateBValidate").FirstOrDefault().DBTSql; sqlProductPrice = string.Format(sqlProductPrice, Item.Pre_CompanyID, Item.OperatingItemIDs); //更新加盟商的合作商价格表的商品为有效值 var sqlPartnerProductPrice = ProjectCache.Sys_HOperControls.Where(p => p.OperCode == "Pre_Company.BC_PartnerProductPriceByUpdateBValidate").FirstOrDefault().DBTSql; sqlPartnerProductPrice = string.Format(sqlPartnerProductPrice, Item.Pre_CompanyID, Item.OperatingItemIDs); resp = ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p => { resp = EditSaveNotTran(); Pre_User_EditAdminSave(); Query16(sqlProductPrice, 1); //更新加盟商零售价格表中,商品有效性。 Query16(sqlPartnerProductPrice, 1); //更新加盟商的合作商价格表中,商品有效性。 })); return(resp); }
public ActionResult Dashboard(SoftProjectAreaEntityDomain domain) { if (domain.Item.Pre_CompanyID == null) { throw new Exception("加盟商ID不能为空"); } var resp = new MyResponseBase { Item = domain.Item }; ModularOrFunCode = "AuthorizationAreas.Pre_Company.Dashboard"; domain.Design_ModularOrFun = Design_ModularOrFun; return(View("Dashboard", resp)); }