public static string LoadEmpNameSQL(Util_EmpNameDataBean model)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("select Top 1 P.CompID,C.CompName ");
sb.AppendLine(",P.EmpID,P.NameN as EmpNameN ");
sb.AppendLine(",P.DeptID,Dpt.OrganName as DeptName ");
sb.AppendLine(",P.OrganID,Org.OrganName ");
sb.AppendLine(",WW.WorkTypeID,WW.Remark as WorkType ");
sb.AppendLine(",PP.PositionID,PP.Remark as Position ");
sb.AppendLine(",OrgF.OrganID as FlowOrganID,Org.OrganName as FlowOrganName ");
sb.AppendLine(",P.TitleID,T.TitleName ");
sb.AppendLine("from dbo.Personal P ");
sb.AppendLine("left join dbo.EmpFlow EF on P.CompID=EF.CompID and P.EmpID=EF.EmpID ");
sb.AppendLine("left join dbo.OrganizationFlow OrgF on EF.OrganID=OrgF.OrganID ");
sb.AppendLine("left join dbo.EmpWorkType EW on P.CompID=EW.CompID and P.EmpID=EW.EmpID and EW.PrincipalFlag='1' ");
sb.AppendLine("left join dbo.WorkType WW on EW.CompID=WW.CompID and EW.WorkTypeID=WW.WorkTypeID ");
sb.AppendLine("left join dbo.EmpPosition EP on P.CompID=EP.CompID and P.EmpID=EP.EmpID and EP.PrincipalFlag='1' ");
sb.AppendLine("left join dbo.Position PP on EP.CompID=PP.CompID and EP.PositionID=PP.PositionID ");
sb.AppendLine("left join dbo.Company C on P.CompID=C.CompID ");
sb.AppendLine("left join dbo.Organization Dpt on P.CompID=Dpt.CompID and P.DeptID=Dpt.OrganID ");
sb.AppendLine("left join dbo.Organization Org on P.CompID=Org.CompID and P.OrganID=Org.OrganID ");
sb.AppendLine("left join dbo.Title T on P.CompID=T.CompID and P.TitleID=T.TitleID and P.RankID=T.RankID ");
sb.AppendLine("where P.WorkStatus='1' and P.CompID =@CompID and P.EmpID=@EmpID ");
if (!string.IsNullOrEmpty(model.outEmpID))
{
sb.AppendLine("and P.EmpID!=@outEmpID");
}
return(sb.ToString());
}
public static bool LoadEmpName(Util_EmpNameDataBean model, out List <Util_EmpNameDataBean> datas, out string msg)
{
bool result = false;
msg = "";
datas = new List <Util_EmpNameDataBean>();
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_eHRMSDB_ITRD).ConnectionString
})
{
try
{
datas = conn.Query <Util_EmpNameDataBean>(LoadEmpNameSQL(model), model).ToList();
}
catch (Exception)
{
throw;
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}
protected void txtEmpID_TextChanged(object sender, EventArgs e)
{
var isSuccess = false;
var msg = "";
var EmpNameDataLists = new List <Util_EmpNameDataBean>();
var EmpNameData = new Util_EmpNameDataBean();
EmpNameData.CompID = string.IsNullOrEmpty(selectCompID)? UserInfo.getUserInfo().CompID:selectCompID;
EmpNameData.EmpID = ViewState["EmpID"].ToString().Trim();
EmpNameData.outEmpID = selectOutEmpID;
isSuccess = LoadEmpName(EmpNameData, out EmpNameDataLists, out msg);
if (isSuccess && EmpNameDataLists != null && EmpNameDataLists.Count > 0)
{
reCompID = EmpNameDataLists[0].CompID;
reCompName = EmpNameDataLists[0].CompName;
reEmpID = EmpNameDataLists[0].EmpID;
reEmpNameN = EmpNameDataLists[0].EmpNameN;
reDeptID = EmpNameDataLists[0].DeptID;
reDeptName = EmpNameDataLists[0].DeptName;
reOrganID = EmpNameDataLists[0].OrganID;
reOrganName = EmpNameDataLists[0].OrganName;
reWorkTypeID = EmpNameDataLists[0].WorkTypeID;
reWorkType = EmpNameDataLists[0].WorkType;
reFlowOrganID = EmpNameDataLists[0].FlowOrganID;
reFlowOrganName = EmpNameDataLists[0].FlowOrganName;
reTitleID = EmpNameDataLists[0].TitleID;
reTitleName = EmpNameDataLists[0].TitleName;
rePositionID = EmpNameDataLists[0].PositionID;
rePosition = EmpNameDataLists[0].Position;
}
else
{
reCompID = "";
reCompName = "";
reEmpID = "";
reEmpNameN = "";
reDeptID = "";
reDeptName = "";
reOrganID = "";
reOrganName = "";
reWorkTypeID = "";
reWorkType = "";
reFlowOrganID = "";
reFlowOrganName = "";
reTitleID = "";
reTitleName = "";
rePositionID = "";
rePosition = "";
}
}
