/// <summary>
/// GetEmpFlowSNEmpAndSex
/// </summary>
/// <param name="dataBean">data</param>
/// <param name="sb">傳入之前組好Command</param>
/// <param name="isReset">StringBuilder Reset or not</param>
public static void GetEmpFlowSNEmpAndSexSql(TemplateBean dataBean, ref StringBuilder sb, bool isReset = false)
{
if (isReset)
{
sb = new StringBuilder();
}
sb.Append(" SELECT ");
sb.Append(" EFSN.CompID, EFSN.EmpID ");
sb.Append(" ,P.NameN, P.Sex ");
sb.Append(" FROM EmpFlowSN AS EFSN ");
sb.Append(" LEFT JOIN " + _eHRMSDB_ITRD + ".dbo.Personal AS P");
sb.Append(" ON EFSN.CompID = P.CompID AND EFSN.EmpID = P.EmpID ");
sb.Append(" WHERE 0 = 0 ");
if (!String.IsNullOrEmpty(dataBean.CompID))
{
sb.Append(" AND EFSN.CompID=@CompID ");
}
if (!String.IsNullOrEmpty(dataBean.EmpID))
{
sb.Append(" AND EFSN.EmpID=@EmpID ");
}
if (!String.IsNullOrEmpty(dataBean.NameN))
{
sb.Append(" AND P.NameN=@NameN ");
}
if (!String.IsNullOrEmpty(dataBean.Sex))
{
sb.Append(" AND P.Sex =@Sex ");
}
sb.Append(" ; ");
}
/// <summary>
/// 取得DB資料
/// </summary>
/// <param name="model">畫面model</param>
/// <param name="datas">回傳資料</param>
/// <param name="msg">回傳訊息</param>
/// <returns>bool</returns>
public static bool GetEmpFlowSNEmpAndSexUseDapper(TemplateModel model, out List <TemplateBean> datas, out string msg)
{
bool result = false;
msg = "";
datas = new List <TemplateBean>();
try
{
using (var conn = new SqlConnection()
{
ConnectionString = DbHelper.getConnectionStrings(_attendantDBName).ConnectionString
})
{
TemplateBean dataBean = new TemplateBean()
{
CompID = model.OTCompID,
EmpID = model.OTEmpID,
NameN = model.NameN,
Sex = model.Sex
};
StringBuilder sb = new StringBuilder();
SqlCommand.GetEmpFlowSNEmpAndSexSql(dataBean, ref sb);
try
{
datas = conn.Query <TemplateBean>(sb.ToString(), dataBean).ToList();
}
catch (Exception)
{
throw;
}
if (datas == null || datas.Count == 0)
{
throw new Exception("查無資料!");
}
}
result = true;
}
catch (Exception ex)
{
msg = ex.Message;
}
return(result);
}