public override SqlParameter[] GetParameters() { M_User_Card model = this; if (model.CDate <= DateTime.Now) { model.CDate = DateTime.Now; } SqlParameter[] sp = GetSP(); sp[0].Value = model.ID; sp[1].Value = model.UserID; sp[2].Value = model.StoreID; sp[3].Value = model.CardNo; sp[4].Value = model.CardLevel; sp[5].Value = model.CardType; sp[6].Value = model.CardStatus; sp[7].Value = model.CardPurse; sp[8].Value = model.CardRemark; sp[9].Value = model.CardScope; sp[10].Value = model.CardAddon1; sp[11].Value = model.CardAddon2; sp[12].Value = model.OPUserID; sp[13].Value = model.CDate; sp[14].Value = model.Remark; return(sp); }
public M_User_Card GetModelFromReader(DbDataReader rdr) { M_User_Card model = new M_User_Card(); model.ID = ConvertToInt(rdr["ID"]); model.UserID = ConvertToInt(rdr["UserID"]); model.StoreID = ConvertToInt(rdr["StoreID"]); model.CardNo = ConverToStr(rdr["CardNo"]); model.CardLevel = ConvertToInt(rdr["CardLevel"]); model.CardType = ConvertToInt(rdr["CardType"]); model.CardStatus = ConvertToInt(rdr["CardStatus"]); model.CardPurse = ConverToDouble(rdr["CardPurse"]); model.CardRemark = ConverToStr(rdr["CardRemark"]); model.CardScope = ConverToStr(rdr["CardScope"]); model.CardAddon1 = ConverToStr(rdr["CardAddon1"]); model.CardAddon2 = ConverToStr(rdr["CardAddon2"]); model.OPUserID = ConvertToInt(rdr["OPUserID"]); model.CDate = ConvertToDate(rdr["CDate"]); model.Remark = ConverToStr(rdr["Remark"]); rdr.Close(); return(model); }
public bool UpdateByID(M_User_Card model) { return(DBCenter.UpdateByID(model, model.ID)); }
public int Insert(M_User_Card model) { return(DBCenter.Insert(model)); }