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