/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.INWORK model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update INWORK set "); strSql.Append("JBSJ=:JBSJ,"); strSql.Append("JBDW=:JBDW,"); strSql.Append("CBLX=:CBLX,"); strSql.Append("ZT=:ZT,"); strSql.Append("CJR=:CJR,"); strSql.Append("CJSJ=:CJSJ,"); strSql.Append("ISTX=:ISTX,"); strSql.Append("TXSJ=:TXSJ,"); strSql.Append("ISZB=:ISZB,"); strSql.Append("ZBYH=:ZBYH"); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":JBSJ", OracleDbType.Varchar2, 36), new OracleParameter(":JBDW", OracleDbType.Varchar2, 36), new OracleParameter(":CBLX", OracleDbType.Int32, 4), new OracleParameter(":ZT", OracleDbType.Int32, 4), new OracleParameter(":CJR", OracleDbType.Varchar2, 36), new OracleParameter(":CJSJ", OracleDbType.Date), new OracleParameter(":ISTX", OracleDbType.Int32, 4), new OracleParameter(":TXSJ", OracleDbType.Date), new OracleParameter(":ISZB", OracleDbType.Int32, 4), new OracleParameter(":ZBYH", OracleDbType.Varchar2, 36), new OracleParameter(":ID", OracleDbType.Varchar2, 36) }; parameters[0].Value = model.JBSJ; parameters[1].Value = model.JBDW; parameters[2].Value = model.CBLX; parameters[3].Value = model.ZT; parameters[4].Value = model.CJR; parameters[5].Value = model.CJSJ; parameters[6].Value = model.ISTX; parameters[7].Value = model.TXSJ; parameters[8].Value = model.ISZB; parameters[9].Value = model.ZBYH; parameters[10].Value = model.ID; int rows = DbHelperOra_new.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.INWORK DataRowToModel(DataRow row) { Model.INWORK model = new Model.INWORK(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["JBSJ"] != null) { model.JBSJ = row["JBSJ"].ToString(); } if (row["JBDW"] != null) { model.JBDW = row["JBDW"].ToString(); } if (row["CBLX"] != null && row["CBLX"].ToString() != "") { model.CBLX = decimal.Parse(row["CBLX"].ToString()); } if (row["ZT"] != null && row["ZT"].ToString() != "") { model.ZT = decimal.Parse(row["ZT"].ToString()); } if (row["CJR"] != null) { model.CJR = row["CJR"].ToString(); } if (row["CJSJ"] != null && row["CJSJ"].ToString() != "") { model.CJSJ = DateTime.Parse(row["CJSJ"].ToString()); } if (row["ISTX"] != null && row["ISTX"].ToString() != "") { model.ISTX = decimal.Parse(row["ISTX"].ToString()); } if (row["TXSJ"] != null && row["TXSJ"].ToString() != "") { model.TXSJ = DateTime.Parse(row["TXSJ"].ToString()); } if (row["ISZB"] != null && row["ISZB"].ToString() != "") { model.ISZB = decimal.Parse(row["ISZB"].ToString()); } if (row["ZBYH"] != null) { model.ZBYH = row["ZBYH"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.INWORK model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into INWORK("); strSql.Append("ID,JBSJ,JBDW,CBLX,ZT,CJR,CJSJ,ISTX,TXSJ,ISZB,ZBYH,UPDEP)"); strSql.Append(" values ("); strSql.Append(":ID,:JBSJ,:JBDW,:CBLX,:ZT,:CJR,:CJSJ,:ISTX,:TXSJ,:ISZB,:ZBYH,:UPDEP)"); OracleParameter[] parameters = { new OracleParameter(":ID", OracleDbType.Varchar2, 36), new OracleParameter(":JBSJ", OracleDbType.Varchar2, 36), new OracleParameter(":JBDW", OracleDbType.Varchar2, 36), new OracleParameter(":CBLX", OracleDbType.Int32, 4), new OracleParameter(":ZT", OracleDbType.Int32, 4), new OracleParameter(":CJR", OracleDbType.Varchar2, 36), new OracleParameter(":CJSJ", OracleDbType.Date), new OracleParameter(":ISTX", OracleDbType.Int32, 4), new OracleParameter(":TXSJ", OracleDbType.Date), new OracleParameter(":ISZB", OracleDbType.Int32, 4), new OracleParameter(":ZBYH", OracleDbType.Varchar2, 36), new OracleParameter(":UPDEP", OracleDbType.Int32, 4) }; parameters[0].Value = model.ID; parameters[1].Value = model.JBSJ; parameters[2].Value = model.JBDW; parameters[3].Value = model.CBLX; parameters[4].Value = model.ZT; parameters[5].Value = model.CJR; parameters[6].Value = model.CJSJ; parameters[7].Value = model.ISTX; parameters[8].Value = model.TXSJ; parameters[9].Value = model.ISZB; parameters[10].Value = model.ZBYH; parameters[11].Value = model.UPDEP; int rows = DbHelperOra_new.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 处办数据 /// </summary> /// <param name="assign_guid">交办id</param> /// <param name="inwork_guid">处办id</param> /// <param name="jbdw">交办单位</param> /// <param name="dr"></param> /// <returns></returns> private Model.INWORK InworkModel(string assign_guid, string inwork_guid, string jbdw, DataRow dr) { Model.INWORK model_inwork = new Model.INWORK(); //处办表 model_inwork.ID = inwork_guid; model_inwork.CJR = "民意一期"; //创建人 if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString())) { model_inwork.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间 } //model_inwork.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间 model_inwork.ISTX = 0; model_inwork.ISZB = 2; //1 是 2否 是否转办 model_inwork.JBDW = jbdw; //交办单位 model_inwork.JBSJ = assign_guid; //交办数据 model_inwork.CBLX = 1; //出版类型 1办理 2拒绝 model_inwork.ZT = 6; //状态 已办结 model_inwork.UPDEP = 1; // 上报处理部门,0:否,1:是 return(model_inwork); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.INWORK GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,JBSJ,JBDW,CBLX,ZT,CJR,CJSJ,ISTX,TXSJ,ISZB,ZBYH from INWORK "); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleDbType.Varchar2, 36) }; parameters[0].Value = ID; Model.INWORK model = new Model.INWORK(); DataSet ds = DbHelperOra_new.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.INWORK model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.INWORK model) { return(dal.Add(model)); }
/// <summary> /// 获取96122数据并插入新民意系统对应的数据库中 /// </summary> private void Get96122Data() { try { string strSql = $"select T.INFOID,t.deptid,t.dtdate,t.redeptid,t.intnum,t.chrtitle,t.dtappendddate,t.chrdesc,t.chrno,t.isgone from TRAFFIC_INFO t where isgone = -2 and deptid = 2341 and infoid >{strMaxid} order by t.infoid desc"; DataSet dt96122 = DbHelperOra.Query(strSql); //获取某ID之上的所有数据 event_showLogs("获取未同步数据信息"); if (dt96122 == null || dt96122.Tables[0].Rows.Count <= 0) { event_showLogs("获取未同步数据信息为null"); return; } //1.遍历数据并转存到系统数据库 foreach (DataRow dr in dt96122.Tables[0].Rows) { try { //更新最大ID using (FileStream fs = new FileStream("configs/maxid.txt", FileMode.Open, FileAccess.ReadWrite)) { using (StreamWriter sw = new StreamWriter(fs, Encoding.GetEncoding("UTF-8"))) { sw.WriteLine(dr["INFOID"] + ""); sw.Close(); fs.Close(); // Class1 cl = new Class1(); event_showLogs("成功更新configs/maxid.txt最大ID:" + dr["INFOID"]); SysLog.WriteOptDisk("成功更新configs/maxid.txt最大ID:" + dr["INFOID"], AppDomain.CurrentDomain.BaseDirectory, 100); } } } catch { } //1 找到对应的新系统的GUID string strID = dr["redeptid"] + ""; //得到老系统的中的部门ID string strNewPartId = ""; //新希望的部门ID if (dicID_GUID.ContainsKey(strID)) { strNewPartId = dicID_GUID[strID]; //得到字典中对应的ID } else { SysLog.WriteOptDisk("新系统为找到对应的部门ID老系统ID为" + strID + ";TRAFFIC_INFO表中INFOID为" + dr["INFOID"], AppDomain.CurrentDomain.BaseDirectory, 16); } //2 插入数据库 string StrGUID = Guid.NewGuid().ToString("N").ToUpper(); //得到32位大写的 GUID Model.CON_JLYEE model_96122 = new Model.CON_JLYEE(); model_96122.ID = StrGUID; model_96122.JBRQ = Convert.ToDateTime(dr["dtdate"] + ""); //交办日期 model_96122.LXDH = ""; //联系电话 model_96122.NRZR = dr["chrtitle"] + ""; //内容标题 model_96122.SJBH = ""; //上级编号 model_96122.SJR = ""; //收件人 model_96122.SSLB = 0; //0 所属类别 0 其他 model_96122.ZT = 1; //状态 1 model_96122.FYRQ = Convert.ToDateTime(dr["dtdate"] + ""); //反映日期 model_96122.FYR = "96122"; //反映人 model_96122.FYNR = dr["chrdesc"] + ""; //反映内容 model_96122.FJDZ = ""; //附件地址 model_96122.CJSJ = DateTime.Now; //创建时间 model_96122.CJR = "96122"; //创建人 96122 510521aa-f5fc-4f06-bd58-c2696bda22e5 model_96122.BZ = ""; //备注 model_96122.BT = dr["chrtitle"] + ""; //标题 model_96122.BH = dr["chrno"] + ""; //编号 Model.ASSIGN model_assign = new Model.ASSIGN(); //ASSIGN 主表 model_assign.BZ = ""; //备注空 model_assign.CJR = "96122"; //创建人 model_assign.CJSJ = DateTime.Now; //创建时间 model_assign.HFNR = ""; //各部门回复内容汇总 string strAssignId = Guid.NewGuid().ToString("N").ToUpper(); model_assign.ID = strAssignId; model_assign.JBDW = strNewPartId; //交办单位 model_assign.JBRQ = Convert.ToDateTime(dr["dtdate"] + ""); //交办日期 model_assign.JBYQ = ""; //交办要求 model_assign.LDPS = ""; //领导批示 model_assign.MYLY = "510521AAF5FC4F06BD58C2696BDA22E5"; //96122 model_assign.MYSJDX = StrGUID; //民意数据来源 model_assign.ZT = 1; Model.INWORK model_inwork = new Model.INWORK(); //处办表 model_inwork.CJR = "96122"; //96122 model_inwork.CJSJ = DateTime.Now; //创建时间 model_inwork.ID = Guid.NewGuid().ToString("N").ToUpper(); //得到32位大写的 GUID model_inwork.ISTX = 0; model_inwork.ISZB = 2; //1 是 2否 是否转办 model_inwork.JBDW = strNewPartId; //交办单位 model_inwork.JBSJ = strAssignId; //交办数据 model_inwork.ZT = 1; //状态 try { new BLL.CON_JLYEE().Add(model_96122); //新增96122数据 new BLL.ASSIGN().Add(model_assign); //assgin new BLL.INWORK().Add(model_inwork); //inwork 处办表 event_showLogs("成功更新民意数据库,对应96122 ID:" + dr["INFOID"]); // SysLog.WriteOptDisk("成功更新configs/maxid.txt最大ID" + dr["INFOID"], AppDomain.CurrentDomain.BaseDirectory, 100); } catch (Exception ex) { SysLog.WriteLog(ex, AppDomain.CurrentDomain.BaseDirectory); } } } catch (Exception ex) { //本地记录异常日志 SysLog.WriteLog(ex, AppDomain.CurrentDomain.BaseDirectory); } }
/// <summary> /// 获取民意一期数据并插入新民意系统对应的数据库中 /// </summary> private void GetPlatformData() { try { string strSql = $"select top 1000 * from Data_processingissues t where id >{strMaxid} order by id"; //每次读取1000条数据 DataSet dt_MY1 = DbHelperSQL.Query(strSql); //获取某ID之上的所有数据 event_showLogs("获取民意一期数据未同步数据信息"); if (dt_MY1 == null || dt_MY1.Tables[0].Rows.Count <= 0) { event_showLogs("获取民意一期数据未同步数据信息为null"); return; } //1.遍历数据并转存到系统数据库 foreach (DataRow dr in dt_MY1.Tables[0].Rows) { string SourceID = dr["SOURCEID"].ToString(); //数据来源ID string mylyguid = string.Empty; //二期民意来源guid int upReportMyly = 0; //上报民意来源对应number switch (SourceID) { //6062178399694A078E1AACF5FDD9F481 寒山闻钟论坛----------支队寒山闻钟 //0E8E2D480578471EAB622AC8DDC2A874 12345热线-------------支队政风行风 //510521AAF5FC4F06BD58C2696BDA22E5 96122-----------------96122工单 //7B8F5B74C09243FA9E2B5540B708761D 纪委条线--------------市局纪委 //58EAE7497C054DBCB3241A15C9336795 信访条线--------------市局信访处 //EA6859A55E7A44289A6B589D887C61AC 省厅、总队信件办理----其他 //09B7732CDBEA4009A1FA9DC5166B7690 督察条线来信----------市局督察 //BED2CF750A634A9D876262BB670A3A39 支队信件转办----------支队 //0C51C38CFF464CB4B839FA663C181CDE 其他自选项------------分局寒山闻钟、分局政风行风 // 1寒山闻钟论坛;2:12345热线;3纪委条线;4:信访条线;5省厅、总队信件办理;6督察条线来信;7支队信件转办;8其他自选项;9:96122 case "1": //支队寒山闻钟 mylyguid = "6062178399694A078E1AACF5FDD9F481"; upReportMyly = 1; break; case "2": //支队政风行风 mylyguid = "0E8E2D480578471EAB622AC8DDC2A874"; upReportMyly = 2; break; case "3": //96122工单 mylyguid = "510521AAF5FC4F06BD58C2696BDA22E5"; upReportMyly = 9; break; case "5": //分局寒山闻钟 mylyguid = "0C51C38CFF464CB4B839FA663C181CDE"; upReportMyly = 8; break; case "6": //分局政风行风 mylyguid = "0C51C38CFF464CB4B839FA663C181CDE"; upReportMyly = 8; break; case "7": //市局信访处 mylyguid = "58EAE7497C054DBCB3241A15C9336795"; upReportMyly = 4; break; case "8": //市局纪委 mylyguid = "7B8F5B74C09243FA9E2B5540B708761D"; upReportMyly = 3; break; case "9": //1号窗口 mylyguid = ""; break; case "10": //市局平安民声 mylyguid = ""; break; case "11": //支队 mylyguid = "BED2CF750A634A9D876262BB670A3A39"; upReportMyly = 7; break; case "12": //市局督查 mylyguid = "09B7732CDBEA4009A1FA9DC5166B7690"; upReportMyly = 6; break; case "13": //其他 mylyguid = "EA6859A55E7A44289A6B589D887C61AC"; upReportMyly = 5; break; default: break; } if (string.IsNullOrWhiteSpace(mylyguid)) { continue; } string jbdw_MY1 = dr["SPONSORID"].ToString(); //承办单位 //如遇有多个承办单位,则取第一个为交办单位 if (jbdw_MY1.IndexOf(",") >= 0) { jbdw_MY1 = jbdw_MY1.Substring(0, jbdw_MY1.LastIndexOf(",")); } string jbdw_MY2 = string.Empty;//民意二期交办单位 if (dicDEPID_GUID.ContainsKey(jbdw_MY1)) { jbdw_MY2 = dicDEPID_GUID[jbdw_MY1]; //得到字典中对应的ID } //添加民意档案数据 string con_guid = Guid.NewGuid().ToString("N").ToUpper(); //得到32位大写的 GUID bool conres = MYDangan(con_guid, dr); // 添加交办数据 string assign_guid = Guid.NewGuid().ToString("N").ToUpper();//得到32位大写的 GUID Model.ASSIGN model_assign = AssignModel(assign_guid, mylyguid, con_guid, jbdw_MY2, dr); //添加处办数据 string inwork_guid = Guid.NewGuid().ToString("N").ToUpper();//得到32位大写的 GUID Model.INWORK model_inwork = InworkModel(assign_guid, inwork_guid, jbdw_MY2, dr); //添加部门答复数据 Model.REPLY_RECORD model_reply = ReplyModel(inwork_guid, dr); //添加上报数据 string upreport_guid = Guid.NewGuid().ToString("N").ToUpper();//得到32位大写的 GUID Model.ASSIGN_UPREPORT model_upreport = UpReportModel(assign_guid, upreport_guid, upReportMyly, dr); // 添加上报附件数据 try { string fjdz = dr["REPLY_CONTENTFILE"].ToString();//答复附件地址 if (!string.IsNullOrWhiteSpace(fjdz)) { Model.ASSIGN_UPFJ model_upfj = UpFJModel(upreport_guid, dr); bool upfjres = new BLL.ASSIGN_UPFJ().Add(model_upfj); } // 添加时间轴数据 } catch (Exception ex) { SysLog.WriteLog(ex, AppDomain.CurrentDomain.BaseDirectory); } try { bool assignres = new BLL.ASSIGN().Add(model_assign); bool inworkres = new BLL.INWORK().Add(model_inwork); bool replyres = new BLL.REPLY_RECORD().Add(model_reply); bool upreportres = new BLL.ASSIGN_UPREPORT().Add(model_upreport); event_showLogs("成功更新民意数据库,对应ID:" + dr["ID"]); } catch (Exception ex) { SysLog.WriteLog(ex, AppDomain.CurrentDomain.BaseDirectory); } #region 更新最大ID try { //更新最大ID using (FileStream fs = new FileStream("configs/maxid.txt", FileMode.Open, FileAccess.ReadWrite)) { using (StreamWriter sw = new StreamWriter(fs, Encoding.GetEncoding("UTF-8"))) { sw.WriteLine(dr["ID"] + ""); sw.Close(); fs.Close(); // Class1 cl = new Class1(); strMaxid = dr["ID"].ToString(); event_showLogs("成功更新configs/maxid.txt最大ID:" + dr["ID"]); SysLog.WriteOptDisk("成功更新configs/maxid.txt最大ID:" + dr["ID"], AppDomain.CurrentDomain.BaseDirectory, 100); } } } catch (Exception ex) { SysLog.WriteLog(ex, AppDomain.CurrentDomain.BaseDirectory); } #endregion } } catch (Exception ex) { SysLog.WriteLog(ex, AppDomain.CurrentDomain.BaseDirectory); } }