void FrmUsers_Load(object sender, EventArgs e) { //throw new NotImplementedException(); RIPP.NIR.Controls.StyleTool.FormatGrid(ref this.dataGridView1); this.SetHeader(); using (var db = new NIRCeneterEntities()) { var lst = db.S_User; foreach (var u in lst) { var row = new mydatarow() { User = u, IsEdited = false, IsNew = false }; row.CreateCells(this.dataGridView1, u.loginName, u.IsDeleted ? "停用" : "正常", "******", u.realName, u.tel, u.email, u.Role.GetDescription()); //显示不同的颜色 if ((this._user.Role == RoleEnum.Engineer && u.Role == RoleEnum.Engineer) && this._user.ID != u.ID) { row.DefaultCellStyle.BackColor = Color.FromArgb(240, 240, 240); } this.dataGridView1.Rows.Add(row); } } }
private void btnSetOk_Click(object sender, EventArgs e) { if (this.dataGridView1.SelectedRows.Count == 0) { MessageBox.Show("请先选中需要启用的用户。"); return; } var row = this.dataGridView1.SelectedRows[0] as mydatarow; if (row == null || row.User == null) { return; } if (MessageBox.Show(string.Format("是否启用 {0} ?", row.User.loginName), "信息提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { using (var db = new NIRCeneterEntities()) { var u = db.S_User.Where(d => d.ID == row.User.ID).FirstOrDefault(); if (u != null) { u.IsDeleted = false; db.SaveChanges(); } row.User.IsDeleted = false; row.Cells["isdeleted"].Value = "启用"; //this.dataGridView1.Rows.RemoveAt(row.Index); } } }
private void button1_Click(object sender, EventArgs e) { if (this.dataGridView1.SelectedRows.Count == 0) { return; } var row = this.dataGridView1.SelectedRows[0] as myrow; if (row == null) { return; } this.lblStatu.Text = "正在保存"; this.Enabled = false; row.Cells[1].Value = true; var lstnames = new List <string>(); for (int r = 0; r < this.dataGridView1.Rows.Count; r++) { if (Convert.ToBoolean(this.dataGridView1[1, r].Value)) { lstnames.Add(Convert.ToString(this.dataGridView1[0, r].Value)); } } Action a = () => { //检查MD5 var md5 = Tool.GetMD5HashFromFile(row.FullPath); using (var db = new NIRCeneterEntities()) { var modeldb = db.AllMethod.Where(m => m.MD5Str == md5).FirstOrDefault(); if (modeldb == null) { modeldb = new AllMethod() { AddTime = DateTime.Now, FullPath = row.FullPath, MD5Str = md5, UserID = this._user.ID, Contents = Serialize.ObjectToByte(row.Model) }; db.AllMethod.AddObject(modeldb); db.SaveChanges(); } this._config.AvailableModelNames = lstnames; this._config.ModelDefaultPath = row.FullPath; this._config.ModelDefaultID = modeldb.ID; this._config.Save(); } this.DialogResult = System.Windows.Forms.DialogResult.Yes; this.Close(); }; this.Invoke(a); }
private void btnOK_Click(object sender, EventArgs e) { using (var db = new NIRCeneterEntities()) { var item = db.S_User.Where(d => d.ID == this._user.ID).FirstOrDefault(); if (item != null) { item.realName = this.txbRealname.Text; item.email = this.txbEmail.Text; item.tel = this.txbPhone.Text; if (!string.IsNullOrWhiteSpace(this.txbpassword.Text.Trim())) { item.password = RIPP.Lib.Security.SecurityTool.BuildPassword(this.txbpassword.Text.Trim()); } db.SaveChanges(); } this.DialogResult = System.Windows.Forms.DialogResult.OK; } }
private void label3_Click(object sender, EventArgs e) { if (MessageBox.Show("是否清除数据库中的所有数据?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { Action a = () => { using (var db = new NIRCeneterEntities()) { var lst = db.Specs; foreach (var s in lst) { db.Specs.DeleteObject(s); } db.SaveChanges(); } }; a.BeginInvoke(null, null); } }
void FrmLogon_Load(object sender, EventArgs e) { this.btnLogon.Enabled = false; this.AcceptButton = this.btnLogon; Action sa = () => { this.showinfo("正在初始化数值计算库..."); RIPP.NIR.Data.Tools.Init(); this._isInit = true; if (this.progressBar1.InvokeRequired) { ThreadStart ss = () => { this.progressBar1.Visible = false; }; this.progressBar1.Invoke(ss); } else { this.progressBar1.Visible = false; } this.showinfo("数值计算库初始化完成"); if (this._islogin) { if (this.InvokeRequired) { ThreadStart ss = () => { this.DialogResult = System.Windows.Forms.DialogResult.OK; }; this.Invoke(ss); } else { this.DialogResult = System.Windows.Forms.DialogResult.OK; } } }; sa.BeginInvoke(null, null); //检查数据库 Action a = () => { try { string str = RIPP.Lib.Security.SecurityTool.BuildPassword("2"); using (var db = new NIRCeneterEntities()) { db.S_User.Where(d => d.ID == 4).FirstOrDefault(); } //初始化Matlab相关 if (this.btnLogon.InvokeRequired) { ThreadStart s = () => { this.btnLogon.Enabled = true; }; this.lblInfo.Invoke(s); } else { this.btnLogon.Enabled = true; } } catch (Exception ex) { this.showinfo("数据库连接失败,请检查配置文件。"); Log.Error(ex.ToString()); } }; a.BeginInvoke(null, null); }
/// <summary> /// 按钮|登陆 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnLogon_Click(object sender, EventArgs e) { btnLogon.Enabled = false; //this.lblInfo.Text = ""; string username = this.txbLoginName.Text.Trim(); string password = this.txbPsw.Text.Trim(); //先判断是否为RIPP if (username == "1") { if (password == "1") { this.LogUser = new S_User() { Role = RoleEnum.RIPP }; this._islogin = true; this.btnLogon.Enabled = false; if (this._isInit) { this.DialogResult = DialogResult.OK; } } else { this.lblInfo.Text = "密码不正确,请重试!"; this.btnLogon.Enabled = true; } } else { using (var db = new NIRCeneterEntities()) { var user = db.S_User.Where(d => d.loginName == username).FirstOrDefault(); if (user == null) { this.lblInfo.Text = "用户名不存在,请重试!"; this.btnLogon.Enabled = true; } else { if (user.password != RIPP.Lib.Security.SecurityTool.BuildPassword(password)) { this.lblInfo.Text = "密码不正确,请重试!"; this.btnLogon.Enabled = true; } else if (user.IsDeleted) { this.lblInfo.Text = "您的账户已被停用,请重试!"; this.btnLogon.Enabled = true; } else { this.LogUser = user; this._islogin = true; this.btnLogon.Enabled = false; if (this._isInit) { this.DialogResult = DialogResult.OK; } } } } } }
public void Save() { if (this._table == null) { return; } using (var db = new NIRCeneterEntities()) { var lst = db.Properties.Where(d => d.TableID == (int)this._table.Table); foreach (var i in lst) { db.Properties.DeleteObject(i); } var needadd = new List <Busi.Properties>(); for (int r = 0; r < this.dataGridView1.RowCount; r++) { int d = 0; var c1 = Convert.ToString(this.dataGridView1[0, r].Value); var c2 = Convert.ToString(this.dataGridView1[5, r].Value); if (!string.IsNullOrWhiteSpace(c1)) { var s = Convert.ToString(this.dataGridView1[4, r].Value); if (int.TryParse(s, out d)) { var name = this.dataGridView1[0, r].Value ?? ""; var name1 = this.dataGridView1[1, r].Value ?? ""; var code = this.dataGridView1[2, r].Value ?? ""; var units = this.dataGridView1[3, r].Value ?? ""; needadd.Add(new Busi.Properties() { Name = name.ToString().Trim(), Name1 = name1.ToString().Trim(), Code = code.ToString().Trim(), Units = units.ToString().Trim(), Eps = d, ColumnIdx = 1, Idx = r, TableID = (int)this._table.Table }); } } if (!string.IsNullOrWhiteSpace(c2)) { var s = Convert.ToString(this.dataGridView1[9, r].Value); if (int.TryParse(s, out d)) { var name = this.dataGridView1[5, r].Value ?? ""; var name1 = this.dataGridView1[6, r].Value ?? ""; var code = this.dataGridView1[7, r].Value ?? ""; var units = this.dataGridView1[8, r].Value ?? ""; needadd.Add(new Busi.Properties() { Name = name.ToString().Trim(), Name1 = name1.ToString().Trim(), Code = code.ToString().Trim(), Units = units.ToString().Trim(), Eps = d, ColumnIdx = 2, Idx = r, TableID = (int)this._table.Table }); } } } foreach (var i in needadd) { db.Properties.AddObject(i); } db.SaveChanges(); } }
private void edituser(int rowid) { if (rowid >= this.dataGridView1.Rows.Count) { return; } var row = this.dataGridView1.Rows[rowid] as mydatarow; if (row == null || row.User == null) { return; } var loginName = Convert.ToString(row.Cells["loginName"].Value).Trim(); var password = Convert.ToString(row.Cells["password"].Value).Trim(); var realName = Convert.ToString(row.Cells["realName"].Value).Trim(); var tel = Convert.ToString(row.Cells["tel"].Value).Trim(); var email = Convert.ToString(row.Cells["email"].Value).Trim(); var role = Convert.ToString(row.Cells["role"].Value).Trim(); var isdelted = Convert.ToString(row.Cells["isdeleted"].Value).Trim(); if (string.IsNullOrWhiteSpace(loginName) || string.IsNullOrWhiteSpace(password)) { return; } using (var db = new NIRCeneterEntities()) { S_User user; if (row.User.ID == 0) { user = new S_User(); } else { user = db.S_User.Where(d => d.ID == row.User.ID).FirstOrDefault(); } //检查登录名是否重复 if (db.S_User.Where(d => d.loginName == loginName && d.ID != user.ID).Count() > 0) { MessageBox.Show("登录名重复,请重新输入!"); return; } if (user == null) { return; } user.loginName = loginName; if (password != "******") { user.password = RIPP.Lib.Security.SecurityTool.BuildPassword(password); } user.realName = realName; user.tel = tel; user.email = email; user.roleID = (int)(RoleEnum.Engineer.GetDescription() == role ? RoleEnum.Engineer : RoleEnum.Operater); user.IsDeleted = isdelted == "停用" ? true : false; if (user.ID == 0) { db.S_User.AddObject(user); } db.SaveChanges(); row.User = user; } }