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='45%'>费用科目</th>");
sb.Append("<th width='45%'>对应违约金科目</th>");
sb.Append("</tr>");
sb.Append("</thead>");
int r = 1;
sb.Append("<tbody>");
Business.Base.BusinessLateFee bc = new project.Business.Base.BusinessLateFee();
foreach (Entity.Base.EntityLateFee it in bc.GetListQuery(string.Empty))
{
sb.Append("<tr class=\"text-c\" id=\"" + it.RowPointer + "\">");
sb.Append("<td style=\"text-align:center;\">" + r.ToString() + "</td>");
sb.Append("<td style=\"text-align:left;\">" + it.SRVName + "</td>");
sb.Append("<td style=\"text-align:left;\">" + it.LateFeeSRVName + "</td>");
sb.Append("</tr>");
r++;
}
sb.Append("</tbody>");
sb.Append("</table>");
return(sb.ToString());
}
private string updateaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessLateFee bc = new project.Business.Base.BusinessLateFee();
bc.load(jp.getValue("id"));
collection.Add(new JsonStringValue("SPNo", bc.Entity.SPNo));
collection.Add(new JsonStringValue("SRVNo", bc.Entity.SRVNo));
collection.Add(new JsonStringValue("LateFeeSRVNo", bc.Entity.LateFeeSRVNo));
StringBuilder sb = new StringBuilder("SELECT SRVNo,SRVName FROM Mstr_Service WHERE SRVStatus=1 ");
sb.AppendFormat("AND SRVSPNo='{0}' ", bc.Entity.SPNo);
string fee = JsonConvert.SerializeObject(obj.PopulateDataSet(sb.ToString() + "AND SRVTypeNo1!='FWLB-007'").Tables[0]);
string lateFee = JsonConvert.SerializeObject(obj.PopulateDataSet(sb.ToString() + "AND SRVTypeNo1='FWLB-007'").Tables[0]);
collection.Add(new JsonStringValue("FeeList", fee));
collection.Add(new JsonStringValue("LateFeeList", lateFee));
}
catch
{ flag = "2"; }
collection.Add(new JsonStringValue("type", "update"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
private string createList(string SPNo, string SRVNo, string SRVName, string LateSRVName, int page)
{
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%'>对应违约金科目</th>");
sb.Append("</tr>");
sb.Append("</thead>");
int r = 1;
sb.Append("<tbody>");
Business.Base.BusinessLateFee bc = new project.Business.Base.BusinessLateFee();
foreach (Entity.Base.EntityLateFee it in bc.GetListQuery(SPNo, SRVNo, SRVName, LateSRVName, page, pageSize))
{
sb.Append("<tr class=\"text-c\" id=\"" + it.RowPointer + "\">");
sb.Append("<td style=\"text-align:center;\">" + r.ToString() + "</td>");
sb.Append("<td style=\"text-align:left;\">" + it.SPShortName + "</td>");
sb.Append("<td style=\"text-align:left;\">" + it.SRVName + "</td>");
sb.Append("<td style=\"text-align:left;\">" + it.LateFeeSRVName + "</td>");
sb.Append("</tr>");
r++;
}
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append(Paginat(bc.GetListCount(SPNo, SRVNo, SRVName, LateSRVName), pageSize, page, 7));
return(sb.ToString());
}
private string submitaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessLateFee bc = new project.Business.Base.BusinessLateFee();
if (jp.getValue("tp") == "update")
{
bc.load(jp.getValue("id"));
bc.Entity.SPNo = jp.getValue("SPNo");
bc.Entity.SRVNo = jp.getValue("SRVNo");
bc.Entity.LateFeeSRVNo = jp.getValue("LateFeeSRVNo");
bc.Entity.UpdateUser = user.Entity.UserName;
bc.Entity.UpdateDate = GetDate();
int r = bc.Save();
if (r <= 0)
{
flag = "2";
}
}
else
{
Data obj = new Data();
DataTable dt = obj.PopulateDataSet("select cnt=COUNT(*) from Mstr_LateFee where SRVNo='" + jp.getValue("SRVNo") + "'").Tables[0];
if (int.Parse(dt.Rows[0]["cnt"].ToString()) > 0)
{
flag = "3";
}
else
{
bc.Entity.SPNo = jp.getValue("SPNo");
bc.Entity.SRVNo = jp.getValue("SRVNo");
bc.Entity.LateFeeSRVNo = jp.getValue("LateFeeSRVNo");
bc.Entity.CreateUser = user.Entity.UserName;
bc.Entity.CreateDate = GetDate();
bc.Entity.UpdateUser = user.Entity.UserName;
bc.Entity.UpdateDate = GetDate();
int r = bc.Save();
if (r <= 0)
{
flag = "2";
}
}
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "submit"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
private string updateaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessLateFee bc = new project.Business.Base.BusinessLateFee();
bc.load(jp.getValue("id"));
collection.Add(new JsonStringValue("SRVNo", bc.Entity.SRVNo));
collection.Add(new JsonStringValue("LateFeeSRVNo", bc.Entity.LateFeeSRVNo));
}
catch
{ flag = "2"; }
collection.Add(new JsonStringValue("type", "update"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
private string deleteaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessLateFee bc = new project.Business.Base.BusinessLateFee();
bc.load(jp.getValue("id"));
int r = bc.delete();
if (r <= 0)
{
flag = "2";
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "delete"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
