void IAttributeQuery.Excute()
{
//*************
//Lay connection info hien tai
//SdeUserInfo va SqlUserInfo la static
SdeConnection conn = new SdeConnection();
ISdeConnectionInfo sdeConn = conn as ISdeConnectionInfo;
ISqlConnectionInfo sqlConn = (ISqlConnectionInfo)sdeConn;
_sqlUser = sqlConn.GetSqlUserInfo();
SqlDataReader reader = null;
QueryEventArg e = new QueryEventArg();
try
{
if (_sqlTable.IsClosed())
{
_sqlTable.SetUserInfo(_sqlUser.GetConnectionStringAsArray());
_sqlTable.OpenConnection();
}
reader = _sqlTable.GetSqlCommand(_sql).ExecuteReader();
//MessageBox.Show("line 49 Loader: --" + reader.HasRows.ToString() + "--" + _sql);
//_pair.ClearPair();
foreach (IAttributeQueryView r in _views)
{
r.ReceiveResult(reader,EnumTypeOfResult.Thua);
}
reader.Close();
_sqlTable.CloseConnection();
onFinished(e);
}
catch (Exception e1)
{
if (reader != null)
{
reader.Close();
}
_sqlTable.CloseConnection();
//MessageBox.Show("line 67 - Loader \n" + e1.ToString());
}
}
void _bwk_DoWork(object sender, DoWorkEventArgs e)
{
SdeConnection conn = new SdeConnection();
ISdeConnectionInfo sdeConn = conn as ISdeConnectionInfo;
//ISqlConnectionInfo sqlConn = (ISqlConnectionInfo)sdeConn;
ISdeUserInfo sdeUser = sdeConn.GetSdeUserInfo();
_fcName = new TnFeatureClassName(sdeConn.Workspace);
_tblName = new TnTableName(sdeConn.Workspace);
_sqlUser = sdeUser.GetSqlUserInfo();
SqlDataReader reader = null;
SqlDataAdapter adapter = null;
DataSet dataSet = new DataSet();
QueryEventArg qrEvt = new QueryEventArg();
_nameOfThua = String.Format("{0}_{1}", DataNameTemplate.Thua, _config.NamApDung);
if (_sqlTable.IsClosed())
{
_sqlTable.SetUserInfo(_sqlUser.GetConnectionStringAsArray());
_sqlTable.OpenConnection();
}
int t = 0;
bool rs = int.TryParse(_type.ToString(), out t);
if (!rs)
{
t = 0;
}
IInfoForQuerySql infoSql = (IInfoForQuerySql)_info;
string selectSql = string.Format("select * from {0} where ",_nameOfThua);
string whereClause = "";
List<string> lstSql = new List<string>();
string maxa = "0";
int c = 0;
switch (t)
{
//truy van uniq, so to,so thua,dia chi,ten chu
case 0:
#region Tim uniq
//kiem tra 1 trong cac gia tri sau
//xa,chusohuu,dia chi,soto,sothua
//neu ="" thi bo qua, neu ko thi them vao sql and
qrEvt.Data = "Đang tìm ...";
onQuerying(qrEvt);
if (_info.Xa != "")
{
//tim trong bang xa, lay ma xa theo ten xa
#region tim ma xa
string sqlxa = "";
sqlxa = string.Format("select maxa from {0} where {1}",DataNameTemplate.Ranh_Xa_Poly, infoSql.XaSql);
//adapter = new SqlDataAdapter(_sqlTable.GetSqlCommand(sqlxa));
//adapter.Fill(dataSet);
reader = _sqlTable.GetSqlCommand(sqlxa).ExecuteReader();
if (reader != null)
{
if (reader.HasRows)
{
//lay 1 ma xa
if (reader.Read())
{
maxa = reader.GetValue(0).ToString();
//MessageBox.Show(String.Format("line 119 QueryThua {0}", maxa));
}
}
}
else
{
maxa = "0";
}
reader.Close();
#endregion
//tim cac thua
lstSql.Add(string.Format("{0}='{1}'", _fcName.FC_THUA.MA_XA, maxa));
}
if (_info.ChuSoHuu != "")
{
lstSql.Add(string.Format(infoSql.ChuSoHuuSql));
}
if (_info.DiaChi != "")
{
lstSql.Add(string.Format(infoSql.DiaChiSql));
}
if (_info.SoTo != "")
{
lstSql.Add(string.Format(infoSql.SoToSql));
}
if (_info.SoThua != "")
{
lstSql.Add(string.Format(infoSql.SoThuaSql));
}
if (_info.MaThua != "")
{
lstSql.Add(string.Format(infoSql.MaThuaSql));
}
//ghep cac sql
//c = lstSql.Count;
//if (c > 0)
//{
// whereClause += string.Format("{0}", lstSql[0]);
// for (int i = 1; i < c; i++)
// {
// whereClause += string.Format(" and {0}", lstSql[i]);
// }
// selectSql = selectSql + whereClause;
// adapter = new SqlDataAdapter(_sqlTable.GetSqlCommand(selectSql));
// adapter.Fill(dataSet);
// //MessageBox.Show(selectSql);
// //reader = _sqlTable.GetSqlCommand(whereClause).ExecuteReader();
// //if (reader.HasRows)
// //{
// foreach (IQueryThuaView v in _views)
// {
// v.GetResult(dataSet);
// }
// //}
// //reader.Close();
//}
//qrEvt.Data = "Đã tìm xong";
//onFinished(qrEvt);
break;
#endregion
//tim theo loai dat,so mat tien,..
case 1:
#region tim theo loai dat,...
//xet loai dat de biet xet trong bang gia dat nao
if (_info.LoaiDat != "")
{
lstSql.Add(string.Format(infoSql.LoaiDatSql));
}
if (_info.SoMatTien != "")
{
lstSql.Add(string.Format(infoSql.SoMatTienSql));
}
if (_info.SoTo != "")
{
lstSql.Add(string.Format(infoSql.SoToSql));
}
if (_info.SoThua != "")
{
lstSql.Add(string.Format(infoSql.SoThuaSql));
}
#endregion
break;
case 2:
//tim theo vi tri
#region tim theo vi tri
#endregion
break;
case 3:
//tim theo dien tich
#region tim theo dien tich
if (_info.DienTich != "")
{
lstSql.Add(string.Format(infoSql.DienTichSql));
}
#endregion
break;
default:
break;
}
c = lstSql.Count;
if (c > 0)
{
whereClause += string.Format("{0}", lstSql[0]);
for (int i = 1; i < c; i++)
{
whereClause += string.Format(" and {0}", lstSql[i]);
}
selectSql = selectSql + whereClause;
adapter = new SqlDataAdapter(_sqlTable.GetSqlCommand(selectSql));
adapter.Fill(dataSet);
//MessageBox.Show(selectSql);
//reader = _sqlTable.GetSqlCommand(whereClause).ExecuteReader();
//if (reader.HasRows)
//{
foreach (IQueryThuaView v in _views)
{
v.GetResult(dataSet);
}
//}
//reader.Close();
}
qrEvt.Data = "Đã tìm xong";
onFinished(qrEvt);
_sqlTable.CloseConnection();
}
void IUserInfoController.SetModel(ISqlUserInfo userInfo)
{
throw new NotImplementedException();
}
void ILoader.Load(EnumG1ArcGisTnRecType type)
{
//*************
//Lay connection info hien tai
//SdeUserInfo va SqlUserInfo la static
SdeConnection conn = new SdeConnection();
ISdeConnectionInfo sdeConn = conn as ISdeConnectionInfo;
ISdeUserInfo sdeUser = sdeConn.GetSdeUserInfo();
//ISqlConnectionInfo sqlConn = (ISqlConnectionInfo)sdeConn;
//MessageBox.Show(sqlConn.GetSqlUserInfo().UserName);
_sqlUser = sdeUser.GetSqlUserInfo();
SqlDataReader reader = null;
//_pair = new XPair();
LoaderEventArg e=new LoaderEventArg(type);
//MessageBox.Show(string.Format("line 39 Loader:--{0}, so luong view:{1}", _sql, _lstView.Count));
try
{
if (_sqlTable.IsClosed())
{
_sqlTable.SetUserInfo(_sqlUser.GetConnectionStringAsArray());
//MessageBox.Show(String.Format("line 59 Loader, ConnectionString={0}", _sqlUser.GetConnectionString()));
_sqlTable.OpenConnection();
}
reader = _sqlTable.GetSqlCommand(_sql).ExecuteReader();
//MessageBox.Show("line 49 Loader: --" + reader.HasRows.ToString() + "--" + _sql);
//_pair.ClearPair();
foreach (IReceiverView r in _lstView)
{
r.ReceiveData(reader,type);
}
reader.Close();
_sqlTable.CloseConnection();
onFinished(e);
}
catch (Exception e1)
{
if (reader != null)
{
reader.Close();
}
_sqlTable.CloseConnection();
//MessageBox.Show("line 67 - Loader \n" + e1.ToString());
}
}
public SdeConnection(ISdeUserInfo sdeUser)
{
//_workspace = null;
_sdeUser = sdeUser;
_sqlUser = sdeUser.GetSqlUserInfo();
}
