public override SqlParameter[] GetParameters()
{
M_Order_Exp model = this;
if (model.CDate <= DateTime.MinValue)
{
model.CDate = DateTime.Now;
}
SqlParameter[] sp = GetSP();
sp[0].Value = model.ID;
sp[1].Value = model.OrderID;
sp[2].Value = model.CompType;
sp[3].Value = model.ExpComp;
sp[4].Value = model.ExpNo;
sp[5].Value = model.ExpStatus;
sp[6].Value = model.ExpRemind;
sp[7].Value = model.SendDate;
sp[8].Value = model.SignDate;
sp[9].Value = model.BackDate;
sp[10].Value = model.UserRemind;
sp[11].Value = model.AdminRemind;
sp[12].Value = model.UserID;
sp[13].Value = model.CDate;
sp[14].Value = model.APILink;
return(sp);
}
public M_Order_Exp GetModelFromReader(DbDataReader rdr)
{
M_Order_Exp model = new M_Order_Exp();
model.ID = Convert.ToInt32(rdr["ID"]);
model.OrderID = ConvertToInt(rdr["OrderID"]);
model.CompType = ConverToStr(rdr["CompType"]);
model.ExpComp = ConverToStr(rdr["ExpComp"]);
model.ExpNo = ConverToStr(rdr["ExpNo"]);
model.ExpStatus = ConverToStr(rdr["ExpStatus"]);
model.ExpRemind = ConverToStr(rdr["ExpRemind"]);
model.SendDate = ConverToStr(rdr["SendDate"]);
model.SignDate = ConverToStr(rdr["SignDate"]);
model.BackDate = ConverToStr(rdr["BackDate"]);
model.UserRemind = ConverToStr(rdr["UserRemind"]);
model.AdminRemind = ConverToStr(rdr["AdminRemind"]);
model.UserID = ConvertToInt(rdr["UserID"]);
model.CDate = ConvertToDate(rdr["CDate"]);
model.APILink = ConverToStr(rdr["APILink"]);
rdr.Close();
return(model);
}
