/// <summary> /// 删除工装工位配置信息 /// </summary> /// <param name="frockOfWorkBench">工装工位配置实体集</param> /// <param name="error">错误信息</param> /// <returns>成功返回True ,失败返回False</returns> public bool DeleteFrockOfWorkBench(S_FrockOfWorkBenchSetting frockOfWorkBench, out string error) { error = null; try { DepotManagementDataContext ctx = CommentParameter.DepotDataContext; var varData = from a in ctx.S_FrockOfWorkBenchSetting where a.WorkBench == frockOfWorkBench.WorkBench && a.FrockNumber == frockOfWorkBench.FrockNumber select a; ctx.S_FrockOfWorkBenchSetting.DeleteAllOnSubmit(varData); ctx.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 添加工装工位配置信息 /// </summary> /// <param name="frockOfWorkBench">工装工位配置实体集</param> /// <param name="error">错误信息</param> /// <returns>成功返回True ,失败返回False</returns> public bool AddFrockOfWorkBench(S_FrockOfWorkBenchSetting frockOfWorkBench, out string error) { error = null; try { DepotManagementDataContext ctx = CommentParameter.DepotDataContext; var varData = from a in ctx.S_FrockOfWorkBenchSetting where a.WorkBench == frockOfWorkBench.WorkBench && a.FrockNumber == frockOfWorkBench.FrockNumber select a; if (varData.Count() == 0) { ctx.S_FrockOfWorkBenchSetting.InsertOnSubmit(frockOfWorkBench); ctx.SubmitChanges(); } else { error = "不能添加重复项"; return(false); } return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
private void btnContentUpdate_Click(object sender, EventArgs e) { GetMessage(); S_FrockOfWorkBenchSetting lnqOldData = new S_FrockOfWorkBenchSetting(); lnqOldData.WorkBench = dataGridView1.CurrentRow.Cells["工位"].Value.ToString(); lnqOldData.FrockNumber = dataGridView1.CurrentRow.Cells["工装编号"].Value.ToString(); if (!m_serverFrockStandingBook.UpdateFrockOfWorkBench(lnqOldData, m_lnqFrockOfWorkBenchSet, out m_strErr)) { MessageDialog.ShowPromptMessage(m_strErr); } else { MessageDialog.ShowPromptMessage("更新成功"); } RefreshData(); }
/// <summary> /// 更新工装工位配置信息 /// </summary> /// <param name="oldFrockOfWorkBench">旧实体集</param> /// <param name="newFrockOfWorkBench">新实体集</param> /// <param name="error">错误信息</param> /// <returns>成功返回True,失败返回False</returns> public bool UpdateFrockOfWorkBench(S_FrockOfWorkBenchSetting oldFrockOfWorkBench, S_FrockOfWorkBenchSetting newFrockOfWorkBench, out string error) { error = null; try { DepotManagementDataContext ctx = CommentParameter.DepotDataContext; var varData = from a in ctx.S_FrockOfWorkBenchSetting where a.FrockNumber == oldFrockOfWorkBench.FrockNumber && a.WorkBench == oldFrockOfWorkBench.WorkBench select a; if (varData.Count() != 1) { error = "数据为空或者不唯一"; return(false); } else { S_FrockOfWorkBenchSetting lnqData = varData.Single(); lnqData.FrockNumber = newFrockOfWorkBench.FrockNumber; lnqData.WorkBench = newFrockOfWorkBench.WorkBench; ctx.SubmitChanges(); } return(true); } catch (Exception ex) { error = ex.Message; return(false); } }