WPF单表修改

编写数据库存储过程修改信息代码如下：

 

编写服务端后台代码如下：         

//修改奖品信息

[OperationContract]

        public int UpdatePrize(string strPrize_number, string strPrize_name, string strIntegral,

            bool bolWhether_activity, string strRemarks,int intPrize_ID)

        {

            SqlParameter[] mysqlparameter = {

                new SqlParameter("@type",SqlDbType.NChar),

                new SqlParameter("@Prize_number",SqlDbType.NChar),

                new SqlParameter("@Prize_name",SqlDbType.NChar),

                new SqlParameter("@Integral",SqlDbType.NChar),

                new SqlParameter("@Whether_activity",SqlDbType.Bit),

                new SqlParameter("@Remarks",SqlDbType.NChar),

                new SqlParameter("@Prize_ID",SqlDbType.Int)

            };

            mysqlparameter[0].Value = "UpdatePrize";

            mysqlparameter[1].Value = strPrize_number;

            mysqlparameter[2].Value = strPrize_name;

            mysqlparameter[3].Value = strIntegral;

            mysqlparameter[4].Value = bolWhether_activity;

            mysqlparameter[5].Value = strRemarks;

            mysqlparameter[6].Value = intPrize_ID;

            int count = myDALMethod.UpdateData("Frm_Login", mysqlparameter);

            return count;

        }

编写客户端后台代码如下：

//全局变量

        DataRowView DGVR;//接收一行数据

        BLL.Login.LoginClient myClient = new BLL.Login.LoginClient();

        public WD_UpdateAllot(DataRowView drv)

        {

            InitializeComponent();

            DGVR = drv;

        }

        private void WindowName_Loaded(object sender, RoutedEventArgs e)

        {

            页面数据回填

            txt_number.Text =(DGVR.Row["Prize_number"]).ToString();

            txt_name.Text = (DGVR.Row["Prize_name"]).ToString();

            txt_Integral.Text =(DGVR.Row["Integral"]).ToString();

            if (DGVR.Row["Whether_activity"].ToString() == "是")

            {

                chk_activity.IsChecked = true;

            }

            else

            {

                chk_activity.IsChecked = false;

            }

            txt_remarks.Text =(DGVR.Row["Remarks"]).ToString();

           

        }

 

 

 

 

//确认修改按钮

     private void btn_Affirm_Click(object sender, RoutedEventArgs e)

        {

            try

            {

                string strPrize_number = txt_number.Text.Trim();

                string strPrize_name = txt_name.Text.Trim();

                string strIntegral = txt_Integral.Text.Trim();

                bool bolWhether_activity = (bool)chk_activity.IsChecked;

                string strRemarks = txt_remarks.Text.Trim();

                int intPrize_ID = Convert.ToInt32(DGVR.Row["Prize_ID"]);

                //执行服务方法

                int count = myClient.UpdatePrize(strPrize_number, strPrize_name, strIntegral, bolWhether_activity, strRemarks, intPrize_ID);

                if (count > 0 )

                {

                    MessageBoxResult dr = MessageBox.Show("账号修改成功！", "系统提示", MessageBoxButton.OKCancel,

                        MessageBoxImage.Asterisk); //弹出确定对话框

                    if (dr==MessageBoxResult.OK)

                    {

                        Close();

                    }

                }

                else

                {

                    MessageBoxResult dr = MessageBox.Show("账号修改失败，请重新操作！", "系统提示", MessageBoxButton.OKCancel,

                        MessageBoxImage.Exclamation); //弹出确定对话框

                }

            }

            catch (Exception)

            {

                throw;

            }

        }

结果如图所示：

弹出如下页面：

修改成功：