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