Esempio n. 1
0
        void ListOperation(CE_OperatorMode mode)
        {
            S_StockLackCustomTemplatesList tempLnq = new S_StockLackCustomTemplatesList();

            tempLnq.ID      = dataGridView2.CurrentRow == null ? 0 : Convert.ToInt32(dataGridView2.CurrentRow.Cells["ID"].Value);
            tempLnq.Counts  = numOperationCount.Value;
            tempLnq.GoodsID = Convert.ToInt32(txtCode.Tag);
            tempLnq.ListID  = Convert.ToInt32(dataGridView1.CurrentRow.Cells["ID"].Value);

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

            BindingListInfo(tempLnq.ListID);
            PositioningRecord2(tempLnq.GoodsID);
        }
        /// <summary>
        /// 操作自定义模板明细
        /// </summary>
        /// <param name="mode">操作模式</param>
        /// <param name="list">LNQ信息</param>
        /// <param name="error">错误信息</param>
        /// <returns>成功返回True,失败返回False </returns>
        public bool OperationList(CE_OperatorMode mode, S_StockLackCustomTemplatesList list, out string error)
        {
            error = null;

            try
            {
                DepotManagementDataContext ctx = CommentParameter.DepotDataContext;

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

                S_StockLackCustomTemplatesList tempLnq = new S_StockLackCustomTemplatesList();

                switch (mode)
                {
                case CE_OperatorMode.添加:

                    tempLnq.Counts  = list.Counts;
                    tempLnq.GoodsID = list.GoodsID;
                    tempLnq.ListID  = list.ListID;

                    ctx.S_StockLackCustomTemplatesList.InsertOnSubmit(tempLnq);
                    break;

                case CE_OperatorMode.修改:

                    varData = from a in ctx.S_StockLackCustomTemplatesList
                              where a.ID == list.ID
                              select a;

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

                        tempLnq.Counts  = list.Counts;
                        tempLnq.GoodsID = list.GoodsID;
                    }

                    break;

                case CE_OperatorMode.除:
                    varData = from a in ctx.S_StockLackCustomTemplatesList
                              where a.ID == list.ID
                              select a;

                    ctx.S_StockLackCustomTemplatesList.DeleteAllOnSubmit(varData);
                    break;

                default:
                    break;
                }

                ctx.SubmitChanges();

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