/// <summary>
/// 判断该车辆类型的标准返利是否已经批复
/// </summary>
/// <param name="strTruckCode"></param>
/// <returns></returns>
public bool ispf(string strTruckCode)
{
bool flg = true;
string strsql = @"select Status from T_SpecialRebatesStandard where TruckCode ='" + strTruckCode + "'";
DataTable dt = server.RunQueryCmdToTable(strsql);
if (dt.Rows.Count != 0 && dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["Status"].ToString() == "1")
{
flg = true;
}
else
{
flg = false;
break;
}
}
}
else
{
flg = false;
}
return(flg);
}
public DataTable GetAllHuiKuanNote(string strAppendSql)
{
string strSql = "select * from V_HuiKuanMingXi where 1=1";
if (!string.IsNullOrEmpty(strAppendSql))
{
strSql += strAppendSql;
}
return(server.RunQueryCmdToTable(strSql));
}
public DataTable getDt(string strCarcode)
{
string strsql = @"select * from V_TruckMsg where cjh='" + strCarcode + "'";
return(server.RunQueryCmdToTable(strsql));
}
