/// <summary>
/// 获取所有科常用部门
/// </summary>
/// <returns>null失败</returns>
public ArrayList QueryDept()
{
string strsql = "";
if (this.Sql.GetSql("Manager.DeptItem.QueryDepts", ref strsql) == -1)
{
return(null);
}
if (this.ExecQuery(strsql) == -1)
{
return(null);
}
ArrayList alDepts = new ArrayList();
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Base.DeptItem di = new Neusoft.HISFC.Models.Base.DeptItem();
di.Dept.ID = this.Reader[0].ToString();
di.Dept.Name = this.Reader[1].ToString();
di.UserCode = this.Reader[2].ToString();
di.SpellCode = this.Reader[3].ToString();
di.WBCode = this.Reader[4].ToString();
alDepts.Add(di);
}
this.Reader.Close();
return(alDepts);
}
private void btnSave_Click(object sender, EventArgs e)
{
Neusoft.HISFC.Models.Base.DeptItem deptItem = this.SaveButtonHandler();
if (deptItem == null)
{
return;
}
if (deptItem.Dept.ID == "" || deptItem.Dept.Name == null)
{
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//t.BeginTransaction();
this.diBusiness.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
if (this.diBusiness.InsertItem(deptItem) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();;
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("保存数据失败"));
return;
}
Neusoft.FrameWork.Management.PublicTrans.Commit();;
if (this.InsertSuccessed != null)
{
InsertSuccessed();
}
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("保存数据成功"));
this.FindForm().Close();
}
else
{
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//t.BeginTransaction();
this.diBusiness.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
if (this.diBusiness.UpdateItem(deptItem) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();;
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("保存数据失败"));
return;
}
Neusoft.FrameWork.Management.PublicTrans.Commit();;
if (this.InsertSuccessed != null)
{
InsertSuccessed();
}
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("保存数据成功"));
this.FindForm().Close();
}
//更新操作
}
private Neusoft.HISFC.Models.Base.DeptItem SaveButtonHandler()
{
if (this.valid() == -1)
{
return(null);
}
Neusoft.HISFC.Models.Base.DeptItem deptItem = new Neusoft.HISFC.Models.Base.DeptItem();
deptItem.Dept.ID = this.Tag.ToString();//根据这上决定是更新还是保存,科室编号
deptItem.ItemProperty.ID = this.tbItemCode.Text;
deptItem.ItemProperty.Name = this.tbItemName.Text;
deptItem.UnitFlag = this.UnitFlag;
//deptItem.UnitFlag = this.ckbUnitFlag.Checked ? "1" : "2";
deptItem.BookLocate = this.tbBookLocate.Text;
deptItem.BookTime = this.dtBookTime.Value.ToString();
deptItem.ExecuteLocate = this.tbExecLocate.Text;
deptItem.ReportDate = this.dtReportTime.Value.ToString();
deptItem.HurtFlag = this.ckbHurtFlag.Checked ? "0" : "1";
deptItem.SelfBookFlag = this.ckbSelfBookFlag.Checked ? "0" : "1";
deptItem.ReasonableFlag = this.ckbReasonableFlag.Checked ? "0" : "1";
deptItem.IsStat = this.ckbStat.Checked ? "0" : "1";
deptItem.IsAutoBook = this.ckbAutoBook.Checked ? "0" : "1";
//if (Neusoft.FrameWork.Public.String.ValidMaxLengh(this.tbSpeciality.Text, 20))
//{
deptItem.Speciality = this.tbSpeciality.Text;
//}
//else
//{
// MessageBox.Show("所属专业字段过长", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// this.tbSpeciality.Focus();
// return null;
//}
deptItem.ClinicMeaning = this.tbMeaning.Text;
deptItem.SampleKind = this.tbSampleKind.Text;
deptItem.SampleWay = this.tbSampleWay.Text;
deptItem.SampleUnit = this.tbSampleUnit.Text;
deptItem.SampleQty = Convert.ToDecimal(this.ntSampleQty.NumericValue);
deptItem.SampleContainer = this.tbContainer.Text;
deptItem.Scope = this.tbScope.Text;
deptItem.ItemTime = this.tbItemTime.Text;
deptItem.Memo = this.tbMemo.Text;
//
deptItem.CustomName = this.tbCustomName.Text;
return(deptItem);
}
public int UpdateItem(Neusoft.HISFC.Models.Base.DeptItem deptItem)
{
string dcode = ((Neusoft.HISFC.Models.Base.Employee) this.Operator).Dept.ID;
string strsql = "";
if (this.Sql.GetSql("Manager.DeptItem.UpdateItem.1", ref strsql) == -1)
{
return(-1);
}
try
{
strsql = String.Format(strsql,
deptItem.UnitFlag /*.Trim().Equals("明细") ? "1" : "2"*/,
deptItem.BookLocate,
deptItem.BookTime,
deptItem.ExecuteLocate,
deptItem.ReportDate,
deptItem.HurtFlag /*.Trim().Equals("有") ? "0" : "1"*/,
deptItem.SelfBookFlag /*.Trim().Equals("是") ? "0" : "1"*/,
deptItem.ReasonableFlag /*.Trim().Equals("需要") ? "0" : "1"*/,
deptItem.Speciality,
deptItem.ClinicMeaning,
deptItem.SampleKind,
deptItem.SampleWay,
deptItem.SampleUnit,
deptItem.SampleQty,/*decimal类型*/
deptItem.SampleContainer,
deptItem.Scope,
deptItem.IsStat /*.Trim().Equals("需要") ? "0" : "1"*/,
deptItem.IsAutoBook /*.Trim().Equals("需要") ? "0" : "1"*/,
deptItem.ItemTime,
deptItem.Memo,
this.Operator.ID,
dcode /*dcode 实际上应该用这个,现在测试3001*/,
deptItem.ItemProperty.ID,
deptItem.ItemProperty.Name,
deptItem.CustomName
);
}
catch (Exception ex)
{
this.Err = ex.Message;
this.ErrCode = ex.Source;
return(-1);
}
if (this.ExecNoQuery(strsql) <= 0)
{
return(-1);
}
return(1);
}
/// <summary>
/// 根据FarPoint中的一行,创建一个对象
/// </summary>
/// <param name="row">所在行</param>
/// <returns>对象</returns>
private Neusoft.HISFC.Models.Base.DeptItem CreateDeptItem(int row)
{
Neusoft.HISFC.Models.Base.DeptItem deptitem = new Neusoft.HISFC.Models.Base.DeptItem();
deptitem.Dept.ID = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("科室编号"));
deptitem.ItemProperty.ID = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("项目编号"));
deptitem.ItemProperty.Name = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("项目名称"));
//系统类别:deptitem.ItemProperty.SysClass暂时先不写
switch (this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("单位标识")).Trim())
{
case "药品":
deptitem.UnitFlag = "0";
break;
case "非药品":
deptitem.UnitFlag = "1";
break;
case "组合项目":
deptitem.UnitFlag = "2";
break;
default:
break;
}
//deptitem.UnitFlag = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("单位标识"));
deptitem.BookLocate = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("预约地"));
deptitem.BookTime = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("预约固定时间"));
deptitem.ExecuteLocate = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("执行地点"));
deptitem.ReportDate = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("取报告时间"));
deptitem.HurtFlag = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("是否有创"));
deptitem.SelfBookFlag = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("是否科内预约"));
deptitem.ReasonableFlag = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("知情同意书"));
deptitem.Speciality = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("所属专业"));
deptitem.ClinicMeaning = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("临床意义"));
deptitem.SampleKind = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("标本"));
deptitem.SampleWay = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("采样方法"));
deptitem.SampleUnit = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("标本单位"));
deptitem.SampleQty = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("标本量")));
deptitem.SampleContainer = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("容器"));
deptitem.Scope = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("正常值范围"));
deptitem.IsStat = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("是否需要统计"));
deptitem.IsAutoBook = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("是否自动预约"));
deptitem.ItemTime = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("项目执行所需时间"));
deptitem.Memo = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("注意事项"));
//
deptitem.CustomName = this.fpDeptItem_Sheet1.GetText(row, this.GetCloumn("科内名称"));
return(deptitem);
}
/// <summary>
/// 保存项目信息
/// </summary>
/// <param name="DeptItem">项目信息</param>
/// <returns>1,成功; -1,失败</returns>
public int InsertItem(Neusoft.HISFC.Models.Base.DeptItem deptitem)
{
string dcode = ((Neusoft.HISFC.Models.Base.Employee) this.Operator).Dept.ID;
/* insert into fin_com_deptitem (parent_code,current_code,dept_code, item_code, item_name) values (fun_get_parentcode(),fun_get_currentcode(),'{0}','{1}','{2}');
*/
string strsql = "";
if (this.Sql.GetSql("Manager.DeptItem.InsertItem", ref strsql) == -1)
{
return(-1);
}
try
{
strsql = String.Format(strsql,
dcode /*dcode 实际上应该用这个,现在测试3001*/,
deptitem.ItemProperty.ID,
deptitem.ItemProperty.Name,
deptitem.UnitFlag /*.Trim().Equals("明细") ? "1" : "2"*/,
deptitem.BookLocate,
deptitem.BookTime,
deptitem.ExecuteLocate,
deptitem.ReportDate,
deptitem.HurtFlag /*.Trim().Equals("有") ? "0" : "1"*/,
deptitem.SelfBookFlag /*.Trim().Equals("是") ? "0" : "1"*/,
deptitem.ReasonableFlag /*.Trim().Equals("需要") ? "0" : "1"*/,
deptitem.Speciality,
deptitem.ClinicMeaning,
deptitem.SampleKind,
deptitem.SampleWay,
deptitem.SampleUnit,
deptitem.SampleQty,/*decimal类型*/
deptitem.SampleContainer,
deptitem.Scope,
deptitem.IsStat /*.Trim().Equals("需要") ? "0" : "1"*/,
deptitem.IsAutoBook /*.Trim().Equals("需要") ? "0" : "1"*/,
deptitem.ItemTime,
deptitem.Memo,
this.Operator.ID,
deptitem.CustomName
);
}
catch
{
return(-1);
}
if (this.ExecNoQuery(strsql) <= 0)
{
return(-1);
}
return(1);
}
/// <summary>
/// 供外部调用,根据参数初始化窗体
/// </summary>
/// <param name="deptItem">科常用项目对象</param>
public void ShowWindow(Neusoft.HISFC.Models.Base.DeptItem deptItem)
{
this.tbItemCode.Text = deptItem.ItemProperty.ID;
this.tbItemName.Text = deptItem.ItemProperty.Name;
this.UnitFlag = deptItem.UnitFlag;
//this.ckbUnitFlag.Checked = deptItem.UnitFlag.Trim().Equals("明细") ? true : false;
this.tbBookLocate.Text = deptItem.BookLocate;
if (deptItem.BookTime == "" || deptItem.BookTime == null)
{
this.dtBookTime.Value = DateTime.Now;
}
else
{
this.dtBookTime.Value = Neusoft.FrameWork.Function.NConvert.ToDateTime(deptItem.BookTime);
}
this.tbExecLocate.Text = deptItem.ExecuteLocate;
if (deptItem.ReportDate == "" || deptItem.ReportDate == null)
{
this.dtReportTime.Value = DateTime.Now;
}
else
{
this.dtReportTime.Value = Neusoft.FrameWork.Function.NConvert.ToDateTime(deptItem.ReportDate);
}
this.ckbHurtFlag.Checked = deptItem.HurtFlag.Trim().Equals("有") ? true : false;
this.ckbSelfBookFlag.Checked = deptItem.SelfBookFlag.Trim().Equals("是") ? true : false;
this.ckbReasonableFlag.Checked = deptItem.ReasonableFlag.Trim().Equals("需要") ? true : false;
this.ckbStat.Checked = deptItem.IsStat.Trim().Equals("需要") ? true : false;
this.ckbAutoBook.Checked = deptItem.IsAutoBook.Trim().Equals("需要") ? true : false;
this.tbSpeciality.Text = deptItem.Speciality;
this.tbMeaning.Text = deptItem.ClinicMeaning;
this.tbSampleKind.Text = deptItem.SampleKind;
this.tbSampleWay.Text = deptItem.SampleWay;
this.tbSampleUnit.Text = deptItem.SampleUnit;
this.ntSampleQty.Text = deptItem.SampleQty.ToString();
this.tbContainer.Text = deptItem.SampleContainer;
this.tbScope.Text = deptItem.Scope;
this.tbItemTime.Text = deptItem.ItemTime;
this.tbMemo.Text = deptItem.Memo;
//
this.tbCustomName.Text = deptItem.CustomName;
}
private void fpDeptItem_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
//
// 如果双击的是列头，则返回
//
if (e.ColumnHeader)
{
return;
}
Neusoft.HISFC.Models.Base.DeptItem item = this.CreateDeptItem(e.Row);
ucDeptItem deptItemWindow = new ucDeptItem();
deptItemWindow.InsertSuccessed += new InsertSuccessedHandler(deptItemWindow_InsertSuccessed);
//
// 根据这个值，决定是更新还是插入
//
deptItemWindow.Tag = this.fpDeptItem_Sheet1.GetText(e.Row, this.GetCloumn("科室编号"));
deptItemWindow.ShowWindow(item);
Neusoft.FrameWork.WinForms.Classes.Function.ShowControl(deptItemWindow);
}
/// <summary>
/// 获取科室常用项目信息
/// </summary>
/// <param name="deptID">部门编号</param>
/// <returns>成功返回一个集合, 否则返回null</returns>
public ArrayList QueryItemByDeptID(string deptID)
{
ArrayList alItem = new ArrayList();
string strsql = "";
if (this.Sql.GetSql("Manager.DeptItem.SelectItemByDeptID", ref strsql) == -1)
{
return(null);
}
try
{
strsql = String.Format(strsql, deptID);
}
catch (Exception ex)
{
this.Err = ex.Message;
this.ErrCode = ex.Source;
return(null);
}
if (this.ExecQuery(strsql) == -1)
{
return(null);
}
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Base.DeptItem item = new Neusoft.HISFC.Models.Base.DeptItem();
item.ID = this.Reader[0].ToString();
item.Name = this.Reader[1].ToString();
item.UserCode = this.Reader[2].ToString();
item.SpellCode = this.Reader[3].ToString();
item.WBCode = this.Reader[4].ToString();
item.CustomName = this.Reader[5].ToString();
alItem.Add(item);
}
this.Reader.Close();
return(alItem);
}
protected override int OnSave(object sender, object neuObject)
{
if (this.fpDeptItem_Sheet1.RowCount <= 0)
{
MessageBox.Show("没有要保存的数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(-1);
}
for (int i = 0, j = this.fpDeptItem_Sheet1.RowCount; i < j; i++)
{
Neusoft.HISFC.Models.Base.DeptItem deptItem = new Neusoft.HISFC.Models.Base.DeptItem();
//deptItem.Dept.ID = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).Dept.ID;
deptItem.Dept.ID = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("科室编号"));
deptItem.ItemProperty.ID = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("项目编号"));
deptItem.ItemProperty.Name = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("项目名称"));
switch (this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("单位标识")).Trim())
{
case "药品":
deptItem.UnitFlag = "0";
break;
case "0":
deptItem.UnitFlag = "0";
break;
case "非药品":
deptItem.UnitFlag = "1";
break;
case "1":
deptItem.UnitFlag = "1";
break;
case "组合项目":
deptItem.UnitFlag = "2";
break;
case "2":
deptItem.UnitFlag = "2";
break;
default:
break;
}
deptItem.BookLocate = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("预约地"));
deptItem.BookTime = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("预约固定时间"));
deptItem.ExecuteLocate = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("执行地点"));
deptItem.ReportDate = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("取报告时间"));
deptItem.HurtFlag = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("是否有创")).Trim().Equals("有") ? "0" : "1";
deptItem.SelfBookFlag = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("是否科内预约")).Trim().Equals("是") ? "0" : "1";
deptItem.ReasonableFlag = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("知情同意书")).Trim().Equals("需要") ? "0" : "1";
deptItem.IsStat = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("是否需要统计")).Trim().Equals("需要") ? "0" : "1";
deptItem.IsAutoBook = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("是否自动预约")).Trim().Equals("需要") ? "0" : "1";
deptItem.Speciality = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("所属专业"));
deptItem.ClinicMeaning = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("临床意义"));
deptItem.SampleKind = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("标本"));
deptItem.SampleWay = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("采样方法"));
deptItem.SampleUnit = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("标本单位"));
deptItem.SampleQty = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("标本量")));
deptItem.SampleContainer = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("临床意义"));
deptItem.Scope = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("正常值范围"));
deptItem.ItemTime = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("项目执行所需时间"));
deptItem.Memo = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("注意事项"));
//
deptItem.CustomName = this.fpDeptItem_Sheet1.GetText(i, this.GetCloumn("科内名称"));
if (deptItem.Dept.ID == "" || deptItem.Dept.Name == null)
{
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//t.BeginTransaction();
this.diBusiness.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
if (this.diBusiness.InsertItem(deptItem) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(this.diBusiness.Err, Neusoft.FrameWork.Management.Language.Msg("保存数据失败!"));
return(-1);
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
//MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("保存数据成功"));
}
else
{
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//t.BeginTransaction();
this.diBusiness.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
if (this.diBusiness.UpdateItem(deptItem) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(this.diBusiness.Err, Neusoft.FrameWork.Management.Language.Msg("保存数据失败!"));
return(-1);
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
}
//Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//t.BeginTransaction();
//this.diBusiness.SetTrans(t.Trans);
//if (this.diBusiness.InsertItem(deptItem) == -1)
//{
// if (this.diBusiness.UpdateItem(deptItem) == -1)
// {
// Neusoft.FrameWork.Management.PublicTrans.RollBack();;
// MessageBox.Show(this.diBusiness.Err, Neusoft.FrameWork.Management.Language.Msg("保存数据失败!"));
// return -1;
// }
//}
//Neusoft.FrameWork.Management.PublicTrans.Commit();;
}
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("保存数据成功!"));
this.Init();
//this.FillPharmacy();
//this.FillUndrugItem();
//this.FillComboItem();
return(1);
}
/// <summary>
/// 获取科室常用项目信息
/// </summary>
/// <param name="lstItems">项目信息</param>
/// <param name="deptID">科室编号</param>
/// <returns>1,成功; -1,失败</returns>
public int SelectItem(ref List <Neusoft.HISFC.Models.Base.DeptItem> lstItems, string deptID)
{
string strsql = "";
//
// 如果是取得当前科室
//
if (this.Sql.GetSql("Manager.DeptItem.SelectItem.3", ref strsql) == -1)
{
return(-1);
}
try
{
//这个地方用当前科室编号来代替
strsql = String.Format(strsql, deptID);
}
catch
{
return(-1);
}
if (this.ExecQuery(strsql) == -1)
{
return(-1);
}
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Base.DeptItem di = new Neusoft.HISFC.Models.Base.DeptItem();
di.Dept.ID = (this.Reader[0] == null ? "" : this.Reader[0].ToString());
di.ItemProperty.ID = (this.Reader[1] == null ? "" : this.Reader[1].ToString());
di.ItemProperty.Name = (this.Reader[2] == null ? "" : this.Reader[2].ToString());
di.UnitFlag = (this.Reader[3] == null ? "" : this.Reader[3].ToString());
di.BookLocate = (this.Reader[4] == null ? "" : this.Reader[4].ToString());
di.BookTime = (this.Reader[5] == null ? "" : this.Reader[5].ToString());
di.ExecuteLocate = (this.Reader[6] == null ? "" : this.Reader[6].ToString());
di.ReportDate = (this.Reader[7] == null ? "" : this.Reader[7].ToString());
di.HurtFlag = (this.Reader[8] == null ? "" : this.Reader[8].ToString());
di.SelfBookFlag = (this.Reader[9] == null ? "" : this.Reader[9].ToString());
di.ReasonableFlag = (this.Reader[10] == null ? "" : this.Reader[10].ToString());
di.Speciality = (this.Reader[11] == null ? "" : this.Reader[11].ToString());
di.ClinicMeaning = (this.Reader[12] == null ? "" : this.Reader[12].ToString());
di.SampleKind = (this.Reader[13] == null ? "" : this.Reader[13].ToString());
di.SampleWay = (this.Reader[14] == null ? "" : this.Reader[14].ToString());
di.SampleUnit = (this.Reader[15] == null ? "" : this.Reader[15].ToString());
di.SampleQty = (this.Reader[16] == null ? 0 : Convert.ToDecimal(this.Reader[16]));//decimal类型
di.SampleContainer = (this.Reader[17] == null ? "" : this.Reader[17].ToString());
di.Scope = (this.Reader[18] == null ? "" : this.Reader[18].ToString());
di.IsStat = (this.Reader[19] == null ? "" : this.Reader[19].ToString());
di.IsAutoBook = (this.Reader[20] == null ? "" : this.Reader[20].ToString());
di.ItemTime = (this.Reader[21] == null ? "" : this.Reader[21].ToString());
di.Memo = (this.Reader[22] == null ? "" : this.Reader[22].ToString());
di.CustomName = (this.Reader[23] == null ? "" : this.Reader[23].ToString());
lstItems.Add(di);
}
this.Reader.Close();
return(1);
}
/// <summary>
/// 获取科室常用项目信息(按类别)
/// </summary>
/// <param name="lstItems">项目信息</param>
/// <returns>1,成功; -1,失败</returns>
public int SelectItemByUint(ref List <Neusoft.HISFC.Models.Base.DeptItem> lstItems, string UnitFlag)
{
string strsql = "";
//
// 如果是取得当前科室
//
if (this.Sql.GetSql("Manager.DeptItem.SelectItem.4", ref strsql) == -1)
{
return(-1);
}
try
{
//这个地方用当前科室编号来代替
strsql = String.Format(strsql, ((Neusoft.HISFC.Models.Base.Employee) this.Operator).Dept.ID, UnitFlag);
}
catch
{
return(-1);
}
if (this.ExecQuery(strsql) == -1)
{
return(-1);
}
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Base.DeptItem di = new Neusoft.HISFC.Models.Base.DeptItem();
//di.DeptCode.Name = this.Reader.IsDBNull(1) ? "" : this.Reader.GetString(1);
//di.Dept.ID = this.Reader.IsDBNull(0) ? "" : this.Reader.GetString(0);
//di.ItemProperty.ID = this.Reader.IsDBNull(1) ? "" : this.Reader.GetString(1);
//di.ItemProperty.Name = this.Reader.IsDBNull(2) ? "" : this.Reader.GetString(2);
//di.UnitFlag = this.Reader.IsDBNull(3) ? "" : this.Reader.GetString(3);
//di.BookLocate = this.Reader.IsDBNull(4) ? "" : this.Reader.GetString(4);
//di.BookTime = this.Reader.IsDBNull(5) ? "" : this.Reader.GetString(5);
//di.ExecuteLocate = this.Reader.IsDBNull(6) ? "" : this.Reader.GetString(6);
//di.ReportDate = this.Reader.IsDBNull(7) ? "" : this.Reader.GetString(7);
//di.HurtFlag = this.Reader.IsDBNull(8) ? "" : this.Reader.GetString(8);
//di.SelfBookFlag = this.Reader.IsDBNull(9) ? "" : this.Reader.GetString(9);
//di.ReasonableFlag = this.Reader.IsDBNull(10) ? "" : this.Reader.GetString(10);
//di.Speciality = this.Reader.IsDBNull(11) ? "" : this.Reader.GetString(11);
//di.ClinicMeaning = this.Reader.IsDBNull(12) ? "" : this.Reader.GetString(12);
//di.SampleKind = this.Reader.IsDBNull(13) ? "" : this.Reader.GetString(13);
//di.SampleWay = this.Reader.IsDBNull(14) ? "" : this.Reader.GetString(14);
//di.SampleUnit = this.Reader.IsDBNull(15) ? "" : this.Reader.GetString(15);
//di.SampleQty = this.Reader.IsDBNull(16) ? 0 : this.Reader.GetDecimal(16);//decimal类型
//di.SampleContainer = this.Reader.IsDBNull(17) ? "" : this.Reader.GetString(17);
//di.Scope = this.Reader.IsDBNull(18) ? "" : this.Reader.GetString(18);
//di.IsStat = this.Reader.IsDBNull(19) ? "" : this.Reader.GetString(19);
//di.IsAutoBook = this.Reader.IsDBNull(20) ? "" : this.Reader.GetString(20);
//di.ItemTime = this.Reader.IsDBNull(21) ? "" : this.Reader.GetString(21);
//di.Memo = this.Reader.IsDBNull(22) ? "" : this.Reader.GetString(22);
di.Dept.ID = (this.Reader[0] == null ? "" : this.Reader[0].ToString());
di.ItemProperty.ID = (this.Reader[1] == null ? "" : this.Reader[1].ToString());
di.ItemProperty.Name = (this.Reader[2] == null ? "" : this.Reader[2].ToString());
di.UnitFlag = (this.Reader[3] == null ? "" : this.Reader[3].ToString());
di.BookLocate = (this.Reader[4] == null ? "" : this.Reader[4].ToString());
di.BookTime = (this.Reader[5] == null ? "" : this.Reader[5].ToString());
di.ExecuteLocate = (this.Reader[6] == null ? "" : this.Reader[6].ToString());
di.ReportDate = (this.Reader[7] == null ? "" : this.Reader[7].ToString());
di.HurtFlag = (this.Reader[8] == null ? "" : this.Reader[8].ToString());
di.SelfBookFlag = (this.Reader[9] == null ? "" : this.Reader[9].ToString());
di.ReasonableFlag = (this.Reader[10] == null ? "" : this.Reader[10].ToString());
di.Speciality = (this.Reader[11] == null ? "" : this.Reader[11].ToString());
di.ClinicMeaning = (this.Reader[12] == null ? "" : this.Reader[12].ToString());
di.SampleKind = (this.Reader[13] == null ? "" : this.Reader[13].ToString());
di.SampleWay = (this.Reader[14] == null ? "" : this.Reader[14].ToString());
di.SampleUnit = (this.Reader[15] == null ? "" : this.Reader[15].ToString());
di.SampleQty = (this.Reader[16] == null ? 0 : Convert.ToDecimal(this.Reader[16]));//decimal类型
di.SampleContainer = (this.Reader[17] == null ? "" : this.Reader[17].ToString());
di.Scope = (this.Reader[18] == null ? "" : this.Reader[18].ToString());
di.IsStat = (this.Reader[19] == null ? "" : this.Reader[19].ToString());
di.IsAutoBook = (this.Reader[20] == null ? "" : this.Reader[20].ToString());
di.ItemTime = (this.Reader[21] == null ? "" : this.Reader[21].ToString());
di.Memo = (this.Reader[22] == null ? "" : this.Reader[22].ToString());
di.CustomName = (this.Reader[23] == null ? "" : this.Reader[23].ToString());
lstItems.Add(di);
}
this.Reader.Close();
return(1);
}
