public HJsonResult Delete(SoftProjectAreaEntityDomain domain) { ModularOrFunCode = "ToolArea.T_ToolAttachment.Delete"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.DeleteByID(); return new HJsonResult(new { Data = resp }); }
/// <summary> /// 营销课堂--添加查询 /// </summary> /// <param name="domain"></param> /// <returns></returns> public ActionResult Add(SoftProjectAreaEntityDomain domain) { var resp = domain.Default(); resp.Item.HandoutFileNameGuid = Guid.NewGuid().ToString(); resp.Item.VideoFileNameGuid = Guid.NewGuid().ToString(); resp.EditActions = new List<SoftProjectAreaEntity> { new SoftProjectAreaEntity { LableTitle="讲义", ActionNameEn = "IndexEditHandout", ControllName = "M_MarketingAttachment", ActionFieldNames = "HandoutFileNameGuid", HandoutFileNameGuid = resp.Item.HandoutFileNameGuid, }, new SoftProjectAreaEntity { LableTitle="视频", ActionNameEn = "IndexEdit", ControllName = "M_MarketingAttachment", ActionFieldNames = "VideoFileNameGuid", VideoFileNameGuid = resp.Item.VideoFileNameGuid, }, }; ModularOrFunCode = "MarketingAreas.M_Marketing.Add"; resp.FunNameEn = "Add"; resp.ViewContextName = Design_ModularOrFun.PartialView; return View(Design_ModularOrFun.MainView, resp); }
public ActionResult CompMagerIndex() { MyResponseBase resp = new MyResponseBase(); var domain=new SoftProjectAreaEntityDomain(); resp = domain.Doc_Docment_Home(); return View(resp); }
///// <summary> ///// 自动匹配用户名 ///// </summary> ///// <param name="key"></param> ///// <returns></returns> //public JsonResult AutoCompletePartnerProduct(SoftProjectAreaEntityDomain domain)//string key, int Pre_UserID) //{ // //key = key.Trim().ToUpper(); // //var keyValueList = new List<Pre_UsersView>(); // //if (Pre_UsersDomain.Pre_UsersViews != null && Pre_UsersDomain.Pre_UsersViews.Count > 0) // //{ // // keyValueList = Pre_UsersDomain.Pre_UsersViews.Where(p => p.UserName.Contains(key)).ToList(); // //} // domain.Querys.Add(new Query { QuryType = 0, FieldName = "Pre_UserID___equal", Value = domain.Item.Pre_UserID.ToString() }); // domain.Querys.Add(new Query { QuryType = 0, FieldName = "ProductNo__ProductName__Specifications___like", Value = domain.Item.ProductNo__ProductName__Specifications }); // var resp = domain.BC_PartnerProductPrice_AutoCompletePartnerProduct(); // List<AutocompleteItem> AutocompleteItems = new List<AutocompleteItem>(); // //foreach (var item in resp.Items) // //{ // // AutocompleteItems.Add(new AutocompleteItem // // { // // text = item.ProductNo, // // label = item.ProductNo, // // value = item.BC_PartnerProductPriceID.ToString() // // }); // //} // AutocompleteItems.Add(new AutocompleteItem // { // text = "12345678", // label = "12345678", // value = "12345678" // }); // AutocompleteItems.Add(new AutocompleteItem // { // text = "22345678", // label = "22345678", // value = "22345678" // }); // AutocompleteItems.Add(new AutocompleteItem // { // text = "32345678", // label = "32345678", // value = "32345678" // }); // return Json(AutocompleteItems, JsonRequestBehavior.AllowGet); //} /// <summary> /// 自动匹配用商品价格表 /// </summary> /// <param name="key"></param> /// <returns></returns> public JsonResult AutoCompleteProductPrice(SoftProjectAreaEntityDomain domain) { //参数:用户ID+商品xxx //根据用户ID,查询用户会员等级,可以从缓存中获取 //查询条件:加盟商ID+会员等级+商品XXX //var MG_MemberGradeID = SoftProjectAreaEntityDomain.Pre_UserRoleAll.Where(p => p.Pre_UserID == domain.Item.Pre_UserID).First().MG_MemberGradeID; ModularOrFunCode = "PartnerAreas.BC_PartnerProductPrice.IndexEdit"; domain.Design_ModularOrFun = Design_ModularOrFun; //domain.Querys.Add(new Query { QuryType = 0, FieldName = "Pre_CompanyID___equal", Value = LoginInfo.CompanyID.ToString() }); //domain.Querys.Add(new Query { QuryType = 0, FieldName = "MG_MemberGradeID___equal", Value = MG_MemberGradeID.ToString() }); domain.Querys.Add(new Query { QuryType = 0, FieldName = "ProductNo__ProductName__Specifications___like", Value = domain.Item.ProductNo__ProductName__Specifications }); if (domain.Item.Pre_UserID == null) throw new Exception("合作商ID不能为空"); if (!domain.Querys.QueryDicts.ContainsKey("Pre_UserID___equal")) { domain.Querys.Add(new Query { QuryType = 0, FieldName = "Pre_UserID___equal", Value = domain.Item.Pre_UserID.ToString() }); } domain.PageQueryBase.PageSize = 10; var resp = domain.QueryIndex(); List<AutocompleteItem> AutocompleteItems = new List<AutocompleteItem>(); foreach (var item in resp.Items) { AutocompleteItems.Add(new AutocompleteItem { text = "【" + item.ProductNo + "】" + "【" + item.ProductName + "】" + "【" + item.Specifications + "】", label = "【" + item.ProductNo + "】" + "【" + item.ProductName + "】" + "【" + item.Specifications + "】", value = item.BC_PartnerProductPriceID.ToString() }); } return Json(AutocompleteItems, JsonRequestBehavior.AllowGet); }
public HJsonResult AddSave(SoftProjectAreaEntityDomain domain) { ModularOrFunCode = "PartnerAreas.BC_Order.Add"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.BC_Order_AddSave(); return new HJsonResult(new { Data = resp }); }
public ActionResult UpLoad(SoftProjectAreaEntityDomain domain) { #region 保存文件 if (domain.Item.Doc_BaseDocmentID == null) throw new Exception("文档ID不能为空"); domain.Item.AttachmentFileSizeDisp = ProjectCommon.FileSizeDisp(domain.Item.AttachmentFileSize); ModularOrFunCode = "DocArea.Doc_BaseDocmentAttachment.Upload"; domain.Design_ModularOrFun = Design_ModularOrFun; var respadd = domain.AddSave(); #endregion #region 查询 if (respadd.Item.Doc_BaseDocmentAttachmentID == null) throw new Exception("添加失败"); domain.Item.Doc_BaseDocmentAttachmentID = respadd.Item.Doc_BaseDocmentAttachmentID; ModularOrFunCode = "DocArea.Doc_BaseDocmentAttachment.Index"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.ByID(); resp.Items.Add(resp.Item); resp.FunNameEn = "Detail"; resp.ViewContextName = Design_ModularOrFun.PartialView; #endregion return View("Rows", 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> /// <param name="domain"></param> /// <returns></returns> public ActionResult Add(SoftProjectAreaEntityDomain domain) { var resp = domain.Default(); resp.Item.LoginCategoryID = 1; ModularOrFunCode = "PreOrg_Area.Pre_Organization.Add"; return View("PopupEdit", resp); }
/// <summary> /// 文档类别管理--添加查询 /// </summary> /// <param name="domain"></param> /// <returns></returns> public ActionResult Add(SoftProjectAreaEntityDomain domain) { var resp = domain.Default(); ModularOrFunCode = "DocArea.Doc_Category.Add"; // //resp.FunNameEn = ActionName; return View("PopupEdit", resp); }
/// <summary> /// 公司管理--添加查询 /// </summary> /// <param name="domain"></param> /// <returns></returns> public ActionResult Add(SoftProjectAreaEntityDomain domain) { var resp = domain.Default(); resp.FunNameEn = "Add"; ModularOrFunCode = "AuthorizationAreas.Pre_Company.Add"; resp.ViewContextName = Design_ModularOrFun.PartialView; return View(Design_ModularOrFun.MainView, resp); }
/// <summary> /// 根据主键查询--显示 /// </summary> /// <returns></returns> public static List<SoftProjectAreaEntity> P_Product_ByNewHome() { var domain = new SoftProjectAreaEntityDomain(); domain.Sys_HOperControl = null; string sql = string.Format("SELECT TOP 10 * FROM V_P_Product WHERE BNewID=1 ORDER BY CREATEDATE DESC"); var resp = domain.Query16(sql); return resp.Items; }
public HJsonResult AddSave(SoftProjectAreaEntityDomain domain) { domain.Item.SurveyTemplateTitleContext = Server.UrlDecode(domain.Item.SurveyTemplateTitleContext); ModularOrFunCode = "ActivityAreas.Act_SurveyTemplate.Add"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.AddSave(); return new HJsonResult(new { Data = resp }); }
public HJsonResult EditSave(SoftProjectAreaEntityDomain domain) { ModularOrFunCode = "ToolArea.T_ToolCategory.Edit"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.EditSave(); return new HJsonResult(new { Data = resp }); }
/// <summary> /// 活动费用规定--添加查询 /// </summary> /// <param name="domain"></param> /// <returns></returns> public ActionResult Add(SoftProjectAreaEntityDomain domain) { var resp = domain.Default(); ModularOrFunCode = "ActivityAreas.Act_ActivityCostRegulation.Add"; resp.FunNameEn = "Add"; resp.ViewContextName = Design_ModularOrFun.PartialView; return View(Design_ModularOrFun.MainView, resp); }
public HJsonResult AddSave(SoftProjectAreaEntityDomain domain) { domain.Item.ToolDesc = Server.UrlDecode(domain.Item.ToolDesc); ModularOrFunCode = "ToolArea.T_Tool.Add"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.AddSave(); return new HJsonResult(new { Data = resp }); }
/// <summary> /// 文档类别管理--编辑查询 /// </summary> /// <param name="domain"></param> /// <returns></returns> public ActionResult Edit(SoftProjectAreaEntityDomain domain) { ModularOrFunCode = "DocArea.Doc_Category.Index"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.ByID(); ModularOrFunCode = "DocArea.Doc_Category.Edit"; return View("PopupEdit", resp); }
public HJsonResult AddSave(SoftProjectAreaEntityDomain domain) { domain.Item.PromotionContext = Server.UrlDecode(domain.Item.PromotionContext); ModularOrFunCode = "PromotionAreas.Pr_Notice.Add"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.AddSave(); return new HJsonResult(new { Data = resp }); }
public HJsonResult EditSave(SoftProjectAreaEntityDomain domain) { ModularOrFunCode = "CustomerAreas.C_Recharge.Edit"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.C_Recharge_EditSave(); return new HJsonResult(new { Data = resp }); }
public HJsonResult AddSave(SoftProjectAreaEntityDomain domain) { domain.Item.GuidanceContent = Server.UrlDecode(domain.Item.GuidanceContent); ModularOrFunCode = "FranchiseeAreas.Fra_Guidance.Add"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.AddSave(); return new HJsonResult(new { Data = resp }); }
/// <summary> /// 根据主键查询--本月促销 /// </summary> /// <returns></returns> public static MyResponseBase Pr_Notice_ByCurrMonth() { var domain = new SoftProjectAreaEntityDomain(); domain.Sys_HOperControl = null; string sql = string.Format("SELECT * FROM Pr_Notice WHERE YEAR(PromotionStartDate)=YEAR(GETDATE()) AND MONTH(PromotionStartDate)=MONTH(getdate()) ORDER BY PromotionStartDate DESC "); var resp = domain.Query16(sql); return resp; }
public HJsonResult AddSave(SoftProjectAreaEntityDomain domain) { #region 初始值 #endregion ModularOrFunCode = "CustomerAreas.C_Recharge.Add"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.C_Recharge_AddSave(); return new HJsonResult(new { Data = resp }); }
public HJsonResult AddSave(SoftProjectAreaEntityDomain domain) { #region 初始值 #endregion ModularOrFunCode = "MarketingAreas.M_Marketing.Add"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.AddSave(); return new HJsonResult(new { Data = resp }); }
public HJsonResult AddSave(SoftProjectAreaEntityDomain domain) { #region 初始值 #endregion ModularOrFunCode = "ToolArea.T_ToolCategory.Add"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.AddSave(); return new HJsonResult(new { Data = resp }); }
public HJsonResult AddSave(SoftProjectAreaEntityDomain domain) { domain.Item.Pre_CompanyID = LoginInfo.CompanyID; domain.Item.ComplaintStatuID = 1; ModularOrFunCode = "ComplaintAreas.Complaint.Add"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.AddSave(); return new HJsonResult(new { Data = 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); }
/// <summary> /// 公司管理--编辑查询 /// </summary> /// <param name="domain"></param> /// <returns></returns> public ActionResult Detail(SoftProjectAreaEntityDomain domain) { ModularOrFunCode = "AuthorizationAreas.Pre_Company.Detail"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.ByID(); //MenuCode = "AuthorizationPanel"; resp.ViewContextName = Design_ModularOrFun.PartialView; return View(Design_ModularOrFun.MainView, resp); }
/// <summary> /// 企业客户角色管理--添加查询 /// </summary> /// <param name="domain"></param> /// <returns></returns> public ActionResult AddCompCU(SoftProjectAreaEntityDomain domain) { var resp = domain.Default(); resp.Item.LoginCategoryID = 8; ModularOrFunCode = "AuthorizationAreas.Pre_Role.AddCompCU"; //MenuCode = "AuthorizationPanel"; resp.FunNameEn = "Add"; return View("Edit", resp); }
/// <summary> /// 企业客户角色管理--添加保存 /// </summary> /// <param name="domain"></param> /// <returns></returns> public HJsonResult AddCompCUSave(SoftProjectAreaEntityDomain domain) { domain.Item.Pre_CompanyID = LoginInfo.CompanyID; domain.Item.LoginCategoryID = 8; ModularOrFunCode = "AuthorizationAreas.Pre_Role.AddCompCU"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.Pre_Role_AddSave(); return new HJsonResult(new { Data = resp }); }
/// <summary> /// 组织机构管理--编辑查询 /// </summary> /// <param name="domain"></param> /// <returns></returns> public ActionResult Edit(SoftProjectAreaEntityDomain domain) { ModularOrFunCode = "PreOrg_Area.Pre_Organization.Index"; domain.Design_ModularOrFun = Design_ModularOrFun; var resp = domain.ByID(); resp.Item.LoginCategoryID = 1; ModularOrFunCode = "PreOrg_Area.Pre_Organization.Edit"; return View("PopupEdit", resp); }
public ActionResult EditList(SoftProjectAreaEntityDomain domain) { var resp = domain.Design_ModularOrFunRefBtn_GetByPremSetID(); //resp.FunNameEn = "Edit"; //resp.FunNameCn = "编辑"; //resp.FunBtnNameCn = "保存"; //resp.ModularOrFunCode = "AuthorizationAreas.De_MemberNewP.Edit"; return View("EditList", resp); }
/// <summary> /// 根据主键查询--显示 /// </summary> /// <returns></returns> public static List <SoftProjectAreaEntity> P_Product_ByNewHome() { var domain = new SoftProjectAreaEntityDomain(); domain.Sys_HOperControl = null; string sql = string.Format("SELECT TOP 10 * FROM V_P_Product WHERE BNewID=1 ORDER BY CREATEDATE DESC"); var resp = domain.Query16(sql); return(resp.Items); }
/// <summary> /// 根据主键查询--本月促销 /// </summary> /// <returns></returns> public static MyResponseBase Pr_Notice_ByCurrMonth() { var domain = new SoftProjectAreaEntityDomain(); domain.Sys_HOperControl = null; string sql = string.Format("SELECT * FROM Pr_Notice WHERE YEAR(PromotionStartDate)=YEAR(GETDATE()) AND MONTH(PromotionStartDate)=MONTH(getdate()) ORDER BY PromotionStartDate DESC "); var resp = domain.Query16(sql); 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); }
/// <summary> /// 日志添加 /// </summary> /// <param name="LoginCategoryID">登录类型:1:公司,2:加盟商</param> /// <param name="LogCategoryID">日志类型:1:登录</param> /// <param name="LogCategoryName">日志类型名称:</param> /// <param name="Comp_CompanyID">公司ID:</param> /// <param name="LogPersonID">日志人员ID</param> /// <param name="LogPerson">日志人员</param> /// <param name="OperLogIdent">操作标识</param> /// <param name="OperName">操作名称</param> /// <param name="DetailDescription">描述</param> /// <returns></returns> public static MyResponseBase Sys_OperLogDetail_AddSave(int?LoginCategoryID, int?LogCategoryID, string LogCategoryName, int?Pre_CompanyID, int?LogPersonID, string LogPerson, int?OperLogIdent, string OperName, string DetailDescription = "") { MyResponseBase resp = new MyResponseBase(); SoftProjectAreaEntityDomain operLogDetailDomain = new SoftProjectAreaEntityDomain { Item = new SoftProjectAreaEntity { LoginCategoryID = LoginCategoryID, LogCategoryID = LogCategoryID, LogCategoryName = LogCategoryName, Pre_CompanyID = Pre_CompanyID, LogPersonID = LogPersonID, LogPerson = LogPerson, OperLogIdent = OperLogIdent, OperName = OperName, OperDate = DateTime.Now, DetailDescription = DetailDescription, } }; using (var scope = new TransactionScope()) { try { operLogDetailDomain.Sys_OperLogDetail_Domain(); operLogDetailDomain.OperCode = "Sys_OperLogDetail.AddSave"; resp = operLogDetailDomain.Execute(); scope.Complete(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } return(resp); }
public static string QueryHtmlDropDownList_Ba_AreaID2(string val, string NameCn, SoftProjectAreaEntity item) { if (!string.IsNullOrEmpty(val)) {//data-optionlabel='市(区、县)' var Ba_AreaID = Convert.ToInt32(val); var str = HtmlHelpers.DropDownList(null, "Ba_AreaID2___equal", SoftProjectAreaEntityDomain.Ba_Area_GetBrotherBa_AreaIDss(Ba_AreaID), "Ba_AreaID", "AreaName", val, "", "==市(区、县)==", "form-control", " data-changeurl='/BaseInfoAreas/Ba_Area/GetSubBa_AreaIDs2s' data-textfield='AreaName' data-valuefield='Ba_AreaID' data-targetdom='#Ba_AreaID3___equal' data-optionlabel='市(区、县)' "); return(str.ToString()); } else { //var str = string.Format("<select id='Item_{0}' name='Item.{0}' class='form-control' data-changeurl='/BaseInfoAreas/Ba_Area/GetSubBa_AreaIDs2s' data-textfield='AreaName' data-valuefield='Ba_AreaID' data-targetdom='#Item_Ba_AreaID3' ><option value='' selected=''>==市(区、县)==</option></select>", field.QueryEn); var str = string.Format("<select id='Ba_AreaID2___equal' name='Ba_AreaID2___equal' class='form-control' data-changeurl='/BaseInfoAreas/Ba_Area/GetSubBa_AreaIDs2s' data-textfield='AreaName' data-valuefield='Ba_AreaID' data-targetdom='#Ba_AreaID3___equal' data-optionlabel='市(区、县)'><option value=''>==市(区、县)==</option></select>"); return(str.ToString()); } }
public static string QueryHtmlDropDownList_Ba_AreaID3(string val, string NameCn, SoftProjectAreaEntity item) { #region Ba_AreaID3 if (!string.IsNullOrEmpty(val)) {//==市(区、县)== var Ba_AreaID = Convert.ToInt32(val); var str = HtmlHelpers.DropDownList(null, "Ba_AreaID3___equal", SoftProjectAreaEntityDomain.Ba_Area_GetBrotherBa_AreaIDss(Ba_AreaID), "Ba_AreaID", "AreaName", val, "", "==市(区、县)==", "form-control"); return(str.ToString()); } else {//<option value='' selected=''>==市(区、县)==</option> var str = string.Format("<select id='Ba_AreaID3___equal' name='Ba_AreaID3___equal' class='form-control' ><option value=''>==市(区、县)==</option></select>"); return(str.ToString()); } #endregion }
/// <summary> /// 添加保存,包含添加企业管理员信息 /// </summary> /// <returns></returns> public MyResponseBase Pre_Company_AddSave() { var resp = new MyResponseBase(); 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); } resp = ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p => { resp = AddSaveNotTran(); Item.Pre_CompanyID = resp.Item.Pre_CompanyID; Pre_User_AddAdminSave(); })); return(resp); }
public static string HtmlDropDownLiss_Ba_AreaID3(string val, string NameCn, SoftProjectAreaEntity item) { #region Ba_AreaID3 if (!string.IsNullOrEmpty(val)) {//==市(区、县)== var Ba_AreaID = Convert.ToInt32(val); var str = HtmlHelpers.DropDownList(null, "Item.Ba_AreaID3", SoftProjectAreaEntityDomain.Ba_Area_GetBrotherBa_AreaIDss(Ba_AreaID), "Ba_AreaID", "AreaName", val, "", "", "form-control"); return(str.ToString()); } else {//<option value='' selected=''>==市(区、县)==</option> var str = string.Format("<select id='Item_Ba_AreaID3' name='Item.Ba_AreaID3' class='form-control' ></select>"); return(str.ToString()); } #endregion //必须知道是公司、企业、顾客功能,从而进行过滤 //var Pre_RolesTemp = Pre_Roles.Where(p => p.LoginCategoryID == item.LoginCategoryID); //var str = HtmlHelpers.DropDownList(null, "Item.Pre_RoleID", Pre_RolesTemp, "Pre_RoleID", "RoleName", val, ""); //return str.ToString(); //return ""; }
public MyResponseBase Design_ModularOrFunRefBtn_EditListSave() { Design_ModularOrFunRefBtn_Domain(); #region (2)修改功能模块字段 using (var scope = new TransactionScope()) { try { SoftProjectAreaEntity hOperControl = new SoftProjectAreaEntity { }; #region (1)修改功能模块(无) #endregion #region (3)根据功能模块ID查询所有字段 var resptemp = Design_ModularOrFunRefBtn_GetByPremSetID(); #endregion #region (2)模块字段--数据整理 Item.Items.ForEach(p => { p.Design_PremSetID = Item.Design_PremSetID; }); var deleteIDsEnum = (from p in resptemp.Items select p.Design_ModularOrFunRefBtnID).Except(from o in Item.Items select o.Design_ModularOrFunRefBtnID);//.ToList(); var updateItems = Item.Items.Where(p => p.Design_ModularOrFunRefBtnID != null && !deleteIDsEnum.Contains(p.Design_ModularOrFunRefBtnID)); var addItems = Item.Items.Where(p => p.Design_ModularOrFunRefBtnID == null); #endregion #region (4)删除元素:执行删除,通过In进行删除 //需要写专门语句?delete xxx where ID IN(XXX) if (deleteIDsEnum.Count() > 0) { var deleteIDs = string.Join(",", deleteIDsEnum);//deleteForecastIDsEnum.ToArray() var sql = string.Format("DELETE [dbo].[Design_ModularOrFunRefBtn] WHERE Design_ModularOrFunRefBtnID IN({0})", deleteIDs); resptemp = Query16(sql, 1); } #endregion #region (5)更新模块字段 if (updateItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = updateItems.ToList() }; domain.Design_ModularOrFunRefBtn_Domain(); var DBFieldVals = "Design_PremSetID,Design_ModularOrFunBtnID,PremSetBtnSort"; domain.EditSaves(DBFieldVals); } #endregion #region (6)添加 if (addItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = addItems.ToList() }; domain.Design_ModularOrFunRefBtn_Domain(); var DBFieldVals = "Design_PremSetID,Design_ModularOrFunBtnID,PremSetBtnSort"; domain.AddSaves(DBFieldVals); } #endregion scope.Complete(); ProjectCache.ClearDesign_ModularOrFunRefBtns(); //ProjectCache.Sys_PremSetsAll_Clear(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } #endregion return(resp); }
public MyResponseBase Design_ModularOrFunSql_EditListSave() { Design_ModularOrFunSql_Domain(); #region (2)修改功能模块字段 using (var scope = new TransactionScope()) { try { SoftProjectAreaEntity hOperControl = new SoftProjectAreaEntity { }; #region (1)修改功能模块(无) #endregion #region (3)根据功能模块ID查询所有字段 var resptemp = Design_ModularOrFunSql_GetByModularOrFunID(); #endregion #region (2)模块字段--数据整理 Item.Items.ForEach(p => { p.Design_ModularOrFunID = Item.Design_ModularOrFunID; }); var deleteIDsEnum = (from p in resptemp.Items select p.Design_ModularOrFunSqlID).Except(from o in Item.Items select o.Design_ModularOrFunSqlID); var updateItems = Item.Items.Where(p => p.Design_ModularOrFunSqlID != null); var addItems = Item.Items.Where(p => p.Design_ModularOrFunSqlID == null); #endregion #region (4)删除元素:执行删除,通过In进行删除 //需要写专门语句?delete xxx where ID IN(XXX) if (deleteIDsEnum.Count() > 0) { var deleteIDs = string.Join(",", deleteIDsEnum);//deleteForecastIDsEnum.ToArray() var sql = string.Format("DELETE [dbo].[Design_ModularOrFunSql] WHERE Design_ModularOrFunSqlID IN({0})", deleteIDs); resptemp = Query16(sql, 1); } #endregion #region (5)更新模块字段 if (updateItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = updateItems.ToList() }; domain.Design_ModularOrFunSql_Domain(); var DBFieldVals = "SqlNameCn,OperName,OperCode,DBOperType,DBTSql,SelectSubType,DBSelectResultType,DBSqlParam,DBFieldVals,DefaultSort,FieldDesc,Sort,Design_ModularOrFunID"; domain.EditSaves(DBFieldVals); } #endregion #region (6)添加 if (addItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = addItems.ToList() }; domain.Design_ModularOrFunSql_Domain(); var DBFieldVals = "SqlNameCn,OperName,OperCode,DBOperType,DBTSql,SelectSubType,DBSelectResultType,DBSqlParam,DBFieldVals,DefaultSort,FieldDesc,Sort,Design_ModularOrFunID"; domain.AddSaves(DBFieldVals); } #endregion ProjectCache.ClearHOperControls(); scope.Complete(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } #endregion return(resp); }
/// <summary> /// 用户管理:添加、修改、删除 /// </summary> /// <returns></returns> public MyResponseBase Pre_RolePremSet_AddUpdateDeleteSaves() { using (var scope = new TransactionScope()) { try { //(1)根据用户ID查询:用户角色 Sys_HOperControl = null; OperCode = "Pre_RolePremSet.ByRoleID"; var OldItems = Execute().Items; if (Item.Items == null) { Item.Items = new List <SoftProjectAreaEntity>(); } #region (2)数据整理 Item.Items.ForEach(p => p.Pre_RoleID = Item.Pre_RoleID); var deleteIDsEnum = (from p in OldItems select p.Pre_RolePremSetID).Except(from o in Item.Items select o.Pre_RolePremSetID); var updateItems = Item.Items.Where(p => p.Pre_RolePremSetID != null && !deleteIDsEnum.Contains(p.Pre_RolePremSetID)); var addItems = Item.Items.Where(p => p.Pre_RolePremSetID == null); #endregion //return null; #region (3)删除 if (deleteIDsEnum.Count() > 0) { var deleteIDs = string.Join(",", deleteIDsEnum); var sql = string.Format("DELETE [dbo].[Pre_RolePremSet] WHERE Pre_RolePremSetID IN({0})", deleteIDs); var resptemp = Query16(sql, 1); } #endregion #region 更新 if (updateItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = updateItems.ToList() }; domain.Pre_RolePremSet_Domain(); var operCode = "Pre_RolePremSet.EditSave"; var resptemp = domain.ExecuteEnums(operCode); } #endregion #region 添加 if (addItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = addItems.ToList() }; domain.Pre_RolePremSet_Domain(); var operCode = "Pre_RolePremSet.AddSave"; var resptemp = domain.ExecuteEnums(operCode); } #endregion scope.Complete(); SoftProjectAreaEntityDomain.Pre_RolePremSetAll_Clare(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } return(resp); }
public MyResponseBase Design_ModularPageField_EditListSave() { #region (2)修改功能模块字段 using (var scope = new TransactionScope()) { try { SoftProjectAreaEntity hOperControl = new SoftProjectAreaEntity { }; var DBFieldVals = ""; #region (3)根据功能模块ID查询所有字段 var ModularPageFields = Design_ModularPageField_GetByModularOrFunID().Items; #endregion #region (2)模块字段--数据整理 Item.Design_ModularPageFields.ForEach(p => { p.Design_ModularOrFunID = Item.Design_ModularOrFunID; }); var deleteIDsEnum = (from p in ModularPageFields select p.Design_ModularPageFieldID).Except(from o in Item.Design_ModularPageFields select o.Design_ModularPageFieldID); var updateItems = Item.Design_ModularPageFields.Where(p => p.Design_ModularPageFieldID != null && !deleteIDsEnum.Contains(p.Design_ModularPageFieldID)); var addItems = Item.Design_ModularPageFields.Where(p => p.Design_ModularPageFieldID == null); #endregion MyResponseBase resptemp = new MyResponseBase(); #region (4)删除元素:执行删除,通过In进行删除 //需要写专门语句?delete xxx where ID IN(XXX) if (deleteIDsEnum.Count() > 0) { var deleteIDs = string.Join(",", deleteIDsEnum);//deleteForecastIDsEnum.ToArray() var sql = string.Format("DELETE [dbo].[Design_ModularPageField] WHERE Design_ModularPageFieldID IN({0})", deleteIDs); resptemp = Query16(sql, 1); } #endregion StringBuilder sb = new StringBuilder(); sb.AppendLine(";WITH T0 AS "); sb.AppendLine("("); sb.AppendLine(" SELECT * FROM [dbo].[Design_ModularOrFun] A WHERE Design_ModularOrFunID={0}"); sb.AppendLine(" UNION ALL"); sb.AppendLine(" SELECT * FROM [dbo].[Design_ModularOrFun] A WHERE Design_ModularOrFunParentID={0} AND GroupModularOrFun={1}"); sb.AppendLine(")"); sb.AppendLine("SELECT * FROM T0 ORDER BY Sort"); var sql1 = sb.ToString(); sql1 = string.Format(sql1, Item.Design_ModularOrFunID, "3"); //var sql1 = sb.ToString(); //sql1 = string.Format("SELECT * FROM Design_ModularOrFun WHERE Design_ModularOrFunParentID={0} ORDER BY Sort ", Item.Design_ModularOrFunID); var resp1 = Query16(sql1, 2); //resp.Item.Design_ModularOrFuns = resp1.Items; resp1.Items = resp1.Items.Where(p => p.bFieldsConfigDisp == 1).ToList(); var sqlfields = ""; for (int m = 0; m < resp1.Items.Count; m++) { #region PageFormEleTypeName if (resp1.Items[m].PageFormEleTypeName == "Page01FormEleType") { sqlfields += "Page01FormEleSort,Page01FormElePos,Page01FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page02FormEleType") { sqlfields += "Page02FormEleSort,Page02FormElePos,Page02FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page03FormEleType") { sqlfields += "Page03FormEleSort,Page03FormElePos,Page03FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page04FormEleType") { sqlfields += "Page04FormEleSort,Page04FormElePos,Page04FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page05FormEleType") { sqlfields += "Page05FormEleSort,Page05FormElePos,Page05FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page06FormEleType") { sqlfields += "Page06FormEleSort,Page06FormElePos,Page06FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page07FormEleType") { sqlfields += "Page07FormEleSort,Page07FormElePos,Page07FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page08FormEleType") { sqlfields += "Page08FormEleSort,Page08FormElePos,Page08FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page09FormEleType") { sqlfields += "Page09FormEleSort,Page09FormElePos,Page09FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page10FormEleType") { sqlfields += "Page10FormEleSort,Page10FormElePos,Page10FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page11FormEleType") { sqlfields += "Page11FormEleSort,Page11FormElePos,Page11FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page12FormEleType") { sqlfields += "Page12FormEleSort,Page12FormElePos,Page12FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page13FormEleType") { sqlfields += "Page13FormEleSort,Page13FormElePos,Page13FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page14FormEleType") { sqlfields += "Page14FormEleSort,Page14FormElePos,Page14FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page15FormEleType") { sqlfields += "Page15FormEleSort,Page15FormElePos,Page15FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page16FormEleType") { sqlfields += "Page16FormEleSort,Page16FormElePos,Page16FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page17FormEleType") { sqlfields += "Page17FormEleSort,Page17FormElePos,Page17FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page18FormEleType") { sqlfields += "Page18FormEleSort,Page18FormElePos,Page18FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page19FormEleType") { sqlfields += "Page19FormEleSort,Page19FormElePos,Page19FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page20FormEleType") { sqlfields += "Page20FormEleSort,Page20FormElePos,Page20FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page20FormEleType") { sqlfields += "Page20FormEleSort,Page20FormElePos,Page20FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page21FormEleType") { sqlfields += "Page21FormEleSort,Page21FormElePos,Page21FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page22FormEleType") { sqlfields += "Page22FormEleSort,Page22FormElePos,Page22FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page23FormEleType") { sqlfields += "Page23FormEleSort,Page23FormElePos,Page23FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page24FormEleType") { sqlfields += "Page24FormEleSort,Page24FormElePos,Page24FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page25FormEleType") { sqlfields += "Page25FormEleSort,Page25FormElePos,Page25FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page26FormEleType") { sqlfields += "Page26FormEleSort,Page26FormElePos,Page26FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page27FormEleType") { sqlfields += "Page27FormEleSort,Page27FormElePos,Page27FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page28FormEleType") { sqlfields += "Page28FormEleSort,Page28FormElePos,Page28FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page29FormEleType") { sqlfields += "Page29FormEleSort,Page29FormElePos,Page29FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page30FormEleType") { sqlfields += "Page30FormEleSort,Page30FormElePos,Page30FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page31FormEleType") { sqlfields += "Page31FormEleSort,Page31FormElePos,Page31FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page32FormEleType") { sqlfields += "Page32FormEleSort,Page32FormElePos,Page32FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page33FormEleType") { sqlfields += "Page33FormEleSort,Page33FormElePos,Page33FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page34FormEleType") { sqlfields += "Page34FormEleSort,Page34FormElePos,Page34FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page35FormEleType") { sqlfields += "Page35FormEleSort,Page35FormElePos,Page35FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page36FormEleType") { sqlfields += "Page36FormEleSort,Page36FormElePos,Page36FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page37FormEleType") { sqlfields += "Page37FormEleSort,Page37FormElePos,Page37FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page38FormEleType") { sqlfields += "Page38FormEleSort,Page38FormElePos,Page38FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page39FormEleType") { sqlfields += "Page39FormEleSort,Page39FormElePos,Page39FormEleType,"; } else if (resp1.Items[m].PageFormEleTypeName == "Page40FormEleType") { sqlfields += "Page40FormEleSort,Page40FormElePos,Page40FormEleType,"; } #endregion #region SortCol if (resp1.Items[m].SortCol == "SortCol01") { sqlfields += "Sort01,"; } else if (resp1.Items[m].SortCol == "SortCol02") { sqlfields += "Sort02,"; } else if (resp1.Items[m].SortCol == "SortCol03") { sqlfields += "Sort03,"; } else if (resp1.Items[m].SortCol == "SortCol04") { sqlfields += "Sort04,"; } else if (resp1.Items[m].SortCol == "SortCol05") { sqlfields += "Sort05,"; } else if (resp1.Items[m].SortCol == "SortCol06") { sqlfields += "Sort06,"; } else if (resp1.Items[m].SortCol == "SortCol07") { sqlfields += "Sort07,"; } else if (resp1.Items[m].SortCol == "SortCol08") { sqlfields += "Sort08,"; } else if (resp1.Items[m].SortCol == "SortCol09") { sqlfields += "Sort09,"; } else if (resp1.Items[m].SortCol == "SortCol10") { sqlfields += "Sort10,"; } else if (resp1.Items[m].SortCol == "SortCol11") { sqlfields += "Sort11,"; } else if (resp1.Items[m].SortCol == "SortCol12") { sqlfields += "Sort12,"; } else if (resp1.Items[m].SortCol == "SortCol13") { sqlfields += "Sort13,"; } else if (resp1.Items[m].SortCol == "SortCol14") { sqlfields += "Sort14,"; } else if (resp1.Items[m].SortCol == "SortCol15") { sqlfields += "Sort15,"; } else if (resp1.Items[m].SortCol == "SortCol16") { sqlfields += "Sort16,"; } else if (resp1.Items[m].SortCol == "SortCol17") { sqlfields += "Sort17,"; } else if (resp1.Items[m].SortCol == "SortCol18") { sqlfields += "Sort18,"; } else if (resp1.Items[m].SortCol == "SortCol19") { sqlfields += "Sort19,"; } else if (resp1.Items[m].SortCol == "SortCol20") { sqlfields += "Sort20,"; } if (resp1.Items[m].SortCol == "SortCol21") { sqlfields += "Sort21,"; } else if (resp1.Items[m].SortCol == "SortCol22") { sqlfields += "Sort22,"; } else if (resp1.Items[m].SortCol == "SortCol23") { sqlfields += "Sort23,"; } else if (resp1.Items[m].SortCol == "SortCol24") { sqlfields += "Sort24,"; } else if (resp1.Items[m].SortCol == "SortCol25") { sqlfields += "Sort25,"; } else if (resp1.Items[m].SortCol == "SortCol26") { sqlfields += "Sort26,"; } else if (resp1.Items[m].SortCol == "SortCol27") { sqlfields += "Sort27,"; } else if (resp1.Items[m].SortCol == "SortCol28") { sqlfields += "Sort28,"; } else if (resp1.Items[m].SortCol == "SortCol29") { sqlfields += "Sort29,"; } else if (resp1.Items[m].SortCol == "SortCol30") { sqlfields += "Sort30,"; } else if (resp1.Items[m].SortCol == "SortCol31") { sqlfields += "Sort31,"; } else if (resp1.Items[m].SortCol == "SortCol32") { sqlfields += "Sort32,"; } else if (resp1.Items[m].SortCol == "SortCol33") { sqlfields += "Sort33,"; } else if (resp1.Items[m].SortCol == "SortCol34") { sqlfields += "Sort34,"; } else if (resp1.Items[m].SortCol == "SortCol35") { sqlfields += "Sort35,"; } else if (resp1.Items[m].SortCol == "SortCol36") { sqlfields += "Sort36,"; } else if (resp1.Items[m].SortCol == "SortCol37") { sqlfields += "Sort37,"; } else if (resp1.Items[m].SortCol == "SortCol38") { sqlfields += "Sort38,"; } else if (resp1.Items[m].SortCol == "SortCol39") { sqlfields += "Sort39,"; } else if (resp1.Items[m].SortCol == "SortCol40") { sqlfields += "Sort40,"; } #endregion #region 查询 if (resp1.Items[m].QueryFormEleTypeName == "Query01") { sqlfields += "Query01Pos,Query01FormEleType,Query01QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query02") { sqlfields += "Query02Pos,Query02FormEleType,Query02QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query03") { sqlfields += "Query03Pos,Query03FormEleType,Query03QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query04") { sqlfields += "Query04Pos,Query04FormEleType,Query04QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query05") { sqlfields += "Query05Pos,Query05FormEleType,Query05QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query06") { sqlfields += "Query06Pos,Query06FormEleType,Query06QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query07") { sqlfields += "Query07Pos,Query07FormEleType,Query07QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query08") { sqlfields += "Query08Pos,Query08FormEleType,Query08QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query09") { sqlfields += "Query09Pos,Query09FormEleType,Query09QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query10") { sqlfields += "Query10Pos,Query10FormEleType,Query10QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query11") { sqlfields += "Query11Pos,Query11FormEleType,Query11QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query12") { sqlfields += "Query12Pos,Query12FormEleType,Query12QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query13") { sqlfields += "Query13Pos,Query13FormEleType,Query13QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query14") { sqlfields += "Query14Pos,Query14FormEleType,Query14QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query15") { sqlfields += "Query15Pos,Query15FormEleType,Query15QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query16") { sqlfields += "Query16Pos,Query16FormEleType,Query16QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query17") { sqlfields += "Query17Pos,Query17FormEleType,Query17QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query18") { sqlfields += "Query18Pos,Query18FormEleType,Query18QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query19") { sqlfields += "Query19Pos,Query19FormEleType,Query19QueryType,"; } else if (resp1.Items[m].QueryFormEleTypeName == "Query20") { sqlfields += "Query20Pos,Query20FormEleType,Query20QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query21") { sqlfields += "Query21Pos,Query21FormEleType,Query21QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query22") { sqlfields += "Query22Pos,Query22FormEleType,Query22QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query23") { sqlfields += "Query23Pos,Query23FormEleType,Query23QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query24") { sqlfields += "Query24Pos,Query24FormEleType,Query24QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query25") { sqlfields += "Query25Pos,Query25FormEleType,Query25QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query26") { sqlfields += "Query26Pos,Query26FormEleType,Query26QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query27") { sqlfields += "Query27Pos,Query27FormEleType,Query27QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query28") { sqlfields += "Query28Pos,Query28FormEleType,Query28QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query29") { sqlfields += "Query29Pos,Query29FormEleType,Query29QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query30") { sqlfields += "Query30Pos,Query30FormEleType,Query30QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query31") { sqlfields += "Query31Pos,Query31FormEleType,Query31QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query32") { sqlfields += "Query32Pos,Query32FormEleType,Query32QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query33") { sqlfields += "Query33Pos,Query33FormEleType,Query33QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query34") { sqlfields += "Query34Pos,Query34FormEleType,Query34QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query35") { sqlfields += "Query35Pos,Query35FormEleType,Query35QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query36") { sqlfields += "Query36Pos,Query36FormEleType,Query36QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query37") { sqlfields += "Query37Pos,Query37FormEleType,Query37QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query38") { sqlfields += "Query38Pos,Query38FormEleType,Query38QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query39") { sqlfields += "Query39Pos,Query39FormEleType,Query39QueryType,"; } if (resp1.Items[m].QueryFormEleTypeName == "Query40") { sqlfields += "Query40Pos,Query40FormEleType,Query40QueryType,"; } #endregion } if (sqlfields.Length > 0) { sqlfields = sqlfields.Trim(); sqlfields = sqlfields.Substring(0, sqlfields.Length - 1); } DBFieldVals = "Design_ModularOrFunID,TableInfoSort,FieldFunTypeID,cssclass,calcol,calrow,bTabVer,Design_ModularFieldID,FormEleType,EditAreaName,Design_ModularPageID,AdditionalInfo,"; DBFieldVals += sqlfields; #region (5)更新模块字段 if (updateItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = updateItems.ToList() }; domain.Design_ModularPageField_Domain(); //DBFieldVals = "Design_ModularOrFunID,TableInfoSort,FieldFunTypeID,cssclass,calcol,calrow,bTabVer,Design_ModularFieldID,FormEleType,EditAreaName,Design_ModularPageID,"; //Page01FormEleSort,Page01FormElePos,Page01FormEleType,Page02FormEleSort,Page02FormElePos,Page02FormEleType,Page03FormEleSort,Page03FormElePos,Page03FormEleType,"; //DBFieldVals += "Page04FormEleSort,Page04FormElePos, Page04FormEleType,Page05FormEleSort,Page05FormElePos,Page05FormEleType,Page06FormEleSort,Page06FormElePos,Page06FormEleType,"; //DBFieldVals += "Page07FormEleSort,Page07FormElePos, Page07FormEleType,Page08FormEleSort,Page08FormElePos,Page08FormEleType,Page09FormEleSort,Page09FormElePos,Page09FormEleType,"; //DBFieldVals += "Page10FormEleSort,Page10FormElePos, Page10FormEleType,"; //DBFieldVals += "Query01Pos,Query01FormEleType,Query01QueryType,Query02Pos,Query02FormEleType,Query02QueryType,Query03Pos,Query03FormEleType,Query03QueryType,Query04Pos,Query04FormEleType,Query04QueryType,"; //DBFieldVals += "Query05Pos, Query05FormEleType,Query05QueryType,Query06Pos,Query06FormEleType,Query06QueryType,Query07Pos,Query07FormEleType,Query07QueryType,Query08Pos,Query08FormEleType,Query08QueryType,Query09Pos,Query09FormEleType,Query09QueryType,Query10Pos,Query10FormEleType,Query10QueryType,"; //DBFieldVals += "Sort01,Sort02,Sort03,Sort04,Sort05,Sort06,Sort07,Sort08,Sort09,Sort10"; domain.EditSaves(DBFieldVals); } #endregion #region (6)添加 if (addItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = addItems.ToList() }; domain.Design_ModularPageField_Domain(); //DBFieldVals = "Design_ModularOrFunID,TableInfoSort,FieldFunTypeID,cssclass,calcol,calrow,bTabVer,Design_ModularFieldID,FormEleType,Page01FormEleSort,Page01FormElePos,Page01FormEleType,Page02FormEleSort,Page02FormElePos,Page02FormEleType,Page03FormEleSort,Page03FormElePos,Page03FormEleType,"; //DBFieldVals += "Page04FormEleSort,Page04FormElePos, Page04FormEleType,Page05FormEleSort,Page05FormElePos,Page05FormEleType,Page06FormEleSort,Page06FormElePos,Page06FormEleType,"; //DBFieldVals += "Page07FormEleSort,Page07FormElePos, Page07FormEleType,Page08FormEleSort,Page08FormElePos,Page08FormEleType,Page09FormEleSort,Page09FormElePos,Page09FormEleType,"; //DBFieldVals += "Page10FormEleSort,Page10FormElePos, Page10FormEleType,EditAreaName,Design_ModularPageID,"; //DBFieldVals += "Query01Pos,Query01FormEleType,Query01QueryType,Query02Pos,Query02FormEleType,Query02QueryType,Query03Pos,Query03FormEleType,Query03QueryType,Query04Pos,Query04FormEleType,Query04QueryType,"; //DBFieldVals += "Query05Pos, Query05FormEleType,Query05QueryType,Query06Pos,Query06FormEleType,Query06QueryType,Query07Pos,Query07FormEleType,Query07QueryType,Query08Pos,Query08FormEleType,Query08QueryType,Query09Pos,Query09FormEleType,Query09QueryType,Query10Pos,Query10FormEleType,Query10QueryType,"; //DBFieldVals += "Sort01,Sort02,Sort03,Sort04,Sort05,Sort06,Sort07,Sort08,Sort09,Sort10"; domain.AddSaves(DBFieldVals); } #endregion ProjectCache.Design_ModularPageFields_Clear(); scope.Complete(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } #endregion return(resp); }
public MyResponseBase Design_ModularField_EditListSave() { Design_ModularField_Domain(); #region (2)修改功能模块字段 using (var scope = new TransactionScope()) { try { SoftProjectAreaEntity hOperControl = new SoftProjectAreaEntity { }; #region (1)修改功能模块(无) #endregion #region (3)根据功能模块ID查询所有字段 var resptemp = Design_ModularField_GetByModularOrFunID(); #endregion #region (2)模块字段--数据整理 Item.Design_ModularFields.ForEach(p => { p.Design_ModularOrFunID = Item.Design_ModularOrFunID; }); var deleteIDsEnum = (from p in resptemp.Items select p.Design_ModularFieldID).Except(from o in Item.Design_ModularFields select o.Design_ModularFieldID); var updateItems = Item.Design_ModularFields.Where(p => p.Design_ModularFieldID != null); var addItems = Item.Design_ModularFields.Where(p => p.Design_ModularFieldID == null); #endregion #region (4)删除元素:执行删除,通过In进行删除 //需要写专门语句?delete xxx where ID IN(XXX) if (deleteIDsEnum.Count() > 0) { var deleteIDs = string.Join(",", deleteIDsEnum);//deleteForecastIDsEnum.ToArray() var sql = string.Format("DELETE [dbo].[Design_ModularField] WHERE Design_ModularFieldID IN({0})", deleteIDs); resptemp = Query16(sql, 1); } #endregion #region (5)更新模块字段 if (updateItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = updateItems.ToList() }; domain.Design_ModularField_Domain(); var DBFieldVals = "Design_ModularOrFunID,FieldTypeID,name,NameCn,xtype,length,QueryEn,QueryCn,Dicts,Calformula,Sort,Width,Align,DisFormat,NameCn2,Required,DefaultValue,bPrimaryKeyOrFK,bOperLog,bRepeat,ModularFieldRemark"; domain.EditSaves(DBFieldVals); } #endregion #region (6)添加 if (addItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = addItems.ToList() }; domain.Design_ModularField_Domain(); var DBFieldVals = "Design_ModularOrFunID,FieldTypeID,name,NameCn,xtype,length,QueryEn,QueryCn,Dicts,Calformula,Sort,Width,Align,DisFormat,NameCn2,Required,DefaultValue,bPrimaryKeyOrFK,bOperLog,bRepeat,ModularFieldRemark"; domain.AddSaves(DBFieldVals); } #endregion scope.Complete(); ProjectCache.Design_ModularPageFields_Clear(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } #endregion return(resp); }
public MyResponseBase Design_ModularOrFunBtn_EditListSave() { Design_ModularOrFunBtn_Domain(); #region (2)修改功能模块字段 using (var scope = new TransactionScope()) { try { SoftProjectAreaEntity hOperControl = new SoftProjectAreaEntity { }; #region (1)修改功能模块(无) #endregion #region (3)根据功能模块ID查询所有字段 var resptemp = Design_ModularOrFunBtn_GetByModularOrFunID(); #endregion #region (2)模块字段--数据整理 Item.Design_ModularOrFunBtns.ForEach(p => { p.Design_ModularOrFunID = Item.Design_ModularOrFunID; }); var deleteIDsEnum = (from p in resptemp.Items select p.Design_ModularOrFunBtnID).Except(from o in Item.Design_ModularOrFunBtns select o.Design_ModularOrFunBtnID); var updateItems = Item.Design_ModularOrFunBtns.Where(p => p.Design_ModularOrFunBtnID != null); var addItems = Item.Design_ModularOrFunBtns.Where(p => p.Design_ModularOrFunBtnID == null); #endregion #region (4)删除元素:执行删除,通过In进行删除 //需要写专门语句?delete xxx where ID IN(XXX) if (deleteIDsEnum.Count() > 0) { var deleteIDs = string.Join(",", deleteIDsEnum);//deleteForecastIDsEnum.ToArray() var sql = string.Format("DELETE [dbo].[Design_ModularOrFunBtn] WHERE Design_ModularOrFunBtnID IN({0})", deleteIDs); resptemp = Query16(sql, 1); } #endregion #region (5)更新模块字段 if (updateItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = updateItems.ToList() }; domain.Design_ModularOrFunBtn_Domain(); var DBFieldVals = "Sort,Design_ModularOrFunID,BtnNameEn,BtnNameCn,OperPos,BtnBehavior,PopupAfterTableFun,popupaddrepeat,PopupWidth,DispConditionsExpression,bValid,BtnType,ModularOrFunBtnRemark"; domain.EditSaves(DBFieldVals); } #endregion #region (6)添加 if (addItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = addItems.ToList() }; domain.Design_ModularOrFunBtn_Domain(); var DBFieldVals = "Sort,Design_ModularOrFunID,BtnNameEn,BtnNameCn,OperPos,BtnBehavior,PopupAfterTableFun,popupaddrepeat,PopupWidth,DispConditionsExpression,bValid,BtnType,ModularOrFunBtnRemark"; domain.AddSaves(DBFieldVals); } #endregion scope.Complete(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } #endregion return(resp); }
public MyResponseBase Design_ModularOrFunDomainDetail_EditSave() { MyResponseBase resp = new MyResponseBase(); Design_ModularOrFunDomainDetail_Domain(); #region (2)修改顾客 using (var scope = new TransactionScope()) { try { #region (3)根据功能模块ID查询所有字段 var Design_ModularOrFunDomainDetails = Design_ModularOrFunDomainDetail_GetByModularOrFunDomainID(); #endregion #region (2)模块字段--数据整理 //Item.Design_Design_ModularOrFunDomainDetails.ForEach(p => //{ p.Design_ModularPageID = Item.Design_ModularPageID; }); Item.Items.ForEach(p => p.Design_ModularOrFunDomainID = Item.Design_ModularOrFunDomainID); var deleteIDsEnum = (from p in Design_ModularOrFunDomainDetails select p.Design_ModularOrFunDomainDetailID).Except(from o in Item.Items select o.Design_ModularOrFunDomainDetailID); var updateItems = Item.Items.Where(p => p.Design_ModularOrFunDomainDetailID != null); var addItems = Item.Items.Where(p => p.Design_ModularOrFunDomainDetailID == null); #endregion MyResponseBase resptemp = new MyResponseBase(); #region (4)删除元素:执行删除,通过In进行删除 //需要写专门语句?delete xxx where ID IN(XXX) if (deleteIDsEnum.Count() > 0) { var deleteIDs = string.Join(",", deleteIDsEnum);//deleteForecastIDsEnum.ToArray() var sql = string.Format("DELETE [dbo].[Design_ModularOrFunDomainDetail] WHERE Design_ModularOrFunDomainDetailID IN({0})", deleteIDs); resptemp = Query16(sql, 1); } #endregion var DBFieldVals = ""; #region (5)更新模块字段 if (updateItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = updateItems.ToList() }; domain.Design_ModularOrFunDomainDetail_Domain(); DBFieldVals = "ModularOrFunDomainDetailName,Design_ModularOrFunDomainID,DomainType,DBOperCode,Serial,ParamName"; domain.EditSaves(DBFieldVals); } #endregion #region (6)添加 if (addItems.Count() > 0) { SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain { Items = addItems.ToList() }; domain.Design_ModularOrFunDomainDetail_Domain(); DBFieldVals = "ModularOrFunDomainDetailName,Design_ModularOrFunDomainID,DomainType,DBOperCode,Serial,ParamName"; domain.AddSaves(DBFieldVals); } #endregion scope.Complete(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { scope.Dispose(); } } #endregion return(resp); }