public int HasScoreORAudit(string deptID, out bool hasAudit) { int code = -1; DateTime dtNow = RS_ScoreExtend.CheckMonth; RS_ScoreManageQueryModel queryModel = new RS_ScoreManageQueryModel(); List <RS_ScoreManageModel> list = new List <RS_ScoreManageModel>(); queryModel.DeptCodeEqual = deptID; queryModel.MarkDateEqual = this.GetMonthFirstDate(dtNow); queryModel.TypeEqual = int.Parse(ScoreType.Employ.ToString("d")); list = this.GetRS_ScoreManageList(queryModel); if (list.Count > 0) { code = list[0].Code; if (int.Parse(list[0].Status) > int.Parse(WorkFlowStatus.Audited.ToString("d"))) { hasAudit = true; return(code); } hasAudit = false; return(code); } hasAudit = false; return(code); }
public List <RS_ScoreManageModel> GetRS_ScoreManageList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string DeptCodeEqual, string MarkerEqual, DateTime MarkDateEqual, int TypeEqual, string StatusEqual) { List <RS_ScoreManageModel> models = new List <RS_ScoreManageModel>(); RS_ScoreManageQueryModel objQueryModel = new RS_ScoreManageQueryModel(); objQueryModel.StartRecord = StartRecord; objQueryModel.MaxRecords = MaxRecords; objQueryModel.SortColumns = SortColumns; objQueryModel.CodeEqual = CodeEqual; objQueryModel.DeptCodeEqual = DeptCodeEqual; objQueryModel.MarkerEqual = MarkerEqual; objQueryModel.MarkDateEqual = MarkDateEqual; objQueryModel.TypeEqual = TypeEqual; objQueryModel.StatusEqual = StatusEqual; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { connection.Open(); models = new RS_ScoreManageBLL().GetModels(objQueryModel, connection); connection.Close(); } catch (SqlException exception) { throw exception; } } return(models); }
public int HasManagerScoredORAudit(string userCode, out bool hasScore, out bool hasAudit) { int code = -1; DateTime dtNow = RS_ScoreExtend.CheckMonth; RS_ScoreManageQueryModel queryModel = new RS_ScoreManageQueryModel(); List <RS_ScoreManageModel> list = new List <RS_ScoreManageModel>(); queryModel.MarkDateEqual = this.GetMonthFirstDate(dtNow); queryModel.MarkerEqual = userCode; queryModel.TypeEqual = int.Parse(ScoreType.Manager.ToString("d")); list = this.GetRS_ScoreManageList(queryModel); if ((list == null) || (list.Count == 0)) { hasAudit = false; hasScore = false; return(code); } code = list[0].Code; if (int.Parse(list[0].Status) < int.Parse(WorkFlowStatus.Audited.ToString("d"))) { hasScore = true; hasAudit = false; return(code); } hasScore = true; hasAudit = true; return(code); }
public List <RS_ScoreManageModel> GetManageCode(string deptCode, DateTime dt, ScoreType sorceType) { RS_ScoreManageQueryModel queryModel = new RS_ScoreManageQueryModel(); queryModel.DeptCodeEqual = deptCode; queryModel.MarkDateEqual = dt; queryModel.TypeEqual = int.Parse(sorceType.ToString("d")); List <RS_ScoreManageModel> list = new List <RS_ScoreManageModel>(); return(this.GetRS_ScoreManageList(queryModel)); }
private List <RS_ScoreManageModel> _Select(RS_ScoreManageQueryModel qmObj) { List <RS_ScoreManageModel> list = new List <RS_ScoreManageModel>(); StringBuilder builder = new StringBuilder(); builder.Append("select * from RS_ScoreManage "); builder.Append(qmObj.QueryConditionStr); if (qmObj.SortColumns.Length == 0) { builder.Append(" ORDER BY Code desc"); } else { builder.Append(" ORDER BY " + qmObj.SortColumns); } this._DataProcess.CommandText = builder.ToString(); this._DataProcess.SqlParameters = qmObj.Parameters; SqlDataReader sqlDataReader = null; int num = 0; try { try { sqlDataReader = this._DataProcess.GetSqlDataReader(); while (sqlDataReader.Read()) { if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1))) { RS_ScoreManageModel model = new RS_ScoreManageModel(); this.Initialize(sqlDataReader, model); list.Add(model); } num++; } } catch (SqlException exception) { throw exception; } } finally { if (sqlDataReader != null) { sqlDataReader.Close(); } } return(list); }
public List <EmployScoreMode> GetDeptScores(string userCode, DateTime dt, string type) { List <RS_ScoreManageModel> list = new List <RS_ScoreManageModel>(); List <RS_EmployScoreModel> list2 = new List <RS_EmployScoreModel>(); RS_ScoreManageQueryModel queryModel = new RS_ScoreManageQueryModel(); queryModel.MarkDateEqual = this.GetMonthFirstDate(dt); queryModel.MarkerEqual = userCode; queryModel.TypeEqual = int.Parse(ScoreType.Dept.ToString("d")); list = this.GetRS_ScoreManageList(queryModel); if (list.Count == 0) { if (!type.Equals("Load")) { return(null); } for (int i = 2; (list.Count == 0) && (i > 0); i--) { queryModel = new RS_ScoreManageQueryModel(); dt = dt.AddMonths(-1); queryModel.MarkerEqual = userCode; queryModel.MarkDateEqual = dt; queryModel.TypeEqual = int.Parse(ScoreType.Dept.ToString("d")); list = this.GetRS_ScoreManageList(queryModel); } if (list.Count == 0) { return(null); } } List <RS_EmployScoreModel> userScoreListByManageCode = new List <RS_EmployScoreModel>(); userScoreListByManageCode = this.GetUserScoreListByManageCode(list[0].Code); string userNameByUserID = this.GetUserNameByUserID(list[0].Marker); EmployScoreMode item = new EmployScoreMode(); List <EmployScoreMode> list4 = new List <EmployScoreMode>(); foreach (RS_EmployScoreModel model2 in userScoreListByManageCode) { item = new EmployScoreMode(); item.Score = model2.Score.ToString(); item.DeptCode = model2.UserCode; item.DeptName = this.GetDeptNameByDeptID(model2.UserCode); item.Marker = userNameByUserID; item.ScoreCode = model2.Code; item.MarkTime = list[0].MarkDate.ToString(); list4.Add(item); } return(list4); }
public List <RS_ScoreManageModel> GetRS_ScoreManageList(RS_ScoreManageQueryModel QueryModel) { List <RS_ScoreManageModel> models = new List <RS_ScoreManageModel>(); using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { connection.Open(); if (QueryModel == null) { QueryModel = new RS_ScoreManageQueryModel(); } models = new RS_ScoreManageBLL().GetModels(QueryModel, connection); connection.Close(); } catch (SqlException exception) { throw exception; } } return(models); }
public List <RS_ScoreManageModel> Select(RS_ScoreManageQueryModel qmObj) { return(this._Select(qmObj)); }
public List <RS_ScoreManageModel> Select() { RS_ScoreManageQueryModel qmObj = new RS_ScoreManageQueryModel(); return(this._Select(qmObj)); }
public List <EmployScoreMode> GetScores(string userCode, ScoreType st, DateTime dt) { DateTime monthFirstDate; int num; if (dt > DateTime.Now) { monthFirstDate = this.GetMonthFirstDate(DateTime.Now); } else { monthFirstDate = this.GetMonthFirstDate(dt); } RS_ScoreManageQueryModel queryModel = new RS_ScoreManageQueryModel(); List <RS_ScoreManageModel> list = new List <RS_ScoreManageModel>(); queryModel.MarkerEqual = userCode; queryModel.MarkDateEqual = monthFirstDate; queryModel.TypeEqual = int.Parse(st.ToString("d")); list = this.GetRS_ScoreManageList(queryModel); if ((list == null) || (list.Count == 0)) { for (num = 12; (list.Count == 0) && (num > 0); num--) { queryModel = new RS_ScoreManageQueryModel(); monthFirstDate = monthFirstDate.AddMonths(-1); queryModel.MarkerEqual = userCode; queryModel.MarkDateEqual = monthFirstDate; queryModel.TypeEqual = int.Parse(st.ToString("d")); list = this.GetRS_ScoreManageList(queryModel); } if ((list == null) || (list.Count == 0)) { return(null); } } else { int code = list[0].Code; if (int.Parse(list[0].Status) < int.Parse(WorkFlowStatus.Audited.ToString("d"))) { for (num = 12; (list.Count == 0) && (num > 0); num--) { queryModel = new RS_ScoreManageQueryModel(); monthFirstDate = monthFirstDate.AddMonths(-1); queryModel.MarkerEqual = userCode; queryModel.MarkDateEqual = monthFirstDate; queryModel.TypeEqual = int.Parse(st.ToString("d")); list = this.GetRS_ScoreManageList(queryModel); } if ((list.Count == 0) || (list == null)) { return(null); } } } List <RS_EmployScoreModel> userScoreListByManageCode = new List <RS_EmployScoreModel>(); userScoreListByManageCode = this.GetUserScoreListByManageCode(list[0].Code); string userNameByUserID = this.GetUserNameByUserID(list[0].Marker); EmployScoreMode item = new EmployScoreMode(); List <EmployScoreMode> list3 = new List <EmployScoreMode>(); foreach (RS_EmployScoreModel model2 in userScoreListByManageCode) { item = new EmployScoreMode(); item.UserCode = model2.UserCode; item.Score = model2.Score.ToString(); item.Marker = userNameByUserID; item.ScoreCode = model2.Code; item.MarkTime = list[0].MarkDate.ToString(); item.Status = list[0].Status; list3.Add(item); } return(list3); }
public List <EmployScoreMode> GetEmployScore(string deptCode, DateTime dtNow, SearchType st) { int num; RS_ScoreManageQueryModel model = new RS_ScoreManageQueryModel(); RS_ScoreManageModel model2 = new RS_ScoreManageModel(); List <RS_ScoreManageModel> list = new List <RS_ScoreManageModel>(); DateTime dt = this.GetMonthFirstDate(dtNow); list = this.GetManageCode(deptCode, dt, ScoreType.Employ); if (list.Count == 0) { if (st == SearchType.Search) { return(null); } for (num = 12; (list.Count == 0) && (num > 0); num--) { dt = dt.AddMonths(-1); list = this.GetManageCode(deptCode, dt, ScoreType.Employ); } if (list.Count == 0) { return(null); } } else { int code = list[0].Code; if (int.Parse(list[0].Status) < int.Parse(WorkFlowStatus.Audited.ToString("d"))) { for (num = 12; (list.Count == 0) && (num > 0); num--) { if (st == SearchType.Search) { return(null); } dt = dt.AddMinutes(-1); list = this.GetManageCode(deptCode, dt, ScoreType.Employ); } if (list.Count == 0) { return(null); } } } List <RS_EmployScoreModel> userScoreListByManageCode = new List <RS_EmployScoreModel>(); userScoreListByManageCode = this.GetUserScoreListByManageCode(list[0].Code); string userNameByUserID = this.GetUserNameByUserID(list[0].Marker); string deptNameByDeptID = this.GetDeptNameByDeptID(list[0].DeptCode); EmployScoreMode item = new EmployScoreMode(); List <EmployScoreMode> list3 = new List <EmployScoreMode>(); RS_ScoreExtend extend = new RS_ScoreExtend(); foreach (RS_EmployScoreModel model3 in userScoreListByManageCode) { item = new EmployScoreMode(); item.UserCode = model3.UserCode; item.UserName = extend.GetUserNameByCode(model3.UserCode); item.Score = model3.Score.ToString(); item.DeptCode = list[0].DeptCode; item.DeptName = deptNameByDeptID; item.Marker = userNameByUserID; item.ScoreCode = model3.Code; item.MarkTime = list[0].MarkDate.ToString(); item.Status = list[0].Status; list3.Add(item); } return(list3); }
public List <RS_ScoreManageModel> GetModels(RS_ScoreManageQueryModel ObjQueryModel, SqlTransaction Transaction) { RS_ScoreManageDAL edal = new RS_ScoreManageDAL(Transaction); return(edal.Select(ObjQueryModel)); }