示例#1
0
 public static void RecipientUpdateSent(int recipientId, int deliveryTypeId, bool sent)
 {
     DbHelper2.RunSp("SystemEventRecipientUpdateSent",
                     DbHelper2.mp("@RecipientId", SqlDbType.Int, recipientId),
                     DbHelper2.mp("@DeliveryTypeId", SqlDbType.Int, deliveryTypeId),
                     DbHelper2.mp("@Sent", SqlDbType.Bit, sent));
 }
示例#2
0
 public static void UpdateUserException(int ExceptionId, DateTime FromDate, DateTime ToDate)
 {
     DbHelper2.RunSp("UserCalendarExceptionUpdate",
                     DbHelper2.mp("@ExceptionId", SqlDbType.Int, ExceptionId),
                     DbHelper2.mp("@FromDate", SqlDbType.DateTime, FromDate),
                     DbHelper2.mp("@ToDate", SqlDbType.DateTime, ToDate));
 }
示例#3
0
        public virtual void Update()
        {
            if (_state == DataRowState.Modified)
            {
                DbHelper2.RunSp("mc_BusinessScoreUpdate"

                                , DbHelper2.mp("@BusinessScoreId", SqlDbType.Int, _BusinessScoreId)

                                , DbHelper2.mp("@Key", SqlDbType.NVarChar, 15, _Key)

                                , DbHelper2.mp("@Name", SqlDbType.NVarChar, 255, _Name)

                                );
            }
            else if (_state == DataRowState.Added)
            {
                SqlParameter outPutKey = new SqlParameter("@BusinessScoreId", SqlDbType.Int);
                outPutKey.Direction = ParameterDirection.Output;

                DbHelper2.RunSp("mc_BusinessScoreInsert", outPutKey

                                , DbHelper2.mp("@Key", SqlDbType.NVarChar, 15, _Key)

                                , DbHelper2.mp("@Name", SqlDbType.NVarChar, 255, _Name)

                                );

                _BusinessScoreId = (int)outPutKey.Value;
            }
        }
示例#4
0
 public static void UpdateOutlineLevelAndNumber(int AccountId, int OutlineLevel, string OutlineNumber)
 {
     DbHelper2.RunSp("AccountUpdateOutlineLevelAndNumber",
                     DbHelper2.mp("@AccountId", SqlDbType.Int, AccountId),
                     DbHelper2.mp("@OutlineLevel", SqlDbType.Int, OutlineLevel),
                     DbHelper2.mp("@OutlineNumber", SqlDbType.VarChar, 255, OutlineNumber));
 }
示例#5
0
 public static void Update(int CalendarId, string CalendarName, int TimeZoneId)
 {
     DbHelper2.RunSp("CalendarUpdate",
                     DbHelper2.mp("@CalendarId", SqlDbType.Int, CalendarId),
                     DbHelper2.mp("@CalendarName", SqlDbType.NVarChar, 250, CalendarName),
                     DbHelper2.mp("@TimeZoneId", SqlDbType.Int, TimeZoneId));
 }
示例#6
0
 public static void DeleteReminderSubscriptionPersonalForObject(int DateTypeId, int UserId, int ObjectId)
 {
     DbHelper2.RunSp("ReminderSubscribtionDeletePersonalForObject",
                     DbHelper2.mp("@DateTypeId", SqlDbType.Int, DateTypeId),
                     DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
                     DbHelper2.mp("@ObjectId", SqlDbType.Int, ObjectId));
 }
示例#7
0
 public static void UpdateAccountECur(int AccountId, decimal Value, int LastEditorId)
 {
     DbHelper2.RunSp("AccountUpdateECur",
                     DbHelper2.mp("@AccountId", SqlDbType.Int, AccountId),
                     DbHelper2.mp("@Value", SqlDbType.Money, Value),
                     DbHelper2.mp("@LastEditorId", SqlDbType.Int, LastEditorId));
 }
示例#8
0
        /// <summary>
        /// Updates this instance.
        /// </summary>
        public virtual void Update()
        {
            if (_state == DataRowState.Modified)
            {
                DbHelper2.RunSp("mc_PendingEMailMessageUpdate"

                                , DbHelper2.mp("@PendingEMailMessageId", SqlDbType.Int, _PendingEMailMessageId)

                                , DbHelper2.mp("@EMailMessageId", SqlDbType.Int, _EMailMessageId)

                                );
            }
            else if (_state == DataRowState.Added)
            {
                SqlParameter outPutKey = new SqlParameter("@PendingEMailMessageId", SqlDbType.Int);
                outPutKey.Direction = ParameterDirection.Output;

                DbHelper2.RunSp("mc_PendingEMailMessageInsert", outPutKey

                                , DbHelper2.mp("@EMailMessageId", SqlDbType.Int, _EMailMessageId)

                                );

                _PendingEMailMessageId = (int)outPutKey.Value;
            }
        }
