public override SqlParameter[] GetParameters()
{
M_MisAttendance model = this;
SqlParameter[] sp = GetSP();
sp[0].Value = model.ID;
sp[1].Value = model.DepartMent;
sp[2].Value = model.BeginTime;
sp[3].Value = model.EndTime;
sp[4].Value = model.UserName;
sp[5].Value = model.Comment;
sp[6].Value = model.BeginStatus;
sp[7].Value = model.EndStatus;
return(sp);
}
public M_MisAttendance GetModelFromReader(DbDataReader rdr)
{
M_MisAttendance model = new M_MisAttendance();
model.ID = Convert.ToInt32(rdr["ID"]);
model.DepartMent = ConverToStr(rdr["Department"]);
model.BeginTime = ConverToStr(rdr["BeginTime"]);
model.EndTime = ConverToStr(rdr["EndTime"]);
model.UserName = ConverToStr(rdr["UserName"]);
model.Comment = ConverToStr(rdr["Comment"]);
model.BeginStatus = ConvertToInt(rdr["BeginStatus"]);
model.EndStatus = ConvertToInt(rdr["EndStatus"]);
if (!rdr.HasRows)
{
rdr.Close();
rdr.Dispose();
}
return(model);
}