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)); } }