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); } }