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)); }