private string createList(string SRVNo, string SRVName, string SRVTypeNo1, string SRVTypeNo2, string SRVSPNo, 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=\"5%\">序号</th>");
sb.Append("<th width='8%'>费用编号</th>");
sb.Append("<th width='10%'>费用名称</th>");
sb.Append("<th width='8%'>服务大类</th>");
sb.Append("<th width='8%'>服务子类</th>");
sb.Append("<th width='8%'>服务商</th>");
sb.Append("<th width='8%'>公式编号</th>");
sb.Append("<th width='8%'>费用单价</th>");
sb.Append("<th width='8%'>取整方式</th>");
sb.Append("<th width='10%'>财务科目编号</th>");
sb.Append("<th width='10%'>财务科目名称</th>");
//sb.Append("<th width='15%'>备注</th>");
sb.Append("<th width='5%'>状态</th>");
sb.Append("</tr>");
sb.Append("</thead>");
int r = 1;
sb.Append("<tbody>");
Business.Base.BusinessService bc = new project.Business.Base.BusinessService();
foreach (Entity.Base.EntityService it in bc.GetListQuery(SRVNo, SRVName, SRVTypeNo1, SRVTypeNo2, SRVSPNo, page, pageSize))
{
sb.Append("<tr class=\"text-c\" id=\"" + it.SRVNo + "\">");
sb.Append("<td align='center'>" + r.ToString() + "</td>");
sb.Append("<td>" + it.SRVNo + "</td>");
sb.Append("<td>" + it.SRVName + "</td>");
sb.Append("<td>" + it.SRVTypeNo1Name + "</td>");
sb.Append("<td>" + it.SRVTypeNo2Name + "</td>");
sb.Append("<td>" + it.SRVSPName + "</td>");
sb.Append("<td>" + it.SRVFormulaID + "</td>");
sb.Append("<td>" + it.SRVPrice.ToString("0.####") + "</td>");
sb.Append("<td>" + it.SRVRoundTypeName + "</td>");
sb.Append("<td>" + it.SRVFinanceFeeCode + "</td>");
sb.Append("<td>" + it.SRVFinanceFeeName + "</td>");
//sb.Append("<td>" + it.SRVRemark + "</td>");
sb.Append("<td class=\"td-status\"><span class=\"label " + (it.SRVStatus ? "label-success" : "") + " radius\">" + (it.SRVStatus ? "有效" : "已失效") + "</span></td>");
sb.Append("</tr>");
r++;
}
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append(Paginat(bc.GetListCount(SRVNo, SRVName, SRVTypeNo1, SRVTypeNo2, SRVSPNo), pageSize, page, 7));
return(sb.ToString());
}
private string updateaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
int flag = 0;
try
{
Business.Base.BusinessService bs = new project.Business.Base.BusinessService();
bs.load(jp.getValue("id"));
collection.Add(new JsonStringValue("data", JsonConvert.SerializeObject(bs.Entity)));
}
catch (Exception ex)
{
flag = 2;
collection.Add(new JsonStringValue("ex", ex.ToString()));
}
collection.Add(new JsonStringValue("type", "update"));
collection.Add(new JsonNumericValue("flag", flag));
return(collection.ToString());
}
private string deleteaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
int flag = 0;
try
{
Business.Base.BusinessService bs = new project.Business.Base.BusinessService();
bs.load(jp.getValue("id"));
if (bs.delete() <= 0)
{
flag = 1;
}
}
catch (Exception ex)
{
flag = 2;
collection.Add(new JsonStringValue("ex", ex.ToString()));
}
collection.Add(new JsonStringValue("type", "delete"));
collection.Add(new JsonNumericValue("flag", flag));
return(collection.ToString());
}
private string validaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
int flag = 0;
try
{
Business.Base.BusinessService bc = new project.Business.Base.BusinessService();
bc.load(jp.getValue("id"));
bc.Entity.SRVStatus = !bc.Entity.SRVStatus;
if (bc.valid() <= 0)
{
flag = 1;
}
else
{
if (bc.Entity.SRVStatus)
{
collection.Add(new JsonStringValue("stat", "<span class=\"label label-success radius\">有效</span>"));
}
else
{
collection.Add(new JsonStringValue("stat", "<span class=\"label radius\">已失效</span>"));
}
}
}
catch (Exception ex)
{
flag = 2;
collection.Add(new JsonStringValue("ex", ex.ToString()));
}
collection.Add(new JsonStringValue("id", jp.getValue("id")));
collection.Add(new JsonStringValue("type", "valid"));
collection.Add(new JsonNumericValue("flag", flag));
return(collection.ToString());
}
public string GenOrderFromConferenceRepair(string ResourceNo, string ResourceName, decimal amount, string Remark, string KEY)
{
if (KEY != "6E5F0C851FD4")
{
return("");
}
string InfoMsg = "";
try
{
string prefix = GetDate().ToString("yyyyMM");
string OrderNo = "";
DataTable dt = obj.PopulateDataSet("select top 1 OrderNo from Op_OrderHeader where OrderNo like '" + prefix + "%' order by OrderNo desc").Tables[0];
if (dt.Rows.Count > 0)
{
try
{
long num = long.Parse(dt.Rows[0]["OrderNo"].ToString());
OrderNo = (num + 1).ToString();
}
catch
{
OrderNo = prefix + "00001";
}
}
else
{
OrderNo = prefix + "00001";
}
DateTime now = GetDate();
string id = System.Guid.NewGuid().ToString();
project.Business.Op.BusinessOrderHeader bc = new project.Business.Op.BusinessOrderHeader();
bc.Entity.RowPointer = id;
bc.Entity.OrderNo = OrderNo;
bc.Entity.OrderType = "10";
bc.Entity.CustNo = "22222";
bc.Entity.OrderTime = now.AddDays(-now.Day + 1);
bc.Entity.DaysofMonth = ParseDateForString(now.AddMonths(1).ToString("yyyy-MM") + "-01").AddDays(-1).Day;
bc.Entity.ARDate = now;
bc.Entity.ARAmount = amount;
bc.Entity.ReduceAmount = 0;
bc.Entity.PaidinAmount = 0;
bc.Entity.Remark = Remark;
bc.Entity.OrderCreator = "艾众管家";
bc.Entity.OrderCreateDate = now;
bc.Entity.OrderLastReviser = "艾众管家";
bc.Entity.OrderLastRevisedDate = now;
bc.Entity.OrderStatus = "0";
bc.Save("insert");
project.Business.Base.BusinessService bs = new project.Business.Base.BusinessService();
bs.load("HYSZJ-59");
project.Business.Op.BusinessOrderDetail detail = new project.Business.Op.BusinessOrderDetail();
detail.Entity.RefRP = id;
detail.Entity.ODSRVTypeNo1 = bs.Entity.SRVTypeNo1;
detail.Entity.ODSRVTypeNo2 = bs.Entity.SRVTypeNo2;
detail.Entity.ODSRVNo = bs.Entity.SRVNo;
detail.Entity.ODContractSPNo = bs.Entity.SRVSPNo;
detail.Entity.ResourceNo = ResourceNo;
detail.Entity.ResourceName = ResourceName;
detail.Entity.ODFeeStartDate = now;
detail.Entity.ODFeeEndDate = now;
detail.Entity.BillingDays = 1;
detail.Entity.ODQTY = 1;
detail.Entity.ODUnit = "";
detail.Entity.ODUnitPrice = amount;
detail.Entity.ODARAmount = amount;
detail.Entity.ODCANo = bs.Entity.CANo;
detail.Entity.ODCreator = "艾众管家";
detail.Entity.ODCreateDate = now;
detail.Entity.ODLastReviser = "艾众管家";
detail.Entity.ODLastRevisedDate = now;
detail.Entity.ODTaxRate = bs.Entity.SRVTaxRate;
detail.Entity.ODTaxAmount = amount - Math.Round(amount / (1 + bs.Entity.SRVTaxRate), 2);
detail.Save();
}
catch (Exception ex)
{
InfoMsg = ex.Message;
}
return(InfoMsg);
}
