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