//创建流程
private void StartFlow()
{
if (op == "c" || op == "create")
{
ent = this.GetPostedData <UsrTravelWelfare>();
ent.ApplyTime = DateTime.Now;
ent.DoCreate();
id = ent.Id;
}
else
{
ent = UsrTravelWelfare.Find(id);
}
//受理人
string UserId = ent.ApproveUserId;
string UserName = ent.ApproveName;
string FlowKey = "EmpUsrWelfare"; //工作流key
if (!string.IsNullOrEmpty(FlowKey))
{
string formUrl = "/EmpWelfare/UsrTravelWelfareEdit.aspx?op=r&id=" + id;
Guid guid = Aim.WorkFlow.WorkFlow.StartWorkFlow(id, formUrl, "员工旅游申请", FlowKey, UserInfo.UserID, UserInfo.Name);
ent.WorkFlowState = "Start";
ent.WorkFLowCode = guid.ToString(); //InstanceId
ent.DoUpdate();
this.PageState.Add("NextInfo", guid.ToString() + "$" + UserId + "|" + UserName);
}
}
private void DoCreate()
{
ent = this.GetPostedData <UsrTravelWelfare>();
ent.ApplyTime = DateTime.Now;
ent.NoticeId = RequestData.Get <string>("noticeid");
ent.TravelAddr = RequestData.Get("TravelAddr") + "";
ent.TravelTime = RequestData.Get("TravelTime") + "";
ent.Ext1 = RequestData.Get("Ext1") + "";
ent.CreateId = UserInfo.UserID;
ent.CreateName = UserInfo.LoginName;
ent.CreateTime = DateTime.Now;
ent.WorkFlowState = "1"; //标识 0未提交状态 1已申报
ent.DoCreate();
SaveEveryForm(RequestData.GetList <string>("data"), ent);
}
private void AnalysUser(DataTable Dt)
{
//判断文件是否为模板格式
if (Dt.Columns.Count != 11 && Dt.Columns[0].ColumnName != "姓名")
{
throw new Exception("文件内容格式不符合模板定义的格式!");
}
string guid = string.Empty; //guid
for (int i = 0; i < Dt.Rows.Count; i++)
{
SysUser UserEnt = null; //
try
{
if (!string.IsNullOrEmpty(Dt.Rows[i]["姓名"] + ""))
{
UsrTravelWelfare UW = new UsrTravelWelfare();
UW.DoCreate();
//guid = Guid.NewGuid().ToString(); //guid
guid = UW.Id; //guid
UserEnt = SysUser.FindFirstByProperties(SysUser.Prop_WorkNo, Dt.Rows[i]["工号"]);
UW.Id = guid;
UW.UserId = UserEnt.UserID;
UW.WorkNo = UserEnt.WorkNo;
if (UserEnt.Name != Dt.Rows[i]["姓名"] + "")
{
UW.UserName = Dt.Rows[i]["姓名"] + "/[" + UserEnt.Name + "]";
}
else
{
UW.UserName = UserEnt.Name;
}
UW.Sex = UserEnt.Sex;
UW.ImpState = "1"; //导入状态 1成功
UW.WorkFlowState = "2"; //标识 同意
UW.Result = "同意";
UW.ApplyTime = DateTime.Now; //申请日期
//公司
SysGroup GroupEnt = SysGroup.TryFind(UserEnt.Pk_corp);
if (GroupEnt != null)
{
UW.CompanyName = Dt.Rows[i]["公司"] + "";
UW.CompanyId = GroupEnt.GroupID; //通过工号 强制关联公司和部门
}
//部门
GroupEnt = SysGroup.TryFind(UserEnt.Pk_deptdoc);
if (GroupEnt != null)
{
UW.DeptId = GroupEnt.GroupID;
UW.DeptName = Dt.Rows[i]["部门"] + "";
}
UW.TravelAddr = Dt.Rows[i]["旅游地点"] + ""; //旅游地点
UW.TravelTime = Dt.Rows[i]["出行时间"] + ""; //出行时间
UW.TravelMoney = (decimal)GetMoney(UserEnt, ""); //旅游金额
//入职日期
if (!string.IsNullOrEmpty(UserEnt.Indutydate))
{
UW.IndutyDate = DateTime.Parse(UserEnt.Indutydate);
}
//员工类型 正式员工,实习生
string WorkerType = DataHelper.QueryValue("select psnclassname from HR_OA_MiddleDB..fld_rylb where pk_fld_rylb='" + UserEnt.Pk_rylb + "'") + "";
UW.WorkerType = WorkerType;
//HaveFamily Y
if (!string.IsNullOrEmpty(Dt.Rows[i]["家属姓名"] + ""))
{
UW.HaveFamily = "Y";
UsrTravelInfo UT = new UsrTravelInfo();
//家属姓名
if (!string.IsNullOrEmpty(Dt.Rows[i]["家属姓名"] + ""))
{
UT.Name = Dt.Rows[i]["家属姓名"] + "";
UT.WelfareTravelId = guid; //* 关联的主键ID
UT.CreateTime = DateTime.Now;
}
//家属年龄
int age = 0;
if (int.TryParse(Dt.Rows[i]["家属年龄"] + "", out age))
{
UT.Age = age;
if (age <= 13) //14 岁为标志
{
UT.IsChild = "是";
}
}
//家属性别
if (!string.IsNullOrEmpty(Dt.Rows[i]["家属性别"] + ""))
{
UT.Sex = Dt.Rows[i]["家属性别"] + "";
}
//家属身高
if (!string.IsNullOrEmpty(Dt.Rows[i]["家属身高"] + ""))
{
Decimal dlb = 0;
if (Decimal.TryParse(Dt.Rows[i]["家属身高"] + "", out dlb))
{
UT.Height = dlb;
}
}
UT.DoCreate(); //创建家属记录
}
//计算金额
UW.CreateId = UserInfo.UserID;
UW.CreateName = UserInfo.Name;
UW.CreateTime = DateTime.Now;
UW.DoUpdate();
}
else
{ //家属信息
UsrTravelInfo UT = null;
if (!string.IsNullOrEmpty(Dt.Rows[i]["家属姓名"] + ""))
{
UT = new UsrTravelInfo();
//家属姓名
if (!string.IsNullOrEmpty(Dt.Rows[i]["家属姓名"] + ""))
{
UT.Name = Dt.Rows[i]["家属姓名"] + "";
UT.WelfareTravelId = guid; //* 关联的主键ID
UT.CreateTime = DateTime.Now;
}
//家属年龄
int age = 0;
if (int.TryParse(Dt.Rows[i]["家属年龄"] + "", out age))
{
UT.Age = age;
if (age <= 13) //14 岁为标志
{
UT.IsChild = "是";
}
}
//家属性别
if (!string.IsNullOrEmpty(Dt.Rows[i]["家属性别"] + ""))
{
UT.Sex = Dt.Rows[i]["家属性别"] + "";
}
//家属身高
if (!string.IsNullOrEmpty(Dt.Rows[i]["家属身高"] + ""))
{
Decimal dlb = 0;
if (Decimal.TryParse(Dt.Rows[i]["家属身高"] + "", out dlb))
{
UT.Height = dlb;
}
}
UT.DoCreate(); //创建家属记录
}
}
}
catch
{
UsrTravelWelfare UW = new UsrTravelWelfare();
UW.ImpState = "0"; //无该人员或异常
UW.WorkFlowState = "Exception"; //异常标识
UW.UserName = Dt.Rows[i]["姓名"] + " [异常]";
UW.WorkNo = Dt.Rows[i]["工号"] + "";
UW.CompanyName = Dt.Rows[i]["公司"] + "";
UW.DeptName = Dt.Rows[i]["部门"] + "";
UW.TravelAddr = Dt.Rows[i]["旅游地点"] + "";
UW.TravelTime = Dt.Rows[i]["出行时间"] + "";
UW.OtherName = Dt.Rows[i]["家属姓名"] + " [异常]";
UW.CreateTime = DateTime.Now;
UW.DoCreate();
}
}
}