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);
}
