protected void BtnSvae_Click(object sender, EventArgs e) { zsWebsiteModel M = new zsWebsiteModel(); M.LogName = bp.LoginName; M.WebsiteName = txtWebsiteName.Value.Trim(); M.WebsiteUrl = txtWebsiteUrl.Value.Trim(); M.ProvinceName = Province.SelectedValue.Trim(); M.PublishTime = DateTime.Now; M.SiteContent = txtSiteContent.Text.ToString().Trim(); M.Remarks = txtRemarks.Text.ToString().Trim(); if (bll.Add(M)) { Tz888.Common.MessageBox.ShowAndHref("添加成功!", "ManageZsWebsite.aspx"); } else { Tz888.Common.MessageBox.Show(this.Page, "添加失败!"); } }
protected void BtnUpdate_Click(object sender, EventArgs e) { zsWebsiteModel M = new zsWebsiteModel(); M.Id = Convert.ToInt32(Request.QueryString["Id"]); M.LogName = bp.LoginName; M.WebsiteName = txtWebsiteName.Value.Trim(); M.WebsiteUrl = txtWebsiteUrl.Value.Trim(); M.ProvinceName = Province.SelectedValue.Trim(); M.PublishTime = DateTime.Now; M.SiteContent = txtSiteContent.Text.ToString().Trim(); M.Remarks = txtRemarks.Text.ToString().Trim(); if (bll.Update(M)) { Tz888.Common.MessageBox.ShowAndHref("修改成功!", "ManageZsWebsite.aspx"); } else { Tz888.Common.MessageBox.Show(this.Page, "修改失败!"); } }
public bool Add(zsWebsiteModel M) { int row = 0; try { string sql = "insert into zsWebsite(LogName,WebsiteName,WebsiteUrl,ProvinceName,PublisTime,SiteContent,Remarks) values(@LogName,@WebsiteName,@WebsiteUrl,@ProvinceName,@PublisTime,@SiteContent,@Remarks)"; SqlParameter[] Paras = new SqlParameter[] { new SqlParameter("@LogName", SqlDbType.VarChar, 50), new SqlParameter("@WebsiteName", SqlDbType.VarChar, 100), new SqlParameter("@WebsiteUrl", SqlDbType.VarChar, 100), new SqlParameter("@ProvinceName", SqlDbType.VarChar, 50), new SqlParameter("@PublisTime", SqlDbType.DateTime), new SqlParameter("@SiteContent", SqlDbType.VarChar, 500), new SqlParameter("@Remarks", SqlDbType.VarChar, 500) }; Paras[0].Value = M.LogName; Paras[1].Value = M.WebsiteName; Paras[2].Value = M.WebsiteUrl; Paras[3].Value = M.ProvinceName; Paras[4].Value = M.PublishTime; Paras[5].Value = M.SiteContent; Paras[6].Value = M.Remarks; row = crm.ExecuteSql(sql, Paras); if (row > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw new Exception(ex.ToString()); } }
public bool Update(zsWebsiteModel M) { int row = 0; try { string sql = "update zsWebsite set WebsiteName=@WebsiteName,WebsiteUrl=@WebsiteUrl,ProvinceName=@ProvinceName,SiteContent=@SiteContent,Remarks=@Remarks where Id=@Id"; SqlParameter[] Paras = new SqlParameter[] { new SqlParameter("@WebsiteName", SqlDbType.VarChar, 100), new SqlParameter("@WebsiteUrl", SqlDbType.VarChar, 100), new SqlParameter("@ProvinceName", SqlDbType.VarChar, 50), new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@SiteContent", SqlDbType.VarChar, 500), new SqlParameter("@Remarks", SqlDbType.VarChar, 500) }; Paras[0].Value = M.WebsiteName; Paras[1].Value = M.WebsiteUrl; Paras[2].Value = M.ProvinceName; Paras[3].Value = M.Id; Paras[4].Value = M.SiteContent; Paras[5].Value = M.Remarks; row = crm.ExecuteSql(sql, Paras); if (row > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw new Exception(ex.ToString()); } }
public bool Update(zsWebsiteModel M) { return(dal.Update(M)); }
public bool Add(zsWebsiteModel M) { return(dal.Add(M)); }