private void txtmm_KeyDown(object sender, KeyEventArgs e) { if (Keys.Enter == e.KeyCode) { string zh = ""; string mm = ""; string lab_name = txtzh.Text; string lab_pass_word = txtmm.Text; Maticsoft.BLL.username user = new Maticsoft.BLL.username(); DataSet ds = user.GetList(string.Format(" user = '******' ", lab_name)); DataTable dt = ds.Tables[0]; string user_name = dt.Rows[0]["user"].ToString(); string password = dt.Rows[0]["password"].ToString(); global.power = dt.Rows[0]["power"].ToString(); //MessageBox.Show(" " + password + " aa "); //MessageBox.Show(dt.Rows.Count + " :count " + user_name + " : username " + password + " :password " + lab_name + " :lab_name " + lab_pass_word + " :mm "); if (user_name == lab_name && password == lab_pass_word) { MainFrom mf = new MainFrom(); mf.Show(); } else { //MessageBox.Show(" " + password + " === " + mm); MessageBox.Show("密码或账号不正确"); return; } } }
private void del_bt_Click(object sender, EventArgs e) { int[] aa = manuser.GetSelectedRows(); foreach (int testa in aa) { DataRow drt = manuser.GetDataRow(testa); string id = drt["ID"].ToString(); del_list.Add(Convert.ToInt32(id)); manuser.DeleteRow(testa); } // MessageBox.Show(aa.Length.ToString()); return; DataRow a = manuser.GetDataRow(manuser.FocusedRowHandle); Maticsoft.BLL.username use = new Maticsoft.BLL.username(); use.Delete(Convert.ToInt32(a["id"])); //MessageBox.Show(a["id"].ToString()); MessageBox.Show("删除成功"); Maticsoft.BLL.username usec = new Maticsoft.BLL.username(); DataSet ds = usec.GetAllList(); users_gc.DataSource = ds.Tables[0]; //DataSet ds = use.GetList(" "); //DataTable dt = ds.Tables[0]; //MessageBox.Show(ds.Tables.Count.ToString()); //DataTable dt = ds.Tables[0]; //MessageBox.Show(dt.Rows.Count.ToString()); }
private void query_bt_Click(object sender, EventArgs e) { if (username_tb.Text != "" && time_dtp.Text == "") { Maticsoft.BLL.username use = new Maticsoft.BLL.username(); string aa = string.Format("user = '******'", username_tb.Text); DataSet ds = use.GetList(aa); users_gc.DataSource = ds.Tables[0]; } if (username_tb.Text == "" && time_dtp.Text != "") { Maticsoft.BLL.username use = new Maticsoft.BLL.username(); string aa = string.Format("addtime = '{0}'", time_dtp.Text); DataSet ds = use.GetList(aa); users_gc.DataSource = ds.Tables[0]; } if (username_tb.Text != "" && time_dtp.Text != "") { Maticsoft.BLL.username use = new Maticsoft.BLL.username(); string aa = string.Format("addtime = '{0}'and user='******'", time_dtp.Text, username_tb.Text); DataSet ds = use.GetList(aa); users_gc.DataSource = ds.Tables[0]; } if (username_tb.Text == "" && time_dtp.Text == "") { Maticsoft.BLL.username use = new Maticsoft.BLL.username(); DataSet ds = use.GetAllList(); users_gc.DataSource = ds.Tables[0]; } }
private void edit_bt_Click(object sender, EventArgs e) { DataRow drt = manuser.GetDataRow(manuser.FocusedRowHandle); MessageBox.Show(drt["password"].ToString() + " " + drt["ID"].ToString()); Maticsoft.BLL.username user = new Maticsoft.BLL.username(); Maticsoft.Model.username user_mode = user.GetModel(Convert.ToInt32(drt["ID"])); password pass_obj = new password(); pass_obj.user_mode = user_mode; pass_obj.Show(); return; for (int i = 0; i < manuser.RowCount; i++) { string ua = manuser.GetRowCellValue(i, "user").ToString(); string pw = manuser.GetRowCellValue(i, "password").ToString(); string po = manuser.GetRowCellValue(i, "power").ToString(); int id = Convert.ToInt32(manuser.GetRowCellValue(i, "ID")); DateTime tm = Convert.ToDateTime(manuser.GetRowCellValue(i, "addTime")); Maticsoft.BLL.username use = new Maticsoft.BLL.username(); Maticsoft.Model.username us = new username() { ID = id, user = ua, addtime = tm, password = pw, power = po, }; use.Update(us); } MessageBox.Show("修改成功"); }
private void buttonX1_Click(object sender, EventArgs e) { Maticsoft.BLL.username use = new Maticsoft.BLL.username(); DataSet ds = use.GetAllList(); users_gc.DataSource = ds.Tables[0]; del_list.Clear(); }
private void ShowInfo(int ID) { Maticsoft.BLL.username bll = new Maticsoft.BLL.username(); Maticsoft.Model.username model = bll.GetModel(ID); this.lblID.Text = model.ID.ToString(); this.txtusername.Text = model.username; this.txtaddtime.Text = model.addtime.ToString(); this.txtpassword.Text = model.password; this.txtpower.Text = model.power; }
private void pictureBox2_Click(object sender, EventArgs e) { string zh = ""; string mm = ""; string lab_name = txtzh.Text; string lab_pass_word = txtmm.Text; Maticsoft.BLL.username user = new Maticsoft.BLL.username(); DataSet ds = user.GetList(string.Format(" user = '******' ", lab_name)); DataTable dt = ds.Tables[0]; string user_name = dt.Rows[0]["user"].ToString(); string password = dt.Rows[0]["password"].ToString(); global.power = dt.Rows[0]["power"].ToString(); //MessageBox.Show(" " + password + " aa "); //MessageBox.Show(dt.Rows.Count + " :count " + user_name + " : username " + password + " :password " + lab_name + " :lab_name " + lab_pass_word + " :mm "); if (user_name == lab_name && password == lab_pass_word) { MainFrom mf = new MainFrom(); mf.Show(); } else { //MessageBox.Show(" " + password + " === " + mm); MessageBox.Show("密码或账号不正确"); return; } /* * Maticsoft.BLL.username use = new Maticsoft.BLL.username(); * DataSet ds = use.GetAllList(); * for (int i = 0; i < ds.Tables[0].Rows.Count; i++) * { * zh = ds.Tables[0].Rows[i]["user"].ToString(); * mm = ds.Tables[0].Rows[i]["password"].ToString(); * * * if (txtzh.Text == zh && txtmm.Text == mm) * { * MainFrom mf = new MainFrom(); * mf.Show(); * break; * } * } * if(txtzh.Text != zh || txtmm.Text != mm) * { * MessageBox.Show("密码或账号不正确"); * return; * } */ //MainFrom mf = new MainFrom(); //mf.Show(); }
private void buttonX2_Click(object sender, EventArgs e) { Maticsoft.BLL.username use = new Maticsoft.BLL.username(); foreach (int del_index in del_list) { use.Delete(del_index); } DataSet ds = use.GetAllList(); users_gc.DataSource = ds.Tables[0]; }
private void button1_Click(object sender, EventArgs e) { string aa = DTP.Value.ToString("yyyy-MM-dd HH:mm:ss"); Maticsoft.BLL.username use = new Maticsoft.BLL.username(); Maticsoft.Model.username us = new username() { user = txt_n.Text, addtime = Convert.ToDateTime(aa), password = txt_p.Text, power = txt_q.Text, }; use.Add(us); MessageBox.Show("保存成功"); this.Close(); }
private void UserManForm_Load(object sender, EventArgs e) { Maticsoft.BLL.username use = new Maticsoft.BLL.username(); DataSet ds = use.GetAllList(); users_gc.DataSource = ds.Tables[0]; //ds.Tables.Add(); //DataTable dt = new DataTable();//创建表 //dt.Columns.Add("username", typeof(String));//添加列 //dt.Columns.Add("Manager", typeof(String)); //dt.Columns.Add("addTime", typeof(DateTime)); //dt.Columns.Add("power", typeof(String)); //dt.Rows.Add(new object[] { "admin", "admin", DateTime.Now ,"管理员"});//添加行 //dt.Rows.Add(new object[] { "李四", "zzzs", DateTime.Now, "普通账户"}); //dt.Rows.Add(new object[] { "王五", "www", DateTime.Now, "普通账户" }); // this.users_gc.DataSource = dt; }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtusername.Text.Trim().Length == 0) { strErr += "username不能为空!\\n"; } if (!PageValidate.IsDateTime(txtaddtime.Text)) { strErr += "addtime格式错误!\\n"; } if (this.txtpassword.Text.Trim().Length == 0) { strErr += "password不能为空!\\n"; } if (this.txtpower.Text.Trim().Length == 0) { strErr += "power不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int ID = int.Parse(this.lblID.Text); string username = this.txtusername.Text; DateTime addtime = DateTime.Parse(this.txtaddtime.Text); string password = this.txtpassword.Text; string power = this.txtpower.Text; Maticsoft.Model.username model = new Maticsoft.Model.username(); model.ID = ID; model.username = username; model.addtime = addtime; model.password = password; model.power = power; Maticsoft.BLL.username bll = new Maticsoft.BLL.username(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Trim() != "" && (textBox1.Text == textBox2.Text)) { Maticsoft.BLL.username user = new Maticsoft.BLL.username(); if (user_mode != null) { user_mode.password = textBox1.Text.Trim(); } if (!user.Update(user_mode)) { MessageBox.Show("更新密码失败"); } else { MessageBox.Show("更新密码成功"); } } else { MessageBox.Show("密码不合法"); } }