/// <summary> /// 获取全部对象类型 /// </summary> /// <returns></returns> public List <ObjectTypeModel> GetAllObjectType() { StringBuilder strSql = new StringBuilder(); strSql.Append(" SELECT * FROM OBJECTTYPE "); DataTable dt = DBUtility.SqlServerDBHelper.GetDataTable(strSql.ToString()); List <ObjectTypeModel> list = new List <ObjectTypeModel>(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { ObjectTypeModel model = new ObjectTypeModel(); model.BOT = item["BOT"].ToString(); model.BOTID = item["BOTID"].ToString(); model.FT = item["FT"].ToString(); model.ID = item["ID"].ToString(); model.NAME = item["NAME"].ToString(); model.SHAPE = item["SHAPE"].ToString(); model.ISUSERDEFINEE = item["ISUSERDEFINE"].ToString(); model.USEGEOMETRY = item["USEGEOMETRY"].ToString(); list.Add(model); } } return(list); }
public WResult UpdateObjectType(ObjectTypeModel objectType) { if (objectType == null) { return(new WResult(InvalidDataErrorMessage)); } using (var uow = new UnitOfWork()) { var dbObjectType = uow.ObjectTypes.GetObjectType(objectType.ObjectCode); if (dbObjectType == null) { return(new WResult(ObjectTypeNotExistsErrorMessage)); } ObjectMapper.Default.Map(objectType, dbObjectType); uow.Complete(); return(new WResult()); } }
public IList <ObjectTypeModel> GetList() { List <ObjectTypeModel> List = new List <ObjectTypeModel>(); StringBuilder strSql = new StringBuilder(); strSql.Append(" SELECT * FROM OBJECTTYPE"); DataSet ds = DBUtility.OracleDBHelper.OracleHelper.ExecuteQueryText(strSql.ToString()); if (ds != null) { foreach (DataRow dr in ds.Tables[0].Rows) { ObjectTypeModel OBM = new ObjectTypeModel(); OBM.Botid = dr.ItemArray[0].ToString(); OBM.Bot = dr.ItemArray[1].ToString(); List.Add(OBM); } } return(List); }
public int Delete(ObjectTypeModel model) { return(0); }
public int Update(ObjectTypeModel model) { return(0); }
public int Insert(ObjectTypeModel model) { return(0); }
public bool Exist(ObjectTypeModel model) { return(false); }