public ASMseconds Get_ASMDataSeconds(string clhp, DateTime jcsj) { DateTime a; string sql = "select * from ASM_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 { ASMseconds asm = new ASMseconds(); 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.MMWD = dt.Rows[0]["MMWD"].ToString();//11 asm.MMSD = dt.Rows[0]["MMSD"].ToString(); asm.MMDQY = dt.Rows[0]["MMDQY"].ToString(); asm.MMCS = dt.Rows[0]["MMCS"].ToString(); asm.MMGL = dt.Rows[0]["MMGL"].ToString();//6 asm.MMZS = dt.Rows[0]["MMZS"].ToString(); asm.MMXSXZ = dt.Rows[0]["MMXSXZ"].ToString(); asm.MMSDXZ = dt.Rows[0]["MMSDXZ"].ToString(); asm.MMYW = dt.Rows[0]["MMYW"].ToString(); asm.MMJSGL = dt.Rows[0]["MMJSGL"].ToString();//11 } else { asm.CLID = "-2"; } return(asm); } catch (Exception) { throw; } }
/// <summary> /// 用检测编号和次数查询一条检测数据 /// </summary> /// <param name="jcbh">检测编号</param> /// <param name="jccs">检测次数</param> /// <returns>ASM检测数据Model</returns> public ASMseconds Get_ASMDataSeconds(string CLID) { DateTime a; string sql = "select * from ASM_DATASECONDS where CLID=@CLID"; SqlParameter[] spr = { new SqlParameter("@CLID", CLID) }; try { ASMseconds asm = new ASMseconds(); 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.MMWD = dt.Rows[0]["MMWD"].ToString();//11 asm.MMSD = dt.Rows[0]["MMSD"].ToString(); asm.MMDQY = dt.Rows[0]["MMDQY"].ToString(); asm.MMCS = dt.Rows[0]["MMCS"].ToString(); asm.MMGL = dt.Rows[0]["MMGL"].ToString();//6 asm.MMZS = dt.Rows[0]["MMZS"].ToString(); asm.MMXSXZ = dt.Rows[0]["MMXSXZ"].ToString(); asm.MMSDXZ = dt.Rows[0]["MMSDXZ"].ToString(); asm.MMYW = dt.Rows[0]["MMYW"].ToString(); asm.MMJSGL = dt.Rows[0]["MMJSGL"].ToString();//11 } 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_ASMSseconds(ASMseconds asm) { string sqli = "insert into ASM_DATASECONDS(JYLSH,JYCS,CYDS,MMZSGL,CLID,CLHP,JCSJ,MMTIME,MMSX,MMLB,MMZT,MMHC,MMCO,MMO2,MMCO2,MMNO,MMWD,MMSD,MMDQY,MMCS,MMGL,MMZS,MMXSXZ,MMSDXZ,MMGLYL,MMYW,MMNL,MMJSGL) values(@JYLSH,@JYCS,@CYDS,@MMZSGL,@CLID,@CLHP,@JCSJ,@MMTIME,@MMSX,@MMLB,@MMZT,@MMHC,@MMCO,@MMO2,@MMCO2,@MMNO,@MMWD,@MMSD,@MMDQY,@MMCS,@MMGL,@MMZS,@MMXSXZ,@MMSDXZ,@MMGLYL,@MMYW,@MMNL,@MMJSGL)"; string sqlu = "update ASM_DATASECONDS set JYLSH=@JYLSH,JYCS=@JYCS,CYDS=@CYDS,MMZSGL=@MMZSGL,CLHP=@CLHP,JCSJ=@JCSJ,MMTIME=@MMTIME,MMSX=@MMSX,MMLB=@MMLB,MMZT=@MMZT,MMHC=@MMHC,MMCO=@MMCO,MMO2=@MMO2,MMCO2=@MMCO2,MMNO=@MMNO,MMWD=@MMWD,MMSD=@MMSD,MMDQY=@MMDQY,MMCS=@MMCS,MMGL=@MMGL,MMZS=@MMZS,MMXSXZ=@MMXSXZ,MMSDXZ=@MMSDXZ,MMGLYL=@MMGLYL,MMYW=@MMYW,MMNL=@MMNL,MMJSGL=@MMJSGL where CLID=@CLID"; SqlParameter[] spr = { new SqlParameter("@JYLSH", asm.JYLSH), new SqlParameter("@JYCS", asm.JYCS), new SqlParameter("@CYDS", asm.CYDS), new SqlParameter("@MMZSGL", asm.MMZSGL), 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("@MMZT", asm.MMZT), //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("@MMWD", asm.MMWD), new SqlParameter("@MMSD", asm.MMSD), new SqlParameter("@MMDQY", asm.MMDQY), new SqlParameter("@MMCS", asm.MMCS), new SqlParameter("@MMGL", asm.MMGL), new SqlParameter("@MMZS", asm.MMZS), //6 new SqlParameter("@MMXSXZ", asm.MMXSXZ), new SqlParameter("@MMSDXZ", asm.MMSDXZ), //6 new SqlParameter("@MMGLYL", asm.MMGLYL), new SqlParameter("@MMYW", asm.MMYW), new SqlParameter("@MMNL", asm.MMNL), new SqlParameter("@MMJSGL", asm.MMJSGL) //47 }; try { if (Have_ASMseconds(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); } }