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