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