/// <summary> /// 处理地质构造信息 /// </summary> /// <param name="geologySpaceEntity"></param> /// <returns></returns> public static bool ProcGeologySpaceEntityInfo(GeologySpaceEntityNew geologySpaceEntity) { ManageDataBase db = new ManageDataBase(DATABASE_TYPE.MiningSchedulingDB); StringBuilder sb = new StringBuilder(); sb.Append("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;"); sb.Append("BEGIN TRANSACTION;"); sb.Append("IF EXISTS( SELECT * FROM T_GEOLOGY_SPACE WHERE "); sb.Append(GeologySpaceDbConstNamesNew.WORKFACE_ID + "=" + geologySpaceEntity.WorkSpaceID); sb.Append(" AND " + GeologySpaceDbConstNamesNew.TECTONIC_ID + "=" + geologySpaceEntity.TectonicID); sb.Append(" AND " + GeologySpaceDbConstNamesNew.TECTONIC_TYPE + "=" + geologySpaceEntity.TectonicType); sb.Append(" BEGIN "); sb.Append(" UPDATE " + GeologySpaceDbConstNamesNew.TABLE_NAME + " SET "); sb.Append(GeologySpaceDbConstNamesNew.TECTONIC_DISTANCE + "=" + geologySpaceEntity.Distance); sb.Append("," + GeologySpaceDbConstNamesNew.DATE_TIME + "=" + geologySpaceEntity.onDateTime); sb.Append(" WHERE " + GeologySpaceDbConstNamesNew.WORKFACE_ID + "=" + geologySpaceEntity.WorkSpaceID); sb.Append(" AND " + GeologySpaceDbConstNamesNew.TECTONIC_ID + "=" + geologySpaceEntity.TectonicID); sb.Append(" AND " + GeologySpaceDbConstNamesNew.TECTONIC_TYPE + "=" + geologySpaceEntity.TectonicType + ";"); sb.Append(" END "); sb.Append(" ELSE "); sb.Append(" BEGIN "); sb.Append("INSERT INTO " + GeologySpaceDbConstNamesNew.TABLE_NAME + "(" + GeologySpaceDbConstNamesNew.WORKFACE_ID + "," + GeologySpaceDbConstNamesNew.TECTONIC_ID + "," + GeologySpaceDbConstNamesNew.TECTONIC_TYPE + "," + GeologySpaceDbConstNamesNew.TECTONIC_DISTANCE + "," + GeologySpaceDbConstNamesNew.DATE_TIME + ")VALUES("); sb.Append(geologySpaceEntity.WorkSpaceID + "," + geologySpaceEntity.TectonicID + "," + geologySpaceEntity.TectonicType + "," + geologySpaceEntity.Distance + ",'" + geologySpaceEntity.onDateTime + "');"); sb.Append(" END "); sb.Append("COMMIT TRANSACTION;"); bool bres = db.OperateDB(sb.ToString()); return(bres); }
/// <summary> /// 删除停采线信息 /// </summary> /// <param name="stoplineEntity">停采线实体</param> /// <returns>是否成功删除?true:false</returns> public static bool deleteGeologySpaceEntityInfo(GeologySpaceEntityNew geologySpaceEntity) { ManageDataBase db = new ManageDataBase(DATABASE_TYPE.MiningSchedulingDB); string sql = "DELETE FROM " + GeologySpaceDbConstNamesNew.TABLE_NAME + " WHERE " + GeologySpaceDbConstNamesNew.TECTONIC_ID + " =" + geologySpaceEntity.TectonicID + " AND " + GeologySpaceDbConstNamesNew.TECTONIC_TYPE + "=" + geologySpaceEntity.TectonicType; bool bResult = db.OperateDB(sql); return(bResult); }
/// <summary> /// 更改停采线信息 /// </summary> /// <param name="stopLineEntity">停采线实体</param> /// <returns>是否修改成功?true:false</returns> public static bool updateGeologySpaceEntityInfo(GeologySpaceEntityNew geologySpaceEntity) { ManageDataBase db = new ManageDataBase(DATABASE_TYPE.MiningSchedulingDB); StringBuilder sb = new StringBuilder(); sb.Append("UPDATE " + GeologySpaceDbConstNamesNew.TABLE_NAME + " SET " + GeologySpaceDbConstNamesNew.TECTONIC_DISTANCE + " = '"); sb.Append(geologySpaceEntity.Distance + " WHERE " + GeologySpaceDbConstNamesNew.TECTONIC_ID + "=" + geologySpaceEntity.TectonicID + " AND " + GeologySpaceDbConstNamesNew.TECTONIC_TYPE + "=" + geologySpaceEntity.TectonicType); bool bResult = db.OperateDB(sb.ToString()); return(bResult); }
/// <summary> /// 添加停采线信息 /// </summary> /// <param name="stopLineEntity">停采线实体</param> /// <returns>是否成功添加?true:false</returns> public static bool insertGeologySpaceEntityInfo(GeologySpaceEntityNew geologySpaceEntity) { ManageDataBase db = new ManageDataBase(DATABASE_TYPE.MiningSchedulingDB); StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO " + GeologySpaceDbConstNamesNew.TABLE_NAME + " ("); sb.Append(GeologySpaceDbConstNamesNew.WORKFACE_ID + ", "); sb.Append(GeologySpaceDbConstNamesNew.TECTONIC_ID + ", "); sb.Append(GeologySpaceDbConstNamesNew.TECTONIC_DISTANCE + ", "); sb.Append(GeologySpaceDbConstNamesNew.TECTONIC_TYPE + ", "); sb.Append(GeologySpaceDbConstNamesNew.DATE_TIME); sb.Append(") VALUES ("); sb.Append(geologySpaceEntity.WorkSpaceID + ","); sb.Append(geologySpaceEntity.TectonicID + ","); sb.Append(geologySpaceEntity.Distance + ","); sb.Append(geologySpaceEntity.TectonicType + ","); sb.Append(geologySpaceEntity.onDateTime + ")"); bool bResult = db.OperateDB(sb.ToString()); return(bResult); }