/// <summary>
/// 取得部門員工資料
/// </summary>
/// <param name="deptID"></param>
/// <param name="deptAbbreviate"></param>
/// <param name="deptName"></param>
/// <param name="sort"></param>
/// <param name="order"></param>
/// <returns></returns>
public static List <DeptDataEntity> GetUserNameData(string deptID = null, string deptAbbreviate = null, string deptName = null, string sort = null, string order = null)
{
var strSQL = @"
SELECT * FROM LBOM_DEPT D JOIN LBOM_LOGIN_USER U
ON D.DEPTID = U.DEPTID
WHERE DEPTABBREVIATE = ISNULL(@DEPTABBREVIATE, DEPTABBREVIATE)
AND DEPTNAME= ISNULL(@DEPTNAME, DEPTNAME)
AND D.DEPTID=ISNULL(@DEPTID, D.DEPTID)
";
deptAbbreviate = string.IsNullOrEmpty(deptAbbreviate) ? null : deptAbbreviate;
deptName = string.IsNullOrEmpty(deptName) ? null : deptName;
if (!string.IsNullOrEmpty(sort) && !string.IsNullOrEmpty(order))
{
strSQL += string.Format("ORDER BY {0} {1} ", sort, order);
}
SqlParameter[] parms =
{
new SqlParameter("@DEPTABBREVIATE", (object)deptAbbreviate ?? DBNull.Value),
new SqlParameter("@DEPTNAME", (object)deptName ?? DBNull.Value),
new SqlParameter("@DEPTID", (object)deptID ?? DBNull.Value)
};
//var lst = ReadData<ProductDataEntity>(strSQL, parms);
//-----------------------------------------------------------------------------
var lst = new List <DeptDataEntity>();
using (var conn = new SqlConnection(ConnectionString))
using (var cmd = new SqlCommand(strSQL, conn))
{
cmd.Parameters.AddRange(parms);
conn.Open();
using (var dp = cmd.ExecuteReader())
{
if (dp.HasRows)
{
while (dp.Read())
{
DeptDataEntity dept = new DeptDataEntity()
{
deptID = dp["deptID"].ToString(),
deptAbbreviate = dp["deptAbbreviate"].ToString(),
deptName = dp["deptName"].ToString(),
loginuserName = dp["loginuserName"].ToString()
};
lst.Add(dept);
}
//Mapper.CreateMap<IDataReader, LoginUserInfoDataEntity>();
//user = Mapper.Map<IDataReader, IList<LoginUserInfoDataEntity>>(dr).ToList().First();
}
}
}
return(lst);
}
/// <summary>
/// 新增部門資料
/// </summary>
/// <param name="uData"></param>
/// <returns></returns>
public string NewDeptData(DeptDataEntity uData)
{
uData.deptID = Guid.NewGuid().ToString();
var depts = new List <DeptDataEntity>()
{
uData
};
DeptDataAccess.AddDeptData(depts);
return(JsonConvert.SerializeObject(new { success = true, errorMsg = "" }));
}
/// <summary>
/// 修改部門資料
/// </summary>
/// <param name="uData"></param>
/// <returns></returns>
public string EditDeptData(DeptDataEntity uData)
{
var depts = new List <DeptDataEntity>()
{
uData
};
var errorMsg = string.Empty;
var isSuccess = true;
try { DeptDataAccess.UpdateDeptData(depts); }
catch (Exception ex)
{
isSuccess = false;
errorMsg = ex.Message.Replace("\n", "");
}
return(JsonConvert.SerializeObject(new { success = isSuccess, errorMsg = errorMsg }));
}