/// <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;
}
}
