/// <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");
}
private void DoBatchDelete()
{
IList <object> idList = RequestData.GetList <object>("IdList");
if (idList != null && idList.Count > 0)
{
TravelMoneyConfig.DoBatchDelete(idList.ToArray());
}
}
/// <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);
}
}
}
string type = String.Empty; // 对象类型
protected void Page_Load(object sender, EventArgs e)
{
op = RequestData.Get <string>("op");
id = RequestData.Get <string>("id");
type = RequestData.Get <string>("type");
TravelMoneyConfig ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Update:
ent = this.GetMergedData <TravelMoneyConfig>();
ent.DoUpdate();
break;
case RequestActionEnum.Insert:
case RequestActionEnum.Create:
ent = this.GetPostedData <TravelMoneyConfig>();
ent.DoCreate();
break;
case RequestActionEnum.Delete:
ent = this.GetTargetData <TravelMoneyConfig>();
ent.DoDelete();
return;
default:
if (RequestActionString == "SelectVal")
{
GetDetailInfo();
}
break;
}
if (op != "c" && op != "cs")
{
if (!String.IsNullOrEmpty(id))
{
ent = TravelMoneyConfig.Find(id);
}
this.SetFormData(ent);
}
}
protected void Page_Load(object sender, EventArgs e)
{
SearchCriterion.PageSize = 40;
TravelMoneyConfig ent = null;
switch (this.RequestAction)
{
case RequestActionEnum.Delete:
ent = this.GetTargetData <TravelMoneyConfig>();
ent.DoDelete();
this.SetMessage("删除成功！");
break;
default:
if (RequestActionString == "batchdelete")
{
DoBatchDelete();
}
else if (RequestActionString == "ImpUser")
{
DoImpData();
}
else if (RequestActionString == "EditMoney")
{
DoEditMoney();
}
else if (RequestActionString == "CreateMoney")
{
CreateMoney();
}
else if (RequestActionString == "CreateCheck")
{
CreateCheck();
}
else
{
DoSelect();
}
break;
}
}
/// <summary>
/// 导入数据
/// </summary>
private void DoImpData()
{
string prefix = FileModule.FindFirstByProperties("Name", "Portal").RootPath + "\\Default\\";
string FilePath = RequestData.Get("FileId") + "";
FilePath = prefix + FilePath;
DataTable Dt = ExcelToDataTable(FilePath, 4);
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);
SysGroup DeptGroup = SysGroup.TryFind(UserEnt.Pk_deptdoc); //Dept
TravelMoneyConfig TM = new TravelMoneyConfig();
ComUtility Utility = new ComUtility();
string Money = string.Empty;
if (string.IsNullOrEmpty(Dt.Rows[i]["服务年限奖励金"] + ""))
{
Money = Utility.GetTravelMoney(workno);
decimal M = 0.0m;
if (decimal.TryParse(Money, out M))
{
TM.Money = M;
}
}
else
{
decimal M = 0.0m;
if (decimal.TryParse(Dt.Rows[i]["服务年限奖励金"] + "", out M))
{
TM.Money = M;
}
}
//基本津贴
decimal MK = 0.0m;
string BaseMoney = Utility.GetTravelBaseMoney(workno);
if (decimal.TryParse(BaseMoney, out MK))
{
TM.BaseMoney = MK;
}
TM.UserId = UserEnt.UserID;
TM.UserName = UserEnt.Name;
TM.WorkNo = UserEnt.WorkNo;
DateTime DTime = new DateTime();
if (DateTime.TryParse(UserEnt.Indutydate, out DTime))
{
TM.Indutydate = DTime;
}
if (!string.IsNullOrEmpty(Dt.Rows[i]["是否已用"] + ""))
{
string val = string.Empty;
val = ((Dt.Rows[i]["是否已用"] + "") == "是" || (Dt.Rows[i]["是否已用"] + "") == "Y") ? "Y" : "N";
TM.HaveUsed = val;
}
if (Group != null)
{
TM.Corp = Group.GroupID;
TM.CorpName = Group.Name;
}
if (DeptGroup != null)
{
TM.DeptId = DeptGroup.GroupID;
TM.DeptName = DeptGroup.Name;
}
TM.CreateTime = DateTime.Now;
TM.UserId = UserEnt.UserID;
TM.Create();
}
catch { }
}
this.PageState.Add("State", "1");
}
/// <summary>
/// 生成旅游金额
/// </summary>
private void CreateMoney()
{
string CorpId = string.Empty;
UserContextInfo UC = new UserContextInfo();
CorpId = UC.GetUserCurrentCorpId(UserInfo.UserID);
EasyDictionary LimitDate = SysEnumeration.GetEnumDict("TravelLimitDate");
string limitDateStr = string.Empty;
if ((LimitDate["LimitDate"] + "").ToUpper() == "2L") //2 月最后一天
{
limitDateStr = "'" + GetLastDayOfMonth(DateTime.Now.Year, 2).ToString("yyyy-MM-dd") + "'";
}
else
{
string prefix = LimitDate["LimitDate"] + "";
limitDateStr = "'" + DateTime.Now.Year + "-" + prefix + "'";
}
EasyDictionary Dic = SysEnumeration.GetEnumDict("BaseMoney");
string One = Dic[">1<5"] + "";
string Two = Dic[">=5<10"] + "";
string Three = Dic[">=10<15"] + "";
string Four = Dic[">=15<20"] + "";
EasyDictionary DicBase = SysEnumeration.GetEnumDict("WorkYearMoney");
string BaseMoney_One = DicBase["<1年"] + "";
string BaseMoney_two = DicBase[">1年"] + "";
string SQL = @"select A.* ,
case
when 1<datediff(year, Indutydate,getdate())and datediff(year,Indutydate,getdate())<5 then {0}
when 5<=datediff(year,Indutydate,getdate())and datediff(year,Indutydate,getdate())<10 then {1}
when 10<=datediff(year,Indutydate,getdate())and datediff(year,Indutydate,getdate())<15 then {2}
when 15<=datediff(year,Indutydate,getdate())and datediff(year,Indutydate,getdate())<20 then {3}
else 0
end As YearMoney,
case
when charindex('正式工',B.psnclassname)>0 and year(Indutydate)>1 then {5}
else {4}
end As BaseMoney ,C.GroupID as CorpId,C.Name As CorpName,D.GroupID As DeptId,D.Name As DeptName
from FL_PortalHR..sysuser As A
left join HR_OA_MiddleDB..fld_rylb As B
on B.pk_fld_rylb=A.Pk_rylb
left join FL_PortalHR..SysGroup As C
on C.GroupID=A.PK_Corp
left join FL_PortalHR..SysGroup As D
on D.GroupID=A.Pk_deptdoc
where
(OutdutyDate='' or OutdutyDate is null) and A.Status=1 and A.Indutydate<>'' ##QUERY## ";
SQL = string.Format(SQL, One, Two, Three, Four, BaseMoney_One, BaseMoney_two);
SQL = SQL.Replace("FL_PortalHR", Global.AimPortalDB);
SQL = SQL.Replace("HR_OA_MiddleDB", Global.HR_OA_MiddleDB);
SQL = SQL.Replace("getdate()", limitDateStr);
string where = string.Empty;
CommPowerSplit PS = new CommPowerSplit();
if (PS.IsAdmin(UserInfo.LoginName) || PS.IsHR(UserInfo.UserID, UserInfo.LoginName))
{
}
else
{
where += " and A.Pk_corp='" + CorpId + "' ";
}
SQL = SQL.Replace("##QUERY##", where);
DataTable UDt = DataHelper.QueryDataTable(SQL);
for (int i = 0; i < UDt.Rows.Count; i++)
{
try
{
TravelMoneyConfig TM = new TravelMoneyConfig();
string YearMoney = UDt.Rows[i]["YearMoney"] + "", BaseMoney = UDt.Rows[i]["BaseMoney"] + "";
if (!string.IsNullOrEmpty(YearMoney))
{
decimal M = 0.0m;
if (decimal.TryParse(YearMoney, out M))
{
TM.Money = M;
}
}
else
{
TM.Money = 0;
}
//基本津贴
if (!string.IsNullOrEmpty(BaseMoney))
{
decimal M = 0.0m;
if (decimal.TryParse(BaseMoney, out M))
{
TM.BaseMoney = M;
}
}
else
{
TM.BaseMoney = 0;
}
TM.UserId = UDt.Rows[i]["UserID"] + "";
TM.UserName = UDt.Rows[i]["Name"] + "";
TM.WorkNo = UDt.Rows[i]["WorkNo"] + "";
DateTime DTime = new DateTime();
if (DateTime.TryParse(UDt.Rows[i]["Indutydate"] + "", out DTime))
{
TM.Indutydate = DTime;
}
TM.HaveUsed = "N";
TM.Corp = UDt.Rows[i]["CorpId"] + "";
TM.CorpName = UDt.Rows[i]["CorpName"] + "";
TM.DeptId = UDt.Rows[i]["DeptId"] + "";
TM.DeptName = UDt.Rows[i]["DeptName"] + "";
TM.CreateTime = DateTime.Now;
TM.Ext1 = "C|" + CorpId + "_" + UserInfo.UserID + ""; //生成标志
TM.Create();
}
catch { }
}
this.PageState.Add("State", "1");
}
