Example #1
0
        void MainOperation(CE_OperatorMode mode)
        {
            S_StockLackCustomTemplates tempLnq = new S_StockLackCustomTemplates();

            tempLnq.ID            = dataGridView1.CurrentRow == null ? 0 : Convert.ToInt32(dataGridView1.CurrentRow.Cells["ID"].Value);
            tempLnq.TemplatesName = txtTemplatesName.Text;

            if (!m_serverLack.OperationMain(mode, tempLnq, out m_strErr))
            {
                MessageDialog.ShowPromptMessage(m_strErr);
                return;
            }
            else
            {
                MessageDialog.ShowPromptMessage(mode.ToString() + "成功");
            }

            BindingMainInfo();
            PositioningRecord1(tempLnq.TemplatesName);
        }
        /// <summary>
        /// 自定义模板操作模板
        /// </summary>
        /// <param name="mode">操作模式</param>
        /// <param name="main">LNQ信息</param>
        /// <param name="error">错误信息</param>
        /// <returns>成功返回True, 失败返回False</returns>
        public bool OperationMain(CE_OperatorMode mode, S_StockLackCustomTemplates main, out string error)
        {
            error = null;

            try
            {
                DepotManagementDataContext ctx = CommentParameter.DepotDataContext;

                var varData = from a in ctx.S_StockLackCustomTemplates
                              select a;

                S_StockLackCustomTemplates tempLnq = new S_StockLackCustomTemplates();

                switch (mode)
                {
                case CE_OperatorMode.添加:
                    tempLnq.TemplatesName = main.TemplatesName;
                    ctx.S_StockLackCustomTemplates.InsertOnSubmit(tempLnq);
                    break;

                case CE_OperatorMode.修改:

                    varData = from a in ctx.S_StockLackCustomTemplates
                              where a.ID == main.ID
                              select a;

                    if (varData.Count() != 1)
                    {
                        throw new Exception("数据不唯一");
                    }
                    else
                    {
                        tempLnq = varData.Single();

                        tempLnq.TemplatesName = main.TemplatesName;
                    }

                    break;

                case CE_OperatorMode.除:
                    varData = from a in ctx.S_StockLackCustomTemplates
                              where a.ID == main.ID
                              select a;

                    ctx.S_StockLackCustomTemplates.DeleteAllOnSubmit(varData);
                    break;

                default:
                    break;
                }

                ctx.SubmitChanges();

                return(true);
            }
            catch (Exception ex)
            {
                error = ex.Message;
                return(false);
            }
        }