/// <summary> /// 比较两个sheet的不同 /// </summary> /// <param name="pre">操作前</param> /// <param name="after">操作后</param> /// <returns></returns> public SheetDiffer CompareSheet(Prj_Sheet pre, Prj_Sheet after) { SheetDiffer result = new SheetDiffer(); if (pre.ID != after.ID) { throw new Exception("sheet id should be equal"); } if (!pre.Compare(after)) { result.Sheet_Modified.Add(after); } {//signal Hashtable id_to_signal1 = new Hashtable(); foreach (Cld_Signal signal in pre.Cld_Signal_List) { id_to_signal1[signal.ID] = signal; } foreach (Cld_Signal signal in after.Cld_Signal_List) { if (id_to_signal1.Contains(signal.ID)) { if (!((Cld_Signal)id_to_signal1[signal.ID]).Compare(signal)) { result.Signal_Modified.Add(signal); } id_to_signal1.Remove(signal.ID); } else { result.Signal_Newed.Add(signal); } } foreach (Cld_Signal signal in id_to_signal1.Values) { result.Signal_Deleted.Add(signal); } } {//cld_fcblcok Hashtable id_to_block = new Hashtable(); foreach (Cld_FCBlock block in pre.Cld_FCBlock_List) { id_to_block[block.ID] = block; } foreach (Cld_FCBlock block in after.Cld_FCBlock_List) { if (id_to_block.Contains(block.ID)) { if (!((Cld_FCBlock)id_to_block[block.ID]).Compare(block)) { result.Block_Modified.Add(block); } //input Hashtable id_to_input = new Hashtable(); foreach (Cld_FCInput input in ((Cld_FCBlock)id_to_block[block.ID]).Cld_FCInput_List) { id_to_input[input.ID] = input; } foreach (Cld_FCInput input in block.Cld_FCInput_List) { if (id_to_input.Contains(input.ID)) { if (!((Cld_FCInput)id_to_input[input.ID]).Compare(input)) { result.Input_Modified.Add(input); } id_to_input.Remove(input.ID); } else { result.Input_Newed.Add(input); } } foreach (Cld_FCInput input in id_to_input.Values) { result.Input_Deleted.Add(input); } //output Hashtable id_to_output = new Hashtable(); foreach (Cld_FCOutput output in ((Cld_FCBlock)id_to_block[block.ID]).Cld_FCOutput_List) { id_to_output[output.ID] = output; } foreach (Cld_FCOutput output in block.Cld_FCOutput_List) { if (id_to_output.Contains(output.ID)) { if (!((Cld_FCOutput)id_to_output[output.ID]).Compare(output)) { result.Output_Modified.Add(output); } id_to_output.Remove(output.ID); } else { result.Output_Newed.Add(output); } } foreach (Cld_FCOutput output in id_to_output.Values) { result.Output_Deleted.Add(output); } //para Hashtable id_to_para = new Hashtable(); foreach (Cld_FCParameter p in ((Cld_FCBlock)id_to_block[block.ID]).Cld_FCParameter_List) { id_to_para[p.ID] = p; } foreach (Cld_FCParameter p in block.Cld_FCParameter_List) { if (id_to_para.Contains(p.ID)) { if (!((Cld_FCParameter)id_to_para[p.ID]).Compare(p)) { result.Para_Modified.Add(p); } id_to_para.Remove(p.ID); } else { result.Para_Newed.Add(p); } } foreach (Cld_FCParameter p in id_to_para.Values) { result.Para_Deleted.Add(p); } id_to_block.Remove(block.ID); } else { result.Block_Newed.Add(block); block.Orin = true; if (block.Cld_FCInput_List != null) { foreach (Cld_FCInput input in block.Cld_FCInput_List) { result.Input_Newed.Add(input); } } if (block.Cld_FCOutput_List != null) { foreach (Cld_FCOutput output in block.Cld_FCOutput_List) { result.Output_Newed.Add(output); } } if (block.Cld_FCParameter_List != null) { foreach (Cld_FCParameter p in block.Cld_FCParameter_List) { result.Para_Newed.Add(p); } } block.Orin = false; } } foreach (Cld_FCBlock block in id_to_block.Values) { result.Block_Deleted.Add(block); foreach (Cld_FCInput input in block.Cld_FCInput_List) { result.Input_Deleted.Add(input); } foreach (Cld_FCOutput output in block.Cld_FCOutput_List) { result.Output_Deleted.Add(output); } foreach (Cld_FCParameter p in block.Cld_FCParameter_List) { result.Para_Deleted.Add(p); } } } { //cld_const Hashtable id_to_const = new Hashtable(); foreach (Cld_Constant con in pre.Cld_Constant_List) { id_to_const[con.ID] = con; } foreach (Cld_Constant con in after.Cld_Constant_List) { if (id_to_const.Contains(con.ID)) { if (!((Cld_Constant)id_to_const[con.ID]).Compare(con)) { result.Const_Modified.Add(con); } id_to_const.Remove(con.ID); } else { result.Const_Newed.Add(con); } } foreach (Cld_Constant con in id_to_const.Values) { result.Const_Deleted.Add(con); } } { //cld_graphic Hashtable id_to_grap = new Hashtable(); foreach (Cld_Graphic g in pre.Cld_Graphic_List) { id_to_grap[g.ID] = g; } foreach (Cld_Graphic g in after.Cld_Graphic_List) { if (id_to_grap.Contains(g)) { if (!((Cld_Graphic)id_to_grap[g.ID]).Compare(g)) { result.Graphic_Modified.Add(g); } id_to_grap.Remove(g.ID); } else { result.Graphic_Newed.Add(g); } } foreach (Cld_Graphic g in id_to_grap.Values) { result.Graphic_Deleted.Add(g); } } return result; }
/// <summary> /// 比较两个sheet的不同 /// </summary> /// <param name="pre">操作前</param> /// <param name="after">操作后</param> /// <returns></returns> public SheetDiffer CompareSheet(Prj_Sheet pre, Prj_Sheet after) { SheetDiffer result = new SheetDiffer(); if (pre.ID != after.ID) { throw new Exception("sheet id should be equal"); } if (!pre.Compare(after)) { result.Sheet_Modified.Add(after); } {//signal Hashtable id_to_signal1 = new Hashtable(); foreach (Cld_Signal signal in pre.Cld_Signal_List) { id_to_signal1[signal.ID] = signal; } foreach (Cld_Signal signal in after.Cld_Signal_List) { if (id_to_signal1.Contains(signal.ID)) { if (!((Cld_Signal)id_to_signal1[signal.ID]).Compare(signal)) { result.Signal_Modified.Add(signal); } id_to_signal1.Remove(signal.ID); } else { result.Signal_Newed.Add(signal); } } foreach (Cld_Signal signal in id_to_signal1.Values) { result.Signal_Deleted.Add(signal); } } {//cld_fcblcok Hashtable id_to_block = new Hashtable(); foreach (Cld_FCBlock block in pre.Cld_FCBlock_List) { id_to_block[block.ID] = block; } foreach (Cld_FCBlock block in after.Cld_FCBlock_List) { if (id_to_block.Contains(block.ID)) { if (!((Cld_FCBlock)id_to_block[block.ID]).Compare(block)) { result.Block_Modified.Add(block); } //input Hashtable id_to_input = new Hashtable(); foreach (Cld_FCInput input in ((Cld_FCBlock)id_to_block[block.ID]).Cld_FCInput_List) { id_to_input[input.ID] = input; } foreach (Cld_FCInput input in block.Cld_FCInput_List) { if (id_to_input.Contains(input.ID)) { if (!((Cld_FCInput)id_to_input[input.ID]).Compare(input)) { result.Input_Modified.Add(input); } id_to_input.Remove(input.ID); } else { result.Input_Newed.Add(input); } } foreach (Cld_FCInput input in id_to_input.Values) { result.Input_Deleted.Add(input); } //output Hashtable id_to_output = new Hashtable(); foreach (Cld_FCOutput output in ((Cld_FCBlock)id_to_block[block.ID]).Cld_FCOutput_List) { id_to_output[output.ID] = output; } foreach (Cld_FCOutput output in block.Cld_FCOutput_List) { if (id_to_output.Contains(output.ID)) { if (!((Cld_FCOutput)id_to_output[output.ID]).Compare(output)) { result.Output_Modified.Add(output); } id_to_output.Remove(output.ID); } else { result.Output_Newed.Add(output); } } foreach (Cld_FCOutput output in id_to_output.Values) { result.Output_Deleted.Add(output); } //para Hashtable id_to_para = new Hashtable(); foreach (Cld_FCParameter p in ((Cld_FCBlock)id_to_block[block.ID]).Cld_FCParameter_List) { id_to_para[p.ID] = p; } foreach (Cld_FCParameter p in block.Cld_FCParameter_List) { if (id_to_para.Contains(p.ID)) { if (!((Cld_FCParameter)id_to_para[p.ID]).Compare(p)) { result.Para_Modified.Add(p); } id_to_para.Remove(p.ID); } else { result.Para_Newed.Add(p); } } foreach (Cld_FCParameter p in id_to_para.Values) { result.Para_Deleted.Add(p); } id_to_block.Remove(block.ID); } else { result.Block_Newed.Add(block); block.Orin = true; if (block.Cld_FCInput_List != null) { foreach (Cld_FCInput input in block.Cld_FCInput_List) { result.Input_Newed.Add(input); } } if (block.Cld_FCOutput_List != null) { foreach (Cld_FCOutput output in block.Cld_FCOutput_List) { result.Output_Newed.Add(output); } } if (block.Cld_FCParameter_List != null) { foreach (Cld_FCParameter p in block.Cld_FCParameter_List) { result.Para_Newed.Add(p); } } block.Orin = false; } } foreach (Cld_FCBlock block in id_to_block.Values) { result.Block_Deleted.Add(block); foreach (Cld_FCInput input in block.Cld_FCInput_List) { result.Input_Deleted.Add(input); } foreach (Cld_FCOutput output in block.Cld_FCOutput_List) { result.Output_Deleted.Add(output); } foreach (Cld_FCParameter p in block.Cld_FCParameter_List) { result.Para_Deleted.Add(p); } } } { //cld_const Hashtable id_to_const = new Hashtable(); foreach (Cld_Constant con in pre.Cld_Constant_List) { id_to_const[con.ID] = con; } foreach (Cld_Constant con in after.Cld_Constant_List) { if (id_to_const.Contains(con.ID)) { if (!((Cld_Constant)id_to_const[con.ID]).Compare(con)) { result.Const_Modified.Add(con); } id_to_const.Remove(con.ID); } else { result.Const_Newed.Add(con); } } foreach (Cld_Constant con in id_to_const.Values) { result.Const_Deleted.Add(con); } } { //cld_graphic Hashtable id_to_grap = new Hashtable(); foreach (Cld_Graphic g in pre.Cld_Graphic_List) { id_to_grap[g.ID] = g; } foreach (Cld_Graphic g in after.Cld_Graphic_List) { if (id_to_grap.Contains(g)) { if (!((Cld_Graphic)id_to_grap[g.ID]).Compare(g)) { result.Graphic_Modified.Add(g); } id_to_grap.Remove(g.ID); } else { result.Graphic_Newed.Add(g); } } foreach (Cld_Graphic g in id_to_grap.Values) { result.Graphic_Deleted.Add(g); } } return(result); }
/// <summary> /// 向数据库提交sheet /// </summary> /// <param name="diff"></param> /// <returns></returns> public void Commit_Sheet(SheetDiffer diff) { ITransaction transaction = this.session.BeginTransaction(); try { //deleted注意删除的顺序,有可能发生“unexpected row count”异常 foreach (Cld_Signal signal in diff.Signal_Deleted) { this.session.Delete(signal); } foreach (Cld_Constant con in diff.Const_Deleted) { this.session.Delete(con); } foreach (Cld_Graphic g in diff.Graphic_Deleted) { this.session.Delete(g); } foreach (Cld_FCParameter p in diff.Para_Deleted) { this.session.Delete(p); } foreach (Cld_FCInput input in diff.Input_Deleted) { this.session.Delete(input); } foreach (Cld_FCOutput output in diff.Output_Deleted) { this.session.Delete(output); } foreach (Cld_FCBlock block in diff.Block_Deleted) { this.session.Delete(block); } //modified foreach (Cld_Signal signal in diff.Signal_Modified) { this.session.SaveOrUpdate(signal); } foreach (Cld_Constant con in diff.Const_Modified) { this.session.SaveOrUpdate(con); } foreach (Cld_Graphic g in diff.Graphic_Modified) { this.session.SaveOrUpdate(g); } foreach (Cld_FCOutput output in diff.Output_Modified) { this.session.SaveOrUpdate(output); } foreach (Cld_FCInput input in diff.Input_Modified) { this.session.SaveOrUpdate(input); } foreach (Cld_FCParameter p in diff.Para_Modified) { this.session.SaveOrUpdate(p); } foreach (Cld_FCBlock b in diff.Block_Modified) { this.session.SaveOrUpdate(b); } //added foreach (Cld_Signal signal in diff.Signal_Newed) { this.session.Save(signal); } foreach (Cld_Constant con in diff.Const_Newed) { this.session.Save(con); } foreach (Cld_Graphic g in diff.Graphic_Newed) { this.session.Save(g); } foreach (Cld_FCBlock block in diff.Block_Newed) { this.session.Save(block); } foreach (Cld_FCParameter p in diff.Para_Newed) { this.session.Save(p); } foreach (Cld_FCInput input in diff.Input_Newed) { this.session.Save(input); } foreach (Cld_FCOutput output in diff.Output_Newed) { this.session.Save(output); } transaction.Commit(); } catch (Exception e) { if (transaction != null) { transaction.Rollback(); } throw e; } }
/// <summary> /// 向数据库提交sheet /// </summary> /// <param name="diff"></param> /// <returns></returns> public void Commit_Sheet(SheetDiffer diff) { ITransaction transaction = this.session.BeginTransaction(); try { //deleted注意删除的顺序,有可能发生“unexpected row count”异常 foreach (Cld_Signal signal in diff.Signal_Deleted) { this.session.Delete(signal); } foreach (Cld_Constant con in diff.Const_Deleted) { this.session.Delete(con); } foreach (Cld_Graphic g in diff.Graphic_Deleted) { this.session.Delete(g); } foreach (Cld_FCParameter p in diff.Para_Deleted) { this.session.Delete(p); } foreach (Cld_FCInput input in diff.Input_Deleted) { this.session.Delete(input); } foreach (Cld_FCOutput output in diff.Output_Deleted) { this.session.Delete(output); } foreach (Cld_FCBlock block in diff.Block_Deleted) { this.session.Delete(block); } //modified foreach (Cld_Signal signal in diff.Signal_Modified) { this.session.SaveOrUpdate(signal); } foreach (Cld_Constant con in diff.Const_Modified) { this.session.SaveOrUpdate(con); } foreach (Cld_Graphic g in diff.Graphic_Modified) { this.session.SaveOrUpdate(g); } foreach (Cld_FCOutput output in diff.Output_Modified) { this.session.SaveOrUpdate(output); } foreach (Cld_FCInput input in diff.Input_Modified) { this.session.SaveOrUpdate(input); } foreach (Cld_FCParameter p in diff.Para_Modified) { this.session.SaveOrUpdate(p); } foreach (Cld_FCBlock b in diff.Block_Modified) { this.session.SaveOrUpdate(b); } //added foreach (Cld_Signal signal in diff.Signal_Newed) { this.session.Save(signal); } foreach (Cld_Constant con in diff.Const_Newed) { this.session.Save(con); } foreach (Cld_Graphic g in diff.Graphic_Newed) { this.session.Save(g); } foreach (Cld_FCBlock block in diff.Block_Newed) { this.session.Save(block); } foreach (Cld_FCParameter p in diff.Para_Newed) { this.session.Save(p); } foreach (Cld_FCInput input in diff.Input_Newed) { this.session.Save(input); } foreach (Cld_FCOutput output in diff.Output_Newed) { this.session.Save(output); } transaction.Commit(); } catch (Exception e) { if (transaction != null) { transaction.Rollback(); } throw e; } }