/// <summary>
/// 公司后台管理
/// </summary>
/// <returns></returns>
public ActionResult PlatformIndex()
{
var loginInfo = new SoftProjectAreaEntity
{
Sys_LoginInfoID = 1,
LoginName = "平台-超级管理员",
PasswordDigest = "",//;//.Item.PasswordDigest,
CompanyID = 1,
CompanyName = "平台-超级管理员",
LoginCategoryID = 1,
LoginNameCn = "平台-超级管理员",
//HomeConstrollName = "Home",
//HomeActionName = "Default",
//CurrNav = "Home",
//CurrMenuModularOrFunID = 71
};
//loginInfo.CurrNavCategoryID = 1;
//loginInfo.CurrNav = "加盟商仪表盘";
//loginInfo.CurrNavIdent = 1005;
SoftProjectAreaEntityDomain.Sys_OperLogDetail_AddSave(1, 1, "登录", 1, 1, "平台-超级管理员", 1, "登录");
Session["LoginInfo"] = loginInfo;
return(View("Index"));
}
public string GetEntityDataType(SoftProjectAreaEntity item)
{
//数据类型：56：整数 106：小数 167：字符串 61：日期
var datatype = "";
switch (item.xtype)
{
case 56:
datatype = string.Format(" int? ");
break;
case 106:
datatype = " decimal? ";
break;
case 167:
datatype = string.Format(" string ");
break;
case 61:
datatype = string.Format(" DateTime? ");
break;
}
return(datatype);
}
public string GetDataType(SoftProjectAreaEntity item)
{
//数据类型：56：整数 106：小数 167：字符串 61：日期
var datatype = "";
switch (item.xtype)
{
case 56:
datatype = string.Format(" int ");
break;
case 106:
datatype = " decimal(18,4) ";
break;
case 167:
if (item.length == 8000)
{
datatype += string.Format("varchar(max)");
}
else
{
datatype = string.Format(" varchar({0}) ", item.length == null ? 50 : item.length);
}
break;
case 61:
datatype = string.Format(" DateTime ", item.length);
break;
}
return(datatype);
}
public void Pre_User_UpdateCacheByMy()
{
#region (3)根据ID查询，替换
ModularOrFunCode = "AuthorizationAreas.Pre_User.Index";
Design_ModularOrFun = ProjectCache.Design_ModularOrFuns.Where(p => p.ModularOrFunCode == ModularOrFunCode).FirstOrDefault();
resp = ByID();
var Pre_User = SoftProjectAreaEntityDomain.Pre_UserRoleAll.Where(p => p.Pre_UserID == Item.Pre_UserID).FirstOrDefault();
SoftProjectAreaEntityDomain.Pre_UserRoleAll.Remove(Pre_User);
SoftProjectAreaEntityDomain.Pre_UserRoleAll.Add(resp.Item);
//Pre_User = resp.Item;
var user = resp.Item;
var loginInfo = new SoftProjectAreaEntity
{
Sys_LoginInfoID = user.Pre_UserID,
LoginCategoryID = 1,
MobilePhone = user.MobilePhone,
CompanyID = user.Pre_CompanyID,
CompanyName = user.PreCompanyName,
UserName = user.UserName,
RoleID = user.Pre_RoleID,
HomePageName = user.RoleHomePageName,
HomePageUrl = user.RoleHomePageUrl,
};
HttpContext.Current.Session["LoginInfo"] = loginInfo;
#endregion
}
/// <summary>
/// 加盟商后台管理
/// </summary>
/// <returns></returns>
public ActionResult CompIndex()
{
var loginInfo = new SoftProjectAreaEntity
{
Sys_LoginInfoID = 1,
LoginName = "公司1-企业管理员",
PasswordDigest = "",//;//.Item.PasswordDigest,
CompanyID = 1,
CompanyName = "公司",
LoginCategoryID = 2,
LoginNameCn = "公司-企业管理员1",
//HomeConstrollName = "Home",
//HomeActionName = "Default",
//CurrNav = "Home",
//CurrMenuModularOrFunID = 71
};
//loginInfo.CurrNavCategoryID = 1;
//loginInfo.CurrNav = "加盟商仪表盘";
//loginInfo.CurrNavIdent = 1005;
//Session["Pre_Users"] = new Pre_Users { Pre_UsersID = 1, UserName = "******", LoginName = "zs" };
//SoftProjectAreaEntityDomain.Sys_OperLogDetail_AddSave(1, 1, "登录", 1, "登录");
SoftProjectAreaEntityDomain.Sys_OperLogDetail_AddSave(2, 1, "登录", 1, 1, "公司1-企业管理员", 1, "登录");
//SoftProjectAreaEntityDomain.Sys_OperLogDetail_AddSave(2, 1, "登录", 1005, "登录");
Session["LoginInfo"] = loginInfo;
return(View("Index"));
}
//多选下拉列表框
private static void DropDownListMultiSelects(HtmlHelper helper, SoftProjectAreaEntity data, StringBuilder sbHtml,
Type type, SoftProjectAreaEntity field, ref PropertyInfo property, ref object value, ref string val, string css = "")
{
#region 拉列表框
property = type.GetProperty(field.name);
value = property.GetValue(data, null);
if (value != null)
{
var strval = value.ToString();
val = strval;
}
var dict = field.name;
if (!string.IsNullOrEmpty(field.Dicts))
{
dict = field.Dicts;
}
if (ProjectCache.IsExistyCategory(dict))
{
var str = HtmlHelpers.DropDownListMultiSelect(helper, "Item." + field.name + "s", ProjectCache.GetByCategory(dict), "DValue", "DText", val, "");
//var str = HtmlHelpers.DropDownList(helper, "Item." + field.name, ProjectCache.GetByCategory(dict), "DValue", "DText", val, css);
sbHtml.AppendLine(str.ToString());
}
else
{
if (ProjectCache.HtmlDropDownListMultiSelects.ContainsKey(field.name))
{
var str = ProjectCache.HtmlDropDownListMultiSelects[field.name](val, field.NameCn, data);
sbHtml.AppendLine(str.ToString());
}
}
#endregion
}
public static string HtmlDropDownLiss_Pre_RoleID(string val, string NameCn, SoftProjectAreaEntity item)
{
//必须知道是公司、企业、顾客功能，从而进行过滤
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());
}
/// <summary>
/// Jquery树
/// </summary>
/// <param name="val"></param>
/// <param name="NameCn"></param>
/// <returns></returns>
public static string JqTreeNs_Pre_OrganizationID(string val, string NameCn, SoftProjectAreaEntity item)
{
List <SoftProjectAreaEntity> Items = SoftProjectAreaEntityDomain.Pre_Organizations.Where(p => p.LoginCategoryID == item.LoginCategoryID).ToList();
var treeList = new TreeList(Items, "0", "OrganizationName", "Pre_OrganizationID", "ParentPre_OrganizationID", "", "", "Pre_OrganizationID", "", "");
var str = HtmlHelpersProject.JqTreeN(null, "Pre_OrganizationID", treeList, "", 2);
return(str.ToString());
}
public static string HtmlDropDownLiss_Ba_AreaID1(string val, string NameCn, SoftProjectAreaEntity item)
{
var str = HtmlHelpers.DropDownList(null, "Item.Ba_AreaID1", SoftProjectAreaEntityDomain.Ba_Area_AreaID1s, "Ba_AreaID", "AreaName",
val, "", "", "form-control",
" data-changeurl='/BaseInfoAreas/Ba_Area/GetSubBa_AreaIDs1s' data-textfield='AreaName' data-valuefield='Ba_AreaID' data-targetdom='#Item_Ba_AreaID2' ");
return(str.ToString());
}
//public static MvcHtmlString MainMenu(this HtmlHelper html)
//{
// var controll = html.ViewContext.Controller as BaseController;
// //var html.GetRouteString("Controller").ToLower()
// //var area = "";
// //if (controll.RouteData.DataTokens["area"] != null)
// // area = controll.RouteData.DataTokens["area"].ToString();
// //var constrollName = controll.RouteData.Values["controller"].ToString();
// //var actionName = controll.RouteData.Values["action"].ToString();
// List<Sys_PremSet> Sys_PremSets = controll.LoginMenu();
// var currpath = "";
// if (HttpContext.Current.Session["MenuUrl"] != null)
// currpath = HttpContext.Current.Session["MenuUrl"].ToString();
// ////根据Action，选中路径
// //var Sys_PremSetsAll = controll.Sys_PremSets;//所有角色权限权限集
// //var premSet = Sys_PremSetsAll.Where(p => p.Area == area && p.ConstrollName == constrollName && p.ActionName == actionName).First();
// //if (premSet.PermSetCategory == 0)
// //{
// // var temp1 = Sys_PremSets.Where(p => p.Sys_PremCodeID == premSet.PermSetParentID).First();
// // //var temp2 = Sys_PremSets.Where(p => p.Sys_PremCodeID == temp1.PermSetParentID).First();
// // currpath = temp1.PermSetParentID + "/" + temp1.Sys_PermSetID + "/";
// //}
// //else
// // currpath = premSet.PermSetParentID + "/" + premSet.Sys_PermSetID + "/";
// //var ActionSys_PremSet = Sys_PremSets.Where(p => p.Area == area && p.ConstrollName == constrollName && p.ActionName == actionName).First();
// //var ActionSys_PremSet = Sys_PremSets.Where(p => p.Area == area && p.ConstrollName == constrollName && p.ActionName == actionName).First();
// //var currpath =ActionSys_PremSet.PermSetParentID + "/" + ActionSys_PremSet.Sys_PermSetID+"/";//
// //获取路径
// var path = controll.Request.ApplicationPath;
// StringBuilder sb = new StringBuilder();//string.Format("<ul id='{0}' class='easyui-tree'>", name));
// sb.AppendLine("<ul id='mymenu' class='mymenu'>");
// //<li class='active'>
// // <a href='/Home/Index'>
// // <i class='glyphicon glyphicon-th-large'></i>
// // <span>首页</span>
// // </a>
// // <ul class='submenu'>
// // </ul>
// // </li>
// if (currpath.Contains("/Home/Index"))
// sb.AppendLine("<li class='active'>");
// else
// sb.AppendLine("<li class=''>");
// sb.AppendLine(" <a href='/'>");
// sb.AppendLine(" <i class='glyphicon glyphicon-th-large'></i>");
// sb.AppendLine(" <span>首页</span>");
// sb.AppendLine(" <b class='icon-angle-down'></b></a>");
// sb.AppendLine("<ul class='submenu' style='display: block;'>");
// sb.AppendLine("</ul>");
// sb.AppendLine("</li>");
// var root = Sys_PremSets.Where(p => p.PermSetParentID == 0).OrderBy(p => p.OrderNum).ToList();
// var count = root.Count();
// if (count > 0)
// {
// for (int i = 0; i < count; i++)
// {
// var active = "";
// var bopen = false;
// if (currpath.Contains("/" + root[i].Sys_PermSetID + "/"))
// {
// active = "active";
// bopen = true;
// }
// sb.AppendLine("<li class='" + active + "'>");
// //sb.AppendLine(" <a class='" + selected + "' href='" + path + root[i].ActionPath + "'>");
// if (root[i].ActionPath == "")
// sb.AppendLine(" <a href='#'>");
// else
// sb.AppendLine(" <a href='/" + root[i].ActionPath + "'>");
// sb.AppendLine(" <i class='glyphicon glyphicon-th-large'></i>");
// sb.AppendLine(" <span>" + root[i].PermSetName + "</span>");
// sb.AppendLine(" </a>");
// sb.AppendLine(BindMainMenu(Sys_PremSets, (int)root[i].Sys_PermSetID, currpath, path, bopen));
// sb.AppendLine("</li>");
// }
// }
// sb.AppendLine("</ul>");//结束
// MvcHtmlString mstr = new MvcHtmlString(sb.ToString());
// return mstr;
//}
//private static string BindMainMenu(List<Sys_PremSet> Sys_PremSets, int Sys_PermSetID, string currpath, string path, bool bopen)
//{
// StringBuilder sb = new StringBuilder();
// if (bopen)
// sb.AppendLine("<ul class='submenu' style='display: block;'>");
// else
// sb.AppendLine("<ul class='submenu'>");
// var root = Sys_PremSets.Where(p => p.PermSetParentID == Sys_PermSetID).OrderBy(p => p.OrderNum).ToList();
// int count = root.Count;
// if (count > 0)
// {
// for (int i = 0; i < count; i++)
// {
// var selected = "";
// if (currpath == "/" + Sys_PermSetID + "/" + root[i].Sys_PermSetID + "/")
// selected = "selected";
// sb.AppendLine("<li>");
// sb.AppendLine(" <a class='" + selected + "' href='" + path + root[i].ActionPath + "'>");
// sb.AppendLine(" <span>" + root[i].PermSetName + "</span>");
// sb.AppendLine(" </a>");
// sb.AppendLine("</li>");
// }
// }
// sb.AppendLine("</ul>");
// return sb.ToString();
//}
//public Breadcrumb Menu(SoftProjectAreaEntity item)
//{
// //var conts = ViewContext.Controller as BaseController;
// Menus.Items.Clear();
// if (MenuFun == null)
// return Menus;
// var Items = new List<SoftProjectAreaEntity>();
// var btns = LoginModulerBtns(MenuCode, 1);
// var sbhtml = new StringBuilder();
// foreach (var btn in btns)
// {
// var controllss = ProjectCache.Design_ModularOrFunBtnControlls.Where(p => p.Design_ModularOrFunBtnID == btn.Design_ModularOrFunBtnID).ToList();
// var action = "";
// if (controllss[0].ActionPath == Request.Path)
// action = "active";
// var url = UrlByControll(item, controllss.First());
// //sbhtml.AppendLine("<li class='" + action + "'>");
// //sbhtml.AppendLine(string.Format("<a href='{0}'>{1}</a>", url, btn.BtnNameCn));
// //sbhtml.AppendLine("</li>");
// ////////////////////////////////////////////////////////
// Menus.Items.Add(new BreadcrumbItem { Name = btn.BtnNameCn, URL = url });
// }
// var strHtml = new MvcHtmlString(sbhtml.ToString());
// return Menus;
//}
//private static string UrlByControll(object item, SoftProjectAreaEntity controlls)
//{
// var strParam = "?";
// if (controlls.ParamName != null && controlls.ParamName.Length > 0 && item != null)
// {
// #region 对象数据类型
// Type type = item.GetType();
// #endregion
// var paramNames = controlls.ParamName.Split(',');
// foreach (var param in paramNames)
// {
// PropertyInfo property = type.GetProperty(param);
// var value = property.GetValue(item, null);
// strParam += "Item." + param + "=" + value;
// //var val=item.
// }
// }
// //var url = "/" + controlls.AreasCode + "/" + controlls.ControllCode + "/" + controlls.ActionMethod + strParam;
// var url = controlls.ActionPath + strParam;
// return url;
//}
//public int? MenuPostion()
//{
// if (Design_ModularOrFun != null)
// {
// var MenuPanelItem = MenuPanel(Design_ModularOrFun);
// //var MenuPanel = Design_ModularOrFun;
// //var Items = new List<SoftProjectAreaEntity>();
// //if (MenuPanel.BMenuPanel != 1)//是控制面板
// //{
// // //MenuPanel = ProjectCache.Design_ModularOrFuns.Where(p => p.Design_ModularOrFunID == MenuPanel.Design_ModularOrFunParentID).FirstOrDefault();
// // MenuPanel = ProjectCache.Design_ModularOrFuns.Where(p => p.Design_ModularOrFunID == MenuPanel.ParentPremID).FirstOrDefault();
// //}
// //var respItem = ProjectCache.Design_ModularOrFuns.Where(p => p.Design_ModularOrFunID == LoginInfo.CurrMenuModularOrFunID).FirstOrDefault();
// return MenuPanelItem.MenuPostion;
// }
// return 0;
//}
//public Breadcrumb Menu(SoftProjectAreaEntity obj)
//{
// Menus.Items.Clear();
// if (Design_ModularOrFun == null)
// return Menus;
// var Items = new List<SoftProjectAreaEntity>();
// var MenuPanelItem = MenuPanel(Design_ModularOrFun);
// Items = ProjectCache.Design_ModularOrFuns.Where(p => p.ParentPremID == MenuPanelItem.Design_ModularOrFunID && p.BMenu == 1).OrderBy(p=>p.Sort).ToList();
// if (MenuPanelItem.BMenu == 1)
// {
// #region 参数
// var strParam = "";
// if (MenuPanelItem.ParamName != null && MenuPanelItem.ParamName.Length > 0 && obj != null)
// {
// #region 对象数据类型
// Type type = obj.GetType();
// #endregion
// var paramNames = MenuPanelItem.ParamName.Split(',');
// foreach (var param in paramNames)
// {
// PropertyInfo property = type.GetProperty(param);
// var value = property.GetValue(obj, null);
// strParam += "Item." + param + "=" + value;
// //var val=item.
// }
// }
// if (strParam.Length > 0)
// strParam = "?" + strParam;
// #endregion
// var ActionPath = MenuPanelItem.ActionPath + strParam;
// //strNav += string.Format("<li><a href='{0}{1}'>{2}</a></li>", modular.ActionPath, strParam, modular.ModularName);
// Menus.Items.Add(new BreadcrumbItem { Name = MenuPanelItem.ModularName, URL = ActionPath });
// }
// foreach (var item in Items)
// {
// #region 参数
// var strParam = "";
// if (item.ParamName != null && item.ParamName.Length > 0 && obj != null)
// {
// #region 对象数据类型
// Type type = obj.GetType();
// #endregion
// var paramNames = item.ParamName.Split(',');
// foreach (var param in paramNames)
// {
// PropertyInfo property = type.GetProperty(param);
// var value = property.GetValue(obj, null);
// strParam += "Item." + param + "=" + value;
// //var val=item.
// }
// }
// if (strParam.Length > 0)
// strParam = "?" + strParam;
// #endregion
// var ActionPath = item.ActionPath + strParam;
// Menus.Items.Add(new BreadcrumbItem { Name = item.ModularName, URL = ActionPath });
// }
// return Menus;
//}
public SoftProjectAreaEntity MenuPanel(SoftProjectAreaEntity MenuPanelItem)
{
if (MenuPanelItem.BMenuPanel == 1 || MenuPanelItem.ParentPremID == 0)
{
return(MenuPanelItem);
}
MenuPanelItem = ProjectCache.Design_ModularOrFuns.Where(p => p.Design_ModularOrFunID == MenuPanelItem.ParentPremID).FirstOrDefault();
return(MenuPanel(MenuPanelItem));
}
public MyResponseBase()
{
searchType = 0;
Item = new SoftProjectAreaEntity();
Items = new List <SoftProjectAreaEntity>();
RespAttachInfo = new RespAttachInfo();
PageQueryBase = new PageQueryBase();
Querys = new Querys();
}
/// <summary>
/// Jquery树
/// </summary>
/// <param name="val"></param>
/// <param name="NameCn"></param>
/// <returns></returns>
public static string JqTreeNs_Doc_CategoryID(string val, string NameCn, SoftProjectAreaEntity item)
{
var Pre_Company = HttpContext.Current.Session["LoginInfo"] as SoftProjectAreaEntity;
var Itemst = SoftProjectAreaEntityDomain.Doc_Categorys.Where(p => p.Pre_CompanyID == Pre_Company.CompanyID);
//var Itemst = SoftProjectAreaEntityDomain.Doc_Categorys;
var treeList = new TreeList(Itemst, "0", "DocCategoryName", "Doc_CategoryID", "ParentDoc_CategoryID", "", "", "Doc_CategoryID", "", "");
var str = HtmlHelpersProject.JqTreeN(null, "Doc_CategoryID", treeList, "", 2);
return(str.ToString());
}
/// <summary>
/// 编辑页面下拉树--文档类型父节点
/// </summary>
/// <param name="val"></param>
/// <param name="NameCn"></param>
/// <returns></returns>
public static string HtmlDropTrees_Doc_CategoryID(string val, string NameCn, SoftProjectAreaEntity item)
{
var Pre_Company = HttpContext.Current.Session["LoginInfo"] as SoftProjectAreaEntity;
var Items = SoftProjectAreaEntityDomain.Doc_Categorys.Where(p => p.Pre_CompanyID == Pre_Company.CompanyID);
//List<SoftProjectAreaEntity> Items = SoftProjectAreaEntityDomain.Doc_Categorys;
var tt = new SelectTreeList(Items, "0", "DocCategoryName", "Doc_CategoryID", "ParentDoc_CategoryID", "Doc_CategoryID", val, true, "");
var str = HtmlHelpers.DropDownForTree(null, "Item.Doc_CategoryID", tt, "==文档类型==");
return(str.ToHtmlString());
}
/// <summary>
/// 生成查询语句的数据库
/// </summary>
public void BulidHOperControl()
{
Sys_HOperControl = new SoftProjectAreaEntity
{
DBTSql = ProjectCache.GetQuerySql(TabViewName),
DBOperType = 8,
SelectSubType = 6,
DBSelectResultType = 2,
EqualQueryParam = ""
};
}
/// <summary>
/// 编辑单个对象，参数由配置文件完成
/// </summary>
/// <param name="DBFieldVals"></param>
/// <returns></returns>
public MyResponseBase EditSave()
{
MyResponseBase resp = new MyResponseBase();
SoftProjectAreaEntityDomain_Domain();
#region 主键检查
//var PKFieldValue = 0;
if (string.IsNullOrEmpty(PKField))
{
throw new Exception(ModularName + "主键字段名：不能为空！");
}
var type = Item.GetType(); //获取类型
PropertyInfo propertyInfo = type.GetProperty(PKField);
var PrimaryKeyItem = propertyInfo.GetValue(Item, null);
if (PrimaryKeyItem == null || PrimaryKeyItem == DBNull.Value)
{
throw new Exception(ModularName + "主键值：不能为空！");
}
#endregion
#region (2)编辑
using (var scope = new TransactionScope())
{
try
{
//Comp_Company_Domain();
var DBFieldVals = Design_ModularOrFun.TSql;
var hOperControl = new SoftProjectAreaEntity
{
DBOperType = 2,
DBSelectResultType = 1,
DBSqlParam = DBFieldVals
};
Sys_HOperControl = hOperControl;
resp = Execute();
scope.Complete();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
scope.Dispose();
}
}
#endregion
return(resp);
}
/// <summary>
/// 编辑单个对象
/// </summary>
/// <param name="DBFieldVals"></param>
/// <returns></returns>
public MyResponseBase EditSave(string DBFieldVals)
{
MyResponseBase resp = new MyResponseBase();
var hOperControl = new SoftProjectAreaEntity
{
DBOperType = 2,
DBSelectResultType = 1,
DBSqlParam = DBFieldVals
};
Sys_HOperControl = hOperControl;
resp = Execute();
return(resp);
}
public List <SoftProjectAreaEntity> SelectCells(CommandType CommandType, string TSql, SqlParameter[] paras)
{
List <SoftProjectAreaEntity> CellTs = new List <SoftProjectAreaEntity>();
using (SqlDataReader sdr = SqlHelper.ExecuteReader(ProviderHelper.ConnectionString,
CommandType, TSql, paras))
{
while (sdr.Read())
{
SoftProjectAreaEntity cellT = SqlTool.Read <SoftProjectAreaEntity>(new SafeDataReader(sdr));
CellTs.Add(cellT);
}
}
return(CellTs);
}
/// <summary>
/// 查询：根据ID查询
/// </summary>
/// <returns></returns>
public MyResponseBase Sys_PremCode_GetByID()
{
Sys_PremCode_PKCheck();
SoftProjectAreaEntity hOperControl = new SoftProjectAreaEntity
{
DBTSql = ";WITH T1000 AS (SELECT * FROM [dbo].[Sys_PremCode] A )",
DBOperType = 8,
SelectSubType = 1,
DBSelectResultType = 4,
EqualQueryParam = "Sys_PremCodeID"
};
resp = Execute();
return(resp);
}
//#region #区域
//static List<SoftProjectAreaEntity> _Ba_Areas = new List<SoftProjectAreaEntity>();
//public static List<SoftProjectAreaEntity> Ba_Areas
//{
// get
// {
// if (_Ba_Areas.Count == 0)
// {
// SoftProjectAreaEntityDomain domain = new SoftProjectAreaEntityDomain();
// _Ba_Areas = domain.Ba_Area_GetAll();
// }
// return _Ba_Areas;
// }
//}
///// <summary>
///// 获取所有1级区域
///// </summary>
//public static List<SoftProjectAreaEntity> Ba_AreaID1s
//{
// get
// {
// var lists = Ba_Areas.Where(p => p.AreaParentCode == "0");
// return lists.ToList();
// }
//}
///// <summary>
///// 根据ID，获取对应ID父区域下的子区域
///// </summary>
///// <param name="Ba_AreaID"></param>
///// <returns></returns>
//public static List<SoftProjectAreaEntity> GetBrotherBa_AreaIDss(int? Ba_AreaID)
//{
// var item = Ba_Areas.Where(p => p.Ba_AreaID == Ba_AreaID).First();
// var lists = Ba_Areas.Where(p => p.AreaParentCode == item.AreaParentCode);
// return lists.ToList();
//}
///// <summary>
///// 根据ID，查询所有子区域
///// </summary>
///// <param name="Ba_AreaID"></param>
///// <returns></returns>
//public static List<SoftProjectAreaEntity> GetSubBa_AreaIDss(int? Ba_AreaID)
//{
// var item = Ba_Areas.Where(p => p.Ba_AreaID == Ba_AreaID).First();
// var lists = _Ba_Areas.Where(p => p.AreaParentCode == item.AreaCode);
// return lists.ToList();
//}
///// <summary>
///// 根据ID查询
///// </summary>
///// <param name="Ba_AreaID"></param>
///// <returns></returns>
//public static SoftProjectAreaEntity GetByAreaID(int? Ba_AreaID)
//{
// var item = Ba_Areas.Where(p => p.Ba_AreaID == Ba_AreaID).First();
// return item;
//}
//#endregion
public static SoftProjectAreaEntity BulidRequest(SoftProjectAreaEntity oldItem, SoftProjectAreaEntity ChildAction)
{
//Model.ChildAction.ControllName, Model.ChildAction
var request = new SoftProjectAreaEntity();
var ActionFieldNamess = ChildAction.ActionFieldNames.Split(',');
Type type = oldItem.GetType();
foreach (var fieldname in ActionFieldNamess)
{
PropertyInfo property = type.GetProperty(fieldname);
object value = property.GetValue(oldItem, null);
property.SetValue(request, value);
}
return(request);
}
/// <summary>
/// 查询：根据ID查询
/// </summary>
/// <returns></returns>
public MyResponseBase Sys_Dict_GetByID()
{
//(1)检查ID是否为空
Sys_Dict_PKCheck();
SoftProjectAreaEntity hOperControl = new SoftProjectAreaEntity
{
DBTSql = string.Format("SELECT * FROM Sys_Dict WHERE Sys_DictID={0}", Item.Sys_DictID),
DBOperType = 16,
DBSelectResultType = 4,
};
Sys_HOperControl = hOperControl;
var resp = Execute();
return(resp);
}
public MyResponseBase QueryIndex()
{
var resp = new MyResponseBase();
if (PageQueryBase.RankInfo == null || PageQueryBase.RankInfo.Length == 0)
{
if (string.IsNullOrEmpty(Design_ModularOrFun.TSqlDefaultSort))
{
PageQueryBase.RankInfo = "UpdateDate|0";
}
else
{
var sorts = Design_ModularOrFun.TSqlDefaultSort.Split('|');
if (sorts.Length == 2)
{
PageQueryBase.RankInfo = sorts[0] + "|" + sorts[1];
}
else
{
PageQueryBase.RankInfo = sorts[0] + "|1";
}
}
}
SoftProjectAreaEntityDomain_Domain();
Sys_HOperControl = new SoftProjectAreaEntity
{
DBTSql = ProjectCache.GetQuerySql(TabViewName),
DBOperType = 8,
SelectSubType = 6,
DBSelectResultType = 2,
EqualQueryParam = ""
};
if (Design_ModularOrFun.BCalCol == 1)
{
bCal = 1;
ModularOrFunCode = Design_ModularOrFun.ModularOrFunCode;
//bCal,ModularOrFunCode
}
//BulidPageQueryBase();
//BulidHOperControl();
resp = Execute();
resp.Querys = Querys;
resp.Item = Item;
return(resp);
}
private static void HtmlDropDownLisByTable(HtmlHelper helper, SoftProjectAreaEntity data, StringBuilder sbHtml,
Type type, SoftProjectAreaEntity field, ref PropertyInfo property, ref object value, ref string val, string css = "")
{
#region 拉列表框
property = type.GetProperty(field.name);
value = property.GetValue(data, null);
if (value != null)
{
var strval = value.ToString();
val = strval;
}
var dict = field.name;
if (!string.IsNullOrEmpty(field.Dicts))
{
dict = field.Dicts;
}
if (ProjectCache.IsExistyCategory(dict))
{
var str = HtmlHelpers.DropDownList(helper, field.name, ProjectCache.GetByCategory(dict), "DValue", "DText", val, css);
sbHtml.AppendLine(str.ToString());
}
else
{
if (ProjectCache.HtmlDropDownLiss.ContainsKey(field.name))
{
var str = ProjectCache.HtmlDropDownLiss[field.name](val, field.NameCn, data);
sbHtml.AppendLine(str.ToString());
}
}
//else if (field.name == "Pre_RoleID")
//{
// var Pre_Roles = ProjectCache.Pre_Roles;
// var str = HtmlHelpers.DropDownList(helper, "Item." + field.name, Pre_Roles, "Pre_RoleID", "RoleName", val, "");
// sbHtml.AppendLine(str.ToString());
//}
//else if (field.name == "Comp_RoleID")
//{
// var Comp_Roles = ProjectCache.Comp_Roles;
// var str = HtmlHelpers.DropDownList(helper, "Item." + field.name, Comp_Roles, "Comp_RoleID", "CompRoleName", val, "");
// sbHtml.AppendLine(str.ToString());
//}
#endregion
}
public MyResponseBase Query4(int?PKValue)
{
string sql = ProjectCache.GetQuerySqlByID(TabViewName, PKField, PKValue);
SoftProjectAreaEntity hOperControl = new SoftProjectAreaEntity
{
DBTSql = sql,
DBOperType = 16,
DBSelectResultType = 4,
};
Sys_HOperControl = hOperControl;
var resp = Execute();
resp.Querys = Querys;
return(resp);
}
/// <summary>
/// 获取所有权限码：将进行缓存：用于判断是否需要进行权限验证
/// </summary>
/// <returns></returns>
public List <SoftProjectAreaEntity> Sys_PremCode_GetAll()
{
PageQueryBase.RankInfo = "[PremCode]|1";
SoftProjectAreaEntity hOperControl = new SoftProjectAreaEntity
{
DBTSql = "SELECT * FROM [dbo].[Sys_PremCode] A Order By [PremCode]",
DBOperType = 16,
DBSelectResultType = 2,
EqualQueryParam = ""
};
Sys_HOperControl = hOperControl;
var resp = Execute();
resp = Execute();
return(resp.Items);
}
public static string HtmlDropDownLiss_Ba_AreaID2(string val, string NameCn, SoftProjectAreaEntity item)
{
#region 2级区域
if (!string.IsNullOrEmpty(val))
{//data-optionlabel='市(区、县)'
var Ba_AreaID = Convert.ToInt32(val);
var str = HtmlHelpers.DropDownList(null, "Item.Ba_AreaID2", 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='#Item_Ba_AreaID3' ");
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='Item_Ba_AreaID2' name='Item.Ba_AreaID2' class='form-control' data-changeurl='/BaseInfoAreas/Ba_Area/GetSubBa_AreaIDs2s' data-textfield='AreaName' data-valuefield='Ba_AreaID' data-targetdom='#Item_Ba_AreaID3' ></select>");
return(str.ToString());
}
#endregion
}
public MyResponseBase AddSaves(string DBFieldVals)
{
var resp = new MyResponseBase();
var hOperControl = new SoftProjectAreaEntity
{
DBOperType = 1,
DBSelectResultType = 1,
DBSqlParam = DBFieldVals
};
Sys_HOperControl = hOperControl;
foreach (var item in Items)
{
Item = item;
resp = Execute();
}
return(resp);
}
/// <summary>
/// 生成页面记录
/// </summary>
/// <returns></returns>
public MyResponseBase Design_ModularPageField_BulidRecord()
{
var Design_ModularOrFunID = Item.Design_ModularOrFunID;
Design_ModularOrFun_Domain();
SoftProjectAreaEntity hOperControl = new SoftProjectAreaEntity {
};
#region 功能模块对象
var Design_ModularOrFun = Design_ModularOrFun_GetByID().Item;
#endregion
var sbsql = new StringBuilder();
string sql = "";
//sbsql.AppendLine("SELECT 1 Design_ModularFieldID,1 TableInfoSort");
//sbsql.AppendLine("UNION ALL");
//sbsql.AppendLine("SELECT 3,100");
//sbsql.AppendLine("UNION ALL");
//sbsql.AppendLine("SELECT Design_ModularFieldID,Sort+2 TableInfoSort");
//sbsql.AppendLine("FROM Design_ModularField");
//sbsql.AppendLine("WHERE Design_ModularOrFunID={0}");
//sbsql.AppendLine("ORDER BY TableInfoSort");
sbsql.AppendLine(";WITH T0 AS");
sbsql.AppendLine("(");
sbsql.AppendLine(" SELECT 1 Design_ModularFieldID,1 TableInfoSort");
sbsql.AppendLine(" UNION ALL");
sbsql.AppendLine(" SELECT 3,100");
sbsql.AppendLine(" UNION ALL");
sbsql.AppendLine(" SELECT Design_ModularFieldID,Sort+2 TableInfoSort");
sbsql.AppendLine(" FROM Design_ModularField");
sbsql.AppendLine(" WHERE Design_ModularOrFunID={0}");
//sbsql.AppendLine(" ORDER BY TableInfoSort");
sbsql.AppendLine(")");
sbsql.AppendLine("INSERT INTO Design_ModularPageField(Design_ModularOrFunID,Design_ModularFieldID,TableInfoSort)");
sbsql.AppendLine("SELECT {0},*");
sbsql.AppendLine("FROM T0 ");
sbsql.AppendLine("ORDER BY TableInfoSort");
sql = sbsql.ToString();
sql = string.Format(sql, Item.Design_ModularOrFunID);
Query16(sql, 1);
return(resp);
}
//MyResponseBase<LoginInfo> resp = new MyResponseBase<LoginInfo>();
public MyResponseBase Login()
{
if (string.IsNullOrEmpty(Item.MobilePhone) || string.IsNullOrEmpty(Item.PasswordDigest))
{
throw new Exception("手机号和密码不能为空");
//resp.RespAttachInfo.ValidationErrors.ErrorMessage = "用户名或密码不能为空";
//return resp;
}
//return false;
#region 用户登录
var Users = SoftProjectAreaEntityDomain.Pre_UserRoleAll.Where(p => p.MobilePhone == Item.MobilePhone && p.PasswordDigest == Item.PasswordDigest && p.UserStatuID == 1);
if (Users.Count() > 0)
{
#region 公司
var user = Users.First();
//HomePageName HomePageUrl
var loginInfo = new SoftProjectAreaEntity
{
Sys_LoginInfoID = user.Pre_UserID,
LoginCategoryID = 1,
MobilePhone = user.MobilePhone,
CompanyID = user.Pre_CompanyID,
CompanyName = user.PreCompanyName,
UserName = user.UserName,
RoleID = user.Pre_RoleID,
HomePageName = user.RoleHomePageName,
HomePageUrl = user.RoleHomePageUrl,
};
resp.Item = loginInfo;
#endregion
}
else
{
throw new Exception("用户、密码不正确，或此用户已被停用!");
}
#endregion
return(resp);
}
public MyResponseBase Query16(string sql, int DBSelectResultType = 2)
{
SoftProjectAreaEntity hOperControl = new SoftProjectAreaEntity
{
DBTSql = sql,
DBOperType = 16,
DBSelectResultType = DBSelectResultType,
};
Sys_HOperControl = hOperControl;
var resp = Execute();
resp.Querys = Querys;
if (DBSelectResultType != 4)
{
resp.Item = Item;
}
return(resp);
}
public MyResponseBase ExcuteEnumsNew(int DBOperType = 2)
{
MyResponseBase resp = new MyResponseBase();
SoftProjectAreaEntityDomain_Domain();
#region (2)编辑
using (var scope = new TransactionScope())
{
try
{
var DBFieldVals = Design_ModularOrFun.TSql;
var hOperControl = new SoftProjectAreaEntity
{
DBOperType = DBOperType,
DBSelectResultType = 1,
DBSqlParam = DBFieldVals
};
Sys_HOperControl = hOperControl;
foreach (var item in Items)
{
Item = item;
resp = Execute();
}
scope.Complete();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
scope.Dispose();
}
}
#endregion
return(resp);
}
