private string deleteaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessLocation bc = new project.Business.Base.BusinessLocation();
bc.load(jp.getValue("id"));
if (obj.PopulateDataSet("select 1 from Mstr_Location where ParentLOCNo='" + bc.Entity.LOCNo + "'").Tables[0].Rows.Count > 0)
{
flag = "3";
}
else
{
int r = bc.delete();
if (r <= 0)
{
flag = "2";
}
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "delete"));
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("liststr", createList()));
return(collection.ToString());
}
private string createList()
{
System.Text.StringBuilder sb = new System.Text.StringBuilder("");
sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">");
sb.Append("<thead>");
sb.Append("<tr class=\"text-c\">");
sb.Append("<th width=\"5%\">序号</th>");
sb.Append("<th width='25%'>编号</th>");
sb.Append("<th width='35%'>名称</th>");
sb.Append("<th width='35%'>父项类型</th>");
sb.Append("</tr>");
sb.Append("</thead>");
int r = 1;
sb.Append("<tbody>");
Business.Base.BusinessLocation bc = new project.Business.Base.BusinessLocation();
foreach (Entity.Base.EntityLocation it in bc.GetListQuery(string.Empty, string.Empty, string.Empty))
{
string spacestr = "";
int row = 1;
while (row <= it.LOCLevel)
{
spacestr += " ";
row++;
}
sb.Append("<tr class=\"text-c\" id=\"" + it.LOCNo + "\">");
sb.Append("<td style=\"text-align:center;\">" + r.ToString() + "</td>");
sb.Append("<td style=\"text-align:left;\">" + it.LOCNo + "</td>");
sb.Append("<td style=\"text-align:left;\">" + spacestr + it.LOCName + "</td>");
sb.Append("<td style=\"text-align:left;\">" + it.ParentLOCName + "</td>");
sb.Append("</tr>");
r++;
}
sb.Append("</tbody>");
sb.Append("</table>");
return(sb.ToString());
}
private string insertaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessLocation bc = new project.Business.Base.BusinessLocation();
bc.load(jp.getValue("id"));
collection.Add(new JsonStringValue("LOCNo", bc.Entity.LOCNo));
collection.Add(new JsonStringValue("LOCName", bc.Entity.LOCName));
}
catch
{ flag = "2"; }
collection.Add(new JsonStringValue("type", "insert"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
private string submitaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessLocation bc = new project.Business.Base.BusinessLocation();
if (jp.getValue("tp") == "update")
{
bc.load(jp.getValue("id"));
bc.Entity.LOCName = jp.getValue("LOCName");
bc.Entity.ParentLOCNo = jp.getValue("ParentLOCNo");
if (bc.Entity.ParentLOCNo == "")
{
bc.Entity.LOCLevel = 1;
}
else
{
Business.Base.BusinessLocation loc = new Business.Base.BusinessLocation();
loc.load(bc.Entity.ParentLOCNo);
bc.Entity.LOCLevel = loc.Entity.LOCLevel + 1;
}
int r = bc.Save("update");
if (r <= 0)
{
flag = "2";
}
}
else
{
Data obj = new Data();
DataTable dt = obj.PopulateDataSet("select cnt=COUNT(*) from Mstr_Location where LOCNo='" + jp.getValue("LOCNo") + "'").Tables[0];
if (int.Parse(dt.Rows[0]["cnt"].ToString()) > 0)
{
flag = "3";
}
else
{
bc.Entity.LOCNo = jp.getValue("LOCNo");
bc.Entity.LOCName = jp.getValue("LOCName");
bc.Entity.ParentLOCNo = jp.getValue("ParentLOCNo");
if (bc.Entity.ParentLOCNo == "")
{
bc.Entity.LOCLevel = 1;
}
else
{
Business.Base.BusinessLocation loc = new Business.Base.BusinessLocation();
loc.load(bc.Entity.ParentLOCNo);
bc.Entity.LOCLevel = loc.Entity.LOCLevel + 1;
}
int r = bc.Save("insert");
if (r <= 0)
{
flag = "2";
}
}
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "submit"));
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("liststr", createList()));
return(collection.ToString());
}
private string createList(string Name, int page)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder("");
try
{
if (Request.QueryString["type"] == "user")
{
sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">");
sb.Append("<thead>");
sb.Append("<tr class=\"text-c\">");
sb.Append("<th width='35%'>用户编号</th>");
sb.Append("<th width='65%'>用户名称</th>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
Business.Sys.BusinessUserInfo pt = new project.Business.Sys.BusinessUserInfo();
foreach (Entity.Sys.EntityUserInfo it in pt.GetUserInfoListQuery(string.Empty, Name, page, 15))
{
sb.Append("<tr class=\"text-c\" id='" + it.UserNo + "' onclick='submit(\"" + it.UserNo + "\")'>");
sb.Append("<td style='white-space: nowrap;'>" + it.UserNo + "<input type='hidden' id='it" + it.UserNo + "' value='" + it.UserName + "' /></td>");
sb.Append("<td style='white-space: nowrap;'>" + it.UserName + "</td>");
sb.Append("</tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append(Paginat(pt.GetUserInfoListCount(string.Empty, Name), 15, page, 5));
}
else if (Request.QueryString["type"] == "SRVType")
{
sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">");
sb.Append("<thead>");
sb.Append("<tr class=\"text-c\">");
sb.Append("<th width='35%'>服务类型编号</th>");
sb.Append("<th width='65%'>服务类型名称</th>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
Business.Base.BusinessServiceType pt = new project.Business.Base.BusinessServiceType();
foreach (Entity.Base.EntityServiceType it in pt.GetListQuery(string.Empty, Name, "null", string.Empty, true, page, 15))
{
sb.Append("<tr class=\"text-c\" id='" + it.SRVTypeNo + "' onclick='submit(\"" + it.SRVTypeNo + "\")'>");
sb.Append("<td style='white-space: nowrap;'>" + it.SRVTypeNo + "<input type='hidden' id='it" + it.SRVTypeNo + "' value='" + it.SRVTypeName + "' /></td>");
sb.Append("<td style='white-space: nowrap;'>" + it.SRVTypeName + "</td>");
sb.Append("</tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append(Paginat(pt.GetListCount(string.Empty, Name, "null", string.Empty, true), 15, page, 5));
}
else if (Request.QueryString["type"] == "LOC")
{
sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">");
sb.Append("<thead>");
sb.Append("<tr class=\"text-c\">");
sb.Append("<th width='35%'>编号</th>");
sb.Append("<th width='65%'>名称</th>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
Business.Base.BusinessLocation pt = new project.Business.Base.BusinessLocation();
foreach (Entity.Base.EntityLocation it in pt.GetListQuery(string.Empty, Name, string.Empty, page, 15))
{
string spacestr = "";
int row = 1;
while (row <= it.LOCLevel)
{
spacestr += " ";
row++;
}
sb.Append("<tr class=\"text-c\" id='" + it.LOCNo + "' onclick='submit(\"" + it.LOCNo + "\")'>");
sb.Append("<td style=\"white-space: nowrap;text-align:left;\">" + it.LOCNo + "<input type='hidden' id='it" + it.LOCNo + "' value='" + it.LOCName + "' /></td>");
sb.Append("<td style=\"white-space: nowrap;text-align:left;\">" + spacestr + it.LOCName + "</td>");
sb.Append("</tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append(Paginat(pt.GetListCount(string.Empty, Name, string.Empty), 15, page, 5));
}
else if (Request.QueryString["type"] == "Cust")
{
sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">");
sb.Append("<thead>");
sb.Append("<tr class=\"text-c\">");
sb.Append("<th width='35%'>客户编号</th>");
sb.Append("<th width='65%'>客户名称</th>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
Business.Base.BusinessCustomer pt = new project.Business.Base.BusinessCustomer();
foreach (Entity.Base.EntityCustomer it in pt.GetListQuery(string.Empty, Name, string.Empty, string.Empty, page, 15))
{
sb.Append("<tr class=\"text-c\" id='" + it.CustNo + "' onclick='submit(\"" + it.CustNo + "\")'>");
sb.Append("<td style='white-space: nowrap;'>" + it.CustNo + "<input type='hidden' id='it" + it.CustNo + "' value='" + it.CustName + "' /></td>");
sb.Append("<td style='white-space: nowrap;'>" + it.CustName + "</td>");
sb.Append("</tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append(Paginat(pt.GetListCount(string.Empty, Name, string.Empty, string.Empty), 15, page, 5));
}
else if (Request.QueryString["type"] == "Billboard")
{
sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">");
sb.Append("<thead>");
sb.Append("<tr class=\"text-c\">");
sb.Append("<th width='20%'>广告位编号</th>");
sb.Append("<th width='25%'>广告位名称</th>");
sb.Append("<th width='40%'>位置</th>");
sb.Append("<th width='15%'>广告位类型</th>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
Business.Base.BusinessBillboard pt = new project.Business.Base.BusinessBillboard();
foreach (Entity.Base.EntityBillboard it in pt.GetListQuery(string.Empty, Name, string.Empty, string.Empty, string.Empty, string.Empty, page, 15))
{
sb.Append("<tr class=\"text-c\" id='" + it.BBNo + "' onclick='submit(\"" + it.BBNo + "\")'>");
sb.Append("<td style='white-space: nowrap;'>" + it.BBNo + "<input type='hidden' id='it" + it.BBNo + "' value='" + it.BBName + "' /></td>");
sb.Append("<td style='white-space: nowrap;'>" + it.BBName + "</td>");
sb.Append("<td style='white-space: nowrap;'>" + it.BBAddr + "</td>");
sb.Append("<td style='white-space: nowrap;'>" + it.BBTypeName + "</td>");
sb.Append("</tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append(Paginat(pt.GetListCount(string.Empty, Name, string.Empty, string.Empty, string.Empty, string.Empty), 15, page, 5));
}
}
catch { }
return(sb.ToString());
}
