protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[1].Text = e.Row.Cells[1].Text == "True" ? "男" : "女";
switch (e.Row.Cells[7].Text)
{
case "2": e.Row.Cells[7].Text = "未通过 <a href='?UserID=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "&redo=1&state=5'>重新面试</a>"; break;
case "5": e.Row.Cells[7].Text = "等待审核"; break;
case "6": e.Row.Cells[7].Text = "<a href='HR_AddIntojobs.aspx?UserId=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>审核并入职</a>"; break;
case "10": e.Row.Cells[7].Text = "<a href='HR_AddIntojobs.aspx?UserId=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>员工档案</a><a href='HR_AddTransferKong.aspx?type=1&UserId=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>调岗</a><a href='HR_Official.aspx?UserID=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>转正</a><a href='HR_Leavejobs2.aspx?UserID=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>离职</a>"; break;
case "20":
{
e.Row.Cells[7].Text = "<a href='HR_AddTransferKong.aspx?type=1&UserId=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>调岗</a><a href='HR_AddTransferKong.aspx?type=2&UserID=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>升职</a><a href='HR_Userjobs.aspx?UserId=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>加/撤职</a><a href='HR_Leavejobs2.aspx?UserID=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>离职</a>";
ULCode.QDA.XDataTable xdt = ULCode.QDA.XSql.GetXDataTable("select te.Name from TU_User_X_DutyDetail tuxd left join TE_DutyDetail te on tuxd.DutyDetailID=te.ID where tuxd.UserID='" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'");
string str = xdt.ToColValueList("，+", 0);
if (str != "")
{
e.Row.Cells[5].Text += "，+" + str;
}
break;
}
//case "30": e.Row.Cells[7].Text = "<a href='HR_AddTransferKong.aspx?type=1&uid=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>调岗</a> <a href='HR_AddTransferKong.aspx?type=2&uid=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>升职</a> <a href='HR_Leavejobs.aspx?uid=" + Gv_intojobs.DataKeys[e.Row.RowIndex].Value + "'>离职</a>"; break;
case "40": e.Row.Cells[7].Text = "离职中。。。"; break;
default: break;
}
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ULCode.QDA.XDataTable xdt = ULCode.QDA.XSql.GetXDataTable("select pu.UserID,te.RealName from PRO_User pu left join TU_Users te on pu.UserID=te.UserID where pu.type=1 and pid=" + e.Row.Cells[4].Text);
e.Row.Cells[4].Text = xdt.ToColValueList("，", 1);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
WX.PRO.Project.MODEL model = WX.PRO.Project.GetModel("select * from PRO_Projects where ID=" + WX.Request.rProjectId);
if (model != null)
{
li_name.Text = model.ProjectName.ToString();
ui_Name.Text = model.ProjectName.ToString();
li_days.Text = model.Days.ToString();
ui_days.Text = model.Days.ToString();
if (Convert.ToInt32(model.Persons.ToString()) > 0)
{
ULCode.QDA.XDataTable xdt = ULCode.QDA.XSql.GetXDataTable("select pu.UserID,te.RealName from PRO_User pu left join TU_Users te on pu.UserID=te.UserID where pu.type=1 and pid=" + model.ID.ToString());
li_persons.Text = xdt.ToColValueList("，", 1);
ui_Persons.Value = xdt.ToColValueList(",", 0);
liu_Persons.Text = xdt.ToColValueList(",", 1);
}
li_fee.Text = model.Fee.ToString();
ui_fee.Text = model.Fee.ToString();
li_content.Text = model.Content.ToString();
li_Imagine.Text = model.Imagine.ToString();
li_state.Text = WX.PRO.Project.statearray[Convert.ToInt32(model.State.ToString())];
if (model.Annex.ToString() != "")
{
li_annex.Text = "<a href='" + model.Annex.ToString() + "'>" + model.Annex.ToString() + "</a>";
}
if (model.State.ToString() == "1" || model.State.ToString() == "0")
{
tr1.Visible = false;
tr2.Visible = false;
checkdata.Visible = model.State.ToString() != "0";
}
else
{
WX.PRO.State.MODEL statemodel = WX.PRO.State.GetModel("select * from PRO_State where ProjID=" + model.ID.ToString());
if (statemodel.ProcID.ToString() != "" && statemodel.ProcID.ToString() != "0")
{
//WX.PRO.Process.MODEL procmodel = WX.PRO.Process.GetModel("select top 1 * from PRO_Process where ProjID=" + statemodel.ProjID.ToString() + " and NO="+statemodel.ProcID.ToString());
hivalue = statemodel.ProcID.ToString();
}
li_projmanage.Text = WX.CommonUtils.GetRealNameListByUserIdList(statemodel.Manage.ToString());
li_checkfee.Text = statemodel.Fee.ToString();
li_checkmanage.Text = WX.CommonUtils.GetRealNameListByUserIdList(model.Manage.ToString());
li_checkopinion.Text = model.Opinion.ToString();
li_checktime.Text = Convert.ToDateTime(model.Stime.value).ToString("yyyy-MM-dd HH:mm:ss");
checkdata.Visible = false;
}
}
ReBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//1.验证当前用户页面权限
if (!this.Master.A_Edit)
{
Response.Write("你没有权限访问此功能！");
Response.End();
return;
}
if (!IsPostBack)
{
if (Request["id"] != null)
{
WX.PRO.Project.MODEL model = WX.PRO.Project.GetModel("select * from PRO_Projects where ID=" + Request["id"]);
if (model != null)
{
ui_Name.Text = model.ProjectName.ToString();
ui_days.Text = model.Days.ToString();
if (Convert.ToInt32(model.Persons.ToString()) > 0)
{
ULCode.QDA.XDataTable xdt = ULCode.QDA.XSql.GetXDataTable("select pu.UserID,te.RealName from PRO_User pu left join TU_Users te on pu.UserID=te.UserID where pu.type=1 and pid=" + model.ID.ToString());
ui_Persons.Value = xdt.ToColValueList(",", 0);
li_Persons.Text = xdt.ToColValueList(",", 1);
}
//ui_Persons.Value = model.Persons.ToString();
ui_fee.Text = model.Fee.ToString();
ui_content.Value = model.Content.ToString();
ui_Imagine.Text = model.Imagine.ToString();
if (model.Annex.ToString() != "")
{
li_annex.Text = "<a href='" + model.Annex.ToString() + "'>" + model.Annex.ToString() + "</a> <br/>";
}
if (ULCode.QDA.XSql.GetDataTable("select ID from PRO_Process where ProjID=" + model.ID.ToString()).Rows.Count > 0)
{
Button2.Visible = true;
}
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
WX.HR.DutyLog.MODEL log = WX.HR.DutyLog.NewDataModel();
string userId = WX.Request.rUserId;
WX.HR.TransferKong.MODEL tfk = WX.HR.TransferKong.NewDataModel();
WX.Model.User.MODEL usermodel = WX.Request.rUser;
tfk.Addtime.value = DateTime.Now;
tfk.UserID.value = userId;
tfk.BackDutyID.value = ui_duty.SelectedValue;
tfk.BackDempID.value = ui_demp.SelectedValue;
tfk.NowDutyID.value = ui_duty2.SelectedValue;
tfk.NowDempID.value = ui_demp2.SelectedValue;
tfk.BackGrade.value = DropDownList1.SelectedValue;
tfk.NowGrade.value = DropDownList2.SelectedValue;
tfk.dempOpinion.value = ui_dempop.Text;
tfk.dempManager.value = ui_dempuser.Value;
tfk.hrOpinion.value = ui_hrop.Text;
tfk.hrManager.value = ui_hruser.Value;
tfk.bossOpinion.value = ui_bossop.Text;
tfk.bossManager.value = ui_bossuser.Value;
tfk.type.value = Request["type"] == "1" ? 1 : 2;
int tfkid = tfk.Insert(true);
log.Content.value = "员工" + (tfk.type.ToString() == "1" ? "调岗" : "升职");
WX.Model.DutyDetail.MODEL dutydetail = WX.Model.DutyDetail.GetModel(Convert.ToInt32(ui_duty2.SelectedValue));
usermodel.Grade.value = dutydetail.GradeID.value;
usermodel.DepartmentID.value = ui_demp2.SelectedValue;
usermodel.DutyId.value = ui_duty2.SelectedValue;
usermodel.Grade.value = DropDownList2.SelectedValue;
usermodel.Update();
WX.Model.DutyDetail.MODEL dutydetailback = WX.Model.DutyDetail.GetModel(Convert.ToInt32(ui_duty.SelectedValue));
ULCode.QDA.XDataTable xdt = ULCode.QDA.XSql.GetXDataTable("select RealName from TU_Users where DutyId=" + dutydetailback.ID.ToString() + " and State>6 and State<40");
dutydetailback.UsersName.value = xdt.ToColValueList(",", 0);
if (dutydetailback.UsersName.ToString() != "")
{
dutydetailback.Update();
}
xdt = ULCode.QDA.XSql.GetXDataTable("select RealName from TU_Users where DutyId=" + dutydetail.ID.ToString() + " and State>6 and State<40");
dutydetail.UsersName.value = xdt.ToColValueList(",", 0);
if (dutydetail.UsersName.ToString() != "")
{
ULCode.QDA.XSql.Execute("update TE_DutyDetail set UsersName=replace(UsersName,'" + usermodel.RealName.ToString() + ",','')");
dutydetail.UsersName.value = dutydetail.UsersName.ToString() + ",";
dutydetail.Update();
}
//日志
log.UserID.value = userId;
log.BackDutyID.value = ui_duty.SelectedValue;
log.BackDempID.value = ui_demp.SelectedValue;
log.NowDutyID.value = ui_duty2.SelectedValue;
log.NowDempID.value = ui_demp2.SelectedValue;
log.Backtableid.value = tfk.type.ToString() == "1" ? 2 : 3;
log.Backcolumid.value = tfkid;
log.Starttime.value = DateTime.Now;
log.GradeID.value = usermodel.Grade.value;
WX.HR.DutyLog.MODEL backlog = WX.HR.DutyLog.GetModel("select top 1 * from HR_DutyLogs where UserID='" + userId + "' order by Starttime desc");
if (backlog != null)
{
backlog.stoptime.value = DateTime.Now;
backlog.Nowtableid.value = tfk.type.ToString() == "1" ? 2 : 3;
backlog.Nowcolumid.value = tfkid;
backlog.Update();
}
log.Insert();
Response.Redirect("HR_Intojobs.aspx?state=20");
}
protected void Page_Load(object sender, EventArgs e)
{
WX.Main.CurUser.LoadDutyDetailUser();
string sql = "select cc.ID,ContactName,BabySex,cc.CustomerID,CustomerName from CRM_Contact cc inner join CRM_Customers ccu on cc.CustomerID=ccu.ID left join Tu_Users tu on ccu.EmployeeID=tu.UserID where datediff(day,BabyBirthday,getdate())=0 and (BabySex='男' or BabySex='女')" + (WX.Main.CurUser.DutyDetailUser.DutyID.ToInt32() >= 900 ? "" : " and tu.DepartmentID=" + WX.Main.CurUser.UserModel.DepartmentID.ToString());
DataTable dt = ULCode.QDA.XSql.GetDataTable(sql);
int no = 1;
for (int i = 0; i < dt.Rows.Count; i++)
{
tablestr += "<tr><th style=\"width: 30px;\"></th><td> " + no + "、" + dt.Rows[i]["CustomerName"] + dt.Rows[i]["ContactName"] + (dt.Rows[i]["BabySex"].ToString() == "男" ? "儿子" : "女儿") + "今天生日！</td><td class=\"manage\" style=\"width: 100px;\"><a href=\"Crm_Single_AddContact.aspx?PageMode=my&Action=Edit&&ContactID=" + dt.Rows[i]["ID"] + "&CustomerID=" + dt.Rows[i]["CustomerID"] + "\">维护</a></td></tr>";
no++;
}
sql = "select ct.ID,ct.ProcessState,cc.CustomerID CustomerNo,cc.CustomerName from CRM_Track ct left join CRM_Customers cc on ct.CustomerID=cc.ID left join Tu_Users tu on cc.EmployeeID=tu.UserID where datediff(day,TrackTime,getdate())=0 and ct.State=0" + (WX.Main.CurUser.DutyDetailUser.DutyID.ToInt32() >= 900 ? "" : " and tu.DepartmentID=" + WX.Main.CurUser.UserModel.DepartmentID.ToString());
DataTable dt2 = ULCode.QDA.XSql.GetDataTable(sql);
for (int i = 0; i < dt2.Rows.Count; i++)
{
tablestr += "<tr><th style=\"width: 30px;\"></th><td> " + no + "、" + dt2.Rows[i]["CustomerName"] + "今日应该" + WX.CRM.Track.ProcessState[Convert.ToInt32(dt2.Rows[i]["ProcessState"])] + "！</td><td class=\"manage\" style=\"width: 100px;\"><a href=\"javascript:PopupIFrame('CRM_SingleM_EditTrack.aspx?TrackID=" + dt2.Rows[i]["ID"] + "','提交跟踪信息','','',700,450)\">维护</a></td></tr>";
no++;
}
string ids = WX.Main.GetUserDeptids(WX.Main.CurUser.UserID);
WX.Main.CurUser.LoadMyDepartment();
DataTable dtcount = ULCode.QDA.XSql.GetDataTable("exec " + (WX.CommonUtils.GetBossUserID == WX.Main.CurUser.UserID || WX.Main.CurUser.MyDepartMent.ID.ToString() == System.Configuration.ConfigurationManager.AppSettings["Dept_CA"] ? "Get_CRM_ManagerLDTongji" : "Get_CRM_ManagerTongji2 '" + (ids != "" ? ids : WX.Main.CurUser.UserModel.DepartmentID.ToString()) + "'"));
limycount.Text = dtcount.Rows[0]["mycount"].ToString();
limyTempcount.Text = dtcount.Rows[0]["myTempcount"].ToString();
sql = "SELECT case CustomerZJM when '' then CustomerName else CustomerZJM end CustomerName FROM CRM_CustomersTemp C left join TU_Users tu on C.EmployeeID=tu.UserID where C.State>-1" + (WX.Main.CurUser.DutyDetailUser.DutyID.ToInt32() >= 900 ? "" : " and tu.DepartmentID=" + WX.Main.CurUser.UserModel.DepartmentID.ToString())
+ " union all "
+ " SELECT case CustomerZJM when '' then CustomerName else CustomerZJM end CustomerName FROM CRM_ContactTemp as cctemp left join CRM_Customers AS C on cctemp.CustomerID=C.ID left join TU_Users tu on C.EmployeeID=tu.UserID"
+ " where cctemp.CheckState>-1" + (WX.Main.CurUser.UserID == WX.CommonUtils.GetBossUserID ? "" : " and tu.DepartmentID=" + WX.Main.CurUser.UserModel.DepartmentID.ToString());
ULCode.QDA.XDataTable tempdt = ULCode.QDA.XSql.GetXDataTable(sql);
Literal1.Text = tempdt.ToColValueList("，", 0);
Literal3.Text = dtcount.Rows[0]["myGTcount"].ToString();
DataTable gtdt = ULCode.QDA.XSql.GetDataTable("select top 10 case CustomerZJM when '' then CustomerName else CustomerZJM end CustomerName,cc.ID from CRM_Customers cc" + (WX.Main.CurUser.UserID != WX.CommonUtils.GetBossUserID ? " left join Tu_Users tu on cc.EmployeeID=tu.UserID where cc.State>0 and tu.DepartmentID in(" + (ids != "" ? ids : WX.Main.CurUser.UserModel.DepartmentID.ToString()) + ") and StageID<2" : " where cc.State>0 and StageID<2 "));
//Literal4.Text = gtdt.ToColValueList("，", 0);
Literal4.Text = this.GetCustomerNames(gtdt);
Literal6.Text = dtcount.Rows[0]["myGZcount"].ToString();
DataTable gzdt = ULCode.QDA.XSql.GetDataTable("select top 10 case CustomerZJM when '' then CustomerName else CustomerZJM end CustomerName,cc.ID from CRM_Customers cc" + (WX.Main.CurUser.UserID != WX.CommonUtils.GetBossUserID ? " left join Tu_Users tu on cc.EmployeeID=tu.UserID where cc.State>0 and tu.DepartmentID in(" + (ids != "" ? ids : WX.Main.CurUser.UserModel.DepartmentID.ToString()) + ") and StageID=2" : " where cc.State>0 and StageID=2 "));
Literal7.Text = this.GetCustomerNames(gzdt);
Literal9.Text = dtcount.Rows[0]["myQYcount"].ToString();
DataTable qydt = ULCode.QDA.XSql.GetDataTable("select top 10 case CustomerZJM when '' then CustomerName else CustomerZJM end CustomerName,cc.ID from CRM_Customers cc" + (WX.Main.CurUser.UserID != WX.CommonUtils.GetBossUserID ? " left join Tu_Users tu on cc.EmployeeID=tu.UserID where cc.State>0 and tu.DepartmentID in(" + (ids != "" ? ids : WX.Main.CurUser.UserModel.DepartmentID.ToString()) + ") and StageID=3" : " where cc.State>0 and StageID=3 "));
Literal10.Text = this.GetCustomerNames(qydt);
Literal12.Text = dtcount.Rows[0]["myWHcount"].ToString();
DataTable whdt = ULCode.QDA.XSql.GetDataTable("select top 10 case CustomerZJM when '' then CustomerName else CustomerZJM end CustomerName,cc.ID from CRM_Customers cc" + (WX.Main.CurUser.UserID != WX.CommonUtils.GetBossUserID ? " left join Tu_Users tu on cc.EmployeeID=tu.UserID where cc.State>0 and tu.DepartmentID in(" + (ids != "" ? ids : WX.Main.CurUser.UserModel.DepartmentID.ToString()) + ") and StageID=4" : " where cc.State>0 and StageID=4 "));
Literal13.Text = this.GetCustomerNames(whdt);
Literal15.Text = dtcount.Rows[0]["cmpmonthcount"].ToString();
Literal16.Text = dtcount.Rows[0]["deptmonthcount"].ToString();
Literal18.Text = dtcount.Rows[0]["cmpmonthQYcount"].ToString();
Literal19.Text = dtcount.Rows[0]["deptmonthQYcount"].ToString();
Literal21.Text = dtcount.Rows[0]["cmpmonthGZcount"].ToString();
Literal22.Text = dtcount.Rows[0]["deptmonthGZcount"].ToString();
Literal24.Text = dtcount.Rows[0]["cmpmonthTrackcount"].ToString();
Literal25.Text = dtcount.Rows[0]["deptmonthTrackcount"].ToString();
Literal27.Text = string.Format("{0:C2}", dtcount.Rows[0]["cmpmonthTrackfee"]);
Literal28.Text = string.Format("{0:C2}", dtcount.Rows[0]["deptmonthTrackfee"]);
Literal30.Text = dtcount.Rows[0]["cmpyearcount"].ToString();
Literal35.Text = dtcount.Rows[0]["deptyearcount"].ToString();
Literal31.Text = dtcount.Rows[0]["cmpyearQYcount"].ToString();
Literal36.Text = dtcount.Rows[0]["deptyearQYcount"].ToString();
Literal32.Text = dtcount.Rows[0]["cmpyearGZcount"].ToString();
Literal37.Text = dtcount.Rows[0]["deptyearGZcount"].ToString();
Literal33.Text = dtcount.Rows[0]["cmpyearTrackcount"].ToString();
Literal38.Text = dtcount.Rows[0]["deptyearTrackcount"].ToString();
Literal34.Text = string.Format("{0:C2}", dtcount.Rows[0]["cmpyearTrackfee"]);
Literal39.Text = string.Format("{0:C2}", dtcount.Rows[0]["deptyearTrackfee"]);
if (WX.Main.CurUser.DutyDetailUser.DutyID.ToInt32() >= 900)
{
monthdiv.Visible = false;
yeardiv.Visible = false;
}
DataTable categorydt = ULCode.QDA.XSql.GetDataTable("select CategoryID,count(CategoryID) count,max(CategoryName) cname from CRM_Customers cc left join CRM_InnerCategory cic on cc.CategoryID=cic.ID where EmployeeID='" + WX.Main.CurUser.UserID + "' and CategoryID is not null group by CategoryID ");
for (int i = 0; i < categorydt.Rows.Count; i++)
{
Literal45.Text += (i > 0 ? "，" : "") + categorydt.Rows[i]["cname"] + categorydt.Rows[i]["count"] + "个";
}
DataTable Naturedt = ULCode.QDA.XSql.GetDataTable("select NatureID,count(NatureID) count,max(CompanyNature) cname from CRM_Customers cc left join CRM_CompanyNature cin on cc.NatureID=cin.ID where EmployeeID='" + WX.Main.CurUser.UserID + "' and NatureID is not null group by NatureID");
for (int i = 0; i < Naturedt.Rows.Count; i++)
{
Literal46.Text += (i > 0 ? "，" : "") + Naturedt.Rows[i]["cname"] + Naturedt.Rows[i]["count"] + "个";
}
DataTable Sourcedt = ULCode.QDA.XSql.GetDataTable("select SourceID,count(SourceID) count,max(SourceName) cname from CRM_Customers cc left join CRM_Source cs on cc.SourceID=cs.ID where EmployeeID='" + WX.Main.CurUser.UserID + "' and SourceID is not null group by SourceID ");
for (int i = 0; i < Sourcedt.Rows.Count; i++)
{
Literal47.Text += (i > 0 ? "，" : "") + Sourcedt.Rows[i]["cname"] + Sourcedt.Rows[i]["count"] + "个";
}
DataTable Industrydt = ULCode.QDA.XSql.GetDataTable("select IndustryID,count(IndustryID) count,max(IndustryName) cname from CRM_Customers cc left join CRM_Industry ci on cc.IndustryID=ci.ID where EmployeeID='" + WX.Main.CurUser.UserID + "' and IndustryID is not null group by IndustryID");
for (int i = 0; i < Industrydt.Rows.Count; i++)
{
Literal48.Text += (i > 0 ? "，" : "") + Industrydt.Rows[i]["cname"] + Industrydt.Rows[i]["count"] + "个";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//1.validate user data
string userId = WX.Request.rUserId;
//2.入职手续
WX.HR.IntoJob.MODEL intojob = WX.HR.IntoJob.NewDataModel();
intojob.UserID.value = userId;
intojob.Addtime.value = DateTime.Now;
try
{
intojob.Addtime.value = ui_addtime.Text.Trim();
}
catch { }
intojob.jobsname.value = ui_jobname.SelectedValue;
intojob.deptid.value = ddlDepartment.SelectedValue;
intojob.salary.value = DropDownList1.SelectedValue;
intojob.PSalary.value = DropDownList2.SelectedValue;
intojob.dempOpinion.value = ui_content.Text + "(" + DateTime.Now + ")";
//intojob.GradeID.value = ui_grade.SelectedValue;
intojob.SignUserID.value = WX.Main.CurUser.UserID;
int jobid = intojob.Insert(true);
WX.Model.User.MODEL usermodel = WX.Request.rUser;
WX.Model.DutyDetail.MODEL dutydetail = WX.Model.DutyDetail.GetModel(Convert.ToInt32(ui_jobname.SelectedValue));
//3.更新用户职务状态
usermodel.State.value = 10;
usermodel.CompanyID.value = WX.Main.DefaultCompanyId;
usermodel.DepartmentID.set(ddlDepartment.SelectedValue);
usermodel.DutyId.set(ui_jobname.SelectedValue);
usermodel.ArchiveBySelf.value = 0;
usermodel.Grade.value = DropDownList1.SelectedValue;
usermodel.Update();
WX.Main.ExcuteUpdate("aspnet_Membership", "IsLockedOut=0", "UserID='" + usermodel.UserID.ToString() + "'");
ULCode.QDA.XDataTable xdt = ULCode.QDA.XSql.GetXDataTable("select RealName from TU_Users where DutyId=" + dutydetail.ID.ToString() + " and State>6 and State<40");
dutydetail.UsersName.value = xdt.ToColValueList(",", 0);
if (dutydetail.UsersName.ToString() != "")
{
dutydetail.UsersName.value = dutydetail.UsersName.ToString() + ",";
dutydetail.Update();
}
//4.入职日志
WX.HR.DutyLog.MODEL log = WX.HR.DutyLog.NewDataModel();
log.UserID.value = userId;
log.NowDutyID.value = usermodel.DutyId.value;
log.NowDempID.value = usermodel.DepartmentID.value;
log.Backtableid.value = 0;
log.Backcolumid.value = jobid;
log.Starttime.value = DateTime.Now;
log.GradeID.value = dutydetail.GradeID.value;
log.Content.value = "新员工入职";
WX.HR.DutyLog.MODEL backlog = WX.HR.DutyLog.GetModel("select top 1 * from HR_DutyLogs where UserID='" + userId + "' order by Starttime desc");
if (backlog != null)
{
backlog.stoptime.value = DateTime.Now;
backlog.Nowtableid.value = 0;
backlog.Nowcolumid.value = jobid;
backlog.Update();
}
log.Insert();
//办理完入职1、向部门发送人员入职通知
WX.Main.MessageSend(usermodel.RealName.ToString() + "已办理入职，" + WX.CommonUtils.GetDeptNameListByDeptIdList(usermodel.DepartmentID.ToString()) + "接收——入职通知", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetDeptUserID(1, "[Host]", usermodel.DepartmentID.ToInt32()), WX.Main.CurUser.UserID, 8, 0);
//2、向人资发送入职通知并提醒签合同、办保险
WX.Main.MessageSend(usermodel.RealName.ToString() + "已办理入职——入职通知", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetHRUserID, WX.Main.CurUser.UserID, 8, 0);
//3、向综管发送通知提示配备办公用品
WX.Main.MessageSend("<a href=/Manage/Assets/Ass_AddConsuming.aspx?UserID=" + usermodel.UserID.ToString() + "&mes=1>" + WX.CommonUtils.GetDeptNameListByDeptIdList(usermodel.DepartmentID.ToString()) + "新来同事" + usermodel.RealName.ToString() + "，请配备办公用品——入职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetCAUserID, WX.Main.CurUser.UserID, 8, 0);
//4、向财务发送通知提示办理工资卡
WX.Main.MessageSend("<a href=/Manage/Finance/FD_NewUserList.aspx?mes=1>" + WX.CommonUtils.GetDeptNameListByDeptIdList(usermodel.DepartmentID.ToString()) + "新来同事" + usermodel.RealName.ToString() + "，请办理工资卡等相关工作——入职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetFDUserID, WX.Main.CurUser.UserID, 8, 0);
//5、向入职人员发送入职办理清单
WX.Main.MessageSend("<a href=/Manage/Private/IntoJobList.aspx?mes=1>欢迎加入我行大家庭！入职相关事宜请查看新人入职附表——入职通知</a>", "/Manage/Main/messagelist.aspx", usermodel.UserID.ToString(), WX.Main.CurUser.UserID, 8, 0);
Response.Redirect("HR_Intojobs.aspx?state=10");
}
protected void Page_Load(object sender, EventArgs e)
{
this.LoadHelperInfo();
DataTable dtcount = ULCode.QDA.XSql.GetDataTable("exec Get_CRM_Tongji '" + WX.Main.CurUser.UserID + "'," + WX.Main.CurUser.UserModel.DepartmentID.ToInt32());
limycount.Text = dtcount.Rows[0]["mycount"].ToString();
limyTempcount.Text = dtcount.Rows[0]["myTempcount"].ToString();
string sql = "SELECT case CustomerZJM when '' then CustomerName else CustomerZJM end CustomerName FROM CRM_CustomersTemp where State>-1 and EmployeeID='" + WX.Main.CurUser.UserID + "'"
+ " union all "
+ " SELECT case CustomerZJM when '' then CustomerName else CustomerZJM end CustomerName FROM CRM_ContactTemp as cctemp left join CRM_Customers AS C on cctemp.CustomerID=C.ID "
+ " where cctemp.CheckState>-1 and C.EmployeeID='" + WX.Main.CurUser.UserID + "'";
ULCode.QDA.XDataTable tempdt = ULCode.QDA.XSql.GetXDataTable(sql);
Literal1.Text = tempdt.ToColValueList("，", 0);
Literal3.Text = dtcount.Rows[0]["myGTcount"].ToString();
DataTable gtdt = ULCode.QDA.XSql.GetDataTable("select top 10 CustomerZJM CustomerName,ID from CRM_Customers where EmployeeID='" + WX.Main.CurUser.UserID + "' and StageID<2 and State>0");
Literal4.Text = this.GetCustomerNames(gtdt);
Literal6.Text = dtcount.Rows[0]["myGZcount"].ToString();
DataTable gzdt = ULCode.QDA.XSql.GetDataTable("select top 10 CustomerZJM CustomerName,ID from CRM_Customers where EmployeeID='" + WX.Main.CurUser.UserID + "' and StageID=2 and State>0");
Literal7.Text = this.GetCustomerNames(gzdt);
Literal9.Text = dtcount.Rows[0]["myQYcount"].ToString();
DataTable qydt = ULCode.QDA.XSql.GetDataTable("select top 10 CustomerZJM CustomerName,ID from CRM_Customers where EmployeeID='" + WX.Main.CurUser.UserID + "' and StageID=3 and State>0");
Literal10.Text = this.GetCustomerNames(qydt);
Literal12.Text = dtcount.Rows[0]["myWHcount"].ToString();
DataTable whdt = ULCode.QDA.XSql.GetDataTable("select top 10 CustomerZJM CustomerName,ID from CRM_Customers where EmployeeID='" + WX.Main.CurUser.UserID + "' and StageID=4 and State>0");
Literal13.Text = this.GetCustomerNames(whdt);
Literal15.Text = dtcount.Rows[0]["cmpmonthcount"].ToString();
Literal16.Text = dtcount.Rows[0]["deptmonthcount"].ToString();
Literal17.Text = dtcount.Rows[0]["mymonthcount"].ToString();
Literal18.Text = dtcount.Rows[0]["cmpmonthQYcount"].ToString();
Literal19.Text = dtcount.Rows[0]["deptmonthQYcount"].ToString();
Literal20.Text = dtcount.Rows[0]["mymonthQYcount"].ToString();
Literal21.Text = dtcount.Rows[0]["cmpmonthGZcount"].ToString();
Literal22.Text = dtcount.Rows[0]["deptmonthGZcount"].ToString();
Literal23.Text = dtcount.Rows[0]["mymonthGZcount"].ToString();
Literal24.Text = dtcount.Rows[0]["cmpmonthTrackcount"].ToString();
Literal25.Text = dtcount.Rows[0]["deptmonthTrackcount"].ToString();
Literal26.Text = dtcount.Rows[0]["mymonthTrackcount"].ToString();
Literal27.Text = string.Format("{0:C2}", dtcount.Rows[0]["cmpmonthTrackfee"]);
Literal28.Text = string.Format("{0:C2}", dtcount.Rows[0]["deptmonthTrackfee"]);
Literal29.Text = string.Format("{0:C2}", dtcount.Rows[0]["mymonthTrackfee"]);
Literal30.Text = dtcount.Rows[0]["cmpyearcount"].ToString();
Literal35.Text = dtcount.Rows[0]["deptyearcount"].ToString();
Literal40.Text = dtcount.Rows[0]["myyearcount"].ToString();
Literal31.Text = dtcount.Rows[0]["cmpyearQYcount"].ToString();
Literal36.Text = dtcount.Rows[0]["deptyearQYcount"].ToString();
Literal41.Text = dtcount.Rows[0]["myyearQYcount"].ToString();
Literal32.Text = dtcount.Rows[0]["cmpyearGZcount"].ToString();
Literal37.Text = dtcount.Rows[0]["deptyearGZcount"].ToString();
Literal42.Text = dtcount.Rows[0]["myyearGZcount"].ToString();
Literal33.Text = dtcount.Rows[0]["cmpyearTrackcount"].ToString();
Literal38.Text = dtcount.Rows[0]["deptyearTrackcount"].ToString();
Literal43.Text = dtcount.Rows[0]["myyearTrackcount"].ToString();
Literal34.Text = string.Format("{0:C2}", dtcount.Rows[0]["cmpyearTrackfee"]);
Literal39.Text = string.Format("{0:C2}", dtcount.Rows[0]["deptyearTrackfee"]);
Literal44.Text = string.Format("{0:C2}", dtcount.Rows[0]["myyearTrackfee"]);
DataTable categorydt = ULCode.QDA.XSql.GetDataTable("select CategoryID,count(CategoryID) count,max(CategoryName) cname from CRM_Customers cc left join CRM_InnerCategory cic on cc.CategoryID=cic.ID where EmployeeID='" + WX.Main.CurUser.UserID + "' and CategoryID is not null group by CategoryID ");
for (int i = 0; i < categorydt.Rows.Count; i++)
{
Literal45.Text += (i > 0?"，":"") + categorydt.Rows[i]["cname"] + categorydt.Rows[i]["count"] + "个";
}
DataTable Naturedt = ULCode.QDA.XSql.GetDataTable("select NatureID,count(NatureID) count,max(CompanyNature) cname from CRM_Customers cc left join CRM_CompanyNature cin on cc.NatureID=cin.ID where EmployeeID='" + WX.Main.CurUser.UserID + "' and NatureID is not null group by NatureID");
for (int i = 0; i < Naturedt.Rows.Count; i++)
{
Literal46.Text += (i > 0 ? "，" : "") + Naturedt.Rows[i]["cname"] + Naturedt.Rows[i]["count"] + "个";
}
DataTable Sourcedt = ULCode.QDA.XSql.GetDataTable("select SourceID,count(SourceID) count,max(SourceName) cname from CRM_Customers cc left join CRM_Source cs on cc.SourceID=cs.ID where EmployeeID='" + WX.Main.CurUser.UserID + "' and SourceID is not null group by SourceID ");
for (int i = 0; i < Sourcedt.Rows.Count; i++)
{
Literal47.Text += (i > 0 ? "，" : "") + Sourcedt.Rows[i]["cname"] + Sourcedt.Rows[i]["count"] + "个";
}
DataTable Industrydt = ULCode.QDA.XSql.GetDataTable("select IndustryID,count(IndustryID) count,max(IndustryName) cname from CRM_Customers cc left join CRM_Industry ci on cc.IndustryID=ci.ID where EmployeeID='" + WX.Main.CurUser.UserID + "' and IndustryID is not null group by IndustryID");
for (int i = 0; i < Industrydt.Rows.Count; i++)
{
Literal48.Text += (i > 0 ? "，" : "") + Industrydt.Rows[i]["cname"] + Industrydt.Rows[i]["count"] + "个";
}
}
