/// <summary>
/// 根据出差申请单号获取报告单号
/// </summary>
/// <param name="strBillCode"></param>
/// <returns></returns>
public string GetAppCodeByReportCode(string strBillCode)
{
try
{
string strSql = "select maincode from Bill_TravelApplication where ReportCode='" + strBillCode + "'";
object objRel = new sqlHelper.sqlHelper().ExecuteScalar(strSql);
if (objRel == null)
{
return("");
}
else
{
return(objRel.ToString());
}
}
catch (Exception ex)
{
return("");
}
}
