public static int GetRecordCount(string search = "") { string strSql = "select count(*) from ServiceConfiguration where ServerName like '%" + search + "%' "; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
/// <summary> /// 服务名称是否存在 /// </summary> /// <param name="UserName"></param> /// <returns></returns> public static bool Exists(string ServerName) { string strSql = "select count(*) from ServiceConfiguration where ServerName='" + ServerName + "'"; return(DBHelperSQL.GetResult(strSql, connectionString).ToString().Trim() == "1" ? true : false); }
public static int GetRecordCount(string UserName = "") { string strSql = "select count(*) from ErrorRTKRecord where UserName like '%" + UserName + "%'"; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
/// <summary> /// 用户是否存在 /// </summary> /// <param name="UserName"></param> /// <returns></returns> public static bool Exists(string OrderNumber) { string strSql = "select count(*) from InvoiceList where OrderNumber='" + OrderNumber + "'"; return(DBHelperSQL.GetResult(strSql, connectionString).ToString().Trim() == "1" ? true : false); }
public static int GetRecordCount(string NetName = "") { string strSql = "select count(*) from StationNetInfo where NetName like '%" + NetName + "%'"; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
public static bool Exists(int ID) { string strSql = "select count(*) from WorkingArea where ID=" + ID.ToString(); return(DBHelperSQL.GetResult(strSql, connectionString).ToString().Trim() == "1" ? true : false); }
public static int GetRecordCount(string where = "1=1") { string strSql = "select count(*) from InternetInfoEquip where " + where; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
//单位管理员 public static int GetRecordCount(string Company, bool i, string search = "") { string strSql = "select count(*) from RTKSurveyRec where Company='" + Company + "' and " + search; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
public static int GetRecordCountNew(string search = "", string strwhere = "1=1") { string strSql = "select count(*) from UserMessage where Content like '%" + search + "%' and " + strwhere; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
/// <summary> /// 判断收件人是否存在 /// </summary> /// <param name="ToUser"></param> /// <returns></returns> public bool Exists(string ToUser) { string strlSql = "select count(*) from UserMeassage where ToUser='******' "; return(DBHelperSQL.GetResult(strlSql).ToString().Trim() != "0" ? true : false); }
/// <summary> /// 是否存在该记录 /// </summary> /// <param name="ID"></param> /// <returns></returns> public bool Exists(int ID) { string strSql = "select count(*) from UserMeassage where ID=" + ID.ToString(); return(DBHelperSQL.GetResult(strSql).ToString().Trim() == "1" ? true : false); }
public static int UnreadCount(string ToUser) { string strSql = "select count(*) from UserMessage where ToUser = '******' and IsRead=0"; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
public static int GetRecordCount(string ToUser, string Content = "") { string strSql = "select count(*) from UserMessage where ToUser = '******' and Content like '%" + Content + "%'"; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
public static int GetRecordCount() { string strSql = "select count(*) from RTKSurveyRec"; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
/// <summary> /// 设备名 /// </summary> /// <param name="UserName"></param> /// <returns></returns> public static bool Exists(string MachineName) { string strSql = "select count(*) from InternetInfoEquip where MachineName='" + MachineName + "'"; return(DBHelperSQL.GetResult(strSql, connectionString).ToString().Trim() == "1" ? true : false); }
//cors用户 public static int GetRecordCount(string UserName, int i, string search = "") { string strSql = "select count(*) from RTKSurveyRec where UserName='******' and " + search; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
/// <summary> /// 用户是否存在 /// </summary> /// <param name="UserName"></param> /// <returns></returns> public static bool Exists(string UserName) { string strSql = "select count(*) from RTKUserPurview where UserName='******'"; return(DBHelperSQL.GetResult(strSql, connectionString).ToString().Trim() == "1" ? true : false); }
public static bool Exists(string MDZBXM) { string strSql = "select count(*) from GDCoorSysXYZ where MDZBXM='" + MDZBXM + "'"; return(DBHelperSQL.GetResult(strSql, connectionString).ToString().Trim() == "1" ? true : false); }
public static int Getcount1() { string strSql = "select count(*) from InvoiceList where Status=3"; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
/// <summary> /// 站网名称 /// </summary> /// <param name="UserName"></param> /// <returns></returns> public static bool Exists(string NetName) { string strSql = "select count(*) from StationNetInfo where NetName='" + NetName + "'"; return(DBHelperSQL.GetResult(strSql, connectionString).ToString().Trim() == "1" ? true : false); }
public static int GetRecordCount(string search = "", string strwhere = "1=1") { string strSql = "select count(*) from InvoiceList where OrderNumber like '%" + search + "%' and " + strwhere; return(Convert.ToInt32(DBHelperSQL.GetResult(strSql, connectionString))); }
/// <summary> /// 是否存在该记录 /// </summary> public static bool Exists(string AreaName) { string strSql = "select count(*) from WorkingArea where AreaName='" + AreaName.ToString() + "'"; return(DBHelperSQL.GetResult(strSql, connectionString).ToString().Trim() == "1" ? true : false); }
public static bool Exists(string Source) { string strSql = "select count(*) from SourceTable where Source='" + Source + "'"; return(DBHelperSQL.GetResult(strSql, connectionString).ToString().Trim() == "1" ? true : false); }