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)); }