/// <summary> /// 得到一个对象实体 /// </summary> public M_GoodsExtraInfo GetM_GoodsExtraInfoModel(int m_GoodsExtraInfoID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 m_GoodsExtraInfoID,m_GoodsID,eid,num_iid,title,m_desc,feature,memo,type,reserve_price,created,modified,list_time,delist_time,approve_status,pic_url,options,item_pic_url,item_options,item_num from tb_M_GoodsExtraInfo "); strSql.Append(" where m_GoodsExtraInfoID=@m_GoodsExtraInfoID "); SqlParameter[] parameters = { new SqlParameter("@m_GoodsExtraInfoID", SqlDbType.Int, 4) }; parameters[0].Value = m_GoodsExtraInfoID; M_GoodsExtraInfo model = new M_GoodsExtraInfo(); DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["m_GoodsExtraInfoID"].ToString() != "") { model.m_GoodsExtraInfoID = int.Parse(ds.Tables[0].Rows[0]["m_GoodsExtraInfoID"].ToString()); } if (ds.Tables[0].Rows[0]["m_GoodsID"].ToString() != "") { model.m_GoodsID = int.Parse(ds.Tables[0].Rows[0]["m_GoodsID"].ToString()); } if (ds.Tables[0].Rows[0]["eid"].ToString() != "") { model.eid = int.Parse(ds.Tables[0].Rows[0]["eid"].ToString()); } if (ds.Tables[0].Rows[0]["num_iid"].ToString() != "") { model.num_iid = int.Parse(ds.Tables[0].Rows[0]["num_iid"].ToString()); } model.title = ds.Tables[0].Rows[0]["title"].ToString(); model.m_desc = ds.Tables[0].Rows[0]["m_desc"].ToString(); model.feature = ds.Tables[0].Rows[0]["feature"].ToString(); model.memo = ds.Tables[0].Rows[0]["memo"].ToString(); model.type = ds.Tables[0].Rows[0]["type"].ToString(); if (ds.Tables[0].Rows[0]["reserve_price"].ToString() != "") { model.reserve_price = decimal.Parse(ds.Tables[0].Rows[0]["reserve_price"].ToString()); } if (ds.Tables[0].Rows[0]["created"].ToString() != "") { model.created = DateTime.Parse(ds.Tables[0].Rows[0]["created"].ToString()); } if (ds.Tables[0].Rows[0]["modified"].ToString() != "") { model.modified = DateTime.Parse(ds.Tables[0].Rows[0]["modified"].ToString()); } if (ds.Tables[0].Rows[0]["list_time"].ToString() != "") { model.list_time = DateTime.Parse(ds.Tables[0].Rows[0]["list_time"].ToString()); } if (ds.Tables[0].Rows[0]["delist_time"].ToString() != "") { model.delist_time = DateTime.Parse(ds.Tables[0].Rows[0]["delist_time"].ToString()); } model.approve_status = ds.Tables[0].Rows[0]["approve_status"].ToString(); model.pic_url = ds.Tables[0].Rows[0]["pic_url"].ToString(); if (ds.Tables[0].Rows[0]["options"].ToString() != "") { model.options = int.Parse(ds.Tables[0].Rows[0]["options"].ToString()); } model.item_pic_url = ds.Tables[0].Rows[0]["item_pic_url"].ToString(); if (ds.Tables[0].Rows[0]["item_options"].ToString() != "") { model.item_options = int.Parse(ds.Tables[0].Rows[0]["item_options"].ToString()); } if (ds.Tables[0].Rows[0]["item_num"].ToString() != "") { model.item_num = int.Parse(ds.Tables[0].Rows[0]["item_num"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int AddM_GoodsExtraInfo(M_GoodsExtraInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_M_GoodsExtraInfo("); strSql.Append("m_GoodsID,eid,num_iid,title,m_desc,feature,memo,type,reserve_price,created,modified,list_time,delist_time,approve_status,pic_url,options,item_pic_url,item_options,item_num)"); strSql.Append(" values ("); strSql.Append("@m_GoodsID,@eid,@num_iid,@title,@m_desc,@feature,@memo,@type,@reserve_price,@created,@modified,@list_time,@delist_time,@approve_status,@pic_url,@options,@item_pic_url,@item_options,@item_num)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@m_GoodsID", SqlDbType.Int, 4), new SqlParameter("@eid", SqlDbType.Int, 4), new SqlParameter("@num_iid", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.VarChar, 100), new SqlParameter("@m_desc", SqlDbType.VarChar, 1024), new SqlParameter("@feature", SqlDbType.VarChar, 512), new SqlParameter("@memo", SqlDbType.VarChar, 512), new SqlParameter("@type", SqlDbType.VarChar, 50), new SqlParameter("@reserve_price", SqlDbType.Money, 8), new SqlParameter("@created", SqlDbType.DateTime), new SqlParameter("@modified", SqlDbType.DateTime), new SqlParameter("@list_time", SqlDbType.DateTime), new SqlParameter("@delist_time", SqlDbType.DateTime), new SqlParameter("@approve_status", SqlDbType.VarChar, 50), new SqlParameter("@pic_url", SqlDbType.VarChar, 512), new SqlParameter("@options", SqlDbType.Int, 4), new SqlParameter("@item_pic_url", SqlDbType.VarChar, 512), new SqlParameter("@item_options", SqlDbType.Int, 4), new SqlParameter("@item_num", SqlDbType.Int, 4) }; parameters[0].Value = model.m_GoodsID; parameters[1].Value = model.eid; parameters[2].Value = model.num_iid; parameters[3].Value = model.title; parameters[4].Value = model.m_desc; parameters[5].Value = model.feature; parameters[6].Value = model.memo; parameters[7].Value = model.type; parameters[8].Value = model.reserve_price; parameters[9].Value = model.created; parameters[10].Value = model.modified; parameters[11].Value = model.list_time; parameters[12].Value = model.delist_time; parameters[13].Value = model.approve_status; parameters[14].Value = model.pic_url; parameters[15].Value = model.options; parameters[16].Value = model.item_pic_url; parameters[17].Value = model.item_options; parameters[18].Value = model.item_num; object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(-1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void UpdateM_GoodsExtraInfo(M_GoodsExtraInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_M_GoodsExtraInfo set "); strSql.Append("m_GoodsID=@m_GoodsID,"); strSql.Append("eid=@eid,"); strSql.Append("num_iid=@num_iid,"); strSql.Append("title=@title,"); strSql.Append("m_desc=@m_desc,"); strSql.Append("feature=@feature,"); strSql.Append("memo=@memo,"); strSql.Append("type=@type,"); strSql.Append("reserve_price=@reserve_price,"); strSql.Append("created=@created,"); strSql.Append("modified=@modified,"); strSql.Append("list_time=@list_time,"); strSql.Append("delist_time=@delist_time,"); strSql.Append("approve_status=@approve_status,"); strSql.Append("pic_url=@pic_url,"); strSql.Append("options=@options,"); strSql.Append("item_pic_url=@item_pic_url,"); strSql.Append("item_options=@item_options,"); strSql.Append("item_num=@item_num"); strSql.Append(" where m_GoodsExtraInfoID=@m_GoodsExtraInfoID "); SqlParameter[] parameters = { new SqlParameter("@m_GoodsExtraInfoID", SqlDbType.Int, 4), new SqlParameter("@m_GoodsID", SqlDbType.Int, 4), new SqlParameter("@eid", SqlDbType.Int, 4), new SqlParameter("@num_iid", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.VarChar, 100), new SqlParameter("@m_desc", SqlDbType.VarChar, 1024), new SqlParameter("@feature", SqlDbType.VarChar, 512), new SqlParameter("@memo", SqlDbType.VarChar, 512), new SqlParameter("@type", SqlDbType.VarChar, 50), new SqlParameter("@reserve_price", SqlDbType.Money, 8), new SqlParameter("@created", SqlDbType.DateTime), new SqlParameter("@modified", SqlDbType.DateTime), new SqlParameter("@list_time", SqlDbType.DateTime), new SqlParameter("@delist_time", SqlDbType.DateTime), new SqlParameter("@approve_status", SqlDbType.VarChar, 50), new SqlParameter("@pic_url", SqlDbType.VarChar, 512), new SqlParameter("@options", SqlDbType.Int, 4), new SqlParameter("@item_pic_url", SqlDbType.VarChar, 512), new SqlParameter("@item_options", SqlDbType.Int, 4), new SqlParameter("@item_num", SqlDbType.Int, 4) }; parameters[0].Value = model.m_GoodsExtraInfoID; parameters[1].Value = model.m_GoodsID; parameters[2].Value = model.eid; parameters[3].Value = model.num_iid; parameters[4].Value = model.title; parameters[5].Value = model.m_desc; parameters[6].Value = model.feature; parameters[7].Value = model.memo; parameters[8].Value = model.type; parameters[9].Value = model.reserve_price; parameters[10].Value = model.created; parameters[11].Value = model.modified; parameters[12].Value = model.list_time; parameters[13].Value = model.delist_time; parameters[14].Value = model.approve_status; parameters[15].Value = model.pic_url; parameters[16].Value = model.options; parameters[17].Value = model.item_pic_url; parameters[18].Value = model.item_options; parameters[19].Value = model.item_num; DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); }