示例#9
0
        public virtual void Update()
        {
            if (_state == DataRowState.Modified)
            {
                DbHelper2.RunSp("mc_BasePlanSlotUpdate"

                                , DbHelper2.mp("@BasePlanSlotId", SqlDbType.Int, _BasePlanSlotId)

                                , DbHelper2.mp("@Name", SqlDbType.NVarChar, 50, _Name)

                                , DbHelper2.mp("@IsDefault", SqlDbType.Bit, _IsDefault)

                                );
            }
            else if (_state == DataRowState.Added)
            {
                SqlParameter outPutKey = new SqlParameter("@BasePlanSlotId", SqlDbType.Int);
                outPutKey.Direction = ParameterDirection.Output;

                DbHelper2.RunSp("mc_BasePlanSlotInsert", outPutKey

                                , DbHelper2.mp("@Name", SqlDbType.NVarChar, 50, _Name)

                                , DbHelper2.mp("@IsDefault", SqlDbType.Bit, _IsDefault)

                                );

                _BasePlanSlotId = (int)outPutKey.Value;
            }
        }
示例#10
0
 public static void TemplateUpdate(string key, string subject, string body)
 {
     DbHelper2.RunSp("Alert2TemplateUpdate",
                     DbHelper2.mp("@Key", SqlDbType.NVarChar, 100, key),
                     DbHelper2.mp("@Subject", SqlDbType.NVarChar, 1000, subject),
                     DbHelper2.mp("@Body", SqlDbType.NText, body));
 }
示例#11
0
 public static void LogPortalLogin(int UserId, string IP)
 {
     DbHelper2.RunSp("PortalLoginAdd",
                     DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
                     DbHelper2.mp("@LoginTime", SqlDbType.DateTime, DateTime.UtcNow),
                     DbHelper2.mp("@IP", SqlDbType.VarChar, 15, IP));
 }
        /// <summary>
        /// Updates this instance.
        /// </summary>
        public virtual void Update()
        {
            if (_state == DataRowState.Modified)
            {
                DbHelper2.RunSp("mc_EMailMessageAntiSpamItemUpdate"

                                , DbHelper2.mp("@EMailMessageAntiSpamItemId", SqlDbType.Int, _EMailMessageAntiSpamItemId)

                                , DbHelper2.mp("@From", SqlDbType.NVarChar, 255, _From)

                                , DbHelper2.mp("@IsWhite", SqlDbType.Bit, _IsWhite)

                                );
            }
            else if (_state == DataRowState.Added)
            {
                SqlParameter outPutKey = new SqlParameter("@EMailMessageAntiSpamItemId", SqlDbType.Int);
                outPutKey.Direction = ParameterDirection.Output;

                DbHelper2.RunSp("mc_EMailMessageAntiSpamItemInsert", outPutKey

                                , DbHelper2.mp("@From", SqlDbType.NVarChar, 255, _From)

                                , DbHelper2.mp("@IsWhite", SqlDbType.Bit, _IsWhite)

                                );

                _EMailMessageAntiSpamItemId = (int)outPutKey.Value;
            }
        }
示例#13
0
 public static void UpdateResolutionInfo(int issueId, string resolution, string workaround)
 {
     DbHelper2.RunSp("Act_IssueUpdateResolutionInfo",
                     DbHelper2.mp("@IssueId", SqlDbType.Int, issueId),
                     DbHelper2.mp("@Resolution", SqlDbType.NText, resolution),
                     DbHelper2.mp("@Workaround", SqlDbType.NText, workaround));
 }
示例#14
0
 public static void UnsubscribePersonalForObject(int EventTypeId, int UserId, int ObjectId)
 {
     DbHelper2.RunSp("SubscribtionUnsubscribePersonalForObject",
                     DbHelper2.mp("@EventTypeId", SqlDbType.Int, EventTypeId),
                     DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
                     DbHelper2.mp("@ObjectId", SqlDbType.Int, ObjectId));
 }
示例#15
0
 public static void AddNewDateTypeValue(int DateTypeId, int ObjectId, DateTime DateValue)
 {
     DbHelper2.RunSp("DateTypeValueAddNew",
                     DbHelper2.mp("@DateTypeId", SqlDbType.Int, DateTypeId),
                     DbHelper2.mp("@ObjectId", SqlDbType.Int, ObjectId),
                     DbHelper2.mp("@DateValue", SqlDbType.DateTime, DateValue));
 }
