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