public static void ModifyT_District(T_District t_District) { string sql = "UPDATE T_District " + "SET " + "district_name = @district_name, " + "district_level = @district_level, " + "parent_district = @parent_district " + "WHERE Id = @Id"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Id", t_District.Id), new SqlParameter("@district_name", DBHelper.GetValueByWhetherNull(t_District.District_name)), new SqlParameter("@district_level", DBHelper.GetValueByWhetherNull(t_District.District_level)), new SqlParameter("@parent_district", DBHelper.GetValueByWhetherNull(t_District.Parent_district)) }; DBHelper.ExecuteCommand(sql, para); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static T_District AddT_District(T_District t_District) { string sql = "INSERT T_District (district_name, district_level, parent_district)" + "VALUES (@district_name, @district_level, @parent_district)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@district_name", DBHelper.GetValueByWhetherNull(t_District.District_name)), new SqlParameter("@district_level", DBHelper.GetValueByWhetherNull(t_District.District_level)), new SqlParameter("@parent_district", DBHelper.GetValueByWhetherNull(t_District.Parent_district)) }; int newId = DBHelper.GetScalar(sql, para); return(GetT_DistrictById(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
protected void ddlcity_SelectedIndexChanged(object sender, EventArgs e) { string cityid = this.ddlcity.SelectedValue; T_District blld = new T_District(); DataTable dtd = blld.GetList("1=1 and CityID='" + cityid + "' order by DisSort").Tables[0]; this.ddlarea.Items.Clear(); this.ddlarea.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dtd.Rows) { string Id = dr["Id"].ToString(); string Title = dr["DisName"].ToString().Trim(); this.ddlarea.Items.Add(new ListItem(Title, Id)); } }
public static T_District GetT_DistrictById(int id) { string sql = "SELECT * FROM T_District WHERE Id = @Id"; try { SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@Id", id)); if (reader.Read()) { T_District t_District = new T_District(); try{ t_District.Id = (int)reader["Id"]; }catch {} try{ t_District.District_name = (string)reader["district_name"]; }catch {} try{ t_District.District_level = (int)reader["district_level"]; }catch {} try{ t_District.Parent_district = (int)reader["parent_district"]; }catch {} reader.Close(); return(t_District); } else { reader.Close(); return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
private void procityareabind(int _id) { tbl_product model1 = new tbl_product(); model1.GetModel(_id); T_Province bll = new T_Province(); DataTable dt = bll.GetList("1=1 order by ProSort").Tables[0]; this.ddlprov.Items.Clear(); this.ddlprov.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["ProID"].ToString(); string Title = dr["ProName"].ToString().Trim(); this.ddlprov.Items.Add(new ListItem(Title, Id)); } string proid = model1.province_id.ToString(); T_City bllc = new T_City(); DataTable dtc = bllc.GetList("1=1 and ProID='" + proid + "' order by CitySort").Tables[0]; this.ddlcity.Items.Clear(); this.ddlcity.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dtc.Rows) { string Id = dr["CityID"].ToString(); string Title = dr["CityName"].ToString().Trim(); this.ddlcity.Items.Add(new ListItem(Title, Id)); } string cityid = model1.city_id.ToString(); T_District blld = new T_District(); DataTable dtd = blld.GetList("1=1 and CityID='" + cityid + "' order by DisSort").Tables[0]; this.ddlarea.Items.Clear(); this.ddlarea.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dtd.Rows) { string Id = dr["Id"].ToString(); string Title = dr["DisName"].ToString().Trim(); this.ddlarea.Items.Add(new ListItem(Title, Id)); } }
protected void ddlprov_SelectedIndexChanged(object sender, EventArgs e) { string proid = this.ddlprov.SelectedValue; T_City bllc = new T_City(); DataTable dtc = bllc.GetList("1=1 and ProID='" + proid + "' order by CitySort").Tables[0]; this.ddlcity.Items.Clear(); this.ddlcity.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dtc.Rows) { string Id = dr["CityID"].ToString(); string Title = dr["CityName"].ToString().Trim(); this.ddlcity.Items.Add(new ListItem(Title, Id)); } T_District blld = new T_District(); DataTable dtd = blld.GetList("1=1 order by DisSort").Tables[0]; this.ddlarea.Items.Clear(); this.ddlarea.Items.Add(new ListItem("请选择...", "")); }
private static List <T_District> GetT_DistrictsBySql(string sql, params SqlParameter[] values) { List <T_District> list = new List <T_District>(); try { DataTable table = DBHelper.GetDataSet(sql, values); foreach (DataRow row in table.Rows) { T_District t_District = new T_District(); try{ t_District.Id = (int)row["Id"]; }catch {} try{ t_District.District_name = (string)row["district_name"]; }catch {} try{ t_District.District_level = (int)row["district_level"]; }catch {} try{ t_District.Parent_district = (int)row["parent_district"]; }catch {} list.Add(t_District); } return(list); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
private void procityareabind() { T_Province bll = new T_Province(); DataTable dt = bll.GetList("1=1 order by ProSort").Tables[0]; this.ddlprov.Items.Clear(); this.ddlprov.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["ProID"].ToString(); string Title = dr["ProName"].ToString().Trim(); this.ddlprov.Items.Add(new ListItem(Title, Id)); } T_City bllc = new T_City(); DataTable dtc = bllc.GetList("1=1 order by CitySort").Tables[0]; this.ddlcity.Items.Clear(); this.ddlcity.Items.Add(new ListItem("请选择...", "")); //foreach (DataRow dr in dtc.Rows) //{ // string Id = dr["CityID"].ToString(); // string Title = dr["CityName"].ToString().Trim(); // this.ddlcity.Items.Add(new ListItem(Title, Id)); //} T_District blld = new T_District(); DataTable dtd = blld.GetList("1=1 order by DisSort").Tables[0]; this.ddlarea.Items.Clear(); this.ddlarea.Items.Add(new ListItem("请选择...", "")); //foreach (DataRow dr in dtd.Rows) //{ // string Id = dr["Id"].ToString(); // string Title = dr["DisName"].ToString().Trim(); // this.ddlarea.Items.Add(new ListItem(Title, Id)); //} }
public static void ModifyT_District(T_District t_District) { T_DistrictService.ModifyT_District(t_District); }
public static void DeleteT_District(T_District t_District) { T_DistrictService.DeleteT_District(t_District); }
public static T_District AddT_District(T_District t_District) { return(T_DistrictService.AddT_District(t_District)); }
public static void DeleteT_District(T_District t_District) { DeleteT_DistrictById(t_District.Id); }
public static void DeleteT_District(T_District t_District) { DeleteT_DistrictByDistrict_name(t_District.District_name); }