/// <summary> /// 物料是否被使用 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool isInUse(string id, string userid) { try { string sql = ""; sql = " select count(*) from T_OPERATE_STOCKS where C_MATERIEL_ID = @id "; Hashtable table = new Hashtable(); table.Add("id", id); DbParameter[] parms = dbHelper.getParams(table); object obj = dbHelper.GetScalar(sql, parms); int count1 = Convert.IsDBNull(obj) ? 0 : Convert.ToInt32(obj); sql = " select count(*) from T_Runing_Dolist where C_MATERIEL = @id "; Hashtable table2 = new Hashtable(); table2.Add("id", id); DbParameter[] parms2 = dbHelper.getParams(table2); object obj2 = dbHelper.GetScalar(sql, parms2); int count2 = Convert.IsDBNull(obj2) ? 0 : Convert.ToInt32(obj2); sql = " select count(*) from T_OPERATE_INOUT_SUB where C_MATERIEL = @id "; Hashtable table4 = new Hashtable(); table4.Add("id", id); DbParameter[] parms4 = dbHelper.getParams(table4); object obj4 = dbHelper.GetScalar(sql, parms4); int count4 = Convert.IsDBNull(obj2) ? 0 : Convert.ToInt32(obj4); //物料权限 //sql = " select count(*) from T_JB_MATERIEL_USER where C_MATERIEL = @id and C_JIAOSE <> @userid "; //Hashtable table5 = new Hashtable(); //table5.Add("id", id); //table5.Add("userid", userid); //DbParameter[] parms5 = dbHelper.getParams(table5); //object obj5 = dbHelper.GetScalar(sql, parms5); //int count5 = Convert.IsDBNull(obj2) ? 0 : Convert.ToInt32(obj5); if (count1 > 0 || count2 > 0 || count4 > 0) { return(true); } else { return(false); } } catch (Exception ex) { Log.write(ex.Message + "\r\n" + ex.StackTrace); throw ex; } finally { dbHelper.getConnection().Close(); } }