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