/// <summary> /// 得到一个对象实体 /// </summary> public Model.CON_JLYEE GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,BH,SJBH,FYR,LXDH,FYRQ,SJR,BT,NRZY,FYNR,FJDZ,JBRQ,BLQX,SSLB,BZ,CJR,CJSJ,ZT from CON_JLYEE "); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleDbType.Varchar2, 36) }; parameters[0].Value = ID; Model.CON_JLYEE model = new Model.CON_JLYEE(); 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 Add(Model.CON_JLYEE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CON_JLYEE("); strSql.Append("ID,BH,SJBH,FYR,LXDH,FYRQ,SJR,BT,NRZY,FYNR,FJDZ,JBRQ,BLQX,SSLB,BZ,CJR,CJSJ,ZT,XJLY)"); strSql.Append(" values ("); strSql.Append(":ID,:BH,:SJBH,:FYR,:LXDH,:FYRQ,:SJR,:BT,:NRZY,:FYNR,:FJDZ,:JBRQ,:BLQX,:SSLB,:BZ,:CJR,:CJSJ,:ZT,:XJLY)"); OracleParameter[] parameters = { new OracleParameter(":ID", OracleDbType.Varchar2, 36), new OracleParameter(":BH", OracleDbType.Varchar2, 100), new OracleParameter(":SJBH", OracleDbType.Varchar2, 100), new OracleParameter(":FYR", OracleDbType.Varchar2, 100), new OracleParameter(":LXDH", OracleDbType.Varchar2, 36), new OracleParameter(":FYRQ", OracleDbType.Date), new OracleParameter(":SJR", OracleDbType.Varchar2, 50), new OracleParameter(":BT", OracleDbType.Varchar2, 500), new OracleParameter(":NRZY", OracleDbType.Varchar2, 4000), new OracleParameter(":FYNR", OracleDbType.Clob), new OracleParameter(":FJDZ", OracleDbType.Varchar2, 300), new OracleParameter(":JBRQ", OracleDbType.Date), new OracleParameter(":BLQX", OracleDbType.Date), new OracleParameter(":SSLB", OracleDbType.Int32, 1), new OracleParameter(":BZ", OracleDbType.Varchar2, 500), new OracleParameter(":CJR", OracleDbType.Varchar2, 36), new OracleParameter(":CJSJ", OracleDbType.Date), new OracleParameter(":ZT", OracleDbType.Int32, 1), new OracleParameter(":XJLY", OracleDbType.Varchar2, 200) }; parameters[0].Value = model.ID; parameters[1].Value = model.BH; parameters[2].Value = model.SJBH; parameters[3].Value = model.FYR; parameters[4].Value = model.LXDH; parameters[5].Value = model.FYRQ; parameters[6].Value = model.SJR; parameters[7].Value = model.BT; parameters[8].Value = model.NRZY; parameters[9].Value = model.FYNR; parameters[10].Value = model.FJDZ; parameters[11].Value = model.JBRQ; parameters[12].Value = model.BLQX; parameters[13].Value = model.SSLB; parameters[14].Value = model.BZ; parameters[15].Value = model.CJR; parameters[16].Value = model.CJSJ; parameters[17].Value = model.ZT; parameters[18].Value = model.XJLY; int rows = DbHelperOra_new.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.CON_JLYEE DataRowToModel(DataRow row) { Model.CON_JLYEE model = new Model.CON_JLYEE(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["BH"] != null) { model.BH = row["BH"].ToString(); } if (row["SJBH"] != null) { model.SJBH = row["SJBH"].ToString(); } if (row["FYR"] != null) { model.FYR = row["FYR"].ToString(); } if (row["LXDH"] != null) { model.LXDH = row["LXDH"].ToString(); } if (row["FYRQ"] != null && row["FYRQ"].ToString() != "") { model.FYRQ = DateTime.Parse(row["FYRQ"].ToString()); } if (row["SJR"] != null) { model.SJR = row["SJR"].ToString(); } if (row["BT"] != null) { model.BT = row["BT"].ToString(); } //model.NRZY=row["NRZY"].ToString(); //model.FYNR=row["FYNR"].ToString(); if (row["FJDZ"] != null) { model.FJDZ = row["FJDZ"].ToString(); } if (row["JBRQ"] != null && row["JBRQ"].ToString() != "") { model.JBRQ = DateTime.Parse(row["JBRQ"].ToString()); } if (row["BLQX"] != null && row["BLQX"].ToString() != "") { model.BLQX = DateTime.Parse(row["BLQX"].ToString()); } if (row["SSLB"] != null && row["SSLB"].ToString() != "") { model.SSLB = decimal.Parse(row["SSLB"].ToString()); } if (row["BZ"] != null) { model.BZ = row["BZ"].ToString(); } if (row["CJR"] != null) { model.CJR = row["CJR"].ToString(); } if (row["CJSJ"] != null) { model.CJSJ = DateTime.Parse(row["CJSJ"].ToString()); } if (row["ZT"] != null && row["ZT"].ToString() != "") { model.ZT = decimal.Parse(row["ZT"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.CON_JLYEE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CON_JLYEE set "); strSql.Append("BH=:BH,"); strSql.Append("SJBH=:SJBH,"); strSql.Append("FYR=:FYR,"); strSql.Append("LXDH=:LXDH,"); strSql.Append("FYRQ=:FYRQ,"); strSql.Append("SJR=:SJR,"); strSql.Append("BT=:BT,"); strSql.Append("NRZY=:NRZY,"); strSql.Append("FYNR=:FYNR,"); strSql.Append("FJDZ=:FJDZ,"); strSql.Append("JBRQ=:JBRQ,"); strSql.Append("BLQX=:BLQX,"); strSql.Append("SSLB=:SSLB,"); strSql.Append("BZ=:BZ,"); strSql.Append("CJR=:CJR,"); strSql.Append("CJSJ=:CJSJ,"); strSql.Append("ZT=:ZT"); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":BH", OracleDbType.Varchar2, 100), new OracleParameter(":SJBH", OracleDbType.Varchar2, 100), new OracleParameter(":FYR", OracleDbType.Varchar2, 100), new OracleParameter(":LXDH", OracleDbType.Varchar2, 36), new OracleParameter(":FYRQ", OracleDbType.Date), new OracleParameter(":SJR", OracleDbType.Varchar2, 50), new OracleParameter(":BT", OracleDbType.Varchar2, 500), new OracleParameter(":NRZY", OracleDbType.Varchar2, 4000), new OracleParameter(":FYNR", OracleDbType.Clob), new OracleParameter(":FJDZ", OracleDbType.Varchar2, 300), new OracleParameter(":JBRQ", OracleDbType.Date), new OracleParameter(":BLQX", OracleDbType.Date), new OracleParameter(":SSLB", OracleDbType.Int32, 1), new OracleParameter(":BZ", OracleDbType.Varchar2, 500), new OracleParameter(":CJR", OracleDbType.Varchar2, 36), new OracleParameter(":CJSJ", OracleDbType.Date), new OracleParameter(":ZT", OracleDbType.Int32, 1), new OracleParameter(":ID", OracleDbType.Varchar2, 36) }; parameters[0].Value = model.BH; parameters[1].Value = model.SJBH; parameters[2].Value = model.FYR; parameters[3].Value = model.LXDH; parameters[4].Value = model.FYRQ; parameters[5].Value = model.SJR; parameters[6].Value = model.BT; parameters[7].Value = model.NRZY; parameters[8].Value = model.FYNR; parameters[9].Value = model.FJDZ; parameters[10].Value = model.JBRQ; parameters[11].Value = model.BLQX; parameters[12].Value = model.SSLB; parameters[13].Value = model.BZ; parameters[14].Value = model.CJR; parameters[15].Value = model.CJSJ; parameters[16].Value = model.ZT; parameters[17].Value = model.ID; int rows = DbHelperOra_new.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <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); } }
private bool MYDangan(string con_guid, DataRow dr) { try { string SourceID = dr["SOURCEID"].ToString(); //数据来源ID string fyrqstr = dr["REACTION_DATE"].ToString(); //反映日期 string jbrqstr = dr["ASSIGNED_DATE"].ToString(); //交办日期 string blqxstr = dr["APPLYPERIOD"].ToString(); //办理期限 string fjdz = dr["SUMMARYFILEOLD"].ToString(); //反映内容附件地址 if (!string.IsNullOrWhiteSpace(fjdz)) { fjdz = FJ_baseurl + fjdz; } switch (SourceID) { // 寒山闻钟论坛----------支队寒山闻钟 // 12345热线-------------支队政风行风 // 96122-----------------96122工单 // 纪委条线--------------市局纪委 // 信访条线--------------市局信访处 // 省厅、总队信件办理----其他 // 督察条线来信----------市局督察 // 支队信件转办----------支队 // 其他自选项------------分局寒山闻钟、分局政风行风 case "1": //支队寒山闻钟---寒山闻钟论坛 #region 寒山闻钟论坛 Model.CON_HSWZ hswz_model = new Model.CON_HSWZ(); hswz_model.ID = con_guid; //主键ID(32位或36位guid) hswz_model.BH = dr["SERIALNUMBER"].ToString(); //编号 //hswz_model.BT = "";//标题 hswz_model.FYR = dr["REACTION_PEOPLE"].ToString(); //反映人 if (!string.IsNullOrWhiteSpace(fyrqstr)) { hswz_model.FYRQ = Convert.ToDateTime(fyrqstr); //反映日期 } //hswz_model.FYLX = "";//反映类型 hswz_model.FYNR = dr["SUMMARY"].ToString(); //反映内容 hswz_model.NRZY = dr["ZHAIYAO"].ToString(); //内容摘要 //hswz_model.YQ = "";//要求 hswz_model.FJDZ = fjdz; //附件地址 if (!string.IsNullOrWhiteSpace(blqxstr)) { hswz_model.BLQX = Convert.ToDateTime(blqxstr); //办理期限 } if (!string.IsNullOrWhiteSpace(jbrqstr)) { hswz_model.JBRQ = Convert.ToDateTime(jbrqstr); //交办日期 } //hswz_model.JBYQ = "";//交办要求 //hswz_model.LDPS = "";//领导批示 //hswz_model.BZ = "";//备注 hswz_model.CJR = "民意一期"; //创建人 if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString())) { hswz_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString()); //创建时间 } hswz_model.ZT = 1; // 状态( 0.删除 1.待交办 2.待答复 3.待答复审核 4.待转办 5.待转办审核 6.退办 7.反馈中 8.回访中 9.办结) //hswz_model.FPSJ = null;//分配时间 hswz_model.FJM = dr["SUMMARYFILE"].ToString(); //附件名 bool hswz_res = new BLL.CON_HSWZ().Add(hswz_model); return(hswz_res); #endregion case "2": //支队政风行风---12345热线 #region 12345热线 Model.CON_YESSW yessw_model = new Model.CON_YESSW(); yessw_model.ID = con_guid; //主键ID(32位或36位guid) yessw_model.BH = dr["SERIALNUMBER"].ToString(); //编号 yessw_model.SJBH = dr["ORIGINALSYSTEMNUM"].ToString(); //上级编号 yessw_model.LDR = dr["REACTION_PEOPLE"].ToString(); //来电人 yessw_model.LXDH = dr["CONTACT_PHONE"].ToString(); //联系电话 if (!string.IsNullOrWhiteSpace(fyrqstr)) { yessw_model.FYRQ = Convert.ToDateTime(fyrqstr); //来电日期 } //yessw_model.FYLX = "";//反映类型 yessw_model.FYNR = dr["SUMMARY"].ToString(); //反映内容 yessw_model.NRZY = dr["ZHAIYAO"].ToString(); //内容摘要 yessw_model.FJDZ = fjdz; //附件地址 //yessw_model.YQ = "";//要求 if (!string.IsNullOrWhiteSpace(jbrqstr)) { yessw_model.JBRQ = Convert.ToDateTime(jbrqstr); //交办日期 } if (!string.IsNullOrWhiteSpace(blqxstr)) { yessw_model.BLQX = Convert.ToDateTime(blqxstr); //办理期限 } //yessw_model.JBYQ = "";//交办要求 yessw_model.FPSJ = null; //分配时间 //yessw_model.BZ = "";//备注 //yessw_model.LDPS = "";//领导批示 yessw_model.CJR = "民意一期"; //创建人 if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString())) { yessw_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString()); //创建时间 } //yessw_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间(时间格式,便于数据库查看) yessw_model.ZT = 1; //状态( 0.删除 1.待交办 2.待答复 3.待答复审核 4.待转办 5.待转办审核 6.退办 7.反馈中 8.回访中 9.办结) //yessw_model.XBDW = "";//协办单位 yessw_model.FJM = dr["SUMMARYFILE"].ToString(); //附件名 bool yessw_res = new BLL.CON_YESSW().Add(yessw_model); return(yessw_res); #endregion case "3": //96122工单---96122 #region 96122 Model.CON_JLYEE jlyee_model = new Model.CON_JLYEE(); jlyee_model.ID = con_guid; // 主键ID(32位或36位guid) jlyee_model.BH = dr["SERIALNUMBER"].ToString(); //编号 jlyee_model.SJBH = dr["ORIGINALSYSTEMNUM"].ToString(); //上级编号 jlyee_model.FYR = dr["REACTION_PEOPLE"].ToString(); //反映人 jlyee_model.LXDH = dr["CONTACT_PHONE"].ToString();; //联系电话 if (!string.IsNullOrWhiteSpace(fyrqstr)) { jlyee_model.FYRQ = Convert.ToDateTime(fyrqstr); //反映日期 } //jlyee_model.SJR = "";//收件人 //jlyee_model.BT = "";//标题 jlyee_model.NRZY = dr["ZHAIYAO"].ToString(); //内容摘要 jlyee_model.FYNR = dr["SUMMARY"].ToString(); //反映内容 jlyee_model.FJDZ = fjdz; //附件地址 if (!string.IsNullOrWhiteSpace(jbrqstr)) { jlyee_model.JBRQ = Convert.ToDateTime(jbrqstr); //交办日期 } //jlyee_model.BJRQ = null;//办结日期 jlyee_model.SSLB = 0; //所属类别0.其他 1.投诉 2.建议 3.咨询 4.举报 5.求助 6.表扬 //jlyee_model.BZ = "";//备注 jlyee_model.CJR = "民意一期"; //创建人 if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString())) { jlyee_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString()); //创建时间 } //jlyee_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间 jlyee_model.ZT = 1; //状态( 0.删除 1.有效) //jlyee_model.XJLY = "";// 信件来源 bool jlyee_res = new BLL.CON_JLYEE().Add(jlyee_model); return(jlyee_res); #endregion case "5": //分局寒山闻钟---其他自选项 case "6": //分局政风行风---其他自选项 #region 其他自选项 Model.CON_QTZXX qtzxx_model = new Model.CON_QTZXX(); qtzxx_model.ID = con_guid; //键ID(32位或36位guid) qtzxx_model.BH = dr["SERIALNUMBER"].ToString(); //编号 qtzxx_model.SJBH = dr["ORIGINALSYSTEMNUM"].ToString(); //上级编号 qtzxx_model.FYR = dr["REACTION_PEOPLE"].ToString(); //反映人 qtzxx_model.LXDH = dr["CONTACT_PHONE"].ToString();; //联系电话 //qtzxx_model.DZYJ = "";//电子邮件 //qtzxx_model.DZ = "";//地址 if (!string.IsNullOrWhiteSpace(fyrqstr)) { qtzxx_model.FYRQ = Convert.ToDateTime(fyrqstr); //反映日期 } if (!string.IsNullOrWhiteSpace(blqxstr)) { qtzxx_model.BLQX = Convert.ToDateTime(blqxstr); //办理期限 } //qtzxx_model.BT = "";//标题 qtzxx_model.FYNR = dr["SUMMARY"].ToString(); //反映内容 qtzxx_model.NRZY = dr["ZHAIYAO"].ToString(); //内容摘要 //qtzxx_model.YQ = "";//要求 qtzxx_model.FJDZ = fjdz; //附件地址 //qtzxx_model.FPSJ = null;//分配时间 if (!string.IsNullOrWhiteSpace(jbrqstr)) { qtzxx_model.JBRQ = Convert.ToDateTime(jbrqstr); //交办日期 } //qtzxx_model.JBYQ = "";//交办要求 //qtzxx_model.LDPS = "";//领导批示 //qtzxx_model.BZ = "";//备注 qtzxx_model.CJR = "民意一期"; //创建人 if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString())) { qtzxx_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString()); //创建时间 } //qtzxx_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间 qtzxx_model.ZT = 1; //状态( 0.删除 1.待交办 2.待答复 3.待答复审核 4.待转办 5.待转办审核 6.退办 7.反馈中 8.回访中 9.办结) qtzxx_model.FJM = dr["SUMMARYFILE"].ToString(); //附件名 //qtzxx_model.XJLY = "";//信件来源 bool qtzxx_res = new BLL.CON_QTZXX().Add(qtzxx_model); return(qtzxx_res); #endregion case "7": //市局信访处---信访条线 #region 信访条线 Model.CON_XFTX xftx_model = new Model.CON_XFTX(); xftx_model.ID = con_guid; // 主键ID(32位或36位guid) //xftx_model.XJLY = "";// 信件来源 xftx_model.BH = dr["SERIALNUMBER"].ToString(); //编号 xftx_model.SJBH = dr["ORIGINALSYSTEMNUM"].ToString(); //上级编号 xftx_model.XFR = dr["REACTION_PEOPLE"].ToString(); //信访人 xftx_model.LXDH = dr["CONTACT_PHONE"].ToString();; //联系电话 //xftx_model.DZYJ = "";//电子邮件 //xftx_model.DZ = "";//地址 if (!string.IsNullOrWhiteSpace(fyrqstr)) { xftx_model.FYRQ = Convert.ToDateTime(fyrqstr); //反映日期 } if (!string.IsNullOrWhiteSpace(blqxstr)) { xftx_model.BLQX = Convert.ToDateTime(blqxstr); //办理期限 } //xftx_model.BT = "";//标题 xftx_model.FYNR = dr["SUMMARY"].ToString(); //反映内容 xftx_model.NRZY = dr["ZHAIYAO"].ToString(); //内容摘要 //xftx_model.YQ = "";//要求 xftx_model.FJDZ = fjdz; //反应内容附件 // xftx_model.FPSJ = null;//分配时间 if (!string.IsNullOrWhiteSpace(jbrqstr)) { xftx_model.JBRQ = Convert.ToDateTime(jbrqstr); //交办日期 } //xftx_model.JBYQ = "";//交办要求 //xftx_model.LDPS = "";//领导批示 //xftx_model.BZ = "";//备注 xftx_model.CJR = "民意一期"; //创建人 if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString())) { xftx_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString()); //创建时间 } //xftx_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间 xftx_model.ZT = 1; //状态( 0.删除 1.待交办 2.待答复 3.待答复审核 4.待转办 5.待转办审核 6.退办 7.反馈中 8.回访中 9.办结) xftx_model.FJM = dr["SUMMARYFILE"].ToString(); //附件名 bool xftx_res = new BLL.CON_XFTX().Add(xftx_model); return(xftx_res); #endregion case "8": //市局纪委---纪委条线 #region 纪委条线 Model.CON_JWTX jwtx_model = new Model.CON_JWTX(); jwtx_model.ID = con_guid; //主键ID(32位或36位guid) jwtx_model.BH = dr["SERIALNUMBER"].ToString(); //编号 jwtx_model.SJBH = dr["ORIGINALSYSTEMNUM"].ToString(); //上级编号 jwtx_model.FYR = dr["REACTION_PEOPLE"].ToString(); //反映人 jwtx_model.LXDH = dr["CONTACT_PHONE"].ToString();; //联系电话 //jwtx_model.DZ = "";//地址 //jwtx_model.DZYJ = "";//电子邮件 if (!string.IsNullOrWhiteSpace(fyrqstr)) { jwtx_model.FYRQ = Convert.ToDateTime(fyrqstr); //反映日期 } if (!string.IsNullOrWhiteSpace(blqxstr)) { jwtx_model.BLQX = Convert.ToDateTime(blqxstr); //办理期限 } //jwtx_model.BT = "";//标题 jwtx_model.FYNR = dr["SUMMARY"].ToString(); //反映内容 jwtx_model.NRZY = dr["ZHAIYAO"].ToString(); //内容摘要 //jwtx_model.YQ = "";//要求 jwtx_model.FJDZ = fjdz; //附件地址 //jwtx_model.FPSJ = null;//分配时间 if (!string.IsNullOrWhiteSpace(jbrqstr)) { jwtx_model.JBRQ = Convert.ToDateTime(jbrqstr); //交办日期 } //jwtx_model.JBYQ = "";//交办要求 //jwtx_model.LDPS = "";//领导批示 //jwtx_model.BZ = "";//备注 jwtx_model.CJR = "民意一期"; //创建人 if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString())) { jwtx_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString()); //创建时间 } //jwtx_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间 jwtx_model.ZT = 1; //状态( 0.删除 1.待交办 2.待答复 3.待答复审核 4.待转办 5.待转办审核 6.退办 7.反馈中 8.回访中 9.办结) jwtx_model.FJM = dr["SUMMARYFILE"].ToString(); //附件名 //jwtx_model.XJLY = "";//信件来源 bool jwtx_res = new BLL.CON_JWTX().Add(jwtx_model); return(jwtx_res); #endregion case "9": //1号窗口 case "10": //市局平安民声 break; case "11": //支队---支队信件转办 #region 支队信件转办 Model.CON_ZDXJZB zdxjzb_model = new Model.CON_ZDXJZB(); zdxjzb_model.ID = con_guid; //主键ID(32位或36位guid) zdxjzb_model.BH = dr["SERIALNUMBER"].ToString(); //编号 zdxjzb_model.SJBH = dr["ORIGINALSYSTEMNUM"].ToString(); //上级编号 zdxjzb_model.FYR = dr["REACTION_PEOPLE"].ToString(); //反映人 zdxjzb_model.LXDH = dr["CONTACT_PHONE"].ToString();; //联系电话 //zdxjzb_model.DZYJ = "";//电子邮件 //zdxjzb_model.DZ = "";//地址 if (!string.IsNullOrWhiteSpace(fyrqstr)) { zdxjzb_model.FYRQ = Convert.ToDateTime(fyrqstr); //反映日期 } if (!string.IsNullOrWhiteSpace(blqxstr)) { zdxjzb_model.BLQX = Convert.ToDateTime(blqxstr); //办理期限 } zdxjzb_model.FYNR = dr["SUMMARY"].ToString(); //反映内容 zdxjzb_model.NRZY = dr["ZHAIYAO"].ToString(); //内容摘要 //zdxjzb_model.YQ = "";//要求 zdxjzb_model.FJDZ = fjdz; //附件地址 //zdxjzb_model.FPSJ = null;//分配时间 if (!string.IsNullOrWhiteSpace(jbrqstr)) { zdxjzb_model.JBRQ = Convert.ToDateTime(jbrqstr); //交办日期 } //zdxjzb_model.JBYQ = "";//交办要求 //zdxjzb_model.LDPS = "";//领导批示 //zdxjzb_model.BZ = "";//备注 zdxjzb_model.CJR = "民意一期"; //创建人 if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString())) { zdxjzb_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString()); //创建时间 } //zdxjzb_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间 zdxjzb_model.ZT = 1; //状态( 0.删除 1.待交办 2.待答复 3.待答复审核 4.待转办 5.待转办审核 6.退办 7.反馈中 8.回访中 9.办结) zdxjzb_model.FJM = dr["SUMMARYFILE"].ToString(); //附件名 //zdxjzb_model.XJLY = "";//信件来源 bool zdxjzb_res = new BLL.CON_ZDXJZB().Add(zdxjzb_model); return(zdxjzb_res); #endregion case "12": //市局督查---督察条线来信 #region 督察条线来信 Model.CON_DCTXLX dcxtlx_model = new Model.CON_DCTXLX(); dcxtlx_model.ID = con_guid; //主键ID(32位或36位guid) dcxtlx_model.BH = dr["SERIALNUMBER"].ToString(); //编号 dcxtlx_model.SJBH = dr["ORIGINALSYSTEMNUM"].ToString(); //上级编号 dcxtlx_model.FYR = dr["REACTION_PEOPLE"].ToString(); //反映人 dcxtlx_model.LXDH = dr["CONTACT_PHONE"].ToString();; //联系电话 //dcxtlx_model.DZYJ = "";//电子邮件 //dcxtlx_model.DZ = "";//地址 if (!string.IsNullOrWhiteSpace(fyrqstr)) { dcxtlx_model.FYRQ = Convert.ToDateTime(fyrqstr); //反映日期 } if (!string.IsNullOrWhiteSpace(blqxstr)) { dcxtlx_model.BLQX = Convert.ToDateTime(blqxstr); //办理期限 } //dcxtlx_model.BT = "";//标题 dcxtlx_model.FYNR = dr["SUMMARY"].ToString(); //反映内容 dcxtlx_model.NRZY = dr["ZHAIYAO"].ToString(); //内容摘要 //dcxtlx_model.YQ = "";//要求 dcxtlx_model.FJDZ = fjdz; //附件地址 //dcxtlx_model.FPSJ = null;//分配时间 if (!string.IsNullOrWhiteSpace(jbrqstr)) { dcxtlx_model.JBRQ = Convert.ToDateTime(jbrqstr); //交办日期 } //dcxtlx_model.JBYQ = "";//交办要求 //dcxtlx_model.FYWTXZ = "";//反映问题性质 //dcxtlx_model.LDPS = "";//领导批示 //dcxtlx_model.BZ = "";//备注 dcxtlx_model.CJR = "民意一期"; //创建人 if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString())) { dcxtlx_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString()); //创建时间 } //dcxtlx_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间 dcxtlx_model.ZT = 1; //状态( 0.删除 1.待交办 2.待答复 3.待答复审核 4.待转办 5.待转办审核 6.退办 7.反馈中 8.回访中 9.办结) dcxtlx_model.FJM = dr["SUMMARYFILE"].ToString(); //附件名拼接 //dcxtlx_model.XJLY = "";//信件来源 bool dcxtlx_res = new BLL.CON_DCTXLX().Add(dcxtlx_model); return(dcxtlx_res); #endregion case "13": //其他---省厅、总队信件办理 #region 省厅、总队信件办理 Model.CON_STZDXJBL stzdxjbl_model = new Model.CON_STZDXJBL(); stzdxjbl_model.ID = con_guid; //主键ID(32位或36位guid) //stzdxjbl_model.XJLY = "";//信件来源 stzdxjbl_model.BH = dr["SERIALNUMBER"].ToString(); //编号 stzdxjbl_model.SJBH = dr["ORIGINALSYSTEMNUM"].ToString(); //上级编号 stzdxjbl_model.LXR = dr["REACTION_PEOPLE"].ToString(); //来信人 stzdxjbl_model.LXDH = dr["CONTACT_PHONE"].ToString();; //联系电话 //stzdxjbl_model.DZ = "";//地址 //stzdxjbl_model.DZYJ = "";//电子邮件 if (!string.IsNullOrWhiteSpace(fyrqstr)) { stzdxjbl_model.FYRQ = Convert.ToDateTime(fyrqstr); //反映日期 } if (!string.IsNullOrWhiteSpace(blqxstr)) { stzdxjbl_model.BLQX = Convert.ToDateTime(blqxstr); //办理期限 } //stzdxjbl_model.BT = "";//标题 stzdxjbl_model.FYNR = dr["SUMMARY"].ToString(); //反映内容 stzdxjbl_model.NRZY = dr["ZHAIYAO"].ToString(); //内容摘要 //stzdxjbl_model.YQ = "";//要求 stzdxjbl_model.FJDZ = fjdz; //附件地址 //stzdxjbl_model.FPSJ = null;//分配时间 if (!string.IsNullOrWhiteSpace(jbrqstr)) { stzdxjbl_model.JBRQ = Convert.ToDateTime(jbrqstr); //交办日期 } //stzdxjbl_model.JBYQ = "";//交办要求 //stzdxjbl_model.LDPS = "";//领导批示 //stzdxjbl_model.BZ = "";//备注 stzdxjbl_model.CJR = "民意一期"; //创建人 if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString())) { stzdxjbl_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString()); //创建时间 } //stzdxjbl_model.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间 stzdxjbl_model.ZT = 1; //状态(0.删除 1.待交办 2.待答复 3.待答复审核 4.待转办 5.待转办审核 6.退办 7.反馈中 8.回访中 9.办结) stzdxjbl_model.FJM = dr["SUMMARYFILE"].ToString(); //附件名 bool stzdxjbl_res = new BLL.CON_STZDXJBL().Add(stzdxjbl_model); return(stzdxjbl_res); #endregion default: break; } } catch (Exception e) { SysLog.WriteLog(e, AppDomain.CurrentDomain.BaseDirectory); } return(false); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.CON_JLYEE model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.CON_JLYEE model) { return(dal.Add(model)); }