public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
int PageSize = Convert.ToInt32(context.Request.Params["pagesize"]);
int currentpage = Convert.ToInt32(context.Request.Params["page"]);
string sWhere = "";
WhereFilter QF = null;
//条件
if (context.Request.Params["where"] != null)
{
QF = new JavaScriptSerializer().Deserialize <WhereFilter>(context.Request.Params["where"]);
//sWhere = QF.GetWhere();
}
//排序
if (context.Request.Params["sortorder"] != null)
{
string sortname = context.Request.Params["sortname"];
string sortorder = context.Request.Params["sortorder"];
sWhere += " order by " + sortname + " " + sortorder;
}
M_Data_Paging <M_CustomerInfo> lstMCusPage = SQLDBHelper.CreateDBClass <M_CustomerInfo_DB>().Query(QF, (currentpage - 1) * PageSize, currentpage * PageSize);
//分页
var griddata = new { Rows = lstMCusPage.lstTObj, Total = lstMCusPage.RowCount };
string str = new JavaScriptSerializer().Serialize(griddata);
context.Response.Write(str);
}
catch (Exception ex)
{
}
}
public static TerminalTypes GetOneTerminalTypes(int id)
{
TerminalTypes termType = new TerminalTypes();
string sql = "select * from TerminalTypes where ID=" + id.ToString();
DataTable dt = null;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
dt = sqlHelper.Query(sql);
}
catch (Exception e)
{
throw e;
}
if (dt != null && dt.Rows.Count > 0)
{
termType.ID = Convert.ToInt32(dt.Rows[0]["ID"]);
termType.Name = dt.Rows[0]["Name"].ToString();
termType.Price = Convert.ToDecimal(dt.Rows[0]["Price"]);
if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
{
termType.Remark = dt.Rows[0]["Remark"].ToString();
}
else
{
termType.Remark = string.Empty;
}
}
return(termType);
}
private void button1_Click(object sender, EventArgs e)
{//解锁
string username = textBox1.Text.Trim();
string pwd = textBox2.Text;
SQLDBHelper sqlHelper = new SQLDBHelper();
object o = sqlHelper.GetSingle("select pwd from Managers where username='******'");
if (o != null && o != DBNull.Value)
{
if (o.ToString() == pwd)
{
UnlockSystem();
}
else
{
MessageBox.Show("密码错误！");
textBox2.SelectAll();
textBox2.Focus();
}
}
else
{
MessageBox.Show("该账号不存在！");
textBox1.SelectAll();
textBox1.Focus();
}
}
public int UpdateUser(sys_User request)
{
using (IDbConnection sqlConn = SQLDBHelper.CreateConnection())
{
return(sqlConn.Update(request));
}
}
/// <summary>
/// 使用存储过程分页返回记录对象集
/// </summary>
/// <param name="DataTbleName">输出表名称</param>
/// <param name="ReturnFields">返回的字段，多个时，有逗号隔开</param>
/// <param name="Where">条件语句，可以为空，表示不使用条件</param>
/// <param name="pageIndex">当前页</param>
/// <param name="Sort">排序字段，可以为空,使用默认</param>
/// <param name="pageSize">每页的行数</param>
/// <param name="AllRecords">满足条件的记录数</param>
/// <returns></returns>
public static IList <EtProjectInfo> GetPageProjectInfos(string DataTbleName, string ReturnFields, string SqlWhere, int pageIndex, string Sort, int pageSize, out Int32 AllRecords)
{
SqlParameter[] SqlParam = new SqlParameter[]
{
new SqlParameter("@TableName", SqlDbType.NVarChar, 1000),
new SqlParameter("@PrimaryKey", SqlDbType.NVarChar, 200),
new SqlParameter("@ReturnFields", SqlDbType.NVarChar, 3000),
new SqlParameter("@Where", SqlDbType.NVarChar, 3000),
new SqlParameter("@PageIndex", SqlDbType.Int, 4),
new SqlParameter("@PageSize", SqlDbType.Int, 4),
new SqlParameter("@Sort", SqlDbType.NVarChar, 200)
};
SqlParam[0].Value = "ProjectInfo";
SqlParam[1].Value = "EDSID";
SqlParam[2].Value = ReturnFields;
SqlParam[3].Value = SqlWhere;
SqlParam[4].Value = pageIndex;
SqlParam[5].Value = pageSize;
SqlParam[6].Value = Sort;
DataSet ds = SQLDBHelper.RunProceGetDataSet("usp_GetPageData", SqlParam, DataTbleName);
if (ds != null && ds.Tables.Count > 0)
{
AllRecords = Convert.ToInt32(ds.Tables[1].Rows[0]["RecordCount"]);
return(GetProjectInfosByDataTable(ds.Tables[DataTbleName]));
}
AllRecords = 0;
return(null);
}
public static List <Managers> GetMoreManagers(string where = "(1=1)")
{
List <Managers> managers = new List <Managers>();
string sql = "select * from Managers where " + where;
DataTable dt = null;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
dt = sqlHelper.Query(sql);
}
catch (Exception e)
{
throw e;
}
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Managers manager = new Managers();
manager.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
manager.username = dt.Rows[i]["username"].ToString();
manager.pwd = dt.Rows[i]["pwd"].ToString();
managers.Add(manager);
}
}
return(managers);
}
public static void ClearAtennalType()
{
string proName = "[dbo].[usp_ClearAtennalType]";
List<SqlParameter> listParas = new List<SqlParameter>();
// listParas.Add(SQLDBHelper.CreateSqlParameter("@Id", id));
SQLDBHelper.RunProcGetAffected(proName, listParas.ToArray());
}
public CheckInTool(VideoSourcePlayer videoSource, DataGridView hasCome, DataGridView unCome)
{
db = new SQLDBHelper();
camera = new CameraTool.CameraTool(videoSource);
FCTool = new FaceCompareTools();
this.DGV_HasCome = hasCome;
this.DGV_UnCome = unCome;
}
/// <summary>
/// 获取站点数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public int GetStationInfo(string sql)
{
DataSet ds = new DataSet();
ds = SQLDBHelper.Query(sql);
if (ds == null || ds.Tables[0].Rows.Count == 0 || ds.Tables[0].Rows == null)
{
return(0);
}
return(1);
}
public static List <Users> GetMoreUsers(string where = "(1=1)")
{
List <Users> users = new List <Users>();
string sql = "select * from Users where " + where;
DataTable dt = null;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
dt = sqlHelper.Query(sql);
}
catch (Exception e)
{
throw e;
}
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Users user = new Users();
user.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
user.Name = dt.Rows[i]["Name"].ToString();
user.Deadline = Convert.ToDateTime(dt.Rows[i]["Deadline"]);
user.ContactTel = dt.Rows[i]["ContactTel"].ToString();
if (dt.Rows[i]["ContactAddress"] != null && dt.Rows[i]["ContactAddress"] != DBNull.Value)
{
user.ContactAddress = dt.Rows[i]["ContactAddress"].ToString();
}
else
{
user.ContactAddress = string.Empty;
}
if (dt.Rows[i]["Contacter"] != null && dt.Rows[i]["Contacter"] != DBNull.Value)
{
user.Contacter = dt.Rows[i]["Contacter"].ToString();
}
else
{
user.Contacter = string.Empty;
}
if (dt.Rows[i]["Remark"] != null && dt.Rows[i]["Remark"] != DBNull.Value)
{
user.Remark = dt.Rows[i]["Remark"].ToString();
}
else
{
user.Remark = string.Empty;
}
users.Add(user);
}
}
return(users);
}
public static bool UpdateTerminals(Terminals term)
{
string sql = "update Terminals set TypeID=" + term.TypeID + ", Name='" + term.Name + "', IP='" + term.IP + "', SIM='" + term.SIM + "', RunStatus=" + term.RunStatus + ", UserID=" + term.UserID + ", Remark='" + term.Remark + "', IsEnable=" + term.IsEnable + " where ID=" + term.ID;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
catch (Exception e)
{
throw e;
}
}
public static bool InsertTerminals(Terminals term)
{
string sql = "insert into Terminals(TypeID, Name, IP, SIM, RunStatus, UserID, Remark, IsEnable) values (" + term.TypeID + ", '" + term.Name + "', '" + term.IP + "', '" + term.SIM + "', " + term.RunStatus + ", " + term.UserID + ", '" + term.Remark + "', " + (term.IsEnable ? "1" : "0") + ")";
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
catch (Exception e)
{
throw e;
}
}
public static bool DeleteTerminalTypes(int id)
{
string sql = "delete from TerminalTypes where ID=" + id;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
catch (Exception e)
{
throw e;
}
}
public Page <sys_User> GetUsersFor(UserRequest request)
{
Dictionary <string, SortOrder> orderKey = new Dictionary <string, SortOrder>();
//if (!string.IsNullOrEmpty(request.OrderField))
// orderKey.Add(request.OrderField, request.SortOrder);
orderKey.Add("ID", SortOrder.Ascending);
List <sys_User> users = new List <sys_User>();
string strSql = @"select * from sys_User where 1=1 ";
using (IDbConnection sqlConn = SQLDBHelper.CreateConnection())
{
return(sqlConn.QueryPaging <sys_User>(strSql, request, orderKey));
}
}
public static bool UpdateUsers(Users user)
{
string sql = "update Users set Name='" + user.Name + "', Deadline='" + user.Deadline.ToString("yyyy-MM-dd HH:mm:ss") + "', Contacter='" + user.Contacter + "', ContactTel='" + user.ContactTel + "', ContactAddress='" + user.ContactAddress + "', Remark='" + user.Remark + "' where ID=" + user.ID;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
catch (Exception e)
{
throw e;
}
}
public static bool UpdateManagers(Managers manager)
{
string sql = "update Managers set username='******', pwd='" + manager.pwd + "' where ID=" + manager.ID;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
catch (Exception e)
{
throw e;
}
}
public static bool InsertManagers(Managers manager)
{
string sql = "insert into Managers(username, pwd) values ('" + manager.username + "', '" + manager.pwd + "')";
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
catch (Exception e)
{
throw e;
}
}
public static bool UpdateTerminalTypes(TerminalTypes termType)
{
string sql = "update TerminalTypes set Name='" + termType.Name + "', Price=" + termType.Price + ", Remark='" + termType.Remark + "' where ID=" + termType.ID;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
catch (Exception e)
{
throw e;
}
}
public static bool InsertUsers(Users user)
{
string sql = "insert into Users(Name, Deadline, Contacter, ContactTel, ContactAddress, Remark) values ('" + user.Name + "', '" + user.Deadline + "', '" + user.Contacter + "', '" + user.ContactTel + "', '" + user.ContactAddress + "', '" + user.Remark + "')";
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
catch (Exception e)
{
throw e;
}
}
public static bool InsertTerminalTypes(TerminalTypes termType)
{
string sql = "insert into TerminalTypes(Name, Price, Remark) values ('" + termType.Name + "', " + termType.Price + ", '" + termType.Remark + "')";
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
catch (Exception e)
{
throw e;
}
}
public static Users GetOneUsers(int id)
{
Users user = new Users();
string sql = "select * from Users where ID=" + id.ToString();
DataTable dt = null;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
dt = sqlHelper.Query(sql);
}
catch (Exception e)
{
throw e;
}
if (dt != null && dt.Rows.Count > 0)
{
user.ID = Convert.ToInt32(dt.Rows[0]["ID"]);
user.Name = dt.Rows[0]["Name"].ToString();
user.Deadline = Convert.ToDateTime(dt.Rows[0]["Deadline"]);
user.ContactTel = dt.Rows[0]["ContactTel"].ToString();
if (dt.Rows[0]["Contacter"] != null && dt.Rows[0]["Contacter"] != DBNull.Value)
{
user.Contacter = dt.Rows[0]["Contacter"].ToString();
}
else
{
user.Contacter = string.Empty;
}
if (dt.Rows[0]["ContactAddress"] != null && dt.Rows[0]["ContactAddress"] != DBNull.Value)
{
user.ContactAddress = dt.Rows[0]["ContactAddress"].ToString();
}
else
{
user.ContactAddress = string.Empty;
}
if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
{
user.Remark = dt.Rows[0]["Remark"].ToString();
}
else
{
user.Remark = string.Empty;
}
}
return(user);
}
public static List <Terminals> GetMoreTerminals(string where = "(1=1)")
{
List <Terminals> terms = new List <Terminals>();
string sql = "select * from Terminals where " + where;
DataTable dt = null;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
dt = sqlHelper.Query(sql);
}
catch (Exception e)
{
throw e;
}
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Terminals term = new Terminals();
term.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
term.Name = dt.Rows[i]["Name"].ToString();
term.IP = dt.Rows[i]["IP"].ToString();
term.TypeID = Convert.ToInt32(dt.Rows[i]["TypeID"]);
term.UserID = Convert.ToInt32(dt.Rows[i]["UserID"]);
term.RunStatus = Convert.ToInt32(dt.Rows[i]["RunStatus"]);
term.IsEnable = Convert.ToBoolean(dt.Rows[i]["IsEnable"]);
if (dt.Rows[i]["SIM"] != null && dt.Rows[i]["SIM"] != DBNull.Value)
{
term.SIM = dt.Rows[i]["SIM"].ToString();
}
else
{
term.SIM = string.Empty;
}
if (dt.Rows[i]["Remark"] != null && dt.Rows[i]["Remark"] != DBNull.Value)
{
term.Remark = dt.Rows[i]["Remark"].ToString();
}
else
{
term.Remark = string.Empty;
}
terms.Add(term);
}
}
return(terms);
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
int PageSize = Convert.ToInt32(context.Request.Params["pagesize"]);
int currentpage = Convert.ToInt32(context.Request.Params["page"]);
string sWhere = "";
WhereFilter QF = null;
//条件
if (context.Request.Params["where"] != null)
{
QF = new JavaScriptSerializer().Deserialize <WhereFilter>(context.Request.Params["where"]);
//sWhere = QF.GetWhere();
}
//排序
if (context.Request.Params["sortorder"] != null)
{
string sortname = context.Request.Params["sortname"];
string sortorder = context.Request.Params["sortorder"];
sWhere += " order by " + sortname + " " + sortorder;
}
//M_User m = new M_User
//{
// UserID = "a",
// UserName = "******",
// UserPwd = "s",
// UserPermission = "1,2",
// UserState = 1,
// Remark = "abc",
//};
//bool i = SQLDBHelper.CreateDBClass<M_User_DB>().Add(m);
M_Data_Paging <M_User> lstMUserPage = SQLDBHelper.CreateDBClass <M_User_DB>().Query(QF, (currentpage - 1) * PageSize, currentpage * PageSize);
//分页
var griddata = new { Rows = lstMUserPage.lstTObj, Total = lstMUserPage.RowCount };
string str = new JavaScriptSerializer().Serialize(griddata);
context.Response.Write(str);
}
catch (Exception ex)
{
}
}
public static Terminals GetOneTerminals(int id)
{
Terminals term = new Terminals();
string sql = "select * from Terminals where ID=" + id.ToString();
DataTable dt = null;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
dt = sqlHelper.Query(sql);
}
catch (Exception e)
{
throw e;
}
if (dt != null && dt.Rows.Count > 0)
{
term.ID = Convert.ToInt32(dt.Rows[0]["ID"]);
term.Name = dt.Rows[0]["Name"].ToString();
term.IP = dt.Rows[0]["IP"].ToString();
term.TypeID = Convert.ToInt32(dt.Rows[0]["TypeID"]);
term.UserID = Convert.ToInt32(dt.Rows[0]["UserID"]);
term.RunStatus = Convert.ToInt32(dt.Rows[0]["RunStatus"]);
term.IsEnable = Convert.ToBoolean(dt.Rows[0]["IsEnable"]);
if (dt.Rows[0]["SIM"] != null && dt.Rows[0]["SIM"] != DBNull.Value)
{
term.SIM = dt.Rows[0]["SIM"].ToString();
}
else
{
term.SIM = string.Empty;
}
if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value)
{
term.Remark = dt.Rows[0]["Remark"].ToString();
}
else
{
term.Remark = string.Empty;
}
}
return(term);
}
public static string GetTypeNameByID(int typeId)
{
Users user = new Users();
string sql = "select Name from TerminalTypes where ID=" + typeId;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
object o = sqlHelper.GetSingle(sql);
if (o != null && o != DBNull.Value)
{
return(o.ToString());
}
}
catch (Exception e)
{
return("[" + e.Message + "]");
}
return("未知类型");
}
public static Managers GetOneManagers(int id)
{
Managers manager = new Managers();
string sql = "select * from Managers where ID=" + id.ToString();
DataTable dt = null;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
dt = sqlHelper.Query(sql);
}
catch (Exception e)
{
throw e;
}
if (dt != null && dt.Rows.Count > 0)
{
manager.ID = Convert.ToInt32(dt.Rows[0]["ID"]);
manager.username = dt.Rows[0]["username"].ToString();
manager.pwd = dt.Rows[0]["pwd"].ToString();
}
return(manager);
}
public static List <TerminalTypes> GetMoreTerminalTypes(string where = "(1=1)")
{
List <TerminalTypes> termTypes = new List <TerminalTypes>();
string sql = "select * from TerminalTypes where " + where;
DataTable dt = null;
try
{
SQLDBHelper sqlHelper = new SQLDBHelper();
dt = sqlHelper.Query(sql);
}
catch (Exception e)
{
throw e;
}
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TerminalTypes termType = new TerminalTypes();
termType.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
termType.Name = dt.Rows[i]["Name"].ToString();
termType.Price = Convert.ToDecimal(dt.Rows[i]["Price"]);
if (dt.Rows[i]["Remark"] != null && dt.Rows[i]["Remark"] != DBNull.Value)
{
termType.Remark = dt.Rows[i]["Remark"].ToString();
}
else
{
termType.Remark = string.Empty;
}
termTypes.Add(termType);
}
}
return(termTypes);
}
public int AddUser(sys_User request)
{
using (IDbConnection sqlConn = SQLDBHelper.CreateConnection())
{
for (int i = 0; i < 200; i++)
{
request = new sys_User()
{
Name = "liwx" + i,
Account = "Account" + i,
Password = "******" + i.ToString(),
Gender = i % 2,
Status = 1,
IsLimitIP = true,
MaxIPCount = 1,
Email = "358948567" + i.ToString() + "@qq.com",
Mobile = (15821121139 + i).ToString()
};
sqlConn.Insert(request);
}
return(1);
}
}
/// <summary>
/// 取得表的行数
/// </summary>
public static int GetRowCountOfAllProjectInfos()
{
return(SQLDBHelper.GetRowCount("ProjectInfo", ""));
}
/// <summary>
/// 取得表的行数
/// </summary>
public static int GetRowCountOfAllTransTypes()
{
return(SQLDBHelper.GetRowCount("TransType", ""));
}
