/// <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));
}
