public DataTable FuzzySearch(string content)
{
SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_FuzzySearchCustomer");
sp.AddParam("@Content", SqlDbType.VarChar, content);
sp.AddParam("@AttributeCodes", SqlDbType.VarChar, "");
return(DataProvider.Instance.GetTable(_Loginer.DBName, sp.SqlCommand, tb_SUPPLIERCUSTOMER.__TableName));
}
public DataTable GetSUPPLIERCUSTOMERByAttributeCodes(string attributeCodes, bool nameWithCode)
{
SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_GetCustomerByAttributeCodes");
sp.AddParam("@AttributeCodes", SqlDbType.VarChar, attributeCodes);
sp.AddParam("@NameWithCode", SqlDbType.VarChar, nameWithCode ? "Y" : "N");
return(DataProvider.Instance.GetTable(_Loginer.DBName, sp.SqlCommand, "tb_SUPPLIERCUSTOMER"));
}
public DataTable TaskAccountByManual(int TaskId)
{
SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_WCS_Task_AccountByManual");
sp.AddParam("@IP", SqlDbType.NVarChar, Globals.DEF_ClientIP());
sp.AddParam("@Client", SqlDbType.NVarChar, Globals.DEF_ClientName());
sp.AddParam("@Loginer", SqlDbType.NVarChar, Loginer.CurrentUser.Account);
sp.AddParam("@TaskId", SqlDbType.Int, TaskId);
return(DataProvider.Instance.GetTable(_Loginer.DBName, sp.SqlCommand, tb_WMS_Task.__TableName));
}
public DataSet GetReportData_Checklist(string DocNoFrom, string DocNoTo, DateTime DateFrom, DateTime DateTo)
{
SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_RptAP_Checklist");
sp.AddParam("@DocNoFrom", SqlDbType.VarChar, DocNoFrom.Trim());
sp.AddParam("@DocNoTo", SqlDbType.VarChar, DocNoTo.Trim());
sp.AddParam("@DateFrom", SqlDbType.VarChar, ConvertEx.ToCharYYYYMMDD(DateFrom));
sp.AddParam("@DateTo", SqlDbType.VarChar, ConvertEx.ToCharYYYYMMDD(DateTo));
DataSet ds = DataProvider.Instance.GetDataSet(_Loginer.DBName, sp.SqlCommand);
ds.Tables[0].TableName = tb_AP.__TableName;
return(ds);
}
public DataTable FuzzySearch(string content)
{
SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_FuzzySearchProduct");
sp.AddParam("@Content", SqlDbType.NVarChar, content);
return(DataProvider.Instance.GetTable(_Loginer.DBName, sp.SqlCommand, tb_Product.__TableName));
}
public DataTable TaskPriorityModify(int TaskId, int First, int Second)
{
SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_WCS_Task_PriorityModify");
sp.AddParam("@IP", SqlDbType.NVarChar, Globals.DEF_ClientIP());
sp.AddParam("@Client", SqlDbType.NVarChar, Globals.DEF_ClientName());
sp.AddParam("@Loginer", SqlDbType.NVarChar, Loginer.CurrentUser.Account);
sp.AddParam("@TaskId", SqlDbType.Int, TaskId);
sp.AddParam("@First", SqlDbType.Int, First);
sp.AddParam("@Sencond", SqlDbType.Int, Second);
return(DataProvider.Instance.GetTable(_Loginer.DBName, sp.SqlCommand, tb_WMS_Task.__TableName));
}
public DataTable FuzzySearch(string content)
{
if (content.ToLower().Contains("like"))
{
string sql = ("select * from ITEM where ISDELETED=0 ");
if (content != "")
{
sql += content;
}
return(DataProvider.Instance.GetTable(_Loginer.DBName, sql, _TableName));
}
else
{
SqlProcedure sp = SqlBuilder.BuildSqlProcedure("sp_FuzzySearchProduct");
sp.AddParam("@Content", SqlDbType.NVarChar, content);
return(DataProvider.Instance.GetTable(_Loginer.DBName, sp.SqlCommand, tb_ITEM.__TableName));
}
}