Example #1
0
        public void UpdateObject(BusinessObject obj)
        {
            if (DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colSelected))
            {
                ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colSelected, false);
            }

            if (String.IsNullOrWhiteSpace(ABCBaseUserProvider.CurrentUserName) == false &&
                DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colUpdateUser))
            {
                ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colUpdateUser, ABCBaseUserProvider.CurrentUserName);
            }

            if (DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colUpdateTime))
            {
                ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colUpdateTime, ABCApp.ABCDataGlobal.WorkingDate);
            }

            BusinessObjectHelper.GenerateNoColumn(obj, false);

            if (DatabaseHelper.IsSQLConnection())
            {
                (DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.Update, TableName), obj);
            }
            else
            {
                DatabaseHelper.RunScript(QueryTemplateGenerator.GenUpdate(TableName), obj);
            }
        }
Example #2
0
        public virtual Guid CreateObject(BusinessObject obj)
        {
            #region Default Value
            if (DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colSelected))
            {
                ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colSelected, false);
            }

            if (String.IsNullOrWhiteSpace(ABCBaseUserProvider.CurrentUserName) == false &&
                DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colCreateUser))
            {
                ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colCreateUser, ABCBaseUserProvider.CurrentUserName);
            }

            if (DataStructureProvider.IsTableColumn(obj.AATableName, ABCCommon.ABCConstString.colCreateTime))
            {
                ABCDynamicInvoker.SetValue(obj, ABCCommon.ABCConstString.colCreateTime, ABCApp.ABCDataGlobal.WorkingDate);
            }

            #endregion

            Guid iID = Guid.Empty;
            if (DatabaseHelper.IsSQLConnection())
            {
                iID = ABCHelper.DataConverter.ConvertToGuid((DatabaseHelper as SqlDatabaseHelper).RunStoredProcedure(StoredProcedureGenerator.GetSPName(StoredProcedureGenerator.SPType.Insert, TableName), obj));
            }
            else
            {
                String strQuery = QueryTemplateGenerator.GenInsert(TableName);
                iID      = Guid.NewGuid();
                strQuery = strQuery.Replace(String.Format("@{0}", DataStructureProvider.GetPrimaryKeyColumn(TableName)), "'" + iID.ToString() + "'");
                DatabaseHelper.RunScript(strQuery, obj);
            }

            ABCDynamicInvoker.SetValue(obj, DataStructureProvider.GetPrimaryKeyColumn(obj.AATableName), iID);

            if (BusinessObjectHelper.GenerateNoColumn(obj, true))
            {
                UpdateObject(obj);
            }

            return(iID);
        }