/// <summary> /// 更新一条数据 /// </summary> public bool Update(USERROLE model) { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); strSql.Append("update USERROLE set "); strSql.Append(" F_ID = :F_ID , "); strSql.Append(" F_ACCOUNT = :F_ACCOUNT , "); strSql.Append(" F_ROLECODE = :F_ROLECODE "); strSql.Append(" where F_ID=:F_ID "); OracleParameter[] parameters = { new OracleParameter(":F_ID", OracleType.VarChar, 36), new OracleParameter(":F_ACCOUNT", OracleType.VarChar, 36), new OracleParameter(":F_ROLECODE", OracleType.VarChar, 36) }; parameters[0].Value = model.F_ID; parameters[1].Value = model.F_ACCOUNT; parameters[2].Value = model.F_ROLECODE; int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public USERROLE GetModel(string F_ID) { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); strSql.Append("select F_ID, F_ACCOUNT, F_ROLECODE "); strSql.Append(" from USERROLE "); strSql.Append(" where F_ID=:F_ID "); OracleParameter[] parameters = { new OracleParameter(":F_ID", OracleType.VarChar, 36) }; parameters[0].Value = F_ID; USERROLE model = new USERROLE(); DataTable ds = dbHelper.GetDataTable(strSql.ToString(), parameters); if (ds.Rows.Count > 0) { model.F_ID = ds.Rows[0]["F_ID"].ToString(); model.F_ACCOUNT = ds.Rows[0]["F_ACCOUNT"].ToString(); model.F_ROLECODE = ds.Rows[0]["F_ROLECODE"].ToString(); return(model); } else { return(null); } }
public void ModifyUser(MdlUserLogin model) { USER u = _dbFirms.USERs.First(i => i.UserID == model.UserID); u.UserName = model.UserName; u.UserEmail = model.UserEmail; u.UserContactNo = model.UserContactNo; u.EntryDate = DateTime.Now; _dbFirms.SaveChanges(); USERROLE ur = _dbFirms.USERROLEs.First(e => e.User_ID == model.UserID); ur.Role_ID = model.Role_ID; ur.ModifyDate = DateTime.Now; ur.EnterByUser_ID = model.EnterByUser_ID; _dbFirms.SaveChanges(); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(USERROLE model) { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); strSql.Append("insert into USERROLE("); strSql.Append("F_ID,F_ACCOUNT,F_ROLECODE"); strSql.Append(") values ("); strSql.Append(":F_ID,:F_ACCOUNT,:F_ROLECODE"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":F_ID", OracleType.VarChar, 36), new OracleParameter(":F_ACCOUNT", OracleType.VarChar, 36), new OracleParameter(":F_ROLECODE", OracleType.VarChar, 36) }; parameters[0].Value = model.F_ID; parameters[1].Value = model.F_ACCOUNT; parameters[2].Value = model.F_ROLECODE; dbHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
private void btnOk_Click(object sender, EventArgs e) { if (txtPwd.Text != txtPwd2.Text) { MessageBox.Show("两次输入的密码不一致,请重新输入!"); txtPwd.Focus(); return; } if (lblTitle.Text == "新增用户") { IList <USER> users = USERDao.QueryForList(null).Where(p => p.NAME == txtDlm.Text.Trim()).ToList(); if (users != null && users.Count > 0) { MessageBox.Show("该登录名已使用,请重新输入登录名!"); txtDlm.Focus(); return; } } USER user = new USER(); user.ID = int.Parse(lblXh.Text); user.NAME = txtDlm.Text; user.REAL_NAME = txtXm.Text; if (rdbMale.Checked == true) { user.GENDER = "男"; } else { user.GENDER = "女"; } user.DEPT = cmbBm.Text; user.TEL = txtLxdh.Text; user.EMAIL = txtEmail.Text; user.STATE = 0; user.PASSWORD = txtPwd.Text; if (USERDao.Get(user.ID) != null) { USERDao.Update(user); } else { USERDao.Insert(user); } var userRoles = USERROLEDao.QueryForListByUserId(user.ID); if (userRoles != null && userRoles.Count > 0) { USERROLE userRole = new USERROLE { ID = userRoles[0].ID, USER_ID = user.ID, ROLE_ID = (int)cmbQx.SelectedValue, PROJ_ID = 1 }; USERROLEDao.Update(userRole); } else { USERROLE userRole = new USERROLE { ID = USERROLEDao.GetNewId(), USER_ID = user.ID, ROLE_ID = (int)cmbQx.SelectedValue, PROJ_ID = 1 }; USERROLEDao.Insert(userRole); } if (lblTitle.Text == "新增用户") { MainForm.UpdateYHList(null, true); } else { MainForm.UpdateYHList(null, false); } MainForm.HidenFlyout(); }
public static object Insert(USERROLE t) { return(BaseDA.Insert <USERROLE>("InsertUSERROLE", t)); }
public static int Update(USERROLE t) { return(BaseDA.Update <USERROLE>("UpdateUSERROLE", t)); }