/// <summary> /// 修改检测线的状态 /// </summary> public int updateJcxcltByJcxh(string jcxh, string newjcxcl) { string sql = "update JCXZT set JCXCL=" + "'" + newjcxcl + "'" + " where JCXH=" + "'" + jcxh + "'"; int rows = DBHelperSQL.Execute(sql); return(rows); }
/// <summary> /// 修改检测线的累计试验数 /// </summary> public int updateJcxLjsycs(string IP, int ljsycs) { string sql = "update JCXXXB set LJSYS=" + "'" + ljsycs + "'" + " where GYJSJIP=" + "'" + IP + "'"; int rows = DBHelperSQL.Execute(sql); return(rows); }
/// <summary> /// 修改检测线的状态 /// </summary> public int updateDataByJcxh(string jcxh, string newsj1, string newsj2, string newsj3, string newsj4, string newsj5) { string sql = "update JCXZT set SJ1=" + "'" + newsj1 + "'" + ",SJ2=" + "'" + newsj2 + "'" + ",SJ3=" + "'" + newsj3 + "'" + ",SJ4=" + "'" + newsj4 + "'" + ",SJ5=" + "'" + newsj5 + "'" + " where JCXH=" + "'" + jcxh + "'"; int rows = DBHelperSQL.Execute(sql); return(rows); }
/// <summary> /// 修改检测线的状态 /// </summary> public int updateJsbzByJcxh(string jcxh, string newjsbz) { string sql = "update JCXZT set JSBZ=" + "'" + newjsbz + "'" + " where JCXH=" + "'" + jcxh + "'"; int rows = DBHelperSQL.Execute(sql); return(rows); }
/// <summary> /// 用设备信息更新设备 /// </summary> /// <param name="sb">SBXXB</param> /// <returns>bool</returns> public bool Update_sb(SBXXB sb) { string sql = "update sbxxb set sblx=@sblx,sbmc=@sbmc,sccj=@sccj,syzt=@syzt,sbms=@sbms,xhtd=@xhtd,gdtd=@gdtd,cktd=@cktd where sbbh=@sbbh"; SqlParameter[] spr = { new SqlParameter("@sbbh", sb.SBBH), new SqlParameter("@sblx", sb.SBLX), new SqlParameter("@sbmc", sb.SBMC), new SqlParameter("@sccj", sb.SCCJ), new SqlParameter("@syzt", sb.SYZT), new SqlParameter("@xhtd", sb.XHTD), new SqlParameter("@gdtd", sb.GDTD), new SqlParameter("@cktd", sb.CKTD), new SqlParameter("@sbms", sb.SBMS) }; try { if (DBHelperSQL.Execute(sql, spr) > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
/// <summary> /// 修改检测线的状态 /// </summary> public int updateCsffByJcxh(string jcxh, string newcsff) { string sql = "update JCXZT set CSFF=" + "'" + newcsff + "'" + " where JCXH=" + "'" + jcxh + "'"; int rows = DBHelperSQL.Execute(sql); return(rows); }
/// <summary> /// 更新检测站设置 /// </summary> /// <param name="jcz">JCZXXB</param> /// <returns>bool</returns> public bool Update_jcz(JCZXXB jcz) { string sql = "update jczxxb set jczbh=@jczbh,jczmc=@jczmc,jczdh=@jczdh,jczdz=@jczdz,jczfzr=@jczfzr"; SqlParameter[] spr = { new SqlParameter("@jczbh", jcz.JCZBH), new SqlParameter("@jczmc", jcz.JCZMC), new SqlParameter("@jczdh", jcz.JCZDH), new SqlParameter("@jczdz", jcz.JCZDZ), new SqlParameter("@jczfzr", jcz.JCZFZR) }; try { if (DBHelperSQL.Execute(sql, spr) > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
/// <summary> /// 用设备信息保存设备 /// </summary> /// <param name="sb">SBXXB</param> /// <returns>bool</returns> public bool Save_sb(SBXXB sb) { string sql = "insert into sbxxb values(@sblx,@sbmc,@sccj,@syzt,@xhtd,@gdtd,@cktd,@sbms)"; SqlParameter[] spr = { new SqlParameter("@sblx", sb.SBLX), new SqlParameter("@sbmc", sb.SBMC), new SqlParameter("@sccj", sb.SCCJ), new SqlParameter("@syzt", sb.SYZT), new SqlParameter("@xhtd", sb.XHTD), new SqlParameter("@gdtd", sb.GDTD), new SqlParameter("@cktd", sb.CKTD), new SqlParameter("@sbms", sb.SBMS) }; try { if (DBHelperSQL.Execute(sql, spr) > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
/// <summary> /// 用YGB Model更新一个员工 /// </summary> /// <param name="yg">YGB Model</param> /// <returns>bool</returns> public bool Update_YG(YGB yg) { string sql = "update YGB set YGXM=@YGXM,DHHM=@DHHM,YGZWBH=@YGZWBH,YGSFZ=@YGSFZ,YGZT=@YGZT,USER_NAME=@USER_NAME,PASSWORD=@PASSWORD where ygbh=@ygbh"; SqlParameter[] spr = { new SqlParameter("@YGXM", yg.YGXM), new SqlParameter("@DHHM", yg.DHHM), new SqlParameter("@YGZWBH", yg.YGZWBH), new SqlParameter("@YGSFZ", yg.YGSFZ), new SqlParameter("@YGZT", yg.YGZT), new SqlParameter("@USER_NAME", yg.User_Name), new SqlParameter("@PASSWORD", yg.Password), new SqlParameter("@ygbh", yg.YGBH) }; try { if (DBHelperSQL.Execute(sql, spr) > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
/// <summary> /// 用检测线新建检测线 /// </summary> /// <param name="jcx">jcxxxb Model</param> /// <returns>bool</returns> public bool Save_jcx(JCXXXB jcx) { string sql = "insert into jcxxxb values(@gyjsjip,@jcxmc,@jcfflx,@dpcgjbh,@fqfxybh,@btgydjbh,@wyzsbbh,@qtllfxybh,@LEDDPBH)"; SqlParameter[] spr = { new SqlParameter("@gyjsjip", jcx.GYJSJIP), new SqlParameter("@jcxmc", jcx.JCXMC), new SqlParameter("@jcfflx", jcx.JCFFLX), new SqlParameter("@dpcgjbh", jcx.DPCGJBH), new SqlParameter("@fqfxybh", jcx.FQFXYBH), new SqlParameter("@btgydjbh", jcx.BTGYDJBH), new SqlParameter("@wyzsbbh", jcx.WYZSBBH), new SqlParameter("@qtllfxybh", jcx.QTLLFXYBH), new SqlParameter("@LEDDPBH", jcx.LEDDPBH) }; try { if (DBHelperSQL.Execute(sql, spr) > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
/// <summary> /// 用YGB Model保存一个员工 /// </summary> /// <param name="yg">YGB Model</param> /// <returns>bool</returns> public bool Save_YG(YGB yg) { string sql = "insert into YGB values(@ygxm,@dhhm,@ygzwbh,@ygsfz,@ygzt,@user_name,@password)"; SqlParameter[] spr = { new SqlParameter("@ygxm", yg.YGXM), new SqlParameter("@dhhm", yg.DHHM), new SqlParameter("@ygzwbh", yg.YGZWBH), new SqlParameter("@ygzt", yg.YGZT), new SqlParameter("@ygsfz", yg.YGSFZ), new SqlParameter("@user_name", yg.User_Name), new SqlParameter("@password", yg.Password) }; try { int i = DBHelperSQL.Execute(sql, spr); if (i > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
/// <summary> /// 更新保存系统设置 /// </summary> /// <param name="sys">SYS.Model.SYSConfig Model</param> /// <returns>bool</returns> public bool Save_Sys_Config(SYS.Model.SYSConfig sys) { string sql = "update SYSConfig set DYSJ=@dysj,DYJCCS=@dyjccs,FCFS=@fcfs,QXZ=@qxz,Interval=@Interval"; SqlParameter[] spr = { new SqlParameter("@dysj", sys.DYSJ), new SqlParameter("@dyjccs", sys.DYJCCS), new SqlParameter("@fcfs", sys.FCFS), new SqlParameter("@qxz", sys.QXZ), new SqlParameter("@Interval", sys.Interval) }; try { int i = DBHelperSQL.Execute(sql, spr); if (i > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
/// <summary> /// 用检测线更新检测线 /// </summary> /// <param name="jcx">jcxxxb Model</param> /// <returns>bool</returns> public bool Update_jcx(JCXXXB jcx) { string sql = "update jcxxxb set gyjsjip=@gyjsjip,jcxmc=@jcxmc,jcfflx=@jcfflx,dpcgjbh=@dpcgjbh,fqfxybh=@fqfxybh,btgydjbh=@btgydjbh,wyzsbbh=@wyzsbbh,qtllfxybh=@qtllfxybh,LEDDPBH=@LEDDPBH where jcxbh=@jcxbh"; SqlParameter[] spr = { new SqlParameter("@jcxbh", jcx.JCXBH), new SqlParameter("@gyjsjip", jcx.GYJSJIP), new SqlParameter("@jcxmc", jcx.JCXMC), new SqlParameter("@jcfflx", jcx.JCFFLX), new SqlParameter("@dpcgjbh", jcx.DPCGJBH), new SqlParameter("@fqfxybh", jcx.FQFXYBH), new SqlParameter("@btgydjbh", jcx.BTGYDJBH), new SqlParameter("@wyzsbbh", jcx.WYZSBBH), new SqlParameter("@qtllfxybh", jcx.QTLLFXYBH), new SqlParameter("@LEDDPBH", jcx.LEDDPBH) }; try { if (DBHelperSQL.Execute(sql, spr) > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
/// <summary> /// 修改消息状态 /// </summary> /// <param name="ID">消息ID</param> /// <param name="flag">消息状态</param> /// <returns>bool</returns> public bool Set_Read(int ID, string flag) { string sql = "Update xxxxb set flag=@flag where ID=@ID"; SqlParameter[] spr = { new SqlParameter("@ID", ID), new SqlParameter("@flag", flag) }; try { if (DBHelperSQL.Execute(sql, spr) > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
/// <summary> /// 修改检测线的IP地址 /// </summary> public int updateJcxLjsycs(string IP, string newIP) { string sql = "update JCXXXB set GYJSJIP=" + "'" + newIP + "'" + " where GYJSJIP=" + "'" + IP + "'"; int rows = DBHelperSQL.Execute(sql); return(rows); }
public int updateJcrq(string jcbh, string jcrq) { string sql = "update BJCLXXB set JCRQ=" + "'" + jcrq + "'" + " where JCBH=" + "'" + jcbh + "'"; int rows = DBHelperSQL.Execute(sql); return(rows); }
/// <summary> /// 检测完毕 修改检测次数和 检测标记 /// </summary> public int updateJcXx(string jcbh, int jccs, string jczt) { string sql = "update BJCLXXB set JCCS=" + (jccs + 1) + ",JCZT=" + "'" + jczt + "'" + ", JCBJ=0 where JCBH=" + "'" + jcbh + "'"; int rows = DBHelperSQL.Execute(sql); return(rows); }
public int updateJcFf(string jcbh, string jcff) { string sql = "update BJCLXXB set QRJCFF=" + "'" + jcff + "'" + " where JCBH=" + "'" + jcbh + "'"; int rows = DBHelperSQL.Execute(sql); return(rows); }
/// <summary> /// 用JZJS插入逐秒数据 /// </summary> /// <param name="JZJS">JZJS</param> /// <returns>int 0为失败,1为插入成功,2为更新成功</returns> public int Save_SDSSseconds(SDSseconds sds) { string sqli = "insert into SDS_DATASECONDS(JYLSH,JYCS,CYDS,CLID,CLHP,JCSJ,MMTIME,MMSX,MMLB,MMHC,MMCO,MMO2,MMCO2,MMLAMDA,MMZS,MMYW,MMWD,MMSD,MMDQY) values(@JYLSH,@JYCS,@CYDS,@CLID,@CLHP,@JCSJ,@MMTIME,@MMSX,@MMLB,@MMHC,@MMCO,@MMO2,@MMCO2,@MMLAMDA,@MMZS,@MMYW,@MMWD,@MMSD,@MMDQY)"; string sqlu = "update SDS_DATASECONDS set JYLSH=@JYLSH,JYCS=@JYCS,CYDS=@CYDS,CLHP=@CLHP,JCSJ=@JCSJ,MMTIME=@MMTIME,MMSX=@MMSX,MMLB=@MMLB,MMHC=@MMHC,MMCO=@MMCO,MMO2=@MMO2,MMCO2=@MMCO2,MMLAMDA=@MMLAMDA,MMZS=@MMZS,MMYW=@MMYW,MMWD=@MMWD,MMSD=@MMSD,MMDQY=@MMDQY where CLID=@CLID"; SqlParameter[] spr = { new SqlParameter("@JYLSH", sds.JYLSH), //1 new SqlParameter("@JYCS", sds.JYCS), //1 new SqlParameter("@CYDS", sds.CYDS), //1 new SqlParameter("@CLID", sds.CLID), //1 new SqlParameter("@CLHP", sds.CLHP), new SqlParameter("@JCSJ", sds.JCSJ), new SqlParameter("@MMTIME", sds.MMTIME), new SqlParameter("@MMSX", sds.MMSX), new SqlParameter("@MMLB", sds.MMLB), //6 new SqlParameter("@MMHC", sds.MMHC), new SqlParameter("@MMCO", sds.MMCO), new SqlParameter("@MMO2", sds.MMO2), new SqlParameter("@MMCO2", sds.MMCO2), new SqlParameter("@MMLAMDA", sds.MMLAMDA), new SqlParameter("@MMZS", sds.MMZS), //6 new SqlParameter("@MMYW", sds.MMYW), new SqlParameter("@MMWD", sds.MMWD), new SqlParameter("@MMSD", sds.MMSD), new SqlParameter("@MMDQY", sds.MMDQY) //47 }; try { if (Have_SDSseconds(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; return(0); } }
public bool saveFlowmeterDataByIni(Flowmeterdata 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("O2GLCBZ,"); //=@CLXHBH,");3 strSql.Append("O2GLCCLZ,"); //=@CLXHBH,");3 strSql.Append("O2GLCWC,"); //=@JCCS,");4 strSql.Append("O2DLCBZ,"); //=@CCRQ,");5 strSql.Append("O2DLCCLZ,"); //=@DJRQ,"); 6 strSql.Append("O2DLCWC,"); //=@FDJH,");7 strSql.Append("BZSM,"); //=@LCBDS,");12 strSql.Append("BDJG,"); //=@HBBZ,");13 strSql.Append("BDRQ) "); //=@SYQK,");14 strSql.Append("values (@STATIONID,@LINEID,@O2GLCBZ,@O2GLCCLZ,@O2GLCWC,@O2DLCBZ,@O2DLCCLZ,@O2DLCWC,@BZSM,@BDJG,@BDRQ)"); SqlParameter[] parameters = { new SqlParameter("@STATIONID", SqlDbType.VarChar, 50), new SqlParameter("@LINEID", SqlDbType.VarChar, 50), new SqlParameter("@O2GLCBZ", SqlDbType.VarChar, 50), new SqlParameter("@O2GLCCLZ", SqlDbType.VarChar, 100), new SqlParameter("@O2GLCWC", SqlDbType.VarChar, 50), new SqlParameter("@O2DLCBZ", SqlDbType.VarChar, 50), new SqlParameter("@O2DLCCLZ", SqlDbType.VarChar, 50), new SqlParameter("@O2DLCWC", 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.O2glcbz.ToString("0.00"); parameters[i++].Value = model.O2glcclz.ToString("0.00"); parameters[i++].Value = model.O2glcwc.ToString("0.00"); parameters[i++].Value = model.O2dlcbz.ToString("0.00"); parameters[i++].Value = model.O2dlcclz.ToString("0.00"); parameters[i++].Value = model.O2dlcwc.ToString("0.00"); 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 saveFlowmeterData(FLOWMETER model) { int i = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [流量计标定] ("); strSql.Append("STATIONID,"); //=@PZLX,");1 strSql.Append("LINEID,"); //=@JCCLPH,");2 strSql.Append("O2GLCBZ,"); //=@CLXHBH,");3 strSql.Append("O2GLCCLZ,"); //=@CLXHBH,");3 strSql.Append("O2GLCWC,"); //=@JCCS,");4 strSql.Append("O2DLCBZ,"); //=@CCRQ,");5 strSql.Append("O2DLCCLZ,"); //=@DJRQ,"); 6 strSql.Append("O2DLCWC,"); //=@FDJH,");7 strSql.Append("BZSM,"); //=@LCBDS,");12 strSql.Append("BDJG,"); //=@HBBZ,");13 strSql.Append("BDRQ) "); //=@SYQK,");14 strSql.Append("values (@STATIONID,@LINEID,@O2GLCBZ,@O2GLCCLZ,@O2GLCWC,@O2DLCBZ,@O2DLCCLZ,@O2DLCWC,@BZSM,@BDJG,@BDRQ)"); SqlParameter[] parameters = { new SqlParameter("@STATIONID", SqlDbType.VarChar, 50), new SqlParameter("@LINEID", SqlDbType.VarChar, 50), new SqlParameter("@O2GLCBZ", SqlDbType.VarChar, 50), new SqlParameter("@O2GLCCLZ", SqlDbType.VarChar, 100), new SqlParameter("@O2GLCWC", SqlDbType.VarChar, 50), new SqlParameter("@O2DLCBZ", SqlDbType.VarChar, 50), new SqlParameter("@O2DLCCLZ", SqlDbType.VarChar, 50), new SqlParameter("@O2DLCWC", 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.O2GLCBZ; parameters[i++].Value = model.O2GLCCLZ; parameters[i++].Value = model.O2GLCWC; parameters[i++].Value = model.O2DLCBZ; parameters[i++].Value = model.O2DLCCLZ; parameters[i++].Value = model.O2DLCWC; 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 saveWordLogByIni(workLogData model) { int i = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [操作日志] ("); strSql.Append("PROID,"); //=@PZLX,");1 strSql.Append("PRONAME,"); //=@JCCLPH,");2 strSql.Append("STATIONID,"); //=@CLXHBH,");3 strSql.Append("LINEID,"); //=@CLXHBH,");3 strSql.Append("CZY,"); //=@JCCS,");4 strSql.Append("DATA,"); //=@CCRQ,");5 strSql.Append("STATE,"); //=@CLXHBH,");3 strSql.Append("RESULT,"); //=@CLXHBH,");3 strSql.Append("BDRQ,"); //=@JCCS,");4 strSql.Append("BZSM) "); //=@SYQK,");14 strSql.Append("values (@PROID,@PRONAME,@STATIONID,@LINEID,@CZY,@DATA,@STATE,@RESULT,@BDRQ,@BZSM)"); SqlParameter[] parameters = { new SqlParameter("@PROID", SqlDbType.VarChar, 50), new SqlParameter("@PRONAME", SqlDbType.VarChar, 50), new SqlParameter("@STATIONID", SqlDbType.VarChar, 50), new SqlParameter("@LINEID", SqlDbType.VarChar, 50), new SqlParameter("@CZY", SqlDbType.VarChar, 50), new SqlParameter("@DATA", SqlDbType.VarChar, 1000), new SqlParameter("@STATE", SqlDbType.VarChar, 50), new SqlParameter("@RESULT", SqlDbType.VarChar, 50), new SqlParameter("@BDRQ", SqlDbType.DateTime), new SqlParameter("@BZSM", SqlDbType.VarChar, 100) }; parameters[i++].Value = model.ProjectID; parameters[i++].Value = model.ProjectName; parameters[i++].Value = model.Stationid; parameters[i++].Value = model.Lineid; parameters[i++].Value = model.Czy; parameters[i++].Value = model.Data; parameters[i++].Value = model.State; parameters[i++].Value = model.Result; parameters[i++].Value = model.Date; parameters[i++].Value = model.Bzsm; 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_jzjs_jcxx(JZJS_JCXXB vmas) { string sqli = "insert into jzjs_jcxxb(JCBH,JCZMC,JCRQ,SBHZH,CGJXH,CGJZZC,YDJXH,YDJZZC,ZSJXH,ZSJZZC,HJZXH,HJZZZC,PCXH,PCZZC,JCY,SHY,PZR,ZCY) values(@JCBH,@JCZMC,@JCRQ,@SBHZH,@CGJXH,@CGJZZC,@YDJXH,@YDJZZC,@ZSJXH,@ZSJZZC,@HJZXH,@HJZZZC,@PCXH,@PCZZC,@JCY,@SHY,@PZR,@ZCY)"; string sqlu = "update jzjs_jcxxb set JCZMC=@JCZMC,JCRQ=@JCRQ,SBHZH=@SBHZH,CGJXH=@CGJXH,CGJZZC=@CGJZZC,YDJXH=@YDJXH,YDJZZC=@YDJZZC,ZSJXH=@ZSJXH,ZSJZZC=@ZSJZZC,HJZXH=@HJZXH,HJZZZC=@HJZZZC,PCXH=@PCXH,PCZZC=@PCZZC,JCY=@JCY,SHY=@SHY,PZR=@PZR,ZCY=@ZCY where JCBH=@JCBH"; SqlParameter[] spr = { new SqlParameter("@JCBH", vmas.JCBH), //1 new SqlParameter("@JCZMC", vmas.JCZMC), new SqlParameter("@JCRQ", vmas.JCRQ), new SqlParameter("@SBHZH", vmas.SBHZH), new SqlParameter("@CGJXH", vmas.CGJXH), //6 new SqlParameter("@CGJZZC", vmas.CGJZZC), new SqlParameter("@YDJXH", vmas.YDJXH), new SqlParameter("@YDJZZC", vmas.YDJZZC), new SqlParameter("@ZSJXH", vmas.ZSJXH), new SqlParameter("@ZSJZZC", vmas.ZSJZZC), //11 new SqlParameter("@HJZXH", vmas.HJZXH), //1 new SqlParameter("@HJZZZC", vmas.HJZZZC), new SqlParameter("@PCXH", vmas.PCXH), new SqlParameter("@PCZZC", vmas.PCZZC), new SqlParameter("@JCY", vmas.JCY), new SqlParameter("@SHY", vmas.SHY), //6 new SqlParameter("@PZR", vmas.PZR), new SqlParameter("@ZCY", vmas.ZCY) }; try { if (Have_JZJS_jcxx(vmas.JCBH)) { 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 saveParasiticDataByIni(parasitic 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("SDQJ,"); //=@CLXHBH,");3 strSql.Append("MYSD,"); //=@CLXHBH,");3 strSql.Append("HXSJ,"); //=@JCCS,");4 strSql.Append("JSGL,"); //=@CCRQ,");5 strSql.Append("LJHXSJ,"); //=@DJRQ,"); 6 strSql.Append("BZ,"); //=@FDJH,");7 strSql.Append("BDJG,"); //=@HBBZ,");13 strSql.Append("BDRQ) "); //=@SYQK,");14 strSql.Append("values (@STATIONID,@LINEID,@SDQJ,@MYSD,@HXSJ,@JSGL,@LJHXSJ,@BZ,@BDJG,@BDRQ)"); SqlParameter[] parameters = { new SqlParameter("@STATIONID", SqlDbType.VarChar, 50), new SqlParameter("@LINEID", SqlDbType.VarChar, 50), new SqlParameter("@SDQJ", SqlDbType.VarChar, 50), new SqlParameter("@MYSD", SqlDbType.VarChar, 100), new SqlParameter("@HXSJ", SqlDbType.VarChar, 50), new SqlParameter("@JSGL", SqlDbType.VarChar, 50), new SqlParameter("@LJHXSJ", 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.Sdqj; parameters[i++].Value = model.Mysd; parameters[i++].Value = model.Hxsj; parameters[i++].Value = model.Jsgl; parameters[i++].Value = model.Ljhxsj; 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; } }
public bool saveParasiticData(PARASITIC model) { int i = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [寄生功率试验] ("); strSql.Append("STATIONID,"); //=@PZLX,");1 strSql.Append("LINEID,"); //=@JCCLPH,");2 strSql.Append("SDQJ,"); //=@CLXHBH,");3 strSql.Append("MYSD,"); //=@CLXHBH,");3 strSql.Append("HXSJ,"); //=@JCCS,");4 strSql.Append("JSGL,"); //=@CCRQ,");5 strSql.Append("LJHXSJ,"); //=@DJRQ,"); 6 strSql.Append("BZ,"); //=@FDJH,");7 strSql.Append("BDJG,"); //=@HBBZ,");13 strSql.Append("BDRQ) "); //=@SYQK,");14 strSql.Append("values (@STATIONID,@LINEID,@SDQJ,@MYSD,@HXSJ,@JSGL,@LJHXSJ,@BZ,@BDJG,@BDRQ)"); SqlParameter[] parameters = { new SqlParameter("@STATIONID", SqlDbType.VarChar, 50), new SqlParameter("@LINEID", SqlDbType.VarChar, 50), new SqlParameter("@SDQJ", SqlDbType.VarChar, 50), new SqlParameter("@MYSD", SqlDbType.VarChar, 100), new SqlParameter("@HXSJ", SqlDbType.VarChar, 50), new SqlParameter("@JSGL", SqlDbType.VarChar, 50), new SqlParameter("@LJHXSJ", 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.SDQJ; parameters[i++].Value = model.MYSD; parameters[i++].Value = model.HXSJ; parameters[i++].Value = model.JSGL; parameters[i++].Value = model.LJHXSJ; 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 bool saveSmokeDataByIni(Smokemeterdata 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("KBZ,"); //=@CLXHBH,");3 strSql.Append("KSCZ,"); //=@CLXHBH,");3 strSql.Append("KABSWC,"); //=@JCCS,");4 strSql.Append("KRELWC,"); //=@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,@KBZ,@KSCZ,@KABSWC,@KRELWC,@BDJG,@BZSM,@CZY,@BDRQ)"); SqlParameter[] parameters = { new SqlParameter("@STATIONID", SqlDbType.VarChar, 50), new SqlParameter("@LINEID", SqlDbType.VarChar, 50), new SqlParameter("@KBZ", SqlDbType.VarChar, 50), new SqlParameter("@KSCZ", SqlDbType.VarChar, 50), new SqlParameter("@KABSWC", SqlDbType.VarChar, 50), new SqlParameter("@KRELWC", 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.Kbz.ToString("0.00"); parameters[i++].Value = model.Kscz.ToString("0.00"); parameters[i++].Value = model.Kabswc.ToString("0.00"); parameters[i++].Value = model.Krelwc.ToString("0.000"); 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; } }
public bool saveBzGlideDataByIni(bzglide 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("CCDT,"); //=@CLXHBH,");3 strSql.Append("ACDT,"); //=@JCCS,");4 strSql.Append("WC,"); //=@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,@HXQJ,@CCDT,@ACDT,@WC,@BDJG,@BZSM,@CZY,@BDRQ)"); SqlParameter[] parameters = { new SqlParameter("@STATIONID", SqlDbType.VarChar, 50), new SqlParameter("@LINEID", SqlDbType.VarChar, 50), new SqlParameter("@HXQJ", SqlDbType.VarChar, 50), new SqlParameter("@CCDT", SqlDbType.VarChar, 50), new SqlParameter("@ACDT", SqlDbType.VarChar, 50), new SqlParameter("@WC", 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.Hxqj; parameters[i++].Value = model.Ccdt; parameters[i++].Value = model.Acdt; parameters[i++].Value = model.Wc; 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> /// 用JZJS插入逐秒数据 /// </summary> /// <param name="JZJS">JZJS</param> /// <returns>int 0为失败,1为插入成功,2为更新成功</returns> public int Save_ZYJSseconds(ZYJSseconds jzjs) { string sqli = "insert into ZYJS_DATASECONDS(JYLSH,JYCS,CYDS,CLID,CLHP,JCSJ,MMTIME,MMSX,MMLB,MMZS,MMYW,MMK) values(@JYLSH,@JYCS,@CYDS,@CLID,@CLHP,@JCSJ,@MMTIME,@MMSX,@MMLB,@MMZS,@MMYW,@MMK)"; string sqlu = "update ZYJS_DATASECONDS set JYLSH=@JYLSH,JYCS=@JYCS,CYDS=@CYDS,CLHP=@CLHP,JCSJ=@JCSJ,MMTIME=@MMTIME,MMSX=@MMSX,MMLB=@MMLB,MMZS=@MMZS,MMYW=@MMYW,MMK=@MMK where CLID=@CLID"; SqlParameter[] spr = { new SqlParameter("@JYLSH", jzjs.JYLSH), new SqlParameter("@JYCS", jzjs.JYCS), new SqlParameter("@CYDS", jzjs.CYDS), new SqlParameter("@CLID", jzjs.CLID), //1 new SqlParameter("@CLHP", jzjs.CLHP), new SqlParameter("@JCSJ", jzjs.JCSJ), new SqlParameter("@MMTIME", jzjs.MMTIME), new SqlParameter("@MMSX", jzjs.MMSX), new SqlParameter("@MMLB", jzjs.MMLB), //6 new SqlParameter("@MMZS", jzjs.MMZS), new SqlParameter("@MMYW", jzjs.MMYW), new SqlParameter("@MMK", jzjs.MMK) //47 }; try { if (Have_Zyjsseconds(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; return(0); } }
/// <summary> /// 删除所有消息数据 /// </summary> /// <returns>bool</returns> public bool DeleteAll() { string sql = "delete * from xxxxb"; if (DBHelperSQL.Execute(sql) > 0) { return(true); } else { return(false); } }
public bool Update(SYS.Model.YGB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ygb set "); strSql.Append("YGBH=@YGBH,"); //=@PZLX,"); strSql.Append("YGXM=@YGXM,"); //=@JCCLPH,"); strSql.Append("DHHM=@DHHM,"); //=@CLXHBH,"); strSql.Append("YGZWBH=@YGZWBH,"); //=@JCCS,"); strSql.Append("YGSFZ=@YGSFZ,"); //=@CCRQ,"); strSql.Append("YGZT=@YGZT,"); //=@DJRQ,"); strSql.Append("User_Name=@User_Name,"); //=@FDJH,"); strSql.Append("Password=@Password "); //=@CJH,"); strSql.Append("where ygbh=@YGBH or User_Name=@User_Name"); SqlParameter[] parameters = { new SqlParameter("@YGBH", SqlDbType.VarChar, 32), new SqlParameter("@YGXM", SqlDbType.VarChar, 32), new SqlParameter("@DHHM", SqlDbType.VarChar, 32), new SqlParameter("@YGZWBH", SqlDbType.Int, 4), new SqlParameter("@YGSFZ", SqlDbType.VarChar, 32), new SqlParameter("@YGZT", SqlDbType.VarChar, 32), new SqlParameter("@User_Name", SqlDbType.VarChar, 32), new SqlParameter("@Password", SqlDbType.VarChar, 32) }; parameters[0].Value = model.YGBH; parameters[1].Value = model.YGXM; parameters[2].Value = model.DHHM; parameters[3].Value = model.YGZWBH; parameters[4].Value = model.YGSFZ; parameters[5].Value = model.YGZT; parameters[6].Value = model.User_Name; parameters[7].Value = model.Password; try { int rows = DBHelperSQL.Execute(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }