/// <summary> /// 获得实体 /// </summary> /// <returns></returns> private YQForm EntityGet() { YQForm entity = new YQForm(); entity.ID = HTDataID; return(entity); }
/// <summary> /// 保存(传入事务处理) /// </summary> /// <param name="p_Entity"></param> /// <param name="p_BE"></param> /// <param name="sqlTrans"></param> public void RSave(YQForm p_Entity, BaseEntity[] p_BE, IDBTransAccess sqlTrans) { try { string sql = "DELETE FROM WH_YQFormDts WHERE MainID=" + p_Entity.ID.ToString(); sql += " AND ID NOT IN" + string.Format("({0})", GetIDExist(p_BE)); sqlTrans.ExecuteNonQuery(sql);//删除原单据里应该删除的明细数据,即数据库里有但是UI里已经删除的数据 for (int i = 0; i < p_BE.Length; i++) { YQFormDts entitydts = (YQFormDts)p_BE[i]; if (entitydts.ID != 0)//ID不为0说明数据库中已经存在 { this.RUpdate(entitydts, sqlTrans); } else { entitydts.MainID = p_Entity.ID; this.RAdd(entitydts, sqlTrans); } } } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 新增(传入事务处理) /// </summary> /// <param name="p_BE">要新增的实体</param> /// <param name="sqlTrans">事务类</param> public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); YQForm entity = (YQForm)p_BE; YQFormCtl control = new YQFormCtl(sqlTrans); string sql = "SELECT FormNo FROM WH_YQForm WHERE FormNo=" + SysString.ToDBString(entity.FormNo); DataTable dt = sqlTrans.Fill(sql); if (dt.Rows.Count > 0) { throw new BaseException("溢缺单号已存在,请双击单号重新生成"); } entity.ID = (int)EntityIDTable.GetID((long)SysEntity.WH_YQForm, sqlTrans); control.AddNew(entity); FormNoControlRule rule = new FormNoControlRule(); rule.RAddSort((int)FormNoControlEnum.溢缺单号, sqlTrans); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 删除 /// </summary> public override void EntityDelete() { YQFormRule rule = new YQFormRule(); YQForm entity = EntityGet(); rule.RDelete(entity); }
/// <summary> /// 删除 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int Delete(BaseEntity p_Entity) { try { YQForm MasterEntity = (YQForm)p_Entity; if (MasterEntity.ID == 0) { return(0); } //删除主表数据 string Sql = ""; Sql = "DELETE FROM WH_YQForm WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID); //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(Sql); } else { AffectedRows = sqlTrans.ExecuteNonQuery(Sql); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete), E); } }
/// <summary> /// 检验字段值是否已存在 /// </summary> /// <param name="p_TableName">表名</param> /// <param name="p_FieldName">字段名</param> /// <param name="p_FieldValue">字段值</param> /// <param name="p_KeyField">主键(只考虑主键为ID的情况)</param> /// <param name="p_KeyValue">主键值</param> /// <param name="p_sqlTrans"></param> /// <returns></returns> private bool CheckFieldValueIsExist(BaseEntity p_BE, string p_FieldName, string p_FieldValue, IDBTransAccess p_sqlTrans) { YQForm entity = (YQForm)p_BE; bool ret = false; string sql = string.Format(" SELECT {0} FROM {1} WHERE 1=1 AND {0}={2} AND {3}<>{4}", p_FieldName, YQForm.TableName, SysString.ToDBString(p_FieldValue), "ID", entity.ID); DataTable dt = p_sqlTrans.Fill(sql); if (dt.Rows.Count != 0) { ret = true; } return(ret); }
public void RSave(YQForm p_Entity, YQFormDts[] p_EntityDts, ArrayList list, IDBTransAccess sqlTrans) { try { string sql = string.Empty; sql = "SELECT BoxNo FROM WH_YQFormDtsPack WHERE MainID=" + p_Entity.ID.ToString(); sql += " AND ID NOT IN" + string.Format("({0})", GetIDExist(list)); DataTable dtDelete = sqlTrans.Fill(sql); //删除表结构 if (dtDelete.Rows.Count != 0) //有需要删除的数据 { sql = "DELETE FROM WH_YQFormDtsPack WHERE MainID=" + p_Entity.ID.ToString(); sql += " AND ID NOT IN" + string.Format("({0})", GetIDExist(list)); sqlTrans.ExecuteNonQuery(sql);//删除原单据里应该删除的明细数据,即数据库里有但是UI里已经删除的数据 } for (int i = 0; i < list.Count; i++) { YQFormDtsPack entitydts = (YQFormDtsPack)list[i]; int YQFormdtsdex = -1; for (int m = 0; m < p_EntityDts.Length; m++) { if (p_EntityDts[m].Seq == entitydts.Seq)//找到相同的SEQ了 { YQFormdtsdex = m; break; } } if (YQFormdtsdex == -1)//未找到,异常 { throw new Exception("码单输入异常,未找到单据明细,行号:" + entitydts.Seq); } entitydts.MainID = p_Entity.ID; this.RAdd(p_Entity, p_EntityDts[YQFormdtsdex], entitydts, sqlTrans); } } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
public void RAdd(YQForm p_MainEntity, YQFormDts p_MainDts, BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); YQFormDtsPack entity = (YQFormDtsPack)p_BE; this.RAdd(entity, sqlTrans);//后插入的原因是箱号是在插入箱号实体时生成的 } 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); YQForm entity = (YQForm)p_BE; YQFormCtl control = new YQFormCtl(sqlTrans); control.Delete(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 RUpdate(BaseEntity p_BE, BaseEntity[] p_BE2, ArrayList list, IDBTransAccess sqlTrans) { try { YQForm entity = (YQForm)p_BE; this.RUpdate(p_BE, sqlTrans); YQFormDtsRule ruledts = new YQFormDtsRule(); ruledts.RSave((YQForm)p_BE, (YQFormDts[])p_BE2, sqlTrans);//保存从表 //删除数据库中此单据类型的码单信息2011-07-12 YQFormDtsPackRule dtsprule = new YQFormDtsPackRule();//保存码单明细 dtsprule.RSave(entity, (YQFormDts[])p_BE2, list, sqlTrans); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 新增(传入事务处理) /// </summary> /// <param name="p_BE">要新增的实体</param> /// <param name="sqlTrans">事务类</param> public void RAdd2(BaseEntity p_BE, BaseEntity[] p_BE2, ArrayList list, IDBTransAccess sqlTrans) { try { YQForm entity = (YQForm)p_BE; this.RAdd(p_BE, sqlTrans); YQFormDtsRule ruledts = new YQFormDtsRule(); ruledts.RSave((YQForm)p_BE, p_BE2, sqlTrans);//保存从表 YQFormDtsPackRule dtsprule = new YQFormDtsPackRule();//保存码单明细 dtsprule.RSave(entity, (YQFormDts[])p_BE2, list, sqlTrans); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 审核 /// </summary> /// <param name="p_FormID">单据ID</param> /// <param name="p_Type">0/1/2/3:弃审/审核</param> public void RSubmit(int p_FormID, int p_Type, IDBTransAccess sqlTrans) { try { int p_TempType = p_Type;//处理状态 string sql = string.Empty; YQForm entity = new YQForm(sqlTrans); entity.ID = p_FormID; entity.SelectByID(); if (entity.SubmitFlag == p_Type)//如果相同异常 { throw new Exception("单据状态重复设置,请关闭程序重新打开操作"); } #region 提交 sql = "UPDATE WH_YQForm SET SubmitFlag=" + SysString.ToDBString(p_Type); if (p_Type == (int)ConfirmFlag.审核通过 || p_Type == (int)ConfirmFlag.审核拒绝) { sql += ",SubmitOPID=" + SysString.ToDBString(ParamConfig.LoginName) + ",SubmitTime=" + SysString.ToDBString(DateTime.Now); } sql += " WHERE ID=" + p_FormID.ToString();//更新单据主表审核状态 sqlTrans.ExecuteNonQuery(sql); sql = "SELECT DLaodDtsID,MoveQty FROM WH_YQFormDts WHERE MainID=" + SysString.ToDBString(p_FormID); DataTable dt = sqlTrans.Fill(sql); for (int i = 0; i < dt.Rows.Count; i++) { int DLaodDtsID = SysConvert.ToInt32(dt.Rows[i][0]); if (DLaodDtsID > 0) { if (p_Type == (int)ConfirmFlag.已提交) { sql = "UPDATE WH_IOFormDts SET YQQty=ISNULL(YQQty,0)+" + SysString.ToDBString(SysConvert.ToDecimal(dt.Rows[i]["MoveQty"])); sql += " WHERE ID=" + SysString.ToDBString(DLaodDtsID); sqlTrans.ExecuteNonQuery(sql); } else { sql = "UPDATE WH_IOFormDts SET YQQty=ISNULL(YQQty,0)-(" + SysString.ToDBString(SysConvert.ToDecimal(dt.Rows[i]["MoveQty"])) + ")"; sql += " WHERE ID=" + SysString.ToDBString(DLaodDtsID); sqlTrans.ExecuteNonQuery(sql); } } } #endregion if (entity.SubmitFlag == p_Type)//如果相同异常 { throw new Exception("单据状态重复设置,请关闭程序重新打开操作"); } } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 检查将要操作的数据是否符合业务规则 /// </summary> /// <param name="p_BE"></param> private void CheckCorrect(BaseEntity p_BE) { YQForm entity = (YQForm)p_BE; }
/// <summary> /// 新增 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int AddNew(BaseEntity p_Entity) { try { YQForm MasterEntity = (YQForm)p_Entity; if (MasterEntity.ID == 0) { return(0); } //新增主表数据 StringBuilder MasterField = new StringBuilder(); StringBuilder MasterValue = new StringBuilder(); MasterField.Append("INSERT INTO WH_YQForm("); MasterValue.Append(" VALUES("); MasterField.Append("ID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ","); MasterField.Append("FromIOFormID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.FromIOFormID) + ","); MasterField.Append("CompanyTypeID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.CompanyTypeID) + ","); MasterField.Append("WHTypeID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.WHTypeID) + ","); MasterField.Append("FormNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.FormNo) + ","); MasterField.Append("HeadType" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.HeadType) + ","); MasterField.Append("SubType" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.SubType) + ","); MasterField.Append("VendorID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.VendorID) + ","); MasterField.Append("OutDep" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.OutDep) + ","); MasterField.Append("Indep" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.Indep) + ","); MasterField.Append("WHOP" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.WHOP) + ","); MasterField.Append("PassOP" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.PassOP) + ","); MasterField.Append("DutyOP" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.DutyOP) + ","); MasterField.Append("SOID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.SOID) + ","); MasterField.Append("SpecialNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.SpecialNo) + ","); MasterField.Append("FormDate" + ","); if (MasterEntity.FormDate != SystemConfiguration.DateTimeDefaultValue) { MasterValue.Append(SysString.ToDBString(MasterEntity.FormDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("CardNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.CardNo) + ","); MasterField.Append("ConfirmFlag" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ConfirmFlag) + ","); MasterField.Append("CheckOP" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.CheckOP) + ","); MasterField.Append("CheckDate" + ","); if (MasterEntity.CheckDate != SystemConfiguration.DateTimeDefaultValue) { MasterValue.Append(SysString.ToDBString(MasterEntity.CheckDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("WHID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.WHID) + ","); MasterField.Append("WHType" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.WHType) + ","); MasterField.Append("LastUpdTime" + ","); if (MasterEntity.LastUpdTime != SystemConfiguration.DateTimeDefaultValue) { MasterValue.Append(SysString.ToDBString(MasterEntity.LastUpdTime.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("LastUpdOP" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.LastUpdOP) + ","); MasterField.Append("DelFlag" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.DelFlag) + ","); MasterField.Append("SubmitFlag" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.SubmitFlag) + ","); MasterField.Append("Remark" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.Remark) + ","); MasterField.Append("JHCode" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.JHCode) + ","); MasterField.Append("XZ" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.XZ) + ","); MasterField.Append("SaleOPID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.SaleOPID) + ","); MasterField.Append("DM" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.DM) + ","); MasterField.Append("InvoiceNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.InvoiceNo) + ","); MasterField.Append("TotalQty" + ","); if (MasterEntity.TotalQty != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.TotalQty) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("TotalAmount" + ","); if (MasterEntity.TotalAmount != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.TotalAmount) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("SubmitOPID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.SubmitOPID) + ","); MasterField.Append("SubmitTime" + ","); if (MasterEntity.SubmitTime != SystemConfiguration.DateTimeDefaultValue) { MasterValue.Append(SysString.ToDBString(MasterEntity.SubmitTime.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("FHTypeID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.FHTypeID) + ","); MasterField.Append("KDNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.KDNo) + ","); MasterField.Append("DEFlag" + ")"); MasterValue.Append(SysString.ToDBString(MasterEntity.DEFlag) + ")"); //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString()); } else { AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString()); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E); } }
/// <summary> /// 修改 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int Update(BaseEntity p_Entity) { try { YQForm MasterEntity = (YQForm)p_Entity; if (MasterEntity.ID == 0) { return(0); } //更新主表数据 StringBuilder UpdateBuilder = new StringBuilder(); UpdateBuilder.Append("UPDATE WH_YQForm SET "); UpdateBuilder.Append(" ID=" + SysString.ToDBString(MasterEntity.ID) + ","); UpdateBuilder.Append(" FromIOFormID=" + SysString.ToDBString(MasterEntity.FromIOFormID) + ","); UpdateBuilder.Append(" CompanyTypeID=" + SysString.ToDBString(MasterEntity.CompanyTypeID) + ","); UpdateBuilder.Append(" WHTypeID=" + SysString.ToDBString(MasterEntity.WHTypeID) + ","); UpdateBuilder.Append(" FormNo=" + SysString.ToDBString(MasterEntity.FormNo) + ","); UpdateBuilder.Append(" HeadType=" + SysString.ToDBString(MasterEntity.HeadType) + ","); UpdateBuilder.Append(" SubType=" + SysString.ToDBString(MasterEntity.SubType) + ","); UpdateBuilder.Append(" VendorID=" + SysString.ToDBString(MasterEntity.VendorID) + ","); UpdateBuilder.Append(" OutDep=" + SysString.ToDBString(MasterEntity.OutDep) + ","); UpdateBuilder.Append(" Indep=" + SysString.ToDBString(MasterEntity.Indep) + ","); UpdateBuilder.Append(" WHOP=" + SysString.ToDBString(MasterEntity.WHOP) + ","); UpdateBuilder.Append(" PassOP=" + SysString.ToDBString(MasterEntity.PassOP) + ","); UpdateBuilder.Append(" DutyOP=" + SysString.ToDBString(MasterEntity.DutyOP) + ","); UpdateBuilder.Append(" SOID=" + SysString.ToDBString(MasterEntity.SOID) + ","); UpdateBuilder.Append(" SpecialNo=" + SysString.ToDBString(MasterEntity.SpecialNo) + ","); if (MasterEntity.FormDate != SystemConfiguration.DateTimeDefaultValue) { UpdateBuilder.Append(" FormDate=" + SysString.ToDBString(MasterEntity.FormDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { UpdateBuilder.Append(" FormDate=null,"); } UpdateBuilder.Append(" CardNo=" + SysString.ToDBString(MasterEntity.CardNo) + ","); UpdateBuilder.Append(" ConfirmFlag=" + SysString.ToDBString(MasterEntity.ConfirmFlag) + ","); UpdateBuilder.Append(" CheckOP=" + SysString.ToDBString(MasterEntity.CheckOP) + ","); if (MasterEntity.CheckDate != SystemConfiguration.DateTimeDefaultValue) { UpdateBuilder.Append(" CheckDate=" + SysString.ToDBString(MasterEntity.CheckDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { UpdateBuilder.Append(" CheckDate=null,"); } UpdateBuilder.Append(" WHID=" + SysString.ToDBString(MasterEntity.WHID) + ","); UpdateBuilder.Append(" WHType=" + SysString.ToDBString(MasterEntity.WHType) + ","); if (MasterEntity.LastUpdTime != SystemConfiguration.DateTimeDefaultValue) { UpdateBuilder.Append(" LastUpdTime=" + SysString.ToDBString(MasterEntity.LastUpdTime.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { UpdateBuilder.Append(" LastUpdTime=null,"); } UpdateBuilder.Append(" LastUpdOP=" + SysString.ToDBString(MasterEntity.LastUpdOP) + ","); UpdateBuilder.Append(" DelFlag=" + SysString.ToDBString(MasterEntity.DelFlag) + ","); UpdateBuilder.Append(" SubmitFlag=" + SysString.ToDBString(MasterEntity.SubmitFlag) + ","); UpdateBuilder.Append(" Remark=" + SysString.ToDBString(MasterEntity.Remark) + ","); UpdateBuilder.Append(" JHCode=" + SysString.ToDBString(MasterEntity.JHCode) + ","); UpdateBuilder.Append(" XZ=" + SysString.ToDBString(MasterEntity.XZ) + ","); UpdateBuilder.Append(" SaleOPID=" + SysString.ToDBString(MasterEntity.SaleOPID) + ","); UpdateBuilder.Append(" DM=" + SysString.ToDBString(MasterEntity.DM) + ","); UpdateBuilder.Append(" InvoiceNo=" + SysString.ToDBString(MasterEntity.InvoiceNo) + ","); if (MasterEntity.TotalQty != 0) { UpdateBuilder.Append(" TotalQty=" + SysString.ToDBString(MasterEntity.TotalQty) + ","); } else { UpdateBuilder.Append(" TotalQty=null,"); } if (MasterEntity.TotalAmount != 0) { UpdateBuilder.Append(" TotalAmount=" + SysString.ToDBString(MasterEntity.TotalAmount) + ","); } else { UpdateBuilder.Append(" TotalAmount=null,"); } UpdateBuilder.Append(" SubmitOPID=" + SysString.ToDBString(MasterEntity.SubmitOPID) + ","); if (MasterEntity.SubmitTime != SystemConfiguration.DateTimeDefaultValue) { UpdateBuilder.Append(" SubmitTime=" + SysString.ToDBString(MasterEntity.SubmitTime.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { UpdateBuilder.Append(" SubmitTime=null,"); } UpdateBuilder.Append(" FHTypeID=" + SysString.ToDBString(MasterEntity.FHTypeID) + ","); UpdateBuilder.Append(" KDNo=" + SysString.ToDBString(MasterEntity.KDNo) + ","); UpdateBuilder.Append(" DEFlag=" + SysString.ToDBString(MasterEntity.DEFlag)); UpdateBuilder.Append(" WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID)); //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString()); } else { AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString()); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E); } }