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