/// <summary>
/// 是否存在该角色
/// </summary>
public bool RoleExists(string Description)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Accounts_Roles");
strSql.Append(" where Description=?Description");
MySqlParameter[] parameters =
{
new MySqlParameter("?Description", MySqlDbType.VarChar, 50)
};
parameters[0].Value = Description;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(long id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from pgroup");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.bigint, 20)
};
parameters[0].Value = id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int user_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from ecs_users");
strSql.Append(" where user_id=@user_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@user_id", MySqlDbType.Int32)
};
parameters[0].Value = user_id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int newc_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from t_newscategory");
strSql.Append(" where newc_ID=@newc_ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@newc_ID", MySqlDbType.Int32)
};
parameters[0].Value = newc_ID;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int componentId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from component");
strSql.Append(" where componentId=@componentId ");
MySqlParameter[] parameters =
{
new MySqlParameter("@componentId", MySqlDbType.Int32, 11)
};
parameters[0].Value = componentId;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int iAutoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from t_index_banner");
strSql.Append(" where iAutoID=@iAutoID");
MySqlParameter[] parameters =
{
new MySqlParameter("@iAutoID", MySqlDbType.Int32)
};
parameters[0].Value = iAutoID;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int SysNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from T_Customer");
strSql.Append(" where SysNo=@SysNo");
MySqlParameter[] parameters =
{
new MySqlParameter("@SysNo", MySqlDbType.Int32)
};
parameters[0].Value = SysNo;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from verificationcode");
strSql.Append(" where id=?id ");
MySqlParameter[] parameters =
{
new MySqlParameter("?id", MySqlDbType.Int32, 11)
};
parameters[0].Value = id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string college_num)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from t_college");
strSql.Append(" where college_num=@college_num ");
MySqlParameter[] parameters =
{
new MySqlParameter("@college_num", MySqlDbType.VarChar, 50)
};
parameters[0].Value = college_num;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string Exp_NoOri)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from cjplpback");
strSql.Append(" where Exp_NoOri=@Exp_NoOri ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Exp_NoOri", MySqlDbType.VarChar, 255)
};
parameters[0].Value = Exp_NoOri;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string brandcode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from base_carbrandinfo");
strSql.Append(" where brandcode=?brandcode ");
MySqlParameter[] parameters =
{
new MySqlParameter("?brandcode", MySqlDbType.VarChar, 10)
};
parameters[0].Value = brandcode;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from crm_contact_bill_check");
strSql.Append(" where id=@id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
parameters[0].Value = id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int PersonID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from checkperson");
strSql.Append(" where PersonID=@PersonID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@PersonID", MySqlDbType.Int32, 11)
};
parameters[0].Value = PersonID;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool ExistsLink(int customerid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from CRM_Contact");
strSql.Append(" where C_customerid=@customerid and IsDefaultContact=1 and isDelete=0 ");
MySqlParameter[] parameters =
{
new MySqlParameter("@customerid", MySqlDbType.Int32, 4)
};
parameters[0].Value = customerid;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(double User_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from user");
strSql.Append(" where User_id=@User_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@User_id", MySqlDbType.Double, 15)
};
parameters[0].Value = User_id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string Exp_No)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from ps_wwtp");
strSql.Append(" where Exp_No=@Exp_No ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Exp_No", MySqlDbType.VarChar, 100)
};
parameters[0].Value = Exp_No;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string Factory_Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from scm_authority_supply");
strSql.Append(" where Factory_Id=@Factory_Id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Factory_Id", MySqlDbType.VarChar, 60)
};
parameters[0].Value = Factory_Id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Sys_FactoryInfo");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32, 4)
};
parameters[0].Value = ID;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int sl_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from t_systemleave");
strSql.Append(" where sl_id=@sl_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@sl_id", MySqlDbType.Int32)
};
parameters[0].Value = sl_id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(long Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from ticketinfo");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int64)
};
parameters[0].Value = Id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from blogcommentphoto");
strSql.Append(" where Id=@Id");
MySqlParameter[] parameters =
{
new MySqlParameter("@Id", MySqlDbType.Int32)
};
parameters[0].Value = Id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string snowid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from syn_file_info");
strSql.Append(" where snowid=@snowid ");
MySqlParameter[] parameters =
{
new MySqlParameter("@snowid", MySqlDbType.VarChar, 20)
};
parameters[0].Value = snowid;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int OrderDetailId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from orderdetail");
strSql.Append(" where OrderDetailId=@OrderDetailId ");
MySqlParameter[] parameters =
{
new MySqlParameter("@OrderDetailId", MySqlDbType.Int32, 11)
};
parameters[0].Value = OrderDetailId;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int MileageID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from vehihiclemileage");
strSql.Append(" where MileageID=@MileageID");
MySqlParameter[] parameters =
{
new MySqlParameter("@MileageID", MySqlDbType.Int32)
};
parameters[0].Value = MileageID;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int Menu_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from sys_menu");
strSql.Append(" where Menu_id=@Menu_id ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Menu_id", MySqlDbType.Int32, 4)
};
parameters[0].Value = Menu_id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string GUN_INFO_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from gun_info");
strSql.Append(" where GUN_INFO_ID=@GUN_INFO_ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@GUN_INFO_ID", MySqlDbType.VarChar, 255)
};
parameters[0].Value = GUN_INFO_ID;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(long ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from tb_warnlog");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32, 20)
};
parameters[0].Value = ID;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from server_contents_message");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from dms_set_exclude");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string sequence_name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from sys_sequence");
strSql.Append(" where sequence_name=@sequence_name ");
MySqlParameter[] parameters =
{
new MySqlParameter("@sequence_name", MySqlDbType.VarChar, 200)
};
parameters[0].Value = sequence_name;
return(DbHelperMySQL.Exists(strSql.ToString(), parameters));
}
