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