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=\"10%\">序号</th>");
sb.Append("<th width='20%'>编号</th>");
sb.Append("<th width='30%'>名称</th>");
sb.Append("<th width='30%'>U8科目编号</th>");
sb.Append("<th width='10%'>状态</th>");
sb.Append("</tr>");
sb.Append("</thead>");
int r = 1;
sb.Append("<tbody>");
Business.Base.BusinessBank bc = new project.Business.Base.BusinessBank();
foreach (Entity.Base.EntityBank it in bc.GetListQuery(string.Empty, string.Empty, null))
{
sb.Append("<tr class=\"text-c\" id=\"" + it.BankNo + "\">");
sb.Append("<td style=\"text-align:center;\">" + r.ToString() + "</td>");
sb.Append("<td style=\"text-align:left;\">" + it.BankNo + "</td>");
sb.Append("<td style=\"text-align:left;\">" + it.BankName + "</td>");
sb.Append("<td style=\"text-align:left;\">" + it.BankAccount + "</td>");
sb.Append("<td class=\"td-status\"><span class=\"label " + (it.Valid ? "label-success" : "") + " radius\">" + (it.Valid ? "正常" : "禁用") + "</span></td>");
sb.Append("</tr>");
r++;
}
sb.Append("</tbody>");
sb.Append("</table>");
return(sb.ToString());
}
private string validaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessBank bc = new project.Business.Base.BusinessBank();
bc.load(jp.getValue("id"));
bc.Entity.Valid = !bc.Entity.Valid;
int r = bc.Save("update");
if (r <= 0)
{
flag = "2";
}
if (!bc.Entity.Valid)
{
collection.Add(new JsonStringValue("stat", "<span class=\"label radius\">禁用</span>"));
}
else
{
collection.Add(new JsonStringValue("stat", "<span class=\"label label-success radius\">正常</span>"));
}
collection.Add(new JsonStringValue("id", jp.getValue("id")));
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "valid"));
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("liststr", createList()));
return(collection.ToString());
}
private string deleteaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessBank bc = new project.Business.Base.BusinessBank();
bc.load(jp.getValue("id"));
if (obj.PopulateDataSet("select 1 from Op_OrderFeeReceiver where ODPaidBankNo='" + bc.Entity.BankNo + "'").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 submitaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessBank bc = new project.Business.Base.BusinessBank();
if (jp.getValue("tp") == "update")
{
bc.load(jp.getValue("id"));
bc.Entity.BankName = jp.getValue("BankName");
bc.Entity.BankAccount = jp.getValue("BankAccount");
int r = bc.Save("update");
if (r <= 0)
{
flag = "2";
}
}
else
{
Data obj = new Data();
DataTable dt = obj.PopulateDataSet("select cnt=COUNT(*) from Mstr_Bank where BankNo='" + jp.getValue("BankNo") + "'").Tables[0];
if (int.Parse(dt.Rows[0]["cnt"].ToString()) > 0)
{
flag = "3";
}
else
{
bc.Entity.BankNo = jp.getValue("BankNo");
bc.Entity.BankName = jp.getValue("BankName");
bc.Entity.BankAccount = jp.getValue("BankAccount");
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 updateaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessBank bc = new project.Business.Base.BusinessBank();
bc.load(jp.getValue("id"));
collection.Add(new JsonStringValue("BankNo", bc.Entity.BankNo));
collection.Add(new JsonStringValue("BankName", bc.Entity.BankName));
collection.Add(new JsonStringValue("BankAccount", bc.Entity.BankAccount));
}
catch
{ flag = "2"; }
collection.Add(new JsonStringValue("type", "update"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
