private void BuildTree2(string id)
{
if (id == "")
{
id = "1";
}
List <SqlParameter> parameters = new List <SqlParameter>(); //sql参数存储对象
var parameter = new SqlParameter("@ParentId", DbType.AnsiString);
parameter.Value = id;
parameters.Add(parameter);
DataSet dataset = proTypeDal.GetList("", parameters); //查询所有类别信息
_stringBuilder.Append("[");
var i = 0;
foreach (DataRow trow in dataset.Tables[0].Rows)
{
if (i != 0)
{
_stringBuilder.Append(",");
}
var text = trow["AreaName"].ToString().Trim();
var no = trow["AreaId"].ToString().Trim();
var pid = trow["ParentId"];
var href = "ProductSpecMain.aspx?AreaId=" + no;
_stringBuilder.Append("{\"id\": " + no + ",\"pId\":" + pid + ",\"name\":\"" + text + "\"}");
i++;
}
_stringBuilder.Append("]");
}
/// <summary>
/// 获取区域信息
/// </summary>
/// <returns></returns>
public DataSet GetArea()
{
DataSet dt = new DataSet();
List <SqlParameter> parameters = new List <SqlParameter>();
string sqlWhere = " ParentId =0 ";
dt = orgAreaDal.GetList(sqlWhere, parameters);
return(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
try
{
if (string.IsNullOrEmpty(Request.Form["id"]))
{
return;
}
var id = Request.Form["id"];
if (string.IsNullOrEmpty(Request.Form["name"]))
{
return;
}
var pcname = Request.Form["name"];
var bll = new OrgArea();
var model = bll.GetModel(id);
model.AreaName = pcname;
List <SqlParameter> parameters = new List <SqlParameter>();
var parameter = new SqlParameter("@AreaName", DbType.AnsiString)
{
Value = pcname
};
parameters.Add(parameter);
var parameter1 = new SqlParameter("@AreaId", DbType.AnsiString)
{
Value = id
};
parameters.Add(parameter1);
var parameter2 = new SqlParameter("@ParentId", DbType.AnsiString)
{
Value = model.ParentId
};
parameters.Add(parameter2);
if (bll.GetList(" AreaName=@AreaName and Status=1 and AreaId!=@AreaId ", parameters).Tables[0].Rows.Count > 0)
{
Response.Write("区域名称已存在");
Response.End();
}
Response.Write(bll.Update(model) ? "修改成功" : "修改失败");
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception)
{
Response.Write("修改失败");
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
try
{
if (string.IsNullOrEmpty(Request.Form["id"]))
{
return;
}
var id = Request.Form["id"];
if (string.IsNullOrEmpty(Request.Form["name"]))
{
return;
}
var pcname = Request.Form["name"];
var bll = new OrgArea();
List <SqlParameter> parameters = new List <SqlParameter>();
var parameter = new SqlParameter("@AreaName", DbType.AnsiString)
{
Value = pcname
};
parameters.Add(parameter);
if (bll.GetList(" AreaName=@AreaName and Status=1 ", parameters).Tables[0].Rows.Count > 0)
{
Response.Write("区域名称已存在");
Response.End();
}
var model = new Admin.Model.OrgArea
{
AreaName = pcname,
ParentId = id,
AreaId = bll.MaxAreaId(),
AreaLevel = 3,
Status = 1
};
Response.Write(bll.Add(model) ? "保存成功" : "保存失败");
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception)
{
Response.Write("保存失败");
Response.End();
}
}
/// <summary>
/// 构建栏目树
/// </summary>
private void BuildTree(string id)
{
try
{
if (!string.IsNullOrEmpty(Request.QueryString["menu"]))
{
List <SqlParameter> parameters = new List <SqlParameter>(); //sql参数存储对象
DataSet myset = proTypeDal.GetList(" Status=1 ", parameters); //查询所有类别信息
if (id == "")
{
id = "1";
}
foreach (
var iRow in myset.Tables[0].Rows.Cast <DataRow>().Where(iRow => iRow["AreaId"].ToString() == id))
{
iRow["ParentId"] = DBNull.Value;
}
myset.Relations.Add("NodeRelation", myset.Tables[0].Columns["AreaId"],
myset.Tables[0].Columns["ParentId"], false);
_stringBuilder.Append("[");
var i = 0;
if (i != 0)
{
_stringBuilder.Append(",");
}
foreach (DataRow mRow in myset.Tables[0].Rows)
{
if (!mRow.IsNull("ParentId"))
{
continue;
}
var text = mRow["AreaName"].ToString().Trim();
var no = mRow["AreaId"].ToString().Trim();
var href = Request.QueryString["menu"] + "?AreaId=" + no;
if (mRow.GetChildRows("NodeRelation").Length <= 0)
{
_stringBuilder.Append("{\"state\":\"open\",\"data\":{\"title\": \"" + text +
"\",\"icon\": \"jstree-iconla\",\"attr\": { \"href\": \"" + href +
"\", \"target\": \"center\" }},\"attr\": { \"id\": \"" + no + "\" }");
}
else
{
_stringBuilder.Append("{\"state\":\"open\",\"data\":{\"title\": \"" + text + "\",\"attr\": { \"href\": \"" + href +
"\", \"target\": \"center\" }},\"attr\": { \"id\": \"" + no + "\" }");
}
//_stringBuilder.Append("{\"data\":{\"title\": \"" + text + "\",\"attr\": { \"href\": \"" + href +
// "\", \"target\": \"center\" }},\"attr\": { \"id\": \"" + no + "\" }");
BuildSubTree(mRow);
_stringBuilder.Append("}");
i++;
}
_stringBuilder.Append("]");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request.QueryString["ProvinceId"]))
{
string provinceId = Request.QueryString["ProvinceId"];
List <SqlParameter> parameters = new List <SqlParameter>();
DataTable dts = orgAreaDal.GetList(" ParentId=" + provinceId + " and [Status]=1 ", parameters).Tables[0];
var areaName = string.Empty;
if (dts.Rows.Count > 0)
{
for (int i = 0; i < dts.Rows.Count; i++)
{
areaName += "," + dts.Rows[i]["AreaId"] + "|";
areaName += dts.Rows[i]["AreaName"] + " ";
}
}
Response.Write(areaName);
Response.End();
}
if (!string.IsNullOrEmpty(Request.QueryString["CityId"]))
{
string cityId = Request.QueryString["CityId"];
List <SqlParameter> parameters = new List <SqlParameter>();
DataTable dts = orgAreaDal.GetList(" ParentId=" + cityId + " and [Status]=1 ", parameters).Tables[0];
var areaName = string.Empty;
if (dts.Rows.Count > 0)
{
for (int i = 0; i < dts.Rows.Count; i++)
{
areaName += "," + dts.Rows[i]["AreaId"] + "|";
areaName += dts.Rows[i]["AreaName"] + " ";
}
}
Response.Write(areaName);
Response.End();
}
if (!string.IsNullOrEmpty(Request.QueryString["OrgId"]))
{
Response.Write(orgOrgDal.DelOrgWorStaTran(Request.QueryString["OrgId"]) ? "删除成功" : "删除失败");
Response.End();
}
else
{
Response.Write("删除失败");
Response.End();
}
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception)
{
Response.Write("删除失败");
Response.End();
}
}
}
