/// <summary>
/// 用ASM对象插入或更新条检测数据
/// </summary>
/// <param name="asm">ASM</param>
/// <returns>int 0为失败，1为插入成功，2为更新成功</returns>
public int Save_ASM(ASM asm)
{
string sqli = "insert into asm(CLID,CLPH,CO25CLZ,CO25XZ,CO25PD,HC25CLZ,HC25XZ,HC25PD,NOX25CLZ,NOX25XZ,NOX25PD,CO40CLZ,CO40XZ,CO40PD,HC40CLZ,HC40XZ,HC40PD,NOX40CLZ,NOX40XZ,NOX40PD,ZHPD,JCRQ,WD,SD,DQY,SBMC,SBXH,SBZZC,CGJXH,CGJBH,CGJZZC,FXYXH,FXYBH,FXYZZC,FDJZS5025,FDJYW5025,FDJZS2540,FDJYW2540,JCBGBH,SHY,SYNCHDATE,YW,JCKSSJ,JCJSSJ,LAMBDA5025,LAMBDA2540,CO25025,O25025,CO22540,O22540,JYLSH,JYCS,JZZGL5025,JZZGL2540,SBRZBM) values(@CLID,@CLPH,@CO25CLZ,@CO25XZ,@CO25PD,@HC25CLZ,@HC25XZ,@HC25PD,@NOX25CLZ,@NOX25XZ,@NOX25PD,@CO40CLZ,@CO40XZ,@CO40PD,@HC40CLZ,@HC40XZ,@HC40PD,@NOX40CLZ,@NOX40XZ,@NOX40PD,@ZHPD,@JCRQ,@WD,@SD,@DQY,@SBMC,@SBXH,@SBZZC,@CGJXH,@CGJBH,@CGJZZC,@FXYXH,@FXYBH,@FXYZZC,@FDJZS5025,@FDJYW5025,@FDJZS2540,@FDJYW2540,@JCBGBH,@SHY,@SYNCHDATE,@YW,@JCKSSJ,@JCJSSJ,@LAMBDA5025,@LAMBDA2540,@CO25025,@O25025,@CO22540,@O22540,@JYLSH,@JYCS,@JZZGL5025,@JZZGL2540,@SBRZBM)";
string sqlu = "update asm set CLPH=@CLPH,CO25CLZ=@CO25CLZ,CO25XZ=@CO25XZ,CO25PD=@CO25PD,HC25CLZ=@HC25CLZ,HC25XZ=@HC25XZ,HC25PD=@HC25PD,NOX25CLZ=@NOX25CLZ,NOX25XZ=@NOX25XZ,NOX25PD=@NOX25PD,CO40CLZ=@CO40CLZ,CO40XZ=@CO40XZ,CO40PD=@CO40PD,HC40CLZ=@HC40CLZ,HC40XZ=@HC40XZ,HC40PD=@HC40PD,NOX40CLZ=@NOX40CLZ,NOX40XZ=@NOX40XZ,NOX40PD=@NOX40PD,ZHPD=@ZHPD,JCRQ=@JCRQ,WD=@WD,SD=@SD,DQY=@DQY,SBMC=@SBMC,SBXH=@SBXH,SBZZC=@SBZZC,CGJXH=@CGJXH,CGJBH=@CGJBH,CGJZZC=@CGJZZC,FXYXH=@FXYXH,FXYBH=@FXYBH,FXYZZC=@FXYZZC,FDJZS5025=@FDJZS5025,FDJYW5025=@FDJYW5025,FDJZS2540=@FDJZS2540,FDJYW2540=@FDJYW2540,JCBGBH=@JCBGBH,SHY=@SHY,SYNCHDATE=@SYNCHDATE,YW=@YW,JCKSSJ=@JCKSSJ,JCJSSJ=@JCJSSJ,LAMBDA5025=@LAMBDA5025,LAMBDA2540=@LAMBDA2540,CO25025=@CO25025,O25025=@O25025,CO22540=@CO22540,O22540=@O22540,JYLSH=@JYLSH,JYCS=@JYCS,JZZGL5025=@JZZGL5025,JZZGL2540=@JZZGL2540,SBRZBM=@SBRZBM where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@CLID", asm.CLID), //1
new SqlParameter("@CLPH", asm.CLPH), //1
new SqlParameter("@CO25CLZ", asm.CO25CLZ),
new SqlParameter("@CO25XZ", asm.CO25XZ),
new SqlParameter("@CO25PD", asm.CO25PD),
new SqlParameter("@HC25CLZ", asm.HC25CLZ), //6
new SqlParameter("@HC25XZ", asm.HC25XZ),
new SqlParameter("@HC25PD", asm.HC25PD),
new SqlParameter("@NOX25CLZ", asm.NOX25CLZ),
new SqlParameter("@NOX25XZ", asm.NOX25XZ),
new SqlParameter("@NOX25PD", asm.NOX25PD), //11
new SqlParameter("@CO40CLZ", asm.CO40CLZ),
new SqlParameter("@CO40XZ", asm.CO40XZ),
new SqlParameter("@CO40PD", asm.CO40PD),
new SqlParameter("@HC40CLZ", asm.HC40CLZ), //6
new SqlParameter("@HC40XZ", asm.HC40XZ),
new SqlParameter("@HC40PD", asm.HC40PD),
new SqlParameter("@NOX40CLZ", asm.NOX40CLZ),
new SqlParameter("@NOX40XZ", asm.NOX40XZ),
new SqlParameter("@NOX40PD", asm.NOX40PD), //11
new SqlParameter("@ZHPD", asm.ZHPD),
new SqlParameter("@JCRQ", asm.JCRQ),
new SqlParameter("@WD", asm.WD),
new SqlParameter("@SD", asm.SD),
new SqlParameter("@DQY", asm.DQY), //16
new SqlParameter("@SBMC", asm.SBMC),
new SqlParameter("@SBXH", asm.SBXH),
new SqlParameter("@SBZZC", asm.SBZZC),
new SqlParameter("@CGJXH", asm.CGJXH),
new SqlParameter("@CGJBH", asm.CGJBH), //21
new SqlParameter("@CGJZZC", asm.CGJZZC),
new SqlParameter("@FXYXH", asm.FXYXH),
new SqlParameter("@FXYBH", asm.FXYBH),
new SqlParameter("@FXYZZC", asm.FXYZZC),
new SqlParameter("@FDJZS5025", asm.FDJZS5025),
new SqlParameter("@FDJYW5025", asm.FDJYW5025), //21
new SqlParameter("@FDJZS2540", asm.FDJZS2540),
new SqlParameter("@FDJYW2540", asm.FDJYW2540),
new SqlParameter("@JCBGBH", asm.JCBGBH),
new SqlParameter("@SHY", asm.SHY), //21
new SqlParameter("@SYNCHDATE", asm.SYNCHDATE),
new SqlParameter("@YW", asm.YW),
new SqlParameter("@JCKSSJ", asm.JCKSSJ),
new SqlParameter("@JCJSSJ", asm.JCJSSJ),
new SqlParameter("@LAMBDA5025", asm.LAMBDA5025),
new SqlParameter("@LAMBDA2540", asm.LAMBDA2540),
new SqlParameter("@CO25025", asm.CO25025),
new SqlParameter("@O25025", asm.O25025),
new SqlParameter("@CO22540", asm.CO22540),
new SqlParameter("@O22540", asm.O22540),
new SqlParameter("@JYLSH", asm.JYLSH),
new SqlParameter("@JYCS", asm.JYCS),
new SqlParameter("@JZZGL5025", asm.JZZGL5025),
new SqlParameter("@JZZGL2540", asm.JZZGL2540),
new SqlParameter("@SBRZBM", asm.SBRZBM)
};
try
{
if (Have_ASM(asm.CLID))
{
ini.INIIO.saveLogInf("Save_ASM()过程中发现ID号重复：" + asm.CLID);
if (DBHelperSQL.Execute(sqlu, spr) > 0)
{
ini.INIIO.saveLogInf("更新结果成功，ID号：" + asm.CLID);
return(2);
}
else
{
ini.INIIO.saveLogInf("更新结果失败，ID号：" + asm.CLID);
return(0);
}
}
else
{
if (DBHelperSQL.Execute(sqli, spr) > 0)
{
ini.INIIO.saveLogInf("Save_ASM()成功，ID号：" + asm.CLID);
return(1);
}
else
{
ini.INIIO.saveLogInf("Save_ASM()失败，ID号：" + asm.CLID);
return(0);
}
}
}
catch (Exception er)
{
ini.INIIO.saveLogInf("Save_ASM()过程中出现异常：" + er.Message);
throw;
}
}
public bool saveInertnessDataByIni(inertness model, string stationid, string lineid, DateTime bdrq)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [惯量测试] (");
strSql.Append("STATIONID,"); //=@PZLX,");1
strSql.Append("LINEID,"); //=@JCCLPH,");2
strSql.Append("T1POWER,"); //=@CLXHBH,");3
strSql.Append("T2POWER,"); //=@CLXHBH,");3
strSql.Append("STARTSPEED,"); //=@JCCS,");4
strSql.Append("ENDSPEED,"); //=@CCRQ,");5
strSql.Append("ACD1_1,"); //=@DJRQ,"); 6
strSql.Append("ACD1_2,"); //=@FDJH,");7
strSql.Append("ACD1_3,"); //=@CJH,");8
strSql.Append("ACD1,"); //=@CZ,");9
strSql.Append("ACD2_1,"); //=@DJRQ,"); 6
strSql.Append("ACD2_2,"); //=@FDJH,");7
strSql.Append("ACD2_3,"); //=@CJH,");8
strSql.Append("ACD2,"); //=@CZ,");9
strSql.Append("DIW_1,"); //=@DJRQ,"); 6
strSql.Append("DIW_2,"); //=@FDJH,");7
strSql.Append("DIW_3,"); //=@CJH,");8
strSql.Append("DIW,"); //=@CZ,");9
strSql.Append("DIW_BC,"); //=@CZDH,");10
strSql.Append("DIW_SC,"); //=@CZDZ,");11
strSql.Append("WC,"); //=@CZ,");9
strSql.Append("PD,"); //=@CZDH,");10
strSql.Append("HXSJ,"); //=@CZDZ,");11
strSql.Append("BZ,"); //=@LCBDS,");12
strSql.Append("BDJG,"); //=@HBBZ,");13
strSql.Append("BDRQ) "); //=@SYQK,");14
strSql.Append("values (@STATIONID,@LINEID,@T1POWER,@T2POWER,@STARTSPEED,@ENDSPEED,@ACD1_1,@ACD1_2,@ACD1_3,@ACD1,@ACD2_1,@ACD2_2,@ACD2_3,@ACD2,@DIW_1,@DIW_2,@DIW_3,@DIW,@DIW_BC,@DIW_SC,@WC,@PD,@HXSJ,@BZ,@BDJG,@BDRQ)");
SqlParameter[] parameters =
{
new SqlParameter("@STATIONID", SqlDbType.VarChar, 50),
new SqlParameter("@LINEID", SqlDbType.VarChar, 50),
new SqlParameter("@T1POWER", SqlDbType.VarChar, 50),
new SqlParameter("@T2POWER", SqlDbType.VarChar, 100),
new SqlParameter("@STARTSPEED", SqlDbType.VarChar, 50),
new SqlParameter("@ENDSPEED", SqlDbType.VarChar, 50),
new SqlParameter("@ACD1_1", SqlDbType.VarChar, 50),
new SqlParameter("@ACD1_2", SqlDbType.VarChar, 50),
new SqlParameter("@ACD1_3", SqlDbType.VarChar, 50),
new SqlParameter("@ACD1", SqlDbType.VarChar, 50),
new SqlParameter("@ACD2_1", SqlDbType.VarChar, 50),
new SqlParameter("@ACD2_2", SqlDbType.VarChar, 50),
new SqlParameter("@ACD2_3", SqlDbType.VarChar, 50),
new SqlParameter("@ACD2", SqlDbType.VarChar, 50),
new SqlParameter("@DIW_1", SqlDbType.VarChar, 50),
new SqlParameter("@DIW_2", SqlDbType.VarChar, 50),
new SqlParameter("@DIW_3", SqlDbType.VarChar, 50),
new SqlParameter("@DIW", SqlDbType.VarChar, 50),
new SqlParameter("@DIW_BC", SqlDbType.VarChar, 50),
new SqlParameter("@DIW_SC", SqlDbType.VarChar, 50),
new SqlParameter("@WC", SqlDbType.VarChar, 50),
new SqlParameter("@PD", SqlDbType.VarChar, 50),
new SqlParameter("@HXSJ", SqlDbType.VarChar, 50),
new SqlParameter("@BZ", SqlDbType.VarChar, 50),
new SqlParameter("@BDJG", SqlDbType.VarChar, 50),
new SqlParameter("@BDRQ", SqlDbType.DateTime)
};
parameters[i++].Value = stationid;
parameters[i++].Value = lineid;
parameters[i++].Value = model.T1power;
parameters[i++].Value = model.T2power;
parameters[i++].Value = model.StartSpeed;
parameters[i++].Value = model.EndSpeed;
parameters[i++].Value = model.Acd1_1;
parameters[i++].Value = model.Acd1_2;
parameters[i++].Value = model.Acd1_3;
parameters[i++].Value = model.Acd1;
parameters[i++].Value = model.Acd2_1;
parameters[i++].Value = model.Acd2_2;
parameters[i++].Value = model.Acd2_3;
parameters[i++].Value = model.Acd2;
parameters[i++].Value = model.Diw_1;
parameters[i++].Value = model.Diw_2;
parameters[i++].Value = model.Diw_3;
parameters[i++].Value = model.Diw;
parameters[i++].Value = model.Diw_bc;
parameters[i++].Value = model.Diw_sc;
parameters[i++].Value = model.Wc;
parameters[i++].Value = model.Pd;
parameters[i++].Value = model.Hxsj;
parameters[i++].Value = model.Bz;
parameters[i++].Value = model.Bdjg;
parameters[i++].Value = bdrq;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用检测编号和次数查询一条检测数据
/// </summary>
/// <param name="jcbh">检测编号</param>
/// <param name="jccs">检测次数</param>
/// <returns>SDS检测数据Model</returns>
public SDS Get_SDS(string CLID)
{
DateTime a;
string sql = "select * from SDS where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@CLID", CLID)
};
try
{
SDS SDS = new SDS();
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
SDS.CLID = dt.Rows[0]["CLID"].ToString(); //1
SDS.JCBGBH = dt.Rows[0]["JCBGBH"].ToString(); //1
SDS.CLPH = dt.Rows[0]["CLPH"].ToString();
SDS.COLOWCLZ = dt.Rows[0]["COLOWCLZ"].ToString();
SDS.COLOWXZ = dt.Rows[0]["COLOWXZ"].ToString();
SDS.HCLOWCLZ = dt.Rows[0]["HCLOWCLZ"].ToString();
SDS.HCLOWXZ = dt.Rows[0]["HCLOWXZ"].ToString();//6
SDS.COHIGHCLZ = dt.Rows[0]["COHIGHCLZ"].ToString();
SDS.COHIGHXZ = dt.Rows[0]["COHIGHXZ"].ToString();
SDS.HCHIGHCLZ = dt.Rows[0]["HCHIGHCLZ"].ToString();
SDS.HCHIGHXZ = dt.Rows[0]["HCHIGHXZ"].ToString();
SDS.LAMDAHIGHCLZ = dt.Rows[0]["LAMDAHIGHCLZ"].ToString(); //11
SDS.LAMDAHIGHXZ = dt.Rows[0]["LAMDAHIGHXZ"].ToString(); //11
SDS.LAMDAHIGHPD = dt.Rows[0]["LAMDAHIGHPD"].ToString(); //11
SDS.LOWPD = dt.Rows[0]["LOWPD"].ToString(); //11
SDS.HIGHPD = dt.Rows[0]["HIGHPD"].ToString(); //11
SDS.ZHPD = dt.Rows[0]["ZHPD"].ToString();
DateTime.TryParse(dt.Rows[0]["JCRQ"].ToString(), out a);
if (a != null)
{
SDS.JCRQ = a;
}
else
{
SDS.JCRQ = DateTime.Today;
}
SDS.WD = dt.Rows[0]["WD"].ToString();
SDS.SD = dt.Rows[0]["SD"].ToString();
SDS.DQY = dt.Rows[0]["DQY"].ToString();//16
SDS.SBMC = dt.Rows[0]["SBMC"].ToString();
SDS.SBXH = dt.Rows[0]["SBXH"].ToString();
SDS.SBZZC = dt.Rows[0]["SBZZC"].ToString();
SDS.ZSJXH = dt.Rows[0]["ZSJXH"].ToString();
SDS.ZSJBH = dt.Rows[0]["ZSJBH"].ToString();//21
SDS.ZSJZZC = dt.Rows[0]["ZSJZZC"].ToString();
SDS.FXYXH = dt.Rows[0]["FXYXH"].ToString();
SDS.FXYBH = dt.Rows[0]["FXYBH"].ToString();
SDS.FXYZZC = dt.Rows[0]["FXYZZC"].ToString();
SDS.COLOWPD = dt.Rows[0]["COLOWPD"].ToString();
SDS.HCLOWPD = dt.Rows[0]["HCLOWPD"].ToString();
SDS.ZSLOW = dt.Rows[0]["ZSLOW"].ToString();
SDS.JYWDLOW = dt.Rows[0]["JYWDLOW"].ToString();
SDS.COHIGHPD = dt.Rows[0]["COHIGHPD"].ToString();
SDS.HCHIGHPD = dt.Rows[0]["HCHIGHPD"].ToString();
SDS.ZSHIGH = dt.Rows[0]["ZSHIGH"].ToString();
SDS.JYWDHIGH = dt.Rows[0]["JYWDHIGH"].ToString();
SDS.SHY = dt.Rows[0]["SHY"].ToString();
SDS.SYNCHDATE = dt.Rows[0]["SYNCHDATE"].ToString();
SDS.YW = dt.Rows[0]["YW"].ToString();
SDS.GLKQXSSX = dt.Rows[0]["GLKQXSSX"].ToString();
SDS.GLKQXSXX = dt.Rows[0]["GLKQXSXX"].ToString();
SDS.JCKSSJ = dt.Rows[0]["JCKSSJ"].ToString();
SDS.JCJSSJ = dt.Rows[0]["JCJSSJ"].ToString();
SDS.CO2HIGH = dt.Rows[0]["CO2HIGH"].ToString();
SDS.O2HIGH = dt.Rows[0]["O2HIGH"].ToString();
SDS.CO2LOW = dt.Rows[0]["CO2LOW"].ToString();
SDS.O2LOW = dt.Rows[0]["O2LOW"].ToString();
SDS.COLOWXXZ = dt.Rows[0]["COLOWXXZ"].ToString();
SDS.COHIGHXXZ = dt.Rows[0]["COHIGHXXZ"].ToString();
SDS.COLOWXYZ = dt.Rows[0]["COLOWXYZ"].ToString();
SDS.COHIGHXYZ = dt.Rows[0]["COHIGHXYZ"].ToString();
SDS.CO2LOWXYZ = dt.Rows[0]["CO2LOWXYZ"].ToString();
SDS.CO2HIGHXYZ = dt.Rows[0]["CO2HIGHXYZ"].ToString();
SDS.HCLOWXYZ = dt.Rows[0]["HCLOWXYZ"].ToString();
SDS.HCHIGHXYZ = dt.Rows[0]["HCHIGHXYZ"].ToString();
}
else
{
SDS.CLID = "-2";
}
return(SDS);
}
catch (Exception)
{
throw;
}
}
public bool saveAnalysisData(ANALYSISMETER model)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [废气仪标定] (");
strSql.Append("STATIONID,"); //=@PZLX,");1
strSql.Append("LINEID,"); //=@JCCLPH,");2
strSql.Append("CO2BZ,"); //=@CLXHBH,");3
strSql.Append("CO2CLZ,"); //=@CLXHBH,");3
strSql.Append("COBZ,"); //=@JCCS,");4
strSql.Append("COCLZ,"); //=@CCRQ,");5
strSql.Append("HCBZ,"); //=@DJRQ,"); 6
strSql.Append("HCCLZ,"); //=@FDJH,");7
strSql.Append("NOBZ,"); //=@CJH,");8
strSql.Append("NOCLZ,"); //=@CZ,");9
strSql.Append("JZDS,"); //=@CZDH,");10
strSql.Append("GDJZ,"); //=@CZDZ,");11
strSql.Append("BZSM,"); //=@LCBDS,");12
strSql.Append("BDJG,"); //=@HBBZ,");13
strSql.Append("BDRQ) "); //=@SYQK,");14
strSql.Append("values (@STATIONID,@LINEID,@CO2BZ,@CO2CLZ,@COBZ,@COCLZ,@HCBZ,@HCCLZ,@NOBZ,@NOCLZ,@JZDS,@GDJZ,@BZSM,@BDJG,@BDRQ)");
SqlParameter[] parameters =
{
new SqlParameter("@STATIONID", SqlDbType.VarChar, 50),
new SqlParameter("@LINEID", SqlDbType.VarChar, 50),
new SqlParameter("@CO2BZ", SqlDbType.VarChar, 50),
new SqlParameter("@CO2CLZ", SqlDbType.VarChar, 100),
new SqlParameter("@COBZ", SqlDbType.VarChar, 50),
new SqlParameter("@COCLZ", SqlDbType.VarChar, 50),
new SqlParameter("@HCBZ", SqlDbType.VarChar, 50),
new SqlParameter("@HCCLZ", SqlDbType.VarChar, 50),
new SqlParameter("@NOBZ", SqlDbType.VarChar, 50),
new SqlParameter("@NOCLZ", SqlDbType.VarChar, 50),
new SqlParameter("@JZDS", SqlDbType.VarChar, 50),
new SqlParameter("@GDJZ", SqlDbType.VarChar, 50),
new SqlParameter("@BZSM", SqlDbType.VarChar, 50),
new SqlParameter("@BDJG", SqlDbType.VarChar, 50),
new SqlParameter("@BDRQ", SqlDbType.DateTime)
};
parameters[i++].Value = model.STATIONID;
parameters[i++].Value = model.LINEID;
parameters[i++].Value = model.CO2BZ;
parameters[i++].Value = model.CO2CLZ;
parameters[i++].Value = model.COBZ;
parameters[i++].Value = model.COCLZ;
parameters[i++].Value = model.HCBZ;
parameters[i++].Value = model.HCCLZ;
parameters[i++].Value = model.NOBZ;
parameters[i++].Value = model.NOCLZ;
parameters[i++].Value = model.JZDS;
parameters[i++].Value = model.GDJZ;
parameters[i++].Value = model.BZSM;
parameters[i++].Value = model.BDJG;
parameters[i++].Value = model.BDRQ;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
public bool saveGlideDataByIni(glide model, string stationid, string lineid, DateTime bdrq)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [加载滑行试验] (");
strSql.Append("STATIONID,"); //=@PZLX,");1
strSql.Append("LINEID,"); //=@JCCLPH,");2
strSql.Append("HXQJ,"); //=@CLXHBH,");3
strSql.Append("QJMYSD,"); //=@CLXHBH,");3
strSql.Append("PLHP,"); //=@JCCS,");4
strSql.Append("CCDT,"); //=@CCRQ,");5
strSql.Append("ACDT,"); //=@DJRQ,"); 6
strSql.Append("WC,"); //=@FDJH,");7
strSql.Append("JZSDGL,"); //=@CJH,");8
strSql.Append("BZSM,"); //=@LCBDS,");12
strSql.Append("BDJG,"); //=@HBBZ,");13
strSql.Append("BDRQ) "); //=@SYQK,");14
strSql.Append("values (@STATIONID,@LINEID,@HXQJ,@QJMYSD,@PLHP,@CCDT,@ACDT,@WC,@JZSDGL,@BZSM,@BDJG,@BDRQ)");
SqlParameter[] parameters =
{
new SqlParameter("@STATIONID", SqlDbType.VarChar, 50),
new SqlParameter("@LINEID", SqlDbType.VarChar, 50),
new SqlParameter("@HXQJ", SqlDbType.VarChar, 50),
new SqlParameter("@QJMYSD", SqlDbType.VarChar, 100),
new SqlParameter("@PLHP", SqlDbType.VarChar, 50),
new SqlParameter("@CCDT", SqlDbType.VarChar, 50),
new SqlParameter("@ACDT", SqlDbType.VarChar, 50),
new SqlParameter("@WC", SqlDbType.VarChar, 50),
new SqlParameter("@JZSDGL", SqlDbType.VarChar, 50),
new SqlParameter("@BZSM", SqlDbType.VarChar, 50),
new SqlParameter("@BDJG", SqlDbType.VarChar, 50),
new SqlParameter("@BDRQ", SqlDbType.DateTime)
};
parameters[i++].Value = stationid;
parameters[i++].Value = lineid;
parameters[i++].Value = model.Hxqj;
parameters[i++].Value = model.Qjmysd;
parameters[i++].Value = model.Plhp;
parameters[i++].Value = model.Ccdt;
parameters[i++].Value = model.Acdt;
parameters[i++].Value = model.Wc;
parameters[i++].Value = model.Jzsdgl;
parameters[i++].Value = model.Bzsm;
parameters[i++].Value = model.Bdjg;
parameters[i++].Value = bdrq;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
public bool savemoneyRecordInf(MONEY model)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [收费记录] (");
strSql.Append("CLID,");
strSql.Append("CLHP,");
strSql.Append("DLSJ,");
strSql.Append("EXHAUST,");
strSql.Append("SAFE,");
strSql.Append("EXHAUSTSTANDARDFY,");
strSql.Append("SAFESTANDARDFY,");
strSql.Append("EXHAUSTFY,");
strSql.Append("SAFEFY,");
strSql.Append("EXHAUSTBZ,");
strSql.Append("SAFEBZ,");
strSql.Append("FY,");
strSql.Append("SKR,");
strSql.Append("TF,");
strSql.Append("TFFY,");
strSql.Append("CZ,");
strSql.Append("SFSJ)");
strSql.Append("values (@CLID,@CLHP,@DLSJ,@EXHAUST,@SAFE,@EXHAUSTSTANDARDFY,@SAFESTANDARDFY,@EXHAUSTFY,@SAFEFY,@EXHAUSTBZ,@SAFEBZ,@FY,@SKR,@TF,@TFFY,@CZ,@SFSJ)");
SqlParameter[] parameters =
{
new SqlParameter("@CLID", SqlDbType.VarChar, 50),
new SqlParameter("@CLHP", SqlDbType.VarChar, 50),
new SqlParameter("@DLSJ", SqlDbType.DateTime),
new SqlParameter("@EXHAUST", SqlDbType.VarChar, 50),
new SqlParameter("@SAFE", SqlDbType.VarChar, 50),
new SqlParameter("@EXHAUSTSTANDARDFY", SqlDbType.VarChar, 50),
new SqlParameter("@SAFESTANDARDFY", SqlDbType.VarChar, 50),
new SqlParameter("@EXHAUSTFY", SqlDbType.VarChar, 50),
new SqlParameter("@SAFEFY", SqlDbType.VarChar, 50),
new SqlParameter("@EXHAUSTBZ", SqlDbType.VarChar, 50),
new SqlParameter("@SAFEBZ", SqlDbType.VarChar, 50),
new SqlParameter("@FY", SqlDbType.VarChar, 50),
new SqlParameter("@SKR", SqlDbType.VarChar, 50),
new SqlParameter("@TF", SqlDbType.VarChar, 50),
new SqlParameter("@TFFY", SqlDbType.VarChar, 50),
new SqlParameter("@CZ", SqlDbType.VarChar, 50),
new SqlParameter("@SFSJ", SqlDbType.DateTime)
};
parameters[i++].Value = model.CLID;
parameters[i++].Value = model.CLHP;
parameters[i++].Value = model.DLSJ;
parameters[i++].Value = model.EXHAUST;
parameters[i++].Value = model.SAFE;
parameters[i++].Value = model.EXHAUSTSTANDARDFY;
parameters[i++].Value = model.SAFESTANDARDFY;
parameters[i++].Value = model.EXHAUSTFY;
parameters[i++].Value = model.SAFEFY;
parameters[i++].Value = model.EXHAUSTBZ;
parameters[i++].Value = model.SAFEBZ;
parameters[i++].Value = model.FY;
parameters[i++].Value = model.SKR;
parameters[i++].Value = model.TF;
parameters[i++].Value = model.TFFY;
parameters[i++].Value = model.CZ;
parameters[i++].Value = model.SFSJ;
try
{
if (checkMoneyRecordIsAlive(model.CLID))
{
if (updateMoneyRecordInf(model))
{
return(true);
}
else
{
return(false);
}
}
else
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
throw;
}
}
public bool saveSdDataByIni(sdbddata model, string stationid, string lineid, DateTime bdrq)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [速度标定] (");
strSql.Append("STATIONID,"); //=@PZLX,");1
strSql.Append("LINEID,"); //=@JCCLPH,");2
strSql.Append("BZ1,"); //=@CLXHBH,");3
strSql.Append("CLZ1,"); //=@CLXHBH,");3
strSql.Append("WC1,"); //=@JCCS,");4
strSql.Append("BZ2,"); //=@CLXHBH,");3
strSql.Append("CLZ2,"); //=@CLXHBH,");3
strSql.Append("WC2,"); //=@JCCS,");4
strSql.Append("BZ3,"); //=@CLXHBH,");3
strSql.Append("CLZ3,"); //=@CLXHBH,");3
strSql.Append("WC3,"); //=@JCCS,");4
strSql.Append("BDDS,"); //=@CCRQ,");5
strSql.Append("BDJG,"); //=@DJRQ,"); 6
strSql.Append("BZSM,"); //=@FDJH,");7
strSql.Append("BDRQ) "); //=@SYQK,");14
strSql.Append("values (@STATIONID,@LINEID,@BZ1,@CLZ1,@WC1,@BZ2,@CLZ2,@WC2,@BZ3,@CLZ3,@WC3,@BDDS,@BDJG,@BZSM,@BDRQ)");
SqlParameter[] parameters =
{
new SqlParameter("@STATIONID", SqlDbType.VarChar, 50),
new SqlParameter("@LINEID", SqlDbType.VarChar, 50),
new SqlParameter("@BZ1", SqlDbType.VarChar, 50),
new SqlParameter("@CLZ1", SqlDbType.VarChar, 50),
new SqlParameter("@WC1", SqlDbType.VarChar, 50),
new SqlParameter("@BZ2", SqlDbType.VarChar, 50),
new SqlParameter("@CLZ2", SqlDbType.VarChar, 50),
new SqlParameter("@WC2", SqlDbType.VarChar, 50),
new SqlParameter("@BZ3", SqlDbType.VarChar, 50),
new SqlParameter("@CLZ3", SqlDbType.VarChar, 50),
new SqlParameter("@WC3", SqlDbType.VarChar, 50),
new SqlParameter("@BDDS", SqlDbType.VarChar, 50),
new SqlParameter("@BDJG", SqlDbType.VarChar, 50),
new SqlParameter("@BZSM", SqlDbType.VarChar, 50),
new SqlParameter("@BDRQ", SqlDbType.DateTime)
};
parameters[i++].Value = stationid;
parameters[i++].Value = lineid;
parameters[i++].Value = model.Bz1;
parameters[i++].Value = model.Clz1;
parameters[i++].Value = model.Wc1;
parameters[i++].Value = model.Bz2;
parameters[i++].Value = model.Clz2;
parameters[i++].Value = model.Wc2;
parameters[i++].Value = model.Bz3;
parameters[i++].Value = model.Clz3;
parameters[i++].Value = model.Wc3;
parameters[i++].Value = model.Bdds;
parameters[i++].Value = model.Bdjg;
parameters[i++].Value = model.Bzsm;
parameters[i++].Value = bdrq;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用ASM对象插入或更新条检测数据
/// </summary>
/// <param name="asm">ASM</param>
/// <returns>int 0为失败，1为插入成功，2为更新成功</returns>
public int Save_VMAS(VMAS vmas)
{
string sqli = "insert into vmas(CSLJCCSJ,XSLC,JYLSH,JYCS,SBRZBM,CLID,CLPH,COZL,COXZ,COPD,NOXZL,NOXXZ,NOXPD,HCZL,HCXZ,HCPD,ZHPD,JCRQ,WD,SD,DQY,SBMC,SBXH,SBZZC,CGJXH,CGJBH,CGJZZC,FXYXH,FXYBH,FXYZZC,LLJXH,LLJBH,LLJZZC,BEFORE) values(@CSLJCCSJ,@XSLC,@JYLSH,@JYCS,@SBRZBM,@CLID,@CLPH,@COZL,@COXZ,@COPD,@NOXZL,@NOXXZ,@NOXPD,@HCZL,@HCXZ,@HCPD,@ZHPD,@JCRQ,@WD,@SD,@DQY,@SBMC,@SBXH,@SBZZC,@CGJXH,@CGJBH,@CGJZZC,@FXYXH,@FXYBH,@FXYZZC,@LLJXH,@LLJBH,@LLJZZC,@BEFORE)";
string sqlu = "update vmas set CSLJCCSJ=@CSLJCCSJ,XSLC=@XSLC,JYLSH=@JYLSH,JYCS=@JYCS,SBRZBM=@SBRZBM,CLPH=@CLPH,COZL=@COZL,COXZ=@COXZ,COPD=@COPD,NOXZL=@NOXZL,NOXXZ=@NOXXZ,NOXPD=@NOXPD,HCZL=@HCZL,HCXZ=@HCXZ,HCPD=@HCPD,ZHPD=@ZHPD,JCRQ=@JCRQ,WD=@WD,SD=@SD,DQY=@DQY,SBMC=@SBMC,SBXH=@SBXH,SBZZC=@SBZZC,CGJXH=@CGJXH,CGJBH=@CGJBH,CGJZZC=@CGJZZC,FXYXH=@FXYXH,FXYBH=@FXYBH,FXYZZC=@FXYZZC,LLJXH=@LLJXH,LLJBH=@LLJBH,LLJZZC=@LLJZZC,BEFORE=@BEFORE where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@CSLJCCSJ", vmas.CSLJCCSJ),
new SqlParameter("@XSLC", vmas.XSLC),
new SqlParameter("@JYLSH", vmas.JYLSH),
new SqlParameter("@JYCS", vmas.JYCS),
new SqlParameter("@SBRZBM", vmas.SBRZBM),
new SqlParameter("@CLID", vmas.CLID), //1
new SqlParameter("@CLPH", vmas.CLPH),
new SqlParameter("@COZL", vmas.COZL),
new SqlParameter("@COXZ", vmas.COXZ),
new SqlParameter("@COPD", vmas.COPD),
new SqlParameter("@NOXZL", vmas.NOXZL), //6
new SqlParameter("@NOXXZ", vmas.NOXXZ),
new SqlParameter("@NOXPD", vmas.NOXPD),
new SqlParameter("@HCZL", vmas.HCZL),
new SqlParameter("@HCXZ", vmas.HCXZ),
new SqlParameter("@HCPD", vmas.HCPD), //11
new SqlParameter("@ZHPD", vmas.ZHPD),
new SqlParameter("@JCRQ", vmas.JCRQ),
new SqlParameter("@WD", vmas.WD),
new SqlParameter("@SD", vmas.SD),
new SqlParameter("@DQY", vmas.DQY), //16
new SqlParameter("@SBMC", vmas.SBMC),
new SqlParameter("@SBXH", vmas.SBXH),
new SqlParameter("@SBZZC", vmas.SBZZC),
new SqlParameter("@CGJXH", vmas.CGJXH),
new SqlParameter("@CGJBH", vmas.CGJBH), //21
new SqlParameter("@CGJZZC", vmas.CGJZZC),
new SqlParameter("@FXYXH", vmas.FXYXH),
new SqlParameter("@FXYBH", vmas.FXYBH),
new SqlParameter("@FXYZZC", vmas.FXYZZC), //47
new SqlParameter("@LLJXH", vmas.LLJXH),
new SqlParameter("@LLJBH", vmas.LLJBH),
new SqlParameter("@LLJZZC", vmas.LLJZZC), //47
new SqlParameter("@BEFORE", vmas.BEFORE)
};
try
{
if (Have_VMAS(vmas.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 VMASseconds Get_VMASDataSeconds(string clhp, DateTime jcsj)
{
DateTime a;
string sql = "select * from VMAS_DATASECONDS where clhp=@clhp and convert(varchar(50),jcsj,120)=convert(varchar(50),@jcsj,120)";
SqlParameter[] spr =
{
new SqlParameter("@clhp", clhp),
new SqlParameter("@jcsj", jcsj.ToString("yyyy-MM-dd HH:mm:ss"))
};
try
{
VMASseconds asm = new VMASseconds();
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
asm.CLID = dt.Rows[0]["CLID"].ToString();//1
asm.CLHP = dt.Rows[0]["CLHP"].ToString();
asm.JCSJ = DateTime.Parse(dt.Rows[0]["JCSJ"].ToString());
asm.MMTIME = dt.Rows[0]["MMTIME"].ToString();
asm.MMSX = dt.Rows[0]["MMSX"].ToString();
asm.MMLB = dt.Rows[0]["MMLB"].ToString();
asm.MMHC = dt.Rows[0]["MMHC"].ToString();//6
asm.MMCO = dt.Rows[0]["MMCO"].ToString();
asm.MMO2 = dt.Rows[0]["MMO2"].ToString();
asm.MMCO2 = dt.Rows[0]["MMCO2"].ToString();
asm.MMNO = dt.Rows[0]["MMNO"].ToString();
asm.MMCOZL = dt.Rows[0]["MMCOZL"].ToString();
asm.MMHCZL = dt.Rows[0]["MMHCZL"].ToString();
asm.MMNOZL = dt.Rows[0]["MMNOZL"].ToString();
asm.MMXSO2 = dt.Rows[0]["MMXSO2"].ToString();
asm.MMHJO2 = dt.Rows[0]["MMHJO2"].ToString();
asm.MMSJLL = dt.Rows[0]["MMSJLL"].ToString();
asm.MMBZLL = dt.Rows[0]["MMBZLL"].ToString();
asm.MMWQLL = dt.Rows[0]["MMWQLL"].ToString();
asm.MMXSB = dt.Rows[0]["MMXSB"].ToString();
asm.MMWD = dt.Rows[0]["MMWD"].ToString();//11
asm.MMSD = dt.Rows[0]["MMSD"].ToString();
asm.MMDQY = dt.Rows[0]["MMDQY"].ToString();
asm.MMLLJWD = dt.Rows[0]["MMLLJWD"].ToString();
asm.MMLLJYL = dt.Rows[0]["MMLLJYL"].ToString();
asm.MMCS = dt.Rows[0]["MMCS"].ToString();
asm.MMBZCS = dt.Rows[0]["MMBZCS"].ToString();
asm.MMXSXZ = dt.Rows[0]["MMXSXZ"].ToString();
asm.MMSDXZ = dt.Rows[0]["MMSDXZ"].ToString();
asm.MMGLYL = dt.Rows[0]["MMGLYL"].ToString();
asm.MMYW = dt.Rows[0]["MMYW"].ToString();
asm.MMJSGL = dt.Rows[0]["MMJSGL"].ToString();//11
asm.MMNJ = dt.Rows[0]["MMNJ"].ToString();
asm.MMGL = dt.Rows[0]["MMGL"].ToString();
}
else
{
asm.CLID = "-2";
}
return(asm);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用JZJS插入逐秒数据
/// </summary>
/// <param name="JZJS">JZJS</param>
/// <returns>int 0为失败，1为插入成功，2为更新成功</returns>
public int Save_VMASSseconds(VMASseconds asm)
{
string sqli = "insert into VMAS_DATASECONDS(JYLSH,JYCS,CYDS,MMZS,MMZSGL,MMJZGL,MMCO2ZL,CLID,CLHP,JCSJ,MMTIME,MMSX,MMLB,MMHC,MMCO,MMO2,MMCO2,MMNO,MMCOZL,MMHCZL,MMNOZL,MMXSO2,MMHJO2,MMSJLL,MMBZLL,MMWQLL,MMXSB,MMWD,MMSD,MMDQY,MMLLJWD,MMLLJYL,MMCS,MMBZCS,MMGL,MMNJ,MMXSXZ,MMSDXZ,MMGLYL,MMYW,MMJSGL) values(@JYLSH,@JYCS,@CYDS,@MMZS,@MMZSGL,@MMJZGL,@MMCO2ZL,@CLID,@CLHP,@JCSJ,@MMTIME,@MMSX,@MMLB,@MMHC,@MMCO,@MMO2,@MMCO2,@MMNO,@MMCOZL,@MMHCZL,@MMNOZL,@MMXSO2,@MMHJO2,@MMSJLL,@MMBZLL,@MMWQLL,@MMXSB,@MMWD,@MMSD,@MMDQY,@MMLLJWD,@MMLLJYL,@MMCS,@MMBZCS,@MMGL,@MMNJ,@MMXSXZ,@MMSDXZ,@MMGLYL,@MMYW,@MMJSGL)";
string sqlu = "update VMAS_DATASECONDS set JYLSH=@JYLSH,JYCS=@JYCS,CYDS=@CYDS,MMZS=@MMZS,MMZSGL=@MMZSGL,MMJZGL=@MMJZGL,MMCO2ZL=@MMCO2ZL,CLHP=@CLHP,JCSJ=@JCSJ,MMTIME=@MMTIME,MMSX=@MMSX,MMLB=@MMLB,MMHC=@MMHC,MMCO=@MMCO,MMO2=@MMO2,MMCO2=@MMCO2,MMNO=@MMNO,MMCOZL=@MMCOZL,MMHCZL=@MMHCZL,MMNOZL=@MMNOZL,MMXSO2=@MMXSO2,MMHJO2=@MMHJO2,MMSJLL=@MMSJLL,MMBZLL=@MMBZLL,MMWQLL=@MMWQLL,MMXSB=@MMXSB,MMWD=@MMWD,MMSD=@MMSD,MMDQY=@MMDQY,MMLLJWD=@MMLLJWD,MMLLJYL=@MMLLJYL,MMCS=@MMCS,MMBZCS=@MMBZCS,MMGL=@MMGL,MMNJ=@MMNJ,MMXSXZ=@MMXSXZ,MMSDXZ=@MMSDXZ,MMGLYL=@MMGLYL,MMYW=@MMYW,MMJSGL=@MMJSGL where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@JYLSH", asm.JYLSH),
new SqlParameter("@JYCS", asm.JYCS),
new SqlParameter("@CYDS", asm.CYDS),
new SqlParameter("@MMZS", asm.MMZS),
new SqlParameter("@MMZSGL", asm.MMZSGL),
new SqlParameter("@MMJZGL", asm.MMJZGL),
new SqlParameter("@MMCO2ZL", asm.MMCO2ZL),
new SqlParameter("@CLID", asm.CLID), //1
new SqlParameter("@CLHP", asm.CLHP),
new SqlParameter("@JCSJ", asm.JCSJ),
new SqlParameter("@MMTIME", asm.MMTIME),
new SqlParameter("@MMSX", asm.MMSX),
new SqlParameter("@MMLB", asm.MMLB), //6
new SqlParameter("@MMHC", asm.MMHC),
new SqlParameter("@MMCO", asm.MMCO),
new SqlParameter("@MMO2", asm.MMO2),
new SqlParameter("@MMCO2", asm.MMCO2),
new SqlParameter("@MMNO", asm.MMNO),
new SqlParameter("@MMCOZL", asm.MMCOZL),
new SqlParameter("@MMHCZL", asm.MMHCZL),
new SqlParameter("@MMNOZL", asm.MMNOZL),
new SqlParameter("@MMXSO2", asm.MMXSO2), //6
new SqlParameter("@MMHJO2", asm.MMHJO2),
new SqlParameter("@MMSJLL", asm.MMSJLL),
new SqlParameter("@MMBZLL", asm.MMBZLL),
new SqlParameter("@MMWQLL", asm.MMWQLL),
new SqlParameter("@MMXSB", asm.MMXSB),
new SqlParameter("@MMWD", asm.MMWD),
new SqlParameter("@MMSD", asm.MMSD),
new SqlParameter("@MMDQY", asm.MMDQY),
new SqlParameter("@MMLLJWD", asm.MMLLJWD),
new SqlParameter("@MMLLJYL", asm.MMLLJYL),
new SqlParameter("@MMCS", asm.MMCS),
new SqlParameter("@MMBZCS", asm.MMBZCS),
new SqlParameter("@MMXSXZ", asm.MMXSXZ),
new SqlParameter("@MMSDXZ", asm.MMSDXZ), //6
new SqlParameter("@MMGLYL", asm.MMGLYL),
new SqlParameter("@MMYW", asm.MMYW),
new SqlParameter("@MMJSGL", asm.MMJSGL),
new SqlParameter("@MMGL", asm.MMGL),
new SqlParameter("@MMNJ", asm.MMNJ) //6
//47
};
try
{
if (Have_VMASseconds(asm.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;
return(0);
}
}
/// <summary>
/// 用检测编号和次数查询一条检测数据
/// </summary>
/// <param name="jcbh">检测编号</param>
/// <param name="jccs">检测次数</param>
/// <returns>ASM检测数据Model</returns>
public VMAS Get_VMAS(string CLID)
{
DateTime a;
string sql = "select * from vmas where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@CLID", CLID)
};
try
{
VMAS vmas = new VMAS();
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
vmas.CLID = dt.Rows[0]["CLID"].ToString();//1
vmas.CLPH = dt.Rows[0]["CLPH"].ToString();
vmas.COZL = dt.Rows[0]["COZL"].ToString();
vmas.COXZ = dt.Rows[0]["COXZ"].ToString();
vmas.COPD = dt.Rows[0]["COPD"].ToString();
vmas.NOXZL = dt.Rows[0]["NOXZL"].ToString();//6
vmas.NOXXZ = dt.Rows[0]["NOXXZ"].ToString();
vmas.NOXPD = dt.Rows[0]["NOXPD"].ToString();
vmas.HCZL = dt.Rows[0]["HCZL"].ToString();
vmas.HCXZ = dt.Rows[0]["HCXZ"].ToString();
vmas.HCPD = dt.Rows[0]["HCPD"].ToString();//11
vmas.ZHPD = dt.Rows[0]["ZHPD"].ToString();
DateTime.TryParse(dt.Rows[0]["JCRQ"].ToString(), out a);
if (a != null)
{
vmas.JCRQ = a;
}
else
{
vmas.JCRQ = DateTime.Today;
}
vmas.WD = dt.Rows[0]["WD"].ToString();
vmas.SD = dt.Rows[0]["SD"].ToString();
vmas.DQY = dt.Rows[0]["DQY"].ToString();//16
vmas.SBMC = dt.Rows[0]["SBMC"].ToString();
vmas.SBXH = dt.Rows[0]["SBXH"].ToString();
vmas.SBZZC = dt.Rows[0]["SBZZC"].ToString();
vmas.CGJXH = dt.Rows[0]["CGJXH"].ToString();
vmas.CGJBH = dt.Rows[0]["CGJBH"].ToString();//21
vmas.CGJZZC = dt.Rows[0]["CGJZZC"].ToString();
vmas.FXYXH = dt.Rows[0]["FXYXH"].ToString();
vmas.FXYBH = dt.Rows[0]["FXYBH"].ToString();
vmas.FXYZZC = dt.Rows[0]["FXYZZC"].ToString();
vmas.LLJXH = dt.Rows[0]["LLJXH"].ToString();
vmas.LLJBH = dt.Rows[0]["LLJBH"].ToString();
vmas.LLJZZC = dt.Rows[0]["LLJZZC"].ToString();
vmas.BEFORE = dt.Rows[0]["BEFORE"].ToString();
}
else
{
vmas.CLID = "-2";
}
return(vmas);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用ASM对象插入或更新条检测数据
/// </summary>
/// <param name="asm">ASM</param>
/// <returns>int 0为失败，1为插入成功，2为更新成功</returns>
public int Save_ASM(ASM asm)
{
string sqli = "insert into asm(CLID,CLPH,CO25CLZ,CO25XZ,CO25PD,HC25CLZ,HC25XZ,HC25PD,NOX25CLZ,NOX25XZ,NOX25PD,CO40CLZ,CO40XZ,CO40PD,HC40CLZ,HC40XZ,HC40PD,NOX40CLZ,NOX40XZ,NOX40PD,ZHPD,JCRQ,WD,SD,DQY,SBMC,SBXH,SBZZC,CGJXH,CGJBH,CGJZZC,FXYXH,FXYBH,FXYZZC) values(@CLID,@CLPH,@CO25CLZ,@CO25XZ,@CO25PD,@HC25CLZ,@HC25XZ,@HC25PD,@NOX25CLZ,@NOX25XZ,@NOX25PD,@CO40CLZ,@CO40XZ,@CO40PD,@HC40CLZ,@HC40XZ,@HC40PD,@NOX40CLZ,@NOX40XZ,@NOX40PD,@ZHPD,@JCRQ,@WD,@SD,@DQY,@SBMC,@SBXH,@SBZZC,@CGJXH,@CGJBH,@CGJZZC,@FXYXH,@FXYBH,@FXYZZC)";
string sqlu = "update asm set CLPH=@CLPH,CO25CLZ=@CO25CLZ,CO25XZ=@CO25XZ,CO25PD=@CO25PD,HC25CLZ=@HC25CLZ,HC25XZ=@HC25XZ,HC25PD=@HC25PD,NOX25CLZ=@NOX25CLZ,NOX25XZ=@NOX25XZ,NOX25PD=@NOX25PD,CO40CLZ=@CO40CLZ,CO40XZ=@CO40XZ,CO40PD=@CO40PD,HC40CLZ=@HC40CLZ,HC40XZ=@HC40XZ,HC40PD=@HC40PD,NOX40CLZ=@NOX40CLZ,NOX40XZ=@NOX40XZ,NOX40PD=@NOX40PD,ZHPD=@ZHPD,JCRQ=@JCRQ,WD=@WD,SD=@SD,DQY=@DQY,SBMC=@SBMC,SBXH=@SBXH,SBZZC=@SBZZC,CGJXH=@CGJXH,CGJBH=@CGJBH,CGJZZC=@CGJZZC,FXYXH=@FXYXH,FXYBH=@FXYBH,FXYZZC=@FXYZZC where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@CLID", asm.CLID), //1
new SqlParameter("@CLPH", asm.CLPH), //1
new SqlParameter("@CO25CLZ", asm.CO25CLZ),
new SqlParameter("@CO25XZ", asm.CO25XZ),
new SqlParameter("@CO25PD", asm.CO25PD),
new SqlParameter("@HC25CLZ", asm.HC25CLZ), //6
new SqlParameter("@HC25XZ", asm.HC25XZ),
new SqlParameter("@HC25PD", asm.HC25PD),
new SqlParameter("@NOX25CLZ", asm.NOX25CLZ),
new SqlParameter("@NOX25XZ", asm.NOX25XZ),
new SqlParameter("@NOX25PD", asm.NOX25PD), //11
new SqlParameter("@CO40CLZ", asm.CO40CLZ),
new SqlParameter("@CO40XZ", asm.CO40XZ),
new SqlParameter("@CO40PD", asm.CO40PD),
new SqlParameter("@HC40CLZ", asm.HC40CLZ), //6
new SqlParameter("@HC40XZ", asm.HC40XZ),
new SqlParameter("@HC40PD", asm.HC40PD),
new SqlParameter("@NOX40CLZ", asm.NOX40CLZ),
new SqlParameter("@NOX40XZ", asm.NOX40XZ),
new SqlParameter("@NOX40PD", asm.NOX40PD), //11
new SqlParameter("@ZHPD", asm.ZHPD),
new SqlParameter("@JCRQ", asm.JCRQ),
new SqlParameter("@WD", asm.WD),
new SqlParameter("@SD", asm.SD),
new SqlParameter("@DQY", asm.DQY), //16
new SqlParameter("@SBMC", asm.SBMC),
new SqlParameter("@SBXH", asm.SBXH),
new SqlParameter("@SBZZC", asm.SBZZC),
new SqlParameter("@CGJXH", asm.CGJXH),
new SqlParameter("@CGJBH", asm.CGJBH), //21
new SqlParameter("@CGJZZC", asm.CGJZZC),
new SqlParameter("@FXYXH", asm.FXYXH),
new SqlParameter("@FXYBH", asm.FXYBH),
new SqlParameter("@FXYZZC", asm.FXYZZC)
};
try
{
if (Have_ASM(asm.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>ASM检测数据Model</returns>
public ASM Get_ASM(string CLID)
{
DateTime a;
string sql = "select * from asm where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@CLID", CLID)
};
try
{
ASM asm = new ASM();
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
asm.CLID = dt.Rows[0]["CLID"].ToString();//1
asm.CLPH = dt.Rows[0]["CLPH"].ToString();
asm.CO25CLZ = dt.Rows[0]["CO25CLZ"].ToString();
asm.CO25XZ = dt.Rows[0]["CO25XZ"].ToString();
asm.CO25PD = dt.Rows[0]["CO25PD"].ToString();
asm.HC25CLZ = dt.Rows[0]["HC25CLZ"].ToString();//6
asm.HC25XZ = dt.Rows[0]["HC25XZ"].ToString();
asm.HC25PD = dt.Rows[0]["HC25PD"].ToString();
asm.NOX25CLZ = dt.Rows[0]["NOX25CLZ"].ToString();
asm.NOX25XZ = dt.Rows[0]["NOX25XZ"].ToString();
asm.NOX25PD = dt.Rows[0]["NOX25PD"].ToString();//11
asm.CO40CLZ = dt.Rows[0]["CO40CLZ"].ToString();
asm.CO40XZ = dt.Rows[0]["CO40XZ"].ToString();
asm.CO40PD = dt.Rows[0]["CO40PD"].ToString();
asm.HC40CLZ = dt.Rows[0]["HC40CLZ"].ToString();//6
asm.HC40XZ = dt.Rows[0]["HC40XZ"].ToString();
asm.HC40PD = dt.Rows[0]["HC40PD"].ToString();
asm.NOX40CLZ = dt.Rows[0]["NOX40CLZ"].ToString();
asm.NOX40XZ = dt.Rows[0]["NOX40XZ"].ToString();
asm.NOX40PD = dt.Rows[0]["NOX40PD"].ToString();//11
asm.ZHPD = dt.Rows[0]["ZHPD"].ToString();
DateTime.TryParse(dt.Rows[0]["JCRQ"].ToString(), out a);
if (a != null)
{
asm.JCRQ = a;
}
else
{
asm.JCRQ = DateTime.Today;
}
asm.WD = dt.Rows[0]["WD"].ToString();
asm.SD = dt.Rows[0]["SD"].ToString();
asm.DQY = dt.Rows[0]["DQY"].ToString();//16
asm.SBMC = dt.Rows[0]["SBMC"].ToString();
asm.SBXH = dt.Rows[0]["SBXH"].ToString();
asm.SBZZC = dt.Rows[0]["SBZZC"].ToString();
asm.CGJXH = dt.Rows[0]["CGJXH"].ToString();
asm.CGJBH = dt.Rows[0]["CGJBH"].ToString();//21
asm.CGJZZC = dt.Rows[0]["CGJZZC"].ToString();
asm.FXYXH = dt.Rows[0]["FXYXH"].ToString();
asm.FXYBH = dt.Rows[0]["FXYBH"].ToString();
asm.FXYZZC = dt.Rows[0]["FXYZZC"].ToString();
asm.CO25025 = dt.Rows[0]["CO25025"].ToString();
asm.O25025 = dt.Rows[0]["O25025"].ToString();
asm.CO22540 = dt.Rows[0]["CO22540"].ToString();
asm.O22540 = dt.Rows[0]["O22540"].ToString();
if (dt.Columns.Contains("LAMBDA5025"))
{
asm.LAMBDA5025 = dt.Rows[0]["LAMBDA5025"].ToString();
asm.LAMBDA2540 = dt.Rows[0]["LAMBDA2540"].ToString();
}
}
else
{
asm.CLID = "-2";
}
return(asm);
}
catch (Exception)
{
throw;
}
}
public bool updateBdsx(BDSX model)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update [设备标定时限] set ");
strSql.Append("HXSX=@HXSX,");
strSql.Append("JSGLSX=@JSGLSX,");
strSql.Append("GLSX=@GLSX,");
strSql.Append("LLJSX=@LLJSX,");
strSql.Append("YDJSX=@YDJSX,");
strSql.Append("FXYLOWSX=@FXYLOWSX,");
strSql.Append("FXYHIGHSX=@FXYHIGHSX,");
strSql.Append("FXYMIDSX=@FXYMIDSX,");
strSql.Append("FXYLOWMIDSX=@FXYLOWMIDSX,");
strSql.Append("FXYHIGHMIDSX=@FXYHIGHMIDSX,");
strSql.Append("ZJSX=@ZJSX,");
strSql.Append("YRSX=@YRSX,");
strSql.Append("YLJSX=@YLJSX,");
strSql.Append("SDSX=@SDSX,");
strSql.Append("HJCSSX=@HJCSSX,");
strSql.Append("ZSJSX=@ZSJSX,");
strSql.Append("JLSX=@JLSX");
SqlParameter[] parameters =
{
//new SqlParameter("@STAFFID", SqlDbType.VarChar,50),
new SqlParameter("@HXSX", SqlDbType.VarChar, 50),
new SqlParameter("@JSGLSX", SqlDbType.VarChar, 50),
new SqlParameter("@GLSX", SqlDbType.VarChar, 50),
new SqlParameter("@LLJSX", SqlDbType.VarChar, 50),
new SqlParameter("@YDJSX", SqlDbType.VarChar, 50),
new SqlParameter("@FXYLOWSX", SqlDbType.VarChar, 50),
new SqlParameter("@FXYHIGHSX", SqlDbType.VarChar, 50),
new SqlParameter("@FXYMIDSX", SqlDbType.VarChar, 50),
new SqlParameter("@FXYLOWMIDSX", SqlDbType.VarChar, 50),
new SqlParameter("@FXYHIGHMIDSX", SqlDbType.VarChar, 50),
new SqlParameter("@ZJSX", SqlDbType.VarChar, 50),
new SqlParameter("@YRSX", SqlDbType.VarChar, 50),
new SqlParameter("@YLJSX", SqlDbType.VarChar, 50),
new SqlParameter("@SDSX", SqlDbType.VarChar, 50),
new SqlParameter("@HJCSSX", SqlDbType.VarChar, 50),
new SqlParameter("@ZSJSX", SqlDbType.VarChar, 50),
new SqlParameter("@JLSX", SqlDbType.VarChar, 50)
};
//parameters[i++].Value = model.STAFFID;
parameters[i++].Value = model.HXSX;
parameters[i++].Value = model.JSGLSX;
parameters[i++].Value = model.GLSX;
parameters[i++].Value = model.LLJSX;
parameters[i++].Value = model.YDJSX;
parameters[i++].Value = model.FXYLOWSX;
parameters[i++].Value = model.FXYHIGHSX;
parameters[i++].Value = model.FXYMIDSX;
parameters[i++].Value = model.FXYLOWMIDSX;
parameters[i++].Value = model.FXYHIGHMIDSX;
parameters[i++].Value = model.ZJSX;
parameters[i++].Value = model.YRSX;
parameters[i++].Value = model.YLJSX;
parameters[i++].Value = model.SDSX;
parameters[i++].Value = model.HJCSSX;
parameters[i++].Value = model.ZSJSX;
parameters[i++].Value = model.JLSX;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
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;
}
}
public bool updateMoneyRecordInf(MONEY model)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update [收费记录] set ");
strSql.Append("CLHP=@CLHP,");
strSql.Append("DLSJ=@DLSJ,");
strSql.Append("EXHAUST=@EXHAUST,");
strSql.Append("SAFE=@SAFE,");
strSql.Append("EXHAUSTSTANDARDFY=@EXHAUSTSTANDARDFY,");
strSql.Append("SAFESTANDARDFY=@SAFESTANDARDFY,");
strSql.Append("EXHAUSTFY=@EXHAUSTFY,");
strSql.Append("SAFEFY=@SAFEFY,");
strSql.Append("EXHAUSTBZ=@EXHAUSTBZ,");
strSql.Append("SAFEBZ=@SAFEBZ,");
strSql.Append("FY=@FY,");
strSql.Append("SKR=@SKR,");
strSql.Append("TF=@TF,");
strSql.Append("TFFY=@TFFY,");
strSql.Append("CZ=@CZ,");
strSql.Append("SFSJ=@SFSJ");
strSql.Append(" where CLID='" + model.CLID + "'");
SqlParameter[] parameters =
{
new SqlParameter("@CLHP", SqlDbType.VarChar, 50),
new SqlParameter("@DLSJ", SqlDbType.DateTime),
new SqlParameter("@EXHAUST", SqlDbType.VarChar, 50),
new SqlParameter("@SAFE", SqlDbType.VarChar, 50),
new SqlParameter("@EXHAUSTSTANDARDFY", SqlDbType.VarChar, 50),
new SqlParameter("@SAFESTANDARDFY", SqlDbType.VarChar, 50),
new SqlParameter("@EXHAUSTFY", SqlDbType.VarChar, 50),
new SqlParameter("@SAFEFY", SqlDbType.VarChar, 50),
new SqlParameter("@EXHAUSTBZ", SqlDbType.VarChar, 50),
new SqlParameter("@SAFEBZ", SqlDbType.VarChar, 50),
new SqlParameter("@FY", SqlDbType.VarChar, 50),
new SqlParameter("@SKR", SqlDbType.VarChar, 50),
new SqlParameter("@TF", SqlDbType.VarChar, 50),
new SqlParameter("@TFFY", SqlDbType.VarChar, 50),
new SqlParameter("@CZ", SqlDbType.VarChar, 50),
new SqlParameter("@SFSJ", SqlDbType.DateTime)
};
parameters[i++].Value = model.CLHP;
parameters[i++].Value = model.DLSJ;
parameters[i++].Value = model.EXHAUST;
parameters[i++].Value = model.SAFE;
parameters[i++].Value = model.EXHAUSTSTANDARDFY;
parameters[i++].Value = model.SAFESTANDARDFY;
parameters[i++].Value = model.EXHAUSTFY;
parameters[i++].Value = model.SAFEFY;
parameters[i++].Value = model.EXHAUSTBZ;
parameters[i++].Value = model.SAFEBZ;
parameters[i++].Value = model.FY;
parameters[i++].Value = model.SKR;
parameters[i++].Value = model.TF;
parameters[i++].Value = model.TFFY;
parameters[i++].Value = model.CZ;
parameters[i++].Value = model.SFSJ;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用检测编号和次数查询一条检测数据
/// </summary>
/// <param name="jcbh">检测编号</param>
/// <param name="jccs">检测次数</param>
/// <returns>Zyjs_Btg检测数据Model</returns>
public Zyjs_Btg Get_Zyjs(string CLID)
{
DateTime a;
string sql = "select * from zyjs_btg where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@CLID", CLID)
};
try
{
Zyjs_Btg zyjs = new Zyjs_Btg();
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
zyjs.CLID = dt.Rows[0]["CLID"].ToString();//1
zyjs.JCBGBH = dt.Rows[0]["JCBGBH"].ToString();
zyjs.CLPH = dt.Rows[0]["CLPH"].ToString();
zyjs.FIRSTDATA = dt.Rows[0]["FIRSTDATA"].ToString();
zyjs.SECONDDATA = dt.Rows[0]["SECONDDATA"].ToString();
zyjs.THIRDDATA = dt.Rows[0]["THIRDDATA"].ToString();
zyjs.FOURTHDATA = dt.Rows[0]["FOURTHDATA"].ToString();
zyjs.AVERAGEDATA = dt.Rows[0]["AVERAGEDATA"].ToString(); //6
zyjs.YDXZ = dt.Rows[0]["YDXZ"].ToString(); //6
zyjs.YDPD = dt.Rows[0]["YDPD"].ToString();
zyjs.DSZS = dt.Rows[0]["DSZS"].ToString();
zyjs.ZHPD = dt.Rows[0]["ZHPD"].ToString();
DateTime.TryParse(dt.Rows[0]["JCRQ"].ToString(), out a);
if (a != null)
{
zyjs.JCRQ = a;
}
else
{
zyjs.JCRQ = DateTime.Today;
}
zyjs.WD = dt.Rows[0]["WD"].ToString();
zyjs.SD = dt.Rows[0]["SD"].ToString();
zyjs.DQY = dt.Rows[0]["DQY"].ToString();//16
zyjs.SBMC = dt.Rows[0]["SBMC"].ToString();
zyjs.SBXH = dt.Rows[0]["SBXH"].ToString();
zyjs.SBZZC = dt.Rows[0]["SBZZC"].ToString();
zyjs.ZSJXH = dt.Rows[0]["ZSJXH"].ToString();
zyjs.ZSJBH = dt.Rows[0]["ZSJBH"].ToString();//21
zyjs.ZSJZZC = dt.Rows[0]["ZSJZZC"].ToString();
zyjs.YDJXH = dt.Rows[0]["YDJXH"].ToString();
zyjs.YDJBH = dt.Rows[0]["YDJBH"].ToString();
zyjs.YDJZZC = dt.Rows[0]["YDJZZC"].ToString();
zyjs.SHY = dt.Rows[0]["SHY"].ToString();
zyjs.SYNCHDATE = dt.Rows[0]["SYNCHDATE"].ToString();
zyjs.YW = dt.Rows[0]["YW"].ToString();
zyjs.JCKSSJ = dt.Rows[0]["JCKSSJ"].ToString();
zyjs.JCJSSJ = dt.Rows[0]["JCJSSJ"].ToString();
zyjs.JCFF = dt.Rows[0]["JCFF"].ToString();
}
else
{
zyjs.CLID = "-2";
}
return(zyjs);
}
catch (Exception)
{
throw;
}
}
public bool saveTemperatureDataByIni(temperatureData model, string stationid, string lineid, DateTime bdrq)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [气象站校准] (");
strSql.Append("STATIONID,"); //=@PZLX,");1
strSql.Append("LINEID,"); //=@JCCLPH,");2
strSql.Append("WDBZ,"); //=@CLXHBH,");3
strSql.Append("WDSCZ,"); //=@CLXHBH,");3
strSql.Append("SDBZ,"); //=@JCCS,");4
strSql.Append("SDSCZ,"); //=@CCRQ,");5
strSql.Append("DQYBZ,"); //=@CLXHBH,");3
strSql.Append("DQYSCZ,"); //=@CLXHBH,");3
strSql.Append("WDWC,"); //=@JCCS,");4
strSql.Append("SDWC,"); //=@CCRQ,");5
strSql.Append("DQYWC,"); //=@CCRQ,");5
strSql.Append("BDJG,"); //=@DJRQ,"); 6
strSql.Append("BZSM,"); //=@FDJH,");7
strSql.Append("CZY,"); //=@LCBDS,");12
strSql.Append("BDRQ) "); //=@SYQK,");14
strSql.Append("values (@STATIONID,@LINEID,@WDBZ,@WDSCZ,@SDBZ,@SDSCZ,@DQYBZ,@DQYSCZ,@WDWC,@SDWC,@DQYWC,@BDJG,@BZSM,@CZY,@BDRQ)");
SqlParameter[] parameters =
{
new SqlParameter("@STATIONID", SqlDbType.VarChar, 50),
new SqlParameter("@LINEID", SqlDbType.VarChar, 50),
new SqlParameter("@WDBZ", SqlDbType.VarChar, 50),
new SqlParameter("@WDSCZ", SqlDbType.VarChar, 50),
new SqlParameter("@SDBZ", SqlDbType.VarChar, 50),
new SqlParameter("@SDSCZ", SqlDbType.VarChar, 50),
new SqlParameter("@DQYBZ", SqlDbType.VarChar, 50),
new SqlParameter("@DQYSCZ", SqlDbType.VarChar, 50),
new SqlParameter("@WDWC", SqlDbType.VarChar, 50),
new SqlParameter("@SDWC", SqlDbType.VarChar, 50),
new SqlParameter("@DQYWC", SqlDbType.VarChar, 50),
new SqlParameter("@BDJG", SqlDbType.VarChar, 50),
new SqlParameter("@BZSM", SqlDbType.VarChar, 50),
new SqlParameter("@CZY", SqlDbType.VarChar, 50),
new SqlParameter("@BDRQ", SqlDbType.DateTime)
};
parameters[i++].Value = stationid;
parameters[i++].Value = lineid;
parameters[i++].Value = model.Wdbz.ToString("0.00");
parameters[i++].Value = model.Wdscz.ToString("0.00");
parameters[i++].Value = model.Sdbz.ToString("0.00");
parameters[i++].Value = model.Sdscz.ToString("0.00");
parameters[i++].Value = model.Dqybz.ToString("0.00");
parameters[i++].Value = model.Dqyscz.ToString("0.00");
parameters[i++].Value = model.Wdwc.ToString("0.00");
parameters[i++].Value = model.Sdwc.ToString("0.00");
parameters[i++].Value = model.Dqywc.ToString("0.00");
parameters[i++].Value = model.Bdjg;
parameters[i++].Value = model.Bzsm;
parameters[i++].Value = "";
parameters[i++].Value = bdrq;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用Zyjs_Btg对象插入或更新条检测数据
/// </summary>
/// <param name="zyjs">Zyjs_Btg</param>
/// <returns>int 0为失败，1为插入成功，2为更新成功</returns>
public int Save_Zyjs_Btg(Zyjs_Btg zyjs)
{
string sqli = "insert into zyjs_btg(JYLSH,JYCS,SBRZBM,CLID,CLPH,FIRSTDATA,SECONDDATA,THIRDDATA,FOURTHDATA,AVERAGEDATA,YDXZ,YDPD,DSZS,ZHPD,JCRQ,WD,SD,DQY,SBMC,SBXH,SBZZC,YDJXH,YDJBH,YDJZZC,ZSJXH,ZSJBH,ZSJZZC,JCBGBH,SHY,SYNCHDATE,YW,JCKSSJ,JCJSSJ,JCFF) values(@JYLSH,@JYCS,@SBRZBM,@CLID,@CLPH,@FIRSTDATA,@SECONDDATA,@THIRDDATA,@FOURTHDATA,@AVERAGEDATA,@YDXZ,@YDPD,@DSZS,@ZHPD,@JCRQ,@WD,@SD,@DQY,@SBMC,@SBXH,@SBZZC,@YDJXH,@YDJBH,@YDJZZC,@ZSJXH,@ZSJBH,@ZSJZZC,@JCBGBH,@SHY,@SYNCHDATE,@YW,@JCKSSJ,@JCJSSJ,@JCFF)";
string sqlu = "update zyjs_btg set JYLSH=@JYLSH,JYCS=@JYCS,SBRZBM=@SBRZBM,CLPH=@CLPH,FIRSTDATA=@FIRSTDATA,SECONDDATA=@SECONDDATA,THIRDDATA=@THIRDDATA,FOURTHDATA=@FOURTHDATA,AVERAGEDATA=@AVERAGEDATA,YDXZ=@YDXZ,YDPD=@YDPD,DSZS=@DSZS,ZHPD=@ZHPD,JCRQ=@JCRQ,WD=@WD,SD=@SD,DQY=@DQY,SBMC=@SBMC,SBXH=@SBXH,SBZZC=@SBZZC,YDJXH=@YDJXH,YDJBH=@YDJBH,YDJZZC=@YDJZZC,ZSJXH=@ZSJXH,ZSJBH=@ZSJBH,ZSJZZC=@ZSJZZC,JCBGBH=@JCBGBH,SHY=@SHY,SYNCHDATE=@SYNCHDATE,YW=@YW,JCKSSJ=@JCKSSJ,JCJSSJ=@JCJSSJ,JCFF=@JCFF where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@JYLSH", zyjs.JYLSH),
new SqlParameter("@JYCS", zyjs.JYCS),
new SqlParameter("@SBRZBM", zyjs.SBRZBM),
new SqlParameter("@CLID", zyjs.CLID), //1
new SqlParameter("@CLPH", zyjs.CLPH),
new SqlParameter("@FIRSTDATA", zyjs.FIRSTDATA),
new SqlParameter("@SECONDDATA", zyjs.SECONDDATA),
new SqlParameter("@THIRDDATA", zyjs.THIRDDATA),
new SqlParameter("@FOURTHDATA", zyjs.FOURTHDATA),
new SqlParameter("@AVERAGEDATA", zyjs.AVERAGEDATA), //6zyjs
new SqlParameter("@YDXZ", zyjs.YDXZ),
new SqlParameter("@YDPD", zyjs.YDPD),
new SqlParameter("@DSZS", zyjs.DSZS),
new SqlParameter("@ZHPD", zyjs.ZHPD),
new SqlParameter("@JCRQ", zyjs.JCRQ),
new SqlParameter("@WD", zyjs.WD),
new SqlParameter("@SD", zyjs.SD),
new SqlParameter("@DQY", zyjs.DQY), //16
new SqlParameter("@SBMC", zyjs.SBMC),
new SqlParameter("@SBXH", zyjs.SBXH),
new SqlParameter("@SBZZC", zyjs.SBZZC),
new SqlParameter("@ZSJXH", zyjs.ZSJXH),
new SqlParameter("@ZSJBH", zyjs.ZSJBH), //21
new SqlParameter("@ZSJZZC", zyjs.ZSJZZC),
new SqlParameter("@YDJXH", zyjs.YDJXH),
new SqlParameter("@YDJBH", zyjs.YDJBH),
new SqlParameter("@YDJZZC", zyjs.YDJZZC), //47
new SqlParameter("@JCBGBH", zyjs.JCBGBH),
new SqlParameter("@SHY", zyjs.SHY), //21
new SqlParameter("@SYNCHDATE", zyjs.SYNCHDATE),
new SqlParameter("@YW", zyjs.YW),
new SqlParameter("@JCKSSJ", zyjs.JCKSSJ),
new SqlParameter("@JCJSSJ", zyjs.JCJSSJ),
new SqlParameter("@JCFF", zyjs.JCFF)
};
try
{
if (Have_Zyjs_Btg(zyjs.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;
}
}
public bool saveAnswerTimeByIni(xysjData model, string stationid, string lineid, DateTime bdrq)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [响应时间测试] (");
strSql.Append("STATIONID,"); //=@PZLX,");1
strSql.Append("LINEID,"); //=@JCCLPH,");2
strSql.Append("SPEED,"); //=@CLXHBH,");3
strSql.Append("STARTPOWER,"); //=@CLXHBH,");3
strSql.Append("STARTFORCE,"); //=@JCCS,");4
strSql.Append("ENDPOWER,"); //=@CCRQ,");5
strSql.Append("ENDFORCE,"); //=@CCRQ,");5
strSql.Append("XYTIME,"); //=@CCRQ,");5
strSql.Append("WDTIME,"); //=@CCRQ,");5
strSql.Append("BDJG,"); //=@DJRQ,"); 6
strSql.Append("CZY,"); //=@LCBDS,");12
strSql.Append("BDRQ) "); //=@SYQK,");14
strSql.Append("values (@STATIONID,@LINEID,@SPEED,@STARTPOWER,@STARTFORCE,@ENDPOWER,@ENDFORCE,@XYTIME,@WDTIME,@BDJG,@CZY,@BDRQ)");
SqlParameter[] parameters =
{
new SqlParameter("@STATIONID", SqlDbType.VarChar, 50),
new SqlParameter("@LINEID", SqlDbType.VarChar, 50),
new SqlParameter("@SPEED", SqlDbType.VarChar, 50),
new SqlParameter("@STARTPOWER", SqlDbType.VarChar, 50),
new SqlParameter("@STARTFORCE", SqlDbType.VarChar, 50),
new SqlParameter("@ENDPOWER", SqlDbType.VarChar, 50),
new SqlParameter("@ENDFORCE", SqlDbType.VarChar, 50),
new SqlParameter("@XYTIME", SqlDbType.VarChar, 50),
new SqlParameter("@WDTIME", SqlDbType.VarChar, 50),
new SqlParameter("@BDJG", SqlDbType.VarChar, 50),
new SqlParameter("@CZY", SqlDbType.VarChar, 50),
new SqlParameter("@BDRQ", SqlDbType.DateTime)
};
parameters[i++].Value = stationid;
parameters[i++].Value = lineid;
parameters[i++].Value = model.Sd;
parameters[i++].Value = model.StartPower;
parameters[i++].Value = model.StartForce;
parameters[i++].Value = model.EndPower;
parameters[i++].Value = model.EndForce;
parameters[i++].Value = model.XyTime;
parameters[i++].Value = model.WdTime;
parameters[i++].Value = model.Bdjg;
parameters[i++].Value = "";
parameters[i++].Value = bdrq;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用检测编号和次数查询一条检测数据
/// </summary>
/// <param name="jcbh">检测编号</param>
/// <param name="jccs">检测次数</param>
/// <returns>Zyjs_Btg检测数据Model</returns>
public selfcheckdata Get_SelfCheckData(string ID)
{
DateTime a;
string sql = "select * from [自检记录] where ID=@ID";
SqlParameter[] spr =
{
new SqlParameter("@ID", ID)
};
try
{
selfcheckdata zyjs = new selfcheckdata();
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
zyjs.ID = dt.Rows[0]["ID"].ToString();
zyjs.WORKTIME = DateTime.Parse(dt.Rows[0]["WORKTIME"].ToString());
zyjs.WORKER = dt.Rows[0]["WORKER"].ToString();
zyjs.ISQXZCHECK = dt.Rows[0]["ISQXZCHECK"].ToString();
zyjs.ISFQYCHECK = dt.Rows[0]["ISFQYCHECK"].ToString();
zyjs.ISBTGCHECK = dt.Rows[0]["ISBTGCHECK"].ToString();
zyjs.ISCGJCHECK = dt.Rows[0]["ISCGJCHECK"].ToString();
zyjs.ISLLJCHECK = dt.Rows[0]["ISLLJCHECK"].ToString();
zyjs.ISZSJCHECK = dt.Rows[0]["ISZSJCHECK"].ToString();
zyjs.TEMPOK = dt.Rows[0]["TEMPOK"].ToString();
zyjs.HUMIOK = dt.Rows[0]["HUMIOK"].ToString();
zyjs.AIRPOK = dt.Rows[0]["AIRPOK"].ToString();
zyjs.TEMP = dt.Rows[0]["TEMP"].ToString();
zyjs.HUMI = dt.Rows[0]["HUMI"].ToString();
zyjs.AIRP = dt.Rows[0]["AIRP"].ToString();
zyjs.FQYTX = dt.Rows[0]["FQYTX"].ToString();
zyjs.FQYYR = dt.Rows[0]["FQYYR"].ToString();
zyjs.FQYTL = dt.Rows[0]["FQYTL"].ToString();
zyjs.FQYJL = dt.Rows[0]["FQYJL"].ToString();
zyjs.FQYLC = dt.Rows[0]["FQYLC"].ToString();
zyjs.FQYO2 = dt.Rows[0]["FQYO2"].ToString();
zyjs.BTGTX = dt.Rows[0]["BTGTX"].ToString();
zyjs.BTGYR = dt.Rows[0]["BTGYR"].ToString();
zyjs.BTGTL = dt.Rows[0]["BTGTL"].ToString();
zyjs.BTGLC = dt.Rows[0]["BTGLC"].ToString();
zyjs.BTGJZ = dt.Rows[0]["BTGJZ"].ToString();
zyjs.CGJTX = dt.Rows[0]["CGJTX"].ToString();
zyjs.CGJYR = dt.Rows[0]["CGJYR"].ToString();
zyjs.CGJQL = dt.Rows[0]["CGJQL"].ToString();
zyjs.CGJJSGL = dt.Rows[0]["CGJJSGL"].ToString();
zyjs.CGJJZHX = dt.Rows[0]["CGJJZHX"].ToString();
zyjs.CGJEDGL = dt.Rows[0]["CGJEDGL"].ToString();
zyjs.CGJSJGL = dt.Rows[0]["CGJSJGL"].ToString();
zyjs.CGJGLWC = dt.Rows[0]["CGJGLWC"].ToString();
zyjs.CGJVITRUALTIME = dt.Rows[0]["CGJVITRUALTIME"].ToString();
zyjs.CGJREALTIME = dt.Rows[0]["CGJREALTIME"].ToString();
zyjs.CGJTIMEWC = dt.Rows[0]["CGJTIMEWC"].ToString();
zyjs.LLJTX = dt.Rows[0]["LLJTX"].ToString();
zyjs.LLJLL = dt.Rows[0]["LLJLL"].ToString();
zyjs.ZSJTX = dt.Rows[0]["ZSJTX"].ToString();
zyjs.ZSJLC = dt.Rows[0]["ZSJLC"].ToString();
zyjs.HSSlideActualTime = dt.Rows[0]["HSSlideActualTime"].ToString();
zyjs.HSSlideTheoreticalTime = dt.Rows[0]["HSSlideTheoreticalTime"].ToString();
zyjs.HSSlideLoadPower = dt.Rows[0]["HSSlideLoadPower"].ToString();
zyjs.HSSlideBeginTime = dt.Rows[0]["HSSlideBeginTime"].ToString();
zyjs.HSSlideEndTime = dt.Rows[0]["HSSlideEndTime"].ToString();
zyjs.LSSlideActualTime = dt.Rows[0]["LSSlideActualTime"].ToString();
zyjs.LSSlideTheoreticalTime = dt.Rows[0]["LSSlideTheoreticalTime"].ToString();
zyjs.LSSlideLoadPower = dt.Rows[0]["LSSlideLoadPower"].ToString();
zyjs.LSSlideBeginTime = dt.Rows[0]["LSSlideBeginTime"].ToString();
zyjs.LSSlideEndTime = dt.Rows[0]["LSSlideEndTime"].ToString();
zyjs.WattlessMaxSpeed1 = dt.Rows[0]["WattlessMaxSpeed1"].ToString();
zyjs.WattlessMinSpeed1 = dt.Rows[0]["WattlessMinSpeed1"].ToString();
zyjs.WattlessNorminalSpeed1 = dt.Rows[0]["WattlessNorminalSpeed1"].ToString();
zyjs.WattlessBeginTime1 = dt.Rows[0]["WattlessBeginTime1"].ToString();
zyjs.WattlessEndTime1 = dt.Rows[0]["WattlessEndTime1"].ToString();
zyjs.WattlessOutput1 = dt.Rows[0]["WattlessOutput1"].ToString();
zyjs.WattlessMaxSpeed2 = dt.Rows[0]["WattlessMaxSpeed2"].ToString();
zyjs.WattlessMinSpeed2 = dt.Rows[0]["WattlessMinSpeed2"].ToString();
zyjs.WattlessNorminalSpeed2 = dt.Rows[0]["WattlessNorminalSpeed2"].ToString();
zyjs.WattlessBeginTime2 = dt.Rows[0]["WattlessBeginTime2"].ToString();
zyjs.WattlessEndTime2 = dt.Rows[0]["WattlessEndTime2"].ToString();
zyjs.WattlessOutput2 = dt.Rows[0]["WattlessOutput2"].ToString();
zyjs.WattlessMaxSpeed3 = dt.Rows[0]["WattlessMaxSpeed3"].ToString();
zyjs.WattlessMinSpeed3 = dt.Rows[0]["WattlessMinSpeed3"].ToString();
zyjs.WattlessNorminalSpeed3 = dt.Rows[0]["WattlessNorminalSpeed3"].ToString();
zyjs.WattlessBeginTime3 = dt.Rows[0]["WattlessBeginTime3"].ToString();
zyjs.WattlessEndTime3 = dt.Rows[0]["WattlessEndTime3"].ToString();
zyjs.WattlessOutput3 = dt.Rows[0]["WattlessOutput3"].ToString();
zyjs.WattlessMaxSpeed4 = dt.Rows[0]["WattlessMaxSpeed4"].ToString();
zyjs.WattlessMinSpeed4 = dt.Rows[0]["WattlessMinSpeed4"].ToString();
zyjs.WattlessNorminalSpeed4 = dt.Rows[0]["WattlessNorminalSpeed4"].ToString();
zyjs.WattlessBeginTime4 = dt.Rows[0]["WattlessBeginTime4"].ToString();
zyjs.WattlessEndTime4 = dt.Rows[0]["WattlessEndTime4"].ToString();
zyjs.WattlessOutput4 = dt.Rows[0]["WattlessOutput4"].ToString();
zyjs.O2MRBeginTime = dt.Rows[0]["O2MRBeginTime"].ToString();
zyjs.O2MREndTime = dt.Rows[0]["O2MREndTime"].ToString();
zyjs.WQBeginTime = dt.Rows[0]["WQBeginTime"].ToString();
zyjs.WQEndTime = dt.Rows[0]["WQEndTime"].ToString();
zyjs.SlideJudge = dt.Rows[0]["SlideJudge"].ToString();
zyjs.WattlessJudge = dt.Rows[0]["WattlessJudge"].ToString();
zyjs.O2MRJudge = dt.Rows[0]["O2MRJudge"].ToString();
zyjs.WQJudge = dt.Rows[0]["WQJudge"].ToString();
zyjs.AllJudge = dt.Rows[0]["AllJudge"].ToString();
}
else
{
zyjs.ID = "-2";
}
return(zyjs);
}
catch (Exception)
{
throw;
}
}
public bool saveGlideData(GLIDE model)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [加载滑行试验] (");
strSql.Append("STATIONID,"); //=@PZLX,");1
strSql.Append("LINEID,"); //=@JCCLPH,");2
strSql.Append("HXQJ,"); //=@CLXHBH,");3
strSql.Append("QJMYSD,"); //=@CLXHBH,");3
strSql.Append("PLHP,"); //=@JCCS,");4
strSql.Append("CCDT,"); //=@CCRQ,");5
strSql.Append("ACDT,"); //=@DJRQ,"); 6
strSql.Append("WC,"); //=@FDJH,");7
strSql.Append("JZSDGL,"); //=@CJH,");8
strSql.Append("BZSM,"); //=@LCBDS,");12
strSql.Append("BDJG,"); //=@HBBZ,");13
strSql.Append("BDRQ) "); //=@SYQK,");14
strSql.Append("values (@STATIONID,@LINEID,@HXQJ,@QJMYSD,@PLHP,@CCDT,@ACDT,@WC,@JZSDGL,@BZSM,@BDJG,@BDRQ)");
SqlParameter[] parameters =
{
new SqlParameter("@STATIONID", SqlDbType.VarChar, 50),
new SqlParameter("@LINEID", SqlDbType.VarChar, 50),
new SqlParameter("@HXQJ", SqlDbType.VarChar, 50),
new SqlParameter("@QJMYSD", SqlDbType.VarChar, 100),
new SqlParameter("@PLHP", SqlDbType.VarChar, 50),
new SqlParameter("@CCDT", SqlDbType.VarChar, 50),
new SqlParameter("@ACDT", SqlDbType.VarChar, 50),
new SqlParameter("@WC", SqlDbType.VarChar, 50),
new SqlParameter("@JZSDGL", SqlDbType.VarChar, 50),
new SqlParameter("@BZSM", SqlDbType.VarChar, 50),
new SqlParameter("@BDJG", SqlDbType.VarChar, 50),
new SqlParameter("@BDRQ", SqlDbType.DateTime)
};
parameters[i++].Value = model.STATIONID;
parameters[i++].Value = model.LINEID;
parameters[i++].Value = model.HXQJ;
parameters[i++].Value = model.QJMYSD;
parameters[i++].Value = model.PLHP;
parameters[i++].Value = model.CCDT;
parameters[i++].Value = model.ACDT;
parameters[i++].Value = model.WC;
parameters[i++].Value = model.JZSDGL;
parameters[i++].Value = model.BZSM;
parameters[i++].Value = model.BDJG;
parameters[i++].Value = model.BDRQ;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用Zyjs_Btg对象插入或更新条检测数据
/// </summary>
/// <param name="zyjs">Zyjs_Btg</param>
/// <returns>int 0为失败，1为插入成功，2为更新成功</returns>
public int Save_SelfCheckData(selfcheckdata zyjs)
{
string sqli = "insert into [自检记录](ID,WORKTIME,WORKER,ISQXZCHECK,ISFQYCHECK,ISBTGCHECK,ISCGJCHECK,ISLLJCHECK,ISZSJCHECK,TEMPOK,HUMIOK,AIRPOK,TEMP,HUMI,AIRP,FQYTX,FQYYR,FQYTL,FQYJL,FQYLC,FQYO2,BTGTX,BTGYR,BTGTL,BTGLC,BTGJZ,CGJTX,CGJYR,CGJQL,CGJJSGL,CGJJZHX,CGJEDGL,CGJSJGL,CGJGLWC,CGJVITRUALTIME,CGJREALTIME,CGJTIMEWC,LLJTX,LLJLL,ZSJTX,ZSJLC," +
"HSSlideBeginTime, HSSlideEndTime, HSSlideTheoreticalTime, HSSlideActualTime, HSSlideLoadPower, LSSlideBeginTime, LSSlideEndTime, LSSlideTheoreticalTime, LSSlideActualTime, LSSlideLoadPower," +
"WattlessMaxSpeed1,WattlessMinSpeed1,WattlessNorminalSpeed1,WattlessBeginTime1,WattlessEndTime1,WattlessOutput1," +
"WattlessMaxSpeed2,WattlessMinSpeed2,WattlessNorminalSpeed2,WattlessBeginTime2,WattlessEndTime2,WattlessOutput2," +
"WattlessMaxSpeed3,WattlessMinSpeed3,WattlessNorminalSpeed3,WattlessBeginTime3,WattlessEndTime3,WattlessOutput3," +
"WattlessMaxSpeed4,WattlessMinSpeed4,WattlessNorminalSpeed4,WattlessBeginTime4,WattlessEndTime4,WattlessOutput4," +
"O2MRBeginTime,O2MREndTime,WQBeginTime,WQEndTime,SlideJudge,WattlessJudge,O2MRJudge,WQJudge,AllJudge)" +
" values(@ID,@WORKTIME,@WORKER,@ISQXZCHECK,@ISFQYCHECK,@ISBTGCHECK,@ISCGJCHECK,@ISLLJCHECK,@ISZSJCHECK,@TEMPOK,@HUMIOK,@AIRPOK,@TEMP,@HUMI,@AIRP,@FQYTX,@FQYYR,@FQYTL,@FQYJL,@FQYLC,@FQYO2,@BTGTX,@BTGYR,@BTGTL,@BTGLC,@BTGJZ,@CGJTX,@CGJYR,@CGJQL,@CGJJSGL,@CGJJZHX,@CGJEDGL,@CGJSJGL,@CGJGLWC,@CGJVITRUALTIME,@CGJREALTIME,@CGJTIMEWC,@LLJTX,@LLJLL,@ZSJTX,@ZSJLC," +
"@HSSlideBeginTime, @HSSlideEndTime, @HSSlideTheoreticalTime, @HSSlideActualTime, @HSSlideLoadPower, @LSSlideBeginTime, @LSSlideEndTime, @LSSlideTheoreticalTime, @LSSlideActualTime, @LSSlideLoadPower," +
"@WattlessMaxSpeed1,@WattlessMinSpeed1,@WattlessNorminalSpeed1,@WattlessBeginTime1,@WattlessEndTime1,@WattlessOutput1," +
"@WattlessMaxSpeed2,@WattlessMinSpeed2,@WattlessNorminalSpeed2,@WattlessBeginTime2,@WattlessEndTime2,@WattlessOutput2," +
"@WattlessMaxSpeed3,@WattlessMinSpeed3,@WattlessNorminalSpeed3,@WattlessBeginTime3,@WattlessEndTime3,@WattlessOutput3," +
"@WattlessMaxSpeed4,@WattlessMinSpeed4,@WattlessNorminalSpeed4,@WattlessBeginTime4,@WattlessEndTime4,@WattlessOutput4," +
"@O2MRBeginTime,@O2MREndTime,@WQBeginTime,@WQEndTime,@SlideJudge,@WattlessJudge,@O2MRJudge,@WQJudge,@AllJudge" +
")";
string sqlu = "update [自检记录] set WORKTIME=@WORKTIME,WORKER=@WORKER,ISQXZCHECK=@ISQXZCHECK,ISFQYCHECK=@ISFQYCHECK,ISBTGCHECK=@ISBTGCHECK,ISCGJCHECK=@ISCGJCHECK,ISLLJCHECK=@ISLLJCHECK,ISZSJCHECK=@ISZSJCHECK,TEMPOK=@TEMPOK,HUMIOK=@HUMIOK,AIRPOK=@AIRPOK,TEMP=@TEMP,HUMI=@HUMI,AIRP=@AIRP,FQYTX=@FQYTX,FQYYR=@FQYYR,FQYTL=@FQYTL,FQYJL=@FQYJL,FQYLC=@FQYLC,FQYO2=@FQYO2,BTGTX=@BTGTX,BTGYR=@BTGYR,BTGTL=@BTGTL,BTGLC=@BTGLC,BTGJZ=@BTGJZ,CGJTX=@CGJTX,CGJYR=@CGJYR,CGJQL=@CGJQL,CGJJSGL=@CGJJSGL,CGJJZHX=@CGJJZHX,CGJEDGL=@CGJEDGL,CGJSJGL=@CGJSJGL,CGJGLWC=@CGJGLWC,CGJVITRUALTIME=@CGJVITRUALTIME,CGJREALTIME=@CGJREALTIME,CGJTIMEWC=@CGJTIMEWC,LLJTX=@LLJTX,LLJLL=@LLJLL,ZSJTX=@ZSJTX,ZSJLC=@ZSJLC," +
"HSSlideBeginTime=@HSSlideBeginTime, HSSlideEndTime=@HSSlideEndTime, HSSlideTheoreticalTime=@HSSlideTheoreticalTime, HSSlideActualTime=@HSSlideActualTime, HSSlideLoadPower=@HSSlideLoadPower, LSSlideBeginTime=@LSSlideBeginTime, LSSlideEndTime=@LSSlideEndTime, LSSlideTheoreticalTime=@LSSlideTheoreticalTime, LSSlideActualTime=@LSSlideActualTime, LSSlideLoadPower=@LSSlideLoadPower," +
"WattlessMaxSpeed1=@WattlessMaxSpeed1,WattlessMinSpeed1=@WattlessMinSpeed1,WattlessNorminalSpeed1=@WattlessNorminalSpeed1,WattlessBeginTime1=@WattlessBeginTime1,WattlessEndTime1=@WattlessEndTime1,WattlessOutput1=@WattlessOutput1," +
"WattlessMaxSpeed2=@WattlessMaxSpeed2,WattlessMinSpeed2=@WattlessMinSpeed2,WattlessNorminalSpeed2=@WattlessNorminalSpeed2,WattlessBeginTime2=@WattlessBeginTime2,WattlessEndTime2=@WattlessEndTime2,WattlessOutput2=@WattlessOutput2," +
"WattlessMaxSpeed3=@WattlessMaxSpeed3,WattlessMinSpeed3=@WattlessMinSpeed3,WattlessNorminalSpeed3=@WattlessNorminalSpeed3,WattlessBeginTime3=@WattlessBeginTime3,WattlessEndTime3=@WattlessEndTime3,WattlessOutput3=@WattlessOutput3," +
"WattlessMaxSpeed4=@WattlessMaxSpeed4,WattlessMinSpeed4=@WattlessMinSpeed4,WattlessNorminalSpeed4=@WattlessNorminalSpeed4,WattlessBeginTime4=@WattlessBeginTime4,WattlessEndTime4=@WattlessEndTime4,WattlessOutput4=@WattlessOutput4," +
"O2MRBeginTime=@O2MRBeginTime,O2MREndTime=@O2MREndTime,WQBeginTime=@WQBeginTime,WQEndTime=@WQEndTime,SlideJudge=@SlideJudge,WattlessJudge=@WattlessJudge,O2MRJudge=@O2MRJudge,WQJudge=@WQJudge,AllJudge=@AllJudge " +
"where ID=@ID";
SqlParameter[] spr =
{
new SqlParameter("@ID", zyjs.ID),
new SqlParameter("@WORKTIME", zyjs.WORKTIME),
new SqlParameter("@WORKER", zyjs.WORKER),
new SqlParameter("@ISQXZCHECK", zyjs.ISQXZCHECK),
new SqlParameter("@ISFQYCHECK", zyjs.ISFQYCHECK),
new SqlParameter("@ISBTGCHECK", zyjs.ISBTGCHECK),
new SqlParameter("@ISCGJCHECK", zyjs.ISCGJCHECK),
new SqlParameter("@ISLLJCHECK", zyjs.ISLLJCHECK),
new SqlParameter("@ISZSJCHECK", zyjs.ISZSJCHECK),
new SqlParameter("@TEMPOK", zyjs.TEMPOK),
new SqlParameter("@HUMIOK", zyjs.HUMIOK),
new SqlParameter("@AIRPOK", zyjs.AIRPOK),
new SqlParameter("@TEMP", zyjs.TEMP),
new SqlParameter("@HUMI", zyjs.HUMI),
new SqlParameter("@AIRP", zyjs.AIRP),
new SqlParameter("@FQYTX", zyjs.FQYTX),
new SqlParameter("@FQYYR", zyjs.FQYYR),
new SqlParameter("@FQYTL", zyjs.FQYTL),
new SqlParameter("@FQYJL", zyjs.FQYJL),
new SqlParameter("@FQYLC", zyjs.FQYLC),
new SqlParameter("@FQYO2", zyjs.FQYO2),
new SqlParameter("@BTGTX", zyjs.BTGTX),
new SqlParameter("@BTGYR", zyjs.BTGYR),
new SqlParameter("@BTGTL", zyjs.BTGTL),
new SqlParameter("@BTGLC", zyjs.BTGLC),
new SqlParameter("@BTGJZ", zyjs.BTGJZ),
new SqlParameter("@CGJTX", zyjs.CGJTX),
new SqlParameter("@CGJYR", zyjs.CGJYR),
new SqlParameter("@CGJQL", zyjs.CGJQL),
new SqlParameter("@CGJJSGL", zyjs.CGJJSGL),
new SqlParameter("@CGJJZHX", zyjs.CGJJZHX),
new SqlParameter("@CGJEDGL", zyjs.CGJEDGL),
new SqlParameter("@CGJSJGL", zyjs.CGJSJGL),
new SqlParameter("@CGJGLWC", zyjs.CGJGLWC),
new SqlParameter("@CGJVITRUALTIME", zyjs.CGJVITRUALTIME),
new SqlParameter("@CGJREALTIME", zyjs.CGJREALTIME),
new SqlParameter("@CGJTIMEWC", zyjs.CGJTIMEWC),
new SqlParameter("@LLJTX", zyjs.LLJTX),
new SqlParameter("@LLJLL", zyjs.LLJLL),
new SqlParameter("@ZSJTX", zyjs.ZSJTX),
new SqlParameter("@ZSJLC", zyjs.ZSJLC),
new SqlParameter("@HSSlideActualTime", zyjs.HSSlideActualTime),
new SqlParameter("@HSSlideTheoreticalTime", zyjs.HSSlideTheoreticalTime),
new SqlParameter("@HSSlideLoadPower", zyjs.HSSlideLoadPower),
new SqlParameter("@HSSlideBeginTime", zyjs.HSSlideBeginTime),
new SqlParameter("@HSSlideEndTime", zyjs.HSSlideEndTime),
new SqlParameter("@LSSlideActualTime", zyjs.LSSlideActualTime),
new SqlParameter("@LSSlideTheoreticalTime", zyjs.LSSlideTheoreticalTime),
new SqlParameter("@LSSlideLoadPower", zyjs.LSSlideLoadPower),
new SqlParameter("@LSSlideBeginTime", zyjs.LSSlideBeginTime),
new SqlParameter("@LSSlideEndTime", zyjs.LSSlideEndTime),
new SqlParameter("@WattlessMaxSpeed1", zyjs.WattlessMaxSpeed1),
new SqlParameter("@WattlessMinSpeed1", zyjs.WattlessMinSpeed1),
new SqlParameter("@WattlessNorminalSpeed1", zyjs.WattlessNorminalSpeed1),
new SqlParameter("@WattlessBeginTime1", zyjs.WattlessBeginTime1),
new SqlParameter("@WattlessEndTime1", zyjs.WattlessEndTime1),
new SqlParameter("@WattlessOutput1", zyjs.WattlessOutput1),
new SqlParameter("@WattlessMaxSpeed2", zyjs.WattlessMaxSpeed2),
new SqlParameter("@WattlessMinSpeed2", zyjs.WattlessMinSpeed2),
new SqlParameter("@WattlessNorminalSpeed2", zyjs.WattlessNorminalSpeed2),
new SqlParameter("@WattlessBeginTime2", zyjs.WattlessBeginTime2),
new SqlParameter("@WattlessEndTime2", zyjs.WattlessEndTime2),
new SqlParameter("@WattlessOutput2", zyjs.WattlessOutput2),
new SqlParameter("@WattlessMaxSpeed3", zyjs.WattlessMaxSpeed3),
new SqlParameter("@WattlessMinSpeed3", zyjs.WattlessMinSpeed3),
new SqlParameter("@WattlessNorminalSpeed3", zyjs.WattlessNorminalSpeed3),
new SqlParameter("@WattlessBeginTime3", zyjs.WattlessBeginTime3),
new SqlParameter("@WattlessEndTime3", zyjs.WattlessEndTime3),
new SqlParameter("@WattlessOutput3", zyjs.WattlessOutput3),
new SqlParameter("@WattlessMaxSpeed4", zyjs.WattlessMaxSpeed4),
new SqlParameter("@WattlessMinSpeed4", zyjs.WattlessMinSpeed4),
new SqlParameter("@WattlessNorminalSpeed4", zyjs.WattlessNorminalSpeed4),
new SqlParameter("@WattlessBeginTime4", zyjs.WattlessBeginTime4),
new SqlParameter("@WattlessEndTime4", zyjs.WattlessEndTime4),
new SqlParameter("@WattlessOutput4", zyjs.WattlessOutput4),
new SqlParameter("@O2MRBeginTime", zyjs.O2MRBeginTime),
new SqlParameter("@O2MREndTime", zyjs.O2MREndTime),
new SqlParameter("@WQBeginTime", zyjs.WQBeginTime),
new SqlParameter("@WQEndTime", zyjs.WQEndTime),
new SqlParameter("@SlideJudge", zyjs.SlideJudge),
new SqlParameter("@WattlessJudge", zyjs.WattlessJudge),
new SqlParameter("@O2MRJudge", zyjs.O2MRJudge),
new SqlParameter("@WQJudge", zyjs.WQJudge),
new SqlParameter("@AllJudge", zyjs.AllJudge)
};
try
{
if (Have_SelfCheckData(zyjs.ID))
{
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 er)
{
throw;
}
}
public bool saveInertnessData(INERTNESS model)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [惯量测试] (");
strSql.Append("STATIONID,"); //=@PZLX,");1
strSql.Append("LINEID,"); //=@JCCLPH,");2
strSql.Append("T1POWER,"); //=@CLXHBH,");3
strSql.Append("T2POWER,"); //=@CLXHBH,");3
strSql.Append("STARTSPEED,"); //=@JCCS,");4
strSql.Append("ENDSPEED,"); //=@CCRQ,");5
strSql.Append("ACD1_1,"); //=@DJRQ,"); 6
strSql.Append("ACD1_2,"); //=@FDJH,");7
strSql.Append("ACD1_3,"); //=@CJH,");8
strSql.Append("ACD1,"); //=@CZ,");9
strSql.Append("ACD2_1,"); //=@DJRQ,"); 6
strSql.Append("ACD2_2,"); //=@FDJH,");7
strSql.Append("ACD2_3,"); //=@CJH,");8
strSql.Append("ACD2,"); //=@CZ,");9
strSql.Append("DIW_1,"); //=@DJRQ,"); 6
strSql.Append("DIW_2,"); //=@FDJH,");7
strSql.Append("DIW_3,"); //=@CJH,");8
strSql.Append("DIW,"); //=@CZ,");9
strSql.Append("DIW_BC,"); //=@CZDH,");10
strSql.Append("DIW_SC,"); //=@CZDZ,");11
strSql.Append("WC,"); //=@CZ,");9
strSql.Append("PD,"); //=@CZDH,");10
strSql.Append("HXSJ,"); //=@CZDZ,");11
strSql.Append("BZ,"); //=@LCBDS,");12
strSql.Append("BDJG,"); //=@HBBZ,");13
strSql.Append("BDRQ) "); //=@SYQK,");14
strSql.Append("values (@STATIONID,@LINEID,@T1POWER,@T2POWER,@STARTSPEED,@ENDSPEED,@ACD1_1,@ACD1_2,@ACD1_3,@ACD1,@ACD2_1,@ACD2_2,@ACD2_3,@ACD2,@DIW_1,@DIW_2,@DIW_3,@DIW,@DIW_BC,@DIW_SC,@WC,@PD,@HXSJ,@BZ,@BDJG,@BDRQ)");
SqlParameter[] parameters =
{
new SqlParameter("@STATIONID", SqlDbType.VarChar, 50),
new SqlParameter("@LINEID", SqlDbType.VarChar, 50),
new SqlParameter("@T1POWER", SqlDbType.VarChar, 50),
new SqlParameter("@T2POWER", SqlDbType.VarChar, 100),
new SqlParameter("@STARTSPEED", SqlDbType.VarChar, 50),
new SqlParameter("@ENDSPEED", SqlDbType.VarChar, 50),
new SqlParameter("@ACD1_1", SqlDbType.VarChar, 50),
new SqlParameter("@ACD1_2", SqlDbType.VarChar, 50),
new SqlParameter("@ACD1_3", SqlDbType.VarChar, 50),
new SqlParameter("@ACD1", SqlDbType.VarChar, 50),
new SqlParameter("@ACD2_1", SqlDbType.VarChar, 50),
new SqlParameter("@ACD2_2", SqlDbType.VarChar, 50),
new SqlParameter("@ACD2_3", SqlDbType.VarChar, 50),
new SqlParameter("@ACD2", SqlDbType.VarChar, 50),
new SqlParameter("@DIW_1", SqlDbType.VarChar, 50),
new SqlParameter("@DIW_2", SqlDbType.VarChar, 50),
new SqlParameter("@DIW_3", SqlDbType.VarChar, 50),
new SqlParameter("@DIW", SqlDbType.VarChar, 50),
new SqlParameter("@DIW_BC", SqlDbType.VarChar, 50),
new SqlParameter("@DIW_SC", SqlDbType.VarChar, 50),
new SqlParameter("@WC", SqlDbType.VarChar, 50),
new SqlParameter("@PD", SqlDbType.VarChar, 50),
new SqlParameter("@HXSJ", SqlDbType.VarChar, 50),
new SqlParameter("@BZ", SqlDbType.VarChar, 50),
new SqlParameter("@BDJG", SqlDbType.VarChar, 50),
new SqlParameter("@BDRQ", SqlDbType.DateTime)
};
parameters[i++].Value = model.STATIONID;
parameters[i++].Value = model.LINEID;
parameters[i++].Value = model.T1POWER;
parameters[i++].Value = model.T2POWER;
parameters[i++].Value = model.STARTSPEED;
parameters[i++].Value = model.ENDSPEED;
parameters[i++].Value = model.ACD1_1;
parameters[i++].Value = model.ACD1_2;
parameters[i++].Value = model.ACD1_3;
parameters[i++].Value = model.ACD1;
parameters[i++].Value = model.ACD2_1;
parameters[i++].Value = model.ACD2_2;
parameters[i++].Value = model.ACD2_3;
parameters[i++].Value = model.ACD2;
parameters[i++].Value = model.DIW_1;
parameters[i++].Value = model.DIW_2;
parameters[i++].Value = model.DIW_3;
parameters[i++].Value = model.DIW;
parameters[i++].Value = model.DIW_BC;
parameters[i++].Value = model.DIW_SC;
parameters[i++].Value = model.WC;
parameters[i++].Value = model.PD;
parameters[i++].Value = model.HXSJ;
parameters[i++].Value = model.BZ;
parameters[i++].Value = model.BDJG;
parameters[i++].Value = model.BDRQ;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
public LINESBBD getLineDemarcateInf(string station, string line)
{
LINESBBD model = new LINESBBD();
string sql = "select * from [设备标定] where STATIONID='" + station + "' and LINEID='" + line + "'";
try
{
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
model.STATIONID = dt.Rows[0]["STATIONID"].ToString();
model.LINEID = dt.Rows[0]["LINEID"].ToString();
model.Hxdate = DateTime.Parse(dt.Rows[0]["HXDATE"].ToString());
model.Hxenable = (dt.Rows[0]["HXENABLE"].ToString() == "Y");
model.Jsgldate = DateTime.Parse(dt.Rows[0]["JSGLDATE"].ToString());
model.Jsglenable = (dt.Rows[0]["JSGLENABLE"].ToString() == "Y");
model.Gldate = DateTime.Parse(dt.Rows[0]["GLDATE"].ToString());
model.Glenable = (dt.Rows[0]["GLENABLE"].ToString() == "Y");
model.Yrdate = DateTime.Parse(dt.Rows[0]["YRDATE"].ToString());
model.Yrenable = (dt.Rows[0]["YRENABLE"].ToString() == "Y");
model.Zjdate = DateTime.Parse(dt.Rows[0]["ZJDATE"].ToString());
model.Zjenable = (dt.Rows[0]["ZJENABLE"].ToString() == "Y");
model.Fxylowdate = DateTime.Parse(dt.Rows[0]["FXYLOWDATE"].ToString());
model.Fxylowenable = (dt.Rows[0]["FXYLOWENABLE"].ToString() == "Y");
model.Fxyhighdate = DateTime.Parse(dt.Rows[0]["FXYHIGHDATE"].ToString());
model.Fxyhighenable = (dt.Rows[0]["FXYHIGHENABLE"].ToString() == "Y");
model.Fxymiddate = DateTime.Parse(dt.Rows[0]["FXYMIDDATE"].ToString());
model.Fxymidenable = (dt.Rows[0]["FXYMIDENABLE"].ToString() == "Y");
model.Fxylowmiddate = DateTime.Parse(dt.Rows[0]["FXYLOWMIDDATE"].ToString());
model.Fxylowmidenable = (dt.Rows[0]["FXYLOWMIDENABLE"].ToString() == "Y");
model.Fxyhighmiddate = DateTime.Parse(dt.Rows[0]["FXYHIGHMIDDATE"].ToString());
model.Fxyhighmidenable = (dt.Rows[0]["FXYHIGHMIDENABLE"].ToString() == "Y");
model.Ydjdate = DateTime.Parse(dt.Rows[0]["YDJDATE"].ToString());
model.Ydjenable = (dt.Rows[0]["YDJENABLE"].ToString() == "Y");
model.Lljdate = DateTime.Parse(dt.Rows[0]["LLJDATE"].ToString());
model.Lljenable = (dt.Rows[0]["LLJENABLE"].ToString() == "Y");
model.Yljdate = DateTime.Parse(dt.Rows[0]["YLJDATE"].ToString());
model.Yljenable = (dt.Rows[0]["YLJENABLE"].ToString() == "Y");
model.Sddate = DateTime.Parse(dt.Rows[0]["SDDATE"].ToString());
model.Sdenable = (dt.Rows[0]["SDENABLE"].ToString() == "Y");
model.Hjcsdate = DateTime.Parse(dt.Rows[0]["HJCSDATE"].ToString());
model.Hjcsenable = (dt.Rows[0]["HJCSENABLE"].ToString() == "Y");
model.Zsjdate = DateTime.Parse(dt.Rows[0]["ZSJDATE"].ToString());
model.Zsjenable = (dt.Rows[0]["ZSJENABLE"].ToString() == "Y");
model.Jldate = DateTime.Parse(dt.Rows[0]["JLDATE"].ToString());
model.Jlenable = (dt.Rows[0]["JLENABLE"].ToString() == "Y");
}
else
{
model.STATIONID = station;
model.LINEID = line;
model.Hxdate = DateTime.Now;
model.Hxenable = true;
model.Jsgldate = DateTime.Now;
model.Jsglenable = true;
model.Gldate = DateTime.Now;
model.Glenable = true;
model.Yrdate = DateTime.Now;
model.Yrenable = true;
model.Zjdate = DateTime.Now;
model.Zjenable = true;
model.Fxylowdate = DateTime.Now;
model.Fxylowenable = true;
model.Fxyhighdate = DateTime.Now;
model.Fxyhighenable = true;
model.Fxymiddate = DateTime.Now;
model.Fxymidenable = true;
model.Fxylowmiddate = DateTime.Now;
model.Fxylowmidenable = false;
model.Fxyhighmiddate = DateTime.Now;
model.Fxyhighmidenable = false;
model.Ydjdate = DateTime.Now;
model.Ydjenable = true;
model.Lljdate = DateTime.Now;
model.Lljenable = true;
model.Yljdate = DateTime.Now;
model.Yljenable = true;
model.Sddate = DateTime.Now;
model.Sdenable = true;
model.Hjcsdate = DateTime.Now;
model.Hjcsenable = true;
model.Zsjdate = DateTime.Now;
model.Zsjenable = true;
model.Jldate = DateTime.Now;
model.Jlenable = true;
}
}
catch (Exception)
{
model.STATIONID = station;
model.LINEID = line;
model.Hxdate = DateTime.Now;
model.Hxenable = true;
model.Jsgldate = DateTime.Now;
model.Jsglenable = true;
model.Gldate = DateTime.Now;
model.Glenable = true;
model.Yrdate = DateTime.Now;
model.Yrenable = true;
model.Zjdate = DateTime.Now;
model.Zjenable = true;
model.Fxylowdate = DateTime.Now;
model.Fxylowenable = true;
model.Fxyhighdate = DateTime.Now;
model.Fxyhighenable = true;
model.Fxymiddate = DateTime.Now;
model.Fxymidenable = true;
model.Fxylowmiddate = DateTime.Now;
model.Fxylowmidenable = false;
model.Fxyhighmiddate = DateTime.Now;
model.Fxyhighmidenable = false;
model.Ydjdate = DateTime.Now;
model.Ydjenable = true;
model.Lljdate = DateTime.Now;
model.Lljenable = true;
model.Yljdate = DateTime.Now;
model.Yljenable = true;
model.Sddate = DateTime.Now;
model.Sdenable = true;
model.Hjcsdate = DateTime.Now;
model.Hjcsenable = true;
model.Zsjdate = DateTime.Now;
model.Zsjenable = true;
model.Jldate = DateTime.Now;
model.Jlenable = true;
}
return(model);
}
public bool saveAnalysisDataByIni(analysismeterInidata model, string stationid, string lineid, DateTime bdrq)
{
int i = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [废气仪标定] (");
strSql.Append("STATIONID,"); //=@PZLX,");1
strSql.Append("LINEID,"); //=@JCCLPH,");2
strSql.Append("CO2BZ,"); //=@CLXHBH,");3
strSql.Append("CO2CLZ,"); //=@CLXHBH,");3
strSql.Append("COBZ,"); //=@JCCS,");4
strSql.Append("COCLZ,"); //=@CCRQ,");5
strSql.Append("HCBZ,"); //=@DJRQ,"); 6
strSql.Append("HCCLZ,"); //=@FDJH,");7
strSql.Append("NOBZ,"); //=@CJH,");8
strSql.Append("NOCLZ,"); //=@CZ,");9
strSql.Append("JZDS,"); //=@CZDH,");10
strSql.Append("GDJZ,"); //=@CZDZ,");11
strSql.Append("BZSM,"); //=@LCBDS,");12
strSql.Append("BDJG,"); //=@HBBZ,");13
strSql.Append("BDRQ) "); //=@SYQK,");14
strSql.Append("values (@STATIONID,@LINEID,@CO2BZ,@CO2CLZ,@COBZ,@COCLZ,@HCBZ,@HCCLZ,@NOBZ,@NOCLZ,@JZDS,@GDJZ,@BZSM,@BDJG,@BDRQ)");
SqlParameter[] parameters =
{
new SqlParameter("@STATIONID", SqlDbType.VarChar, 50),
new SqlParameter("@LINEID", SqlDbType.VarChar, 50),
new SqlParameter("@CO2BZ", SqlDbType.VarChar, 50),
new SqlParameter("@CO2CLZ", SqlDbType.VarChar, 100),
new SqlParameter("@COBZ", SqlDbType.VarChar, 50),
new SqlParameter("@COCLZ", SqlDbType.VarChar, 50),
new SqlParameter("@HCBZ", SqlDbType.VarChar, 50),
new SqlParameter("@HCCLZ", SqlDbType.VarChar, 50),
new SqlParameter("@NOBZ", SqlDbType.VarChar, 50),
new SqlParameter("@NOCLZ", SqlDbType.VarChar, 50),
new SqlParameter("@JZDS", SqlDbType.VarChar, 50),
new SqlParameter("@GDJZ", SqlDbType.VarChar, 50),
new SqlParameter("@BZSM", SqlDbType.VarChar, 50),
new SqlParameter("@BDJG", SqlDbType.VarChar, 50),
new SqlParameter("@BDRQ", SqlDbType.DateTime)
};
parameters[i++].Value = stationid;
parameters[i++].Value = lineid;
parameters[i++].Value = model.Co2bz.ToString("0.00");
parameters[i++].Value = model.Co2clz.ToString("0.00");
parameters[i++].Value = model.Cobz.ToString("0.00");
parameters[i++].Value = model.Coclz.ToString("0.00");
parameters[i++].Value = model.Hcbz.ToString("0.00");
parameters[i++].Value = model.Hcclz.ToString("0.00");
parameters[i++].Value = model.Nobz.ToString("0.00");
parameters[i++].Value = model.Noclz.ToString("0.00");
parameters[i++].Value = model.Jzds.ToString();
parameters[i++].Value = model.Gdjz;
parameters[i++].Value = model.Bzsm;
parameters[i++].Value = model.Bdjg;
parameters[i++].Value = bdrq;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
public stationInfModel getStationInf(string stationid)
{
stationInfModel model = new stationInfModel();
string sql = "select * from stationNormalInf";
DateTime datetimemodel;
try
{
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
model.STATIONID = dt.Rows[0]["STATIONID"].ToString();
model.STATIONADD = dt.Rows[0]["STATIONADD"].ToString();
model.STATIONNAME = dt.Rows[0]["STATIONNAME"].ToString();
model.STATIONPERSON = dt.Rows[0]["STATIONPERSON"].ToString();
model.STATIONPHONE = dt.Rows[0]["STATIONPHONE"].ToString();
model.STATIONDATE = dt.Rows[0]["STATIONDATE"].ToString();
model.STATIONJCFF = dt.Rows[0]["STATIONJCFF"].ToString();
model.STANDARD = dt.Rows[0]["STANDARD"].ToString();
model.STATIONNET = dt.Rows[0]["STATIONNET"].ToString();
model.StationCompany = dt.Rows[0]["STATIONCOMPANY"].ToString();
model.JCZXKZH = dt.Rows[0]["JCZXKZH"].ToString();
model.SBHZBH = dt.Rows[0]["SBHZBH"].ToString();
if (DateTime.TryParse(dt.Rows[0]["YXQSTARTTIME"].ToString(), out datetimemodel))
{
model.YXQSTARTTIME = datetimemodel;
}
else
{
model.YXQSTARTTIME = DateTime.Now;
}
if (DateTime.TryParse(dt.Rows[0]["YXQENDTIME"].ToString(), out datetimemodel))
{
model.YXQENDTIME = datetimemodel;
}
else
{
model.YXQENDTIME = DateTime.Now;
}
model.ISLOCK = (dt.Rows[0]["ISLOCK"].ToString() == "Y");
model.LOCKREASON = dt.Rows[0]["LOCKREASON"].ToString();
if (dt.Columns.Contains("CLEARMODE"))
{
model.CLEARMODE = dt.Rows[0]["CLEARMODE"].ToString();
}
else
{
model.CLEARMODE = "Y";
}
if (dt.Columns.Contains("JJLX"))
{
model.JJLX = dt.Rows[0]["JJLX"].ToString();
model.LXR = dt.Rows[0]["LXR"].ToString();
model.FZR = dt.Rows[0]["FZR"].ToString();
if (DateTime.TryParse(dt.Rows[0]["ZCSJ"].ToString(), out datetimemodel))
{
model.ZCSJ = datetimemodel;
}
else
{
model.ZCSJ = DateTime.Now;
}
}
else
{
model.JJLX = "";
model.LXR = "";
model.FZR = "";
model.ZCSJ = DateTime.Now;
}
if (dt.Columns.Contains("JCXS"))
{
model.JCXS = dt.Rows[0]["JCXS"].ToString();
}
else
{
model.JCXS = "";
}
if (dt.Columns.Contains("STATIONCOUNTDATE"))
{
if (DateTime.TryParse(dt.Rows[0]["STATIONCOUNTDATE"].ToString(), out datetimemodel))
{
model.STATIONCOUNTDATE = datetimemodel;
}
else
{
model.STATIONCOUNTDATE = DateTime.Now.AddDays(-1);
}
if (DateTime.TryParse(dt.Rows[0]["LOGINCOUNTDATE"].ToString(), out datetimemodel))
{
model.LOGINCOUNTDATE = datetimemodel;
}
else
{
model.LOGINCOUNTDATE = DateTime.Now.AddDays(-1);
}
}
else
{
model.STATIONCOUNTDATE = DateTime.Now.AddDays(-1);
model.LOGINCOUNTDATE = DateTime.Now.AddDays(-1);
}
if (dt.Columns.Contains("LSHRULE"))
{
model.LSHRULE = dt.Rows[0]["LSHRULE"].ToString();
if (model.LSHRULE == "")
{
model.LSHRULE = "通用";
}
}
else
{
model.LSHRULE = "通用";
}
}
else
{
model.STATIONID = "-2"; //当服务器上没有找到本线时，本线编号置为-2，以免为0
}
}
catch (Exception)
{
throw;
}
return(model);
}
/// <summary>
/// 用SDS对象插入或更新条检测数据
/// </summary>
/// <param name="SDS">SDS</param>
/// <returns>int 0为失败，1为插入成功，2为更新成功</returns>
public int Save_SDS(SDS SDS)
{
string sqli = "insert into SDS(JYLSH,JYCS,SBRZBM,CLID,JCBGBH,CLPH,COLOWCLZ,COLOWXZ,HCLOWCLZ,HCLOWXZ,COHIGHCLZ,COHIGHXZ,HCHIGHCLZ,HCHIGHXZ,LAMDAHIGHCLZ,LAMDAHIGHXZ,LAMDAHIGHPD,LOWPD,HIGHPD,ZHPD,JCRQ,WD,SD,DQY,SBMC,SBXH,SBZZC,FXYXH,FXYBH,FXYZZC,ZSJXH,ZSJBH,ZSJZZC,COLOWPD,HCLOWPD,ZSLOW,JYWDLOW,COHIGHPD,HCHIGHPD,ZSHIGH,JYWDHIGH,SHY,SYNCHDATE,YW,GLKQXSSX,GLKQXSXX,JCKSSJ,JCJSSJ,CO2HIGH,O2HIGH,CO2LOW,O2LOW,COLOWXXZ,COHIGHXXZ,COLOWXYZ,COHIGHXYZ,CO2LOWXYZ,CO2HIGHXYZ,HCLOWXYZ,HCHIGHXYZ) values(@JYLSH,@JYCS,@SBRZBM,@CLID,@JCBGBH,@CLPH,@COLOWCLZ,@COLOWXZ,@HCLOWCLZ,@HCLOWXZ,@COHIGHCLZ,@COHIGHXZ,@HCHIGHCLZ,@HCHIGHXZ,@LAMDAHIGHCLZ,@LAMDAHIGHXZ,@LAMDAHIGHPD,@LOWPD,@HIGHPD,@ZHPD,@JCRQ,@WD,@SD,@DQY,@SBMC,@SBXH,@SBZZC,@FXYXH,@FXYBH,@FXYZZC,@ZSJXH,@ZSJBH,@ZSJZZC,@COLOWPD,@HCLOWPD,@ZSLOW,@JYWDLOW,@COHIGHPD,@HCHIGHPD,@ZSHIGH,@JYWDHIGH,@SHY,@SYNCHDATE,@YW,@GLKQXSSX,@GLKQXSXX,@JCKSSJ,@JCJSSJ,@CO2HIGH,@O2HIGH,@CO2LOW,@O2LOW,@COLOWXXZ,@COHIGHXXZ,@COLOWXYZ,@COHIGHXYZ,@CO2LOWXYZ,@CO2HIGHXYZ,@HCLOWXYZ,@HCHIGHXYZ)";
string sqlu = "update SDS set JYLSH=@JYLSH,JYCS=@JYCS,SBRZBM=@SBRZBM,CLPH=@CLPH,JCBGBH=@JCBGBH,COLOWCLZ=@COLOWCLZ,COLOWXZ=@COLOWXZ,HCLOWCLZ=@HCLOWCLZ,HCLOWXZ=@HCLOWXZ,COHIGHCLZ=@COHIGHCLZ,COHIGHXZ=@COHIGHXZ,HCHIGHCLZ=@HCHIGHCLZ,HCHIGHXZ=@HCHIGHXZ,LAMDAHIGHCLZ=@LAMDAHIGHCLZ,LAMDAHIGHXZ=@LAMDAHIGHXZ,LAMDAHIGHPD=@LAMDAHIGHPD,LOWPD=@LOWPD,HIGHPD=@HIGHPD,ZHPD=@ZHPD,JCRQ=@JCRQ,WD=@WD,SD=@SD,DQY=@DQY,SBMC=@SBMC,SBXH=@SBXH,SBZZC=@SBZZC,FXYXH=@FXYXH,FXYBH=@FXYBH,FXYZZC=@FXYZZC,ZSJXH=@ZSJXH,ZSJBH=@ZSJBH,ZSJZZC=@ZSJZZC,COLOWPD=@COLOWPD,HCLOWPD=@HCLOWPD,ZSLOW=@ZSLOW,JYWDLOW=@JYWDLOW,COHIGHPD=@COHIGHPD,HCHIGHPD=@HCHIGHPD,ZSHIGH=@ZSHIGH,JYWDHIGH=@JYWDHIGH,SHY=@SHY,SYNCHDATE=@SYNCHDATE,YW=@YW,GLKQXSSX=@GLKQXSSX,GLKQXSXX=@GLKQXSXX,JCKSSJ=@JCKSSJ,JCJSSJ=@JCJSSJ,CO2HIGH=@CO2HIGH,O2HIGH=@O2HIGH,CO2LOW=@CO2LOW,O2LOW=@O2LOW,COLOWXXZ=@COLOWXXZ,COHIGHXXZ=@COHIGHXXZ,COLOWXYZ=@COLOWXYZ,COHIGHXYZ=@COHIGHXYZ,CO2LOWXYZ=@CO2LOWXYZ,CO2HIGHXYZ=@CO2HIGHXYZ,HCLOWXYZ=@HCLOWXYZ,HCHIGHXYZ=@HCHIGHXYZ where CLID=@CLID";
SqlParameter[] spr =
{
new SqlParameter("@JYLSH", SDS.JYLSH),
new SqlParameter("@JYCS", SDS.JYCS),
new SqlParameter("@SBRZBM", SDS.SBRZBM),
new SqlParameter("@CLID", SDS.CLID), //1
new SqlParameter("@JCBGBH", SDS.JCBGBH), //1
new SqlParameter("@CLPH", SDS.CLPH),
new SqlParameter("@COLOWCLZ", SDS.COLOWCLZ),
new SqlParameter("@COLOWXZ", SDS.COLOWXZ),
new SqlParameter("@HCLOWCLZ", SDS.HCLOWCLZ),
new SqlParameter("@HCLOWXZ", SDS.HCLOWXZ),
new SqlParameter("@COHIGHCLZ", SDS.COHIGHCLZ), //6
new SqlParameter("@COHIGHXZ", SDS.COHIGHXZ),
new SqlParameter("@HCHIGHCLZ", SDS.HCHIGHCLZ),
new SqlParameter("@HCHIGHXZ", SDS.HCHIGHXZ),
new SqlParameter("@LAMDAHIGHCLZ", SDS.LAMDAHIGHCLZ),
new SqlParameter("@LAMDAHIGHXZ", SDS.LAMDAHIGHXZ), //11
new SqlParameter("@LAMDAHIGHPD", SDS.LAMDAHIGHPD), //11
new SqlParameter("@LOWPD", SDS.LOWPD),
new SqlParameter("@HIGHPD", SDS.HIGHPD), //11
new SqlParameter("@ZHPD", SDS.ZHPD),
new SqlParameter("@JCRQ", SDS.JCRQ),
new SqlParameter("@WD", SDS.WD),
new SqlParameter("@SD", SDS.SD),
new SqlParameter("@DQY", SDS.DQY), //16
new SqlParameter("@SBMC", SDS.SBMC),
new SqlParameter("@SBXH", SDS.SBXH),
new SqlParameter("@SBZZC", SDS.SBZZC),
new SqlParameter("@ZSJXH", SDS.ZSJXH),
new SqlParameter("@ZSJBH", SDS.ZSJBH), //21
new SqlParameter("@ZSJZZC", SDS.ZSJZZC),
new SqlParameter("@FXYXH", SDS.FXYXH),
new SqlParameter("@FXYBH", SDS.FXYBH),
new SqlParameter("@FXYZZC", SDS.FXYZZC), //47
new SqlParameter("@COLOWPD", SDS.COLOWPD),
new SqlParameter("@HCLOWPD", SDS.HCLOWPD),
new SqlParameter("@ZSLOW", SDS.ZSLOW), //21
new SqlParameter("@JYWDLOW", SDS.JYWDLOW),
new SqlParameter("@COHIGHPD", SDS.COHIGHPD),
new SqlParameter("@HCHIGHPD", SDS.HCHIGHPD),
new SqlParameter("@ZSHIGH", SDS.ZSHIGH), //21
new SqlParameter("@JYWDHIGH", SDS.JYWDHIGH),
new SqlParameter("@SHY", SDS.SHY),
new SqlParameter("@SYNCHDATE", SDS.SYNCHDATE),
new SqlParameter("@YW", SDS.YW), //21
new SqlParameter("@GLKQXSSX", SDS.GLKQXSSX),
new SqlParameter("@GLKQXSXX", SDS.GLKQXSXX),
new SqlParameter("@JCKSSJ", SDS.JCKSSJ),
new SqlParameter("@JCJSSJ", SDS.JCJSSJ),
new SqlParameter("@CO2HIGH", SDS.CO2HIGH),
new SqlParameter("@O2HIGH", SDS.O2HIGH),
new SqlParameter("@CO2LOW", SDS.CO2LOW),
new SqlParameter("@O2LOW", SDS.O2LOW),
new SqlParameter("@COLOWXXZ", SDS.COLOWXXZ),
new SqlParameter("@COHIGHXXZ", SDS.COHIGHXXZ),
new SqlParameter("@COLOWXYZ", SDS.COLOWXYZ),
new SqlParameter("@COHIGHXYZ", SDS.COHIGHXYZ),
new SqlParameter("@CO2LOWXYZ", SDS.CO2LOWXYZ),
new SqlParameter("@CO2HIGHXYZ", SDS.CO2HIGHXYZ),
new SqlParameter("@HCLOWXYZ", SDS.HCLOWXYZ),
new SqlParameter("@HCHIGHXYZ", SDS.HCHIGHXYZ)
//47
};
try
{
if (Have_SDS(SDS.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>
public bool Update(SYS.Model.JCXXXB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update JCXXXB set");
//strSql.Append("JCXBH=@JCXBH,");
strSql.Append(" GYJSJIP=@GYJSJIP,");
strSql.Append("JCXMC=@JCXMC,");
strSql.Append("JCFFLX=@JCFFLX,");
strSql.Append("DPCGJBH=@DPCGJBH,");
strSql.Append("FQFXYBH=@FQFXYBH,");
strSql.Append("BTGYDJBH=@BTGYDJBH,");
strSql.Append("WYZSBBH=@WYZSBBH,");
strSql.Append("QTLLFXYBH=@QTLLFXYBH,");
strSql.Append("LEDDPBH=@LEDDPBH,");
strSql.Append("LEDPZ=@LEDPZ,");
strSql.Append("XH=@XH,");
strSql.Append("RZBH=@RZBH,");
strSql.Append("ZZCS=@ZZCS,");
strSql.Append("LLJBH=@LLJBH,");
strSql.Append("DPCGJPZ=@DPCGJPZ,");
strSql.Append("FQFXYPZ=@FQFXYPZ,");
strSql.Append("BTGYDJPZ=@BTGYDJPZ,");
strSql.Append("LLJPZ=@LLJPZ,");
strSql.Append("PCBH=@PCBH,");
strSql.Append("HJZBH=@HJZBH ");
//strSql.Append("LJSYS=@LJSYS");//更新时不改变累计试验数
strSql.Append(" where JCXBH=@JCXBH");
//strSql.Append("values (@JCXBH,@GYJSJIP,@JCXMC,@JCFFLX,@DPCGJBH,@FQFXYBH,@BTGYDJBH,@WYZSBBH,@QTLLFXYBH,@LEDDPBH,@XH,@RZBH,@ZZCS,@LLJBH,@LJSYS)");
SqlParameter[] parameters =
{
//new SqlParameter("@JCXBH", SqlDbType.VarChar,32),
new SqlParameter("@GYJSJIP", SqlDbType.VarChar, 16),
new SqlParameter("@JCXMC", SqlDbType.VarChar, 64),
new SqlParameter("@JCFFLX", SqlDbType.Int, 4),
new SqlParameter("@DPCGJBH", SqlDbType.Int, 4),
new SqlParameter("@FQFXYBH", SqlDbType.Int, 4),
new SqlParameter("@BTGYDJBH", SqlDbType.Int, 4),
new SqlParameter("@WYZSBBH", SqlDbType.Int, 4),
new SqlParameter("@QTLLFXYBH", SqlDbType.Int, 4),
new SqlParameter("@LEDDPBH", SqlDbType.Int, 4),
new SqlParameter("@LEDPZ", SqlDbType.VarChar, 32),
new SqlParameter("@XH", SqlDbType.VarChar, 32),
new SqlParameter("@RZBH", SqlDbType.VarChar, 64),
new SqlParameter("@ZZCS", SqlDbType.VarChar, 64),
new SqlParameter("@LLJBH", SqlDbType.Int, 4),
new SqlParameter("@DPCGJPZ", SqlDbType.VarChar, 64),
new SqlParameter("@FQFXYPZ", SqlDbType.VarChar, 64),
new SqlParameter("@BTGYDJPZ", SqlDbType.VarChar, 64),
new SqlParameter("@LLJPZ", SqlDbType.VarChar, 64),
new SqlParameter("@PCBH", SqlDbType.Int, 4),
new SqlParameter("@HJZBH", SqlDbType.Int, 4),
//new SqlParameter("@LJSYS", SqlDbType.Int,4),
new SqlParameter("@JCXBH", SqlDbType.VarChar, 32)
};
//parameters[0].Value = model.JCXBH;
parameters[0].Value = model.GYJSJIP;
parameters[1].Value = model.JCXMC;
parameters[2].Value = model.JCFFLX;
parameters[3].Value = model.DPCGJBH;
parameters[4].Value = model.FQFXYBH;
parameters[5].Value = model.BTGYDJBH;
parameters[6].Value = model.WYZSBBH;
parameters[7].Value = model.QTLLFXYBH;
parameters[8].Value = model.LEDDPBH;
parameters[9].Value = model.LEDPZ;
parameters[10].Value = model.XH;
parameters[11].Value = model.RZBH;
parameters[12].Value = model.ZZCS;
parameters[13].Value = model.LLJBH;
parameters[14].Value = model.DPCGJPZ;
parameters[15].Value = model.FQFXYPZ;
parameters[16].Value = model.BTGYDJPZ;
parameters[17].Value = model.LLJPZ;
parameters[18].Value = model.PCBH;
parameters[19].Value = model.HJZBH;
//parameters[14].Value = model.LJSYS;
parameters[20].Value = model.JCXBH;
try
{
int rows = DBHelperSQL.Execute(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}