/// <summary>
/// 用JZJS对象插入或更新条检测数据
/// </summary>
/// <param name="JZJS">JZJS</param>
/// <returns>int 0为失败，1为插入成功，2为更新成功</returns>
public int Save_JZJS(JZJS jzjs)
{
string sqli = "insert into jzjs(GLXZXS,ACTMAXHP,REALVELMAXHP,VELMAXHP,VELMAXHPZS,RATEREVUP,RATEREVDOWN,JYLSH,JYCS,SBRZBM,CLID,CLPH,HK,NK,EK,HNO,NNO,ENO,YDXZ,HKPD,NKPD,EKPD,MAXLBGL,GLXZ,GLPD,MAXLBZS,ZSXZ,ZSPD,ZHPD,JCRQ,WD,SD,DQY,SBMC,SBXH,SBZZC,CGJXH,CGJBH,CGJZZC,YDJXH,YDJBH,YDJZZC,ZSJXH,ZSJBH,ZSJZZC) values(@GLXZXS,@ACTMAXHP,@REALVELMAXHP,@VELMAXHP,@VELMAXHPZS,@RATEREVUP,@RATEREVDOWN,@JYLSH,@JYCS,@SBRZBM,@CLID,@CLPH,@HK,@NK,@EK,@HNO,@NNO,@ENO,@YDXZ,@HKPD,@NKPD,@EKPD,@MAXLBGL,@GLXZ,@GLPD,@MAXLBZS,@ZSXZ,@ZSPD,@ZHPD,@JCRQ,@WD,@SD,@DQY,@SBMC,@SBXH,@SBZZC,@CGJXH,@CGJBH,@CGJZZC,@YDJXH,@YDJBH,@YDJZZC,@ZSJXH,@ZSJBH,@ZSJZZC)";
string sqlu = "update jzjs set GLXZXS=@GLXZXS,ACTMAXHP=@ACTMAXHP,REALVELMAXHP=@REALVELMAXHP,VELMAXHP=@VELMAXHP,VELMAXHPZS=@VELMAXHPZS,RATEREVUP=@RATEREVUP,RATEREVDOWN=@RATEREVDOWN,JYLSH=@JYLSH,JYCS=@JYCS,SBRZBM=@SBRZBM,CLPH=@CLPH,HK=@HK,NK=@NK,EK=@EK,HNO=@HNO,NNO=@NNO,ENO=@ENO,YDXZ=@YDXZ,HKPD=@HKPD,NKPD=@NKPD,EKPD=@EKPD,MAXLBGL=@MAXLBGL,GLXZ=@GLXZ,GLPD=@GLPD,MAXLBZS=@MAXLBZS,ZSXZ=@ZSXZ,ZSPD=@ZSPD,ZHPD=@ZHPD,JCRQ=@JCRQ,WD=@WD,SD=@SD,DQY=@DQY,SBMC=@SBMC,SBXH=@SBXH,SBZZC=@SBZZC,CGJXH=@CGJXH,CGJBH=@CGJBH,CGJZZC=@CGJZZC,YDJXH=@YDJXH,YDJBH=@YDJBH,YDJZZC=@YDJZZC,ZSJXH=@ZSJXH,ZSJBH=@ZSJBH,ZSJZZC=@ZSJZZC where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@GLXZXS", jzjs.GLXZXS),
new SqlParameter("@ACTMAXHP", jzjs.ACTMAXHP),
new SqlParameter("@REALVELMAXHP", jzjs.REALVELMAXHP),
new SqlParameter("@VELMAXHP", jzjs.VELMAXHP),
new SqlParameter("@VELMAXHPZS", jzjs.VELMAXHPZS),
new SqlParameter("@RATEREVUP", jzjs.RATEREVUP),
new SqlParameter("@RATEREVDOWN", jzjs.RATEREVDOWN),
new SqlParameter("@JYLSH", jzjs.JYLSH),
new SqlParameter("@JYCS", jzjs.JYCS),
new SqlParameter("@SBRZBM", jzjs.SBRZBM),
new SqlParameter("@CLID", jzjs.CLID), //1
new SqlParameter("@CLPH", jzjs.CLPH),
new SqlParameter("@HK", jzjs.HK),
new SqlParameter("@NK", jzjs.NK),
new SqlParameter("@EK", jzjs.EK),
new SqlParameter("@HNO", jzjs.HNO),
new SqlParameter("@NNO", jzjs.NNO),
new SqlParameter("@ENO", jzjs.ENO),
new SqlParameter("@YDXZ", jzjs.YDXZ), //6
new SqlParameter("@HKPD", jzjs.HKPD),
new SqlParameter("@NKPD", jzjs.NKPD),
new SqlParameter("@EKPD", jzjs.EKPD),
new SqlParameter("@MAXLBGL", jzjs.MAXLBGL),
new SqlParameter("@GLXZ", jzjs.GLXZ),
new SqlParameter("@GLPD", jzjs.GLPD),
new SqlParameter("@MAXLBZS", jzjs.MAXLBZS), //11
new SqlParameter("@ZSXZ", jzjs.ZSXZ),
new SqlParameter("@ZSPD", jzjs.ZSPD),
new SqlParameter("@ZHPD", jzjs.ZHPD),
new SqlParameter("@JCRQ", jzjs.JCRQ),
new SqlParameter("@WD", jzjs.WD),
new SqlParameter("@SD", jzjs.SD),
new SqlParameter("@DQY", jzjs.DQY), //16
new SqlParameter("@SBMC", jzjs.SBMC),
new SqlParameter("@SBXH", jzjs.SBXH),
new SqlParameter("@SBZZC", jzjs.SBZZC),
new SqlParameter("@CGJXH", jzjs.CGJXH),
new SqlParameter("@CGJBH", jzjs.CGJBH), //21
new SqlParameter("@CGJZZC", jzjs.CGJZZC),
new SqlParameter("@YDJXH", jzjs.YDJXH),
new SqlParameter("@YDJBH", jzjs.YDJBH),
new SqlParameter("@YDJZZC", jzjs.YDJZZC),
new SqlParameter("@ZSJXH", jzjs.ZSJXH),
new SqlParameter("@ZSJBH", jzjs.ZSJBH),
new SqlParameter("@ZSJZZC", jzjs.ZSJZZC) //47
};
try
{
if (Have_JZJS(jzjs.CLID))
{
if (DBHelperSQL.Execute(sqlu, spr) > 0)
{
return(2);
}
else
{
return(0);
}
}
else
{
if (DBHelperSQL.Execute(sqli, spr) > 0)
{
return(1);
}
else
{
return(0);
}
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用JZJS对象插入或更新条检测数据
/// </summary>
/// <param name="JZJS">JZJS</param>
/// <returns>int 0为失败，1为插入成功，2为更新成功</returns>
public int Save_JZJS(JZJS jzjs)
{
string sqli = "insert into jzjs(CLID,CLPH,HK,NK,EK,YDXZ,HKPD,NKPD,EKPD,MAXLBGL,GLXZ,GLPD,MAXLBZS,ZSXZ,ZSPD,ZHPD,JCRQ,WD,SD,DQY,SBMC,SBXH,SBZZC,CGJXH,CGJBH,CGJZZC,YDJXH,YDJBH,YDJZZC,ZSJXH,ZSJBH,ZSJZZC) values(@CLID,@CLPH,@HK,@NK,@EK,@YDXZ,@HKPD,@NKPD,@EKPD,@MAXLBGL,@GLXZ,@GLPD,@MAXLBZS,@ZSXZ,@ZSPD,@ZHPD,@JCRQ,@WD,@SD,@DQY,@SBMC,@SBXH,@SBZZC,@CGJXH,@CGJBH,@CGJZZC,@YDJXH,@YDJBH,@YDJZZC,@ZSJXH,@ZSJBH,@ZSJZZC)";
string sqlu = "update jzjs set CLPH=@CLPH,HK=@HK,NK=@NK,EK=@EK,YDXZ=@YDXZ,HKPD=@HKPD,NKPD=@NKPD,EKPD=@EKPD,MAXLBGL=@MAXLBGL,GLXZ=@GLXZ,GLPD=@GLPD,MAXLBZS=@MAXLBZS,ZSXZ=@ZSXZ,ZSPD=@ZSPD,ZHPD=@ZHPD,JCRQ=@JCRQ,WD=@WD,SD=@SD,DQY=@DQY,SBMC=@SBMC,SBXH=@SBXH,SBZZC=@SBZZC,CGJXH=@CGJXH,CGJBH=@CGJBH,CGJZZC=@CGJZZC,YDJXH=@YDJXH,YDJBH=@YDJBH,YDJZZC=@YDJZZC,ZSJXH=@ZSJXH,ZSJBH=@ZSJBH,ZSJZZC=@ZSJZZC where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@CLID", jzjs.CLID), //1
new SqlParameter("@CLPH", jzjs.CLPH),
new SqlParameter("@HK", jzjs.HK),
new SqlParameter("@NK", jzjs.NK),
new SqlParameter("@EK", jzjs.EK),
new SqlParameter("@YDXZ", jzjs.YDXZ), //6
new SqlParameter("@HKPD", jzjs.HKPD),
new SqlParameter("@NKPD", jzjs.NKPD),
new SqlParameter("@EKPD", jzjs.EKPD),
new SqlParameter("@MAXLBGL", jzjs.MAXLBGL),
new SqlParameter("@GLXZ", jzjs.GLXZ),
new SqlParameter("@GLPD", jzjs.GLPD),
new SqlParameter("@MAXLBZS", jzjs.MAXLBZS), //11
new SqlParameter("@ZSXZ", jzjs.ZSXZ),
new SqlParameter("@ZSPD", jzjs.ZSPD),
new SqlParameter("@ZHPD", jzjs.ZHPD),
new SqlParameter("@JCRQ", jzjs.JCRQ),
new SqlParameter("@WD", jzjs.WD),
new SqlParameter("@SD", jzjs.SD),
new SqlParameter("@DQY", jzjs.DQY), //16
new SqlParameter("@SBMC", jzjs.SBMC),
new SqlParameter("@SBXH", jzjs.SBXH),
new SqlParameter("@SBZZC", jzjs.SBZZC),
new SqlParameter("@CGJXH", jzjs.CGJXH),
new SqlParameter("@CGJBH", jzjs.CGJBH), //21
new SqlParameter("@CGJZZC", jzjs.CGJZZC),
new SqlParameter("@YDJXH", jzjs.YDJXH),
new SqlParameter("@YDJBH", jzjs.YDJBH),
new SqlParameter("@YDJZZC", jzjs.YDJZZC),
new SqlParameter("@ZSJXH", jzjs.ZSJXH),
new SqlParameter("@ZSJBH", jzjs.ZSJBH),
new SqlParameter("@ZSJZZC", jzjs.ZSJZZC) //47
};
try
{
if (Have_JZJS(jzjs.CLID))
{
if (DBHelperSQL.Execute(sqlu, spr) > 0)
{
return(2);
}
else
{
return(0);
}
}
else
{
if (DBHelperSQL.Execute(sqli, spr) > 0)
{
return(1);
}
else
{
return(0);
}
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用检测编号和次数查询一条检测数据
/// </summary>
/// <param name="jcbh">检测编号</param>
/// <param name="jccs">检测次数</param>
/// <returns>JZJS检测数据Model</returns>
public JZJS Get_JZJS(string CLID)
{
DateTime a;
string sql = "select * from JZJS where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@CLID", CLID)
};
try
{
JZJS JZJS = new JZJS();
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
JZJS.CLID = dt.Rows[0]["CLID"].ToString();//1
JZJS.CLPH = dt.Rows[0]["CLPH"].ToString();
JZJS.HK = dt.Rows[0]["HK"].ToString();
JZJS.NK = dt.Rows[0]["NK"].ToString();
JZJS.EK = dt.Rows[0]["EK"].ToString();
JZJS.YDXZ = dt.Rows[0]["YDXZ"].ToString();//6
JZJS.HKPD = dt.Rows[0]["HKPD"].ToString();
JZJS.NKPD = dt.Rows[0]["NKPD"].ToString();
JZJS.EKPD = dt.Rows[0]["EKPD"].ToString();
JZJS.MAXLBGL = dt.Rows[0]["MAXLBGL"].ToString();
JZJS.GLXZ = dt.Rows[0]["GLXZ"].ToString();
JZJS.GLPD = dt.Rows[0]["GLPD"].ToString();
JZJS.MAXLBZS = dt.Rows[0]["MAXLBZS"].ToString(); //11
JZJS.ZSXZ = dt.Rows[0]["ZSXZ"].ToString(); //11
JZJS.ZSPD = dt.Rows[0]["ZSPD"].ToString(); //11
JZJS.ZHPD = dt.Rows[0]["ZHPD"].ToString();
DateTime.TryParse(dt.Rows[0]["JCRQ"].ToString(), out a);
if (a != null)
{
JZJS.JCRQ = a;
}
else
{
JZJS.JCRQ = DateTime.Today;
}
JZJS.WD = dt.Rows[0]["WD"].ToString();
JZJS.SD = dt.Rows[0]["SD"].ToString();
JZJS.DQY = dt.Rows[0]["DQY"].ToString();//16
JZJS.SBMC = dt.Rows[0]["SBMC"].ToString();
JZJS.SBXH = dt.Rows[0]["SBXH"].ToString();
JZJS.SBZZC = dt.Rows[0]["SBZZC"].ToString();
JZJS.CGJXH = dt.Rows[0]["CGJXH"].ToString();
JZJS.CGJBH = dt.Rows[0]["CGJBH"].ToString();//21
JZJS.CGJZZC = dt.Rows[0]["CGJZZC"].ToString();
JZJS.YDJXH = dt.Rows[0]["YDJXH"].ToString();
JZJS.YDJBH = dt.Rows[0]["YDJBH"].ToString();
JZJS.YDJZZC = dt.Rows[0]["YDJZZC"].ToString();
JZJS.ZSJXH = dt.Rows[0]["ZSJXH"].ToString();
JZJS.ZSJBH = dt.Rows[0]["ZSJBH"].ToString();
JZJS.ZSJZZC = dt.Rows[0]["ZSJZZC"].ToString();
}
else
{
JZJS.CLID = "-2";
}
return(JZJS);
}
catch (Exception)
{
throw;
}
}
public void init_data(string jcbh, string jcff)
{
if (jcff == "简易瞬态工况法")
{
VMAS vmasdata = vmasdal.Get_VMAS(jcbh);
label_cp.Text = vmasdata.JCCLPH;
label_bh.Text = vmasdata.JCBH;
label_ff.Text = jcff;
string[] vmas_cs = vmasdata.MMCS.Split(',');
string[] vmas_o2 = vmasdata.MMO2.Split(',');
string[] vmas_co = vmasdata.MMCO.Split(',');
string[] vmas_co2 = vmasdata.MMCO2.Split(',');
string[] vmas_hc = vmasdata.MMHC.Split(',');
string[] vmas_no = vmasdata.MMNO.Split(',');
string[] vmas_xisio2 = vmasdata.MMXSO2.Split(',');
string[] vmas_lljll = vmasdata.MMBZLL.Split(',');
string[] vmas_sjll = vmasdata.MMSJLL.Split(',');
string[] vmas_xsb = vmasdata.MMXSXS.Split(',');
string[] vmas_cozl = vmasdata.MMCOZL.Split(',');
string[] vmas_hczl = vmasdata.MMHCZL.Split(',');
string[] vmas_nozl = vmasdata.MMNOZL.Split(',');
string[] vmas_lljyl = vmasdata.MMLLJYL.Split(',');
string[] vmas_lljwd = vmasdata.MMLLJWD.Split(',');
if (vmasdata.GKSJ != "")
{
for (int i = 0; i < int.Parse(vmasdata.GKSJ); i++)
{
DataRow dr = dt.NewRow();
dr["工况时间（s）"] = i.ToString();
if (vmas_cs.Length > i)
{
dr["车速(m/s)"] = vmas_cs[i];
}
if (vmas_o2.Length > i)
{
dr["O2浓度（%）"] = vmas_o2[i];
}
if (vmas_co.Length > i)
{
dr["CO浓度（%）"] = vmas_co[i];
}
if (vmas_co2.Length > i)
{
dr["CO2浓度（%）"] = vmas_co2[i];
}
if (vmas_hc.Length > i)
{
dr["HC浓度（10-6）"] = vmas_hc[i];
}
if (vmas_no.Length > i)
{
dr["NO浓度（10-6）"] = vmas_no[i];
}
if (vmas_xisio2.Length > i)
{
dr["稀释O2浓度（%）"] = vmas_xisio2[i];
}
if (vmas_lljll.Length > i)
{
dr["流量计流量（L/s）"] = vmas_lljll[i];
}
if (vmas_sjll.Length > i)
{
dr["尾气实际流量（L/s）"] = vmas_sjll[i];
}
if (vmas_xsb.Length > i)
{
dr["稀释比"] = vmas_xsb[i];
}
if (vmas_cozl.Length > i)
{
dr["CO质量（mg）"] = vmas_cozl[i];
}
if (vmas_nozl.Length > i)
{
dr["NO质量（mg）"] = vmas_nozl[i];
}
if (vmas_hczl.Length > i)
{
dr["HC质量（mg）"] = vmas_hczl[i];
}
if (vmas_lljwd.Length > i)
{
dr["流量计温度（℃）"] = vmas_lljwd[i];
}
if (vmas_lljyl.Length > i)
{
dr["流量计压力（kPa）"] = vmas_lljyl[i];
}
dt.Rows.Add(dr);
dataGridView1.DataSource = dt;
}
}
}
else if (jcff == "加载减速法")
{
JZJS jzjsdata = jzjsdal.Get_JZJS(jcbh);
label_cp.Text = jzjsdata.JCCLPH;
label_bh.Text = jzjsdata.JCBH;
label_ff.Text = jcff;
string[] jzjs_cs = jzjsdata.MMZGXSD.Split(',');
string[] jzjs_zs = jzjsdata.MMFDJZS.Split(',');
string[] jzjs_btg = jzjsdata.MMXGK.Split(',');
string[] jzjs_nl = jzjsdata.MMZGZDL.Split(',');
string[] jzjs_power = jzjsdata.MMCGJFH.Split(',');
if (jzjsdata.GKSJ != null && jzjsdata.GKSJ != 0)
{
for (int i = 0; i < jzjsdata.GKSJ; i++)
{
DataRow dr = dt.NewRow();
dr["工况时间（s）"] = i.ToString();
if (jzjs_cs.Length > i)
{
dr["车速(m/s)"] = jzjs_cs[i];
}
if (jzjs_nl.Length > i)
{
dr["扭力（N）"] = jzjs_nl[i];
}
if (jzjs_power.Length > i)
{
dr["功率（KW）"] = jzjs_power[i];
}
if (jzjs_zs.Length > i)
{
dr["转速（转/分）"] = jzjs_zs[i];
}
if (jzjs_btg.Length > i)
{
dr["烟度值（m-1）"] = jzjs_btg[i];
}
dt.Rows.Add(dr);
dataGridView1.DataSource = dt;
}
}
}
}
