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