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