/// <summary>
/// 新增方法
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Model.check_Work_AttendanceModel model)
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append("insert into check_Work_Attendance (UserId,Attendance_time,work_Overtime,sick_Leave,compassionate_Leave,State)");
strSQL.Append("values (@UserId,@Attendance_time,@work_Overtime,@sick_Leave,@compassionate_Leave,@State)");
SqlParameter[] parameters = {
new SqlParameter("@UserId",SqlDbType.VarChar,20),
new SqlParameter("@Attendance_time",SqlDbType.DateTime),
new SqlParameter("@work_Overtime",SqlDbType.VarChar,2),
new SqlParameter("@sick_Leave",SqlDbType.Text),
new SqlParameter("@compassionate_Leave",SqlDbType.Text),
new SqlParameter("@State",SqlDbType.VarChar,20),
};
parameters[0].Value = model.UserId;
parameters[1].Value = model.Attendance_time;
parameters[2].Value = model.Work_Overtime;
parameters[3].Value = model.Ssick_Leaveex;
parameters[4].Value = model.Compassionate_Leave;
parameters[5].Value = model.State;
int row = Maticsoft.DBUtility.DbHelperSQL.ExecuteSql(strSQL.ToString(), parameters);
if (row > 0)
{
return true;
}
else
{
return false;
}
}
public bool Update(Model.check_Work_AttendanceModel model)
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append("update check_Work_Attendance set UserId=@UserId,Attendance_time=@Attendance_time," +
"Work_Overtime=@Work_Overtime,Sick_Leave=@Sick_Leave,Compassionate_Leave=@Compassionate_Leave," +
"State=@State where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@UserId",SqlDbType.VarChar,20),
new SqlParameter("@Attendance_time",SqlDbType.DateTime),
new SqlParameter("@work_Overtime",SqlDbType.VarChar,2),
new SqlParameter("@sick_Leave",SqlDbType.Text),
new SqlParameter("@compassionate_Leave",SqlDbType.Text),
new SqlParameter("@State",SqlDbType.VarChar,20),
};
parameters[0].Value = model.UserId;
parameters[1].Value = model.Attendance_time;
parameters[2].Value = model.Work_Overtime;
parameters[3].Value = model.Ssick_Leaveex;
parameters[4].Value = model.Compassionate_Leave;
parameters[5].Value = model.State;
int rows = DbHelperSQL.ExecuteSql(strSQL.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 将行数据转换成对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public Model.check_Work_AttendanceModel DataRowToModel(DataRow dr)
{
Model.check_Work_AttendanceModel model = new Model.check_Work_AttendanceModel();
if (dr != null)
{
model.Id = Convert.ToInt32(dr["Id"].ToString());
model.UserId = dr["UserId"].ToString();
model.Attendance_time = dr["Attendance_time"].ToString();
model.Work_Overtime = dr["Work_Overtime"].ToString();
model.Sick_Leave = dr["Ssick_Leaveex"].ToString();
model.Compassionate_Leave = dr["Compassionate_Leave"].ToString();
model.State = dr["State"].ToString();
}
return model;
}
/// <summary>
/// 根据ID获取对象;
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Model.check_Work_AttendanceModel GetModel(int Id)
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append("select id,UserId,Attendance_time,Work_Overtime,Sick_Leave,Compassionate_Leave,State from check_Work_Attendance");
strSQL.Append(" where id=@id");
SqlParameter[] parameter = {
new SqlParameter("@id",SqlDbType.Int)
};
parameter[0].Value = Id;
DataSet ds = DbHelperSQL.Query(strSQL.ToString(), parameter);
Model.check_Work_AttendanceModel tempModel = new Model.check_Work_AttendanceModel();
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
tempModel = DataRowToModel(item);
}
}
return tempModel;
}