private void button5_Click(object sender, EventArgs e) { userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); if (textBox1.Text == "") { MessageBox.Show("请填写完整信息然后锁定或解锁!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (this.radioButton1.Checked == false && this.radioButton2.Checked == false) { MessageBox.Show("账户状态缺失,请重新输入!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } item.name = textBox1.Text.Trim(); if (this.radioButton1.Checked == true) { item.Btype = "Normal"; } else if (this.radioButton2.Checked == true) { item.Btype = "lock"; } userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.lock_Userpassword_Server(userlist_Server); MessageBox.Show("账户状态修改成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
private void tsbLogin_Click(object sender, EventArgs e) { #region Noway DateTime oldDate = DateTime.Now; DateTime dt3; string endday = DateTime.Now.ToString("yyyy/MM/dd"); dt3 = Convert.ToDateTime(endday); DateTime dt2; dt2 = Convert.ToDateTime("2018/08/11"); TimeSpan ts = dt2 - dt3; int timeTotal = ts.Days; if (timeTotal < 0) { MessageBox.Show("六个月运行期已到,请将剩余费用付清 !"); return; } #endregion try { ProcessLogger.Fatal("07932:System Login Start " + DateTime.Now.ToString()); NewMethoduserFind(txtSAPUserId.Text.Trim(), txtSAPPassword.Text.Trim()); if (logis != 0) { ProcessLogger.Fatal("07933:System Login Start " + DateTime.Now.ToString()); this.WindowState = FormWindowState.Maximized; if (chkSaveInfo.Checked == true) { saveUserAndPassword(); } ProcessLogger.Fatal("07934:System Login Start " + DateTime.Now.ToString()); #region 更新登录时间 List <clsuserinfo> userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); item.name = txtSAPUserId.Text.Trim(); item.denglushijian = DateTime.Now.ToString("yyyyMMdd-HH:mm:ss"); userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.updateLoginTime_Server(userlist_Server); ProcessLogger.Fatal("07935:System Login Start " + DateTime.Now.ToString()); #endregion this.WindowState = FormWindowState.Maximized; tsbLogin.Text = "登录成功"; } } catch (Exception ex) { MessageBox.Show("登录失败,请查看根目录下的System文件夹中IP.txt中服务器IP 地址是否正确!" + ex, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; throw ex; } }
private void 重置密码ToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show(" 确认重置管理者账号 , 继续 ?", "Info", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { } else { return; } List <clsuserinfo> userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); item.name = "admin"; item.password = "******"; item.Btype = "Normal"; item.AdminIS = "true"; item.jigoudaima = "管理者"; item.Createdate = DateTime.Now.ToString("yyyy/MM/dd/HH"); userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.createUser_Server(userlist_Server); MessageBox.Show("初始化用户成功!" + "用户名 :admin 密码 :123", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
private void button4_Click(object sender, EventArgs e) { userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); if (textBox4.Text == "" || textBox5.Text == "" || textBox6.Text == "") { MessageBox.Show("请填写完整信息然后创建!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (textBox4.Text.Trim() != textBox5.Text.Trim()) { MessageBox.Show("两次输入的用户密码不一致,请重新输入!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } item.name = textBox6.Text.Trim(); item.password = textBox5.Text.Trim(); userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.changeUserpassword_Server(userlist_Server); MessageBox.Show("密码修改成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
private void eToolStripMenuItem_Click(object sender, EventArgs e) { List <clsuserinfo> userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); item.name = "admin"; item.password = "******"; item.Btype = "Normal"; item.AdminIS = "true"; item.jigoudaima = "管理者"; item.Createdate = DateTime.Now.ToString("yyyy/MM/dd/HH"); userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.deleteUSER(item.name); BusinessHelp.createUser_Server(userlist_Server); MessageBox.Show("创建用户成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
public int loginAndGetUser(string name, string pwd, string company) { string sql = "select * from yh_jinxiaocun_user where name = '" + name + "' and password = '******' and gongsi = '" + company + "'"; ms = new Order.Common.MySqlHelper(sqlStr); MySqlDataReader read = ms.ExecuteReader(sql); if (read.HasRows) { clsuserinfo user = new clsuserinfo(); while (read.Read()) { user.Order_id = read["_id"].ToString(); user.AdminIS = read["AdminIS"].ToString(); user.Btype = read["Btype"].ToString(); user.Createdate = read["Createdate"].ToString(); user.gongsi = read["gongsi"].ToString(); user.jigoudaima = read["jigoudaima"].ToString(); user.name = read["name"].ToString(); user.password = read["password"].ToString(); user.mibao = read["mi_bao"].ToString(); user.denglushijian = DateTime.Now.ToString(); } if (user.Btype.Equals("锁定")) { return(-1); } System.Web.HttpContext.Current.Session["user"] = user; } return(read.HasRows ? 1 : 0); }
public List <clsuserinfo> findUser(string findtext) { string strSelect = "select * from GZCleaning_User where name='" + findtext + "'"; SQLiteConnection dbConn = new SQLiteConnection("Data Source=" + dataSource); dbConn.Open(); SQLiteCommand dbCmd = dbConn.CreateCommand(); //dbCmd.CommandText = "SELECT * FROM tuijanhaoma"; dbCmd.CommandText = strSelect; DbDataReader reader = SQLiteHelper.ExecuteReader("Data Source=" + newsth, dbCmd); List <clsuserinfo> ClaimReport_Server = new List <clsuserinfo>(); while (reader.Read()) { clsuserinfo item = new clsuserinfo(); if (reader.GetValue(0) != null && Convert.ToString(reader.GetValue(0)) != "") { item.Order_id = reader.GetString(0); } if (reader.GetValue(1) != null && Convert.ToString(reader.GetValue(1)) != "") { item.name = reader.GetString(1); } if (reader.GetValue(2) != null && Convert.ToString(reader.GetValue(2)) != "") { item.password = reader.GetString(2); } if (reader.GetValue(3) != null && Convert.ToString(reader.GetValue(3)) != "") { item.Createdate = reader.GetString(3); } if (reader.GetValue(4) != null && Convert.ToString(reader.GetValue(4)) != "") { item.Btype = reader.GetString(4); } if (reader.GetValue(5) != null && Convert.ToString(reader.GetValue(5)) != "") { item.denglushijian = reader.GetString(5); } if (reader.GetValue(6) != null && Convert.ToString(reader.GetValue(6)) != "") { item.jigoudaima = reader.GetString(6); } if (reader.GetValue(7) != null && Convert.ToString(reader.GetValue(7)) != "") { item.AdminIS = reader.GetString(7); } ClaimReport_Server.Add(item); //这里做数据处理.... } return(ClaimReport_Server); }
private void tsbLogin_Click(object sender, EventArgs e) { try { ProcessLogger.Fatal("07932:System Login Start " + DateTime.Now.ToString()); NewMethoduserFind(txtSAPUserId.Text.Trim(), txtSAPPassword.Text.Trim()); if (logis != 0) { ProcessLogger.Fatal("07933:System Login Start " + DateTime.Now.ToString()); this.WindowState = FormWindowState.Maximized; if (chkSaveInfo.Checked == true) { saveUserAndPassword(); } ProcessLogger.Fatal("07934:System Login Start " + DateTime.Now.ToString()); #region 更新登录时间 List <clsuserinfo> userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); item.name = txtSAPUserId.Text.Trim(); item.denglushijian = DateTime.Now.ToString("yyyyMMdd-HH:mm:ss"); if (is_AdminIS == false) { if (shengyuLogintime == 0) { shengyuLogintime = 1; } item.userTime = (shengyuLogintime - 1).ToString(); } userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.updateLoginTime_Server(userlist_Server); if (is_AdminIS == false) { BusinessHelp.update_userTime_Server(userlist_Server); } ProcessLogger.Fatal("07935:System Login Start " + DateTime.Now.ToString()); #endregion this.WindowState = FormWindowState.Maximized; tsbLogin.Text = "登录成功"; } } catch (Exception ex) { MessageBox.Show("登录失败,请查看根目录下的System文件夹中IP.txt中服务器IP 地址是否正确!" + ex, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; throw ex; } }
private void InitialSystemInfo() { clsAllnew BusinessHelp = new clsAllnew(); clsuserinfo user = (clsuserinfo)Session["user"]; Result_Server = new List <clsuserinfo>(); Result_Server = BusinessHelp.ReadUserlistfromServer(user.gongsi); this.gvList.AutoGenerateColumns = false; sortablePendingOrderList = new SortableBindingList <clsuserinfo>(Result_Server); this.gvList.DataSource = sortablePendingOrderList; this.gvList.DataBind(); }
private void NewMethod1() { List <clsuserinfo> userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); item.name = "Admin"; item.password = "******"; item.Btype = "Normal"; item.AdminIS = "true"; userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.createUser_Server(userlist_Server); }
protected void Button1_Click(object sender, EventArgs e) { alterinfo = "124"; userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); if (textBox1.Text == "" || textBox2.Text == "") { alterinfo = "请填写完整信息然后创建!"; return; } if (textBox2.Text.Trim() != textBox3.Text.Trim()) { alterinfo = "两次输入的用户密码不一致,请重新输入!"; return; } item.name = textBox1.Text.Trim(); item.password = textBox2.Text.Trim(); if (this.radioButton1.Checked == true) { item.Btype = "Normal"; } else if (this.radioButton2.Checked == true) { item.Btype = "lock"; } if (checkBox1.Checked == true) { item.AdminIS = "true"; } else { item.AdminIS = "false"; } item.jigoudaima = this.comboBox1.Text.Trim(); item.mibao = this.textBox4.Text.Trim(); item.Createdate = DateTime.Now.ToString("yyyy/MM/dd/HH"); userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.createUser_Server(userlist_Server); alterinfo = "创建用户成功!"; InitialSystemInfo(); }
private void button1_Click(object sender, EventArgs e) { userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); if (textBox1.Text == "" || textBox2.Text == "") { MessageBox.Show("请填写完整信息然后创建!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (textBox2.Text.Trim() != textBox3.Text.Trim()) { MessageBox.Show("两次输入的用户密码不一致,请重新输入!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } item.name = textBox1.Text.Trim(); item.password = textBox2.Text.Trim(); if (this.radioButton1.Checked == true) { item.Btype = "Normal"; } else if (this.radioButton2.Checked == true) { item.Btype = "lock"; } if (checkBox1.Checked == true) { item.AdminIS = "true"; } else { item.AdminIS = "false"; } item.jigoudaima = this.comboBox1.Text.Trim(); if (item.jigoudaima == "普通") { item.userTime = textBox7.Text; } userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.deleteUSER(item.name); BusinessHelp.createUser_Server(userlist_Server); MessageBox.Show("创建用户成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
protected void Button1_Click(object sender, EventArgs e) { clsAllnew BusinessHelp = new clsAllnew(); userlist_Server = new List <clsuserinfo>(); string strSelect = "select * from Yh_JinXiaoCun_user where name='" + textBox6.Text.Trim() + "' and mi_bao='" + textBox1.Text.Trim() + "'"; userlist_Server = BusinessHelp.findUser(strSelect); if (userlist_Server.Count == 0) { alterinfo1 = "请填写正确的密保!"; return; } alterinfo1 = ""; // userlist_Server = new List<clsuserinfo>(); clsuserinfo item = new clsuserinfo(); if (textBox4.Text == "" || textBox5.Text == "" || textBox6.Text == "") { alterinfo1 = "请填写完整信息然后创建!"; return; } if (textBox4.Text.Trim() != textBox5.Text.Trim()) { alterinfo1 = "两次输入的用户密码不一致,请重新输入!"; return; } item.name = textBox6.Text.Trim(); item.password = textBox5.Text.Trim(); foreach (clsuserinfo item_11 in userlist_Server) { item.Order_id = item_11.Order_id; } userlist_Server.Add(item); BusinessHelp.changeUserpassword_Server(userlist_Server); alterinfo1 = "密码修改成功!"; }
public List <clsuserinfo> ReadUserlistfromServer() { string conditions = "select * from emw_user";//成功 OleDbConnection aConnection = new OleDbConnection(ConStr); List <clsuserinfo> ClaimReport_Server = new List <clsuserinfo>(); if (aConnection.State == ConnectionState.Closed) { aConnection.Open(); } OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(conditions, aConnection); OleDbCommandBuilder mybuilder = new OleDbCommandBuilder(myDataAdapter); DataSet ds = new DataSet(); myDataAdapter.Fill(ds, "emw_user"); foreach (DataRow reader in ds.Tables["emw_user"].Rows) { clsuserinfo item = new clsuserinfo(); if (reader["_id"].ToString() != "") { item.Order_id = reader["_id"].ToString(); } if (reader["name"].ToString() != "") { item.name = reader["name"].ToString(); } if (reader["password"].ToString() != "") { item.password = reader["password"].ToString(); } if (reader["Createdate"].ToString() != "") { item.Createdate = reader["Createdate"].ToString(); } if (reader["Btype"].ToString() != "") { item.Btype = reader["Btype"].ToString(); } if (reader["denglushijian"].ToString() != "") { item.denglushijian = reader["denglushijian"].ToString(); } if (reader["jigoudaima"].ToString() != "") { item.jigoudaima = reader["jigoudaima"].ToString(); } if (reader["userTime"].ToString() != "") { item.userTime = reader["userTime"].ToString(); } if (reader["AdminIS"].ToString() != "") { item.AdminIS = reader["AdminIS"].ToString(); } if (reader["mibao"].ToString() != "") { item.mibao = reader["mibao"].ToString(); } ClaimReport_Server.Add(item); //这里做数据处理.... } return(ClaimReport_Server); }
public List <clsuserinfo> findUser(string findtext) { try { // string strSelect = "select * from emw_user where name='" + findtext + "'"; OleDbConnection aConnection = new OleDbConnection(ConStr); List <clsuserinfo> ClaimReport_Server = new List <clsuserinfo>(); if (aConnection.State == ConnectionState.Closed) { aConnection.Open(); } OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(findtext, aConnection); OleDbCommandBuilder mybuilder = new OleDbCommandBuilder(myDataAdapter); DataSet ds = new DataSet(); myDataAdapter.Fill(ds, "emw_user"); foreach (DataRow reader in ds.Tables["emw_user"].Rows) { clsuserinfo item = new clsuserinfo(); if (reader["_id"].ToString() != "") { item.Order_id = reader["_id"].ToString(); } if (reader["name"].ToString() != "") { item.name = reader["name"].ToString(); } if (reader["password"].ToString() != "") { item.password = reader["password"].ToString(); } if (reader["Createdate"].ToString() != "") { item.Createdate = reader["Createdate"].ToString(); } if (reader["Btype"].ToString() != "") { item.Btype = reader["Btype"].ToString(); } if (reader["denglushijian"].ToString() != "") { item.denglushijian = reader["denglushijian"].ToString(); } if (reader["jigoudaima"].ToString() != "") { item.jigoudaima = reader["jigoudaima"].ToString(); } if (reader["userTime"].ToString() != "") { item.userTime = reader["userTime"].ToString(); } if (reader["AdminIS"].ToString() != "") { item.AdminIS = reader["AdminIS"].ToString(); } if (reader["mibao"].ToString() != "") { item.mibao = reader["mibao"].ToString(); } ClaimReport_Server.Add(item); //这里做数据处理.... } return(ClaimReport_Server); } catch (Exception ex) { // inputlog(ex.Message + "//" + ex.Source + "//" + ex.StackTrace); HttpContext.Current.Response.Redirect("~/ErrorPage/ErrorPage.aspx?Error=" + "无法与服务器建立连接,请确保数据库配置或网络畅通!"); throw ex; } }
public List <clsuserinfo> findUser(string findtext) { string strSelect = "select * from JNOrder_User where name='" + findtext + "'"; MySql.Data.MySqlClient.MySqlDataReader reader = MySqlHelper.ExecuteReader(strSelect); List <clsuserinfo> ClaimReport_Server = new List <clsuserinfo>(); while (reader.Read()) { clsuserinfo item = new clsuserinfo(); item.Order_id = reader.GetString(0); item.name = reader.GetString(1); item.password = reader.GetString(2); item.Createdate = reader.GetString(3); item.Btype = reader.GetString(4); item.denglushijian = reader.GetString(5); item.jigoudaima = reader.GetString(6); item.AdminIS = reader.GetString(7); ClaimReport_Server.Add(item); //这里做数据处理.... } return(ClaimReport_Server); #region Read database info server //try //{ // List<clsuserinfo> ClaimReport_Server = new List<clsuserinfo>(); // MongoServer server = MongoServer.Create(connectionString); // MongoDatabase db1 = server.GetDatabase(DB_NAME); // MongoCollection collection1 = db1.GetCollection("FA_shop_User"); // MongoCollection<BsonDocument> employees = db1.GetCollection<BsonDocument>("FA_shop_User"); // var query = new QueryDocument("name", findtext); // foreach (BsonDocument emp in employees.Find(query)) // { // clsuserinfo item = new clsuserinfo(); // #region 数据 // if (emp.Contains("_id")) // item.Order_id = (emp["_id"].ToString()); // if (emp.Contains("name")) // item.name = (emp["name"].AsString); // if (emp.Contains("password")) // item.password = (emp["password"].ToString()); // if (emp.Contains("Btype")) // item.Btype = (emp["Btype"].AsString); // if (emp.Contains("denglushijian")) // item.denglushijian = (emp["denglushijian"].AsString); // if (emp.Contains("Createdate")) // item.Createdate = (emp["Createdate"].AsString); // if (emp.Contains("AdminIS")) // item.AdminIS = (emp["AdminIS"].AsString); // if (emp.Contains("jigoudaima")) // item.jigoudaima = (emp["jigoudaima"].AsString); // #endregion // ClaimReport_Server.Add(item); // } // return ClaimReport_Server; //} //catch (Exception ex) //{ // MessageBox.Show("" + ex); // return null; // throw ex; //} #endregion }
public List <clsuserinfo> findUser(string findtext) { #region Read database info server try { List <clsuserinfo> ClaimReport_Server = new List <clsuserinfo>(); string connectionString = "mongodb://127.0.0.1"; connectionString = ipadress; MongoServer server = MongoServer.Create(connectionString); MongoDatabase db1 = server.GetDatabase("FA_datawork_HRB"); MongoCollection collection1 = db1.GetCollection("FA_datawork_HRB_User"); MongoCollection <BsonDocument> employees = db1.GetCollection <BsonDocument>("FA_datawork_HRB_User"); var query = new QueryDocument("name", findtext); foreach (BsonDocument emp in employees.Find(query)) { clsuserinfo item = new clsuserinfo(); #region 数据 if (emp.Contains("_id")) { item._id = (emp["_id"].ToString()); } if (emp.Contains("name")) { item.name = (emp["name"].AsString); } if (emp.Contains("password")) { item.password = (emp["password"].ToString()); } if (emp.Contains("Btype")) { item.Btype = (emp["Btype"].AsString); } if (emp.Contains("denglushijian")) { item.denglushijian = (emp["denglushijian"].AsString); } if (emp.Contains("Createdate")) { item.Createdate = (emp["Createdate"].AsString); } if (emp.Contains("AdminIS")) { item.AdminIS = (emp["AdminIS"].AsString); } if (emp.Contains("jigoudaima")) { item.jigoudaima = (emp["jigoudaima"].AsString); } #endregion ClaimReport_Server.Add(item); } return(ClaimReport_Server); } catch (Exception ex) { MessageBox.Show("" + ex); return(null); throw ex; } #endregion }
protected void Button1_Click(object sender, EventArgs e) { alterinfo = "124"; userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); if (textBox1.Text == "" || textBox2.Text == "") { alterinfo = "请填写完整信息然后创建!"; return; } if (textBox2.Text.Trim() != textBox3.Text.Trim()) { alterinfo = "两次输入的用户密码不一致,请重新输入!"; return; } item.name = textBox1.Text.Trim(); item.password = textBox2.Text.Trim(); if (this.radioButton1.Checked == true) { item.Btype = "Normal"; } else if (this.radioButton2.Checked == true) { item.Btype = "lock"; } if (checkBox1.Checked == true) { item.AdminIS = "true"; } else { item.AdminIS = "false"; } item.jigoudaima = this.comboBox1.Text.Trim(); item.mibao = this.textBox4.Text.Trim(); item.Createdate = DateTime.Now.ToString("yyyy/MM/dd/HH"); userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); string findup_name = ""; findup_name = item.jigoudaima; while (true) { List <clsuserinfo> Finduserlist_Server = new List <clsuserinfo>(); string strSelect = "select * from _user where name='" + findup_name + "'"; Finduserlist_Server = BusinessHelp.findUser(strSelect.Trim()); //绑定上级 if (Finduserlist_Server.Count > 0) { Finduserlist_Server[0].xiajilist = Finduserlist_Server[0].xiajilist + " " + item.name; //更新上级信息 string conditions = "update _user set " + " xiajilist ='" + Finduserlist_Server[0].xiajilist + "'" + " where _id = " + Finduserlist_Server[0].Order_id + " "; BusinessHelp.Update_User_Server(conditions); findup_name = Finduserlist_Server[0].jigoudaima; } else { break; } } BusinessHelp.createUser_Server(userlist_Server); alterinfo = "创建用户成功!"; InitialSystemInfo(); }