/// <summary> /// 验证名称是否存在 /// </summary> /// <param name="id">ID</param> /// <param name="name">名称</param> /// <param name="mobileType">手机类型</param> /// <returns></returns> public bool NameExists(string name, int id, int mobileType) { if (string.IsNullOrEmpty(name)) { return(true); } var args = new List <object> { new { Name = name, Id = id, MobileType = mobileType } }; var sbWhere = new StringBuilder("SELECT COUNT(*) FROM VersionManagement "); sbWhere.AppendFormat(" Where RowStatus = 1 "); sbWhere.AppendFormat(" and Name = @Name "); sbWhere.AppendFormat(" and MobileType = @MobileType "); if (id > 0) { sbWhere.Append(" and Id <> @Id "); } WriteDatabase.Comment = new StringExtension.SqlComment { Author = "", FileName = "ComVersionManagementDal.cs", ForUse = "查询", FunName = "NameExists" }; return(WriteDatabase.ExecuteScalar <int>(sbWhere.ToString(), args.ToArray()) > 0); }
/// <summary> /// 验证帐号ID是否存在 /// </summary> /// <param name="id">ID</param> /// <param name="accountId">帐号ID</param> /// <returns></returns> public bool AccountIdExists(string accountId, int id) { if (string.IsNullOrEmpty(accountId)) { return(true); } var args = new List <object> { new { p1 = accountId, p2 = id } }; var sbWhere = new StringBuilder("SELECT COUNT(*) FROM ComApiAccount "); sbWhere.Append(Database.GetFormatSql <ComApiAccountEntity>("Where {0}=1 ", t => t.ROWSTATUS)); sbWhere.Append(Database.GetFormatSql <ComApiAccountEntity>(" and {0} = @p1 ", t => t.ACCOUNTID)); if (id > 0) { sbWhere.Append(Database.GetFormatSql <ComApiAccountEntity>(" and {0} <> @p2 ", t => t.ID)); } WriteDatabase.Comment = new StringExtension.SqlComment { Author = "", FileName = "ComApiAccountDal.cs", ForUse = "验证帐号ID是否存在", FunName = "AccountIdExists" }; return(WriteDatabase.ExecuteScalar <int>(sbWhere.ToString(), args.ToArray()) > 0); }
/// <summary> /// 验证文件版本号 /// </summary> /// <param name="fileVersionNo">验证的文件版本号</param> /// <param name="mobileType">手机类型</param> /// <returns></returns> public bool FileVersionExists(string fileVersionNo, int mobileType) { var args = new List <object> { new { FileVersion = fileVersionNo, MobileType = mobileType } }; var sbWhere = new StringBuilder("SELECT COUNT(*) FROM ComVersionManagement "); sbWhere.AppendFormat(" Where RowStatus=1 "); sbWhere.AppendFormat(" and FileVersion = @FileVersion "); sbWhere.AppendFormat(" and MobileType = @MobileType "); WriteDatabase.Comment = new StringExtension.SqlComment { Author = "", FileName = "ComVersionManagementDal.cs", ForUse = "验证文件版本号", FunName = "FileVersionExists" }; return(WriteDatabase.ExecuteScalar <int>(sbWhere.ToString(), args.ToArray()) > 0); }