/// <summary> /// 查询 /// </summary> private void DoSelect() { string SurveyId = this.RequestData.Get("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; } } } //权限过滤 CommPowerSplit PS = new CommPowerSplit(); if (PS.IsHR(UserInfo.UserID, UserInfo.LoginName) || PS.IsAdmin(UserInfo.LoginName) || PS.IsInAdminsRole(UserInfo.UserID)) { } else { UserContextInfo UC = new UserContextInfo(); where += " and C.GroupId='" + UC.GetUserCurrentCorpId(UserInfo.UserID) + "' "; } string sql = @"select A.Id,A.SurveyId,A.SurveyName,A.WorkNo,A.SurveyedUserId,A.SurveyedUserName,A.CreateTime, A.TotalScore,A.ScoreInfo, B.WorkNo As WorkNo1 , C.GroupID As CropId ,C.Name As CropName,D.GroupID As DeptId,D.Name AS DeptName, E.IsNoName from FL_Culture..SurveyCommitHistory As A left join FL_PortalHR..SysUser As B on A.SurveyedUserId=B.UserID or A.WorkNo=B.WorkNo left join FL_PortalHR..SysGroup As C on C.GroupID=B.Pk_corp left join FL_PortalHR..SysGroup As D on D.GroupID =B.Pk_deptdoc left join FL_Culture..SurveyQuestion As E on A.SurveyId=E.Id where A.SurveyId='{0}' "; sql = sql.Replace("FL_PortalHR", Global.AimPortalDB); sql += where; sql = string.Format(sql, SurveyId); //SearchCriterion.SetSearch("SurveyId", SurveyId); //ents = SurveyCommitHistory.FindAll(SearchCriterion); //this.PageState.Add("SurveyCommitHistoryList", ents); this.PageState.Add("DataList", GetPageData(sql, SearchCriterion)); }
/// <summary> /// 服务年限奖励金额修正 /// </summary> private void DoEditMoney() { string prefix = FileModule.FindFirstByProperties("Name", "Portal").RootPath + "\\Default\\"; string FilePath = RequestData.Get("FileId") + ""; FilePath = prefix + FilePath; DataTable Dt = ExcelToDataTable(FilePath, 4); CommPowerSplit Ps = new CommPowerSplit(); bool IsPower = false; if (Ps.IsHR(UserInfo.UserID, UserInfo.LoginName) || Ps.IsAdmin(UserInfo.LoginName) || Ps.IsInAdminsRole(UserInfo.LoginName)) { IsPower = true; } for (int i = 0; i < Dt.Rows.Count; i++) { try { string workno = Dt.Rows[i]["工号"] + ""; SysUser UserEnt = SysUser.FindFirstByProperties(SysUser.Prop_WorkNo, Dt.Rows[i]["工号"]); SysGroup Group = SysGroup.TryFind(UserEnt.Pk_corp); TravelMoneyConfig TM = new TravelMoneyConfig(); decimal Money = 0.0m; if (!string.IsNullOrEmpty(Dt.Rows[i]["服务年限奖励金"] + "")) { decimal M = 0.0m; if (decimal.TryParse(Dt.Rows[i]["服务年限奖励金"] + "", out M)) { Money = M; } } string HasUsed = string.Empty; if (!string.IsNullOrEmpty(Dt.Rows[i]["是否已用"] + "")) { HasUsed = ((Dt.Rows[i]["是否已用"] + "") == "是" || (Dt.Rows[i]["是否已用"] + "") == "Y") ? "Y" : "N"; } string UpdateSQL = @"declare @id varchar(36) select top 1 @id=Id from FL_Culture..TravelMoneyConfig where WorkNo='{0}' and {3} order by CreateTime desc ; update FL_Culture..TravelMoneyConfig set Money={1}, HaveUsed='{2}' where Id=@id"; //权限 string Condition = string.Empty; Condition = IsPower ? " 1=1 " : " Corp ='" + Group.GroupID + "' "; UpdateSQL = string.Format(UpdateSQL, workno, Money, HasUsed, Condition); DataHelper.ExecSql(UpdateSQL); } catch (Exception e) { //throw new Exception(e.Message); } } this.PageState.Add("State", "1"); }