/// <summary> /// 绑定界面上的信息 /// </summary> public bool DataBind(string ruleId) { int id; if (!int.TryParse(ruleId, out id)) { _View.Message = "初始化错误"; return(false); } DutyClass rule = _IPlanDutyFacade.GetDutyClassByPKID(id); if (rule != null) { _View.DutyClassId = rule.DutyClassID.ToString(); _View.DutyClassName = rule.DutyClassName; _View.FirstStartFromTime = rule.FirstStartFromTime.ToString(); _View.FirstStartToTime = rule.FirstStartToTime.ToString(); _View.FirstEndTime = rule.FirstEndTime.ToString(); _View.SecondStartTime = rule.SecondStartTime.ToString(); _View.SecondEndTime = rule.SecondEndTime.ToString(); _View.LateTime = rule.LateTime.ToString(); _View.EarlyLeaveTime = rule.EarlyLeaveTime.ToString(); _View.AbsentEarlyLeaveTime = rule.AbsentEarlyLeaveTime.ToString(); _View.AbsentLateTime = rule.AbsentLateTime.ToString(); return(true); } _View.Message = "初始化错误"; return(false); }
/// <summary> /// 通过pkid查找班别 /// </summary> public DutyClass GetDutyClassByPkid(int pkid) { DutyClass dutyClass = null; SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(_ParmPKID, SqlDbType.Int).Value = pkid; using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetDutyClassByPkid", sqlCommand)) { while (sdr.Read()) { dutyClass = new DutyClass(); dutyClass.DutyClassID = Convert.ToInt32(sdr[_DbPKID]); dutyClass.DutyClassName = (sdr[_DbDutyClassName]).ToString(); dutyClass.FirstStartFromTime = Convert.ToDateTime(sdr[_DbFirstStartFromTime]); dutyClass.FirstStartToTime = Convert.ToDateTime(sdr[_DbFirstStartToTime]); dutyClass.FirstEndTime = Convert.ToDateTime(sdr[_DbFirstEndTime]); dutyClass.SecondStartTime = Convert.ToDateTime(sdr[_DbSecondStartTime]); dutyClass.SecondEndTime = Convert.ToDateTime(sdr[_DbSecondEndTime]); dutyClass.AllLimitTime = Convert.ToDecimal(sdr[_DbAllLimitTime]); dutyClass.LateTime = Convert.ToInt32(sdr[_DbLateTime]); dutyClass.EarlyLeaveTime = Convert.ToInt32(sdr[_DbEarlyLeaveTime]); dutyClass.AbsentEarlyLeaveTime = Convert.ToInt32(sdr[_DbAbsentEarlyLeaveTime]); dutyClass.AbsentLateTime = Convert.ToInt32(sdr[_DbAbsentLateTime]); } return(dutyClass); } }
/// <summary> /// 通过条件得到班别 /// </summary> /// <param name="pkid"></param> /// <param name="dutyClassName"></param> /// <returns></returns> public List <DutyClass> GetDutyClassByCondition(int pkid, string dutyClassName) { List <DutyClass> dutyClasss = new List <DutyClass>(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(_ParmPKID, SqlDbType.Int).Value = pkid; sqlCommand.Parameters.Add(_DbDutyClassName, SqlDbType.NVarChar, 50).Value = dutyClassName; using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetDutyClassByCondition", sqlCommand)) { while (sdr.Read()) { DutyClass dutyClass = new DutyClass(); dutyClass.DutyClassID = Convert.ToInt32(sdr[_DbPKID]); dutyClass.DutyClassName = (sdr[_DbDutyClassName]).ToString(); dutyClass.FirstStartFromTime = Convert.ToDateTime(sdr[_DbFirstStartFromTime]); dutyClass.FirstStartToTime = Convert.ToDateTime(sdr[_DbFirstStartToTime]); dutyClass.FirstEndTime = Convert.ToDateTime(sdr[_DbFirstEndTime]); dutyClass.SecondStartTime = Convert.ToDateTime(sdr[_DbSecondStartTime]); dutyClass.SecondEndTime = Convert.ToDateTime(sdr[_DbSecondEndTime]); dutyClass.AllLimitTime = Convert.ToDecimal(sdr[_DbAllLimitTime]); dutyClass.LateTime = Convert.ToInt32(sdr[_DbLateTime]); dutyClass.EarlyLeaveTime = Convert.ToInt32(sdr[_DbEarlyLeaveTime]); dutyClass.AbsentEarlyLeaveTime = Convert.ToInt32(sdr[_DbAbsentEarlyLeaveTime]); dutyClass.AbsentLateTime = Convert.ToInt32(sdr[_DbAbsentLateTime]); dutyClasss.Add(dutyClass); } return(dutyClasss); } }
/// <summary> /// 将界面上的信息赋值给rule /// </summary> public void CompleteTheObject(DutyClass rule) { if (rule != null) { rule.LateTime = Convert.ToInt32(_View.LateTime); rule.EarlyLeaveTime = Convert.ToInt32(_View.EarlyLeaveTime); rule.AbsentEarlyLeaveTime = Convert.ToInt32(_View.AbsentEarlyLeaveTime); rule.AbsentLateTime = Convert.ToInt32(_View.AbsentLateTime); rule.FirstStartFromTime = Convert.ToDateTime(_View.FirstStartFromTime); rule.FirstStartToTime = Convert.ToDateTime(_View.FirstStartToTime); rule.FirstEndTime = Convert.ToDateTime(_View.FirstEndTime); rule.SecondStartTime = Convert.ToDateTime(_View.SecondStartTime); rule.SecondEndTime = Convert.ToDateTime(_View.SecondEndTime); rule.DutyClassName = _View.DutyClassName.Trim(); } }
public void UpdateEvent() { if (!_Utility.Validate()) { return; } DutyClass rule = _IPlanDutyFacade.GetDutyClassByPKID(Convert.ToInt32(_View.DutyClassId)); _Utility.CompleteTheObject(rule); try { _IPlanDutyFacade.UpdateDutyClass(rule); _View.ActionSuccess = true; } catch (ApplicationException ae) { _View.Message = ae.Message; } }
public void AddEvent() { if (!_Utility.Validate()) { return; } DutyClass rule = new DutyClass(); _Utility.CompleteTheObject(rule); try { _IPlanDutyFacade.AddDutyClass(rule); _View.ActionSuccess = true; } catch (ApplicationException ae) { _View.Message = ae.Message; } }
/// <summary> /// 更新班别 /// </summary> /// <param name="dutyClass"></param> /// <returns></returns> public int UpdateDutyClass(DutyClass dutyClass) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(_ParmPKID, SqlDbType.Int).Value = dutyClass.DutyClassID; sqlCommand.Parameters.Add(_ParmDutyClassName, SqlDbType.NVarChar, 50).Value = dutyClass.DutyClassName; sqlCommand.Parameters.Add(_ParmFirstStartFromTime, SqlDbType.DateTime).Value = dutyClass.FirstStartFromTime; sqlCommand.Parameters.Add(_ParmFirstStartToTime, SqlDbType.DateTime).Value = dutyClass.FirstStartToTime; sqlCommand.Parameters.Add(_ParmFirstEndTime, SqlDbType.DateTime).Value = dutyClass.FirstEndTime; sqlCommand.Parameters.Add(_ParmSecondStartTime, SqlDbType.DateTime).Value = dutyClass.SecondStartTime; sqlCommand.Parameters.Add(_ParmSecondEndTime, SqlDbType.DateTime).Value = dutyClass.SecondEndTime; sqlCommand.Parameters.Add(_ParmAllLimitTime, SqlDbType.Decimal).Value = dutyClass.AllLimitTime; sqlCommand.Parameters.Add(_ParmLateTime, SqlDbType.Int).Value = dutyClass.LateTime; sqlCommand.Parameters.Add(_ParmEarlyLeaveTime, SqlDbType.Int).Value = dutyClass.EarlyLeaveTime; sqlCommand.Parameters.Add(_ParmAbsentLateTime, SqlDbType.Int).Value = dutyClass.AbsentLateTime; sqlCommand.Parameters.Add(_ParmAbsentEarlyLeaveTime, SqlDbType.Int).Value = dutyClass.AbsentEarlyLeaveTime; return(SqlHelper.ExecuteNonQuery("UpdateDutyClass", sqlCommand)); }
/// <summary> /// 插入班别 /// </summary> /// <param name="dutyClass"></param> /// <returns></returns> public int InsertDutyClass(DutyClass dutyClass) { int pkid; SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(_ParmPKID, SqlDbType.Int).Direction = ParameterDirection.Output; sqlCommand.Parameters.Add(_ParmDutyClassName, SqlDbType.NVarChar, 50).Value = dutyClass.DutyClassName; sqlCommand.Parameters.Add(_ParmFirstStartFromTime, SqlDbType.DateTime).Value = dutyClass.FirstStartFromTime; sqlCommand.Parameters.Add(_ParmFirstStartToTime, SqlDbType.DateTime).Value = dutyClass.FirstStartToTime; sqlCommand.Parameters.Add(_ParmFirstEndTime, SqlDbType.DateTime).Value = dutyClass.FirstEndTime; sqlCommand.Parameters.Add(_ParmSecondStartTime, SqlDbType.DateTime).Value = dutyClass.SecondStartTime; sqlCommand.Parameters.Add(_ParmSecondEndTime, SqlDbType.DateTime).Value = dutyClass.SecondEndTime; sqlCommand.Parameters.Add(_ParmAllLimitTime, SqlDbType.Decimal).Value = dutyClass.AllLimitTime; sqlCommand.Parameters.Add(_ParmLateTime, SqlDbType.Int).Value = dutyClass.LateTime; sqlCommand.Parameters.Add(_ParmEarlyLeaveTime, SqlDbType.Int).Value = dutyClass.EarlyLeaveTime; sqlCommand.Parameters.Add(_ParmAbsentLateTime, SqlDbType.Int).Value = dutyClass.AbsentLateTime; sqlCommand.Parameters.Add(_ParmAbsentEarlyLeaveTime, SqlDbType.Int).Value = dutyClass.AbsentEarlyLeaveTime; SqlHelper.ExecuteNonQueryReturnPKID("InsertDutyClass", sqlCommand, out pkid); return(pkid); }
/// <summary> /// 新增班别构造函数,测试 /// </summary> /// <param name="dutyClass"></param> /// <param name="ruleMock"></param> public InsertDutyClass(DutyClass dutyClass, IPlanDutyDal ruleMock) { _DutyClass = dutyClass; _DalRull = ruleMock; }
/// <summary> /// 新增班别构造函数 /// </summary> /// <param name="dutyClass"></param> public InsertDutyClass(DutyClass dutyClass) { _DutyClass = dutyClass; }
public void UpdateDutyClass(DutyClass rule) { UpdateDutyClass UpdateAttendanceRule = new UpdateDutyClass(rule); UpdateAttendanceRule.Excute(); }
public void AddDutyClass(DutyClass dutyClass) { InsertDutyClass _InsertDutyClass = new InsertDutyClass(dutyClass); _InsertDutyClass.Excute(); }
/// <summary> /// 测试用 /// </summary> public UpdateDutyClass(DutyClass rule, IPlanDutyDal ruleMock) { _DutyClass = rule; _DalRull = ruleMock; }
/// <summary> /// 修改班别,构造函数 /// </summary> /// <param name="rule"></param> public UpdateDutyClass(DutyClass rule) { _DutyClass = rule; }