/// <summary>
/// 关闭连接
/// </summary>
/// <param name="dbManager"></param>
private void CloseOracleConnection(CDBManger dbManager)
{
if (dbManager != null)
{
dbManager.close();
}
}
/// <summary>
///
/// </summary>
/// <param name="Xmin"></param>
/// <param name="Xmax"></param>
/// <param name="Ymin"></param>
/// <param name="Ymax"></param>
/// <returns></returns>
public string getKXNameByFw(double Xmin, double Xmax, double Ymin, double Ymax)
{
CDBManger cdb = new CDBManger();
OracleDataReader odr = null;
string sql = "select kxmc from gg_kxinfo t1, gg_kxmanage t2 where t1.kx_id=t2.kx_id and t1.yx_fid=";
string gisid = "";
try
{
odr = cdb.ExecuteReader(sql);
if (odr.Read())
{
gisid = odr["kxmc"].ToString();
}
}
catch (Exception ex)
{
CYZLog.writeLog(ex.ToString(), "");
}
finally
{
CloseOracleDataReader(odr, cdb);
}
return(gisid);
}
/// <summary>
///
/// </summary>
/// <param name="GcId"></param>
/// <returns></returns>
public string GisId(string GcId)
{
string gisid = "";
OracleDataReader odr = null;
string sql = "select GCTICKET_ID from cadgis.ticketship t where t.gcticket_id='" + GcId + "'";
CDBManger cdb = new CDBManger();
try
{
odr = cdb.ExecuteReader(sql);
if (odr.Read())
{
gisid = odr["GCTICKET_ID"].ToString();
}
}
catch (Exception ex)
{
CYZLog.writeLog(ex.ToString(), "");
}
finally
{
CloseOracleDataReader(odr, cdb);
}
return(gisid);
}
/// <summary>
/// 获取用户名和密码和区局配置
/// </summary>
/// <param name="GcId"></param>
/// <param name="username"></param>
/// <param name="password"></param>
/// <param name="qjpz"></param>
public static void GetUserNamePwd(string GcId, ref string username, ref string password, ref string qjpz)
{
CDBManger dbm = null;
try
{
dbm = new CDBManger();
string sql = "select GCUSERNAME from cadgis.ticketship where GCTICKET_ID='" + GcId + "'";
DataTable dt_ticketship = dbm.ExecuteTable(sql);
if (dt_ticketship != null && dt_ticketship.Rows.Count > 0)
{
username = dt_ticketship.Rows[0]["GCUSERNAME"].ToString();
}
else
{
username = null;
password = null;
qjpz = null;
}
if (!string.IsNullOrEmpty(username))
{
sql = "SELECT password_out(QX_YH_MM) FROM GG_XT_QX_YH where QX_YH_MC='" + username + "'";
DataTable dt_ticketship2 = dbm.ExecuteTable(sql);
if (dt_ticketship2 != null && dt_ticketship2.Rows.Count > 0)
{
password = dt_ticketship2.Rows[0][0].ToString();
}
}
if (!string.IsNullOrEmpty(username))
{
StringBuilder sb = new StringBuilder("");
sb.Append("select m.XT_BM_CONFIGURAN from gg_xt_bm_dzhyj m");
sb.Append(" where m.XT_BM_MC in (");
sb.Append(" SELECT b.qx_zzjg_mc ");
sb.Append(" FROM GG_XT_QX_YH a,GG_XT_QX_ZZJG b ");
sb.Append(" where a.qx_yh_ejdw=b.qx_zzjg_ejdw ");
sb.Append(" and upper(a.qx_yh_mc)='" + username + "' and b.qx_zzjg_mc in (select x.xt_bm_mc from gg_xt_bm_dzhyj x ))");
DataTable dt_ticketship3 = dbm.ExecuteTable(sb.ToString());
if (dt_ticketship3 != null && dt_ticketship3.Rows.Count > 0)
{
qjpz = dt_ticketship3.Rows[0]["XT_BM_CONFIGURAN"].ToString();
}
}
}
catch (Exception ex)
{
throw;
}
finally
{
if (dbm != null)
{
dbm.close();
}
}
}
/// <summary>
/// 关闭OracleDataReader
/// </summary>
/// <param name="odr"></param>
/// <param name="dbManager"> </param>
private void CloseOracleDataReader(OracleDataReader odr, CDBManger dbManager)
{
if (odr != null)
{
odr.Close();
}
if (dbManager != null)
{
dbManager.close();
}
}
public string DisableAllTicket()
{
string ss = "";
CDBManger dbm = null;
try
{
dbm = new CDBManger();
DataTable dt = dbm.ExecuteTable("select distinct t.gcticket_id from cadgis.ticketship t");
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string GC_ID = dt.Rows[i][0].ToString();
CYZLog.writeLog("DisableTicket1(" + GC_ID + ")");
if (TickHelper.qxtick1(GC_ID))
{
ss = "TRUE";
}
Thread.Sleep(1000);
}
}
}
catch (Exception ex)
{
CYZLog.writeLog(ex.ToString(), "");
ss = "ERROR:" + ex;
}
finally
{
if (dbm != null)
{
dbm.close();
}
}
CYZLog.writeLog("End DisableTicket; return " + ss);
return(ss);
}
/// <summary>
/// 得到生命周期
/// </summary>
/// <param name="GcId"></param>
/// <param name="GisTick"></param>
/// <returns></returns>
public string Smzq(string GcId, ref string GisTick)
{
string StrSmzq = "";
CDBManger cdb = new CDBManger();
OracleDataReader OdReader = null;
try
{
string sql = "select LTT_NAME,gisticket_id from cadgis.ticketship where GCTICKET_ID='" + GcId + "'";
OdReader = cdb.ExecuteReader(sql);
if (OdReader.Read())
{
StrSmzq = OdReader["LTT_NAME"].ToString();
GisTick = OdReader["gisticket_id"].ToString();
}
}
finally
{
CloseOracleDataReader(OdReader, cdb);
}
return(StrSmzq);
}
/// <summary>
/// 主要锁定依附与房的开关柜
/// </summary>
/// <param name="GC_FNOFIDS">需要开工单锁定的设备fno,fid组。如:{"148,123456","140,654321","156,789546"}</param>
public void LockKgg(ref List <string> GC_FNOFIDS)
{
string ss = "";
CDBManger dbm = null;
StringBuilder sb = new StringBuilder("");
OracleDataReader Oredder = null;
try
{
dbm = new CDBManger();
foreach (string s in GC_FNOFIDS)
{
ss += s.Split(',')[1] + ",";
}
if (ss != "")
{
ss = ss.Substring(0, ss.Length - 1);
sb.Append("select g3e_fno,g3e_fid from b$Gg_pd_kgg_n where g3e_fid in( ");
sb.Append(" select g3e_fid from b$common_n where g3e_fno=198 and owner1_id in( ");
sb.Append(" select g3e_id from b$common_n where g3e_fid in (" + ss + ")))");
Oredder = dbm.ExecuteReader(sb.ToString());
while (Oredder.Read())
{
string Fnofid = Oredder["g3e_fno"].ToString();
Fnofid += "," + Oredder["g3e_fid"];
GC_FNOFIDS.Add(Fnofid);
Fnofid = "";
}
}
}
catch (Exception ex)
{
CYZLog.writeLog(ex.ToString());
}
finally
{
CloseOracleDataReader(Oredder, dbm);
}
}
/// <summary>
/// 主要锁定依附与集抄的户表
/// </summary>
public void LockHb(ref List <string> GC_FNOFIDS)
{
string ss = "";
CDBManger dbm = null;
StringBuilder sb = new StringBuilder("");
OracleDataReader Oredder = null;
try
{
dbm = new CDBManger();
foreach (string s in GC_FNOFIDS)
{
ss += s.Split(',')[1] + ",";
}
if (ss != "")
{
ss = ss.Substring(0, ss.Length - 1);
sb.Append("select * from b$gg_jx_shbd_pt t where t.g3e_detailid in( ");
sb.Append(" select a.g3e_detailid from b$detailreference_n a where a.g3e_fid in (" + ss + "))");
Oredder = dbm.ExecuteReader(sb.ToString());
while (Oredder.Read())
{
string Fnofid = Oredder["g3e_fno"].ToString();
Fnofid += "," + Oredder["g3e_fid"];
GC_FNOFIDS.Add(Fnofid);
Fnofid = "";
}
}
}
catch (Exception ex)
{
CYZLog.writeLog(ex.ToString());
}
finally
{
CloseOracleDataReader(Oredder, dbm);
}
}
public string UpLoadAppend(string AppendFile, string GC_ID)
{
string ss = "TRUE";
int SjBVerion = 0;
string smzq = "";
bool bbreval = false;
string UserName = "";
string PassWord = "";
string QjPz = "";
CDBManger cdm = null;
try
{
DateTime appenshiptime = DateTime.Now;
CYZLog.writeLog("UpLoadAppend(" + AppendFile + "," + GC_ID + ")");
string gistick = "";
smzq = Smzq(GC_ID, ref gistick);
if (smzq == "")
{
return("工单不存在。");
}
bbreval = false;
var xmldb = new XmlDBManager();
xmldb.FileName = Application["dataappendpath"] + GC_ID + "\\" + AppendFile.Substring(AppendFile.LastIndexOf("/") + 1, AppendFile.Length - AppendFile.LastIndexOf("/") - 1);
xmldb.Initialize();
if (xmldb.Count() <= 0)
{
CYZLog.writeLog("数据格式不正确");
return("数据格式不正确请重新导出");
}
int ZlVerion = -1;
var CadV = xmldb.GetEntity <CadVersion>(o => o.G3E_FID == 1); //这个版本号是从增量文件得到的
ZlVerion = CadV.Version;
//对比tickship里面的版本号
cdm = new CDBManger();
GetUserNamePwd(GC_ID, ref UserName, ref PassWord, ref QjPz);
if (string.IsNullOrEmpty(UserName) || string.IsNullOrEmpty(PassWord) || string.IsNullOrEmpty(QjPz))
{
CYZLog.writeLog("账号或密码不存在");
return("账号或密码不存在");
}
var oracledb = new OracleDBManager {
UserName = UserName, Password = PassWord
};
//var oracledb = new OracleDBManager();
string str = "select VERSION from cadgis.appendship t where t.gcticket_id='" + GC_ID + "'";
DataTable tab = cdm.ExecuteTable(str);
if (tab != null && tab.Rows.Count > 0)
{
SjBVerion = int.Parse(tab.Rows[0][0].ToString());
if (ZlVerion == 1 || SjBVerion == 1)//数据库的版本等于1是说明这个数据从来没有到过直接按原来的导入即使是导过一次版本都等于1也是要撤销重新导入的
{
if (!TickHelper.qxtick1(GC_ID, UserName, PassWord, QjPz))
{
return("FALSE");
}
OnceImport(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
}
else
{
if (ZlVerion <= SjBVerion)
{
if (!TickHelper.qxtick1(GC_ID, UserName, PassWord, QjPz))
{
return("FALSE");
} //发现增量文件版本低与tickship里面的版本号,就撤销工单.
OnceImport(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
}
else//如果要导入的版本高于数据库的版本执行下面的导入
{
TwoImport(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
}
}
}
else
{
if (!TickHelper.qxtick1(GC_ID, UserName, PassWord, QjPz))
{
return("FALSE");
}
OnceImport(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
}
if (cdm != null)
{
cdm.close();
}
//增量的增删改
//更新公共属性表里面的从属关系
UploadEventHandler.COMMON_N(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
CYZLog.writeLog("End 更新公共属性表里面的从属关系");
UploadEventHandler.GG_PD_GNWZMC_N(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
CYZLog.writeLog("End 更新功能位置表");
//更新计量表坐标的
UploadEventHandler.UploadGg_jx_jlb_pt_sdogeom(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
CYZLog.writeLog("End 更新计量表坐标的");
//更新户表坐标的
UploadEventHandler.UploadGg_jx_shbd_pt_sdogeom(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
CYZLog.writeLog("End 更新户表坐标的");
// UploadEventHandler.UploadGg_gl_zxbz_n(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
CYZLog.writeLog("End 更新杂项标注");
UploadEventHandler.UpLoadGg_gz_tj_n(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
CYZLog.writeLog("End 更新杂项标注");
UploadEventHandler.UpLoadGg_pd_cbx_n(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
CYZLog.writeLog("End 更新集抄所属变压器");
UploadEventHandler.UpGg_pd_dykg_n(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
CYZLog.writeLog("End 更新低压开关所属变压器");
UploadEventHandler.UpGg_jc_pwy_n(oracledb, xmldb, GC_ID, smzq, appenshiptime, QjPz);
CYZLog.writeLog("End 更新配网仪所属变压器");
//修改所有新增修改删除数据的版本
cdm = new CDBManger();
string strSql = "update cadgis.ticketship set version=" + ZlVerion + " where gcticket_id='" + GC_ID + "'";
string strSql2 = "update cadgis.appendship set version=" + ZlVerion + " where gcticket_id='" + GC_ID + "'";
string StrSql3 = "update cadgis.appendfidship set version=" + ZlVerion + " where gcticket_id='" + GC_ID + "'";
cdm.ExecuteNonQuery(strSql);
cdm.ExecuteNonQuery(strSql2);
cdm.ExecuteNonQuery(StrSql3);
TickHelper.SxSj(smzq, QjPz, UserName, PassWord);
string tzdz = Application["dataappendpath"] + GC_ID;
string filename = null;
GetAllDbFiles(tzdz, ref filename);
//上传生产的增量
TZInterface.UpLoadTZData(gistick.ToString(),
System.Web.HttpUtility.UrlEncode(Application["dataftppath"].ToString().Replace("export", "import") + GC_ID + "/" + filename, Encoding.UTF8).Replace("%", "<M>")
);
}
catch (Exception ex)
{
bbreval = false;
ss = ex.ToString();
CYZLog.writeLog(ex.ToString());
}
finally
{
if (cdm != null)
{
cdm.close();
}
}
CYZLog.writeLog("End UpLoadAppend");
return(ss);
}
