public void SaveZDINITToDB(ZD_INIT ZD_INIT) { try { bool isExistsHD = DeleteINIT(ZD_INIT.INIT_GUID); SaveIINIT(ZD_INIT, isExistsHD); }catch (Exception ex) { throw ex; } }
public static IList <ZD_INIT> getInit(string sqlStr) { IList <ZD_INIT> initList = new List <ZD_INIT>(); using (OracleConnection conn = new OracleConnection(jgptConnString)) { conn.Open(); OracleCommand command = conn.CreateCommand(); command.CommandText = sqlStr; command.CommandType = System.Data.CommandType.Text; OracleDataReader oracleDataReader = command.ExecuteReader(); while (oracleDataReader.Read()) { ZD_INIT init = new ZD_INIT(); init.INIT_CFWCRQ = oracleDataReader["INIT_CFWCRQ"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(oracleDataReader["INIT_CFWCRQ"]); init.INIT_CFWCRY = oracleDataReader["INIT_CFWCRY"] == DBNull.Value ? 0 : Convert.ToDecimal(oracleDataReader["INIT_CFWCRY"]); init.INIT_CQH = oracleDataReader["INIT_CQH"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_CQH"]); init.INIT_CQRK = oracleDataReader["INIT_CQRK"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_CQRK"]); init.INIT_GUID = oracleDataReader["INIT_GUID"] == DBNull.Value ? "" : Convert.ToString(oracleDataReader["INIT_GUID"]); init.INIT_ISCFWC = oracleDataReader["INIT_ISCFWC"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_ISCFWC"]); init.INIT_NYAZ_HB = oracleDataReader["INIT_NYAZ_HB"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_NYAZ_HB"]); init.INIT_NYAZ_LD = oracleDataReader["INIT_NYAZ_LD"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_NYAZ_LD"]); init.INIT_NYAZ_NY = oracleDataReader["INIT_NYAZ_NY"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_NYAZ_NY"]); init.INIT_NYAZ_NZF = oracleDataReader["INIT_NYAZ_NZF"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_NYAZ_NZF"]); init.INIT_NYAZ_QT = oracleDataReader["INIT_NYAZ_QT"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_NYAZ_QT"]); init.INIT_NYAZ_SB = oracleDataReader["INIT_NYAZ_SB"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_NYAZ_SB"]); init.INIT_NYAZ_ZRK = oracleDataReader["INIT_NYAZ_ZRK"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_NYAZ_ZRK"]); init.INIT_PFWH = oracleDataReader["INIT_PFWH"] == DBNull.Value ? "" : Convert.ToString(oracleDataReader["INIT_PFWH"]); init.INIT_PFWH1 = oracleDataReader["INIT_PFWH1"] == DBNull.Value ? "" : Convert.ToString(oracleDataReader["INIT_PFWH1"]); init.INIT_PFWH2 = oracleDataReader["INIT_PFWH2"] == DBNull.Value ? "" : Convert.ToString(oracleDataReader["INIT_PFWH2"]); init.INIT_PFWH3 = oracleDataReader["INIT_PFWH3"] == DBNull.Value ? "" : Convert.ToString(oracleDataReader["INIT_PFWH3"]); init.INIT_PZJG = oracleDataReader["INIT_PZJG"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_PZJG"]); init.INIT_PZSJ = oracleDataReader["INIT_PZSJ"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(oracleDataReader["INIT_PZSJ"]); init.INIT_XMLX = oracleDataReader["INIT_XMLX"] == DBNull.Value ? 0 : Convert.ToInt32(oracleDataReader["INIT_XMLX"]); init.INIT_XMMC = oracleDataReader["INIT_XMMC"] == DBNull.Value ? "" : Convert.ToString(oracleDataReader["INIT_XMMC"]); init.INIT_XZQDM = oracleDataReader["INIT_XZQDM"] == DBNull.Value ? "" : Convert.ToString(oracleDataReader["INIT_XZQDM"]); init.INIT_XZQMC = oracleDataReader["INIT_XZQMC"] == DBNull.Value ? "" : Convert.ToString(oracleDataReader["INIT_XZQMC"]); init.INIT_ZFY = oracleDataReader["INIT_ZFY"] == DBNull.Value ? 0 : Convert.ToDecimal(oracleDataReader["INIT_ZFY"]); init.INIT_ZMJ = oracleDataReader["INIT_ZMJ"] == DBNull.Value ? 0 : Convert.ToDecimal(oracleDataReader["INIT_ZMJ"]); initList.Add(init); } oracleDataReader.Close(); } return(initList); }
public bool SyncTdzzData(Action <int, int> counter) { int totle = 0, success = 0; try { FileInfo[] fileInfos = new DirectoryInfo(this.importPath).GetFiles(); totle = fileInfos.Length; foreach (FileInfo fi in fileInfos) { try { if (fi.Extension.ToLower() == ".json") { ZD_INIT init = Newtonsoft.Json.JsonConvert.DeserializeObject <ZD_INIT>(File.ReadAllText(fi.FullName)); dbOperate.SaveZDINITToDB(init); success++; } else { continue; } } catch (Exception ex) { LogUtil.WriteErrorLog(typeof(SyncDataImport), "导入项目:" + fi.Name + "失败,失败原因是:" + ex.Message, ex); } } counter(totle, success); return(true); } catch (Exception ex) { LogUtil.WriteErrorLog(typeof(SyncDataImport), "导入项目失败,失败原因是:" + ex.Message, ex); return(false); } }
private void SaveIINIT(ZD_INIT initList, bool isExistsHD) { int init_sec = 0; try { string initSqlStr = "insertINIT"; object initsecObject = DbHelper.ExecuteSqlString(initSqlStr, System.Data.CommandType.StoredProcedure, initList); if (initsecObject != null) { init_sec = (int)initsecObject; } if (initList.ZD_INIT_YDQKs != null && initList.ZD_INIT_YDQKs.Count > 0) { foreach (ZD_INIT_YDQK ydqk in initList.ZD_INIT_YDQKs) { string ydqkSqlStr = String.Format(@"insert into zd_init_ydqk (YDQK_SEC,INIT_SEC,YDQK_GUID,YDQK_XZQDM,YDQK_XZQMC,YDQK_ZMJ,YDQK_ZFY, YDQK_NYAZ_ZRK,YDQK_NYAZ_NY,YDQK_NYAZ_SB,YDQK_NYAZ_HB,YDQK_NYAZ_LD,YDQK_NYAZ_NZF,YDQK_CQH, YDQK_CQRK,YDQK_NYAZ_QT) values(s_zd_init_ydqk.nextval,{0},'{1}','{2}','{3}',{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14})", init_sec, ydqk.YDQK_GUID, ydqk.YDQK_XZQDM, ydqk.YDQK_XZQMC, ydqk.YDQK_ZMJ, ydqk.YDQK_ZFY, ydqk.YDQK_NYAZ_ZRK, ydqk.YDQK_NYAZ_NY, ydqk.YDQK_NYAZ_SB, ydqk.YDQK_NYAZ_HB, ydqk.YDQK_NYAZ_LD, ydqk.YDQK_NYAZ_NZF, ydqk.YDQK_CQH, ydqk.YDQK_CQRK, ydqk.YDQK_NYAZ_QT); DbHelper.ExecuteSqlString(ydqkSqlStr); } } if (!isExistsHD) { string sqlstr = "insert into zd_ydqk_hd select s_zd_ydqk_hd.nextval hd_sec, t.ydqk_zmj hd_zmj, t.ydqk_zfy hd_zfy, t.ydqk_nyaz_zrk hd_zrk, t.ydqk_guid from zd_init_ydqk t where not exists(select * from zd_ydqk_hd d where d.ydqk_guid = t.ydqk_guid)"; DbHelper.ExecuteSqlString(sqlstr); } }catch (Exception ex) { throw ex; } }
public static object ExecuteSqlString(string sqlStr, System.Data.CommandType commandType = System.Data.CommandType.Text, ZD_INIT init = null) { using (OracleConnection conn = new OracleConnection(zdbaConnString)) { conn.Open(); OracleCommand command = conn.CreateCommand(); command.CommandText = sqlStr; command.CommandType = commandType; if (init != null) { command.Parameters.Add("V_INIT_GUID", OracleType.VarChar).Direction = ParameterDirection.Input; command.Parameters["V_INIT_GUID"].Value = init.INIT_GUID; command.Parameters.Add("V_INIT_XMMC", OracleType.VarChar).Direction = ParameterDirection.Input; command.Parameters["V_INIT_XMMC"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_PZSJ", OracleType.DateTime).Direction = ParameterDirection.Input; command.Parameters["V_INIT_PZSJ"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_XZQDM", OracleType.VarChar).Direction = ParameterDirection.Input; command.Parameters["V_INIT_XZQDM"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_XZQMC", OracleType.VarChar).Direction = ParameterDirection.Input; command.Parameters["V_INIT_XZQMC"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_XMLX", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_XMLX"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_PZJG", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_PZJG"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_PFWH", OracleType.VarChar).Direction = ParameterDirection.Input; command.Parameters["V_INIT_PFWH"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_PFWH1", OracleType.VarChar).Direction = ParameterDirection.Input; command.Parameters["V_INIT_PFWH1"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_PFWH2", OracleType.VarChar).Direction = ParameterDirection.Input; command.Parameters["V_INIT_PFWH2"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_PFWH3", OracleType.VarChar).Direction = ParameterDirection.Input; command.Parameters["V_INIT_PFWH3"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_ISCFWC", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_ISCFWC"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_ZMJ", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_ZMJ"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_ZFY", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_ZFY"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_NYAZ_ZRK", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_NYAZ_ZRK"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_NYAZ_NY", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_NYAZ_NY"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_NYAZ_HB", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_NYAZ_HB"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_NYAZ_SB", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_NYAZ_SB"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_NYAZ_LD", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_NYAZ_LD"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_NYAZ_NZF", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_NYAZ_NZF"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_NYAZ_QT", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_NYAZ_QT"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_CQH", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_CQH"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_CQRK", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_CQRK"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_CFWCRQ", OracleType.DateTime).Direction = ParameterDirection.Input; command.Parameters["V_INIT_CFWCRQ"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_CFWCRY", OracleType.Number).Direction = ParameterDirection.Input; command.Parameters["V_INIT_CFWCRY"].Value = init.INIT_XMMC; command.Parameters.Add("V_INIT_SEC", OracleType.Number).Direction = ParameterDirection.Output; command.ExecuteNonQuery(); return(command.Parameters["V_INIT_SEC"].Value.ToString()); } return(command.ExecuteNonQuery()); } }