[WebMethod] //合同号
public String[] GetContractNO(string prefixText, int count)
{
///检测参数是否为空
if (string.IsNullOrEmpty(prefixText) == true || count <= 0)
{
return(null);
}
// 如果数组为空
if (autoCompleteWordList == null)
{
//读取数据库的内容
SqlConnection sqlConn = new SqlConnection();
sqlConn.ConnectionString = DBCallCommon.GetStringValue("connectionStrings");
sqlConn.Open();
DataSet ds = new DataSet();
string sqltext = "";
//2为供应商
sqltext = "SELECT PCON_BCODE+'|'+PCON_NAME AS HTBH FROM TBPM_CONPCHSINFO " +
" WHERE (PCON_BCODE LIKE '%" + prefixText + "%' or PCON_NAME like '%" + prefixText + "%')";
ds = DBCallCommon.FillDataSet(sqltext);
//读取内容文件的数据到临时数组
string[] temp = new string[ds.Tables[0].Rows.Count];
int i = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
temp[i] = dr["HTBH"].ToString();
i++;
}
Array.Sort(temp, new CaseInsensitiveComparer());
//将临时数组的内容赋给返回数组
autoCompleteall = temp;
if (sqlConn.State == ConnectionState.Open)
{
sqlConn.Close();
}
}
int matchCount = autoCompleteall.Length >= count ? count : autoCompleteall.Length;
string[] matchResultList = new string[matchCount];
if (matchCount > 0)
{ //复制搜索结果
Array.Copy(autoCompleteall, 0, matchResultList, 0, matchCount);
}
return(matchResultList);
}
[WebMethod] //工程名称
public String[] GetENGNAME(string prefixText, int count)
{
///检测参数是否为空
if (string.IsNullOrEmpty(prefixText) == true || count <= 0)
{
return(null);
}
// 如果数组为空
if (autoCompleteWordList == null)
{
//读取数据库的内容
SqlConnection sqlConn = new SqlConnection();
sqlConn.ConnectionString = DBCallCommon.GetStringValue("connectionStrings");
sqlConn.Open();
DataSet ds = new DataSet();
DataTable glotb = new DataTable();
ds = DBCallCommon.FillDataSet("SELECT ISNULL(TSA_ENGNAME,'') + '|' + ISNULL(TSA_ID,'') as Expr1 FROM TBPM_TCTSASSGN WHERE (TSA_ENGNAME LIKE '%" + prefixText + "%' or TSA_ID like '%" + prefixText + "%') and TSA_ID not like '%-%'");
glotb.Merge(ds.Tables[0]);
glotb.AcceptChanges();
//读取内容文件的数据到临时数组
string[] temp = new string[glotb.Rows.Count];
int i = 0;
foreach (DataRow dr in glotb.Rows)
{
temp[i] = dr["Expr1"].ToString();
i++;
}
Array.Sort(temp, new CaseInsensitiveComparer());
autoCompleteall = temp;
//将临时数组的内容赋给返回数组
if (sqlConn.State == ConnectionState.Open)
{
sqlConn.Close();
}
}
int matchCount = autoCompleteall.Length >= count ? count : autoCompleteall.Length;
string[] matchResultList = new string[matchCount];
if (matchCount > 0)
{ //复制搜索结果
Array.Copy(autoCompleteall, 0, matchResultList, 0, matchCount);
}
return(matchResultList);
}