public SDS_XZGB Get_SDS_XZGB() { string sql = "select * from SDS_XZGB"; SDS_XZGB sds_xzgb = new SDS_XZGB(); try { DataTable dt = DBHelperSQL.GetDataTable(sql); if (dt.Rows.Count > 0) { sds_xzgb.d1Date1995070120000701CO = dt.Rows[0]["d1Date1995070120000701CO"].ToString(); sds_xzgb.d1Date1995070120000701HC = dt.Rows[0]["d1Date1995070120000701HC"].ToString(); sds_xzgb.d1Date19950701qCO = dt.Rows[0]["d1Date19950701qCO"].ToString(); sds_xzgb.d1Date19950701qHC = dt.Rows[0]["d1Date19950701qHC"].ToString(); sds_xzgb.d1Date20000701CO = dt.Rows[0]["d1Date20000701CO"].ToString(); sds_xzgb.d1Date20000701HC = dt.Rows[0]["d1Date20000701HC"].ToString(); sds_xzgb.d2Date1995070120011001CO = dt.Rows[0]["d2Date1995070120011001CO"].ToString(); sds_xzgb.d2Date1995070120011001HC = dt.Rows[0]["d2Date1995070120011001HC"].ToString(); sds_xzgb.d2Date19950701qCO = dt.Rows[0]["d2Date19950701qCO"].ToString(); sds_xzgb.d2Date19950701qHC = dt.Rows[0]["d2Date19950701qHC"].ToString(); sds_xzgb.d2Date20011001CO = dt.Rows[0]["d2Date20011001CO"].ToString(); sds_xzgb.d2Date20011001HC = dt.Rows[0]["d2Date20011001HC"].ToString(); sds_xzgb.Hd1Date1995070120000701CO = dt.Rows[0]["Hd1Date1995070120000701CO"].ToString(); sds_xzgb.Hd1Date1995070120000701HC = dt.Rows[0]["Hd1Date1995070120000701HC"].ToString(); sds_xzgb.Hd1Date19950701qCO = dt.Rows[0]["Hd1Date19950701qCO"].ToString(); sds_xzgb.Hd1Date19950701qHC = dt.Rows[0]["Hd1Date19950701qHC"].ToString(); sds_xzgb.Hd1Date20000701CO = dt.Rows[0]["Hd1Date20000701CO"].ToString(); sds_xzgb.Hd1Date20000701HC = dt.Rows[0]["Hd1Date20000701HC"].ToString(); sds_xzgb.Hd2Date1995070120011001CO = dt.Rows[0]["Hd2Date1995070120011001CO"].ToString(); sds_xzgb.Hd2Date1995070120011001HC = dt.Rows[0]["Hd2Date1995070120011001HC"].ToString(); sds_xzgb.Hd2Date19950701qCO = dt.Rows[0]["Hd2Date19950701qCO"].ToString(); sds_xzgb.Hd2Date19950701qHC = dt.Rows[0]["Hd2Date19950701qHC"].ToString(); sds_xzgb.Hd2Date20011001CO = dt.Rows[0]["Hd2Date20011001CO"].ToString(); sds_xzgb.Hd2Date20011001HC = dt.Rows[0]["Hd2Date20011001HC"].ToString(); sds_xzgb.HNewd1CO = dt.Rows[0]["HNewd1CO"].ToString(); sds_xzgb.HNewd1HC = dt.Rows[0]["HNewd1HC"].ToString(); sds_xzgb.HNewd2CO = dt.Rows[0]["HNewd2CO"].ToString(); sds_xzgb.HNewd2HC = dt.Rows[0]["HNewd2HC"].ToString(); sds_xzgb.HzxDate1995070120040901CO = dt.Rows[0]["HzxDate1995070120040901CO"].ToString(); sds_xzgb.HzxDate1995070120040901HC = dt.Rows[0]["HzxDate1995070120040901HC"].ToString(); sds_xzgb.HzxDate19950701qCO = dt.Rows[0]["HzxDate19950701qCO"].ToString(); sds_xzgb.HzxDate19950701qHC = dt.Rows[0]["HzxDate19950701qHC"].ToString(); sds_xzgb.HzxDate20040901CO = dt.Rows[0]["HzxDate20040901CO"].ToString(); sds_xzgb.HzxDate20040901HC = dt.Rows[0]["HzxDate20040901HC"].ToString(); sds_xzgb.Newd1CO = dt.Rows[0]["Newd1CO"].ToString(); sds_xzgb.Newd1HC = dt.Rows[0]["Newd1HC"].ToString(); sds_xzgb.Newd2CO = dt.Rows[0]["Newd2CO"].ToString(); sds_xzgb.Newd2HC = dt.Rows[0]["Newd2HC"].ToString(); sds_xzgb.zxDate1995070120040901CO = dt.Rows[0]["zxDate1995070120040901CO"].ToString(); sds_xzgb.zxDate1995070120040901HC = dt.Rows[0]["zxDate1995070120040901HC"].ToString(); sds_xzgb.zxDate19950701qCO = dt.Rows[0]["zxDate19950701qCO"].ToString(); sds_xzgb.zxDate19950701qHC = dt.Rows[0]["zxDate19950701qHC"].ToString(); sds_xzgb.zxDate20040901CO = dt.Rows[0]["zxDate20040901CO"].ToString(); sds_xzgb.zxDate20040901HC = dt.Rows[0]["zxDate20040901HC"].ToString(); sds_xzgb.zxHNewCO = dt.Rows[0]["zxHNewCO"].ToString(); sds_xzgb.zxHNewHC = dt.Rows[0]["zxHNewHC"].ToString(); sds_xzgb.zxNewCO = dt.Rows[0]["zxNewCO"].ToString(); sds_xzgb.zxNewHC = dt.Rows[0]["zxNewHC"].ToString(); } return(sds_xzgb); } catch (Exception) { throw; } }
/// <summary> /// 用SDS对象插入或更新数据 /// </summary> /// <param name="sds"></param> /// <returns>int 0为失败,1为插入成功</returns> public int Save_SDS_XZGB(SDS_XZGB sds) { string sqli = "insert into SDS_XZGB(HNewd1HC,HNewd1CO,Newd1HC,Newd1CO,HNewd2HC,HNewd2CO,Newd2HC,Newd2CO,zxHNewHC,zxHNewCO,zxNewHC,zxNewCO,Hd1Date19950701qHC,Hd1Date19950701qCO,d1Date19950701qHC,d1Date19950701qCO,Hd1Date1995070120000701HC,Hd1Date1995070120000701CO,d1Date1995070120000701HC,d1Date1995070120000701CO,Hd1Date20000701HC,Hd1Date20000701CO,d1Date20000701HC,d1Date20000701CO,Hd2Date19950701qHC,Hd2Date19950701qCO,d2Date19950701qHC,d2Date19950701qCO,Hd2Date1995070120011001HC,Hd2Date1995070120011001CO,d2Date1995070120011001HC,d2Date1995070120011001CO,Hd2Date20011001HC,Hd2Date20011001CO,d2Date20011001HC,d2Date20011001CO,HzxDate19950701qHC,HzxDate19950701qCO,zxDate19950701qHC,zxDate19950701qCO,HzxDate1995070120040901HC,HzxDate1995070120040901CO,zxDate1995070120040901HC,zxDate1995070120040901CO,HzxDate20040901HC,HzxDate20040901CO,zxDate20040901HC,zxDate20040901CO) values(@HNewd1HC,@HNewd1CO,@Newd1HC,@Newd1CO,@HNewd2HC,@HNewd2CO,@Newd2HC,@Newd2CO,@zxHNewHC,@zxHNewCO,@zxNewHC,@zxNewCO,@Hd1Date19950701qHC,@Hd1Date19950701qCO,@d1Date19950701qHC,@d1Date19950701qCO,@Hd1Date1995070120000701HC,@Hd1Date1995070120000701CO,@d1Date1995070120000701HC,@d1Date1995070120000701CO,@Hd1Date20000701HC,@Hd1Date20000701CO,@d1Date20000701HC,@d1Date20000701CO,@Hd2Date19950701qHC,@Hd2Date19950701qCO,@d2Date19950701qHC,@d2Date19950701qCO,@Hd2Date1995070120011001HC,@Hd2Date1995070120011001CO,@d2Date1995070120011001HC,@d2Date1995070120011001CO,@Hd2Date20011001HC,@Hd2Date20011001CO,@d2Date20011001HC,@d2Date20011001CO,@HzxDate19950701qHC,@HzxDate19950701qCO,@zxDate19950701qHC,@zxDate19950701qCO,@HzxDate1995070120040901HC,@HzxDate1995070120040901CO,@zxDate1995070120040901HC,@zxDate1995070120040901CO,@HzxDate20040901HC,@HzxDate20040901CO,@zxDate20040901HC,@zxDate20040901CO)"; SqlParameter[] sqr = { new SqlParameter("HNewd1HC", sds.HNewd1HC), new SqlParameter("HNewd1CO", sds.HNewd1CO), new SqlParameter("Newd1HC", sds.Newd1HC), new SqlParameter("Newd1CO", sds.Newd1CO), new SqlParameter("HNewd2HC", sds.HNewd2HC), new SqlParameter("HNewd2CO", sds.HNewd2CO), new SqlParameter("Newd2HC", sds.Newd2HC), new SqlParameter("Newd2CO", sds.Newd2CO), new SqlParameter("zxHNewHC", sds.zxHNewHC), new SqlParameter("zxHNewCO", sds.zxHNewCO), new SqlParameter("zxNewHC", sds.zxNewHC), new SqlParameter("zxNewCO", sds.zxNewCO), new SqlParameter("Hd1Date19950701qHC", sds.Hd1Date19950701qHC), new SqlParameter("Hd1Date19950701qCO", sds.Hd1Date19950701qCO), new SqlParameter("d1Date19950701qHC", sds.d1Date19950701qHC), new SqlParameter("d1Date19950701qCO", sds.d1Date19950701qCO), new SqlParameter("Hd1Date1995070120000701HC", sds.Hd1Date1995070120000701HC), new SqlParameter("Hd1Date1995070120000701CO", sds.Hd1Date1995070120000701CO), new SqlParameter("d1Date1995070120000701HC", sds.d1Date1995070120000701HC), new SqlParameter("d1Date1995070120000701CO", sds.d1Date1995070120000701CO), new SqlParameter("Hd1Date20000701HC", sds.Hd1Date20000701HC), new SqlParameter("Hd1Date20000701CO", sds.Hd1Date20000701CO), new SqlParameter("d1Date20000701HC", sds.d1Date20000701HC), new SqlParameter("d1Date20000701CO", sds.d1Date20000701CO), new SqlParameter("Hd2Date19950701qHC", sds.Hd2Date19950701qHC), new SqlParameter("Hd2Date19950701qCO", sds.Hd2Date19950701qCO), new SqlParameter("d2Date19950701qHC", sds.d2Date19950701qHC), new SqlParameter("d2Date19950701qCO", sds.d2Date19950701qCO), new SqlParameter("Hd2Date1995070120011001HC", sds.Hd2Date1995070120011001HC), new SqlParameter("Hd2Date1995070120011001CO", sds.Hd2Date1995070120011001CO), new SqlParameter("d2Date1995070120011001HC", sds.d2Date1995070120011001HC), new SqlParameter("d2Date1995070120011001CO", sds.d2Date1995070120011001CO), new SqlParameter("Hd2Date20011001HC", sds.Hd2Date20011001HC), new SqlParameter("Hd2Date20011001CO", sds.Hd2Date20011001CO), new SqlParameter("d2Date20011001HC", sds.d2Date20011001HC), new SqlParameter("d2Date20011001CO", sds.d2Date20011001CO), new SqlParameter("HzxDate19950701qHC", sds.HzxDate19950701qHC), new SqlParameter("HzxDate19950701qCO", sds.HzxDate19950701qCO), new SqlParameter("zxDate19950701qHC", sds.zxDate19950701qHC), new SqlParameter("zxDate19950701qCO", sds.zxDate19950701qCO), new SqlParameter("HzxDate1995070120040901HC", sds.HzxDate1995070120040901HC), new SqlParameter("HzxDate1995070120040901CO", sds.HzxDate1995070120040901CO), new SqlParameter("zxDate1995070120040901HC", sds.zxDate1995070120040901HC), new SqlParameter("zxDate1995070120040901CO", sds.zxDate1995070120040901CO), new SqlParameter("HzxDate20040901HC", sds.HzxDate20040901HC), new SqlParameter("HzxDate20040901CO", sds.HzxDate20040901CO), new SqlParameter("zxDate20040901HC", sds.zxDate20040901HC), new SqlParameter("zxDate20040901CO", sds.zxDate20040901CO), }; try { if (Have_GB("SDS_XZGB")) { string sql = "delete from SDS_XZGB"; DBHelperSQL.Execute(sql); if (DBHelperSQL.Execute(sqli, sqr) > 0) { return(1); } else { return(0); } } else { if (DBHelperSQL.Execute(sqli, sqr) > 0) { return(1); } else { return(0); } } } catch (Exception) { throw; } }