示例#16
0
 public static void UpdateClient(int GroupId, PrimaryKeyId contactUid, PrimaryKeyId orgUid)
 {
     DbHelper2.RunSp("GroupUpdateClient",
                     DbHelper2.mp("@PrincipalId", SqlDbType.Int, GroupId),
                     DbHelper2.mp("@ContactUid", SqlDbType.UniqueIdentifier, contactUid),
                     DbHelper2.mp("@OrgUid", SqlDbType.UniqueIdentifier, orgUid));
 }
示例#17
0
 public static void DeleteDateTypeValue(int dateTypeId, int?objectId, Guid?objectUid)
 {
     DbHelper2.RunSp("DateTypeValueDelete",
                     DbHelper2.mp("@DateTypeId", SqlDbType.Int, dateTypeId),
                     DbHelper2.mp("@ObjectId", SqlDbType.Int, objectId),
                     DbHelper2.mp("@objectUid", SqlDbType.UniqueIdentifier, objectUid));
 }
示例#18
0
 public static void UpdateGeneralInfo(int todoId, string title, string description)
 {
     DbHelper2.RunSp("Act_TodoUpdateGeneralInfo",
                     DbHelper2.mp("@TodoId", SqlDbType.Int, todoId),
                     DbHelper2.mp("@Title", SqlDbType.NVarChar, 255, title),
                     DbHelper2.mp("@Description", SqlDbType.NText, description));
 }
示例#19
0
 public static void UpdateActualFinancesValue(int ActualId, decimal AValue, int LastEditorId)
 {
     DbHelper2.RunSp("ActualFinancesUpdateValue",
                     DbHelper2.mp("@ActualId", SqlDbType.Int, ActualId),
                     DbHelper2.mp("@AValue", SqlDbType.Money, AValue),
                     DbHelper2.mp("@LastEditorId", SqlDbType.Int, LastEditorId));
 }
        public virtual void Update()
        {
            if (_state == DataRowState.Modified)
            {
                DbHelper2.RunSp("mc_EMailIssueExternalRecipientUpdate"

                                , DbHelper2.mp("@EMailIssueExternalRecipientId", SqlDbType.Int, _EMailIssueExternalRecipientId)

                                , DbHelper2.mp("@IssueId", SqlDbType.Int, _IssueId)

                                , DbHelper2.mp("@EMail", SqlDbType.NVarChar, 255, _EMail)

                                );
            }
            else if (_state == DataRowState.Added)
            {
                SqlParameter outPutKey = new SqlParameter("@EMailIssueExternalRecipientId", SqlDbType.Int);
                outPutKey.Direction = ParameterDirection.Output;

                DbHelper2.RunSp("mc_EMailIssueExternalRecipientInsert", outPutKey

                                , DbHelper2.mp("@IssueId", SqlDbType.Int, _IssueId)

                                , DbHelper2.mp("@EMail", SqlDbType.NVarChar, 255, _EMail)

                                );

                _EMailIssueExternalRecipientId = (int)outPutKey.Value;
            }
        }
示例#21
0
 public static void RenameAccount(int AccountId, string Title, int LastEditorId)
 {
     DbHelper2.RunSp("AccountRename",
                     DbHelper2.mp("@AccountId", SqlDbType.Int, AccountId),
                     DbHelper2.mp("@Title", SqlDbType.NVarChar, 255, Title),
                     DbHelper2.mp("@LastEditorId", SqlDbType.Int, LastEditorId));
 }
示例#22
0
        public virtual void Update()
        {
            if (_state == DataRowState.Modified)
            {
                DbHelper2.RunSp("mc_ProjectBasePlanInfoUpdate"

                                , DbHelper2.mp("@ProjectBasePlanInfoId", SqlDbType.Int, _ProjectBasePlanInfoId)

                                , DbHelper2.mp("@ProjectId", SqlDbType.Int, _ProjectId)

                                , DbHelper2.mp("@BasePlanSlotId", SqlDbType.Int, _BasePlanSlotId)

                                , DbHelper2.mp("@Created", SqlDbType.DateTime, _Created)

                                );
            }
            else if (_state == DataRowState.Added)
            {
                SqlParameter outPutKey = new SqlParameter("@ProjectBasePlanInfoId", SqlDbType.Int);
                outPutKey.Direction = ParameterDirection.Output;

                DbHelper2.RunSp("mc_ProjectBasePlanInfoInsert", outPutKey

                                , DbHelper2.mp("@ProjectId", SqlDbType.Int, _ProjectId)

                                , DbHelper2.mp("@BasePlanSlotId", SqlDbType.Int, _BasePlanSlotId)

                                , DbHelper2.mp("@Created", SqlDbType.DateTime, _Created)

                                );

                _ProjectBasePlanInfoId = (int)outPutKey.Value;
            }
        }
