public M_Pro_Project GetModelFromReader(DbDataReader rdr)
{
M_Pro_Project model = new M_Pro_Project();
model.ID = ConvertToInt(rdr["ID"]);
model.ProName = ConverToStr(rdr["ProName"]);
model.ZType = ConvertToInt(rdr["ZType"]);
model.ProPrice = ConverToDouble(rdr["ProPrice"]);
model.ProManageer = ConvertToInt(rdr["ProManageer"]);
model.TecDirector = ConverToStr(rdr["TecDirector"]);
model.CustomerID = ConvertToInt(rdr["CustomerID"]);
model.CustomerCompany = ConverToStr(rdr["CustomerCompany"]);
model.CustomerTele = ConverToStr(rdr["CustomerTele"]);
model.CustomerMobile = ConverToStr(rdr["CustomerMobile"]);
model.CustomerQQ = ConverToStr(rdr["CustomerQQ"]);
model.CustomerMSN = ConverToStr(rdr["CustomerMSN"]);
model.CustomerAddress = ConverToStr(rdr["CustomerAddress"]);
model.CustomerEmail = ConverToStr(rdr["CustomerEmail"]);
model.Requirements = ConverToStr(rdr["Requirements"]);
model.ZStatus = ConvertToInt(rdr["ZStatus"]);
model.CDate = ConvertToDate(rdr["CDate"]);
model.Remind = ConverToStr(rdr["Remind"]);
rdr.Close();
return(model);
}
public override SqlParameter[] GetParameters()
{
M_Pro_Project model = this;
if (CDate <= DateTime.MinValue)
{
CDate = DateTime.Now;
}
SqlParameter[] sp = GetSP();
sp[0].Value = model.ID;
sp[1].Value = model.ProName;
sp[2].Value = model.ZType;
sp[3].Value = model.ProPrice;
sp[4].Value = model.ProManageer;
sp[5].Value = model.TecDirector;
sp[6].Value = model.CustomerID;
sp[7].Value = model.CustomerCompany;
sp[8].Value = model.CustomerTele;
sp[9].Value = model.CustomerMobile;
sp[10].Value = model.CustomerQQ;
sp[11].Value = model.CustomerMSN;
sp[12].Value = model.CustomerAddress;
sp[13].Value = model.CustomerEmail;
sp[14].Value = model.Requirements;
sp[15].Value = model.ZStatus;
sp[16].Value = model.CDate;
sp[17].Value = model.Remind;
return(sp);
}
