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