/// <summary>
/// //转帐请款主档
/// </summary>
/// <param name="corpNo"></param>
/// <param name="getNo"></param>
/// <returns></returns>
public PETTY_TRANS_M GetClassPetty_Trans_m(string corpNo,string getNo)
{
string sql ="select * from PETTY_TRANS_M where Corp_No='{0}' and C_QKNO='{1}' ";
IDataReader r = OracleHelper.GetDataReader(string.Format(sql,PrivateConst.Corp_No,getNo));
PETTY_TRANS_M im = new PETTY_TRANS_M();
if (r.Read())
{
im.CORP_NO = r["CORP_NO"].ToString();
im.C_QKNO = r["C_QKNO"].ToString();
im.C_QKDATE = r["C_QKDATE"].ToString();
im.YYYYMM = r["YYYYMM"].ToString();
im.C_DEPTNO = r["C_DEPTNO"].ToString();
im.C_BRANCH=r["C_BRANCH"].ToString();
im.BANK_NM =r["BANK_NM"].ToString();
im.ACCOUNT_NO =r["ACCOUNT_NO"].ToString();
im.C_USERNO =r["C_USERNO"].ToString();
im.SUP_NM =r["SUP_NM"].ToString();
im.C_LOCKMK = r["C_LOCKMK"].ToString();
im.C_SAKE = r["C_SAKE"].ToString();
im.ACC_NO = r["ACC_NO"].ToString();
}
else
{
return null;
}
r.Close();
return im;
}
/// //转帐请款主档
/// </summary>
/// <param name="corpNo"></param>
/// <param name="getNo"></param>
/// <returns></returns>
public PETTY_TRANS_M GetClassPetty_Trans_m(string corpNo,string getNo)
{
string sql ="select * from PETTY_TRANS_M where Corp_No='{0}' and C_QKNO='{1}' ";
IDataReader r = OracleHelper.GetDataReader(string.Format(sql,PrivateConst.Corp_No,getNo));
PETTY_TRANS_M im = new PETTY_TRANS_M();
if (r.Read())
{
im.CORP_NO = r["CORP_NO"].ToString();
im.C_QKNO = r["C_QKNO"].ToString();
im.C_QKDATE = r["C_QKDATE"].ToString();
im.YYYYMM = r["YYYYMM"].ToString();
im.C_DEPTNO = r["C_DEPTNO"].ToString();
im.C_BRANCH=r["C_BRANCH"].ToString();
im.BANK_NM =r["BANK_NM"].ToString();
im.ACCOUNT_NO =r["ACCOUNT_NO"].ToString();
im.C_USERNO =r["C_USERNO"].ToString();
im.SUP_NM =r["SUP_NM"].ToString();
im.C_LOCKMK = r["C_LOCKMK"].ToString();
im.C_SAKE = r["C_SAKE"].ToString();
im.ACC_NO = r["ACC_NO"].ToString();
}
else
{
return null;
}
r.Close();
return im;
}