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