public void Index() { var context = HttpContext; string applyNo = context.Request["ApplyNo"] ?? "Br-A087422000"; Motigage mt = GetPrintPDFURL(applyNo); JavaScriptSerializer json = new JavaScriptSerializer(); context.Response.Write(json.Serialize(mt)); }
public Motigage GetPrintPDFURL(string applyNo) { string tmpPath = "";// System.Web.HttpContext.Current.Server.MapPath("").Replace("ajax", "Filetemplate") + "\\营业执照\\"; string sql = "SELECT * FROM I_MORTGAGE WHERE APPLYNO = '" + applyNo + "'"; DataTable dt = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable(sql); Motigage mt = new Motigage(); if (dt.Rows.Count > 0) { mt.Province = dt.Rows[0]["PROVINCE"].ToString(); mt.City = dt.Rows[0]["CITY"].ToString(); mt.ApplyType = dt.Rows[0]["APPLYTYPE"].ToString(); mt.JKName = dt.Rows[0]["JKNAME"].ToString(); mt.GJName = dt.Rows[0]["GJNAME"].ToString(); mt.DBRName = dt.Rows[0]["DBRNAME"].ToString(); mt.JKCardID = dt.Rows[0]["JKCARDID"].ToString(); mt.GJCardID = dt.Rows[0]["GJCARDID"].ToString(); mt.DBRCardID = dt.Rows[0]["DBRCARDID"].ToString(); mt.Assets = dt.Rows[0]["ASSETS"].ToString(); mt.Factory = dt.Rows[0]["FACTORY"].ToString(); mt.CarType = dt.Rows[0]["CARTYPE"].ToString(); mt.NewCarPrice = dt.Rows[0]["NEWCARPRICE"].ToString(); mt.AssetsPrice = dt.Rows[0]["ASSETSPRICE"].ToString(); mt.MotorType = dt.Rows[0]["MOTORTYPE"].ToString(); mt.FrameNumber = dt.Rows[0]["FRAMENUMBER"].ToString(); mt.ProductClass = dt.Rows[0]["PRODUCTCLASS"].ToString(); mt.ProductType = dt.Rows[0]["PRODUCTTYPE"].ToString(); mt.DKMoney = dt.Rows[0]["DKMONEY"].ToString(); mt.SFMoney = dt.Rows[0]["SFMONEY"].ToString(); mt.FJMoney = dt.Rows[0]["FJMONEY"].ToString(); mt.LicenceNo = dt.Rows[0]["LICENCENO"].ToString(); mt.DyName = dt.Rows[0]["DYNAME"].ToString(); mt.SpName = dt.Rows[0]["SPNAME"].ToString(); mt.OBJECTID = dt.Rows[0]["OBJECTID"].ToString(); mt.DealerName = dt.Rows[0]["经销商名称"].ToString(); mt.Isself = dt.Rows[0]["ISSELF"].ToString(); mt.Localdo = dt.Rows[0]["LOCALDO"].ToString(); mt.SelectShop = dt.Rows[0]["SELECTSHOP"].ToString(); mt.ApplyNo = dt.Rows[0]["APPLYNO"].ToString(); List <GJPeople> GJlist = new List <GJPeople>(); string gjsql = "SELECT * FROM I_GJPEOPLE WHERE PARENTOBJECTID = '" + dt.Rows[0]["OBJECTID"] + "'"; DataTable gjdt = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable(gjsql); if (gjdt.Rows.Count > 0) { for (int i = 0; i < gjdt.Rows.Count; i++) { GJPeople gj = new GJPeople(); gj.People = gjdt.Rows[i]["PEOPLE"].ToString(); gj.PeopleType = gjdt.Rows[i]["PEOPLETYPE"].ToString(); gj.IdType = gjdt.Rows[i]["IDTYPE"].ToString(); gj.ID = gjdt.Rows[i]["ID"].ToString(); GJlist.Add(gj); } } mt.GJPeople = GJlist; } switch (mt.DealerName) { case "包头市宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "包头市宝泽汽车销售服务有限公司高新区分公司": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "包头市路泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "包头市世通瑞晟汽车销售服务有限公司 01": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "包头众锐汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "北京百旺沃瑞汽车销售服务有限公司": break; case "北京宝泽行汽车销售服务有限公司": break; case "北京德万隆经贸有限公司": break; case "北京嘉瑞雅汽车销售服务有限公司": break; case "北京名尊奥翔汽车销售有限公司": break; case "北京正通宝泽行汽车销售有限公司": break; case "北京正通鼎沃汽车销售服务有限公司": break; case "北京中汽南方华北汽车服务有限公司": break; case "北京中汽南方中关汽车销售有限公司": break; case "郴州瑞宝汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150039.pdf"; break; case "成都劲翔汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150057.pdf"; break; case "成都祺宝汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150057.pdf"; break; case "东莞奥泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150011.pdf"; break; case "东莞捷运行汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150011.pdf"; break; case "东莞寮步中汽南方汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150011.pdf"; break; case "东莞正通凯迪汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150011.pdf"; break; case "东莞中汽南方汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150011.pdf"; break; case "佛山奥泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150026.pdf"; break; case "佛山鼎宝行汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150024.pdf"; break; case "佛山正通众锐汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150024.pdf"; break; case "福建中汽南方汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150032.pdf"; break; case "福州鼎沃汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150032.pdf"; break; case "抚州市东信汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150041.pdf"; break; case "赣州宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150064.pdf"; break; case "广东中汽南方汽车销售服务有限公司(VOLVO)": tmpPath = tmpPath + "00000002201808150021.pdf"; break; case "广东中汽南方汽车销售服务有限公司(路虎)": tmpPath = tmpPath + "00000002201808150021.pdf"; break; case "广西瑞合行汽车服务有限公司": tmpPath = tmpPath + "00000002201808150028.pdf"; break; case "广州宝泰行汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150021.pdf"; break; case "广州宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150021.pdf"; break; case "广州宝泽汽车销售服务有限公司MINI": tmpPath = tmpPath + "00000002201808150021.pdf"; break; case "广州市恒悦行汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150022.pdf"; break; case "贵州瑞合行汽车服务有限公司": tmpPath = tmpPath + "00000002201808150038.pdf"; break; case "海南中汽南方汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150048.pdf"; break; case "合肥速融汽车贸易有限公司": tmpPath = tmpPath + "00000002201808150009.pdf"; break; case "河南必诚汽车服务有限公司": tmpPath = tmpPath + "00000002201808150012.pdf"; break; case "河南菲卡汽车销售有限公司 02": tmpPath = tmpPath + "00000002201808150012.pdf"; break; case "河南省锦堂盛汽车有限公司": tmpPath = tmpPath + "00000002201808150012.pdf"; break; case "衡阳路泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150039.pdf"; break; case "呼和浩特市捷运行汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "呼和浩特市祺宝汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "呼和浩特市英菲汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "湖北奥泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "湖北博诚汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "湖北鼎杰汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "湖北捷瑞汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "湖北欣瑞汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "湖南融晟行汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150049.pdf"; break; case "湖南中汽南方汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150045.pdf"; break; case "湖南中汽南方星沙汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150015.pdf"; break; case "吉林坔水汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150019.pdf"; break; case "济南天瑞汽车咨询服务有限公司": tmpPath = tmpPath + "00000002201808150016.pdf"; break; case "江西德奥汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150060.pdf"; break; case "江西正通泽田汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150041.pdf"; break; case "揭阳鼎杰汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150047.pdf"; break; case "揭阳路泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150047.pdf"; break; case "荆门宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150054.pdf"; break; case "廊坊市路泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150023.pdf"; break; case "连云港市耀辉汽车贸易有限公司 01": tmpPath = tmpPath + "00000002201808150034.pdf"; break; case "连云港众可汽车销售有限公司 02": tmpPath = tmpPath + "00000002201808150034.pdf"; break; case "南昌宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150041.pdf"; break; case "内蒙古鼎杰汽车贸易有限公司": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "内蒙古鼎泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "内蒙古津远进口汽车销售服务有限公司 02": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "内蒙古鑫垚陆之虎汽贸有限公司 02": tmpPath = tmpPath + "00000002201808150053.pdf"; break; case "青岛奥泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150055.pdf"; break; case "青岛华成汽车服务有限公司": tmpPath = tmpPath + "00000002201808150055.pdf"; break; case "清远南方丰田汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150059.pdf"; break; case "清远南方合众汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150059.pdf"; break; case "汕头市宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150066.pdf"; break; case "汕头市宏祥物资有限公司": tmpPath = tmpPath + "00000002201808150066.pdf"; break; case "汕头市路杰汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150066.pdf"; break; case "上海奥汇汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150029.pdf"; break; case "上海锋之行汽车金融信息服务有限公司": tmpPath = tmpPath + "00000002201808150029.pdf"; break; case "上海举骋汽车贸易有限公司": tmpPath = tmpPath + "00000002201808150029.pdf"; break; case "上海陆达汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150029.pdf"; break; case "上海陆狮汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150029.pdf"; break; case "上海绅瑞汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150029.pdf"; break; case "上海绅协汽车贸易有限公司": tmpPath = tmpPath + "00000002201808150029.pdf"; break; case "上海绅协绅起汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150029.pdf"; break; case "上海绅协绅通汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150029.pdf"; break; case "上海绅亚汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150029.pdf"; break; case "上饶市宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150041.pdf"; break; case "上饶市路泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150041.pdf"; break; case "深圳宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "深圳鼎沃汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "深圳市南方腾龙汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "深圳市南方腾田汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "深圳市南方腾星汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "深圳市南方英菲尼迪汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "深圳市彦信金融服务有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "深圳市彦信汽车信息咨询服务有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "深圳市中汽南方华沃汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "深圳市中汽南方机电设备有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "深圳市中汽南方汽车维修有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "嵊州奥泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150017.pdf"; break; case "十堰绅协汽车贸易有限公司": tmpPath = tmpPath + "00000002201808150050.pdf"; break; case "天津汽车工业销售深圳南方有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "天津中汽南方汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150014.pdf"; break; case "威海路泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150027.pdf"; break; case "武汉宝泽行汽车维修服务有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "武汉宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "武汉宝泽汽车销售服务有限公司江岸分公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "武汉开泰汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "武汉路泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "武汉正邦兴达资产管理咨询有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "武汉正通悦驰汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "湘潭宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150050.pdf"; break; case "襄阳宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150010.pdf"; break; case "徐州千瑞汽车销售有限公司 02": tmpPath = tmpPath + "00000002201808150034.pdf"; break; case "宜昌宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150040.pdf"; break; case "宜春宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150041.pdf"; break; case "云南瑞合福德汽车服务有限公司": tmpPath = tmpPath + "00000002201808150038.pdf"; break; case "湛江正通凯迪汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150047.pdf"; break; case "长沙瑞宝汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150045.pdf"; break; case "长沙瑞宝汽车销售服务有限公司韶山路分公司": tmpPath = tmpPath + "00000002201808150045.pdf"; break; case "郑州奥泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150025.pdf"; break; case "郑州鼎沃汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150036.pdf"; break; case "中山中汽南方汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150068.pdf"; break; case "珠海宝泽汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150067.pdf"; break; case "珠海宝泽汽车销售服务有限公司MINI": tmpPath = tmpPath + "00000002201808150067.pdf"; break; case "珠海中汽南方捷路汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150049.pdf"; break; case "珠海中汽南方汽车销售服务有限公司": tmpPath = tmpPath + "00000002201808150067.pdf"; break; default: break; } mt.PdfPath = tmpPath; return(mt); }