/// <summary> /// 用检测编号和次数查询一条检测数据 /// </summary> /// <param name="jcbh">检测编号</param> /// <param name="jccs">检测次数</param> /// <returns>ASM检测数据Model</returns> public SDS_JCXXB Get_SDS_jcxx(string jcbh) { string sql = "select * from sds_jcxxb where jcbh=@jcbh"; SqlParameter[] spr = { new SqlParameter("@jcbh", jcbh) }; try { SDS_JCXXB vmas = new SDS_JCXXB(); DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr); if (dt.Rows.Count > 0) { vmas.JCBH = dt.Rows[0]["JCBH"].ToString();//1 vmas.JCZMC = dt.Rows[0]["JCZMC"].ToString(); vmas.JCRQ = dt.Rows[0]["JCRQ"].ToString(); vmas.JCCZY = dt.Rows[0]["JCCZY"].ToString();//6 vmas.JCJSY = dt.Rows[0]["JCJSY"].ToString(); vmas.SBRZBH = dt.Rows[0]["SBRZBH"].ToString(); vmas.SBMC = dt.Rows[0]["SBMC"].ToString(); vmas.SBXH = dt.Rows[0]["SBXH"].ToString(); vmas.SBZZC = dt.Rows[0]["SBZZC"].ToString(); } else { vmas.JCBH = jcbh; } return(vmas); } catch (Exception) { throw; } }
/// <summary> /// 用ASM对象插入或更新条检测数据 /// </summary> /// <param name="asm">ASM</param> /// <returns>int 0为失败,1为插入成功,2为更新成功</returns> public int Save_SDS_jcxx(SDS_JCXXB vmas) { string sqli = "insert into sds_jcxxb(JCBH,JCZMC,JCRQ,JCCZY,JCJSY,SBRZBH,SBMC,SBXH,SBZZC) values(@JCBH,@JCZMC,@JCRQ,@JCCZY,@JCJSY,@SBRZBH,@SBMC,@SBXH,@SBZZC)"; string sqlu = "update sds_jcxxb set JCZMC=@JCZMC,JCRQ=@JCRQ,JCCZY=@JCCZY,JCJSY=@JCJSY,SBRZBH=@SBRZBH,SBMC=@SBMC,SBXH=@SBXH,SBZZC=@SBZZC"; SqlParameter[] spr = { new SqlParameter("@JCBH", vmas.JCBH), //1 new SqlParameter("@JCZMC", vmas.JCZMC), new SqlParameter("@JCRQ", vmas.JCRQ), new SqlParameter("@JCCZY", vmas.JCCZY), //6 new SqlParameter("@JCJSY", vmas.JCJSY), new SqlParameter("@SBRZBH", vmas.SBRZBH), new SqlParameter("@SBMC", vmas.SBMC), new SqlParameter("@SBXH", vmas.SBXH), new SqlParameter("@SBZZC", vmas.SBZZC) }; try { if (Have_SDS_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; } }