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