/// <summary>
/// (医保)传送门诊收费数据到医保前置机
/// </summary>
/// <param name="DSN"></param>
/// <param name="objSQLArr"></param>
/// <returns></returns>
public long m_lngSendybdata(string DSN, ArrayList objYBArr, ref string BillNo)
{
long lngRes = 0;
string Sql = "";
try
{
if (BillNo.Trim() == "")
{
clsOPChargeSvc objCharge = new clsOPChargeSvc();
objCharge.m_mthGenBillNo(out BillNo);
}
if (BillNo != "")
{
ArrayList SqlArr = new ArrayList();
for (int i = 0; i < objYBArr.Count; i++)
{
clsYB_VO objYB = objYBArr[i] as clsYB_VO;
//由于UI控件DATAGRID自身BUG,合计栏偶尔显示错误，故在此重算【合计 = 数量 * 单价】
Sql = @"insert into masmzhxm (hos_code, billno, xmcode, ass_sign, xmdes, xmunt , xmqnt,
xmprc, xmamt, trndate, trnflag, memoa, u_version) values ('" +
objYB.Hoscode + "','" +
BillNo + "','" +
objYB.XMCode + "','" +
objYB.Asssign + "','" +
objYB.XMDes + "','" +
objYB.XMUnt + "'," +
objYB.XMQnt + "," +
objYB.XMPrc + "," +
Convert.ToDecimal(objYB.XMQnt * objYB.XMPrc).ToString("0.00") + ",'" +
objYB.Trndate + "','" +
objYB.Trnflag + "','" +
objYB.Memoa + "','" +
objYB.UVersion + "')";
SqlArr.Add(Sql);
}
clsF2 F2Svc = new clsF2();
F2Svc.DSN = DSN;
lngRes = F2Svc.ExecuteSQL(SqlArr);
}
else
{
return(0);
}
}
catch
{
//throw Exp;
return(0);
}
return(lngRes);
}
/// <summary>
/// (医保)传送住院收费数据到医保前置机
/// </summary>
/// <param name="DSN"></param>
/// <param name="objYBArr"></param>
/// <returns></returns>
public long m_lngSendybdata(string DSN, ArrayList objYBArr)
{
long lngRes = 0;
string Sql = "";
try
{
ArrayList SqlArr = new ArrayList();
for (int i = 0; i < objYBArr.Count; i++)
{
clsYB_VO objYB = objYBArr[i] as clsYB_VO;
Sql = @"insert into mashxm (hos_code, zyno, zysno, xmcode, xmdes, xmunt , xmqnt,
xmprc, xmamt, trndate, trnflag, memoa, u_version) values ('" +
objYB.Hoscode + "','" +
objYB.ZYNo + "'," +
objYB.ZYSno + ",'" +
objYB.XMCode + "','" +
objYB.XMDes + "','" +
objYB.XMUnt + "'," +
objYB.XMQnt + "," +
objYB.XMPrc + "," +
objYB.XMAmt + ",'" +
objYB.Trndate + "','" +
objYB.Trnflag + "','" +
objYB.Memoa + "','" +
objYB.UVersion + "')";
SqlArr.Add(Sql);
}
clsF2 F2Svc = new clsF2();
F2Svc.DSN = DSN;
lngRes = F2Svc.ExecuteSQL(SqlArr);
}
catch
{
//throw Exp;
return(0);
}
return(lngRes);
}
