public DS_Companys.CompanyNameListDataTable GetHaveOrdersAgents()
{
DS_Companys ds = new DS_Companys();
string sql = @"
SELECT companyId, companyName_cn, companyName + ', ' + companyName_cn as companyName
FROM Company
WHERE companyId in (select distinct agentID from agentOrders where status<7)";
m_dao.FillDataSet(ds, "CompanyNameList", sql, null);
return ds.CompanyNameList;
}
public DS_Companys.CompanyListDataTable GetCompanys(int status, int companyType, string companyName)
{
string sql = @"
SELECT companyId, shortname, companyName, telephone, contactPerson,
companyType, status
FROM Company";
string cnd = "";
bool b = false;
if (status>=0 && status<3)
cnd += "status=" + status.ToString() + " and ";
if (companyType>0)
cnd += "companyType=" + companyType.ToString() + " and ";
if (companyName!=null && companyName.Length>2)
{
cnd += "companyName like @companyName and ";
b = true;
}
if (cnd.Length > 0)
sql += " WHERE " + cnd.Substring(0,cnd.Length-5);
DS_Companys ds = new DS_Companys();
if(b){
SqlParameter[] para = {
new SqlParameter("@companyName", companyName),
};
m_dao.FillDataSet(ds,"CompanyList", sql, para);
}
else
m_dao.FillDataSet(ds,"CompanyList", sql, null);
return ds.CompanyList;
}
