protected void btnSave_Click(object sender, EventArgs e) { int StreetId = int.Parse(hdStreetId.Value.ToString()); AreaEntity Area = new AreaEntity(); Area.StreetName = txtStreetName.Text; if (hdStreetId.Value == "0") { if (Ctrl_Area.AddStreet(Area) > 0) { MessageBox.ShowAndRedirect(this, "成功添加一条数据!", "StreetList.aspx"); } else { MessageBox.Show(this, "添加数据失败,请与管理员联系!"); } } else { Area.StreetId = StreetId; if (Ctrl_Area.UpdateStreet(Area)) { MessageBox.ShowAndRedirect(this, "成功修改一条数据!", "StreetList.aspx"); } else { MessageBox.Show(this, "修改数据失败,请与管理员联系!"); } } }
protected void btnSave_Click(object sender, EventArgs e) { int CommunityId = int.Parse(hdCommunityId.Value.ToString()); AreaEntity Area = new AreaEntity(); Area.CommunityName = txtCommunityName.Text; Area.StreetId = int.Parse(drpParentStreet.SelectedValue); if (hdCommunityId.Value == "0") { if (Ctrl_Area.AddCommunity(Area) > 0) { Area.CommunityId = Ctrl_Area.GetMaxCommunityId()-1; if (Ctrl_Area.AddRelation(Area) > 0) MessageBox.ShowAndRedirect(this, "成功添加一条数据!", "CommunityList.aspx"); else MessageBox.Show(this, "添加数据失败,请与管理员联系!"); } else { MessageBox.Show(this, "添加数据失败,请与管理员联系!"); } } else { Area.CommunityId = CommunityId; if (Ctrl_Area.UpdateCommunity(Area) && Ctrl_Area.UpdateRelation(Area)) { MessageBox.ShowAndRedirect(this, "成功修改一条数据!", "CommunityList.aspx"); } else { MessageBox.Show(this, "修改数据失败,请与管理员联系!"); } } }
/// <summary> /// 添加街道社区联系 /// </summary> public static int AddRelation(AreaEntity Area) { int iExecute = 0; try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Area_Relation("); strSql.Append("Sid,Cid)"); strSql.Append(" values ("); strSql.Append("@StreetId,@CommunityId)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@StreetId", SqlDbType.Int), new SqlParameter("@CommunityId", SqlDbType.Int), }; parameters[0].Value = Area.StreetId; parameters[1].Value = Area.CommunityId; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj != null) { iExecute = Convert.ToInt32(obj); } } catch (Exception e) { Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\AddUserRole" + e.Message); } return iExecute; }
/// <summary> /// 增加一个社区 /// </summary> /// <returns>成功返回1 否则返回0</returns> public static int AddCommunity(AreaEntity Area) { int iExecute = 0; try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Area_Community("); strSql.Append("Name)"); strSql.Append(" values ("); strSql.Append("@Name)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar,50) }; parameters[0].Value = Area.CommunityName; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj != null) { iExecute = Convert.ToInt32(obj); } } catch (Exception e) { Log4Net.LogWrite("err", "Controler.Ctrl_Approve.AddUser:" + e.Message); } return iExecute; }
/// <summary> /// 修改街道信息 /// </summary> /// <returns>成功返回true 否则返回false</returns> public static bool UpdateStreet(AreaEntity Area) { bool iExecute = false; try { StringBuilder strSql = new StringBuilder(); strSql.Append("update Area_Street set "); strSql.Append("Name=@Name"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.NVarChar,50), new SqlParameter("@Id", SqlDbType.Int)}; parameters[0].Value = Area.StreetName; parameters[1].Value = Area.StreetId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { iExecute = true; } } catch (Exception e) { Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\Update" + e.Message); } return iExecute; }