private string detailaction(JsonArrayParse jp) { System.Text.StringBuilder sb = new System.Text.StringBuilder(""); JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Order.BusinessWorkOrderCost bc = new project.Business.Order.BusinessWorkOrderCost(); bc.load(jp.getValue("id"), user.Entity.AccID); 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='15%'>填写人</th>"); sb.Append("<th width='16%'>费用项目</th>"); sb.Append("<th width='30%'>说明</th>"); sb.Append("<th width='16%'>费用金额</th>"); sb.Append("<th width='18%'>操作</th>"); sb.Append("</tr>"); sb.Append("</thead>"); int r = 1; sb.Append("<tbody>"); Business.Order.BusinessWorkOrderCostDetail bc1 = new project.Business.Order.BusinessWorkOrderCostDetail(); foreach (Entity.Order.EntityWorkOrderCostDetail it in bc1.GetWorkOrderCostDetailQuery(user.Entity.AccID, bc.Entity.CostNo, bc.Entity.OrderNo, string.Empty, string.Empty, default(DateTime), default(DateTime))) { sb.Append("<tr class=\"text-c\" id=\"" + it.InnerEntityOID + "\">"); sb.Append("<td align='center'>" + r.ToString() + "</td>"); sb.Append("<td>" + it.UserName + "</td>"); sb.Append("<td>" + it.CostTypeName + "</td>"); if (bc.Entity.Status == "OPEN") { sb.Append("<td><input type=\"text\" class=\"input-text size-S\" style=\"width:100%\" placeholder=\"\" id=\"Cont" + it.InnerEntityOID + "\" value=\"" + it.Context + "\"></td>"); sb.Append("<td><input type=\"text\" class=\"input-text size-S\" style=\"width:100%\" placeholder=\"\" onblur=\"validDecimal(this.id)\" id=\"Amt" + it.InnerEntityOID + "\" value=\"" + it.CostAmount.ToString("0.##") + "\"></td>"); sb.Append("<td><a href=\"javascript:;\" onclick=\"save('" + it.InnerEntityOID + "')\" class=\"btn btn-primary radius\"><i class=\"Hui-iconfont\"></i> 保存</a></td>"); } else { sb.Append("<td>" + it.Context + "</td>"); sb.Append("<td>" + it.CostAmount.ToString("0.##") + "</td>"); sb.Append("<td></td>"); } sb.Append("</tr>"); r++; } sb.Append("</tbody>"); sb.Append("</table>"); collection.Add(new JsonStringValue("liststr", sb.ToString())); } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "detail")); collection.Add(new JsonStringValue("flag", flag)); return(collection.ToString()); }
private string createList(string OrderNo, string Status, string MinCostDate, string MaxCostDate, 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='17%'>工单日期</th>"); sb.Append("<th width='17%'>工单号</th>"); sb.Append("<th width='32%'>工单内容</th>"); sb.Append("<th width='17%'>费用金额</th>"); sb.Append("<th width='12%'>状态</th>"); sb.Append("</tr>"); sb.Append("</thead>"); DateTime MinCostDateS = default(DateTime); DateTime MaxCostDateS = default(DateTime); if (MinCostDate != "") { MinCostDateS = ParseDateForString(MinCostDate); } if (MaxCostDate != "") { MaxCostDateS = ParseDateForString(MaxCostDate); } int r = 1; sb.Append("<tbody>"); Business.Order.BusinessWorkOrderCost bc = new project.Business.Order.BusinessWorkOrderCost(); foreach (Entity.Order.EntityWorkOrderCost it in bc.GetWorkOrderCostQuery(user.Entity.AccID, string.Empty, OrderNo, Status, MinCostDateS, MaxCostDateS, "1", page, pageSize)) { sb.Append("<tr class=\"text-c\" id=\"" + it.InnerEntityOID + "\">"); sb.Append("<td align='center'>" + r.ToString() + "</td>"); sb.Append("<td>" + it.OrderDate.ToString("MM-dd HH:mm") + "</td>"); sb.Append("<td>" + it.OrderNo + "</td>"); sb.Append("<td>" + it.OrderName + "</td>"); sb.Append("<td>" + it.CostAmount.ToString("0.##") + "</td>"); sb.Append("<td class=\"td-status\"><span class=\"label " + (it.Status == "OPEN" ? "" : "label-success") + " radius\">" + it.StatusName + "</span></td>"); sb.Append("</tr>"); r++; } sb.Append("</tbody>"); sb.Append("</table>"); sb.Append(Paginat(bc.GetWorkOrderCostCount(user.Entity.AccID, string.Empty, OrderNo, Status, MinCostDateS, MaxCostDateS, "1"), pageSize, page, 7)); return(sb.ToString()); }
private string approveaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Order.BusinessWorkOrderCost bc = new project.Business.Order.BusinessWorkOrderCost(); bc.load(jp.getValue("id"), user.Entity.AccID); if (bc.Entity.Status.ToUpper() == "CONFIRM") { flag = "3"; } else { if (bc.Entity.Status == "OPEN") { bc.Entity.Status = "APPROVE"; } else { bc.Entity.Status = "OPEN"; } int row = bc.Save(); if (row <= 0) { flag = "2"; } else { collection.Add(new JsonStringValue("liststr", createList(jp.getValue("OrderNo"), jp.getValue("Status"), jp.getValue("MinCostDate"), jp.getValue("MaxCostDate"), int.Parse(jp.getValue("page"))))); } } } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "approve")); collection.Add(new JsonStringValue("flag", flag)); return(collection.ToString()); }
private string saveaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Order.BusinessWorkOrderCost bc = new project.Business.Order.BusinessWorkOrderCost(); bc.load(jp.getValue("id"), user.Entity.AccID); if (bc.Entity.Status.ToUpper() != "OPEN") { flag = "3"; } else { Business.Order.BusinessWorkOrderCostDetail detail = new Business.Order.BusinessWorkOrderCostDetail(); detail.load(jp.getValue("detailid"), user.Entity.AccID); detail.Entity.Context = jp.getValue("Context"); detail.Entity.CostAmount = ParseDecimalForString(jp.getValue("Amount")); detail.Entity.UpdateDate = GetDate(); detail.Entity.UpdateUser = user.Entity.UserNo; int row = detail.Save(); if (row <= 0) { flag = "2"; } else { obj.ExecuteNonQuery("update WO_WorkOrder_Cost set CostAmount = isnull((select SUM(CostAmount) from WO_WorkOrder_Cost_Detail where CostNo='" + bc.Entity.CostNo + "'),0) " + "where CostNo = '" + bc.Entity.CostNo + "'"); } } } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "save")); collection.Add(new JsonStringValue("flag", flag)); return(collection.ToString()); }