/// <summary> /// 增加一条数据 /// </summary> public void Add(Entity.DEPARTMENTINFO model) { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); strSql.Append("insert into DEPARTMENTINFO("); strSql.Append("F_DEPARTMENTCODE,F_NAME,F_DESCRIPTION,F_PARENT"); strSql.Append(") values ("); strSql.Append(":F_DEPARTMENTCODE,:F_NAME,:F_DESCRIPTION,:F_PARENT"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":F_DEPARTMENTCODE", OracleType.VarChar, 36), new OracleParameter(":F_NAME", OracleType.NVarChar), new OracleParameter(":F_DESCRIPTION", OracleType.NVarChar), new OracleParameter(":F_PARENT", OracleType.VarChar, 36) }; parameters[0].Value = model.F_DEPARTMENTCODE; parameters[1].Value = model.F_NAME; parameters[2].Value = model.F_DESCRIPTION; parameters[3].Value = model.F_PARENT; dbHelper.ExecuteNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.DEPARTMENTINFO GetModel(string F_DEPARTMENTCODE) { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); strSql.Append("select F_DEPARTMENTCODE, F_NAME, F_DESCRIPTION, F_PARENT "); strSql.Append(" from DEPARTMENTINFO "); strSql.Append(" where F_DEPARTMENTCODE=:F_DEPARTMENTCODE "); OracleParameter[] parameters = { new OracleParameter(":F_DEPARTMENTCODE", OracleType.VarChar, 36) }; parameters[0].Value = F_DEPARTMENTCODE; Entity.DEPARTMENTINFO model = new Entity.DEPARTMENTINFO(); DataTable ds = dbHelper.GetDataTable(strSql.ToString(), parameters); if (ds.Rows.Count > 0) { model.F_DEPARTMENTCODE = ds.Rows[0]["F_DEPARTMENTCODE"].ToString(); model.F_NAME = ds.Rows[0]["F_NAME"].ToString(); model.F_DESCRIPTION = ds.Rows[0]["F_DESCRIPTION"].ToString(); model.F_PARENT = ds.Rows[0]["F_PARENT"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Entity.DEPARTMENTINFO model) { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); strSql.Append("update DEPARTMENTINFO set "); strSql.Append(" F_DEPARTMENTCODE = :F_DEPARTMENTCODE , "); strSql.Append(" F_NAME = :F_NAME , "); strSql.Append(" F_DESCRIPTION = :F_DESCRIPTION , "); strSql.Append(" F_PARENT = :F_PARENT "); strSql.Append(" where F_DEPARTMENTCODE=:F_DEPARTMENTCODE "); OracleParameter[] parameters = { new OracleParameter(":F_DEPARTMENTCODE", OracleType.VarChar, 36), new OracleParameter(":F_NAME", OracleType.NVarChar), new OracleParameter(":F_DESCRIPTION", OracleType.NVarChar), new OracleParameter(":F_PARENT", OracleType.VarChar, 36) }; parameters[0].Value = model.F_DEPARTMENTCODE; parameters[1].Value = model.F_NAME; parameters[2].Value = model.F_DESCRIPTION; parameters[3].Value = model.F_PARENT; int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }