private static SysPathRule[] InnerGetRules()
{
List <SysPathRule> list;
List <SysPathRuleItem> list2;
Dictionary <int, SysPath> dictionary;
SysPathRule current;
using (BizDataContext context = new BizDataContext(true))
{
dictionary = context.FetchAll <SysPath>().ToDictionary <SysPath, int>(t => t.PathId);
list = context.FetchAll <SysPathRule>();
list2 = context.FetchAll <SysPathRuleItem>();
}
using (List <SysPathRule> .Enumerator enumerator = list.GetEnumerator())
{
while (enumerator.MoveNext())
{
current = enumerator.Current;
current.Path = dictionary[current.PathId].Path.ToLower();
}
}
Dictionary <int, SysPathRule> dictionary2 = list.ToDictionary <SysPathRule, int, SysPathRule>(p => p.PathRuleId, p => p);
Dictionary <int, IGrouping <int, SysPathRuleItem> > dictionary3 = (from p in list2 group p by p.PathRuleId).ToDictionary <IGrouping <int, SysPathRuleItem>, int, IGrouping <int, SysPathRuleItem> >(p => p.Key, p => p);
foreach (KeyValuePair <int, IGrouping <int, SysPathRuleItem> > pair in dictionary3)
{
current = dictionary2[pair.Key];
foreach (SysPathRuleItem item in pair.Value)
{
if (item.ItemType == PathRuleMasterType.Role)
{
current.Roles.Add(item.ObjectId);
}
else
{
current.Users.Add(item.ObjectId);
}
}
}
dictionary2.Clear();
dictionary2 = null;
dictionary3.Clear();
dictionary3 = null;
dictionary.Clear();
dictionary = null;
list2.Clear();
list2 = null;
return((from p in list
orderby p.RuleIndex
select p).ToArray <SysPathRule>());
}
public static void SetDefaultValue(TagBuilder UserName, TagBuilder HidUserId, TagBuilder selectedIDHf, string selectValue)
{
string str = string.Empty;
StringBuilder builder = new StringBuilder(100);
if (!string.IsNullOrEmpty(selectValue))
{
string[] strArray = selectValue.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
using (BizDataContext context = new BizDataContext(true))
{
var source = (from u in context.FetchAll <T_User>()
join suid in strArray on u.User_ID.ToString() equals suid
select new { User_ID = u.User_ID, User_Name = u.User_Name }).ToList();
List <string> values = new List <string>();
if ((source != null) && (source.Count > 0))
{
foreach (string str2 in strArray)
{
int id = str2.ToInt();
string item = source.FirstOrDefault(a => (a.User_ID == id)).User_Name;
values.Add(item);
builder.Append(str2 + "," + item + ";");
}
str = string.Join(",", values);
}
}
UserName.MergeAttribute("value", str);
HidUserId.MergeAttribute("value", selectValue);
selectedIDHf.MergeAttribute("value", builder.ToString().TrimEnd(new char[] { ';' }));
}
}
protected void btnChangeSystemLevelCode_Click(object sender, EventArgs e)
{
using (BizDataContext context = new BizDataContext())
{
StringBuilder sbSQL = new StringBuilder();
//将父部门字段值调整过来并先处理好顶级部门的层级码
sbSQL.AppendLine("update T_Department set SystemLevelCode = Convert(nvarchar(50),Department_ID)+'-' where Parent_ID is null");
context.ExecuteNonQuery(sbSQL.ToString());
var AllDepts = context.FetchAll <T_Department>();
var Depts = AllDepts.Where(p => !(p.Parent_ID == null)).ToList();
var DealedDepts = AllDepts.Where(p => p.Parent_ID == null).ToList();
while (Depts.Count > 0)
{
for (int i = Depts.Count - 1; i >= 0; i--)
{
var Child = Depts[i];
var FindParent = DealedDepts.FirstOrDefault(p => p.Department_ID == Child.Parent_ID);
if (FindParent != null)
{
//当前未处理的这个是某个已处理的子部门，则处理当前这个，并把它从未处理中移走，加到已处理中。
Child.SystemLevelCode = FindParent.SystemLevelCode + Child.Department_ID + "-";
context.Update(Child);
Depts.Remove(Child);
DealedDepts.Add(Child);
}
}
}
}
this.AjaxAlert("调整成功！");
}
//string GetEntityName(long entityId,BizDataContext context)
//{
// string res = string.Empty;
// SysEntity se= context.FindById<SysEntity>(entityId);
// if (se != null)
// {
// res = se.DisplayText;
// }
// return res;
//}
private void BindGrid()
{
using (BizDataContext context = new BizDataContext())
{
var list = context.FetchAll <SysProcessRemindTemplate>();
var result = list.Select(p => new
{
p.TemplateId,
p.TemplateName,
p.TemplateType,
p.UseTimeType,
ProcessEntityName = this.EntityCache.FindById <SysEntity>(p.ProcessEntityId).EntityName, //GetEntityName(p.ProcessEntityId.Value,context),
ActivityEntityName = this.EntityCache.FindById <SysEntity>(p.ActivityEntityId).EntityName, //GetEntityName(p.ActivityEntityId.Value,context),
p.State
}).ToList().Select(p => new
{
p.TemplateId,
p.TemplateName,
TemplateType = EnumHelper.GetDescription(typeof(TemplateType), p.TemplateType.Value),
UseTimeType = EnumHelper.GetDescription(typeof(UseTimeType), p.UseTimeType.Value),
p.ProcessEntityName,
p.ActivityEntityName,
State = p.State == 1 ? "启用" : "禁用",
}).ToList();
this.gcProcessTemplateQuery.DataSource = result;
this.gcProcessTemplateQuery.DataBind();
}
}
/// <summary>
/// 查询所有提醒模板
/// </summary>
/// <returns></returns>
public IEnumerable <WfRemindTemplate> GetRemindTemplateList()
{
using (BizDataContext context = new BizDataContext())
{
return(context.FetchAll <SysProcessRemindTemplate>().ConvertTo <WfRemindTemplate>());
}
}
private void LoadDropDown()
{
try
{
using (BizDataContext context = new BizDataContext())
{
var processList = context.Where <SysProcess>(p =>
p.ProcessStatus == (int)ProcessState.StartUsed &&
p.ProcessCategory != (int)ProcessCategory.FormApprove //2013-9-13 zhumin 排除表单流程
);
cbProcess.DataTextField = "ProcessName";
cbProcess.DataValueField = "ProcessType";
cbProcess.DataSource = processList;
cbProcess.DataBind();
cbStartUser.DataTextField = "User_Name";
cbStartUser.DataValueField = "User_ID";
cbStartUser.DataSource = context.FetchAll <T_User>();
cbStartUser.DataBind();
cbStartUser.SetValue(this.LoginUserID.ToString());
}
}
catch (ApplicationException ex)
{
this.AjaxAlert(ex.Message);
}
}
public static List <T> ICommonEntity <T>() where T : class, new()
{
List <T> list = null;
using (BizDataContext context = new BizDataContext(true))
{
string key = typeof(T).ToString();
if (HttpRuntime.Cache[key] == null)
{
list = context.FetchAll <T>();
HttpRuntime.Cache.Add(key, list, null, DateTime.Now.AddSeconds(30.0), TimeSpan.Zero, CacheItemPriority.Normal, null);
return(list);
}
return((List <T>)HttpRuntime.Cache[key]);
}
}
private void BingDataToRoleId(string roleId)
{
//如果传入ID号有误,则变成下拉菜单来处理
bool nextSetp = true;
if (!string.IsNullOrEmpty(roleId))
{
this.RoleId = Convert.ToInt32(roleId);
using (BizDataContext context = new BizDataContext())
{
var query = context.FindById <T_Role>(this.RoleId);
if (query != null)
{
lblRoleName.Text += query.Role_Name;
this.ddlRoleList.Visible = false;
nextSetp = false;
}
}
}
if (nextSetp)
{
using (BizDataContext Context = new BizDataContext())
{
var roleList = Context.FetchAll <T_Role>();
this.ddlRoleList.DataSource = roleList;
this.ddlRoleList.DataValueField = "Role_ID";
this.ddlRoleList.DataTextField = "Role_Name";
this.ddlRoleList.DataBind();
this.RoleId = Convert.ToInt32(this.ddlRoleList.SelectedValue);
this.ddlRoleList.Visible = true;
}
}
}
private static MvcHtmlString GetSelectUserHtml(HtmlHelper html, string name, List <ITreeData> data, string GetLeafURL, string CallBackMethod, UserStyle userStyle, OpenNoteEnum openNote, ValidateOptions validateOptions, string value)
{
BizDataContext context;
List <string> keyList = new List <string>();
JavaScriptSerializer serializer = new JavaScriptSerializer();
StringBuilder builder = new StringBuilder();
TagBuilder builder2 = new TagBuilder("div");
builder2.GenerateId(name);
builder2.AddCssClass("treeDiv");
TagBuilder builder3 = GetTagBuilder("ul", name, "ztree");
builder3.MergeAttribute("style", "display : none;");
builder2.InnerHtml = builder2.InnerHtml + builder3;
TagBuilder builder4 = GetTagBuilder("div", name, "dataHF");
builder4.MergeAttribute("style", "display:none;");
if ((data != null) && (data.Count > 0))
{
data = DealWithNoteOpenState(data, openNote);
builder4.InnerHtml = builder4.InnerHtml + serializer.Serialize(data);
}
else
{
using (context = new BizDataContext(true))
{
ParameterExpression expression;
// List<ITreeData> list2 = DealWithNoteOpenState(context.Set<T_Department>().
// Select<T_Department, TreeData>(Expression.Lambda<Func<T_Department, TreeData>>(Expression.MemberInit(Expression.New((ConstructorInfo) methodof(TreeData..ctor), new Expression[0]), new MemberBinding[] { Expression.Bind((MethodInfo) methodof(TreeData.set_id), Expression.Property(expression = Expression.Parameter(typeof(T_Department), "u"), (MethodInfo) methodof(T_Department.get_Department_ID))), Expression.Bind((MethodInfo) methodof(TreeData.set_name), Expression.Property(expression, (MethodInfo) methodof(T_Department.get_Department_Name))), Expression.Bind((MethodInfo) methodof(TreeData.set_open), Expression.Constant(false, typeof(bool))), Expression.Bind((MethodInfo) methodof(TreeData.set_pId), Expression.Coalesce(Expression.Property(expression, (MethodInfo) methodof(T_Department.get_Parent_ID)), Expression.Constant(-1, typeof(int)))) }), new ParameterExpression[] { expression })).ToList<ITreeData>(), openNote);
//builder4.InnerHtml = builder4.InnerHtml + serializer.Serialize(list2);
}
}
builder2.InnerHtml = builder2.InnerHtml + builder4;
TagBuilder builder5 = GetTagBuilder("input", name, "resultInput");
if (userStyle == UserStyle.Normal)
{
builder5.MergeAttribute("style", "float: left;");
}
else
{
builder5.MergeAttribute("style", "float: left;display:none");
}
builder5.MergeAttribute("type", "text");
if (validateOptions != null)
{
builder5.MergeAttribute("data-bvalidator", ValidateCommon.GetValidateAttr(validateOptions));
if (!string.IsNullOrEmpty(validateOptions.ErrorMsg))
{
builder5.MergeAttribute("data-bvalidator-msg", validateOptions.ErrorMsg);
}
}
builder5.MergeAttribute("readonly", "true");
TagBuilder builder6 = GetTagBuilder("input", name, "resultHf");
builder6.MergeAttribute("type", "hidden");
builder2.InnerHtml = builder2.InnerHtml + builder5;
builder2.InnerHtml = builder2.InnerHtml + builder6;
TagBuilder builder7 = GetTagBuilder("input", name, "treeButton");
builder7.MergeAttribute("type", "button");
builder7.MergeAttribute("value", "选择");
builder7.MergeAttribute("treeName", name);
builder2.InnerHtml = builder2.InnerHtml + builder7;
TagBuilder builder8 = GetTagBuilder("input", name, "selectedIDHf");
builder8.MergeAttribute("type", "hidden");
string str = string.Empty;
if (!string.IsNullOrEmpty(value))
{
string[] strArray = value.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
using (context = new BizDataContext(true))
{
IEnumerable <string> values = from u in context.FetchAll <T_User>()
join suid in strArray on u.User_ID.ToString() equals suid
select u.User_Name;
str = string.Join(",", values);
}
builder8.MergeAttribute("value", value);
}
builder2.InnerHtml = builder2.InnerHtml + builder8;
TagBuilder builder9 = GetTagBuilder("input", name, "selectedNameHF");
builder9.MergeAttribute("type", "hidden");
builder9.MergeAttribute("value", str);
builder2.InnerHtml = builder2.InnerHtml + builder9;
TagBuilder builder10 = GetTagBuilder("input", name, "configDataHF");
builder10.MergeAttribute("type", "hidden");
Dictionary <string, string> dictionary = new Dictionary <string, string>();
dictionary.Add("GetLeafURL", GetLeafURL);
dictionary.Add("CallBackMethod", CallBackMethod);
builder10.MergeAttribute("value", serializer.Serialize(dictionary));
builder2.InnerHtml = builder2.InnerHtml + builder10;
builder.AppendLine(builder2.ToString());
builder.AppendLine(CtrlScripts.RenderScript(html, keyList));
return(MvcHtmlString.Create(builder.ToString()));
}
private static T_Configuration GetConfiguration(string Key)
{
if ((configurationList == null) || (DateTime.Now.Ticks > dt))
{
using (BizDataContext context = new BizDataContext(true))
{
Interlocked.Exchange <List <T_Configuration> >(ref configurationList, context.FetchAll <T_Configuration>());
Interlocked.Exchange(ref dt, DateTime.Now.AddSeconds(30.0).Ticks);
}
}
T_Configuration configuration = configurationList.FirstOrDefault <T_Configuration>(p => p.Configuration_Key == Key);
if (configuration == null)
{
throw new ApplicationException(string.Format("未找到{0}配置项", Key));
}
return(configuration);
}
