private string deleteaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessOrderType bc = new project.Business.Base.BusinessOrderType(); bc.load(jp.getValue("id"), user.Entity.AccID); if (obj.ExecuteDataSet("select 1 from WO_WorkOrder where OrderType='" + bc.Entity.OrderTypeNo + "' and AccID='" + user.Entity.AccID + "'").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 createList(string OrderTypeName) { 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='35%'>订单类型编号</th>"); sb.Append("<th width='60%'>订单类型名称</th>"); sb.Append("</tr>"); sb.Append("</thead>"); int r = 1; sb.Append("<tbody>"); Business.Base.BusinessOrderType bc = new project.Business.Base.BusinessOrderType(); foreach (Entity.Base.EntityOrderType it in bc.GetListQuery(string.Empty, OrderTypeName)) { sb.Append("<tr class=\"text-c\" id=\"" + it.OrderTypeNo + "\">"); sb.Append("<td style=\"text-align:center;\">" + r.ToString() + "</td>"); sb.Append("<td style=\"text-align:left;\">" + it.OrderTypeNo + "</td>"); sb.Append("<td style=\"text-align:left;\">" + it.OrderTypeName + "</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"; string result = "";; try { Business.Base.BusinessOrderType bc = new project.Business.Base.BusinessOrderType(); bc.load(jp.getValue("id"), user.Entity.AccID); collection.Add(new JsonStringValue("OrderTypeNo", bc.Entity.OrderTypeNo)); collection.Add(new JsonStringValue("OrderTypeName", bc.Entity.OrderTypeName)); collection.Add(new JsonStringValue("FlowNo", bc.Entity.FlowNo)); } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "update")); collection.Add(new JsonStringValue("flag", flag)); result = collection.ToString(); return(result); }
private string deleteaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessOrderType bc = new project.Business.Base.BusinessOrderType(); bc.load(jp.getValue("id")); //if (obj.PopulateDataSet("select 1 from Mstr_Billboard where OrderType='" + bc.Entity.OrderTypeNo + "'").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(jp.getValue("OrderTypeNameS")))); return(collection.ToString()); }
private string submitaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessOrderType bc = new project.Business.Base.BusinessOrderType(); if (jp.getValue("tp") == "update") { bc.load(jp.getValue("id"), user.Entity.AccID); bc.Entity.OrderTypeName = jp.getValue("OrderTypeName"); bc.Entity.FlowNo = jp.getValue("FlowNo"); int r = bc.Save("update"); if (r <= 0) { flag = "2"; } } else { Data obj = new Data(); DataTable dt = obj.ExecuteDataSet("select 1 from Base_Order_Type where OrderTypeNo=N'" + jp.getValue("OrderTypeNo") + "' and AccID='" + user.Entity.AccID + "'").Tables[0]; if (dt.Rows.Count > 0) { flag = "3"; } else { bc.Entity.OrderTypeNo = jp.getValue("OrderTypeNo"); bc.Entity.OrderTypeName = jp.getValue("OrderTypeName"); bc.Entity.FlowNo = jp.getValue("FlowNo"); bc.Entity.AccID = user.Entity.AccID; 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 submitaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessOrderType bc = new project.Business.Base.BusinessOrderType(); if (jp.getValue("tp") == "update") { bc.load(jp.getValue("id")); bc.Entity.OrderTypeName = jp.getValue("OrderTypeName"); int r = bc.Save("update"); if (r <= 0) { flag = "2"; } } else { Data obj = new Data(); DataTable dt = obj.PopulateDataSet("select cnt=COUNT(*) from Mstr_OrderType where OrderTypeNo='" + jp.getValue("OrderTypeNo") + "'").Tables[0]; if (int.Parse(dt.Rows[0]["cnt"].ToString()) > 0) { flag = "3"; } else { bc.Entity.OrderTypeNo = jp.getValue("OrderTypeNo"); bc.Entity.OrderTypeName = jp.getValue("OrderTypeName"); 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(jp.getValue("OrderTypeNameS")))); return(collection.ToString()); }
protected override void Page_Load(object sender, EventArgs e) { try { HttpCookie hc = getCookie("1"); if (hc != null) { string str = hc.Value.Replace("%3D", "="); userid = Encrypt.DecryptDES(str, "1"); user.load(userid); CheckRight(user.Entity, "order/WorkOrderWarning.aspx"); if (!Page.IsCallback) { orderType = "<select class=\"input-text required size-S\" id=\"OrderType\" style=\"width:120px\" data-valid=\"\" data-error=\"\">"; orderType += "<option value=\"\" selected>请选择工单类型</option>"; Business.Base.BusinessOrderType type = new project.Business.Base.BusinessOrderType(); foreach (Entity.Base.EntityOrderType it in type.GetOrderTypeListQuery(string.Empty, string.Empty, string.Empty, user.Entity.AccID)) { orderType += "<option value='" + it.OrderTypeNo + "'>" + it.OrderTypeName + "</option>"; } orderType += "</select>"; list = createList(string.Empty, string.Empty, string.Empty, string.Empty, GetDate().ToString("yyyy-MM-dd"), GetDate().ToString("yyyy-MM-dd")); } } else { GotoErrorPage(); } } catch { GotoErrorPage(); } }
protected override void Page_Load(object sender, EventArgs e) { try { HttpCookie hc = getCookie("1"); if (hc != null) { string str = hc.Value.Replace("%3D", "="); userid = Encrypt.DecryptDES(str, "1"); user.load(userid); if (!Page.IsCallback) { CheckRight(user.Entity, "Order/WorkOrder.aspx"); list = createList(string.Empty, string.Empty, GetDate().AddDays(-GetDate().Day + 1).ToString("yyyy-MM-dd"), GetDate().ToString("yyyy-MM-dd"), string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, "", "", 1); orderType = "<select class=\"input-text required\" id=\"OrderType\" data-valid=\"isNonEmpty\" data-error=\"请选择工单类型\">"; orderType += "<option value=\"\" selected>请选择工单类型</option>"; orderTypeS = "<select class=\"input-text required\" id=\"OrderTypeS\" style=\"width:100px\">"; orderTypeS += "<option value=\"\" selected>全部</option>"; Business.Base.BusinessOrderType type = new project.Business.Base.BusinessOrderType(); foreach (Entity.Base.EntityOrderType it in type.GetOrderTypeListQuery(string.Empty, string.Empty, string.Empty, user.Entity.AccID)) { orderType += "<option value='" + it.OrderTypeNo + "'>" + it.OrderTypeName + "</option>"; orderTypeS += "<option value='" + it.OrderTypeNo + "'>" + it.OrderTypeName + "</option>"; } orderType += "</select>"; orderTypeS += "</select>"; alloDept = "<select class=\"input-text required size-S\" id=\"AlloDeptS\" style=\"width:100px\" data-valid=\"isNonEmpty\" data-error=\"请选择\">"; alloDept += "<option value=\"\" selected>请选择</option>"; Business.Sys.BusinessDept allodt = new project.Business.Sys.BusinessDept(); foreach (Entity.Sys.EntityDept it in allodt.GetDeptListQuery(string.Empty, string.Empty, user.Entity.AccID, string.Empty)) { alloDept += "<option value='" + it.DeptNo + "'>" + it.DeptName + "</option>"; } alloDept += "</select>"; alloUser = "******"input-text required size-S\" id=\"AlloUserS\" style=\"width:100px\" data-valid=\"isNonEmpty\" data-error=\"请选择\">"; alloUser += "<option value=\"\" selected>请选择</option>"; Business.Sys.BusinessUserInfo allous = new project.Business.Sys.BusinessUserInfo(); foreach (Entity.Sys.EntityUserInfo it in allous.GetUserInfoListQuery(string.Empty, user.Entity.AccID, string.Empty, string.Empty)) { alloUser += "<option value='" + it.UserNo + "'>" + it.UserName + "</option>"; } alloUser += "</select>"; region = "<select class=\"input-text required size-S\" id=\"RegionS\" style=\"width:80px\" data-valid=\"isNonEmpty\" data-error=\"请选择\">"; region += "<option value=\"\" selected>请选择</option>"; Business.Base.BusinessRegion reg = new project.Business.Base.BusinessRegion(); foreach (Entity.Base.EntityRegion it in reg.GetRegionListQuery(string.Empty, string.Empty, user.Entity.AccID, string.Empty)) { region += "<option value='" + it.RegionNo + "'>" + it.RegionName + "</option>"; } region += "</select>"; status = "<select class=\"input-text required size-S\" id=\"StatusS\" style=\"width:80px\" data-valid=\"\" data-error=\"\">"; status += "<option value=\"\" selected>请选择</option>"; Business.Base.BusinessStatus st = new project.Business.Base.BusinessStatus(); foreach (Entity.Base.EntityStatus it in st.GetStatusListQuery(string.Empty, string.Empty, user.Entity.AccID)) { status += "<option value='" + it.StatusNo + "'>" + it.StatusName + "</option>"; } status += "</select>"; } } else { GotoErrorPage(); } } catch { GotoErrorPage(); } }
private string createList(string Month, string ARDate, string EndDate, string OrderType) { 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("<td width='5%'><input type=\"checkbox\" class=\"input-text size-MINI\" id=\"checkall\" /></td>"); sb.Append("<th width='5%'>序号</th>"); sb.Append("<th width='11%'>订单编号</th>"); sb.Append("<th width='11%'>合同编号</th>"); sb.Append("<th width='17%'>费用项目</th>"); sb.Append("<th width='17%'>资源编号</th>"); sb.Append("<th width='12%'>未收款金额</th>"); sb.Append("<th width='10%'>天数</th>"); sb.Append("<th width='12%'>金额</th>"); sb.Append("</tr>"); sb.Append("</thead>"); string OrderTypes = ""; if (user.Entity.UserType.ToUpper() == "ADMIN") { Business.Base.BusinessOrderType bc1 = new project.Business.Base.BusinessOrderType(); foreach (Entity.Base.EntityOrderType it in bc1.GetListQuery(string.Empty, string.Empty)) { OrderTypes += it.OrderTypeNo + ","; } } else { string sqlstr1 = "select a.OrderType,b.OrderTypeName from Sys_UserOrderTypeRight a left join Mstr_OrderType b on a.OrderType=b.OrderTypeNo " + "where a.UserType='" + user.Entity.UserType + "'"; DataTable dt1 = obj.PopulateDataSet(sqlstr1).Tables[0]; foreach (DataRow dr in dt1.Rows) { OrderTypes += dr["OrderType"].ToString() + ","; } } if (OrderTypes == "") { OrderTypes = "''"; } if (OrderType == "") { OrderType = "%"; } int r = 1; sb.Append("<tbody id=\"tbody\">"); DataTable dt = GetUnLateFeeOrder_Proc(Month, ARDate, EndDate, OrderType, OrderTypes); foreach (DataRow dr in dt.Rows) { sb.Append("<tr class=\"text-c\">"); sb.Append("<td><input type=\"checkbox\" class=\"input-text size-MINI\" value=\"" + dr["RowPointer"].ToString() + "\" name=\"chk\" /></td>"); sb.Append("<td style=\"text-align:center;\">" + r.ToString() + "</td>"); sb.Append("<td>" + dr["OrderNo"].ToString() + "</td>"); sb.Append("<td>" + dr["ODContractNo"].ToString() + "</td>"); sb.Append("<td>" + dr["SRVName"].ToString() + "</td>"); sb.Append("<td>" + dr["ResourceNo"].ToString() + "</td>"); sb.Append("<td>" + ParseDecimalForString(dr["UnPaidAmount"].ToString()).ToString("0.##") + "</td>"); sb.Append("<td>" + dr["LateDays"].ToString() + "</td>"); sb.Append("<td>" + ParseDecimalForString(dr["LateAmount"].ToString()).ToString("0.##") + "</td>"); sb.Append("</tr>"); r++; } sb.Append("</tbody>"); sb.Append("</table>"); return(sb.ToString()); }
protected override void Page_Load(object sender, EventArgs e) { try { HttpCookie hc = getCookie("1"); if (hc != null) { string str = hc.Value.Replace("%3D", "="); userid = Encrypt.DecryptDES(str, "1"); user.load(userid); CheckRight(user.Entity, "pm/Base/AutoAllocation.aspx"); if (!Page.IsCallback) { list = createList(string.Empty, string.Empty); orderType = "<select class=\"input-text required size-S\" id=\"OrderType\" data-valid=\"isNonEmpty\" data-error=\"请选择\">"; orderTypeS = "<select class=\"input-text size-S\" id=\"OrderTypeS\" style=\"width:120px;\">"; orderType += "<option value=\"\" selected></option>"; orderTypeS += "<option value=\"\" selected>全部</option>"; Business.Base.BusinessOrderType type = new project.Business.Base.BusinessOrderType(); foreach (Entity.Base.EntityOrderType it in type.GetOrderTypeListQuery(string.Empty, string.Empty, string.Empty, user.Entity.AccID)) { orderType += "<option value='" + it.OrderTypeNo + "'>" + it.OrderTypeName + "</option>"; orderTypeS += "<option value='" + it.OrderTypeNo + "'>" + it.OrderTypeName + "</option>"; } orderType += "</select>"; orderTypeS += "</select>"; region = "<select class=\"input-text required size-S\" id=\"RegionNo\" data-valid=\"isNonEmpty\" data-error=\"请选择\">"; regionS = "<select class=\"input-text size-S\" id=\"RegionNoS\" style=\"width:120px;\">"; region += "<option value=\"\" selected></option>"; regionS += "<option value=\"\" selected>全部</option>"; Business.Base.BusinessRegion reg = new project.Business.Base.BusinessRegion(); foreach (Entity.Base.EntityRegion it in reg.GetRegionListQuery(string.Empty, string.Empty, user.Entity.AccID, string.Empty)) { region += "<option value='" + it.RegionNo + "'>" + it.RegionName + "</option>"; regionS += "<option value='" + it.RegionNo + "'>" + it.RegionName + "</option>"; } region += "</select>"; regionS += "</select>"; dept = "<select class=\"input-text required size-S\" id=\"DeptNo\" data-valid=\"isNonEmpty\" data-error=\"请选择\">"; dept += "<option value=\"\" selected></option>"; Business.Sys.BusinessDept allodt = new project.Business.Sys.BusinessDept(); foreach (Entity.Sys.EntityDept it in allodt.GetDeptListQuery(string.Empty, string.Empty, user.Entity.AccID, string.Empty)) { dept += "<option value='" + it.DeptNo + "'>" + it.DeptName + "</option>"; } dept += "</select>"; } } else { GotoErrorPage(); } } catch { GotoErrorPage(); } }