/// <summary>
/// 查看记录是否存在
/// </summary>
/// <param name="KeyNames">字段名数组</param>
/// <param name="objects">字段值数组</param>
/// <returns>bool</returns>
public static bool Exists(string[] KeyNames, params object[] objects)
{
System.Collections.ArrayList SqlWhere = new System.Collections.ArrayList();
for (int i = 0; i < KeyNames.Length; i++)
{
SqlWhere.Add(string.Format(" {0}=@{0} ", KeyNames[i]));
}
string where = SqlWhere.JArrayListToString(" and ", true);
return(Exists(where, SQL.GetSQLParameter <EntityObject>(where, objects, typeof(EntityObject)).Re_SqlParameter()));
}
/// <summary>
/// 查看记录是否存在
/// </summary>
/// <param name="KeyNames">字段名数组</param>
/// <param name="_SqlDbTypes">字段类型数组</param>
/// <param name="Values">字段值数组</param>
/// <returns>bool</returns>
public static bool Exists(string[] KeyNames, System.Data.SqlDbType[] _SqlDbTypes, object[] Values)
{
System.Collections.ArrayList SqlWhere = new System.Collections.ArrayList();
Common.Net.CreateParameter _C = new Common.Net.CreateParameter();
for (int i = 0; i < KeyNames.Length; i++)
{
_C.CanShu.Add("@" + KeyNames[i], _SqlDbTypes[i], Values[i]);
SqlWhere.Add(string.Format(" {0}=@{0} ", KeyNames[i]));
}
return(Exists(SqlWhere.JArrayListToString(" and ", true), _C.Re_SqlParameter()));
}
