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