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