/// <summary>
/// 删除对象关系类型
/// </summary>
/// <param name="reltype"></param>
/// <returns></returns>
public int Delete(RelTypeModel reltype)
{
List <Jurassic.GeoFeature.DBUtility.SqlServerDBHelper.SQLEntity> sqlList = new List <Jurassic.GeoFeature.DBUtility.SqlServerDBHelper.SQLEntity>();
StringBuilder DelRelationSql = new StringBuilder();
DelRelationSql.Append(" DELETE RELATION ");
DelRelationSql.Append(" WHERE RTID IN ");
DelRelationSql.Append(" (SELECT RTID FROM RELTYPE ");
DelRelationSql.Append(" WHERE RT=@RT) ");
StringBuilder DelRelTypeSql = new StringBuilder();
DelRelTypeSql.Append(" DELETE RELTYPE ");
DelRelTypeSql.Append(" WHERE RT=@RT");
SqlParameter[] parameters =
{
new SqlParameter("@RT", SqlDbType.VarChar, 36)
};
parameters[0].Value = reltype.RT;
DBUtility.SqlServerDBHelper.SQLEntity DelRelationEntity = new DBUtility.SqlServerDBHelper.SQLEntity();
DelRelationEntity.Sqlstr = DelRelationSql.ToString();
DelRelationEntity.Sqlparameter = parameters;
DBUtility.SqlServerDBHelper.SQLEntity DelRelTypeEntity = new DBUtility.SqlServerDBHelper.SQLEntity();
DelRelTypeEntity.Sqlstr = DelRelTypeSql.ToString();
DelRelTypeEntity.Sqlparameter = parameters;
sqlList.Add(DelRelationEntity);
sqlList.Add(DelRelTypeEntity);
return(DBUtility.SqlServerDBHelper.ExecuteSql(sqlList) == true ? 1 : 0);
}
/// <summary>
/// 更新对象关系类型
/// </summary>
/// <param name="reltype"></param>
/// <returns></returns>
public int Update(RelTypeModel reltype)
{
StringBuilder strUpdateSql = new StringBuilder();
strUpdateSql.Append(" UPDATE RELTYPE SET ");
strUpdateSql.Append(" TITLE=@TITLE,BOT1=@BOT1,BOT2=@BOT2");
strUpdateSql.Append(" WHERE RT=@RT");
SqlParameter[] parameters =
{
new SqlParameter("@TITLE", SqlDbType.VarChar, 100),
new SqlParameter("@BOT1", SqlDbType.VarChar, 36),
new SqlParameter("@BOT2", SqlDbType.VarChar, 36),
new SqlParameter("@RT", SqlDbType.VarChar, 36)
};
parameters[0].Value = reltype.Title;
parameters[1].Value = reltype.Bot1;
parameters[2].Value = reltype.Bot2;
parameters[3].Value = reltype.RT;
return(DBUtility.SqlServerDBHelper.ExecuteSql(strUpdateSql.ToString(), parameters));
}
/// <summary>
/// 判断对象关系类型是否存在
/// </summary>
/// <param name="reltype"></param>
/// <returns></returns>
public bool Exist(RelTypeModel reltype, ref string RTID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM RELTYPE T ");
strSql.Append(" WHERE (REMARK=@REMARK) or (BOTID1=@BOTID1 and BOTID2=@BOTID2)");
SqlParameter[] parameters =
{
new SqlParameter("@REMARK", SqlDbType.VarChar, 50),
new SqlParameter("@BOTID1", SqlDbType.VarChar, 36),
new SqlParameter("@BOTID2", SqlDbType.VarChar, 36)
};
parameters[0].Value = reltype.Title;
parameters[1].Value = reltype.Botid1;
parameters[2].Value = reltype.Botid2;
RelTypeModel model = DBUtility.SqlServerDBHelper.ExecuteQueryText <RelTypeModel>(strSql.ToString(), parameters).FirstOrDefault();
RTID = model == null?System.Guid.NewGuid().ToString() : model.Rtid;
return(model == null ? false : true);
}
/// <summary>
/// 更新对象关系类型
/// </summary>
/// <param name="reltype"></param>
/// <returns></returns>
public int Update(RelTypeModel reltype)
{
StringBuilder strUpdateSql = new StringBuilder();
strUpdateSql.Append(" UPDATE RELTYPE SET ");
strUpdateSql.Append(" TITLE=:TITLE,BOT1=:BOT1,BOT2=:BOT2");
strUpdateSql.Append(" WHERE RT=:RT");
OracleParameter[] parameters =
{
new OracleParameter("TITLE", OracleDbType.Varchar2, 100),
new OracleParameter("BOT1", OracleDbType.Varchar2, 36),
new OracleParameter("BOT2", OracleDbType.Varchar2, 36),
new OracleParameter("RT", OracleDbType.Varchar2, 36)
};
parameters[0].Value = reltype.Title;
parameters[1].Value = reltype.Bot1;
parameters[2].Value = reltype.Bot2;
parameters[3].Value = reltype.RT;
return(DBUtility.OracleDBHelper.OracleHelper.ExecuteSql(strUpdateSql.ToString(), parameters));
}
/// <summary>
/// 添加对象关系类型
/// </summary>
/// <param name="reltype"></param>
/// <returns></returns>
public int Insert(RelTypeModel reltype)
{
StringBuilder strInsertSql = new StringBuilder();
strInsertSql.Append(" INSERT INTO RELTYPE( ");
strInsertSql.Append(" RT,BOT1,BOT2) ");
strInsertSql.Append(" VALUES (@RT,@REMARK,@BOT1,@BOT2 )");
SqlParameter[] parameters =
{
new SqlParameter("@RT", SqlDbType.VarChar, 36),
new SqlParameter("@REMARK", SqlDbType.VarChar, 100),
new SqlParameter("@BOT1", SqlDbType.VarChar, 36),
new SqlParameter("@BOT2", SqlDbType.VarChar, 36)
};
parameters[0].Value = reltype.RT;
parameters[1].Value = reltype.Title;
parameters[2].Value = reltype.Bot1;
parameters[3].Value = reltype.Bot2;
return(DBUtility.SqlServerDBHelper.ExecuteSql(strInsertSql.ToString(), parameters));
}
/// <summary>
/// 添加对象关系类型
/// </summary>
/// <param name="reltype"></param>
/// <returns></returns>
public int Insert(RelTypeModel reltype)
{
StringBuilder strInsertSql = new StringBuilder();
strInsertSql.Append(" INSERT INTO RELTYPE( ");
strInsertSql.Append(" RT,BOT1,BOT2) ");
strInsertSql.Append(" VALUES (:RT,:REMARK,:BOT1,:BOT2 )");
OracleParameter[] parameters =
{
new OracleParameter("RT", OracleDbType.Varchar2, 36),
new OracleParameter("REMARK", OracleDbType.Varchar2, 100),
new OracleParameter("BOT1", OracleDbType.Varchar2, 36),
new OracleParameter("BOT2", OracleDbType.Varchar2, 36)
};
parameters[0].Value = reltype.RT;
parameters[1].Value = reltype.Title;
parameters[2].Value = reltype.Bot1;
parameters[3].Value = reltype.Bot2;
return(DBUtility.OracleDBHelper.OracleHelper.ExecuteSql(strInsertSql.ToString(), parameters));
}
public bool Exist(RelTypeModel model, ref string RTID)
{
return(PrivateObjectCreate <RelTypeModel> .CreatIRelType("RelTypeBusiness").Exist(model, ref RTID));
}
public void Add(RelTypeModel model)
{
PrivateObjectCreate <RelTypeModel> .CreatIRelType("RelTypeBusiness").Insert(model);
}
/// <summary>
/// 提交Excel模板数据到数据库中
/// </summary>
/// <returns></returns>
public string SaveData()
{
string result = "保存成功！";
string TITLE = "";
string BOTID1 = "";
string BOTID2 = "";
string RTID = "";
string RT = "";
List <RelTypeModel> Rlist = new List <RelTypeModel>();
List <RelationModel> BOlist = new List <RelationModel>();
RelTypeModel RelModel = new RelTypeModel();
//调用已经在写好的方法来遍历,具体的在DLL中
if (DataExcel != null)
{
if (CheckData())
{
try
{
foreach (DataRow dr in ResultTable.Rows)
{
if (dr.ItemArray[0].ToString() != "" && dr.ItemArray[1].ToString() != "" && dr.ItemArray[2].ToString() != "" && dr.ItemArray[3].ToString() != "")//取对象类型的关系
{
RelTypeManager manager = new RelTypeManager();
RelModel = new RelTypeModel();
BOlist = new List <RelationModel>();
TITLE = dr.ItemArray[0].ToString();
RT = dr.ItemArray[1].ToString();
BOTID1 = dr.ItemArray[2].ToString();
BOTID2 = dr.ItemArray[3].ToString();
if (!manager.Exist(new RelTypeModel()
{
Title = TITLE, Botid1 = BOTID1, Botid2 = BOTID2
}, ref RTID)) //不存在添加对象类型之间的关系，存在则忽略此关系，只添加对象实例关系
{
RelModel.Rtid = RTID;
RelModel.RT = RT;
RelModel.Title = TITLE;
RelModel.Botid1 = BOTID1;
RelModel.Botid2 = BOTID2;
Rlist.Add(RelModel);
manager.AddRelationModel(Rlist);
}
}
else//对象实例的关系
{
RelationManager Rmanage = new RelationManager();
RelationModel tmpbo = new RelationModel();
tmpbo.RelationID = System.Guid.NewGuid().ToString();
tmpbo.RTID = RTID;
tmpbo.BOId1 = dr.ItemArray[2].ToString();
tmpbo.BOId2 = dr.ItemArray[3].ToString();
Rmanage.Add(tmpbo);
}
}
}
catch
{
result = "保存失败！";
}
finally
{
DataExcel = null;
}
}
else
{
result = CheckBOTError + "\r\n" + CheckBOError;
}
}
else
{
result = "保存失败！";
}
return(result);
}
/// <summary>
/// 修改对象关系类型
/// </summary>
/// <param name="list"></param>
/// <param name="oldRT"></param>
/// <returns></returns>
public int UpdateRelTypeByRt(List <RelTypeModel> list, string oldRT)
{
//1.根据RT查询系统中所有的对象类型 2.对比修改、添加、删除
IList <ObjTypeRelationModel> RelationList = GetRelationListByrt(oldRT);
List <Jurassic.GeoFeature.DBUtility.SqlServerDBHelper.SQLEntity> sqlList = new List <Jurassic.GeoFeature.DBUtility.SqlServerDBHelper.SQLEntity>();
//修改关系类型的实例
foreach (var item in list)
{
ObjTypeRelationModel seachModel = (from p in RelationList where p.Botid1 == item.Botid1 && p.Botid2 == item.Botid2 && p.Rt == oldRT select p).FirstOrDefault();
if (seachModel != null)
{
#region 修改部分
Jurassic.GeoFeature.DBUtility.SqlServerDBHelper.SQLEntity sqlUpdateEntity = new DBUtility.SqlServerDBHelper.SQLEntity();
StringBuilder UpdateRelTypeSql = new StringBuilder();
UpdateRelTypeSql.Append(" UPDATE RELTYPE ");
UpdateRelTypeSql.Append(" SET TITLE=@TITLE,RT=@RT ");
UpdateRelTypeSql.Append(" WHERE RTID=@RTID ");
SqlParameter[] parameters =
{
new SqlParameter("@TITLE", SqlDbType.VarChar, 36),
new SqlParameter("@RT", SqlDbType.VarChar, 36),
new SqlParameter("@RTID", SqlDbType.VarChar, 36)
};
parameters[0].Value = item.Title;
parameters[1].Value = item.RT;
parameters[2].Value = item.Rtid;
sqlUpdateEntity.Sqlstr = UpdateRelTypeSql.ToString();
sqlUpdateEntity.Sqlparameter = parameters;
sqlList.Add(sqlUpdateEntity);
#endregion
}
else
{
#region 新增部分
Jurassic.GeoFeature.DBUtility.SqlServerDBHelper.SQLEntity sqlAddEntity = new DBUtility.SqlServerDBHelper.SQLEntity();
StringBuilder strInsertSql = new StringBuilder();
strInsertSql.Append(" INSERT INTO RELTYPE( ");
strInsertSql.Append(" RTID,RT,TITLE,BOTID1,BOTID2) ");
strInsertSql.Append(" VALUES (@RTID,@RT,@TITLE,@BOTID1,@BOTID2) ");
SqlParameter[] parameters =
{
new SqlParameter("@RTID", SqlDbType.VarChar, 36),
new SqlParameter("@RT", SqlDbType.VarChar, 36),
new SqlParameter("@TITLE", SqlDbType.VarChar, 100),
new SqlParameter("@BOTID1", SqlDbType.VarChar, 36),
new SqlParameter("@BOTID2", SqlDbType.VarChar, 36)
};
parameters[0].Value = System.Guid.NewGuid().ToString();
parameters[1].Value = item.RT;
parameters[2].Value = item.Title;
parameters[3].Value = item.Botid1;
parameters[4].Value = item.Botid2;
sqlAddEntity.Sqlstr = strInsertSql.ToString();
sqlAddEntity.Sqlparameter = parameters;
sqlList.Add(sqlAddEntity);
#endregion
}
}
#region 除部分
foreach (var item in RelationList)
{
RelTypeModel seachModel = (from p in list where p.Botid1 == item.Botid1 && p.Botid2 == item.Botid2 && item.Rt == oldRT select p).FirstOrDefault();
if (seachModel == null)
{
//删除对象关系实例
Jurassic.GeoFeature.DBUtility.SqlServerDBHelper.SQLEntity sqlDelEntity = new DBUtility.SqlServerDBHelper.SQLEntity();
StringBuilder DelRelationSql = new StringBuilder();
DelRelationSql.Append(" DELETE RELATION ");
DelRelationSql.Append(" WHERE RTID =(SELECT RTID FROM RELTYPE WHERE BOTID1 =@BOTID1 AND BOTID2=@BOTID2 AND RT=@RT) ");
SqlParameter[] parameters =
{
new SqlParameter("@BOTID1", SqlDbType.VarChar, 36),
new SqlParameter("@BOTID2", SqlDbType.VarChar, 36),
new SqlParameter("@RT", SqlDbType.VarChar, 50)
};
parameters[0].Value = item.Botid1;
parameters[1].Value = item.Botid2;
parameters[2].Value = oldRT;
sqlDelEntity.Sqlstr = DelRelationSql.ToString();
sqlDelEntity.Sqlparameter = parameters;
sqlList.Add(sqlDelEntity);
//删除类型关系实例
Jurassic.GeoFeature.DBUtility.SqlServerDBHelper.SQLEntity Entity = new DBUtility.SqlServerDBHelper.SQLEntity();
StringBuilder delRelTypeSql = new StringBuilder();
delRelTypeSql.Append(" DELETE RELTYPE ");
delRelTypeSql.Append(" WHERE RTID =(SELECT RTID FROM RELTYPE WHERE BOTID1 =@BOTID1 AND BOTID2=@BOTID2 AND RT=@RT) ");
SqlParameter[] parameters1 =
{
new SqlParameter("@BOTID1", SqlDbType.VarChar, 36),
new SqlParameter("@BOTID2", SqlDbType.VarChar, 36),
new SqlParameter("@RT", SqlDbType.VarChar, 50)
};
parameters1[0].Value = item.Botid1;
parameters1[1].Value = item.Botid2;
parameters1[2].Value = oldRT;
Entity.Sqlstr = delRelTypeSql.ToString();
Entity.Sqlparameter = parameters1;
sqlList.Add(Entity);
}
}
#endregion
return(DBUtility.SqlServerDBHelper.ExecuteSql(sqlList) == true ? 1 : 0);
}
public bool Exist(RelTypeModel reltype)
{
return(false);
}
