/// <summary>
/// 获取明细
/// </summary>
/// <param name="deptCode"></param>
/// <returns></returns>
public ArrayList GetComGroupTailByDeptCode(string deptCode)
{
ArrayList List = null;
string strSql = "";
if (this.Sql.GetSql("Manager.ComGroup.GetComGroupTailByDeptCode", ref strSql) == -1)
{
return(null);
}
try
{
// select group_id ,sequence_no,item_code ,drug_flag,a.exec_dpcd, b.dept_name ,qty,unit_flag,comb_no,remark,a.oper_code,a.oper_date from fin_com_groupdetail a ,com_department b where a.exec_dpcd = b.dept_code and dept_code = '{0}'
strSql = string.Format(strSql, deptCode);
this.ExecQuery(strSql);
List = new ArrayList();
Neusoft.HISFC.Models.Fee.ComGroupTail info = null;
while (this.Reader.Read())
{
info = new Neusoft.HISFC.Models.Fee.ComGroupTail();
info.ID = Reader[0].ToString();
if (Reader[1] != DBNull.Value)
{
info.sequenceNo = Convert.ToInt32(Reader[1]);
}
else
{
info.sequenceNo = 0;
}
info.itemCode = Reader[2].ToString();
info.drugFlag = Reader[3].ToString();
info.deptCode = Reader[4].ToString();
info.deptName = Reader[5].ToString();
if (Reader[6] != DBNull.Value)
{
info.qty = Convert.ToDecimal(Reader[6]);
}
else
{
info.qty = 0;
}
info.unitFlag = Reader[7].ToString();
info.combNo = Reader[8].ToString();
info.reMark = Reader[9].ToString();
info.operCode = Reader[10].ToString();
if (Reader[11] != DBNull.Value)
{
info.OperDate = Convert.ToDateTime(Reader[11]);
}
List.Add(info);
info = null;
}
this.Reader.Close();
}
catch (Exception ee)
{
this.Err = ee.Message;
return(null);
}
return(List);
}
/// <summary>
/// 添加明细到farpoint
/// </summary>
/// <param name="detail"></param>
/// <returns></returns>
private int AddDetailToFP(Neusoft.HISFC.Models.Fee.ComGroupTail detail)
{
neuSpread1_Sheet1.Rows.Add(neuSpread1_Sheet1.Rows.Count, 1);
int row = neuSpread1_Sheet1.Rows.Count - 1;
if (detail.drugFlag == "1")
{
//药品进销存管理类
//Neusoft.HISFC.BizLogic.Pharmacy.Item drugManager = new Neusoft.HISFC.BizLogic.Pharmacy.Item();
//根据药品编码获得某一药品信息
Neusoft.HISFC.Models.Pharmacy.Item drug = this.pharmacyIntegrate.GetItem(detail.itemCode);
if (drug == null)//没找到
{
drug = new Neusoft.HISFC.Models.Pharmacy.Item();
drug.Name = "帐目表中无该项目";
}
//如果规格不为空
if (drug.Specs != null && drug.Specs != "")
{
drug.Name = drug.Name + "{" + drug.Specs + "}";
}
neuSpread1_Sheet1.SetValue(row, (int)Cols.ItemName, drug.Name, false); //项目名称
neuSpread1_Sheet1.SetValue(row, (int)Cols.Price, drug.Price, false); //价格
neuSpread1_Sheet1.SetValue(row, (int)Cols.Unit, drug.PriceUnit, false); //单位
}
else
{
//Neusoft.HISFC.BizLogic.Fee.Item undrugManager = new Neusoft.HISFC.BizLogic.Fee.Item();
Neusoft.HISFC.Models.Fee.Item.Undrug undrug = this.feeIntegrate.GetUndrugByCode(detail.itemCode);
if (undrug == null)
{//没找到
undrug = new Neusoft.HISFC.Models.Fee.Item.Undrug();
undrug.Name = "帐目表中无该项目";
}
neuSpread1_Sheet1.SetValue(row, (int)Cols.ItemName, undrug.Name, false); //项目名称
neuSpread1_Sheet1.SetValue(row, (int)Cols.Price, undrug.Price, false); //价格
neuSpread1_Sheet1.SetValue(row, (int)Cols.Unit, undrug.PriceUnit, false); //单位
}
//项目代码
neuSpread1_Sheet1.SetTag(row, (int)Cols.ItemName, detail.itemCode);
neuSpread1_Sheet1.SetValue(row, (int)Cols.Qty, detail.qty, false); //数量
neuSpread1_Sheet1.SetValue(row, (int)Cols.Dept, detail.deptName, false); //执行科室
neuSpread1_Sheet1.SetTag(row, (int)Cols.Dept, detail.deptCode); //执行科室代码
neuSpread1_Sheet1.SetValue(row, (int)Cols.Combo, detail.combNo, false); //组合号
neuSpread1_Sheet1.SetValue(row, (int)Cols.Memo, detail.reMark, false); //备注
neuSpread1_Sheet1.SetValue(row, (int)Cols.OperCode, detail.operCode, false); //操作员
neuSpread1_Sheet1.SetValue(row, (int)Cols.OperDate, detail.OperDate.ToString(), false); //操作时间
neuSpread1_Sheet1.SetValue(row, (int)Cols.SortId, (decimal)detail.SortNum, false); //序号
neuSpread1_Sheet1.Rows[row].Tag = detail;
return(0);
}
private ArrayList GetSelectedDetail()
{
ArrayList alReturnDetailsTemp = new ArrayList();
for (int i = 0; i < this.neuSpread1_Sheet1.RowCount; i++)
{
bool isSelected = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.neuSpread1_Sheet1.Cells[i, 0].Value);
if (!isSelected)
{
Neusoft.HISFC.Models.Fee.ComGroupTail comGroupTail = this.neuSpread1_Sheet1.Rows[i].Tag as Neusoft.HISFC.Models.Fee.ComGroupTail;
alReturnDetailsTemp.Add(comGroupTail);
}
}
return(alReturnDetailsTemp);
}
/// <summary>
/// 删除一条明细
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int DeleteDataIntoComGroupTail(Neusoft.HISFC.Models.Fee.ComGroupTail 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("Manager.ComGroup.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="info"></param>
/// <returns></returns>
public int ModefyDataIntoComGroupTail(Neusoft.HISFC.Models.Fee.ComGroupTail info)
{
string strSql = "";
try
{
//update fin_com_groupdetail set exec_dpcd =(select dept_code from com_department where dept_name ='{0}' and PARENT_CODE ='[父级编码]' and CURRENT_CODE ='[本级编码]') ,qty= {1},unit_flag ='{2}',comb_no ='{3}' ,remark ='{4}' where group_id = '{5}' and sequence_no ={6} and PARENT_CODE ='[父级编码]' and CURRENT_CODE ='[本级编码]'
if (this.Sql.GetSql("Manager.ComGroup.ModefyDataIntoComGroupTail", ref strSql) == -1)
{
return(-1);
}
string OperCode = this.Operator.ID;
strSql = string.Format(strSql, info.deptName, info.qty, info.unitFlag, info.combNo, info.reMark, info.ID, info.sequenceNo, info.SortNum);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 插入一条明细
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertDataIntoComGroupTail(Neusoft.HISFC.Models.Fee.ComGroupTail info)
{
string strSql = "";
try
{
//insert into fin_com_groupdetail values('[本级编码]','[父级编码]','{0}',{1},'{2}','{3}',(select dept_code from com_department where dept_name ='{4}' and PARENT_CODE ='[父级编码]' and CURRENT_CODE ='[本级编码]'),{5},'{6}','{7}','{8}','{9}',sysdate)
if (this.Sql.GetSql("Manager.ComGroup.InsertDataIntoComGroupTail", ref strSql) == -1)
{
return(-1);
}
string OperCode = this.Operator.ID;
strSql = string.Format(strSql, info.ID, info.sequenceNo, info.itemCode, info.drugFlag, info.deptName, info.qty, info.unitFlag, info.combNo, info.reMark, OperCode, info.SortNum);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
