/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.REPLY_RECORD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update REPLY_RECORD set "); strSql.Append("CBID=:CBID,"); strSql.Append("HFNR=:HFNR,"); strSql.Append("ZT=:ZT,"); strSql.Append("CJR=:CJR,"); strSql.Append("CJSJ=:CJSJ,"); strSql.Append("CBLX=:CBLX,"); strSql.Append("FJDZ=:FJDZ,"); strSql.Append("FJM=:FJM"); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":CBID", OracleDbType.Varchar2, 36), new OracleParameter(":HFNR", OracleDbType.Clob), new OracleParameter(":ZT", OracleDbType.Int32, 4), new OracleParameter(":CJR", OracleDbType.Varchar2, 36), new OracleParameter(":CJSJ", OracleDbType.Date), new OracleParameter(":CBLX", OracleDbType.Int32, 4), new OracleParameter(":FJDZ", OracleDbType.Varchar2, 4000), new OracleParameter(":FJM", OracleDbType.Varchar2, 4000), new OracleParameter(":ID", OracleDbType.Varchar2, 36) }; parameters[0].Value = model.CBID; parameters[1].Value = model.HFNR; parameters[2].Value = model.ZT; parameters[3].Value = model.CJR; parameters[4].Value = model.CJSJ; parameters[5].Value = model.CBLX; parameters[6].Value = model.FJDZ; parameters[7].Value = model.FJM; parameters[8].Value = model.ID; int rows = DbHelperOra_new.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.REPLY_RECORD DataRowToModel(DataRow row) { Model.REPLY_RECORD model = new Model.REPLY_RECORD(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["CBID"] != null) { model.CBID = row["CBID"].ToString(); } if (row["HFNR"] != null) { model.HFNR = row["HFNR"].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["CBLX"] != null && row["CBLX"].ToString() != "") { model.CBLX = decimal.Parse(row["CBLX"].ToString()); } if (row["FJDZ"] != null) { model.FJDZ = row["FJDZ"].ToString(); } if (row["FJM"] != null) { model.FJM = row["FJM"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.REPLY_RECORD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into REPLY_RECORD("); strSql.Append("ID,CBID,HFNR,ZT,CJR,CJSJ,CBLX,FJDZ,FJM)"); strSql.Append(" values ("); strSql.Append(":ID,:CBID,:HFNR,:ZT,:CJR,:CJSJ,:CBLX,:FJDZ,:FJM)"); OracleParameter[] parameters = { new OracleParameter(":ID", OracleDbType.Varchar2, 36), new OracleParameter(":CBID", OracleDbType.Varchar2, 36), new OracleParameter(":HFNR", OracleDbType.Clob), new OracleParameter(":ZT", OracleDbType.Int32, 4), new OracleParameter(":CJR", OracleDbType.Varchar2, 36), new OracleParameter(":CJSJ", OracleDbType.Date), new OracleParameter(":CBLX", OracleDbType.Int32, 4), new OracleParameter(":FJDZ", OracleDbType.Varchar2, 4000), new OracleParameter(":FJM", OracleDbType.Varchar2, 4000) }; parameters[0].Value = model.ID; parameters[1].Value = model.CBID; parameters[2].Value = model.HFNR; parameters[3].Value = model.ZT; parameters[4].Value = model.CJR; parameters[5].Value = model.CJSJ; parameters[6].Value = model.CBLX; parameters[7].Value = model.FJDZ; parameters[8].Value = model.FJM; int rows = DbHelperOra_new.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.REPLY_RECORD GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,CBID,HFNR,ZT,CJR,CJSJ,CBLX,FJDZ,FJM from REPLY_RECORD "); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleDbType.Varchar2, 36) }; parameters[0].Value = ID; Model.REPLY_RECORD model = new Model.REPLY_RECORD(); 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> /// <param name="inwork_guid">处办id</param> /// <param name="dr"></param> /// <returns></returns> private Model.REPLY_RECORD ReplyModel(string inwork_guid, DataRow dr) { Model.REPLY_RECORD model_reply = new Model.REPLY_RECORD(); model_reply.ID = Guid.NewGuid().ToString("N").ToUpper(); //得到32位大写的 GUID model_reply.CBID = inwork_guid; //处办id model_reply.HFNR = dr["REPLY_CONTENT"].ToString(); //回复内容 model_reply.ZT = 1; //状态 model_reply.CJR = "民意一期"; //创建人 if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString())) { model_reply.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间 } //model_reply.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间 model_reply.CBLX = 1; //处办类型 string fjdz = dr["REPLY_CONTENTFILEOLD"].ToString(); //答复附件地址 if (!string.IsNullOrWhiteSpace(fjdz)) { fjdz = FJ_baseurl + fjdz; } model_reply.FJDZ = fjdz; //附件地址 model_reply.FJM = dr["REPLY_CONTENTFILE"].ToString(); //附件名 return(model_reply); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.REPLY_RECORD model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.REPLY_RECORD model) { return(dal.Add(model)); }
/// <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); } }