/// <summary>
/// 插入一条明细
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertGroupTail(Neusoft.HISFC.Models.PhysicalExamination.GroupDetail info)
{
string strSql = "";
try
{
if (this.Sql.GetSql("Exami.ChkGroupDetail.InsertDataIntoComGroupTail", ref strSql) == -1)
{
return(-1);
}
return(this.ExecNoQuery(strSql, GetParam(info)));
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
}
/// <summary>
/// 根据科室编码获取所有项目信息
/// </summary>
/// <param name="deptCode"></param>
/// <returns></returns>
public ArrayList QueryGroupTailByDeptID(string deptCode)
{
ArrayList List = null;
string strSql = "";
if (this.Sql.GetSql("Exami.ChkGroupDetail.GetComGroupTailByDeptCode", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, deptCode);
this.ExecQuery(strSql);
List = new ArrayList();
Neusoft.HISFC.Models.PhysicalExamination.GroupDetail info = null;
while (this.Reader.Read())
{
info = new Neusoft.HISFC.Models.PhysicalExamination.GroupDetail();
info.ID = Reader[0].ToString();
info.sequenceNo = Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[1]);
info.itemCode = Reader[2].ToString();
info.drugFlag = Reader[3].ToString();
info.deptCode = Reader[4].ToString();
info.deptName = Reader[5].ToString();
info.qty = Neusoft.FrameWork.Function.NConvert.ToDecimal(Reader[6]);
info.unitFlag = Reader[7].ToString();
info.combNo = Reader[8].ToString();
info.reMark = Reader[9].ToString();
info.operCode = Reader[10].ToString();
info.OperDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[11]);
List.Add(info);
info = null;
}
this.Reader.Close();
}
catch (Exception ee)
{
this.Err = ee.Message;
return(null);
}
return(List);
}
/// <summary>
/// 获取参数
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
private string[] GetParam(Neusoft.HISFC.Models.PhysicalExamination.GroupDetail info)
{
string[] str = new string[]
{
info.ID, //组套编码
info.SortNum.ToString(), // 序号
info.itemCode, //编码
info.Spacs, //规格
info.qty.ToString(), //开立数量
info.reMark, //备注
info.ValidState, //停用标志0在用/1停用
info.unitFlag, //-项目标志0正常/1卫材/2组套
info.combNo, //组合号
info.ChkTime.ToString(), //检测次数
this.Operator.ID, //操作员
info.ExecDept.ID,
info.RealPrice.ToString() //实际价格
};
return(str);
}
/// <summary>
/// 删除一条明细
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int DeleteGroupTail(Neusoft.HISFC.Models.PhysicalExamination.GroupDetail info)
{
string strSql = "";
try
{
// delete fin_com_groupdetail where group_id ='{0}' and sequence_no ='{1}' and PARENT_CODE ='[父级编码]' and CURRENT_CODE ='[本级编码]
if (this.Sql.GetSql("Exami.ChkGroupDetail.DeleteDataIntoComGroupTail", ref strSql) == -1)
{
return(-1);
}
string OperCode = this.Operator.ID;
strSql = string.Format(strSql, info.ID, info.sequenceNo);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 根据ＳＱＬ获取组套明细
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
private ArrayList QueryGroupDetail(string strSql)
{
ArrayList List = null;
try
{
this.ExecQuery(strSql);
List = new ArrayList();
Neusoft.HISFC.Models.PhysicalExamination.GroupDetail info = null;
while (this.Reader.Read())
{
info = new Neusoft.HISFC.Models.PhysicalExamination.GroupDetail();
info.ID = Reader[0].ToString(); //组套编码
info.SortNum = Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[1]); // 序号
info.itemCode = Reader[2].ToString(); //编码
info.Spacs = Reader[3].ToString(); //规格
info.qty = Neusoft.FrameWork.Function.NConvert.ToDecimal(Reader[4]); //开立数量
info.reMark = Reader[5].ToString(); //备注
info.ValidState = Reader[6].ToString(); //停用标志0在用/1停用
info.unitFlag = Reader[7].ToString(); //-项目标志0正常/1卫材/2组套
info.combNo = Reader[8].ToString(); //组合号
info.ChkTime = Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[9]); //检测次数
info.operCode = Reader[10].ToString(); //操作员
info.OperDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[11]); //操作日期
info.ExecDept.ID = Reader[12].ToString(); //执行科室
info.ExecDept.Name = Reader[13].ToString(); //执行科室
info.RealPrice = Neusoft.FrameWork.Function.NConvert.ToDecimal(Reader[14].ToString());
List.Add(info);
}
this.Reader.Close();
}
catch (Exception ee)
{
this.Err = ee.Message;
return(null);
}
return(List);
}
/// <summary>
/// 删除一条明细
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int DeleteGroupTail(Neusoft.HISFC.Models.PhysicalExamination.GroupDetail info)
{
this.SetDB(mgrGroupDetail);
return(mgrGroupDetail.DeleteGroupTail(info));
}
