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