public void Execute(List <System.Windows.Point> polygon) { //获取案件总数 List <PolyCountInfo> jsCount = polyService.GetCountInfoByPoly("监所管理", "派出所", polygon); foreach (PolyCountInfo js in jsCount) { List <PolyListInfo> jsList = polyService.GetListInfoByPoly("监所管理", js.Name, "派出所", polygon); foreach (PolyListInfo listInfo in jsList) { //获取监所详细信息 string jscode = listInfo.ID.Split(new char[] { '|' })[0]; if (jscode.Equals(string.Empty)) { continue; } JSDetail jsDetail = polyService.GetJSDetailByPoly(jscode); BeyonDBParameter param1 = new BeyonDBParameter("jscode", BeyonDBType.VarChar); param1.Value = jscode; BeyonDBParameter param2 = new BeyonDBParameter("jsmc", BeyonDBType.VarChar); param2.Value = listInfo.Name == null ? string.Empty : listInfo.Name; BeyonDBParameter param3 = new BeyonDBParameter("gajgxz", BeyonDBType.VarChar); param3.Value = jsDetail.GAJGXZ == null ? string.Empty : jsDetail.GAJGXZ; BeyonDBParameter param4 = new BeyonDBParameter("dwld_xm", BeyonDBType.VarChar); param4.Value = jsDetail.DWLD_XM == null ? string.Empty : jsDetail.DWLD_XM; BeyonDBParameter param5 = new BeyonDBParameter("dwld_lxdh", BeyonDBType.VarChar); param5.Value = jsDetail.DWLD_LXDH == null ? string.Empty : jsDetail.DWLD_LXDH; BeyonDBParameter param6 = new BeyonDBParameter("rs", BeyonDBType.VarChar); param6.Value = jsDetail.RS == null ? string.Empty : jsDetail.RS; BeyonDBParameter param7 = new BeyonDBParameter("jd", BeyonDBType.VarChar); param7.Value = listInfo.JD == null ? 0 : listInfo.JD; BeyonDBParameter param8 = new BeyonDBParameter("wd", BeyonDBType.VarChar); param8.Value = listInfo.WD == null ? 0 : listInfo.WD; BeyonDBParameter param9 = new BeyonDBParameter("zp", BeyonDBType.VarChar); param9.Value = jsDetail.zp == null ? string.Empty : jsDetail.zp; BeyonDBParameter param10 = new BeyonDBParameter("jstype", BeyonDBType.VarChar); param10.Value = js.Name == null ? string.Empty : js.Name; //此处应先清空案件表,再插入。因这里原始.net api事务不好处理,请先手工清空表. dbOper.ExecuteScalar("insert into prison (jscode, jsmc, gajgxz, dwld_xm, dwld_lxdh, rs, jd, wd, zp, jstype) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", new BeyonDBParameter[] { param1, param2, param3, param4, param5, param6, param7, param8, param9, param10 }); ////获取监所内服刑人员,并写入监所人员表 //List<JSPerson> jpList = polyService.GetJSPersonListByPoly(js.Name, listInfo.ID); //foreach(JSPerson jp in jpList) //{ // JSPersonDetail jpDetail = polyService.GetJSPersonDetailByPoly(jp.JBXXBH, js.Name); // //写入监所服刑人员信息 // dbOper.ExecuteScalar("insert into anjian (ajid, ajmc, ajtype) values(?, ?, ?)", new BeyonDBParameter[] { param1, param2, param3 }); //} } } }
/// <summary> /// 圈选获取监所详细信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public JSDetail GetJSDetailByPoly(string id) { OleDbConnectionStringBuilder zzjgDBConnectBuilder = new OleDbConnectionStringBuilder(); zzjgDBConnectBuilder.Add("Provider", "MSDAORA"); zzjgDBConnectBuilder.Add("Data Source", ConfigHelper.GetValueByKey("webservice.config", "zzjgDB")); zzjgDBConnectBuilder.Add("Persist Security Info", true); zzjgDBConnectBuilder.Add("User ID", ConfigHelper.GetValueByKey("webservice.config", "zzjgDBUser")); zzjgDBConnectBuilder.Add("Password", ConfigHelper.GetValueByKey("webservice.config", "zzjgDBPasswd")); JSDetail info = new JSDetail(); try { using (OleDbConnection conn = new OleDbConnection(zzjgDBConnectBuilder.ConnectionString)) { //缺少照片数据 String sql = String.Format("select JSMC,LD,DH,DZ,BZRS from B_ZTK_SP_JSJBXX where JSBH='{0}'", id); conn.Open(); OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if (!reader.IsDBNull(0)) { info.JS_MC = reader[0].ToString(); } if (!reader.IsDBNull(1)) { info.DWLD_XM = reader[1].ToString(); } if (!reader.IsDBNull(2)) { info.DWLD_LXDH = reader[2].ToString(); } if (!reader.IsDBNull(3)) { info.GAJGXZ = reader[3].ToString(); } if (!reader.IsDBNull(4)) { info.RS = reader[4].ToString(); } } } } catch (Exception ex) { throw ex; } return(info); //string json = ServiceUtil.GetRemoteXmlStream(ConfigHelper.GetValueByKey("webservice.config", "圈选监所详细信息") + id, null); //return JsonConvert.DeserializeObject<List<JSDetail>>(json)[0]; }
public void GetJSDetailByPolyTest() { PolySelectManager target = new PolySelectManager(); // TODO: 初始化为适当的值 string id = string.Empty; // TODO: 初始化为适当的值 JSDetail expected = null; // TODO: 初始化为适当的值 JSDetail actual; actual = target.GetJSDetailByPoly(id); Assert.AreEqual(expected, actual); Assert.Inconclusive("验证此测试方法的正确性。"); }