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