public Model.memberTradingIntention GetModelByDataReader(IDataReader dr)
{
Model.memberTradingIntention model = new Model.memberTradingIntention();
model.ID = int.Parse(dr["ID"].ToString());
model.UID = int.Parse(dr["UID"].ToString());
model.DrugsBase_Name = dr["DrugsBase_Name"].ToString();
model.Guige = dr["Guige"].ToString();
model.JiXing = dr["JiXing"].ToString();
model.QiYe = dr["QiYe"].ToString();
model.pzwh = dr["pzwh"].ToString();
model.Disposition = dr["Disposition"].ToString();
int jz = 0; int.TryParse(Convert.ToString(dr["jz"]), out jz);
model.jz = jz;
int ProNum = 0; int.TryParse(Convert.ToString(dr["ProNum"]), out ProNum);
model.ProNum = ProNum;
int ArrivalPeriod = 0; int.TryParse(Convert.ToString(dr["ArrivalPeriod"]), out ArrivalPeriod);
model.ArrivalPeriod = ArrivalPeriod;
model.Detail = Convert.ToString(dr["Detail"]);
DateTime AddDate = new DateTime(); DateTime.TryParse(Convert.ToString(dr["AddDate"]), out AddDate);
model.AddDate = AddDate;
DateTime UpdateDate = new DateTime(); DateTime.TryParse(Convert.ToString(dr["UpdateDate"]), out UpdateDate);
model.UpdateDate = UpdateDate;
int State = 0; int.TryParse(Convert.ToString(dr["State"]), out State);
model.State = State;
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.memberTradingIntention model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into memberTradingIntention(");
strSql.Append("UID, DrugsBase_Name, GuiGe, JiXing, QiYe,pzwh,jz, ProNum, ArrivalPeriod, Detail, AddDate, UpdateDate, State)");
strSql.Append(" values (");
strSql.Append("@UID, @DrugsBase_Name, @GuiGe, @JiXing, @QiYe,@pzwh,@jz, @ProNum, @ArrivalPeriod, @Detail, @AddDate, @UpdateDate, @State)");
strSql.Append(" SELECT SCOPE_IDENTITY()");
DateTime now = DateTime.Now;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID);
db.AddInParameter(dbCommand, "DrugsBase_Name", DbType.String, model.DrugsBase_Name);
db.AddInParameter(dbCommand, "GuiGe", DbType.String, model.Guige);
db.AddInParameter(dbCommand, "JiXing", DbType.String, model.JiXing);
db.AddInParameter(dbCommand, "QiYe", DbType.String, model.QiYe);
db.AddInParameter(dbCommand, "pzwh", DbType.String, model.pzwh);
db.AddInParameter(dbCommand, "jz", DbType.Int32, model.jz);
db.AddInParameter(dbCommand, "ProNum", DbType.Int32, model.ProNum);
db.AddInParameter(dbCommand, "ArrivalPeriod", DbType.Int32, model.ArrivalPeriod);
db.AddInParameter(dbCommand, "Detail", DbType.String, model.Detail);
db.AddInParameter(dbCommand, "AddDate", DbType.DateTime, now);
db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, now);
db.AddInParameter(dbCommand, "State", DbType.Int32, model.State);
object obj = db.ExecuteScalar(dbCommand);
return(obj != null?Convert.ToInt32(obj) : 0);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.memberTradingIntention GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from memberTradingIntention ");
strSql.Append(" where ID=" + ID);
DataSet ds = base.ExecuteDataSet(strSql.ToString());
Model.memberTradingIntention model = null;
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
GetModelByDataRow(ds.Tables[0].Rows[0]);
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.memberTradingIntention model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update memberTradingIntention set ");
strSql.Append("UID=@UID,");
strSql.Append("DrugsBase_Name=@DrugsBase_Name,");
strSql.Append("Guige=@Guige,");
strSql.Append("JiXing=@JiXing,");
strSql.Append("QiYe=@QiYe,");
strSql.Append("pzwh=@pzwh,");
strSql.Append("jz=@jz,");
strSql.Append("ProNum=@ProNum,");
strSql.Append("ArrivalPeriod=@ArrivalPeriod,");
strSql.Append("Detail=@Detail,");
strSql.Append("UpdateDate=@UpdateDate,");
strSql.Append("State=@State");
strSql.Append(" where ID=@ID ");
DateTime now = DateTime.Now;
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "ID", DbType.Int32, model.ID);
db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID);
db.AddInParameter(dbCommand, "DrugsBase_Name", DbType.String, model.DrugsBase_Name);
db.AddInParameter(dbCommand, "Guige", DbType.String, model.Guige);
db.AddInParameter(dbCommand, "JiXing", DbType.String, model.JiXing);
db.AddInParameter(dbCommand, "QiYe", DbType.String, model.QiYe);
db.AddInParameter(dbCommand, "pzwh", DbType.String, model.pzwh);
db.AddInParameter(dbCommand, "jz", DbType.Int32, model.jz);
db.AddInParameter(dbCommand, "ProNum", DbType.Int32, model.ProNum);
db.AddInParameter(dbCommand, "ArrivalPeriod", DbType.Int32, model.ArrivalPeriod);
db.AddInParameter(dbCommand, "Detail", DbType.String, model.Detail);
db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, now);
db.AddInParameter(dbCommand, "State", DbType.Int32, model.State);
return(0 < db.ExecuteNonQuery(dbCommand));
}
