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;
}
