Exemple #1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            string    sSql      = "";
            ArrayList lstSql    = new ArrayList();
            DataTable dtChanges = m_configValue.Table.GetChanges();

            if (dtChanges != null)
            {
                if (Program.frm1.PWDCheck("rg"))
                {
                    foreach (DataRow row in dtChanges.Rows)
                    {
                        sSql = "update Config set ConfigValue=" + "'" + row["ConfigValue"].ToString() + "'" + " where [Description]=" + "'" + row["Description"].ToString() + "'";
                        lstSql.Add(sSql);
                    }
                    try
                    {
                        SQLHelper.ExecuteSql(lstSql);
                        m_configValue.Table.AcceptChanges();
                        TableConfig.setFill();
                        MessageBox.Show("保存成功!");
                        ChangeState();
                        this.Close();
                    }
                    catch
                    {
                        m_configValue.Table.RejectChanges();
                        MessageBox.Show("保存失败!");
                    }
                }
                else
                {
                    MessageBox.Show("密码错误!");
                }
            }
            else
            {
                MessageBox.Show("数据未改变!");
                this.Close();
            }
        }