private void DoSelect()
{
ExamineStageResult esrEnt = ExamineStageResult.Find(ExamineStageResultId);
string where = "";
if (SearchCriterion.Orders.Count == 0)
{
SearchCriterion.SetOrder("ToUserName", true);
where = " ExamineStageId='{0}' and State='3' and BeUserId='{1}'";
}
else
{
where = " ExamineStageId='{0}' and State='3' and BeUserId='{1}'";
}
where = string.Format(where, esrEnt.ExamineStageId, esrEnt.UserId);
IList <ExamineTask> etEnts = ExamineTask.FindAll(SearchCriterion, Expression.Sql(where));
PageState.Add("DataList", etEnts);
if (!string.IsNullOrEmpty(esrEnt.ExamineStageId))//有些考核结果是手动填报的 因此需要加判断 有无考核阶段和明细
{
ExamineStage esEnt = ExamineStage.Find(esrEnt.ExamineStageId);
PageState.Add("ExamineStage", esEnt);
}
PageState.Add("BeUserName", esrEnt.UserName);
}
private void Doselect()
{
string where = "";
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (!String.IsNullOrEmpty(item.Value.ToString()))
{
switch (item.PropertyName)
{
default:
where += " and def2 like '%" + item.Value + "%' ";
break;
}
}
}
string SQL = @"select newid() as Id,def2 As XL from (
select distinct def2 from HR_OA_MiddleDB..fld_gw where def2 is not null
) AS T where 1=1 ";
SQL = SQL + where;
SQL = SQL.Replace("HR_OA_MiddleDB", Global.HR_OA_MiddleDB);
SearchCriterion.SetOrder("XL");
this.PageState.Add("DataList", GetPageData(SQL, SearchCriterion));
}
private void DoSelect()
{
SearchCriterion.SetOrder("SortIndex");
var ents = Model.ManagementGroup.FindAll(SearchCriterion);
this.PageState.Add("DataList", ents);
}
private void DoSelect()
{
sql = @"select Id as IndicatorFirstId ,IndicatorFirstName from BJKY_Examine..IndicatorFirst
where ExamineIndicatorId = '" + ExamineIndicatorId + "' order by SortIndex asc ";
EasyDictionary dic = DataHelper.QueryDict(sql, "IndicatorFirstId", "IndicatorFirstName");
PageState.Add("IndictorFirstEnum", dic);//Combo数据集
if (op != "c" && op != "cs")
{
if (!String.IsNullOrEmpty(id))
{
ent = IndicatorSecond.Find(id);
}
SetFormData(ent);
SearchCriterion.AddSearch(ScoreStandard.Prop_IndicatorSecondId, id);
SearchCriterion.SetOrder("SortIndex", true);
ents = ScoreStandard.FindAll(SearchCriterion);
PageState.Add("DataList", ents);
}
else
{
if (!string.IsNullOrEmpty(IndicatorFirstId))
{
IndicatorFirst ifEnt = IndicatorFirst.Find(IndicatorFirstId);
sql = "select isnull(max(SortIndex),0) from BJKY_Examine..IndicatorSecond where IndicatorFirstId='" + IndicatorFirstId + "'";
var obj = new
{
SortIndex = DataHelper.QueryValue <int>(sql) + 1,
ExamineIndicatorId = ExamineIndicatorId
};
SetFormData(obj);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Aim.WorkFlow.Task ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Delete:
ent = this.GetTargetData <Aim.WorkFlow.Task>();
ent.DoDelete();
this.SetMessage("删除成功！");
break;
default:
if (RequestActionString == "batchdelete")
{
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
SysWorkFlowTask.DoBatchDelete(idList.ToArray());
}
}
else
{
SearchCriterion.SetSearch("EFormName", this.RequestData["FormId"].ToString(), SearchModeEnum.Like);
SearchCriterion.SetOrder("CreatedTime", true);
ents = Aim.WorkFlow.TaskRule.FindAll(SearchCriterion);
this.PageState.Add("SysWorkFlowTaskList", ents);
}
break;
}
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
SearchCriterion.SetSearch("CreateId", UserInfo.UserID);
SearchCriterion.SetOrder("CreateTime", false);
ents = EmpVoiceAskQuestion.FindAll(SearchCriterion);
this.PageState.Add("DataList", ents);
this.PageState.Add("QuestionEnum", SysEnumeration.GetEnumDict("QuestionType"));
}
string code = String.Empty; // 编码
#endregion
#region 构造函数
#endregion
#region ASP.NET 事件
protected void Page_Load(object sender, EventArgs e)
{
op = RequestData.Get <string>("op");
id = RequestData.Get <string>("id");
type = RequestData.Get <string>("type");
code = RequestData.Get <string>("code");
DynamicAuthCatalog dac = null; // 动态权限类型
SearchCriterion sc = new HqlSearchCriterion();
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetOrder("CreatedDate");
SearchCriterion.AddSearch("EditStatus", "G", SearchModeEnum.Like); // 只显示允许授权的节点
if (type == "catalog")
{
if (String.IsNullOrEmpty(code) && !String.IsNullOrEmpty(id))
{
dac = DynamicAuthCatalog.Find(id);
code = dac.Code;
}
if (!String.IsNullOrEmpty(code))
{
SearchCriterion.AddSearch("CatalogCode", code);
SearchCriterion.AddSearch("ParentID", SingleSearchModeEnum.IsNull);
ents = DynamicAuthRule.FindAll(SearchCriterion);
if (dac == null)
{
dac = DynamicAuthCatalog.FindFirst(Expression.Eq("Code", code));
}
}
}
else if (!String.IsNullOrEmpty(id))
{
SearchCriterion.AddSearch("ParentID", id);
ents = DynamicAuthRule.FindAll(SearchCriterion);
DynamicAuth da = DynamicAuth.Find(id);
dac = DynamicAuthCatalog.FindFirst(Expression.Eq("Code", da.CatalogCode));
}
this.PageState.Add("EntList", ents);
if (!IsAsyncRequest)
{
if (dac != null)
{
IList <DynamicPermissionCatalog> dpcs = dac.AllowGrantPermissionCatalog;
this.PageState.Add("PCatalogList", dpcs);
}
}
}
/// <summary>
/// 选择操作
/// </summary>
private void DoSelect()
{
DynamicAuthCatalog dac = null; // 动态权限类型
SearchCriterion sc = new HqlSearchCriterion();
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetOrder("CreatedDate");
SearchCriterion.AddSearch("EditStatus", "G", SearchModeEnum.Like); // 只显示允许授权的节点
if (type == "catalog")
{
if (String.IsNullOrEmpty(code) && !String.IsNullOrEmpty(id))
{
dac = DynamicAuthCatalog.Find(id);
code = dac.Code;
}
if (!String.IsNullOrEmpty(code))
{
SearchCriterion.AddSearch("CatalogCode", code);
SearchCriterion.AddSearch("ParentID", SingleSearchModeEnum.IsNull);
ents = DynamicAuthRule.FindAll(SearchCriterion);
if (dac == null)
{
dac = DynamicAuthCatalog.FindFirst(Expression.Eq("Code", code));
}
}
}
else if (!String.IsNullOrEmpty(id))
{
SearchCriterion.AddSearch("ParentID", id);
ents = DynamicAuthRule.FindAll(SearchCriterion);
DynamicAuth da = DynamicAuth.Find(id);
dac = DynamicAuthCatalog.FindFirst(Expression.Eq("Code", da.CatalogCode));
}
this.PageState.Add("EntList", ents);
if (!IsAsyncRequest)
{
if (dac != null)
{
IList <DynamicPermissionCatalog> dpcs = dac.AllowGrantPermissionCatalog;
this.PageState.Add("PCatalogList", dpcs);
this.PageState.Add("AllowOperation", dac.GetAllowOperations()); // 允许的操作
}
this.PageState.Add("OpDivChar", DynamicOperations.DivChar); // 操作分割符
}
}
string code = String.Empty; // 对象类型
#endregion
#region 构造函数
#endregion
#region ASP.NET 事件
protected void Page_Load(object sender, EventArgs e)
{
op = RequestData.Get <string>("op");
id = RequestData.Get <string>("id");
code = RequestData.Get <string>("code");
if (IsAsyncRequest)
{
DynamicAuth ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Read:
case RequestActionEnum.Query:
case RequestActionEnum.Default:
if (SearchCriterion.Orders.Count <= 0)
{
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetOrder("CreatedDate");
}
SearchCriterion.AddSearch("CatalogCode", code);
SearchCriterion.AddSearch("EditStatus", SingleSearchModeEnum.IsNotNull);
SearchCriterion.AddSearch("EditStatus", "", SearchModeEnum.NotEqual);
if (String.IsNullOrEmpty(id))
{
SearchCriterion.AddSearch("ParentID", SingleSearchModeEnum.IsNull);
}
else
{
SearchCriterion.AddSearch("ParentID", id);
}
ents = DynamicAuthRule.FindAll(SearchCriterion);
break;
case RequestActionEnum.Delete:
ent = DynamicAuth.Find(id);
ent.DoDelete();
this.SetMessage("删除成功！");
break;
}
this.PageState.Add("EntList", ents);
}
else
{
SearchCriterion sc = new HqlSearchCriterion();
sc.SetOrder("SortIndex");
sc.SetOrder("CreatedDate");
DynamicAuthCatalog[] entCatalogs = DynamicAuthCatalogRule.FindAll(sc);
this.PageState.Add("EntCatalogList", entCatalogs);
}
}
private void DoSelect()
{
if (!string.IsNullOrEmpty(SurveyId))
{
SearchCriterion.SetSearch("SurveyId", SurveyId);
SearchCriterion.SetOrder("CreateWay");
SurveyCanReaderUsr[] SrEnt = SurveyCanReaderUsr.FindAll(SearchCriterion);
this.PageState.Add("DataList2", SrEnt);
}
}
private void DoSelect()
{
if (!string.IsNullOrEmpty(SurveyId))
{
string where = "";
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (!String.IsNullOrEmpty(item.Value.ToString()))
{
switch (item.PropertyName)
{
case "StartTime":
where += " and CreateTime>='" + item.Value + "' ";
break;
case "EndTime":
where += " and CreateTime<='" + (item.Value.ToString()).Replace(" 0:00:00", " 23:59:59") + "' ";
break;
default:
where += " and " + item.PropertyName + " like '%" + item.Value + "%' ";
break;
}
}
}
//SearchCriterion.SetSearch("SurveyId", SurveyId);
//SearchCriterion.SetOrder("CreateWay");
//SurveyFinallyUsr[] SuEnt = SurveyFinallyUsr.FindAll(SearchCriterion);
// this.PageState.Add("DataList1", SuEnt);
string SQL = @"select distinct A.*,B.Phone,B.Email,
case when C.State='1' then '是'
when C.State='0' then '否'
else '否'
end As EmailIsFilled,
case when C.PhoneState='1' then '是'
when C.PhoneState='0' then '否'
else '否'
end As MsgIsFilled,
case when D.Id is null then 'N' when D.Id is not null then 'Y' end As Commited
from FL_Culture..SurveyFinallyUsr As A
left join FL_PortalHR..SysUser As B
on A.UserID=B.UserID
left join FL_Recruitment..Remind As C
on A.UserID =C.UserId and C.EXT1='S|'+A.Surveyid
left join FL_Culture..SurveyCommitHistory As D
on A.UserId=D.SurveyedUserId and D.SurveyId=A.SurveyId
where A.SurveyId='{0}' ";
SQL += where;
SQL = string.Format(SQL, SurveyId);
SQL = SQL.Replace("FL_PortalHR", Global.AimPortalDB);
SQL = SQL.Replace("FL_Recruitment", Global.FL_Recruitment);
SearchCriterion.SetOrder("CreateWay");
this.PageState.Add("DataList1", GetPageData(SQL, SearchCriterion));
}
}
private void DoSelect()
{
if (!string.IsNullOrEmpty(SurveyId))
{
var Ent = SurveyQuestion.Find(SurveyId);
if (string.IsNullOrEmpty(Ent.TemplateId))
{
string sql = @"select * from FL_Culture..QuestionItem where SurveyId='{0}' order by SortIndex ";
sql = string.Format(sql, SurveyId);
this.PageState.Add("DataList", DataHelper.QueryDictList(sql));
}
else
{
//判断是否合并过
string SQL = "select * from FL_Culture..QuestionItem where SurveyId='{0}' ";
SQL = string.Format(SQL, SurveyId);
var Ents = DataHelper.QueryDictList(SQL);
if (Ents.Count > 0)
{
string sql = @"select * from FL_Culture..QuestionItem where SurveyId='{0}' order by SortIndex ";
sql = string.Format(sql, SurveyId);
this.PageState.Add("DataList", DataHelper.QueryDictList(sql));
//SearchCriterion.SetOrder("SortIndex");
//IList<QuestionItem> Items = QuestionItem.FindAll(SearchCriterion, Expression.Sql(" SurveyId='" + SurveyId + "'"));
//this.PageState.Add("DataList", Items);
return;
}
//合并模板
var TemplateId = Ent.TemplateId;
var ItemEnts = QuestionItem.FindAllByProperties(QuestionItem.Prop_SurveyId, TemplateId);
var SubItemEnts = QuestionAnswerItem.FindAllByProperties(QuestionAnswerItem.Prop_SurveyId, TemplateId);
foreach (var ent in ItemEnts)
{
QuestionItem Item = new QuestionItem();
Item = ent;
Item.SurveyId = SurveyId;
Item.DoCreate();
}
foreach (var subEnt in SubItemEnts)
{
QuestionAnswerItem subItem = new QuestionAnswerItem();
subItem = subEnt;
subItem.SurveyId = SurveyId;
subItem.DoCreate();
}
SearchCriterion.SetOrder("SortIndex");
IList <QuestionItem> items = QuestionItem.FindAll(SearchCriterion, Expression.Sql(" SurveyId='" + SurveyId + "'"));
this.PageState.Add("DataList", items);
}
}
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
string where = string.Empty;
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (!String.IsNullOrEmpty(item.Value.ToString()))
{
switch (item.PropertyName)
{
case "CreateTime":
where += " year(CreateTime)=" + item.Value + " ";
break;
}
}
}
SearchCriterion.RemoveSearch("CreateTime");
SearchCriterion.SetOrder(TravelMoneyConfig.Prop_Corp); //公司
SearchCriterion.SetOrder(TravelMoneyConfig.Prop_Indutydate, true); //日期
CommPowerSplit PS = new CommPowerSplit();
SysUser UsrEnt = SysUser.Find(UserInfo.UserID);
if (PS.TraveMoneyConfig(UserInfo.UserID, UserInfo.LoginName)) //总部HR权限 HR1
{
if (!string.IsNullOrEmpty(where))
{
ents = TravelMoneyConfig.FindAll(SearchCriterion, Expression.Sql(where));
this.PageState.Add("TravelMoneyConfigList", ents);
}
else
{
ents = TravelMoneyConfig.FindAll(SearchCriterion);
this.PageState.Add("TravelMoneyConfigList", ents);
}
}
else
{
//公司权限
UserContextInfo UC = new UserContextInfo();
SearchCriterion.SetSearch(TravelMoneyConfig.Prop_Corp, UC.GetUserCurrentCorpId(UserInfo.UserID));
if (!string.IsNullOrEmpty(where))
{
ents = TravelMoneyConfig.FindAll(SearchCriterion, Expression.Sql(where));
this.PageState.Add("TravelMoneyConfigList", ents);
}
else
{
ents = TravelMoneyConfig.FindAll(SearchCriterion);
this.PageState.Add("TravelMoneyConfigList", ents);
}
}
}
private void DoSelect()
{
if (string.IsNullOrEmpty(ExamineIndicatorId))
{
return;
}
SearchCriterion.SetSearch(IndicatorFirst.Prop_ExamineIndicatorId, ExamineIndicatorId);
SearchCriterion.SetOrder("SortIndex", true);
ents = IndicatorFirst.FindAll(SearchCriterion);
PageState.Add("DataList", ents);
PageState.Add("BeRoleName", SysEnumeration.GetEnumDict("BeExamineObject")); //被考核
}
protected void Page_Load(object sender, EventArgs e)
{
if (SearchCriterion.Orders.Count <= 0)
{
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetOrder("CreatedDate");
}
ents = DynamicPermissionCatalogRule.FindAll(SearchCriterion);
this.PageState.Add("DtList", ents);
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
string LeaderId = RequestData.Get <string>("LeaderId");
string ids = RequestData.Get <string>("id");
string where = "";
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (!String.IsNullOrEmpty(item.Value.ToString()))
{
switch (item.PropertyName)
{
case "TripStartTime":
where += " and TripStartTime>='" + item.Value + "' ";
break;
case "TripEndTime":
where += " and TripStartTime<='" + (item.Value.ToString()).Replace(" 0:00:00", " 23:59:59") + "' ";
break;
default:
where += " and " + item.PropertyName + " like '%" + item.Value + "%' ";
break;
}
}
}
string sql = @"select *,charindex(LeaderName,'{0}') As SortIndex from BJKY_IntegratedManage..LeaderBusinessTrip where 1=1 ";
//按顺序获取领导
string LeaderSql = @"select STUFF((select ','+ CAST(UserName AS varchar) from BJKY_IntegratedManage..InstituteLeader FOR XML PATH('')),1,1,'' ) As LeaderName ";
object obj = DataHelper.QueryValue(LeaderSql);
sql = string.Format(sql, obj);
//if (!string.IsNullOrEmpty(RequestData.Get<string>("viewType") + "")) //处理月份
//{
// sql = "select * from BJKY_IntegratedManage..LeaderBusinessTrip where '{0}' like '%'+Id+'%' ";
// sql = string.Format(sql, ids);
//}
if (!string.IsNullOrEmpty(where))
{
sql = sql + where;
}
if (!string.IsNullOrEmpty(LeaderId))
{
sql += " and LeaderId='" + LeaderId + "'";
}
//sql += " order by SortIndex ";
SearchCriterion.SetOrder("SortIndex");
//ents = IntegratedManage.Model.LeaderBusinessTrip.FindAll();
this.PageState.Add("LeaderBusinessTripList", GetPageData(sql, SearchCriterion));
}
protected void Page_Load(object sender, EventArgs e)
{
id = RequestData.Get <string>("id", String.Empty);
// 类型标识
cid = RequestData.Get <string>("cid", String.Empty);
type = RequestData.Get <string>("type", String.Empty).ToLower();
ctype = RequestData.Get <string>("ctype", "role").ToLower();
if (!IsAsyncRequest)
{
cid = "2"; //WGM 13/4/7 默认组织结构
if (!String.IsNullOrEmpty(cid))
{
try
{
int icid = Convert.ToInt32(cid);
SearchCriterion.SetOrder("ParentID");
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetOrder("CreateDate");
SearchCriterion.AddSearch("Type", icid);
ents = SysGroupRule.FindAll(SearchCriterion);
}
catch { }
this.PageState.Add("DtList", ents);
}
else
{
SysGroupType[] typeList = SysGroupTypeRule.FindAll();
this.PageState.Add("DtList", typeList);
}
}
else
{
switch (this.RequestAction)
{
case RequestActionEnum.Custom:
if (RequestActionString == "querychildren")
{
if (type == "gtype")
{
ents = SysGroup.FindAll("FROM SysGroup as ent WHERE ent.Type = ?", id);
this.PageState.Add("DtList", ents);
}
}
break;
}
}
}
/// <summary>
/// default
/// </summary>
private void DoSelect()
{
string PId = RequestData.Get("PId") + "";
if (!string.IsNullOrEmpty(PId))
{
//ManagementInfo.Prop_PId, PId);
SearchCriterion.AddSearch("PId", PId);
SearchCriterion.SetOrder(ManagementInfo.Prop_CreateTime, false);
var Ents = ManagementInfo.FindAll(SearchCriterion);
this.PageState.Add("DataList", Ents);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// 若未对SortIndex和CreateTime进行排序，在这里进行排序
if (!SearchCriterion.HasOrdered("SortIndex") && SearchCriterion.HasOrdered("CreateTime"))
{
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetOrder("CreateTime");
}
ents = SysGroup.FindAll(SearchCriterion);
this.PageState.Add("DtList", ents);
}
protected void Page_Load(object sender, EventArgs e)
{
id = RequestData.Get <string>("id", String.Empty);
type = RequestData.Get <string>("type", String.Empty).ToLower();
ctype = RequestData.Get <string>("ctype", "user").ToLower();
if (ctype == "group")
{
if (!String.IsNullOrEmpty(id))
{
ICriterion cirt = null;
if (type == "gtype")
{
cirt = Expression.Sql("UserID IN (SELECT UserID FROM SysUserGroup WHERE GroupID IN (SELECT GroupID FROM SysGroup WHERE Type = ?))", id, NHibernateUtil.String);
}
else
{
// 应该同时获取子组用户 矿研的组织机构sysgroup path 字段中并不包含本记录的ID 所以下列语句要改写
//cirt = Expression.Sql("UserID IN (SELECT UserID FROM View_SysUserGroup WHERE Path LIKE '%" + id + "%' or GroupId='" + id + "')",
// id, NHibernateUtil.String);
cirt = Expression.Sql("UserID IN (SELECT UserID FROM SysUserGroup WHERE GroupID IN (SELECT GroupID FROM SysGroup where Path LIKE '%" + id + "%' or GroupId='" + id + "'))",
id, NHibernateUtil.String);
}
cirt = SearchHelper.IntersectCriterions(cirt, Expression.IsNull("Ext1"));
SearchCriterion.AutoOrder = false;
SearchCriterion.SetOrder(SysUser.Prop_WorkNo);
users = SysUserRule.FindAll(SearchCriterion, cirt);
}
PageState.Add("UsrList", users);
}
else
{
SearchCriterion.AutoOrder = false;
string dName = SearchCriterion.GetSearchValue <string>("Name");
string workNo = SearchCriterion.GetSearchValue <string>("WorkNo");
SearchCriterion.SetOrder(SysUser.Prop_WorkNo);
if (dName != null && dName.Trim() != "")
{
string where = "select * from SysUser where " + GetPinyinWhereString("Name", dName);
where += "and Ext1 is null and WorkNo like '%" + workNo + "%'";
PageState.Add("UsrList", DataHelper.QueryDictList(where));
}
else
{
ICriterion cirt = null;
cirt = SearchHelper.IntersectCriterions(cirt, Expression.IsNull("Ext1"));
users = SysUserRule.FindAll(SearchCriterion, cirt);
PageState.Add("UsrList", users);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SearchCriterion.SetOrder("BlockType");
if (!string.IsNullOrEmpty(this.RequestData.Get <string>("BlockType")))
{
ents = WebPartRule.FindAll(SearchCriterion, Expression.Eq("BlockType", this.RequestData.Get <string>("BlockType")));
}
else
{
ents = WebPartRule.FindAll(SearchCriterion, Expression.Eq("BlockType", "portal"));
}
this.PageState.Add("WebPartList", ents);
this.PageState.Add("BlockType", SysEnumeration.GetEnumDict("BlockType"));
Aim.Portal.Model.WebPart ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Insert:
ent = this.GetPostedData <Aim.Portal.Model.WebPart>();
ent.Create();
this.SetMessage("新建成功！");
break;
case RequestActionEnum.Update:
ent = this.GetMergedData <Aim.Portal.Model.WebPart>();
ent.Update();
this.SetMessage("保存成功！");
break;
case RequestActionEnum.Delete:
ent = this.GetTargetData <Aim.Portal.Model.WebPart>();
ent.Delete();
this.SetMessage("删除成功！");
break;
case RequestActionEnum.Custom:
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
if (RequestActionString == "batchdelete")
{
WebPartRule.BatchRemoveByPrimaryKeys(idList);
}
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
SearchCriterion.AutoOrder = false;
SearchCriterion.SetOrder(SysUser.Prop_WorkNo);
string dName = SearchCriterion.GetSearchValue <string>("Name");
if (dName != null && dName.Trim() != "")
{
string where = "select * from SysUser where " + GetPinyinWhereString("Name", dName);
this.PageState.Add("UsrList", DataHelper.QueryDictList(where));
}
else
{
ents = SysUserRule.FindAll(SearchCriterion);
this.PageState.Add("UsrList", ents);
}
if (this.IsAsyncRequest)
{
switch (this.RequestAction)
{
case RequestActionEnum.Custom:
if (RequestActionString == "querychildren")
{
string id = (RequestData.ContainsKey("ID") ? RequestData["ID"].ToString() : String.Empty);
string ttype = RequestData["Type"].ToString().ToLower();
if (RequestData.ContainsKey("Type"))
{
if (ttype == "atype") // 1为入口权限
{
SysAuth[] auths = SysAuth.FindAll("FROM SysAuth as ent WHERE ent.Type = ?", id);
this.PageState.Add("DtList", auths);
}
}
}
break;
default:
break;
}
}
else
{
SysAuthType[] authTypeList = SysAuthTypeRule.FindAll();
this.PageState.Add("DtList", authTypeList);
}
}
protected void Page_Load(object sender, EventArgs e)
{
id = RequestData.Get <string>("id", String.Empty);
type = RequestData.Get <string>("type", String.Empty).ToLower();
ctype = RequestData.Get <string>("ctype", "user").ToLower();
if (ctype == "group")
{
if (!String.IsNullOrEmpty(id))
{
ICriterion cirt = null;
if (type == "gtype")
{
cirt = Expression.Sql("UserID IN (SELECT UserID FROM SysUserGroup WHERE GroupID IN (SELECT GroupID FROM SysGroup WHERE Type = ?))", id, NHibernateUtil.String);
}
else
{
// 应该同时获取子组用户
cirt = Expression.Sql("UserID IN (SELECT UserID FROM SysUserGroup WHERE GroupID IN (SELECT GroupID FROM SysGroup WHERE GroupID = ? OR Path LIKE '%" + id + "%'))",
id, NHibernateUtil.String);
}
SearchCriterion.AutoOrder = false;
SearchCriterion.SetOrder(SysUser.Prop_WorkNo);
users = SysUserRule.FindAll(SearchCriterion, cirt);
this.PageState.Add("UsrList", users);
}
}
else
{
SearchCriterion.AutoOrder = false;
string dName = SearchCriterion.GetSearchValue <string>("Name");
string workNo = SearchCriterion.GetSearchValue <string>("WorkNo");
SearchCriterion.SetOrder(SysUser.Prop_WorkNo);
if (dName != null && dName.Trim() != "")
{
string where = "select * from SysUser where " + GetPinyinWhereString("Name", dName);
where += " and WorkNo like '%" + workNo + "%'";
this.PageState.Add("UsrList", DataHelper.QueryDictList(where));
}
else
{
users = SysUserRule.FindAll(SearchCriterion);
this.PageState.Add("UsrList", users);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (SearchCriterion.Orders.Count <= 0)
{
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetOrder("CreatedDate");
}
ents = DynamicAuthCatalogRule.FindAll(SearchCriterion);
this.PageState.Add("DynamicAuthCatalogList", ents);
DynamicAuthCatalog ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Create:
ent = this.GetPostedData <DynamicAuthCatalog>();
ent.DoCreate();
this.SetMessage("新建成功！");
break;
case RequestActionEnum.Update:
ent = this.GetMergedData <DynamicAuthCatalog>();
ent.DoUpdate();
this.SetMessage("保存成功！");
break;
case RequestActionEnum.Delete:
ent = this.GetTargetData <DynamicAuthCatalog>();
ent.DoDelete();
this.SetMessage("删除成功！");
break;
case RequestActionEnum.Custom:
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
if (RequestActionString == "batchdelete")
{
DynamicAuthCatalogRule.BatchRemoveByPrimaryKeys(idList);
}
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Request.Files.Count > 0)
{
string guid = Guid.NewGuid().ToString();
string filePath = "//WorkTime//InputExcelFiles//" + Guid.NewGuid().ToString() + System.IO.Path.GetExtension(Request.Files[0].FileName);
this.Request.Files[0].SaveAs(Server.MapPath(filePath));
ExcelProcessor ep = ExcelService.GetProcessor(Server.MapPath(filePath));
DataSet ds = ep.GetDataSet();
InputDatas(ds.Tables[0]);
Response.Write("{success:true}");
Response.End();
}
id = RequestData.Get <string>("id", String.Empty);
type = RequestData.Get <string>("type", String.Empty);
SearchCriterion.AutoOrder = false;
SearchCriterion.SetOrder(SysUser.Prop_WorkNo);
users = SysUserRule.FindAll(SearchCriterion);
this.PageState.Add("UsrList", users);
SysUser usr = null;
switch (this.RequestAction)
{
case RequestActionEnum.Create:
usr = this.GetPostedData <SysUser>();
usr.DoCreate();
this.SetMessage("新建成功！");
break;
case RequestActionEnum.Update:
usr = this.GetMergedData <SysUser>();
usr.DoUpdate();
this.SetMessage("保存成功！");
break;
case RequestActionEnum.Delete:
usr = this.GetTargetData <SysUser>();
usr.DoDelete();
this.SetMessage("删除成功！");
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.IsAsyncRequest)
{
SearchCriterion.SetOrder("CreateDate");
SearchCriterion.SetOrder("SortIndex");
ents = SysRoleRule.FindAll(SearchCriterion);
this.PageState.Add("RoleList", ents);
}
SysRole ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Update:
ent = this.GetMergedData <SysRole>();
ent.SaveAndFlush();
this.SetMessage("保存成功！");
break;
case RequestActionEnum.Create:
ent = this.GetPostedData <SysRole>();
ent.CreateAndFlush();
this.SetMessage("新建成功！");
break;
case RequestActionEnum.Delete:
ent = this.GetTargetData <SysRole>();
ent.DeleteAndFlush();
this.SetMessage("删除成功！");
break;
case RequestActionEnum.Custom:
if (RequestActionString == "refreshsys")
{
PortalService.RefreshSysModules();
SetMessage("操作成功！");
}
break;
}
SysRoleType[] roleTypes = SysRoleTypeRule.FindAll();
this.PageState.Add("RoleTypeList", roleTypes);
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
string CorpId = string.Empty;
string where = string.Empty;
var UsrEnt = SysUser.Find(UserInfo.UserID);
CommPowerSplit ps = new CommPowerSplit();
if (ps.IsNoticeRole(UserInfo.UserID, UserInfo.LoginName))
{
where += " (WorkFlowState='1' or WorkFlowState='2' or WorkFlowState='-1') ";
if (!string.IsNullOrEmpty(SearchCriterion.GetSearchValue("Year") + ""))
{
where += " and year(ApplyTime)= " + SearchCriterion.GetSearchValue("Year") + " ";
}
SearchCriterion.RemoveSearch("Year");
ents = UsrTravelWelfare.FindAll(SearchCriterion, Expression.Sql(where));
this.PageState.Add("UsrTravelWelfareList", ents);
}
else
{
// 判断公司登陆
UserContextInfo UC = new UserContextInfo();
CorpId = UC.GetUserCurrentCorpId(UserInfo.UserID);
//SearchCriterion.AddSearch("CompanyId", CorpId);
where += " (WorkFlowState='1' or WorkFlowState='2' or WorkFlowState='-1') " + AppealUsrAuth();
if (!string.IsNullOrEmpty(SearchCriterion.GetSearchValue("Year") + ""))
{
where += " and year(ApplyTime)= " + SearchCriterion.GetSearchValue("Year") + " ";
}
SearchCriterion.RemoveSearch("Year");
SearchCriterion.SetOrder("CompanyId", true);
ents = UsrTravelWelfare.FindAll(SearchCriterion, Expression.Sql(where));
this.PageState.Add("UsrTravelWelfareList", ents);
}
}
protected void Page_Load(object sender, EventArgs e)
{
cid = RequestData.Get <string>("cid");
SysParameter ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Delete:
ent = this.GetTargetData <SysParameter>();
ent.DoDelete();
this.SetMessage("删除成功！");
break;
case RequestActionEnum.Custom:
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
if (RequestActionString == "batchdelete")
{
SysParameter.DoBatchDelete(idList.ToArray());
}
}
break;
default:
if (!String.IsNullOrEmpty(cid))
{
SearchCriterion.SetOrder("SortIndex");
SearchCriterion.SetSearch("CatalogID", cid);
ents = SysParameterRule.FindAll(SearchCriterion);
this.PageState.Add("SysEnumerationList", ents);
}
break;
}
}
private void Doselect()
{
string CorpId = RequestData.Get("CorpId") + "";
string where = "";
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (!String.IsNullOrEmpty(item.Value.ToString()))
{
switch (item.PropertyName)
{
default:
where += " and jobname like '%" + item.Value + "%' ";
break;
}
}
}
string SQL = @"select newid() as Id,jobname As XL from (
select distinct jobname from HR_OA_MiddleDB..fld_gw where isabort='N' and {0}
) AS T where 1=1 ";
if (!string.IsNullOrEmpty(CorpId))
{
SQL = string.Format(SQL, " pk_corp='" + CorpId + "' ");
}
else
{
SQL = string.Format(SQL, " 1=1 ");
}
SQL = SQL + where;
SQL = SQL.Replace("HR_OA_MiddleDB", Global.HR_OA_MiddleDB);
SearchCriterion.SetOrder("XL");
this.PageState.Add("DataList", GetPageData(SQL, SearchCriterion));
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
SearchCriterion.SetOrder("SortIndex");
ents = Model.SurveyType.FindAll(SearchCriterion);
this.PageState.Add("DataList", ents);
}
