public VMAS_XZDB Get_VMAS_XZDB()
{
string sql = "select * from VMAS_XZDB";
VMAS_XZDB vmas_xzdb = new VMAS_XZDB();
try
{
DataTable dt = DBHelperSQL.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
vmas_xzdb.S1020d1date20000701bhc = dt.Rows[0]["S1020d120000701bhc"].ToString();
vmas_xzdb.S1020d1date20000701bco = dt.Rows[0]["S1020d120000701bco"].ToString();
vmas_xzdb.S1020d1date20000701bno = dt.Rows[0]["S1020d120000701bnox"].ToString();
vmas_xzdb.S10201470d1date20000701bhc = dt.Rows[0]["S10201470d120000701bhc"].ToString();
vmas_xzdb.S10201470d1date20000701bco = dt.Rows[0]["S10201470d120000701bco"].ToString();
vmas_xzdb.S10201470d1date20000701bno = dt.Rows[0]["S10201470d120000701bnox"].ToString();
vmas_xzdb.S14701930d1date20000701bhc = dt.Rows[0]["S14701930d120000701bhc"].ToString();
vmas_xzdb.S14701930d1date20000701bco = dt.Rows[0]["S14701930d120000701bco"].ToString();
vmas_xzdb.S14701930d1date20000701bno = dt.Rows[0]["S14701930d120000701bnox"].ToString();
vmas_xzdb.S1930d1date20000701bhc = dt.Rows[0]["S1930d120000701bhc"].ToString();
vmas_xzdb.S1930d1date20000701bco = dt.Rows[0]["S1930d120000701bco"].ToString();
vmas_xzdb.S1930d1date20000701bno = dt.Rows[0]["S1930d120000701bnox"].ToString();
vmas_xzdb.S1020d2date20011001bhc = dt.Rows[0]["S1020d220011001bhc"].ToString();
vmas_xzdb.S1020d2date20011001bco = dt.Rows[0]["S1020d220011001bco"].ToString();
vmas_xzdb.S1020d2date20011001bno = dt.Rows[0]["S1020d220011001bnox"].ToString();
vmas_xzdb.S10201470d2date20011001bhc = dt.Rows[0]["S10201470d220011001bhc"].ToString();
vmas_xzdb.S10201470d2date20011001bco = dt.Rows[0]["S10201470d220011001bco"].ToString();
vmas_xzdb.S10201470d2date20011001bno = dt.Rows[0]["S10201470d220011001bnox"].ToString();
vmas_xzdb.S14701930d2date20011001bhc = dt.Rows[0]["S14701930d220011001bhc"].ToString();
vmas_xzdb.S14701930d2date20011001bco = dt.Rows[0]["S14701930d220011001bco"].ToString();
vmas_xzdb.S14701930d2date20011001bno = dt.Rows[0]["S14701930d220011001bnox"].ToString();
vmas_xzdb.S1930d2date20011001bhc = dt.Rows[0]["S1930d220011001bhc"].ToString();
vmas_xzdb.S1930d2date20011001bco = dt.Rows[0]["S1930d220011001bco"].ToString();
vmas_xzdb.S1930d2date20011001bno = dt.Rows[0]["S1930d220011001bnox"].ToString();
vmas_xzdb.S1250d1date20000701ahcnox = dt.Rows[0]["S1250d120000701ahcnox"].ToString();
vmas_xzdb.S1250d1date20000701aco = dt.Rows[0]["S1250d120000701aco"].ToString();
vmas_xzdb.S12501700d1date20000701ahcnox = dt.Rows[0]["S12501700d120000701ahcnox"].ToString();
vmas_xzdb.S12501700d1date20000701aco = dt.Rows[0]["S12501700d120000701aco"].ToString();
vmas_xzdb.S1700d1date20000701ahcnox = dt.Rows[0]["S1700d120000701ahcnox"].ToString();
vmas_xzdb.S1700d1date20000701aco = dt.Rows[0]["S1700d120000701aco"].ToString();
vmas_xzdb.S1250d2date20011001ahcnox = dt.Rows[0]["S1250d220011001ahcnox"].ToString();
vmas_xzdb.S1250d2date20011001aco = dt.Rows[0]["S1250d220011001aco"].ToString();
vmas_xzdb.S12501700d2date20011001ahcnox = dt.Rows[0]["S12501700d220011001ahcnox"].ToString();
vmas_xzdb.S12501700d2date20011001aco = dt.Rows[0]["S12501700d220011001aco"].ToString();
vmas_xzdb.S1700d2date20011001ahcnox = dt.Rows[0]["S1700d220011001ahcnox"].ToString();
vmas_xzdb.S1700d2date20011001aco = dt.Rows[0]["S1700d220011001aco"].ToString();
}
return(vmas_xzdb);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用ASM对象插入或者更新数据
/// </summary>
/// <param name="asm"></param>
/// <returns>int 0为失败，1为插入成功</returns>
#endregion
#region 用VMAS对象插入或者更新数据
/// <summary>
/// 用VMAS对象插入或者更新数据
/// </summary>
/// <param name="vmas"></param>
/// <returns>int 0为失败，1为插入成功</returns>
public int Save_VMAS_XZDB(VMAS_XZDB vmas)
{
string sqli = "insert into VMAS_XZDB(S1020d1date20000701bhc, S1020d1date20000701bco,S1020d1date20000701bno,S10201470d1date20000701bhc,S10201470d1date20000701bco,S10201470d1date20000701bno,S14701930d1date20000701bhc,S14701930d1date20000701bco,S14701930d1date20000701bno, S1930d1date20000701bhc, S1930d1date20000701bco,S1930d1date20000701bno, S1020d2date20011001bhc, S1020d2date20011001bco,S1020d2date20011001bno, S10201470d2date20011001bhc, S10201470d2date20011001bco,S10201470d2date20011001bno,S14701930d2date20011001bhc, S14701930d2date20011001bco,S14701930d2date20011001bno, S1930d2date20011001bhc, S1930d2date20011001bco,S1930d2date20011001bno,S1250d1date20000701ahcnox, S1250d1date20000701aco, S12501700d1date20000701ahcnox, S12501700d1date20000701aco, S1700d1date20000701ahcnox, S1700d1date20000701aco, S1250d2date20011001ahcnox, S1250d2date20011001aco, S12501700d2date20011001ahcnox, S12501700d2date20011001aco, S1700d2date20011001ahcnox, S1700d2date20011001aco)";
SqlParameter[] sqr =
{
new SqlParameter("@S1020d1date20000701bhc", vmas.S1020d1date20000701bhc),
new SqlParameter("@S1020d1date20000701bco", vmas.S1020d1date20000701bco),
new SqlParameter("@S1020d1date20000701bno", vmas.S1020d1date20000701bno),
new SqlParameter("@S10201470d1date20000701bhc", vmas.S10201470d1date20000701bhc),
new SqlParameter("@S10201470d1date20000701bco", vmas.S10201470d1date20000701bco),
new SqlParameter("@S10201470d1date20000701bno", vmas.S10201470d1date20000701bno),
new SqlParameter("@S14701930d1date20000701bhc", vmas.S14701930d1date20000701bhc),
new SqlParameter("@S14701930d1date20000701bco", vmas.S14701930d1date20000701bco),
new SqlParameter("@S14701930d1date20000701bno", vmas.S14701930d1date20000701bno),
new SqlParameter("@S1930d1date20000701bhc", vmas.S1930d1date20000701bhc),
new SqlParameter("@S1930d1date20000701bco", vmas.S1930d1date20000701bco),
new SqlParameter("@S1930d1date20000701bno", vmas.S1930d1date20000701bno),
new SqlParameter("@S1020d2date20011001bhc", vmas.S1020d2date20011001bhc),
new SqlParameter("@S1020d2date20011001bco", vmas.S1020d2date20011001bco),
new SqlParameter("@S1020d2date20011001bno", vmas.S1020d2date20011001bno),
new SqlParameter("@S10201470d2date20011001bhc", vmas.S10201470d2date20011001bhc),
new SqlParameter("@S10201470d2date20011001bco", vmas.S10201470d2date20011001bco),
new SqlParameter("@S10201470d2date20011001bno", vmas.S10201470d2date20011001bno),
new SqlParameter("@S14701930d2date20011001bhc", vmas.S14701930d2date20011001bhc),
new SqlParameter("@S14701930d2date20011001bco", vmas.S14701930d2date20011001bco),
new SqlParameter("@S14701930d2date20011001bno", vmas.S14701930d2date20011001bno),
new SqlParameter("@S1930d2date20011001bhc", vmas.S1930d2date20011001bhc),
new SqlParameter("@S1930d2date20011001bco", vmas.S1930d2date20011001bco),
new SqlParameter("@S1930d2date20011001bno", vmas.S1930d2date20011001bno),
new SqlParameter("@S1250d1date20000701ahcnox", vmas.S1250d1date20000701ahcnox),
new SqlParameter("@S1250d1date20000701aco", vmas.S1250d1date20000701aco),
new SqlParameter("@S12501700d1date20000701ahcnox", vmas.S12501700d1date20000701ahcnox),
new SqlParameter("@S12501700d1date20000701aco", vmas.S12501700d1date20000701aco),
new SqlParameter("@S1700d1date20000701ahcnox", vmas.S1700d1date20000701ahcnox),
new SqlParameter("@S1700d1date20000701aco", vmas.S1700d1date20000701aco),
new SqlParameter("@S1250d2date20011001ahcnox", vmas.S1250d2date20011001ahcnox),
new SqlParameter("@S1250d2date20011001aco", vmas.S1250d2date20011001aco),
new SqlParameter("@S12501700d2date20011001ahcnox", vmas.S12501700d2date20011001ahcnox),
new SqlParameter("@S12501700d2date20011001aco", vmas.S12501700d2date20011001aco),
new SqlParameter("@S1700d2date20011001ahcnox", vmas.S1700d2date20011001ahcnox),
new SqlParameter("@S1700d2date20011001aco", vmas.S1700d2date20011001aco)
};
try
{
if (Have_GB("VMAS_XZDB"))
{
//删除原来所有数据再插入新数据
string sql = "delete from VMAS_XZDB";
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;
}
}
