private void BindDataGrid()
{
tb = Utility.ExecuteSql4Ds(strSelectSQL).Tables[0];
DataView dv = tb.DefaultView;
//向视图应用过滤信息（先过滤）
if (ViewState["strFilter"] != null)
{
dv.RowFilter = ViewState["strFilter"].ToString().Trim();
}
//向视图应用排序信息（再排序）
if (ViewState["SortExpression"] != null)
{
dv.Sort = ViewState["SortExpression"].ToString().Trim();
}
//重新绑定数据
DataGrid1.DataSource = dv;
//在当前页排序,排序后仍然在当前页（最后确定显示哪一页）
if (ViewState["NowPage"] != null)
{
DataGrid1.CurrentPageIndex = int.Parse(ViewState["NowPage"].ToString().Trim());
}
try
{
DataGrid1.DataBind();
}
catch //比如查询时过滤掉了很多,ViewState["NowPage"]中保存的页数已经偏大
{
DataGrid1.CurrentPageIndex = DataGrid1.PageCount - 1;
DataGrid1.DataBind();
}
}
private void BindGrid()
{
DataView MyDv;
string sWhere = "";
string sSel = Utility.GetParam("paID");
sTable = Utility.Dlookup("bm_bm", "tableName", "id=" + sSel);//("CarBarn", "count(*)", sExist);
f1 = Utility.Dlookup("bm_bm", "f1", "id=" + sSel);
f2 = Utility.Dlookup("bm_bm", "f2", "id=" + sSel);
f1.Trim();
f2.Trim();
sTable.Trim();
String strsql;
DataSet myDs;
strsql = "select "
+ f1 + " as id,"
+ f2 + " as Name " + " from " + sTable;
//strsql="select top 10 meterReading.mrID,meterReading.mrYear from MeterReading order by sales DESC";
strsql += sWhere;
myDs = Utility.ExecuteSql4Ds(strsql);
MyDv = myDs.Tables[0].DefaultView;
if (!object.Equals(ViewState["Sort"], null))
{
MyDv.Sort = ViewState["Sort"].ToString();
}
DataGrid1.DataSource = MyDv;
if (!object.Equals(ViewState["Page"], null))
{
DataGrid1.CurrentPageIndex = int.Parse(ViewState["Page"].ToString());
}
try
{
DataGrid1.DataBind();
}
catch
{
DataGrid1.CurrentPageIndex = DataGrid1.PageCount - 1;
DataGrid1.DataBind();
}
}
private void GridBind()
{
DataView MyDv;
String strsql;
DataSet myDs;
strsql = "select [p].[paName]," +
"[h].[hoRoom], " +
"[t].[taName], " +
"[m].[mrID] as id, " +
"[m].[mrYear], " +
"[m].[mrMonth1], " +
"[m].[mrMonth2], " +
"[m].[mrPreceding], " +
"[m].[mrCurrent], " +
"[m].[mrNumber] " +
" from (( ([MeterReading] m inner join [Pavilion] p on [m].[paID]=[p].[paID]) " +
" inner join [House] h on [m].[hoID]=[h].[hoID]) " +
" inner join [Tariff] t on [m].[taID]=[t].[taID])";
//strsql="select top 10 meterReading.mrID,meterReading.mrYear from MeterReading order by sales DESC";
myDs = Utility.ExecuteSql4Ds(strsql);
MyDv = myDs.Tables[0].DefaultView;
if (!object.Equals(ViewState["Sort"], null))
{
MyDv.Sort = ViewState["Sort"].ToString();
}
dg_Meter.DataSource = MyDv;
if (!object.Equals(ViewState["Page"], null))
{
dg_Meter.CurrentPageIndex = int.Parse(ViewState["Page"].ToString());
}
try
{
dg_Meter.DataBind();
}
catch
{
dg_Meter.CurrentPageIndex = dg_Meter.PageCount - 1;
dg_Meter.DataBind();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
Utility = new CCUtility(this);
if (!IsPostBack)
{
theID.Value = Utility.GetParam("ID");
InitDropDownList();
if (theID.Value.Trim() != "")
{
strSQL = "select * from shebei_mingxi where id=' " + theID.Value.Trim() + " '";
tb = Utility.ExecuteSql4Ds(strSQL).Tables[0];
if (tb.Rows.Count > 0)
{
ControlDataBind();
}
}
}
}
private void GridBind()
{
DataView MyDv;
String strsql;
DataSet myDs;
strsql = "select [p].[paID] as ID," +
"[p].*," +
"[t].[Name] as typeName," +
"[s].[Name] as sunny" +
" from (([Pavilion] p inner join [BM_PavilionType] t on [p].[typeID]=[t].[typeID]) " +
" inner join [bm_Sunny] s on [p].[sunnyID]=[s].[id])";
//strsql="select top 10 meterReading.mrID,meterReading.mrYear from MeterReading order by sales DESC";
myDs = Utility.ExecuteSql4Ds(strsql);
MyDv = myDs.Tables[0].DefaultView;
if (!object.Equals(ViewState["Sort"], null))
{
MyDv.Sort = ViewState["Sort"].ToString();
}
DataGrid1.DataSource = MyDv;
if (!object.Equals(ViewState["Page"], null))
{
DataGrid1.CurrentPageIndex = int.Parse(ViewState["Page"].ToString());
}
try
{
DataGrid1.DataBind();
}
catch
{
DataGrid1.CurrentPageIndex = DataGrid1.PageCount - 1;
DataGrid1.DataBind();
}
}
private void GridBind()
{
string sWhere = "";
bool HasParam = false;
//-------------------------------
// Build WHERE statement
//-------------------------------
System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary();
if (!Params.ContainsKey("search"))
{
string temp = Utility.GetParam("search");
Params.Add("search", temp);
}
if (Params["search"].Length > 0)
{
HasParam = true;
sWhere = "[m].[name] like '%" + Params["search"].Replace("'", "''") + "%'";
}
if (HasParam)
{
sWhere = " WHERE (" + sWhere + ")";
}
DataView MyDv;
String strsql;
DataSet myDs;
strsql = "select " +
"[m].[name], " +
"[m].[memo], " +
"[m].[member_id] as ID, " +
"[m].[member_login] as m_member_login, " +
"[s].[Name] as m_security_level_id " +
" from ([members] m inner join [bm_sLevel] s on [m].[security_level_id]=[s].[id])";
//strsql="select top 10 meterReading.mrID,meterReading.mrYear from MeterReading order by sales DESC";
strsql += sWhere;
myDs = Utility.ExecuteSql4Ds(strsql);
MyDv = myDs.Tables[0].DefaultView;
if (!object.Equals(ViewState["Sort"], null))
{
MyDv.Sort = ViewState["Sort"].ToString();
}
DataGrid1.DataSource = MyDv;
if (!object.Equals(ViewState["Page"], null))
{
DataGrid1.CurrentPageIndex = int.Parse(ViewState["Page"].ToString());
}
try
{
DataGrid1.DataBind();
}
catch
{
DataGrid1.CurrentPageIndex = DataGrid1.PageCount - 1;
DataGrid1.DataBind();
}
}
private void GridBind()
{
string sWhere = "";
bool HasParam = false;
//-------------------------------
// Build WHERE statement
//-------------------------------
System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary();
if (!Params.ContainsKey("paID"))
{
string temp = Utility.GetParam("paID");
if (Utility.IsNumeric(null, temp) && temp.Length > 0)
{
temp = CCUtility.ToSQL(temp, FieldTypes.Number);
}
else
{
temp = "";
}
Params.Add("paID", temp);
}
if (!Params.ContainsKey("search"))
{
string temp = Utility.GetParam("search");
Params.Add("search", temp);
}
if (Params["paID"].Length > 0)
{
HasParam = true;
sWhere += "H.[paID]=" + Params["paID"];
}
if (Params["search"].Length > 0)
{
if (sWhere.Length > 0)
{
sWhere += " and ";
}
HasParam = true;
sWhere += "H.[hoRoom] like '%" + Params["search"].Replace("'", "''") + "%'";
}
if (HasParam)
{
sWhere = " WHERE (" + sWhere + ")";
}
DataView MyDv;
String strsql;
DataSet myDs;
strsql = "select [h].[hoID] as ID," +
"[h].*," +
"[I].[Name] as IndoorName," +
"[c].[Name] as CellName," +
"[s].[Name] as sunnyName " +
" from ((([House] h inner join [bm_Indoor] I on [h].[indoorID]=[I].[ID]) " +
" inner join [bm_cell] c on [h].[cellID]=[c].[ID])" +
" inner join [bm_Sunny] s on [h].[sunnyID]=[s].[ID])";
//strsql="select top 10 meterReading.mrID,meterReading.mrYear from MeterReading order by sales DESC";
if (!HasParam)
{
sWhere = " where hoID=-1";
}
strsql += sWhere;
myDs = Utility.ExecuteSql4Ds(strsql);
MyDv = myDs.Tables[0].DefaultView;
if (!object.Equals(ViewState["Sort"], null))
{
MyDv.Sort = ViewState["Sort"].ToString();
}
DataGrid1.DataSource = MyDv;
if (!object.Equals(ViewState["Page"], null))
{
DataGrid1.CurrentPageIndex = int.Parse(ViewState["Page"].ToString());
}
try
{
DataGrid1.DataBind();
}
catch
{
DataGrid1.CurrentPageIndex = DataGrid1.PageCount - 1;
DataGrid1.DataBind();
}
}
private void GridBind()
{
string sWhere = "";
bool HasParam = false;
//-------------------------------
// Build WHERE statement
//-------------------------------
System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary();
if (!Params.ContainsKey("Master"))
{
string temp = Utility.GetParam("Master");
Params.Add("Master", temp);
}
if (!Params.ContainsKey("search"))
{
string temp = Utility.GetParam("search");
Params.Add("search", temp);
}
if (Params["Master"].Length > 0)
{
HasParam = true;
sWhere += "[c].[Master] like '%" + Params["Master"].Replace("'", "''") + "%'";
}
if (Params["search"].Length > 0)
{
if (sWhere.Length > 0)
{
sWhere += " and ";
}
HasParam = true;
sWhere += "[c].[theNO]='" + Params["search"].Replace("'", "''") + "'";
}
if (HasParam)
{
sWhere = " WHERE (" + sWhere + ")";
}
DataView MyDv;
String strsql;
DataSet myDs;
strsql = "select c.* from carbarn c"; //+
//" from carbarn ";
//strsql="select top 10 meterReading.mrID,meterReading.mrYear from MeterReading order by sales DESC";
strsql += sWhere;
myDs = Utility.ExecuteSql4Ds(strsql);
MyDv = myDs.Tables[0].DefaultView;
if (!object.Equals(ViewState["Sort"], null))
{
MyDv.Sort = ViewState["Sort"].ToString();
}
DataGrid1.DataSource = MyDv;
if (!object.Equals(ViewState["Page"], null))
{
DataGrid1.CurrentPageIndex = int.Parse(ViewState["Page"].ToString());
}
try
{
DataGrid1.DataBind();
}
catch
{
DataGrid1.CurrentPageIndex = DataGrid1.PageCount - 1;
DataGrid1.DataBind();
}
}
