public List <UnitModel> GetAllDepts()
{
List <UnitModel> list = new List <UnitModel>();
SqlConnection sqlConn = new SqlConnection(FunctionRule.GetConnectionString());
return(RS_ScoreManageDAL.GetAllDepts(sqlConn));
}
public List <UnitModel> GetMangeDeptListByUserCode(string userCode)
{
List <UnitModel> list = new List <UnitModel>();
SqlConnection sqlConn = new SqlConnection(FunctionRule.GetConnectionString());
return(RS_ScoreManageDAL.GetManageListByUserCode(userCode, sqlConn));
}
public List <UnitScoreModel> GetUnitScoreModel(DateTime dt)
{
dt = this.GetMonthFirstDate(dt);
List <UnitScoreModel> deptScoreTotal = new List <UnitScoreModel>();
SqlConnection sqlConn = new SqlConnection(FunctionRule.GetConnectionString());
deptScoreTotal = RS_ScoreManageDAL.GetDeptScoreTotal(dt, sqlConn);
List <UnitScoreModel> list2 = new List <UnitScoreModel>();
foreach (UnitScoreModel model2 in deptScoreTotal)
{
SqlConnection connection2 = new SqlConnection(FunctionRule.GetConnectionString());
UnitScoreModel item = new UnitScoreModel();
item.DeptCode = model2.DeptCode;
item.DeptName = this.GetDeptNameByDeptID(model2.DeptCode);
item.Score = model2.Score;
string text = RS_ScoreManageDAL.GetDeptEmployMarker(dt, model2.DeptCode, connection2);
if (!string.IsNullOrEmpty(text))
{
item.Marker = this.GetUserNameByUserID(text);
}
list2.Add(item);
}
return(list2);
}
public List <UserModel> GetLeadedUsersByUserID(string userID)
{
List <UserModel> list = new List <UserModel>();
SqlConnection sqlConn = new SqlConnection(FunctionRule.GetConnectionString());
return(RS_ScoreManageDAL.GetLeadedUser(userID, sqlConn));
}
public int Insert(RS_ScoreManageModel ObjModel, SqlTransaction Transaction)
{
RS_ScoreManageDAL edal = new RS_ScoreManageDAL(Transaction);
return(edal.Insert(ObjModel));
}
public List <RS_ScoreManageModel> GetModels(SqlTransaction Transaction)
{
RS_ScoreManageDAL edal = new RS_ScoreManageDAL(Transaction);
return(edal.Select());
}
public List <RS_ScoreManageModel> GetModels(RS_ScoreManageQueryModel ObjQueryModel, SqlTransaction Transaction)
{
RS_ScoreManageDAL edal = new RS_ScoreManageDAL(Transaction);
return(edal.Select(ObjQueryModel));
}
public List <RS_ScoreManageModel> GetModels(SqlConnection Connection)
{
RS_ScoreManageDAL edal = new RS_ScoreManageDAL(Connection);
return(edal.Select());
}
public RS_ScoreManageModel GetModel(int Code, SqlTransaction Transaction)
{
RS_ScoreManageDAL edal = new RS_ScoreManageDAL(Transaction);
return(edal.GetModel(Code));
}
public RS_ScoreManageModel GetModel(int Code, SqlConnection Connection)
{
RS_ScoreManageDAL edal = new RS_ScoreManageDAL(Connection);
return(edal.GetModel(Code));
}
public int Update(RS_ScoreManageModel ObjModel, SqlTransaction Transaction)
{
RS_ScoreManageDAL edal = new RS_ScoreManageDAL(Transaction);
return(edal.Update(ObjModel));
}
public int Delete(int Code, SqlTransaction Transaction)
{
RS_ScoreManageDAL edal = new RS_ScoreManageDAL(Transaction);
return(edal.Delete(Code));
}
