public int Create(QTC.Adv.DataModule.Single.Workstation workstation) { IDbDataParameter[] parameters = { MakeParameter("@CODE", DbType.String, 10), MakeParameter("@NAME", DbType.String, 200), MakeParameter("@PASSWORD", DbType.String, 400), MakeParameter("@IP", DbType.String, 30), MakeParameter("@UNIT_MANAGER", DbType.String, 200), MakeParameter("@ADDRESS", DbType.String, 400), MakeParameter("@TEL", DbType.String, 20), MakeParameter("@ADMIN_NAME", DbType.String, 200), MakeParameter("@ADMIN_TEL", DbType.String, 20), MakeParameter("@AREA_ID", DbType.Int32, 4), }; parameters[0].Value = workstation.WorkstationCode; parameters[1].Value = workstation.Name; parameters[2].Value = workstation.Password; parameters[3].Value = workstation.IPAddress; parameters[4].Value = workstation.UnitManager; parameters[5].Value = workstation.Address; parameters[6].Value = workstation.PhoneNumber; parameters[7].Value = workstation.AdminName; parameters[8].Value = workstation.AdminPhone; parameters[9].Value = workstation.AreaId; int rowsAffected=0; return RunProcedure("sp_ADV_WORKSTATION_Insert",parameters,out rowsAffected ); }
/// <summary> /// author Khoaht /// modified:29/04/08 /// </summary> public int Add(QTC.Adv.DataModule.Single.ScheduleWorkstation scheduleWorkstation) { IDbDataParameter[] parameters = { MakeParameter("@WORKSTATION_ID", DbType.Int32, 4), MakeParameter("@SCHEDULE_ID", DbType.Int32, 4), MakeParameter("@STATUS", DbType.Byte, 2), MakeParameter("@FREQ", DbType.Byte, 2), MakeParameter("@LENGTH", DbType.String, 8), // Advance Schedule MakeParameter("@START_TIME",DbType.String,5), MakeParameter("@END_TIME",DbType.String,5), MakeParameter("@DAILY_VALUES",DbType.String,2), MakeParameter("@WEEKLY_VALUES",DbType.String,9), MakeParameter("@MONTHLY_VALUES",DbType.String,50), /// MakeParameter("@PRIORITY",DbType.Byte,1), }; parameters[0].Value = scheduleWorkstation.WorkstationId; parameters[1].Value = scheduleWorkstation.ScheduleId; parameters[2].Value = scheduleWorkstation.Status; parameters[3].Value = scheduleWorkstation.Sequence; parameters[4].Value = scheduleWorkstation.Length; parameters[5].Value = scheduleWorkstation.PatternItem==null?"":scheduleWorkstation.PatternItem.StartTime; parameters[6].Value = scheduleWorkstation.PatternItem==null?"":scheduleWorkstation.PatternItem.EndTime; parameters[7].Value = scheduleWorkstation.PatternItem.Daily== null ? "": scheduleWorkstation.PatternItem.Daily; parameters[8].Value = scheduleWorkstation.PatternItem.Weekly== null ? "" : scheduleWorkstation.PatternItem.Weekly; parameters[9].Value = scheduleWorkstation.PatternItem.Monthly== null ? "": scheduleWorkstation.PatternItem.Monthly; parameters[10].Value = scheduleWorkstation.Priority; int rowsAffected = 0; return RunProcedure("sp_ADV_SCHEDULE_WORKSTATION_Insert_1", parameters, out rowsAffected); }
/// <summary> /// @author : TrungMT /// @CreateDate:05/05/2008 /// @Description: show form and play many clip /// </summary> public FrmClipView(DataRowCollection pClipRows, TimeSpan ptServerLocalDelay,QTC.Adv.DataModule.Single.Workstation workstation) { InitializeComponent(); this.workstation = workstation; mClipRows = pClipRows; Stopped = true; InitTimmerList(); mTimer.Enabled = true; mtServerLocalDelay = ptServerLocalDelay; mFullScreen = new FullScreen(this); }
public bool Delete(QTC.Adv.DataModule.Single.Workstation workstation) { IDbDataParameter[] parameters = { MakeParameter("@WORKSTATION_ID", DbType.Int32, 4) }; parameters[0].Value = workstation.WorkstationId; int rowsAffected = 0; RunProcedure("sp_ADV_WORKSTATION_Delete", parameters, out rowsAffected); return (rowsAffected == 1); }
/// <summary> /// author Khoaht /// </summary> public int Add(QTC.Adv.DataModule.Single.Schedule schedule) { IDbDataParameter[] parameters = { MakeParameter("@CLIP_ID", DbType.Int32, 4), MakeParameter("@PRICE", DbType.Decimal, 10), MakeParameter("@FREQ", DbType.Byte, 2), MakeParameter("@STATUS", DbType.Byte, 2), MakeParameter("@FROM_DATE", DbType.DateTime, 8), MakeParameter("@TO_DATE", DbType.DateTime, 8) }; parameters[0].Value = schedule.ClipId; parameters[1].Value = schedule.Price; parameters[2].Value = schedule.Freq; parameters[3].Value = schedule.Status; parameters[4].Value = schedule.FromDate; parameters[5].Value = schedule.ToDate; int rowsAffected = 0; return RunProcedure("sp_ADV_SCHEDULE_Insert", parameters, out rowsAffected); }
/// <summary> /// author Khoaht /// </summary> public bool Delete(QTC.Adv.DataModule.Single.ScheduleWorkstation scheduleWorkstation) { IDbDataParameter[] parameters = { MakeParameter("@WORKSTATION_ID", DbType.Int32, 4), MakeParameter("@SCHEDULE_ID", DbType.Int32, 4), }; parameters[0].Value = scheduleWorkstation.WorkstationId; parameters[1].Value = scheduleWorkstation.ScheduleId; int rowsAffected = 0; RunProcedure("sp_ADV_SCHEDULE_WORKSTATION_Delete", parameters, out rowsAffected); return (rowsAffected > 0); }
public bool DeleteSchedule(QTC.Adv.DataModule.Single.Schedule schedule) { IDbDataParameter[] parameters = { MakeParameter("@SCHEDULE_ID", DbType.Int32, 4), }; parameters[0].Value = schedule.ScheduleId; int rowsAffected = 0; RunProcedure("sp_ADV_SCHEDULE_WORKSTATION_DeleteAll", parameters, out rowsAffected); return rowsAffected>0; }
/// <summary> /// @author : khoaht /// @createDate : 22/05/2008 /// </summary> /// <param name="user"></param> internal void SetCurrentUser(QTC.Admin.Data.Single.User user) { this.user = user; toolUser.Text = user.Fullname; }