/// <summary>
/// 交办数据
/// </summary>
/// <param name="assign_guid">交办id</param>
/// <param name="mylyguid">民意来源guid 对应字典表里的guid</param>
/// <param name="con_guid">民意档案guid</param>
/// <param name="jbdw">交办单位</param>
/// <param name="dr"></param>
/// <returns></returns>
private Model.ASSIGN AssignModel(string assign_guid, string mylyguid, string con_guid, string jbdw, DataRow dr)
{
Model.ASSIGN model_assign = new Model.ASSIGN(); //ASSIGN 主表
model_assign.BZ = ""; //备注空
model_assign.CJR = "民意一期"; //创建人
if (!string.IsNullOrWhiteSpace(dr["CREATE_DATE"].ToString()))
{
model_assign.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间
}
//model_assign.CJSJ = Convert.ToDateTime(dr["CREATE_DATE"].ToString());//创建时间
//model_assign.HFNR = "";//各部门回复内容汇总
model_assign.ID = assign_guid;
model_assign.JBDW = jbdw; //交办单位
string jbrqstr = dr["ASSIGNED_DATE"].ToString(); //交办日期
if (!string.IsNullOrWhiteSpace(jbrqstr))
{
model_assign.JBRQ = Convert.ToDateTime(jbrqstr);//交办日期
}
//model_assign.JBYQ = "";//交办要求
//model_assign.LDPS = "";//领导批示
model_assign.MYLY = mylyguid;
model_assign.MYSJDX = con_guid; //民意数据来源
model_assign.ZT = 5; //已办结
return(model_assign);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.ASSIGN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ASSIGN set ");
strSql.Append("MYSJDX=:MYSJDX,");
strSql.Append("MYLY=:MYLY,");
strSql.Append("JBRQ=:JBRQ,");
strSql.Append("JBDW=:JBDW,");
strSql.Append("JBYQ=:JBYQ,");
strSql.Append("LDPS=:LDPS,");
strSql.Append("BZ=:BZ,");
strSql.Append("ZT=:ZT,");
strSql.Append("CJR=:CJR,");
strSql.Append("CJSJ=:CJSJ,");
strSql.Append("HFNR=:HFNR");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":MYSJDX", OracleDbType.Varchar2, 36),
new OracleParameter(":MYLY", OracleDbType.Varchar2, 36),
new OracleParameter(":JBRQ", OracleDbType.Date),
new OracleParameter(":JBDW", OracleDbType.Varchar2, 2000),
new OracleParameter(":JBYQ", OracleDbType.Varchar2, 2000),
new OracleParameter(":LDPS", OracleDbType.Varchar2, 2000),
new OracleParameter(":BZ", OracleDbType.Varchar2, 2000),
new OracleParameter(":ZT", OracleDbType.Int32, 4),
new OracleParameter(":CJR", OracleDbType.Varchar2, 36),
new OracleParameter(":CJSJ", OracleDbType.Date),
new OracleParameter(":HFNR", OracleDbType.Clob),
new OracleParameter(":ID", OracleDbType.Varchar2, 36)
};
parameters[0].Value = model.MYSJDX;
parameters[1].Value = model.MYLY;
parameters[2].Value = model.JBRQ;
parameters[3].Value = model.JBDW;
parameters[4].Value = model.JBYQ;
parameters[5].Value = model.LDPS;
parameters[6].Value = model.BZ;
parameters[7].Value = model.ZT;
parameters[8].Value = model.CJR;
parameters[9].Value = model.CJSJ;
parameters[10].Value = model.HFNR;
parameters[11].Value = model.ID;
int rows = DbHelperOra_new.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.ASSIGN DataRowToModel(DataRow row)
{
Model.ASSIGN model = new Model.ASSIGN();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["MYSJDX"] != null)
{
model.MYSJDX = row["MYSJDX"].ToString();
}
if (row["MYLY"] != null)
{
model.MYLY = row["MYLY"].ToString();
}
if (row["JBRQ"] != null && row["JBRQ"].ToString() != "")
{
model.JBRQ = DateTime.Parse(row["JBRQ"].ToString());
}
if (row["JBDW"] != null)
{
model.JBDW = row["JBDW"].ToString();
}
if (row["JBYQ"] != null)
{
model.JBYQ = row["JBYQ"].ToString();
}
if (row["LDPS"] != null)
{
model.LDPS = row["LDPS"].ToString();
}
if (row["BZ"] != null)
{
model.BZ = row["BZ"].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());
}
//model.HFNR=row["HFNR"].ToString();
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.ASSIGN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ASSIGN(");
strSql.Append("ID,MYSJDX,MYLY,JBRQ,JBDW,JBYQ,LDPS,BZ,ZT,CJR,CJSJ,HFNR)");
strSql.Append(" values (");
strSql.Append(":ID,:MYSJDX,:MYLY,:JBRQ,:JBDW,:JBYQ,:LDPS,:BZ,:ZT,:CJR,:CJSJ,:HFNR)");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleDbType.Varchar2, 36),
new OracleParameter(":MYSJDX", OracleDbType.Varchar2, 36),
new OracleParameter(":MYLY", OracleDbType.Varchar2, 36),
new OracleParameter(":JBRQ", OracleDbType.Date),
new OracleParameter(":JBDW", OracleDbType.Varchar2, 2000),
new OracleParameter(":JBYQ", OracleDbType.Varchar2, 2000),
new OracleParameter(":LDPS", OracleDbType.Varchar2, 2000),
new OracleParameter(":BZ", OracleDbType.Varchar2, 2000),
new OracleParameter(":ZT", OracleDbType.Int32, 4),
new OracleParameter(":CJR", OracleDbType.Varchar2, 36),
new OracleParameter(":CJSJ", OracleDbType.Date),
new OracleParameter(":HFNR", OracleDbType.Clob)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.MYSJDX;
parameters[2].Value = model.MYLY;
parameters[3].Value = model.JBRQ;
parameters[4].Value = model.JBDW;
parameters[5].Value = model.JBYQ;
parameters[6].Value = model.LDPS;
parameters[7].Value = model.BZ;
parameters[8].Value = model.ZT;
parameters[9].Value = model.CJR;
parameters[10].Value = model.CJSJ;
parameters[11].Value = model.HFNR;
int rows = DbHelperOra_new.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.ASSIGN GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,MYSJDX,MYLY,JBRQ,JBDW,JBYQ,LDPS,BZ,ZT,CJR,CJSJ,HFNR from ASSIGN ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleDbType.Varchar2, 36)
};
parameters[0].Value = ID;
Model.ASSIGN model = new Model.ASSIGN();
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.ASSIGN model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.ASSIGN 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);
}
}
