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