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