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