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("验证此测试方法的正确性。");
}
