/// <summary> /// 新增(传入事务处理) /// </summary> /// <param name="p_BE">要新增的实体</param> /// <param name="sqlTrans">事务类</param> public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); CWDuiZhang entity = (CWDuiZhang)p_BE; CWDuiZhangCtl control = new CWDuiZhangCtl(sqlTrans); string sql = "SELECT Code FROM CaiWu_CWDuiZhang WHERE Code=" + SysString.ToDBString(entity.Code) + " AND DZTypeID=" + SysString.ToDBString(entity.DZTypeID); if (sqlTrans.Fill(sql).Rows.Count != 0) { throw new Exception("该单号已经存在,请双击重新生成"); } //entity.ID = (int)EntityIDTable.GetID((long)SysEntity.CaiWu_CWDuiZhang, sqlTrans); control.AddNew(entity); if (entity.DZTypeID == 1) { //sql = " UPDATE Enum_FormNoControl SET CurSort=CurSort+1 WHERE ID=" + (int)FormNoControlEnum.进项对账单号;//更新CurSort } else if (entity.DZTypeID == 2) { //sql = " UPDATE Enum_FormNoControl SET CurSort=CurSort+1 WHERE ID=" + (int)FormNoControlEnum.销项对账单号;//更新CurSort } SysUtils.ExecuteNonQuery(sql); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 修改 /// </summary> /// <param name="p_BE">要修改的实体</param> /// <param name="sqlTrans">事务类</param> public void RUpdate(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); CWDuiZhang entity = (CWDuiZhang)p_BE; CWDuiZhangCtl control = new CWDuiZhangCtl(sqlTrans); control.Update(entity); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 删除 /// </summary> /// <param name="p_BE">要删除的实体</param> /// <param name="sqlTrans">事务类</param> public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); CWDuiZhang entity = (CWDuiZhang)p_BE; CWDuiZhangCtl control = new CWDuiZhangCtl(sqlTrans); ///初始化对账标志 string sql = "Select * From CaiWu_CWDuiZhangDts WHERE 1=1"; sql += " AND MainID=" + SysString.ToDBString(entity.ID); DataTable dt = sqlTrans.Fill(sql); if (dt.Rows.Count != 0) { for (int i = 0; i < dt.Rows.Count; i++) { sql = "Update WH_IOFormDts Set DZFlag=0,DZTime=null,DZOPID='',DZNo=''"; sql += " WHERE 1=1 AND MainID=" + SysConvert.ToInt32(dt.Rows[i]["IOFormID"]); sql += " AND Seq=" + SysConvert.ToInt32(dt.Rows[i]["IOFormSeq"]); sqlTrans.ExecuteNonQuery(sql); } } sql = "DELETE FROM CaiWu_CWDuiZhangDts WHERE MainID=" + entity.ID.ToString(); sqlTrans.ExecuteNonQuery(sql);//删除原单据明细数据 control.Delete(entity); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }