/// <summary> /// 得到一个对象实体 /// </summary> public VAN_OA.Model.EFrom.A_Role_User GetModelGetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" * "); strSql.Append(" from A_Role_User_View "); strSql.Append(" where ID=" + ID + " order by Role_User_Index,loginName "); VAN_OA.Model.EFrom.A_Role_User model = null; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } } return(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public VAN_OA.Model.EFrom.A_Role_User ReaderBind(IDataReader dataReader) { VAN_OA.Model.EFrom.A_Role_User model = new VAN_OA.Model.EFrom.A_Role_User(); object ojb; ojb = dataReader["iD"]; if (ojb != null && ojb != DBNull.Value) { model.ID = (int)ojb; } model.UserName = dataReader["loginName"].ToString(); model.RoleName = dataReader["A_RoleName"].ToString(); model.LoginName_ID = dataReader["LoginName_ID"].ToString(); model.Role_User_Index = Convert.ToInt32(dataReader["Role_User_Index"]); model.RowState = Convert.ToInt32(dataReader["RowState"]); try { model.UserId = Convert.ToInt32(dataReader["userId"].ToString()); } catch (Exception) { } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(VAN_OA.Model.EFrom.A_Role_User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update A_Role_User set "); strSql.Append("A_RoleId=" + model.A_RoleId + ","); strSql.Append("User_Id=" + model.User_Id + ","); strSql.Append("Role_User_Index=" + model.Role_User_Index + ","); strSql.Append("RowState=" + model.RowState + ""); strSql.Append(" where ID=" + model.ID + ""); DBHelp.ExeCommand(strSql.ToString()); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(VAN_OA.Model.EFrom.A_Role_User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into A_Role_User("); strSql.Append("A_RoleId,User_Id,Role_User_Index,RowState"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("" + model.A_RoleId + ","); strSql.Append("" + model.User_Id + ","); strSql.Append("" + model.Role_User_Index + ","); strSql.Append("" + model.RowState + ""); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); int result; object obj = DBHelp.ExeScalar(strSql.ToString()); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }