登录页面操作流程

一、DAL部分:1.链接数据库    public string strConnect = @“Data Source=DESKTOP-80DD90V\MSSQLSERVER11;Initial Catalog=Catering; User ID=sa; Password=123”;其中DESKTOP-80DD90V\MSSQLSERVER11是服务器名称；sa是登录名；123是密码；2. 查询语句public DataTable QueryDataTable(string sql, SqlParameter[] param)        {            DataTable dt = new DataTable();            using (SqlConnection coon = new SqlConnection(strConnect))            {                coon.Open();                SqlDataAdapter da = new SqlDataAdapter(sql, coon);                da.SelectCommand.CommandType = CommandType.StoredProcedure;                da.SelectCommand.Parameters.AddRange(param);                da.Fill(dt);                coon.Close();            }            return dt;二、BLL部分：1.(服务契约)定义服务协议    特性[ServiceContract] 服务[OperationContract] 创建WCF服务应用程序启动 启动项目，所以BLL上加[ServiceContract]意为服务而[OperationContract]意为创建3. DAL.DALMethod myDALMethod = new DAL.DALMethod();将DAL上的DALMethode实例化并调用 public DataSet SelectLogin(string account, string password)        {            //创建参数列表            SqlParameter[] sqlparameters =            {                new SqlParameter("@type",SqlDbType.VarChar),                new SqlParameter("@account",SqlDbType.VarChar),                new SqlParameter("@password",SqlDbType.VarChar),             };            // 设置参数的值            sqlparameters[0].Value = “Button_Click_CheckLogin”;            sqlparameters[1].Value = account;          sqlparameters[2].Value = password; //调用存储过程 获取返回值进行判断                        DataTable dt = myDALMethod.QueryDataTable(“WDLogin”, sqlparameters);            //返回数据            DataSet mydataSet = new DataSet();            mydataSet.Tables.Add(dt);            return mydataSet;三、WCF服务应用程序1.修改 web.config  高级-服务行为-空名称-serviceMetadata-HttpGetEnable-True改为False2.修改web.config 高级-服务行为-空名称-serviceDebug-IncludeExceptionDetailInFaults-False改为True3. 高级-服务行为-空名称点击修改Name为BLL4.点击服务-新增服务-BLL\bin\Debug\BLL.Login 在地址选择不填5.服务-终结点-Name起名BLL.Login6.服务-BLL.Login-BehaviorConfiguration下拉选择BLL7.高级-宿主环境-serviceActivations-RelativeAddress 填入BLL.Login.svc8.高级-宿主环境-serviceActivations-Service填入BLL.Login四、页面后台登录按钮 //实力化命名空间        BLL.Login.LoginClient myBLL = new BLL.Login.LoginClient();               private void Button_Click(object sender, RoutedEventArgs e)        {            try            {                //1、判断账号是否为空                if (string.IsNullOrEmpty(txtAccount.Text))                {                      //显示文字，标题，按钮个数，图标                    MessageBox.Show(“请输入账号”,“系统提示”,MessageBoxButton.OK,MessageBoxImage.Error);                    return;                }                if (pwdPasword.Password=="")                {                    MessageBox.Show(“请输入密码”, “系统提示”, MessageBoxButton.OK, MessageBoxImage.Error);                    return;                }                 //myBLL.SelectLogin()                //2、获取控件输入值   声明2个参数接收他的值                string strAccounts = txtAccount.Text.Trim();                string strPassword = pwdPasword.Password.Trim();                //3、执行服务里面的方法                DataTable dt = myBLL.SelectLogin(strAccounts, strPassword).Tables[0];                 //4、判断账号或密码是否正确                if (dt.Rows.Count>0)                {                    //5、账号成功(跳转窗口)                    验证 后台服务                    MainWindow1 mainWindow1 = new MainWindow1();                    mainWindow1.Show();                    this.Close();                }                else                {                    MessageBox.Show(“账户不存在或密码正确，请重新输入”, “系统提示”, MessageBoxButton.OK, MessageBoxImage.Error);                }              }            catch (Exception ex)            {                Console.WriteLine(ex);               }            }