public void QueryYongHuguanli(object obj)
{
tableList.Clear();
_tableListTemp.Clear();
_guliyuanList.Clear();
WorkServer.QueryTable(MakeQuerySql(null), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate), true);
}
public void QueryShebeiguanli(object obj)
{
_queryEnum = OperateEnum.OperateEnum_QueryDevice;
_tableListTemp.Clear();
tableList.Clear();
WorkServer.QueryTable(MakeQuerySql(obj), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate));
}
public void QueryYingshebiao(object obj)
{
_yingshelList.Clear();
cardstatus.Clear();
businesstype.Clear();
certificateType.Clear();
WorkServer.QueryTable("select * from Yingshebiao", Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate), true);
cardstatus.Add("全部");
businesstype.Add("全部");
certificateType.Add("全部");
foreach (KeyValuePair <int, string> kvp0 in _yingshelList)
{
if (kvp0.Key >= 7000 && kvp0.Key < 8000)
{
cardstatus.Add(kvp0.Value);
}
if (kvp0.Key >= 4000 && kvp0.Key < 5000)
{
businesstype.Add(kvp0.Value);
}
if (kvp0.Key >= 5000 && kvp0.Key < 6000)
{
devicePosition.Add(kvp0.Value);
}
if (kvp0.Key >= 9000 && kvp0.Key < 9011)
{
certificateType.Add(kvp0.Value);
}
}
}
private void Query(object obj)
{
status = "";
tableList0.Clear();
string sql = "select * from " + tableName;
WorkServer.QueryTable(sql, Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate));
}
public void DoLogon()
{
city.Clear();
ju.Clear();
danwei.Clear();
deviceList.Clear();
_tableListTemp.Clear();
tableList.Clear();
WorkServer.QueryTable(MakeQuerySql(null), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate), true);
}
public void QueryShebeiguanli(object obj)
{
city.Clear();
ju.Clear();
danwei.Clear();
deviceList.Clear();
_tableListTemp.Clear();
tableList.Clear();
WorkServer.QueryTable(MakeQuerySql(obj), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate));
}
public void Query(object obj)
{
tableList.Clear();
_tableListTemp.Clear();
WorkServer.QueryTable(MakeQuerySql(obj), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate));
}
private void Statistics(object obj)
{
WorkServer.QueryTable(MakeStatisticsQuerySql(obj), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate), true);
}
public void QueryHistogramChartData(object obj)
{
_queryoperate = QueryOperate.QueryOperate_HistogramChart;
WorkServer.QueryTable(MakeHistogramChartQuerySql(obj), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate), true);
}
public void QueryGuanLiCiShu(object obj)
{
_queryoperate = QueryOperate.QueryOperate_GuanLiCnt;
WorkServer.QueryTable(MakeGuanLiCiShuQuerySql(obj), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate), true);
}
public void QueryTaiWanWangLai(object obj)
{
_queryoperate = QueryOperate.QueryOperate_Taiwan;
WorkServer.QueryTable(MakeTaiWanWangLaiCurMonthQuerySql(obj), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate), true);
}
public void QueryBenyuebanliyewu(object obj)
{
_queryoperate = QueryOperate.QueryOperate_Yewu;
WorkServer.QueryTable(MakeBenyuebanliyewuCurMonthQuerySql(obj, new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0)), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate), true);
}
public void QueryShebeiguzhang(object obj)
{
_queryoperate = QueryOperate.QueryOperate_Guzhang;
WorkServer.QueryTable(MakeShebeiguzhangCurMonthQuerySql(obj), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate), true);
}
public void QueryRuanjianbao(object obj)
{
_queryEnum = OperateEnum.OperateEnum_QueryUpgrade;
ruanjianList.Clear();
WorkServer.QueryTable("Select Bianhao as Bianhao,Banbenhao as Banbenhao From Ruanjianbao", Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate), false);
}
public void Statistics(object obj)
{
_queryoperate = QueryOperate.QueryOperate_LineChart;
WorkServer.QueryTable(MakeStatisticsQuerySql(obj), Marshal.GetFunctionPointerForDelegate(_querytablecallbackdelegate), true);
}