/// <summary>
/// 删除新区数据
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string Delete(HttpContext context, bool isRoot)
{
int ID;
try
{
if (context.Request.Params["ID"] != null)
{
ID = Convert.ToInt32(context.Request.Params["ID"]);
DISTRICT_CONTRAST dc = new DISTRICT_CONTRAST()
{
ID = ID
};
ArrayList list = new ArrayList();
if (isRoot)
{
DISTRICT_CONTRAST dcSon = new DISTRICT_CONTRAST()
{
SUPERID = ID
};
list.Add(dcm.GetDeleteSql(dcSon));
}
list.Add(dcm.GetDeleteSql(dc));
return(dcm.ExecuteSqlTran(list).ToString());
}
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
}
return("-1");
}
/// <summary>
/// 修改新区数据
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string Update(HttpContext context)
{
ArrayList list = new ArrayList();
try
{
string name = context.Request.Params["NAME"];
int id;
if (context.Request.Params["ID"] != null)
{
id = Convert.ToInt32(context.Request.Params["ID"]);
//获取更新对象以及其更新语句
DISTRICT_CONTRAST fatherDC = new DISTRICT_CONTRAST()
{
ID = id,
NAME = name
};
list.Add(dcm.GetUpdateSql(fatherDC));
//获取更新对象的原来子集对象,及其删除语句
DISTRICT_CONTRAST dcOldSon = new DISTRICT_CONTRAST()
{
SUPERID = id
};
list.Add(dcm.GetDeleteSql(dcOldSon));
//获取更新对象的新子集对象,及其插入语句
string childrenName = context.Request.Params["childrenName"];
string childrenId = context.Request.Params["childrenId"];
string[] arrayName = childrenName.Substring(1).Split(',');
string[] arrayId = childrenId.Substring(1).Split(',');
for (int i = 0; i < arrayName.Length; i++)
{
DISTRICT_CONTRAST dc = new DISTRICT_CONTRAST()
{
ID = dcm.GetSequence(),
SUPERID = fatherDC.ID,
NAME = arrayName[i],
SUPERNAME = fatherDC.NAME,
OLDID = Convert.ToInt32(arrayId[i])
};
list.Add(dcm.GetInsertSql(dc));
}
return(dcm.ExecuteSqlTran(list).ToString());
}
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
}
return("-1");
}
/// <summary>
/// 增加新区数据
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string Insert(HttpContext context)
{
try
{
ArrayList list = new ArrayList();
string name = context.Request.Params["NAME"];
//获取新区对象
DISTRICT_CONTRAST fatherDC = new DISTRICT_CONTRAST()
{
ID = dcm.GetSequence(),
NAME = name,
state = "closed",
SUPERID = 0
};
list.Add(dcm.GetInsertSql(fatherDC));
string childrenName = context.Request.Params["childrenName"];
string childrenId = context.Request.Params["childrenId"];
string[] arrayName = childrenName.Substring(1).Split(',');
string[] arrayId = childrenId.Substring(1).Split(',');
for (int i = 0; i < arrayName.Length; i++)
{
DISTRICT_CONTRAST dc = new DISTRICT_CONTRAST()
{
ID = dcm.GetSequence(),
SUPERID = fatherDC.ID,
NAME = arrayName[i],
SUPERNAME = fatherDC.NAME,
OLDID = Convert.ToInt32(arrayId[i])
};
list.Add(dcm.GetInsertSql(dc));
}
return(dcm.ExecuteSqlTran(list).ToString());
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
return("-1");
}
}