/// <summary> /// 查询组织机构 /// </summary> /// <param name="otherKnowledgeID"></param> /// <param name="parentID"></param> /// <param name="idPath"></param> /// <param name="levelNum"></param> /// <param name="orderIndex"></param> /// <param name="otherKnowledgeName"></param> /// <param name="description"></param> /// <param name="memo"></param> /// <param name="startRowIndex">起始记录行</param> /// <param name="maximumRows">每页记录条数</param> /// <param name="orderBy">排序字符串,如"FieldName ASC"</param> /// <returns></returns> public IList <OtherKnowledge> GetOtherKnowledge(int otherKnowledgeID, int parentID, string idPath, int levelNum, int orderIndex, string otherKnowledgeName, string description, string memo, int startRowIndex, int maximumRows, string orderBy) { IList <OtherKnowledge> otherKnowledges = new List <OtherKnowledge>(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_Other_Knowledge_S"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_start_row_index", DbType.Int32, startRowIndex); db.AddInParameter(dbCommand, "p_page_size", DbType.Int32, maximumRows); db.AddInParameter(dbCommand, "p_order_by", DbType.AnsiString, GetMappingOrderBy(orderBy)); db.AddOutParameter(dbCommand, "p_count", DbType.Int32, 4); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { OtherKnowledge otherKnowledge = CreateModelObject(dataReader); otherKnowledges.Add(otherKnowledge); } } _recordCount = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_count")); return(otherKnowledges); }
public void UpdateOtherKnowledge(OtherKnowledge otherKnowledge) { Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_Other_Knowledge_U"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_Other_Knowledge_id", DbType.Int32, otherKnowledge.OtherKnowledgeID); db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, otherKnowledge.ParentID); db.AddInParameter(dbCommand, "p_id_path", DbType.String, otherKnowledge.IdPath); db.AddInParameter(dbCommand, "p_level_num", DbType.Int32, otherKnowledge.LevelNum); db.AddInParameter(dbCommand, "p_order_index", DbType.Int32, otherKnowledge.OrderIndex); db.AddInParameter(dbCommand, "p_Other_Knowledge_name", DbType.String, otherKnowledge.OtherKnowledgeName); db.AddInParameter(dbCommand, "p_description", DbType.String, otherKnowledge.Description); db.AddInParameter(dbCommand, "p_memo", DbType.String, otherKnowledge.Memo); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { db.ExecuteNonQuery(dbCommand, transaction); transaction.Commit(); } catch { transaction.Rollback(); } connection.Close(); }
public OtherKnowledge GetOtherKnowledge(int OtherKnowledgeID) { OtherKnowledge otherKnowledge = null; Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USp_Other_Knowledge_G"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_Other_Knowledge_id", DbType.Int32, OtherKnowledgeID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { otherKnowledge = CreateModelObject(dataReader); } } return(otherKnowledge); }
public int AddOtherKnowledge(OtherKnowledge otherKnowledge) { int id = 0; Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_Other_Knowledge_I"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddOutParameter(dbCommand, "p_other_knowledge_id", DbType.Int32, 4); db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, otherKnowledge.ParentID); db.AddOutParameter(dbCommand, "p_id_path", DbType.String, 20); db.AddOutParameter(dbCommand, "p_level_num", DbType.Int32, 4); db.AddOutParameter(dbCommand, "p_order_index", DbType.Int32, 4); db.AddInParameter(dbCommand, "p_Other_Knowledge_name", DbType.String, otherKnowledge.OtherKnowledgeName); db.AddInParameter(dbCommand, "p_description", DbType.String, otherKnowledge.Description); db.AddInParameter(dbCommand, "p_memo", DbType.String, otherKnowledge.Memo); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { db.ExecuteNonQuery(dbCommand, transaction); id = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_Other_Knowledge_id")); transaction.Commit(); } catch { transaction.Rollback(); } connection.Close(); return(id); }
public void DeleteOtherKnowledge(OtherKnowledge otherKnowledge) { DeleteOtherKnowledge(otherKnowledge.OtherKnowledgeID); }
public void UpdateOtherKnowledge(OtherKnowledge otherKnowledge) { objLogBll.WriteLog("修改其它知识“" + otherKnowledge.OtherKnowledgeName + "”基本信息"); dal.UpdateOtherKnowledge(otherKnowledge); }
public int AddOtherKnowledge(OtherKnowledge otherKnowledge) { objLogBll.WriteLog("新增其它知识“" + otherKnowledge.OtherKnowledgeName + "”基本信息"); return(dal.AddOtherKnowledge(otherKnowledge)); }