/// <summary>
/// (医保)获取医保结算明细
/// </summary>
/// <param name="Hospcode"></param>
/// <param name="Billno"></param>
/// <param name="dtRecord"></param>
/// <returns></returns>
public long m_lngGetybjsmx(string DSN, string Hospcode, string Billno, out DataTable dtRecord)
{
dtRecord = new DataTable();
long lngRes = 0;
string SQL = @"select b.*, a.*
from masmzhzfjs a,
mashjsmx b
where a.medno = b.medno
and a.hos_code = '" + Hospcode + @"'
and a.billno = '" + Billno + "'";
try
{
clsF2 f2 = new clsF2();
f2.DSN = DSN;
lngRes = f2.GetDatatable(SQL, out dtRecord);
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <summary>
/// (医保)查询传送收费项目是否成功
/// </summary>
/// <param name="DSN"></param>
/// <param name="Hospcode"></param>
/// <param name="ZYNo"></param>
/// <param name="ZYSno"></param>
/// <returns></returns>
public bool m_blnCheckSendRes(string DSN, string Hospcode, string ZYNo, string ZYSno)
{
long lngRes = 0;
string SQL = @"select count(zyno) from mashxm where hos_code = '" + Hospcode + "' and zyno = '" + ZYNo + "' and zysno = " + ZYSno;
bool IsSuccess = false;
try
{
DataTable dt = new DataTable();
clsF2 f2 = new clsF2();
f2.DSN = DSN;
lngRes = f2.GetDatatable(SQL, out dt);
if (lngRes > 0)
{
if (int.Parse(dt.Rows[0][0].ToString()) > 0)
{
IsSuccess = true;
}
}
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(IsSuccess);
}
/// <summary>
/// (医保)检测结算自费项目表是否存在指定的BILLNO
/// </summary>
/// <param name="DSN"></param>
/// <param name="Hospcode"></param>
/// <param name="BillNo"></param>
public bool m_blnCheckBillNo(string DSN, string Hospcode, string BillNo)
{
long lngRes = 0;
string SQL = @"select count(*) from masmzhzfjs where hos_code = '" + Hospcode + "' and billno = '" + BillNo + "'";
bool IsExist = false;
try
{
DataTable dt = new DataTable();
clsF2 f2 = new clsF2();
f2.DSN = DSN;
lngRes = f2.GetDatatable(SQL, out dt);
if (lngRes > 0)
{
if (int.Parse(dt.Rows[0][0].ToString()) > 0)
{
IsExist = true;
}
}
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(IsExist);
}
/// <summary>
/// (医保)获取医保结算明细
/// </summary>
/// <param name="Hospcode"></param>
/// <param name="ZYNo"></param>
/// <param name="ZYSno"></param>
/// <param name="YbType">1 普通 2 公务员</param>
/// <returns></returns>
public long m_lngGetybjsmx(string DSN, string Hospcode, string ZYNo, string ZYSno, out DataTable dtRecord, out int YbType)
{
YbType = 0;
dtRecord = new DataTable();
long lngRes = 0;
string SQL = "";
try
{
clsF2 f2 = new clsF2();
f2.DSN = DSN;
SQL = @"select count(a.medno)
from mashbzjs a
where a.hos_code = '" + Hospcode + @"'
and a.zyno = '" + ZYNo + "' and a.zysno = " + ZYSno + @"
and upper(a.trnflg) = 'T'";
DataTable dt;
lngRes = f2.GetDatatable(SQL, out dt);
if (lngRes > 0)
{
if (int.Parse(dt.Rows[0][0].ToString()) == 0)
{
YbType = 1;
SQL = @"select a.*
from mashzfjs a
where a.hos_code = '" + Hospcode + @"'
and a.zyno = '" + ZYNo + "' and a.zysno = " + ZYSno + @"
and upper(a.trnflg) = 'T'";
lngRes = f2.GetDatatable(SQL, out dtRecord);
}
else
{
YbType = 2;
SQL = @"select a.*
from mashbzjs a
where a.hos_code = '" + Hospcode + @"'
and a.zyno = '" + ZYNo + "' and a.zysno = " + ZYSno + @"
and upper(a.trnflg) = 'T'";
lngRes = f2.GetDatatable(SQL, out dtRecord);
}
}
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <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>
/// (医保)传送时HIS事务失败，手工删除传送数据
/// </summary>
/// <param name="billno"></param>
/// <returns></returns>
public long m_lngDelybdata(string DSN, string ZYNo, string ZYSno)
{
try
{
string SQL = @"delete from mashxm where zyno = '" + ZYNo + "' and zysno = " + ZYSno;
long rows = 0;
clsF2 F2Svc = new clsF2();
F2Svc.DSN = DSN;
long l = F2Svc.ExecuteSQL(SQL, ref rows);
}
catch
{
return(0);
}
return(1);
}
/// <summary>
/// (医保)传送时HIS事务失败，手工删除传送数据
/// </summary>
/// <param name="billno"></param>
/// <returns></returns>
public long m_lngDelybdata(string DSN, string billno)
{
try
{
string SQL = @"delete from masmzhxm where billno = '" + billno + "'";
long rows = 0;
clsF2 F2Svc = new clsF2();
F2Svc.DSN = DSN;
long l = F2Svc.ExecuteSQL(SQL, ref rows);
}
catch
{
return(0);
}
return(1);
}
/// <summary>
/// (医保)手工更改记帐单号
/// </summary>
/// <param name="DSN"></param>
/// <param name="OldBillNo"></param>
/// <param name="NewBillNo"></param>
/// <returns></returns>
public long m_lngModifyBillNo(string DSN, string OldBillNo, string NewBillNo)
{
try
{
string SQL = @"update masmzhxm set billno = '" + NewBillNo + "' where billno = '" + OldBillNo + "'";
long rows = 0;
clsF2 F2Svc = new clsF2();
F2Svc.DSN = DSN;
long l = F2Svc.ExecuteSQL(SQL, ref rows);
}
catch
{
return(0);
}
return(1);
}
/// <summary>
/// (医保)传送住院收费数据到医保前置机
/// </summary>
/// <param name="DSN"></param>
/// <param name="objYBArr"></param>
/// <returns></returns>
public long m_lngSendybdata(string DSN, DataTable dt)
{
long lngRes = 0;
string Sql = "";
try
{
ArrayList SqlArr = new ArrayList();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
Sql = @"insert into mashxm (hos_code, zyno, zysno, xmcode, xmdes, xmunt, xmqnt,
xmprc, xmamt, trndate, trnflag, memoa, u_version) values ('" +
dr["hos_code"].ToString() + "','" +
dr["zyno"].ToString() + "'," +
dr["zysno"].ToString() + ",'" +
dr["xmcode"].ToString() + "','" +
dr["xmdes"].ToString() + "','" +
dr["xmunt"].ToString() + "'," +
dr["xmqnt"].ToString() + "," +
dr["xmprc"].ToString() + "," +
dr["xmamt"].ToString() + ",'" +
Convert.ToDateTime(dr["trndate"].ToString()).ToString("yyyy-MM-dd") + "','" +
dr["trnflag"].ToString() + "','" +
dr["memoa"].ToString() + "','" +
dr["u_version"].ToString() + "')";
SqlArr.Add(Sql);
}
clsF2 F2Svc = new clsF2();
F2Svc.DSN = DSN;
lngRes = F2Svc.ExecuteSQL(SqlArr);
}
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);
}
/// <summary>
/// (医保)下载医保前置机数据
/// </summary>
/// <param name="DSN"></param>
/// <param name="Hospcode"></param>
/// <param name="ZYNo"></param>
/// <param name="ZYSno"></param>
/// <param name="dt"></param>
/// <returns></returns>
public long m_lngDownloadYBData(string DSN, string Hospcode, string ZYNo, string ZYSno, out DataTable dt)
{
long lngRes = 0;
dt = new DataTable();
try
{
string SQL = @"select * from mashxm where hos_code = '" + Hospcode + "' and zyno = '" + ZYNo + "' and zysno = " + ZYSno;
clsF2 f2 = new clsF2();
f2.DSN = DSN;
lngRes = f2.GetDatatable(SQL, out dt);
}
catch
{
//throw Exp;
return(0);
}
return(lngRes);
}
