public M_OA_DocView GetModelFromReader(DbDataReader rdr) { M_OA_DocView model = new M_OA_DocView(); model.ID = ConvertToInt(rdr["ID"]); model.DocID = ConvertToInt(rdr["DocID"]); model.ViewUserIDS = ConverToStr(rdr["ViewUserIDS"]); model.EditUserIDS = ConverToStr(rdr["EditUserIDS"]); model.ZStatus = ConvertToInt(rdr["ZStatus"]); model.UserID = ConvertToInt(rdr["UserID"]); model.CDate = ConvertToDate(rdr["CDate"]); model.EndDate = ConvertToDate(rdr["EndDate"]); rdr.Close(); return(model); }
public override SqlParameter[] GetParameters() { M_OA_DocView model = this; if (model.CDate <= DateTime.MinValue) { model.CDate = DateTime.Now; } if (model.EndDate <= DateTime.MinValue) { model.EndDate = DateTime.MaxValue; } SqlParameter[] sp = GetSP(); sp[0].Value = model.ID; sp[1].Value = model.DocID; sp[2].Value = model.ViewUserIDS; sp[3].Value = model.EditUserIDS; sp[4].Value = model.ZStatus; sp[5].Value = model.UserID; sp[6].Value = model.CDate; sp[7].Value = model.EndDate; return(sp); }