/// <summary>
/// 初始化
/// </summary>
/// <returns></returns>
protected int Init()
{
#region 获取科室
Neusoft.HISFC.BizLogic.Manager.Department deptManager = new Neusoft.HISFC.BizLogic.Manager.Department();
ArrayList al = deptManager.GetDeptmentAll();
ArrayList alDept = new ArrayList();
foreach (Neusoft.HISFC.Models.Base.Department info in al)
{
if (info.DeptType.ID.ToString() == "P" || info.DeptType.ID.ToString() == "PI")
{
alDept.Add(info);
}
}
this.cmbStoreDept.AddItems(alDept);
#endregion
this.job = this.jobManager.GetJob(this.monthStoreType);
if (this.job == null)
{
MessageBox.Show(Language.Msg("根据药品月结编码获取药品月结设置失败"));
return(-1);
}
return(1);
}
/// <summary>
/// Job设置
/// </summary>
/// <param name="job"></param>
public void SetJob(Neusoft.HISFC.Models.Base.Job job, DateTime maxDate)
{
this.lbInfo.Text = string.Format("上次月结截至时间为{0} ", job.LastTime);
this.dtpEnd.Value = maxDate;
this.dtpEnd.MinDate = job.LastTime.AddSeconds(1);
this.dtpEnd.MaxDate = maxDate;
}
/// <summary>
/// 保存人员属性变动数据－－先执行更新操作，如果没有找到可以更新的数据，则插入一条新记录
/// </summary>
/// <param name="Job">Job实体</param>
/// <returns>0没有更新 1成功 -1失败</returns>
public int SetJob(Neusoft.HISFC.Models.Base.Job Job)
{
int parm;
//执行更新操作
parm = UpdateJob(Job);
//如果没有找到可以更新的数据，则插入一条新记录
if (parm == 0)
{
parm = InsertJob(Job);
}
return(parm);
}
/// <summary>
/// 初始化
/// </summary>
/// <returns></returns>
protected int Init()
{
ArrayList alDept = this.baseManager.GetStorageInfo("A", "A", "1", "A");
this.cmbStoreDept.AddItems(alDept);
this.job = this.jobManager.GetJob(this.monthStoreType);
if (this.job == null)
{
MessageBox.Show(Language.Msg("根据药品月结编码获取药品月结设置失败"));
return(-1);
}
return(1);
}
/// <summary>
/// 获得update或者insertJob表的传入参数数组
/// </summary>
/// <param name="Job">Job实体</param>
/// <returns>字符串数组</returns>
private string[] myGetParmJob(Neusoft.HISFC.Models.Base.Job Job)
{
string[] strParm =
{
Job.ID, //0 Job代码
Job.Name, //1 Job名称
Job.State.ID.ToString(), //2 状态N_不统计, D_按日执行, M_按月执行，,Y_按年执行 ,S_正在统计
Job.LastTime.ToString(), //3 上次执行时间
Job.NextTime.ToString(), //4 下次执行时间
Job.Type, //5 类型: 0 前台应用程序处理, 1 后台job处理
Job.IntervalDays.ToString(), //6 新资料名称
Job.Department.ID, //7 科室
this.Operator.ID, //8 申请操作员
Job.Memo //9 备注
};
return(strParm);
}
/// <summary>
/// 取Job列表，可能是一条或者多条
/// 私有方法，在其他方法中调用
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>Job信息对象数组</returns>
private ArrayList myGetJob(string SQLString)
{
ArrayList al = new ArrayList();
Neusoft.HISFC.Models.Base.Job Job; //Job实体
this.ProgressBarText = "正在检索Job...";
this.ProgressBarValue = 0;
//执行查询语句
if (this.ExecQuery(SQLString) == -1)
{
this.Err = "获得Job时，执行SQL语句出错！" + this.Err;
this.ErrCode = "-1";
return(null);
}
try {
while (this.Reader.Read())
{
//取查询结果中的记录
Job = new Neusoft.HISFC.Models.Base.Job();
Job.ID = this.Reader[0].ToString(); //0 Job代码
Job.Name = this.Reader[1].ToString(); //1 Job名称
Job.State.ID = this.Reader[2].ToString(); //2 状态N_不统计, D_按日执行, M_按月执行，,Y_按年执行 ,S_正在统计
Job.LastTime = NConvert.ToDateTime(this.Reader[3].ToString()); //3 上次执行时间
Job.NextTime = NConvert.ToDateTime(this.Reader[4].ToString()); //4 下次执行时间
Job.Type = this.Reader[5].ToString(); //5 类型: 0 前台应用程序处理, 1 后台job处理
Job.IntervalDays = NConvert.ToInt32(this.Reader[6].ToString()); //6 新资料名称
Job.Department.ID = this.Reader[7].ToString(); //7 当前状态（0申请，1确认，2作废）
Job.User01 = this.Reader[8].ToString(); //8 申请操作员
Job.User02 = this.Reader[9].ToString(); //9 申请时间
Job.Memo = this.Reader[10].ToString(); //10 备注
this.ProgressBarValue++;
al.Add(Job);
}
} //抛出错误
catch (Exception ex) {
this.Err = "获得Job信息时出错！" + ex.Message;
this.ErrCode = "-1";
return(null);
}
this.Reader.Close();
this.ProgressBarValue = -1;
return(al);
}
/// <summary>
/// 初始化
/// </summary>
private void Init()
{
this.privOper = this.jobManager.Operator;
this.job = this.jobManager.GetJob(this.monthStoreType);
if (this.job == null)
{
MessageBox.Show(Language.Msg("根据药品月结编码获取药品月结设置失败"));
return;
}
if (this.job.ID != "")
{
if (this.job.Type == "0")
{
this.cmbType.Text = "手动";
}
else
{
this.cmbType.Text = "自动";
}
this.dtpLast.Enabled = false; //上次月结截至时间不能修改
}
else
{
this.job.ID = this.monthStoreType;
this.job.Name = "全院月结";
this.job.State.ID = "M";
this.job.LastTime = this.sysTime.AddMonths(-1);
this.job.NextTime = this.sysTime;
this.job.Type = "0";
this.job.IntervalDays = 30;
this.job.Department.ID = "0";
this.cmbType.Text = "自动";
this.jobManager.SetJob(this.job);
}
this.dtpLast.Value = this.job.LastTime;
this.dtpNext.Value = this.job.NextTime;
}
/// <summary>
/// 更新Job表中一条记录
/// </summary>
/// <param name="Job">科室扩展属性类</param>
/// <returns>0没有更新 1成功 -1失败</returns>
public int UpdateJob(Neusoft.HISFC.Models.Base.Job Job)
{
string strSQL = "";
//取更新操作的SQL语句
if (this.Sql.GetSql("Manager.Job.UpdateJob", ref strSQL) == -1)
{
this.Err = "没有找到Manager.Job.UpdateJob字段!";
return(-1);
}
try {
string[] strParm = myGetParmJob(Job); //取参数列表
strSQL = string.Format(strSQL, strParm); //替换SQL语句中的参数。
}
catch (Exception ex) {
this.Err = "格式化SQL语句时出错Manager.Job.UpdateJob:" + ex.Message;
this.WriteErr();
return(-1);
}
return(this.ExecNoQuery(strSQL));
}
