/// <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> //public DatabaseManagement() //{ // InitializeComponent(); //} /// <summary> /// 带参数的构造方法 /// </summary> public DatabaseManagement(LibDatabase.DATABASE_TYPE type) { InitializeComponent(); db = new ManageDataBase(type); // 服务器名称或IP this.txtServerNameOrIP.Text = db.DataSource.ToString(); // 数据库名 this.txtDataBaseName.Text = db.DataBase.ToString(); // 登录名 this.txtLoginName.Text = db.strID.ToString(); // 登录密码 this.txtPassword.Text = db.strPW.ToString(); }
/// <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; }
/// <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 selectStopLineName(string stopLineName) { ManageDataBase db = new ManageDataBase(DATABASE_TYPE.GeologyMeasureDB); string sql = "SELECT * FROM " + StopLineDbConstNames.TABLE_NAME + " WHERE " + StopLineDbConstNames.STOP_LINE_NAME + " = '" + stopLineName+"'"; DataSet ds = db.ReturnDS(sql); if (ds.Tables[0].Rows.Count > 0) { return true; } else { return false; } }
/// <summary> /// 分页用返回停采区所有信息 /// </summary> /// <returns>分页用停采区所有信息</returns> public static DataSet selectStopLineInfo(int iStartIndex, int iEndIndex) { ManageDataBase db = new ManageDataBase(DATABASE_TYPE.GeologyMeasureDB); StringBuilder sb = new StringBuilder(); sb.Append("SELECT * FROM ( "); sb.Append("SELECT ROW_NUMBER() OVER(ORDER BY " + StopLineDbConstNames.ID + ") AS rowid, * "); sb.Append("FROM " + StopLineDbConstNames.TABLE_NAME + " ) AS TB "); sb.Append("WHERE rowid >= " + iStartIndex); sb.Append("AND rowid <= " + iEndIndex); DataSet ds = db.ReturnDS(sb.ToString()); return ds; }