• SaveData Functions


    Here are some save function for some situations:

    Yes/No

    /// <summary>
            ///保存数据到WCF
            /// </summary>
            /// <param name="ds"></param>
            public void SaveDataSetSingleOrTwoTables(DataSet ds, string parent, string child)
            {
                string message = "您想保存数据吗?";
                string caption = "保存数据";
    
                if (ds.HasChanges())
                {
                    DialogResult result = MessageBox.Show(message, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (result == DialogResult.Yes)
                    {
                        try
                        {
                            //DataSet dsChanged = ds.GetChanges();
                            DataTable tblParent = null;
                            DataTable tblChild = null;
    
                            if (!string.IsNullOrEmpty(parent))
                            {
                                tblParent = ds.Tables[parent].GetChanges(); //error if table not existing
                            }
    
                            if (!string.IsNullOrEmpty(child))
                            {
                                tblParent = ds.Tables[child].GetChanges(); //error if table not existing
                            }
    
                            DataSet ds1 = new DataSet();
                            if (tblParent != null) ds1.Tables.Add(tblParent);
                            DataSet ds2 = new DataSet();
                            if (tblChild != null) ds2.Tables.Add(tblChild);
    
                            //call save method(tblParent, tblChild, null);
                            TJ_Nurse_Service.NurseSvc.QualityCheckIBLLClient saveData = new TJ_Nurse_Service.NurseSvc.QualityCheckIBLLClient();
                            saveData.QualityCheckUpdate(ds1, ds2, null);
                            ds.AcceptChanges();
                            MessageBox.Show("数据已保存。");
                        }
                        catch (Exception ex)
                        {
                            Error.ErrProc(ex);
                            MessageBox.Show("由于某种原因,数据不能保存。数据丢失。");
                            ds.RejectChanges();
                            return;
                        }
    
                    }
                    else
                    {
                        ds.RejectChanges();
                        MessageBox.Show("数据没有保存。已修改的已恢复。");
                    }
                }
                else
                {
                    MessageBox.Show("没有数据要保存。");
                    ds.RejectChanges();
                }
    
            }
    View Code


    Yes/No/Cancel

     /// <summary>
            /// 保存数据到WCF
            /// </summary>
            /// <param name="ds"></param>
            /// <param name="parent"></param>
            /// <param name="child"></param>
            public void SaveDataSetSingleOrTwoTablesWithCancel(DataSet ds, string parent, string child)
            {
                string message = "您想保存数据吗";
                string caption = "保存数据";
    
                if (ds.HasChanges())
                {
                    DialogResult result = MessageBox.Show(message, caption, MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
                    if (result == DialogResult.Yes)
                    {
                        try
                        {
                            //DataSet dsChanged = ds.GetChanges();
                            DataTable tblParent = null;
                            DataTable tblChild = null;
    
                            if (!string.IsNullOrEmpty(parent))
                            {
                                tblParent = ds.Tables[parent].GetChanges(); //error if table not existing
                            }
    
                            if (!string.IsNullOrEmpty(child))
                            {
                                tblParent = ds.Tables[child].GetChanges(); //error if table not existing
                            }
    
                            DataSet ds1 = new DataSet();
                            if (tblParent != null) ds1.Tables.Add(tblParent);
                            DataSet ds2 = new DataSet();
                            if (tblChild != null) ds2.Tables.Add(tblChild);
    
                            //call save method(tblParent, tblChild, null);
                            TJ_Nurse_Service.NurseSvc.QualityCheckIBLLClient saveData = new TJ_Nurse_Service.NurseSvc.QualityCheckIBLLClient();
                            saveData.QualityCheckUpdate(ds1, ds2, null);
                            ds.AcceptChanges();
                            MessageBox.Show("数据已保存。");
                        }
                        catch (Exception ex)
                        {
                            Error.ErrProc(ex);
                            ds.RejectChanges();
                            MessageBox.Show("由于某种原因,数据不能保存。数据丢失。");
                            return;
                        }
    
                    }
                    else if (result == DialogResult.No)
                    {
                        ds.RejectChanges();
                        MessageBox.Show("数据没有保存。已修改的已恢复。");
                        return;
                    }
                    else
                    {
                        MessageBox.Show("您修改的数据没有保存。但您可以保存。");
                        return;
                    }
                }
                else
                {
                    MessageBox.Show("没有数据要保存。");
                    ds.RejectChanges();
                }
    
            }
    View Code

    Yes/No => WCF

    /// <summary>
            ///保存数据到WCF
            /// </summary>
            /// <param name="ds"></param>
            public void SaveDataSetSingleOrTwoTables(DataSet ds, string parent, string child)
            {
                string message = "您想保存数据吗?";
                string caption = "保存数据";
    
                //index_item data changed?
                UpdateCurrentDetail();
    
                if (ds.HasChanges())
                {
                    DialogResult result = MessageBox.Show(message, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (result == DialogResult.Yes)
                    {
                        try
                        {
                            //DataSet dsChanged = ds.GetChanges();
                            DataTable tblParent = null;
                            DataTable tblChild = null;
    
                            if (!string.IsNullOrEmpty(parent))
                            {
                                tblParent = ds.Tables[parent].GetChanges(); //error if table not existing
                            }
    
                            if (!string.IsNullOrEmpty(child))
                            {
                                tblChild = ds.Tables[child].GetChanges(); //error if table not existing
                            }
    
                            DataSet ds1 = new DataSet();
                            if (tblParent != null) ds1.Tables.Add(tblParent);
                            DataSet ds2 = new DataSet();
                            if (tblChild != null) ds2.Tables.Add(tblChild);
    
                            //call save method(tblParent, tblChild, null);
                            TJ_Nurse_Service.NurseSvc.QualityCheckIBLLClient saveData = new TJ_Nurse_Service.NurseSvc.QualityCheckIBLLClient();
                            saveData.QualityCheckUpdate(ds1, ds2, null);
                            ds.AcceptChanges();
                            MessageBox.Show("数据已保存。");
                        }
                        catch (Exception ex)
                        {
                            Error.ErrProc(ex);
                            MessageBox.Show("由于某种原因,数据不能保存。数据丢失。");
                            ds.RejectChanges();
                            return;
                        }
    
                    }
                    else
                    {
                        ds.RejectChanges();
                        MessageBox.Show("数据没有保存。已修改的已恢复。");
                    }
                }
                else
                {
                    MessageBox.Show("没有数据要保存。");
                    ds.RejectChanges();
                }
    
            }
    View Code

    Yes/No/Cancel

    /// <summary>
            /// 保存数据到WCF
            /// </summary>
            /// <param name="ds"></param>
            /// <param name="parent"></param>
            /// <param name="child"></param>
            public void SaveDataSetSingleOrTwoTablesWithCancel(DataSet ds, string parent, string child)
            {
                string message = "您想保存数据吗";
                string caption = "保存数据";
    
                //index_item data changed?
                UpdateCurrentDetail();
    
                if (ds.HasChanges())
                {
                    DialogResult result = MessageBox.Show(message, caption, MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
                    if (result == DialogResult.Yes)
                    {
                        try
                        {
                            //DataSet dsChanged = ds.GetChanges();
                            DataTable tblParent = null;
                            DataTable tblChild = null;
    
                            if (!string.IsNullOrEmpty(parent))
                            {
                                tblParent = ds.Tables[parent].GetChanges(); //error if table not existing
                            }
    
                            if (!string.IsNullOrEmpty(child))
                            {
                                tblChild = ds.Tables[child].GetChanges(); //error if table not existing
                            }
    
                            DataSet ds1 = new DataSet();
                            if (tblParent != null) ds1.Tables.Add(tblParent);
                            DataSet ds2 = new DataSet();
                            if (tblChild != null) ds2.Tables.Add(tblChild);
    
                            //call save method(tblParent, tblChild, null);
                            TJ_Nurse_Service.NurseSvc.QualityCheckIBLLClient saveData = new TJ_Nurse_Service.NurseSvc.QualityCheckIBLLClient();
                            saveData.QualityCheckUpdate(ds1, ds2, null);
                            ds.AcceptChanges();
                            MessageBox.Show("数据已保存。");
                        }
                        catch (Exception ex)
                        {
                            Error.ErrProc(ex);
                            ds.RejectChanges();
                            MessageBox.Show("由于某种原因,数据不能保存。数据丢失。");
                            return;
                        }
    
                    }
                    else if (result == DialogResult.No)
                    {
                        ds.RejectChanges();
                        MessageBox.Show("数据没有保存。已修改的已恢复。");
                        return;
                    }
                    else
                    {
                        MessageBox.Show("您修改的数据没有保存。但您可以保存。");
                        return;
                    }
                }
                else
                {
                    MessageBox.Show("没有数据要保存。");
                    ds.RejectChanges();
                }
    
            }
    View Code
  • 相关阅读:
    MySQL学习之——锁(行锁、表锁、页锁、乐观锁、悲观锁等)
    MySQL 行锁 表锁机制
    数据库中悲观锁和乐观锁
    NYOJ 116 士兵杀敌(二)【线段树 单点更新】
    java模拟而一个电话本操作
    Protostuff具体解释
    Java之enum
    muduo::Connector、TcpClient分析
    Android性能优化之中的一个 布局优化
    linux c 网络编程:用域名获取IP地址或者用IP获取域名 网络地址转换成整型 主机字符顺序与网络字节顺序的转换
  • 原文地址:https://www.cnblogs.com/kevinygq/p/3901444.html
Copyright © 2020-2023  润新知