public static bool AddShortLink(SellerShortLink entity)
{
try
{
string query = @"INSERT INTO SellerShortLink(sellerNick,linkType,linkUrl,createDate,memo)
VALUES(@sellerNick,@linkType,@linkUrl,getdate(),@memo)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@sellerNick", entity.SellerNick),
new SqlParameter("@linkType", entity.LinkType),
new SqlParameter("@linkUrl", entity.LinkUrl),
new SqlParameter("@memo", entity.Memo)
};
DataBase.ExecuteSql(query, param);
return(true);
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
return(false);
}
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
try
{
SellerShortLink obj = new SellerShortLink();
if (string.IsNullOrEmpty(txtName.Text.Trim()))
{
lbMsg.Text = "请输入短链名称！";
lbMsg.ForeColor = Color.Red;
return;
}
if (txtName.Text.Trim().Length > 16)
{
lbMsg.Text = "最多只能16个中文字符！";
lbMsg.ForeColor = Color.Red;
return;
}
string type = DropDownList1.SelectedValue.ToString();
if (type == "0")
{
lbMsg.Text = "请选择需要生成的短链类型！";
lbMsg.ForeColor = Color.Red;
return;
}
string val = "";
string msg = "";
if (DropDownList1.SelectedValue.Equals("LT_ITEM"))
{
obj.Memo = "生成短链的商品ID：" + txtProID.Text.Trim();
val = TBShortlink.SetShortLink(txtName.Text.Trim(), type, txtProID.Text.Trim(), ref msg);
}
else if (DropDownList1.SelectedValue.Equals("LT_SHOP"))
{
obj.Memo = "";
val = TBShortlink.SetShortLink(txtName.Text.Trim(), type, "shop", ref msg);
}
else if (DropDownList1.SelectedValue.Equals("LT_ACTIVITY"))
{
obj.Memo = "";
val = TBShortlink.SetShortLink(txtName.Text.Trim(), type, txtLinkURL.Text.Trim(), ref msg);
}
else if (DropDownList1.SelectedValue.Equals("LT_TRADE"))
{
obj.Memo = "";
val = TBShortlink.SetShortLink(txtName.Text.Trim(), type, txtTradeID.Text.Trim(), ref msg);
}
//修改 val=="0" 时短链创建失败
if (!string.IsNullOrEmpty(msg) || val == "0")
{
//lbMsg.Text = msg;
//lbMsg.ForeColor = Color.Red;
LabelShortLink.Visible = true;
return;
}
obj.SellerNick = Users.Nick;
obj.LinkType = DropDownList1.SelectedItem.Text;
obj.LinkUrl = val;
ShortLinkBLL.AddShortLink(obj);
lbLink.Text = val;
MsgDataBind();
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
lbMsg.Text = "短链创建失败，请联系客服！";
}
}
public static bool AddShortLink(SellerShortLink entity)
{
return(ShortLinkDAL.AddShortLink(entity));
}
