public static bool AddDianPu(SellerShopForTuiGuang obj) { try { string query = @"insert into SellerShopForTuiGuang(sellerNick,shopName,cateName,type,address,huoyuan,hasShiTiShop,hasFactory,createTime) values(@sellerNick,@shopName,@cateName,@type,@address,@huoyuan,@hasShiTiShop,@hasFactory,getdate())"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@sellerNick", string.IsNullOrEmpty(obj.SellerNick)?"":obj.SellerNick), new SqlParameter("@shopName", string.IsNullOrEmpty(obj.ShopName)?"":obj.ShopName), new SqlParameter("@cateName", string.IsNullOrEmpty(obj.CateName)?"":obj.CateName), new SqlParameter("@type", string.IsNullOrEmpty(obj.Type)?"":obj.Type), new SqlParameter("@address", string.IsNullOrEmpty(obj.Address)?"":obj.Address), new SqlParameter("@huoyuan", string.IsNullOrEmpty(obj.Huoyuan)?"":obj.Huoyuan), new SqlParameter("@hasShiTiShop", string.IsNullOrEmpty(obj.HasShiTiShop)?"":obj.HasShiTiShop), new SqlParameter("@hasFactory", string.IsNullOrEmpty(obj.HasFactory)?"":obj.HasFactory) }; DataBase.ExecuteSql(query, param); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
public static bool UpdateDianPu(SellerShopForTuiGuang obj) { try { string query = @"update SellerShopForTuiGuang set shopName = @shopName,cateName = @cateName,type = @type, address = @address,huoyuan = @huoyuan,hasShiTiShop = @hasShiTiShop,hasFactory = @hasFactory where sellerNick = @sellerNick"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@sellerNick", string.IsNullOrEmpty(obj.SellerNick)?"":obj.SellerNick), new SqlParameter("@shopName", string.IsNullOrEmpty(obj.ShopName)?"":obj.ShopName), new SqlParameter("@cateName", string.IsNullOrEmpty(obj.CateName)?"":obj.CateName), new SqlParameter("@type", string.IsNullOrEmpty(obj.Type)?"":obj.Type), new SqlParameter("@address", string.IsNullOrEmpty(obj.Address)?"":obj.Address), new SqlParameter("@huoyuan", string.IsNullOrEmpty(obj.Huoyuan)?"":obj.Huoyuan), new SqlParameter("@hasShiTiShop", string.IsNullOrEmpty(obj.HasShiTiShop)?"":obj.HasShiTiShop), new SqlParameter("@hasFactory", string.IsNullOrEmpty(obj.HasFactory)?"":obj.HasFactory) }; DataBase.ExecuteSql(query, param); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
protected void btnAdd_Click(object sender, ImageClickEventArgs e) { if (drpCatsList.SelectedItem.Text.Equals("--选择店铺主营目录--")) { lbMsg.Text = "请选择主营类目!"; return; } if (string.IsNullOrEmpty(txtAdderss.Text.Trim())) { lbMsg.Text = "联系地址不能为空!"; return; } SellerShopForTuiGuang obj = new SellerShopForTuiGuang(); obj.SellerNick = Users.Nick; obj.ShopName = txt_nick.Text.Trim(); obj.CateName = drpCatsList.SelectedItem.Text; obj.Address = txtAdderss.Text.Trim(); obj.Type = rdoLst1.SelectedValue; obj.Huoyuan = rdoLst2.SelectedValue; obj.HasShiTiShop = rdoLst3.SelectedValue; obj.HasFactory = rdoLst4.SelectedValue; if (!tuiGuangBLL.ChekDianPu()) { if (tuiGuangBLL.AddDianPu(obj)) { lbMsg.Text = "添加成功!"; } else { lbMsg.Text = "添加失败!"; } } else { if (tuiGuangBLL.UpdateDianPu(obj)) { lbMsg.Text = "修改成功!"; } else { lbMsg.Text = "修改失败!"; } } }
public static bool UpdateDianPu(SellerShopForTuiGuang obj) { return(tuiGuangDAL.UpdateDianPu(obj)); }
public static bool AddDianPu(SellerShopForTuiGuang obj) { return(tuiGuangDAL.AddDianPu(obj)); }