知识点.txt

来自「办公自动化系统」· 文本 代码 · 共 24 行

调用存储过程


IList<ArticalTypeInfo> lists = BLLGeneric.Select<ArticalTypeInfo>(CommandType.StoredProcedure, "ArticalTypeInfoList");
            this.gridArticalInfoList.DataSource = lists;
传参调用存储过程


  string loginName = this.txtLoginName.Text;
            string loginPwd = this.txtLoginPwd.Text;
            SqlParameter paramLoginName = new SqlParameter("@LoginName",loginName);
            SqlParameter paramLoginPwd = new SqlParameter("@LoginPwd",loginPwd);
            IList<UserInfo> lists = UserInfoBLL.Select(CommandType.StoredProcedure, "UserInfoLogin", paramLoginName, paramLoginPwd);

格式化WHERE

 String bumen=this.ddl_bumen.Text;
        String where = "em_dept_id='{0}'";
        where = string.Format(where,bumen);
        IList<employee> list = employeeBLL.Select(where);