public M_Stock GetModelFromReader(DbDataReader rdr) { M_Stock model = new M_Stock(); model.id = Convert.ToInt32(rdr["id"]); model.stocktype = ConvertToInt(rdr["stocktype"]); model.danju = ConverToStr(rdr["danju"]); model.proname = ConverToStr(rdr["proname"]); model.addtime = ConvertToDate(rdr["addtime"]); model.adduser = ConverToStr(rdr["adduser"]); model.content = ConverToStr(rdr["content"]); model.proid = ConvertToInt(rdr["proid"]); model.Pronum = ConvertToInt(rdr["pronum"]); model.UserID = ConvertToInt(rdr["UserID"]); model.AdminID = ConvertToInt(rdr["AdminID"]); model.StoreID = ConvertToInt(rdr["StoreID"]); rdr.Close(); rdr.Dispose(); return(model); }
public override SqlParameter[] GetParameters() { M_Stock model = this; if (model.addtime <= DateTime.MinValue) { model.addtime = DateTime.Now; } SqlParameter[] sp = GetSP(); sp[0].Value = model.id; sp[1].Value = model.stocktype; sp[2].Value = model.danju; sp[3].Value = model.proname; sp[4].Value = model.addtime; sp[5].Value = model.adduser; sp[6].Value = model.content; sp[7].Value = model.proid; sp[8].Value = model.Pronum; sp[9].Value = model.UserID; sp[10].Value = model.AdminID; sp[11].Value = model.StoreID; return(sp); }