/// <summary>
/// 审核
/// </summary>
/// <param name="Channel">频道</param>
/// <returns></returns>
public bool UpdateChannelById(Tz888.Model.Link.LinkChannelType Channel)
{
string sql = "update LinkChannelType set ChannelName=@ChannelName,CheckId=@CheckId,Remarks=@Remarks where ChannelId=@ChannelId";
SqlParameter[] Paras = new SqlParameter[] {
new SqlParameter("@ChannelId", SqlDbType.Int, 4),
new SqlParameter("@ChannelName", SqlDbType.VarChar, 50),
new SqlParameter("@CheckId", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 100)
};
Paras[0].Value = Channel.ChannelId;
Paras[1].Value = Channel.ChannelName;
Paras[2].Value = Channel.CheckId;
Paras[3].Value = Channel.Remarks;
int row = crm.ExecuteSql(sql, Paras);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void BtnSvae_Click(object sender, EventArgs e)
{
try
{
Tz888.Model.Link.LinkChannelType Channel = new Tz888.Model.Link.LinkChannelType();
Channel.ChannelName = Tz888.Common.Utility.PageValidate.HtmlEncode(txtChannelName.Value.Trim());
Channel.CheckId = 0;
Channel.Remarks = Tz888.Common.Utility.PageValidate.HtmlEncode(txtRemarks.Value.Trim());
if (bll.AddChannel(Channel))
{
Tz888.Common.MessageBox.ShowAndRedirect(this.Page, "添加成功!", "ChannelManage.aspx", false);
}
else
{
Tz888.Common.MessageBox.Show(this.Page, "添加失败");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 添加频道
/// </summary>
/// <param name="Channel">频道</param>
/// <returns></returns>
public bool AddChannel(Tz888.Model.Link.LinkChannelType Channel)
{
string sql = "insert into LinkChannelType(ChannelName,CheckId,Remarks) values(@ChannelName,@CheckId,@Remarks)";
SqlParameter[] Paras = new SqlParameter[] {
new SqlParameter("@ChannelName", SqlDbType.VarChar, 50),
new SqlParameter("@CheckId", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 100)
};
Paras[0].Value = Channel.ChannelName;
Paras[1].Value = Channel.CheckId;
Paras[2].Value = Channel.Remarks;
int row = crm.ExecuteSql(sql, Paras);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
//频道审核
protected void BtnSvae_Click(object sender, EventArgs e)
{
try
{
Tz888.Model.Link.LinkChannelType model = new Tz888.Model.Link.LinkChannelType();
model.ChannelId = Convert.ToInt32(ViewState["ChannelId"].ToString());
model.ChannelName = Tz888.Common.Utility.PageValidate.HtmlEncode(txtChannelName.Value.Trim());
model.CheckId = Convert.ToInt32(rblAuditing.SelectedValue);
model.Remarks = Tz888.Common.Utility.PageValidate.HtmlEncode(txtRemarks.Value.Trim());
if (Channel.UpdateChannelById(model))
{
Tz888.Common.MessageBox.ShowAndRedirect(this.Page, "审核成功!", "ChannelManage.aspx", false);
}
else
{
Tz888.Common.MessageBox.ShowAndRedirect(this.Page, "审核失败!", "ChannelManage.aspx", false);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
