public override bool Insert(ChannelInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LinkUrl", Value = ParameterHelper.ConvertValue(m.LinkUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ImgUrl", Value = ParameterHelper.ConvertValue(m.ImgUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsShow", Value = ParameterHelper.ConvertValue(m.IsShow)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsHot", Value = ParameterHelper.ConvertValue(m.IsHot)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsTop", Value = ParameterHelper.ConvertValue(m.IsTop)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ColorValue", Value = ParameterHelper.ConvertValue(m.ColorValue)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LastDate", Value = ParameterHelper.ConvertValue(m.LastDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override int InsertIdentityId(ChannelInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LinkUrl", Value = ParameterHelper.ConvertValue(m.LinkUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ImgUrl", Value = ParameterHelper.ConvertValue(m.ImgUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsShow", Value = ParameterHelper.ConvertValue(m.IsShow)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsHot", Value = ParameterHelper.ConvertValue(m.IsHot)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsTop", Value = ParameterHelper.ConvertValue(m.IsTop)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ColorValue", Value = ParameterHelper.ConvertValue(m.ColorValue)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LastDate", Value = ParameterHelper.ConvertValue(m.LastDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
protected void btnSave_Click(object sender, EventArgs e)
{
ChannelInfoVO info = new ChannelInfoVO();
info.ColorValue = "";
info.CreateDate = DateTime.Now;
info.CreateUserId = Account.UserId;
info.Desc = txtDesc.Text;
info.ImgUrl = "";
info.LastDate = DateTime.Now;
info.LinkUrl = txtLinkUrl.Value;
info.Name = txtName.Value;
ChannelInfoBLL.Instance.Add(info);
Response.Redirect("/Admin/Article/ChannelList.aspx");
}
public override string GetOtherConditionByModel(ChannelInfoVO m)
{
return("");
}
public override string GetOrderByModel(ChannelInfoVO m)
{
return("");
}