示例#23
0
        public virtual void Update()
        {
            if (_state == DataRowState.Modified)
            {
                DbHelper2.RunSp("mc_EMailIncidentMappingUpdate"

                                , DbHelper2.mp("@EMailIncidentMappingId", SqlDbType.Int, _EMailIncidentMappingId)

                                , DbHelper2.mp("@Name", SqlDbType.NVarChar, 255, _Name)

                                , DbHelper2.mp("@Type", SqlDbType.NVarChar, 1024, _Type)

                                , DbHelper2.mp("@UserControl", SqlDbType.NVarChar, 1024, _UserControl)

                                );
            }
            else if (_state == DataRowState.Added)
            {
                SqlParameter outPutKey = new SqlParameter("@EMailIncidentMappingId", SqlDbType.Int);
                outPutKey.Direction = ParameterDirection.Output;

                DbHelper2.RunSp("mc_EMailIncidentMappingInsert", outPutKey

                                , DbHelper2.mp("@Name", SqlDbType.NVarChar, 255, _Name)

                                , DbHelper2.mp("@Type", SqlDbType.NVarChar, 1024, _Type)

                                , DbHelper2.mp("@UserControl", SqlDbType.NVarChar, 1024, _UserControl)

                                );

                _EMailIncidentMappingId = (int)outPutKey.Value;
            }
        }
示例#24
0
 public static void LocalAddressRangeUpdate(int rangeId, string startAddress, string endAddress)
 {
     DbHelper2.RunSp("LocalAddressRangeUpdate",
                     DbHelper2.mp("@RangeId", SqlDbType.Int, rangeId),
                     DbHelper2.mp("@StartAddress", SqlDbType.NVarChar, 32, startAddress),
                     DbHelper2.mp("@EndAddress", SqlDbType.NVarChar, 32, endAddress));
 }
示例#25
0
 public static void AddUserCalendar(
     int CalendarId, int UserId)
 {
     DbHelper2.RunSp("UserCalendarAdd",
                     DbHelper2.mp("@CalendarId", SqlDbType.Int, CalendarId),
                     DbHelper2.mp("@UserId", SqlDbType.Int, UserId));
 }
示例#26
0
 public static void ResourceAdd(int objectId, int principalId, bool mustBeConfirmed)
 {
     DbHelper2.RunSp("Act_EventResourceAdd",
                     DbHelper2.mp("@ObjectId", SqlDbType.Int, objectId),
                     DbHelper2.mp("@PrincipalId", SqlDbType.Int, principalId),
                     DbHelper2.mp("@MustBeConfirmed", SqlDbType.Bit, mustBeConfirmed));
 }
示例#27
0
 public static void AddResource(int EventId, int PrincipalId, bool MustBeConfirmed)
 {
     DbHelper2.RunSp("EventResourceAdd",
                     DbHelper2.mp("@EventId", SqlDbType.Int, EventId),
                     DbHelper2.mp("@PrincipalId", SqlDbType.Int, PrincipalId),
                     DbHelper2.mp("@MustBeConfirmed", SqlDbType.Bit, MustBeConfirmed));
 }
示例#28
0
 public static void UpdateProjectAndManager(int eventId, int projectId, int managerId)
 {
     DbHelper2.RunSp("Act_EventUpdateProjectAndManager",
                     DbHelper2.mp("@EventId", SqlDbType.Int, eventId),
                     DbHelper2.mp("@ProjectId", SqlDbType.Int, projectId),
                     DbHelper2.mp("@ManagerId", SqlDbType.Int, managerId));
 }
示例#29
0
文件: DbLdap.cs 项目: alex765022/IBN
 public static void SettingsUpdateLastSynchronization(int LdapId, DateTime LastSynchronization)
 {
     DbHelper2.RunSp("LdapSettingsUpdateLastSynchronization"
                     , DbHelper2.mp("@LdapId", SqlDbType.Int, LdapId)
                     , DbHelper2.mp("@LastSynchronization", SqlDbType.DateTime, LastSynchronization)
                     );
 }
示例#30
0
        public virtual void Update()
        {
            if (_state == DataRowState.Modified)
            {
                DbHelper2.RunSp("mc_PortalConfigUpdate"

                                , DbHelper2.mp("@SettingId", SqlDbType.Int, _SettingId)

                                , DbHelper2.mp("@Key", SqlDbType.NVarChar, 100, _Key)

                                , DbHelper2.mp("@Value", SqlDbType.NText, _Value)

                                );
            }
            else if (_state == DataRowState.Added)
            {
                SqlParameter outPutKey = new SqlParameter("@SettingId", SqlDbType.Int);
                outPutKey.Direction = ParameterDirection.Output;

                DbHelper2.RunSp("mc_PortalConfigInsert", outPutKey

                                , DbHelper2.mp("@Key", SqlDbType.NVarChar, 100, _Key)

                                , DbHelper2.mp("@Value", SqlDbType.NText, _Value)

                                );

                _SettingId = (int)outPutKey.Value;
            }
        }