/// <summary>
/// 组套明细
/// </summary>
/// <param name="lstzt">返回的数据集</param>
/// <returns>1,成功; -1,失败</returns>
public int QueryUnDrugztDetail(ref List <Neusoft.HISFC.Models.Fee.Item.UndrugComb> lstzt)
{
string strsql = "";
if (this.Sql.GetSql("Fee.Itemzt.Info.QueryZTDetails", ref strsql) == -1)
{
return(-1);
}
if (this.ExecQuery(strsql) == -1)
{
return(-1);
}
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Fee.Item.UndrugComb zt = new Neusoft.HISFC.Models.Fee.Item.UndrugComb();
zt.Package.ID = this.Reader.IsDBNull(0) ? "" : this.Reader.GetString(0);
zt.Package.Name = this.Reader.IsDBNull(1) ? "" : this.Reader.GetString(1);
zt.ID = this.Reader.IsDBNull(2) ? "" : this.Reader.GetString(2);
zt.Name = this.Reader.IsDBNull(3) ? "" : this.Reader.GetString(3);
zt.SortID = this.Reader.IsDBNull(4) ? 0 : Convert.ToInt32(this.Reader.GetDecimal(4));
zt.Qty = this.Reader.IsDBNull(5) ? 0 : this.Reader.GetDecimal(5);
zt.ValidState = this.Reader.IsDBNull(6) ? "" : this.Reader.GetString(6);
zt.SpellCode = this.Reader.IsDBNull(7) ? "" : this.Reader.GetString(7);
zt.WBCode = this.Reader.IsDBNull(8) ? "" : this.Reader.GetString(8);
zt.UserCode = this.Reader.IsDBNull(9) ? "" : this.Reader.GetString(9);
zt.Memo = "11";//这是一个标志位,如果为11则,再操作时用update,否则用insert;
lstzt.Add(zt);
}
this.Reader.Close();
return(1);
}
/// <summary>
/// 获得非药品组合项目的实体属性数组
/// </summary>
/// <param name="undrugComb">非药品组合项目实体</param>
/// <returns>非药品组合项目的实体属性数组</returns>
private string[] GetUndrugCombParams(Neusoft.HISFC.Models.Fee.Item.UndrugComb undrugComb)
{
string[] args =
{
undrugComb.Package.ID,
undrugComb.Package.Name,
undrugComb.SysClass.ID.ToString(),
undrugComb.SpellCode,
undrugComb.WBCode,
undrugComb.UserCode,
undrugComb.ExecDept,
undrugComb.SortID.ToString(),
NConvert.ToInt32(undrugComb.IsNeedConfirm).ToString(),
undrugComb.ValidState,
undrugComb.User01,
undrugComb.User02,
undrugComb.Memo,
undrugComb.Mark1,
undrugComb.Mark2,
undrugComb.Mark3,
undrugComb.Mark4
};
return(args);
}
public ArrayList GetValidUndrugzt()
{
ArrayList List = null;
string strSql = "";
if (this.Sql.GetSql("Fee.undrugzt.GetUndrugzt.Valid", ref strSql) == -1)
{
return(null);
}
try
{
// SELECT PACKAGE_CODE,PACKAGE_NAME,SYS_CLASS,SPELL_CODE,WB_CODE ,INPUT_CODE,DEPT_CODE ,SORT_ID ,CONFIRM_FLAG,VALID_STATE,EXT_FLAG,EXT1_FLAG FROM fin_com_undrugzt where parent_code = '[父级编码]' and current_code ='[本级编码]'
if (this.ExecQuery(strSql) == -1)
{
return(null);
}
Neusoft.HISFC.Models.Fee.Item.UndrugComb info = null;
List = new ArrayList();
while (this.Reader.Read())
{
//有效的复合项目
if (Reader[9].ToString() == "0")
{
info = new Neusoft.HISFC.Models.Fee.Item.UndrugComb();
info.ID = Reader[0].ToString();
info.Name = Reader[1].ToString();
info.SysClass.ID = Reader[2].ToString();
info.SpellCode = Reader[3].ToString();
info.WBCode = Reader[4].ToString();
info.UserCode = Reader[5].ToString();
info.ExecDept = Reader[6].ToString();
if (Reader[7] != DBNull.Value)
{
info.SortID = Convert.ToInt32(Reader[7].ToString());
}
info.IsNeedConfirm = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[8].ToString());
info.ValidState = Reader[9].ToString();
info.User01 = Reader[10].ToString();
info.User02 = Reader[11].ToString();
info.Memo = Reader[12].ToString(); //备注
info.Mark1 = Reader[13].ToString(); //病史及检查(开立检查申请单时使用)
info.Mark2 = Reader[14].ToString(); //检查要求(开立检查申请单时使用)
info.Mark3 = Reader[15].ToString(); // 注意事项(开立检查申请单时使用)
info.Mark4 = Reader[16].ToString(); //检查申请单名称
List.Add(info);
}
}
this.Reader.Close();
}
catch (Exception ee)
{
this.Err = ee.Message;
List = null;
}
return(List);
}
public Neusoft.HISFC.Models.Fee.Item.UndrugComb GetSingleUndrugzt(string ztID)
{
string sql = "";
if (this.Sql.GetSql("Fee.undrugzt.GetSingleUndrugzt.1", ref sql) == -1)
{
return(null);
}
Neusoft.HISFC.Models.Fee.Item.UndrugComb info = new Neusoft.HISFC.Models.Fee.Item.UndrugComb();
try
{
sql = string.Format(sql, ztID);
if (this.ExecQuery(sql) == -1)
{
return(null);
}
while (this.Reader.Read())
{
//有效的复合项目
info = new Neusoft.HISFC.Models.Fee.Item.UndrugComb();
info.ID = Reader[0].ToString();
info.Name = Reader[1].ToString();
info.SysClass.ID = Reader[2].ToString();
info.SpellCode = Reader[3].ToString();
info.WBCode = Reader[4].ToString();
info.UserCode = Reader[5].ToString();
info.ExecDept = Reader[6].ToString();
if (Reader[7] != DBNull.Value)
{
info.SortID = Convert.ToInt32(Reader[7].ToString());
}
info.IsNeedConfirm = Neusoft.FrameWork.Function.NConvert.ToBoolean(Reader[8].ToString());
info.ValidState = Reader[9].ToString();
info.User01 = Reader[10].ToString();
info.User02 = Reader[11].ToString();
info.Memo = Reader[12].ToString(); //备注
info.Mark1 = Reader[13].ToString(); //病史及检查(开立检查申请单时使用)
info.Mark2 = Reader[14].ToString(); //检查要求(开立检查申请单时使用)
info.Mark3 = Reader[15].ToString(); // 注意事项(开立检查申请单时使用)
info.Mark4 = Reader[16].ToString(); //检查申请单名称
}
this.Reader.Close();
}
catch (Exception ee)
{
this.Err = "[Fee.undrugzt.GetUndrugzt.1]" + ee.Message;
this.ErrCode = ee.Message;
if (this.Reader.IsClosed == false)
{
this.Reader.Close();
}
return(null);
}
return(info);
}
/// <summary>
/// 通过SQL语句获得组合项目信息
/// </summary>
/// <param name="sql">SQL语句</param>
/// <param name="args">参数</param>
/// <returns>成功:组合项目信息集合 失败: null</returns>
private ArrayList QueryUndrugCombsBySql(string sql, params string[] args)
{
if (this.ExecQuery(sql, args) == -1)
{
return(null);
}
ArrayList undrugCombs = new ArrayList(); //组合项目集合
Neusoft.HISFC.Models.Fee.Item.UndrugComb undrugComb = new Neusoft.HISFC.Models.Fee.Item.UndrugComb(); //组合项目实体
try
{
while (this.Reader.Read())
{
undrugComb = new Neusoft.HISFC.Models.Fee.Item.UndrugComb();
undrugComb.Package.ID = this.Reader[0].ToString();
undrugComb.ID = this.Reader[0].ToString();
undrugComb.Package.Name = this.Reader[1].ToString();
undrugComb.Name = this.Reader[1].ToString();
undrugComb.SysClass.ID = this.Reader[2].ToString();
undrugComb.SpellCode = this.Reader[3].ToString();
undrugComb.WBCode = this.Reader[4].ToString();
undrugComb.UserCode = this.Reader[5].ToString();
undrugComb.ExecDept = this.Reader[6].ToString();
undrugComb.SortID = NConvert.ToInt32(this.Reader[7].ToString());
undrugComb.IsNeedConfirm = NConvert.ToBoolean(this.Reader[8].ToString());
undrugComb.ValidState = this.Reader[9].ToString();
undrugComb.User01 = this.Reader[10].ToString(); //是否特殊医疗项目
undrugComb.Memo = this.Reader[11].ToString(); //备注
undrugComb.Mark1 = this.Reader[12].ToString(); //病史及检查(开立检查申请单时使用)
undrugComb.Mark2 = this.Reader[13].ToString(); //检查要求(开立检查申请单时使用)
undrugComb.Mark3 = this.Reader[14].ToString(); // 注意事项(开立检查申请单时使用)
undrugComb.Mark4 = this.Reader[15].ToString(); //检查申请单名称
undrugCombs.Add(undrugComb);
}
this.Reader.Close();
return(undrugCombs);
}
catch (Exception e)
{
this.Err = e.Message;
if (this.Reader != null && !this.Reader.IsClosed)
{
this.Reader.Close();
}
return(null);
}
}
/// <summary>
/// 非药品组套明细表
/// </summary>
/// <param name="packageCode"></param>
/// <returns></returns>
public ArrayList QueryUndrugPackagesBypackageCode(string packageCode)
{
ArrayList List = null;
string strSql = "";
if (this.Sql.GetSql("Fee.undrugzt.GetUndrugztinfo", ref strSql) == -1)
{
return(null);
}
try
{
if (packageCode != "")
{
List = new ArrayList();
strSql = string.Format(strSql, packageCode);
this.ExecQuery(strSql);
Neusoft.HISFC.Models.Fee.Item.UndrugComb info = null;
while (this.Reader.Read())
{
info = new Neusoft.HISFC.Models.Fee.Item.UndrugComb();
info.Package.ID = Reader[0].ToString(); //组套编码
info.Name = Reader[1].ToString(); //非药品名称
info.ID = Reader[2].ToString(); //非药品编码
if (Reader[3] != DBNull.Value)
{
info.SortID = Convert.ToInt32(Reader[3]); //顺序号
}
else
{
info.SortID = 0;
}
info.SpellCode = Reader[4].ToString(); //取拼音码
info.WBCode = Reader[5].ToString(); //取五笔码
info.UserCode = Reader[6].ToString(); //输入码
info.User01 = Reader[7].ToString(); //标志
info.User02 = Reader[8].ToString(); // 是否特殊医疗项目 0 否 1 是
info.Qty = Neusoft.FrameWork.Function.NConvert.ToDecimal(Reader[9].ToString()); //数量
List.Add(info);
info = null;
}
this.Reader.Close();
}
}
catch (Exception ee)
{
this.Err = ee.Message;
List = null;
}
return(List);
}
/// <summary>
/// 根据SQL语句查询组套明细
/// </summary>
/// <param name="sql">SQL语句</param>
/// <param name="args">参数</param>
/// <returns>成功: 组套明细 失败: null</returns>
private ArrayList QueryUndrugCombDetailsBySql(string sql, params string[] args)
{
if (this.ExecQuery(sql, args) == -1)
{
return(null);
}
ArrayList undrugCombs = new ArrayList(); //组合项目集合
Neusoft.HISFC.Models.Fee.Item.UndrugComb undrugComb = new Neusoft.HISFC.Models.Fee.Item.UndrugComb(); //组合项目实体
try
{
while (this.Reader.Read())
{
undrugComb = new Neusoft.HISFC.Models.Fee.Item.UndrugComb();
undrugComb.Package.ID = this.Reader[0].ToString(); //组套编码
undrugComb.Name = this.Reader[1].ToString(); //非药品名称
undrugComb.ID = this.Reader[2].ToString(); //非药品编码
undrugComb.SortID = NConvert.ToInt32(this.Reader[3].ToString());
undrugComb.SpellCode = Reader[4].ToString(); //取拼音码
undrugComb.WBCode = Reader[5].ToString(); //取五笔码
undrugComb.UserCode = Reader[6].ToString(); //输入码
undrugComb.User01 = Reader[7].ToString(); //标志
undrugComb.User02 = Reader[8].ToString(); // 是否特殊医疗项目 0 否 1 是
undrugComb.Qty = NConvert.ToDecimal(Reader[9].ToString()); //数量
undrugCombs.Add(undrugComb);
}
this.Reader.Close();
return(undrugCombs);
}
catch (Exception e)
{
this.Err = e.Message;
if (this.Reader != null && !this.Reader.IsClosed)
{
this.Reader.Close();
}
return(null);
}
}
/// <summary>
/// 获取非药品组套明细
/// </summary>
/// <param name="pcode">组套编码</param>
/// <param name="pname">组套名称</param>
/// <param name="listzt">结果集</param>
/// <returns>1,成功; -1,失败</returns>
public int QueryUnDrugztDetail(string pcode, ref List <Neusoft.HISFC.Models.Fee.Item.UndrugComb> listzt)
{
string strsql = "";
if (this.Sql.GetSql("Fee.Itemzt.Info.QueryZTDetailsByCodeName1", ref strsql) == -1)
{
return(-1);
}
try
{
strsql = String.Format(strsql, pcode);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(-1);
}
if (this.ExecQuery(strsql) == -1)
{
return(-1);
}
while (this.Reader.Read())
{
Neusoft.HISFC.Models.Fee.Item.UndrugComb zt = new Neusoft.HISFC.Models.Fee.Item.UndrugComb();
zt.Package.ID = this.Reader.IsDBNull(0) ? "" : this.Reader.GetString(0);
zt.Package.Name = this.Reader.IsDBNull(1) ? "" : this.Reader.GetString(1);
zt.ID = this.Reader.IsDBNull(2) ? "" : this.Reader.GetString(2);
zt.Name = this.Reader.IsDBNull(3) ? "" : this.Reader.GetString(3);
zt.SortID = this.Reader.IsDBNull(4) ? 0 : Convert.ToInt32(this.Reader.GetDecimal(4));
zt.Qty = this.Reader.IsDBNull(5) ? 0 : this.Reader.GetDecimal(5);
zt.ValidState = this.Reader.IsDBNull(6) ? "" : this.Reader.GetString(6);
zt.SpellCode = this.Reader.IsDBNull(7) ? "" : this.Reader.GetString(7);
zt.WBCode = this.Reader.IsDBNull(8) ? "" : this.Reader.GetString(8);
zt.UserCode = this.Reader.IsDBNull(9) ? "" : this.Reader.GetString(9);
zt.Memo = "11";//这是一个标志位,如果为11则,再操作时用update,否则用insert;
zt.Price = this.Reader.IsDBNull(10) ? 0 : Convert.ToDecimal(this.Reader.GetDecimal(10));
zt.ChildPrice = this.Reader.IsDBNull(11) ? 0 : Convert.ToDecimal(this.Reader.GetDecimal(11));
zt.SpecialPrice = this.Reader.IsDBNull(12) ? 0 : Convert.ToDecimal(this.Reader.GetDecimal(12));
listzt.Add(zt);
}
this.Reader.Close();
return(1);
}
private void CreateNewLineInFpDetails(Neusoft.HISFC.Models.Fee.Item.UndrugComb zt)
{
this.fpDetails.Rows.Add(0, 1);
this.fpDetails.SetText(0, 0, zt.Package.ID);
this.fpDetails.SetText(0, 1, zt.Package.Name);
this.fpDetails.SetText(0, 2, zt.ID);
this.fpDetails.SetText(0, 3, zt.Name);
this.fpDetails.SetText(0, 4, zt.SortID.ToString());
this.fpDetails.SetText(0, 5, zt.Qty.ToString());
this.fpDetails.SetText(0, 6, zt.ValidState);
this.fpDetails.SetText(0, 7, zt.SpellCode);
this.fpDetails.SetText(0, 8, zt.WBCode);
this.fpDetails.SetText(0, 9, zt.UserCode);
this.fpDetails.SetText(0, 10, zt.Memo); //标志位,如果有值则为更新,否则为插入
//this.fpDetails.SetText(0, 11, "1");//数量
this.fpDetails.SetText(0, 11, zt.Price.ToString()); //三甲
this.fpDetails.SetText(0, 12, zt.ChildPrice.ToString()); //儿童
this.fpDetails.SetText(0, 13, zt.SpecialPrice.ToString()); //特诊价
}
/// <summary>
/// 删除一条新的记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int DeleteUndrugztinfo(Neusoft.HISFC.Models.Fee.Item.UndrugComb info)
{
string strSql = "";
if (this.Sql.GetSql("Fee.undrugzt.DeleteUndrugztinfo", ref strSql) == -1)
{
return(-1);
}
try
{
// delete fin_com_undrugztinfo where PACKAGE_CODE = '{0}' and ITEM_CODE ='{1}' and parent_code = '[父级编码]' and current_code ='[本级编码]'
strSql = string.Format(strSql, info.Package.ID, info.ID);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 更新一条记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int UpdateUndrugztinfo(Neusoft.HISFC.Models.Fee.Item.UndrugComb info)
{
string strSql = "";
if (this.Sql.GetSql("Fee.undrugzt.UpdateUndrugztinfo", ref strSql) == -1)
{
return(-1);
}
try
{
// update fin_com_undrugztinfo set SORT_ID='{2}' where PACKAGE_CODE ='{0}'and ITEM_CODE ='{1}' and parent_code = '[父级编码]' and current_code ='[本级编码]'
strSql = string.Format(strSql, info.Package.ID, info.ID, info.SortID, info.SpellCode, info.WBCode, info.UserCode, info.User01, info.Qty);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// 插入一条新的记录
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertUndruaztinfo(Neusoft.HISFC.Models.Fee.Item.UndrugComb info)
{
string strSql = "";
if (this.Sql.GetSql("Fee.undrugzt.InsertUndruaztinfo", ref strSql) == -1)
{
return(-1);
}
try
{
string OperId = this.Operator.ID;
// insert into fin_com_undrugztinfo (PACKAGE_CODE,ITEM_CODE,SORT_ID,OPER_CODE,OPER_DATE) values ('{0},'{1}','{2}','{3}',sysdate)
strSql = string.Format(strSql, info.Package.ID, info.ID, info.SortID, OperId, info.SpellCode, info.WBCode, info.UserCode, info.User01, info.Qty);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
private void SpreadItems_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
if (e.ColumnHeader)
{
return;
}
if (this.node.Tag == null)
{
MessageBox.Show("请选择所要维护的项目！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
string pcode = ((Neusoft.HISFC.Models.Fee.Item.Undrug) this.node.Tag).ID;
string pname = ((Neusoft.HISFC.Models.Fee.Item.Undrug) this.node.Tag).Name;
Neusoft.HISFC.Models.Fee.Item.UndrugComb undrugzt = new Neusoft.HISFC.Models.Fee.Item.UndrugComb();
undrugzt.Package.ID = pcode;
undrugzt.Package.Name = pname;
undrugzt.ID = this.fpItems.GetText(e.Row, 0); //以后把0改成名称
undrugzt.Name = this.fpItems.GetText(e.Row, 1); //也一样
undrugzt.SortID = 0; // Convert.ToInt32(this.fpItems.GetText(e.Row, 4));//也一样
undrugzt.Qty = 1; // Convert.ToDecimal(this.fpItems.GetText(e.Row, 5));//也一样
undrugzt.ValidState = ""; // this.fpItems.GetText(e.Row, 6);//有效性
undrugzt.SpellCode = this.fpItems.GetText(e.Row, 5);
undrugzt.WBCode = this.fpItems.GetText(e.Row, 6);
undrugzt.UserCode = this.fpItems.GetText(e.Row, 4);
undrugzt.ChildPrice = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.fpItems.GetText(e.Row, 26)); //儿童
undrugzt.Price = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.fpItems.GetText(e.Row, 9)); //三甲
undrugzt.SpecialPrice = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.fpItems.GetText(e.Row, 27)); //特诊价
undrugzt.Memo = ""; // this.fpItems.GetText(e.Row, 10);//标志位
if (this.IsNewLineExists(undrugzt.Package.ID, undrugzt.ID))
{
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("组套明细已经存在"));
return;
}
CreateNewLineInFpDetails(undrugzt);
}
private void SaveButtonHandler()
{
if (this.fpDetails.Rows.Count == 0)
{
return;
}
if (!Valid())
{
return;
}
decimal ChildPrice = 0;
decimal Price = 0;
decimal SpecialPrice = 0; //特诊
//{67BF98D0-3FF2-4ff6-ACF9-F06C4A601C6A}
this.SpreadDetails.StopCellEditing();//更新cell值
List <Neusoft.HISFC.Models.Fee.Item.UndrugComb> lstUndrug = new List <Neusoft.HISFC.Models.Fee.Item.UndrugComb>();
for (int i = 0, j = this.fpDetails.Rows.Count; i < j; i++)
{
Neusoft.HISFC.Models.Fee.Item.UndrugComb zt = new Neusoft.HISFC.Models.Fee.Item.UndrugComb();
zt.Package.ID = this.fpDetails.GetText(i, 0).Trim();
zt.Package.Name = this.fpDetails.GetText(i, 1).Trim();
zt.ID = this.fpDetails.GetText(i, 2).Trim();
zt.Name = this.fpDetails.GetText(i, 3).Trim();
zt.SortID = Convert.ToInt32(this.fpDetails.GetText(i, 4));
zt.Qty = Convert.ToDecimal(this.fpDetails.GetText(i, 5));
if (this.fpDetails.GetText(i, 6).Trim() == "")
{
zt.ValidState = "1";
}
else
{
zt.ValidState = this.fpDetails.GetText(i, 6).Trim() == "有效" ? "1" : "0";
}
zt.SpellCode = this.fpDetails.GetText(i, 7);
zt.WBCode = this.fpDetails.GetText(i, 8);
zt.UserCode = this.fpDetails.GetText(i, 9);
zt.Memo = this.fpDetails.GetText(i, 10);
//{67BF98D0-3FF2-4ff6-ACF9-F06C4A601C6A}
if (zt.ValidState == "1")//增加判断,如果该条项目有效,才累加单价
{
Price += zt.Qty * Neusoft.FrameWork.Function.NConvert.ToDecimal(this.fpDetails.GetText(i, 11));
ChildPrice += zt.Qty * Neusoft.FrameWork.Function.NConvert.ToDecimal(this.fpDetails.GetText(i, 12));
SpecialPrice += zt.Qty * Neusoft.FrameWork.Function.NConvert.ToDecimal(this.fpDetails.GetText(i, 13));
}
lstUndrug.Add(zt);
}
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction trans = new Neusoft.FrameWork.Management.Transaction(ztManager.Connection);
//trans.BeginTransaction();
ztManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
try
{
if (this.ztManager.SaveUndrugzt(lstUndrug) != 1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();;
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("保存数据失败"));
return;
}
//string itemCode = ((Neusoft.HISFC.Models.Fee.Item.Undrug)this.node.Tag).ID;
string itemCode = ((Neusoft.HISFC.Models.Fee.Item.Undrug) this.tvUndrugzt.SelectedNode.Tag).ID;
if (this.ztManager.UpdateUndrugztPrice(itemCode, Price, ChildPrice, SpecialPrice) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();;
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("保存数据失败"));
return;
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("保存数据成功"));
}
catch
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();;
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("保存数据失败"));
}
}
/// <summary>
/// 插入非药品组合项目
/// </summary>
/// <param name="undrugComb">非药品组合项目实体</param>
/// <returns>成功: 1 失败 : -1 没有插入数据 0</returns>
public int InsertUndrugComb(Neusoft.HISFC.Models.Fee.Item.UndrugComb undrugComb)
{
return(this.UpdateSingleTable("Fee.undrugzt.insertUndrugzt", this.GetUndrugCombParams(undrugComb)));
}
/// <summary>
/// 删除非药品组合项目
/// </summary>
/// <param name="undrugComb">非药品组合项目实体</param>
/// <returns>成功: 1 失败 : -1 没有删除到数据 0</returns>
public int DeleteUndrugComb(Neusoft.HISFC.Models.Fee.Item.UndrugComb undrugComb)
{
return(this.UpdateSingleTable("Fee.undrugzt.DeleteUndrugzt", undrugComb.ID));
}
