/// <summary>
/// Company加载数据
/// </summary>
public void CompanyBing()
{
DBClass dbclass = new DBClass();
DataSet ds = null;
string strSql = string.Empty;
strSql = "select distinct Comp from ViewGISRoute";
ds = dbclass.GetDs(strSql);
//com_Company.DataSource = ds.Tables[0];
//com_Company.DisplayMember = "Comp";
//com_Company.ValueMember = "Comp";
com_Company.Items.Insert(0,"");
//com_Company.Items.Add("");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i <ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i][0] != null)
{
com_Company.Items.Insert(i, ds.Tables[0].Rows[i][0].ToString());
}
}
}
}
private void buOk_Click(object sender, EventArgs e)
{
if (com_Company.Text == "" || com_Route.Text == "")
{
return;
}
DBClass dbclass = new DBClass();
DataSet ds = null;
string strSql = string.Empty;
strSql = "select * from ViewGISRoute where GISLatitude!=''";
string strAnd = string.Empty;
if (com_Company.Text != string.Empty)
{
strAnd = " and Comp='" + com_Company.Text + "'";
}
strSql += strAnd + " order by Seq";
ds = dbclass.GetDs(strSql);
DrawLine(ds, colors);
// ShowInformation(ds);
}
/// <summary>
/// Company加载数据
/// </summary>
public void CompanyBing()
{
DBClass dbclass = new DBClass();
DataSet ds = null;
string strSql = string.Empty;
strSql = "select distinct Comp from ViewGISRoute";
ds = dbclass.GetDs(strSql);
//com_Company.DataSource = ds.Tables[0];
//com_Company.DisplayMember = "Comp";
//com_Company.ValueMember = "Comp";
com_Company.Items.Insert(0, "");
//com_Company.Items.Add("");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i][0] != null)
{
com_Company.Items.Insert(i, ds.Tables[0].Rows[i][0].ToString());
}
}
}
}
private void com_Company_SelectedIndexChanged(object sender, EventArgs e)
{
//com_Route.Items.Insert(0, "");
DBClass dbclass = new DBClass();
DataSet ds = null;
string strSql = string.Empty;
string strAnd = string.Empty;
if (com_Company.Text != string.Empty)
{
strAnd = " and Comp='" + com_Company.Text + "'";
}
strSql = "select distinct Route from ViewGISRoute where 1=1"+strAnd;
ds = dbclass.GetDs(strSql);
com_Route.DataSource = ds.Tables[0];
com_Route.DisplayMember = "Route";
com_Route.ValueMember = "Route";
}
private void buOk_Click(object sender, EventArgs e)
{
if (com_Company.Text == "" || com_Route.Text == "")
{
return;
}
DBClass dbclass = new DBClass();
DataSet ds = null;
string strSql = string.Empty;
strSql = "select * from ViewGISRoute where GISLatitude!=''";
string strAnd = string.Empty;
if (com_Company.Text != string.Empty)
{
strAnd = " and Comp='"+com_Company.Text+"'";
}
strSql += strAnd + " order by Seq";
ds = dbclass.GetDs(strSql);
DrawLine(ds, colors);
// ShowInformation(ds);
}
