/// <summary> /// 是否存在指定条件的记录 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsWhere(string where) { if (!string.IsNullOrEmpty(where)) { string w = where.Trim().ToLower(); if (!w.StartsWith("where ")) { w = "where " + w; } return(sqlHelper.Exists("select 1 from TF_PersonalTrain " + w)); } return(false); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TF_FormType where TypeName='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TF_Attachment where Name='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TaskInfo where Name='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TF_StaffCondition where 状态='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TF_Property where 名称='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TF_FollowupType where 方式='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TF_Member where 姓名='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from FlowTemplate where Name='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TF_CardType where 卡种='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TF_FieldMap where Name='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TF_Alert where 提醒项目='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TF_Permission where Name='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name) { return(sqlHelper.Exists("select 1 from TF_ProductType where 类型='" + name + "'")); }
/// <summary> /// 是否存在同名 /// </summary> /// <param name="name"></param> /// <returns></returns> public bool ExistsName(string name, string mobile) { return(sqlHelper.Exists("select 1 from TF_MemberMoney where 会员姓名='" + name + "' and 会员电话='" + mobile + "'")); }