?? controlbinding.cs
字號:
using System;
using System.Data ;
using System.Data.SqlClient ;
namespace qminoa.DA
{
/// <summary>
/// bind 的摘要說明。
/// </summary>
public class controlbinding
{
private DataSet objdataset;
private SqlDataAdapter objadapter=new SqlDataAdapter();
private SqlCommand objcommand=new SqlCommand();
private String conn=System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString");
public controlbinding()
{
//
// TODO: 在此處添加構(gòu)造函數(shù)邏輯
//
}
public DataSet dropPlacebind()
{
return controlbind("cpDropPlaceBind");
}
public DataSet dropTypebind()
{
return controlbind("cpDropTypeBind");
}
//綁定所有機(jī)構(gòu)
public DataSet dropBranchbind()
{
return controlbind("cpDropBranchBind");
}
//綁定指定機(jī)構(gòu)下屬所有部門
public DataSet dropDepbind(string strtxt)
{
return controlbind("cpDropDepBind","@txtdropBranch",strtxt);
}
//綁定制定部門下屬所有人員
public DataSet droplstEmpbind(string strtxt)
{
return controlbind("cpLstEmpBind","@txtdropDep",strtxt);
}
public DataSet controlbind(string strsql)
{
objdataset=new DataSet ();
objadapter=new SqlDataAdapter(strsql,conn);
objadapter.Fill(objdataset, "tablename");
return objdataset;
}
public DataSet controlbind(string strsql ,string paramName,int paramValue)
{
objadapter.SelectCommand = new SqlCommand();
objadapter.SelectCommand.Connection = new SqlConnection(conn);
objdataset=new DataSet ();
objcommand = objadapter.SelectCommand;
objcommand.CommandText = strsql;
objcommand.CommandType = CommandType.StoredProcedure;
SqlParameter param = new SqlParameter(paramName, SqlDbType.Int);
param.Value = paramValue ;
objcommand.Parameters.Add(param);
objadapter.Fill(objdataset);
return objdataset;
}
public DataSet controlbind(string strsql ,string paramName,string paramValue)
{
objadapter.SelectCommand = new SqlCommand();
objadapter.SelectCommand.Connection = new SqlConnection(conn);
objdataset=new DataSet ();
objcommand = objadapter.SelectCommand;
objcommand.CommandText = strsql;
objcommand.CommandType = CommandType.StoredProcedure;
SqlParameter param = new SqlParameter(paramName, SqlDbType.NVarChar, 255);
param.Value = paramValue ;
objcommand.Parameters.Add(param);
objadapter.Fill(objdataset);
return objdataset;
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -