protected void BtnModfiy_Click(object sender, EventArgs e)
{
if (Request.QueryString["Id"] != null)
{
string Id = Request.QueryString["Id"];
if (Tz888.Common.Utility.PageValidate.IsNumber(Id))
{
Tz888.Model.Recommend.RecommendModel model = new Tz888.Model.Recommend.RecommendModel();
model.Id = Convert.ToInt32(Id);
model.Title = txtTitle.Value.Trim();
model.Address = txtAddress.Value.Trim();
model.Sort = txtSort.Value.Trim() == "" ? 0 : Convert.ToInt32(txtSort.Value.Trim());
model.Identity = Convert.ToInt32(DropIdentity.SelectedValue.Trim());
model.ProvinceID = FenZhanList.SelectedValue;
model.IsRecommend = Convert.ToInt32(RadioRecommend.SelectedValue);
model.Remarks = txtRemarks.Value.Trim();
if (bll.ModfiyRecommend(model))
{
Tz888.Common.MessageBox.ShowAndRedirect(this.Page, "修改成功!", "RecommendManage.aspx", false);
}
else
{
Tz888.Common.MessageBox.Show(this.Page, "修改失败!");
}
}
else
{
Tz888.Common.MessageBox.Show(this.Page, "修改错误!");
}
}
}
public bool ModfiyRecommend(Tz888.Model.Recommend.RecommendModel model)
{
string sql = "update Recommend set Title=@Title,Sort=@Sort,Address=@Address,[Identity]=@Identity,Remarks=@Remarks,IsRecommend=@IsRecommend,ProvinceID=@ProvinceID where Id=@Id";
SqlParameter[] Paras = new SqlParameter[] {
new SqlParameter("@Title", SqlDbType.VarChar, 200),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@Address", SqlDbType.VarChar, 200),
new SqlParameter("@Identity", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.VarChar, 200),
new SqlParameter("@IsRecommend", SqlDbType.Int, 4),
new SqlParameter("@ProvinceID", SqlDbType.Char, 10),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
Paras[0].Value = model.Title;
Paras[1].Value = model.Sort;
Paras[2].Value = model.Address;
Paras[3].Value = model.Identity;
Paras[4].Value = model.Remarks;
Paras[5].Value = model.IsRecommend;
Paras[6].Value = model.ProvinceID;
Paras[7].Value = model.Id;
int row = crm.ExecuteSql(sql, Paras);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool AddRecommend(Tz888.Model.Recommend.RecommendModel model)
{
string sql = "insert into Recommend(Title,Sort,Address,[Identity],Remarks,IsRecommend,ProvinceID) values(@Title,@Sort,@Address,@Identity,@Remarks,@IsRecommend,@ProvinceID)";
SqlParameter[] Paras = new SqlParameter[] {
new SqlParameter("@Title", SqlDbType.VarChar, 200),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@Address", SqlDbType.VarChar, 200),
new SqlParameter("@Identity", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.VarChar, 200),
new SqlParameter("@IsRecommend", SqlDbType.Int, 4),
new SqlParameter("@ProvinceID", SqlDbType.Char, 10)
};
Paras[0].Value = model.Title;
Paras[1].Value = model.Sort;
Paras[2].Value = model.Address;
Paras[3].Value = model.Identity;
Paras[4].Value = model.Remarks;
Paras[5].Value = model.IsRecommend;
Paras[6].Value = model.ProvinceID;
int row = crm.ExecuteSql(sql, Paras);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
Tz888.Model.Recommend.RecommendModel model = new Tz888.Model.Recommend.RecommendModel();
model.Title = txtTitle.Value.Trim();
model.Address = txtAddress.Value.Trim();
model.Sort = txtSort.Value.Trim() == "" ? 0 : Convert.ToInt32(txtSort.Value.Trim());
model.Identity = Convert.ToInt32(DropIdentity.SelectedValue.Trim());
model.IsRecommend = Convert.ToInt32(RadioRecommend.SelectedValue);
model.ProvinceID = FenZhanList.SelectedValue;
model.Remarks = txtRemarks.Value.Trim();
if (bll.AddRecommend(model))
{
Tz888.Common.MessageBox.ShowAndRedirect(this.Page, "添加成功!", "RecommendManage.aspx", false);
}
else
{
Tz888.Common.MessageBox.Show(this.Page, "添加失败!");
}
}
public bool ModfiyRecommend(Tz888.Model.Recommend.RecommendModel model)
{
return(dal.ModfiyRecommend(model));
}
public bool AddRecommend(Tz888.Model.Recommend.RecommendModel model)
{
return(dal.AddRecommend(model));
}
