📄 commreport.aspx.cs
字号:
thr.Visible=true;
thr.BackColor =Color.FromArgb(225,240,252) ;
ht.Rows.Add(thr);
}
}
}
////////// //*************************************增加下拉框级联处理**************************
////////// //update by zhouys 2006/02/11
////////// // if(ViewState["act"].ToString()=="C") //如果是第一次进入
////////// // {
////////// for(int cnt=0;cnt<hasht.Count;cnt++)
////////// {
////////// string str_col=((Hashtable)hasht[cnt])["NAME_EN"].ToString();
////////// string str_tmp=db.Judge_Fkey_IsRec(tablename,str_col);
////////// string ptab;
////////// Hashtable hs_sub=new Hashtable();
////////// if(str_tmp==null||str_tmp=="")//如果不存在下级外键，不处理
////////// {
////////// continue;
////////// }
////////// ptab=((Hashtable)hasht[cnt])["FTABLE"].ToString();
////////// hs_sub=db.GetColumnInfo(tablename,str_tmp,this.Page);
////////// //级联菜单置空
////////// // ((DropDownList)ctrl_list[cnt]).SelectedIndex = 0;
////////// // ((DropDownList)ctrl_list[int.Parse(hs_sub["COL_ID"].ToString())-1]).Items.Clear();
////////// //委托给Relax_Click
////////// ((DropDownList)ctrl_list[cnt]).AutoPostBack =true;
////////// ((DropDownList)ctrl_list[cnt]).SelectedIndexChanged +=new System.EventHandler(Relax_Click);
////////// // ddl_process(((DropDownList)ctrl_list[cnt]),false);
//////////
////////// // }
////////// }
////////// //*********************************************************************************
ht.Style["Align"]="center";
//ht.Width.Value =double.Parse(this.Panel_Edit.Width.Value.ToString());
this.Panel_Edit.Controls.Add(ht);
ht.Visible =true;
//结束
ret=true;
Panel_Edit.Visible =true;
return ret;
}
#endregion
#region 初始化dg界面
public bool init_dg(string tablename)
{
this.Panel_DG.Visible =false;
DataSet ds=new DataSet();
string sql=sql=db.OccurSqlDisplayCn(ViewState["tablename"].ToString().Trim(),true,this.Page,0,true);
if(ViewState["sql"]==null)
{
ViewState["sql"]=sql;
}
if(ViewState["Quary_sql"]==null)
{
ViewState["Quary_sql"]=ViewState["sql"].ToString();
}
ds=db.GetDataSet(ViewState["Quary_sql"].ToString(),this.Page);
if(ds==null)
{
return false;
}
cdg.Init(dg,tablename,ds,this.Page);
this.dg.DataSource=ds;
dg.DataBind();
//this.gopage(int.Parse(ViewState["page"].ToString()),ViewState["Quary_sql"].ToString());
ViewState["sql"]=sql;
dg.Visible=true;
this.Panel_DG.Visible =true;
// /***************modify by zhouys 2006/03/28 start****************************************/
// for(int i=0;i<dg.Items.Count;i++)
// {
// ((System.Web.UI.WebControls.Button)this.dg.Items[i].Cells[0].Controls[1]).Attributes.Add("onclick","DataGrid_Edit(\"dg\","+i.ToString()+")");
// //((System.Web.UI.WebControls.TemplateColumn)this.dg.Columns[0]).i
// }
// /***************************modify by zhouys 2006/03/28 end****************************/
return true;
}
#endregion
#endregion
#region 事件
#region 级联下拉框按钮事件
void Relax_Click(object sender, System.EventArgs e)
{
// Hashtable hs_par=new Hashtable();
// Hashtable hs_sub=new Hashtable();
// string str_par,str_sub;
// str_par=((DropDownList)sender).ID.Trim().Substring(5);//txt_ctrlname获得txt_后的字符串
// str_sub=db.Judge_Fkey_IsRec(ViewState["tablename"].ToString(),str_par);
// hs_par = db.GetColumnInfo(ViewState["tablename"].ToString(),str_par,this.Page);
// hs_sub = db.GetColumnInfo(ViewState["tablename"].ToString(),str_sub,this.Page);
// bool enblerelax=true;
// if(ViewState["act"].ToString()=="S")
// {
// enblerelax=false;
// }
// db.RelaxDdlProcess((DropDownList)sender,hs_par["FTABLE"].ToString(),(DropDownList)ctrl_list[int.Parse(hs_sub["COL_ID"].ToString())-1],hs_sub["FTABLE"].ToString(),((DropDownList)sender).SelectedValue.Trim(),enblerelax);
// ViewState["act"]="S";
if(!this.IsPostBack)//不是在页面重载时
{
ddl_process((DropDownList)sender,true);
}
else
{
ddl_process((DropDownList)sender,false);
}
}
void ddl_process(DropDownList sender,bool auto)
{
Hashtable hs_par=new Hashtable();
Hashtable hs_sub=new Hashtable();
string str_par,str_sub;
str_par=((DropDownList)sender).ID.Trim().Substring(5);//txt_ctrlname获得txt_后的字符串
string[] arr_sub;
arr_sub=db.Judge_Fkey_IsRec(ViewState["tablename"].ToString(),str_par);
for(int i=0;i<arr_sub.Length;i++)
{
str_sub=arr_sub[i];
hs_par = db.GetColumnInfo(ViewState["tablename"].ToString(),str_par,this.Page);
hs_sub = db.GetColumnInfo(ViewState["tablename"].ToString(),str_sub,this.Page);
bool enblerelax=true;
// if(auto==true)
// {
// enblerelax=true;
// }
// else
// {
// enblerelax=false;
// }
int old_index=0;
if(((DropDownList)this.Page.FindControl("edit_"+hs_sub["NAME_EN"].ToString())).SelectedIndex>=0)
{
old_index=((DropDownList)this.Page.FindControl("edit_"+hs_sub["NAME_EN"].ToString())).SelectedIndex;
}
db.RelaxDdlProcess((DropDownList)sender,hs_par["FTABLE"].ToString(),(DropDownList)ctrl_list[int.Parse(hs_sub["COL_ID"].ToString())-1],hs_sub["FTABLE"].ToString(),((DropDownList)sender).SelectedValue.Trim(),enblerelax);
// ViewState["act"]="S";
try
{
((DropDownList)this.Page.FindControl("edit_"+hs_sub["NAME_EN"].ToString())).SelectedIndex=old_index;
}
catch
{
}
}
}
#endregion
#region 清除
private void ibtn_clr_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
if(bdl.BaseDataTextBoxClear(this.Page,ViewState["tablename"].ToString().Trim())==false)
{
db.Msgbox("清空失败！","操作",this.Page);
return;
}
this.Panel_Edit.Visible =true;
this.hid_act.Text="C";
ViewState["Act"]="C";
ViewState["Quary_sql"]=ViewState["sql"].ToString();
}
#endregion
#region 查询
private void ibtn_qry_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
ViewState["act"]="Q";
string table=ViewState["tablename"].ToString().Trim();
ArrayList al=new ArrayList();
Hashtable ret=new Hashtable();//edit_panel中有值元素的集合
al=db.GetColumnInfo(table,this.Page);//获得列信息
for(int i=0;i<al.Count;i++)//遍历页面中所有edit_元素
{
string str_id=((Hashtable)al[i])["NAME_EN"].ToString().Trim();//获得字段名
string val=db.GetControlValue(this.Page,"edit_"+str_id); //调用GetControlValue获得该字段在edit_panel值
// string val=db.GetControlValue(this.Page,BaseData.ctrl_list,"edit_"+str_id); //改从空间列表中找 2006-04-01
if(val==""||val==null)//如果为空，不计
{
continue;
}
ret.Add(str_id,val);//如果有值，加入集合
}
string sql=bdl.OccurSqlQuery(table,ret,ViewState["sql"].ToString(),this.Page);//产生有值列的sql
if(sql=="")
{
db.Msgbox("查询失败","操作",this.Page);
return;
}
//sql=sql.Replace("[","").Replace("]","");
ViewState["Quary_sql"]=sql;
//sql=sql.Replace("[","").Replace("]","");
this.dg.AllowPaging=false;
this.dg.DataSource =db.GetDataSet(sql);
this.dg.DataBind();
this.dg.Visible =true;
}
#endregion
#endregion
#region 自定义函数
bool gopage(int page,string sql)
{
return this.gopage(page,sql,true);
}
private void ibtn_prt_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string sql=ViewState["Quary_sql"].ToString();
// db.ExportExcel(this.dg,sql,"",this.Response);
}
bool gopage(int page,string sql,bool isload)
{
if(page<1)
{
page=1;
}
// if(page>dg.PageCount)
// {
// page=dg.PageCount;
// }
DataSet ds=new DataSet();
ds=db.GetDataSet(sql,this.Page);
if(ds==null)
{
return false;
}
// dg.DataSource =ds;
// dg.CurrentPageIndex =page-1;
// dg.DataBind();
// cdg.Init(dg,ViewState["tablename"].ToString().Trim(),ds,this.Page);
// this.lbl_currpage.Text =page.ToString();
// if(isload==false)
// {
ViewState["page"]=page;
// }
// this.lbl_pagecnt.Text =this.dg.PageCount.ToString();
return true;
}
#endregion
#region 获得/设置页面上各个控件的值
void GetPageData()
{
ArrayList al=new ArrayList();
for(int i=0;i<this.ctrl_list.Count;i++)
{
string val=db.GetControlValue(this.Page,((System.Web.UI.Control)this.ctrl_list[i]).ID);
al.Add(val);
}
ViewState["ContralsValue"]=al;
}
void SetPageData()
{
if(ViewState["ContralVal"]==null)
{
return;
}
ArrayList cv_al=new ArrayList();
cv_al=(ArrayList)ViewState["ContralVal"];
}
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -