DataSet ds_sum = new DataSet(); //全局综合查询
protected void Page_Load(object sender, EventArgs e)
{
Check_syntheses.Attributes.Add("onclick", "chkRadio(this)"); //取消选中 考虑，吗，
if (db.address == "SZCFERP" && ddl_address.SelectedValue.ToString() == "SZCFERP")
{
if (ddl_client.Items.Count < 2)
{
db.strconn = "connstrSZCFERP"; //SZCFERP
ddl_client.Items.Clear(); //全部删除
HSql info = new HSql(db.strconn);
info.Open(@"select cm_addr,cm_addr+'-'+cm_sort as cm_sort from cm_mstr");
if (info.m_table.Rows.Count > 0)
{
ddl_client.DataSource = info.m_table.DefaultView;
ddl_client.DataValueField = info.m_table.Columns["cm_addr"].ColumnName;
ddl_client.DataTextField = info.m_table.Columns["cm_sort"].ColumnName;
}
info.Close();
//ListItem("显示的值", "后台隐藏值");
ListItem al = new ListItem("--全部--", "全部");
al.Selected = true;
ddl_client.Items.Insert(0, al);
this.ddl_client.DataBind();
}
}
}
//数据库操作错误信息显示
public static void ShowDBErrMsg(int flag, string msg)
{
string ErrMsg = "";
HSql hs = new HSql();
hs.Open("SELECT Top 1 msg_desc FROM [msg_mstr] WHERE msg_id=" + flag.ToString());
if (hs.NextRow())
{
if (msg != "")
{
ErrMsg = "【" + msg + "】 ";
}
ErrMsg = ErrMsg + hs["msg_desc"].ToString().Trim();
}
else
{
ErrMsg = "发生未知类型错误：" + flag.ToString();
}
if (ErrMsg != "")
{
Jscript.AlertAndGoBack(" 错误提示： " + ErrMsg);
}
}
private void binddl()
{
db.address = ddl_address.SelectedValue.ToString();
if (db.address == "SZCFERP")
{
CONN = db.m_conn; //SZCFERP
}
else
{
CONN = db.ConnGCERP; //GCERP 表格，柱状图，饼图 所用数据库 SqlConnection 对象
}
if (db.address == "SZCFERP")
{
db.strconn = "connstrSZCFERP"; //SZCFERP
}
else
{
db.strconn = "connstrGCERP"; //GCERP 表格，柱状图，饼图 所用数据库 配置字符串
}
// CONN = db.m_conn; //SZCFERP
// String str_select = " cm_addr,cm_sort ";
// String str_tabel = " cm_mstr ";
// String str_where = " 1=1 ";
// db.OpenConnection(CONN);
// SqlCommand comm = new SqlCommand("sp_select", CONN);
// comm.CommandType = CommandType.StoredProcedure;
// comm.Parameters.Add("@comm_select", SqlDbType.NVarChar, 300).Value = str_select;
// comm.Parameters.Add("@comm_tabel", SqlDbType.NVarChar, 300).Value = str_tabel;
// comm.Parameters.Add("@comm_where", SqlDbType.NVarChar, 300).Value = str_where;
// SqlDataAdapter sda = new SqlDataAdapter();
// sda.SelectCommand = comm;
// DataSet ds = new DataSet();
//// sda.Fill(ds);
ddl_client.Items.Clear(); //全部删除
string str_ddl_bz = ddl_bz.SelectedValue.ToString();
HSql info = new HSql(db.strconn);
info.Open(@"select cm_addr,cm_addr+'-'+cm_sort as cm_sort from cm_mstr where cm_curr='" + str_ddl_bz + "'");
if (info.m_table.Rows.Count > 0)
{
ddl_client.DataSource = info.m_table.DefaultView;
ddl_client.DataValueField = info.m_table.Columns["cm_addr"].ColumnName;
ddl_client.DataTextField = info.m_table.Columns["cm_sort"].ColumnName;
}
info.Close();
//ListItem("显示的值", "后台隐藏值");
ListItem al = new ListItem("--全部--", "全部");
al.Selected = true;
ddl_client.Items.Insert(0, al);
//dropdownlist1.Items.Clear(); 全部删除
//dropdownlist1.Items.Remove(要删除的选项);
//dropdownlist1.Items.RemoveAt(要删除的选项的索引);
// this.DropDownList1.Items.Insert(0, "--请选择--");
Check_syntheses.Visible = true;
this.ddl_client.DataBind();
//db.CloseConnection(CONN);
}
