/// <summary> /// 得到到要调价的信息 返回列表 准备插入操作 /// </summary> /// <returns></returns> private ArrayList GetInfo(string SequenceNo) { ArrayList ItemList = new ArrayList(); if (AdjustTable == null) { return(null); } Neusoft.HISFC.Models.Fee.Item.AdjustPrice item = null; //循环取数据 foreach (DataRow row in AdjustTable.Rows) { item = new Neusoft.HISFC.Models.Fee.Item.AdjustPrice(); item.AdjustPriceNO = SequenceNo; item.OrgItem.ID = row["编码"].ToString(); item.OrgItem.Price = Neusoft.FrameWork.Function.NConvert.ToDecimal(row["调前默认价"].ToString()); item.OrgItem.ChildPrice = Neusoft.FrameWork.Function.NConvert.ToDecimal(row["调前儿童价"].ToString()); item.OrgItem.SpecialPrice = Neusoft.FrameWork.Function.NConvert.ToDecimal(row["调前特诊价"].ToString()); item.NewItem.Price = Neusoft.FrameWork.Function.NConvert.ToDecimal(row["调后默认价"].ToString()); item.NewItem.ChildPrice = Neusoft.FrameWork.Function.NConvert.ToDecimal(row["调后儿童价"].ToString()); item.NewItem.SpecialPrice = Neusoft.FrameWork.Function.NConvert.ToDecimal(row["调后特诊价"].ToString()); item.BeginTime = this.dtpImmediate.Value; if (this.ckbImmediate.Checked) //是否即时生效 { item.User03 = "已生效"; // 即时生效 则置成未生效 } else { item.User03 = "未生效"; //非即时生效 ,则置成已生效 } ItemList.Add(item); item = null; } return(ItemList); }
/// <summary> /// 增加一行数据到调价窗口 /// </summary> private void AddDataInfo() { try { if (this.neuSpread1_Sheet1.RowCount < 1) { return; //如果没有数据返回空 } ArrayList alInfo = new ArrayList(); Neusoft.HISFC.Models.Fee.Item.Undrug info = new Neusoft.HISFC.Models.Fee.Item.Undrug(); //从数据库获取要修改的信息 alInfo = item.Query(this.neuSpread1_Sheet1.Cells[this.neuSpread1_Sheet1.ActiveRowIndex, GetColumnKey("编码")].Text, "all"); if (info == null) { MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("获取非药品信息出错")); return; } if (alInfo == null) { return; } info.ID = ((Neusoft.HISFC.Models.Fee.Item.Undrug)alInfo[0]).ID; info.Name = ((Neusoft.HISFC.Models.Fee.Item.Undrug)alInfo[0]).Name; info.Price = ((Neusoft.HISFC.Models.Fee.Item.Undrug)alInfo[0]).Price; info.ChildPrice = ((Neusoft.HISFC.Models.Fee.Item.Undrug)alInfo[0]).ChildPrice; info.SpecialPrice = ((Neusoft.HISFC.Models.Fee.Item.Undrug)alInfo[0]).SpecialPrice; //定义查找 object[] keys = new object[] { info.ID }; DataRow tempRow = AdjustTable.Rows.Find(keys); if (tempRow != null) { MessageBox.Show(info.Name + "已经在调价信息表中了"); return; } Neusoft.HISFC.Models.Fee.Item.AdjustPrice tail = new Neusoft.HISFC.Models.Fee.Item.AdjustPrice(); tail.OrgItem.ID = info.ID; //非药品编码 tail.OrgItem.Name = info.Name; //非药品名称 tail.OrgItem.Price = info.Price; //默认价 tail.OrgItem.ChildPrice = info.ChildPrice; //儿童价 tail.OrgItem.SpecialPrice = info.SpecialPrice; //特诊价 tail.NewItem.Price = info.Price; tail.NewItem.ChildPrice = info.ChildPrice; tail.NewItem.SpecialPrice = info.SpecialPrice; //增加 DataRow row = AdjustTable.NewRow(); //填充数据 SetAdjustRow(tail, row); //增加到表中 AdjustTable.Rows.Add(row); //保存更改 UndrugTable.AcceptChanges(); LockfpSpread2(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 查询头表 /// </summary> /// <param name="BeginTime"></param> /// <param name="EndTime"></param> /// <returns></returns> public ArrayList SelectPriceAdjustHead(System.DateTime BeginTime, System.DateTime EndTime) { ArrayList List = null; string strSql = ""; if (this.Sql.GetSql("Fee.CAdjustPrice.SelectPriceAdjustHead", ref strSql) == -1) { return(null); } try { strSql = string.Format(strSql, BeginTime, EndTime); this.ExecQuery(strSql); Neusoft.HISFC.Models.Fee.Item.AdjustPrice info = null; List = new ArrayList(); while (this.Reader.Read()) { info = new Neusoft.HISFC.Models.Fee.Item.AdjustPrice(); info.AdjustPriceNO = Reader[0].ToString(); if (Reader[1] != DBNull.Value) { info.Oper.OperTime = Convert.ToDateTime(Reader[1]); } List.Add(info); info = null; } this.Reader.Close(); } catch (Exception ee) { this.Err = ee.Message; List = null; } return(List); }
/// <summary> /// 非药品调价记录表 插入 /// </summary> /// <param name="info"></param> /// <returns></returns> public int InsertAdjustPriceDetail(Neusoft.HISFC.Models.Fee.Item.AdjustPrice info) { string strSql = ""; if (this.Sql.GetSql("Fee.CAdjustPrice.InsertCAdjustPriceDetail", ref strSql) == -1) { return(-1); } try { string OperId = this.Operator.ID; string ValueState = ""; if (info.User03 == "已生效") { ValueState = "0"; } else if (info.User03 == "未生效") { ValueState = "1"; } else { ValueState = "2"; } strSql = string.Format(strSql, info.AdjustPriceNO, info.OrgItem.ID, info.NewItem.Price, info.NewItem.ChildPrice, info.NewItem.SpecialPrice, OperId, ValueState); } catch (Exception ee) { this.Err = ee.Message; } return(this.ExecNoQuery(strSql)); }
/// <summary> /// 填充 调价信息 /// </summary> /// <param name="obj"></param> /// <param name="row"></param> private void SetAdjustRow(Neusoft.HISFC.Models.Fee.Item.AdjustPrice obj, DataRow row) { row["编码"] = obj.OrgItem.ID; //0 row["名称"] = obj.OrgItem.Name; //1 row["调前默认价"] = obj.OrgItem.Price; //5 row["调前儿童价"] = obj.OrgItem.ChildPrice; //6 row["调前特诊价"] = obj.OrgItem.SpecialPrice; //7 row["调后默认价"] = obj.NewItem.Price; //5 row["调后儿童价"] = obj.NewItem.ChildPrice; //6 row["调后特诊价"] = obj.NewItem.SpecialPrice; //7 }
/// <summary> /// 非药品调价头表 插入 /// </summary> /// <param name="info"></param> /// <returns></returns> public int InsertAdjustPrice(Neusoft.HISFC.Models.Fee.Item.AdjustPrice info) { string strSql = ""; if (info.IsValid) { //调价即时生效 if (this.Sql.GetSql("Fee.CAdjustPrice.InsertCAdjustPrice1", ref strSql) == -1) { return(-1); } try { string OperId = this.Operator.ID; //insert into fin_com_adjustundrugpricehead values('[父级编码]','[本级编码]','{0}',sysdate,'{1}',sysdate) strSql = string.Format(strSql, info.AdjustPriceNO, OperId); } catch (Exception ee) { this.Err = ee.Message; } } else { if (this.Sql.GetSql("Fee.CAdjustPrice.InsertCAdjustPrice2", ref strSql) == -1) { return(-1); } try { string OperId = this.Operator.ID; //insert into fin_com_adjustundrugpricehead values('[父级编码]','[本级编码]','{0}',{1},'{2}',sysdate) strSql = string.Format(strSql, info.AdjustPriceNO, info.Oper.OperTime, OperId); } catch (Exception ee) { this.Err = ee.Message; } } return(this.ExecNoQuery(strSql)); }
/// <summary> /// 查询明细 /// </summary> /// <param name="AdjustPriceNo"></param> /// <returns></returns> public ArrayList SelectPriceAdjustTail(string AdjustPriceNo) { ArrayList List = null; string strSql = ""; if (this.Sql.GetSql("Fee.CAdjustPrice.SelectPriceAdjustTail", ref strSql) == -1) { return(null); } try { strSql = string.Format(strSql, AdjustPriceNo); this.ExecQuery(strSql); Neusoft.HISFC.Models.Fee.Item.AdjustPrice info = null; List = new ArrayList(); while (this.Reader.Read()) { info = new Neusoft.HISFC.Models.Fee.Item.AdjustPrice(); info.AdjustPriceNO = Reader[0].ToString(); info.OrgItem.ID = Reader[1].ToString(); info.OrgItem.Name = Reader[2].ToString(); if (Reader[3] != DBNull.Value) { info.OrgItem.Price = Convert.ToDecimal(Reader[3]); } if (Reader[4] != DBNull.Value) { info.NewItem.Price = Convert.ToDecimal(Reader[4]); } if (Reader[5] != DBNull.Value) { info.OrgItem.ChildPrice = Convert.ToDecimal(Reader[5]); } if (Reader[6] != DBNull.Value) { info.NewItem.ChildPrice = Convert.ToDecimal(Reader[6]); } if (Reader[7] != DBNull.Value) { info.OrgItem.SpecialPrice = Convert.ToDecimal(Reader[7]); } if (Reader[8] != DBNull.Value) { info.NewItem.SpecialPrice = Convert.ToDecimal(Reader[8]); } info.Oper.ID = Reader[9].ToString(); if (Reader[10] != DBNull.Value) { info.Oper.OperTime = Convert.ToDateTime(Reader[10]); } string ValueState = Reader[11].ToString(); if (ValueState == "0") { info.User03 = "已生效"; // } else if (ValueState == "1") { info.User03 = "未生效"; // } else { info.User03 = "已作废"; } List.Add(info); info = null; } this.Reader.Close(); } catch (Exception ee) { this.Err = ee.Message; List = null; } return(List); }