public static string getPiecePart(string partNo) { string res = string.Empty; try { string sql = "SELECT [BarcodeNO],[PartNO],[Location],[Creater],[CreateDate] " + "FROM [WMS_BarCode_V10].[dbo].[ARGPackingWIP_t] where PartNo = '" + partNo + "' and BPstatus = '0' " + "order by cast(replace(REPLACE(location,'-',''),'M','') as int)"; DataSet ds = new DataSet(); ds = FGA_DAL.Base.SQLServerHelper_WMS.Query(sql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { List <BarcodeHelperModel> luw = new List <BarcodeHelperModel>(); foreach (DataRow row in ds.Tables[0].Rows) { BarcodeHelperModel ERM = new BarcodeHelperModel(row); luw.Add(ERM); } JavaScriptSerializer jssl = new JavaScriptSerializer(); res = jssl.Serialize(luw); res = res.Replace("\\/Date(", "").Replace(")\\/", ""); } } catch (Exception e) { } return(res); }
public static string getPartialData() { string res = string.Empty; try { string sql = "SELECT [BarcodeNO],[PartNO],[BoxType],[OrderQty],[Quantity] " + ",[Creator],[CreateDate],[BoxStatus],[Location] " + " FROM [WMS_BarCode_V10].[dbo].[ARGPartialBox_T] where isnull(dr,0) = 0 and len(barcodeno) > 7 and [Location] not like '%T%' order by CreateDate DESC "; DataSet ds = new DataSet(); ds = FGA_DAL.Base.SQLServerHelper_WMS.Query(sql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { List <BarcodeHelperModel> luw = new List <BarcodeHelperModel>(); foreach (DataRow row in ds.Tables[0].Rows) { BarcodeHelperModel ERM = new BarcodeHelperModel(row); luw.Add(ERM); } JavaScriptSerializer jssl = new JavaScriptSerializer(); res = jssl.Serialize(luw); res = res.Replace("\\/Date(", "").Replace(")\\/", ""); } } catch (Exception e) { } return(res); }
public static string SearchPartialData(string BarcodeID) { string res = string.Empty; try { string sql = "SELECT [BarcodeNO],[PartNO],[BoxType],[OrderQty],[Quantity] " + ",[Creator],[CreateDate],[BoxStatus],[Location] " + " FROM [WMS_BarCode_V10].[dbo].[ARGPartialBox_T] where isnull(dr,0) = 0 and len(barcodeno) > 7 and [Location] not like '%T%' "; //查询条件 if (!String.IsNullOrEmpty(BarcodeID)) { string ids = "\'0\'"; int lg = BarcodeID.Length / 9; for (int i = 0; i < lg; i++) { ids = ids + "," + '\'' + BarcodeID.Substring(i * 9, 9) + '\''; } sql = sql + " and [BarcodeNO] in (" + ids + ") "; } else { sql = sql + " and 1 = 2 "; } sql = sql + " order by CreateDate DESC"; DataSet ds = new DataSet(); ds = FGA_DAL.Base.SQLServerHelper_WMS.Query(sql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { List <BarcodeHelperModel> luw = new List <BarcodeHelperModel>(); foreach (DataRow row in ds.Tables[0].Rows) { BarcodeHelperModel ERM = new BarcodeHelperModel(row); luw.Add(ERM); } JavaScriptSerializer jssl = new JavaScriptSerializer(); res = jssl.Serialize(luw); res = res.Replace("\\/Date(", "").Replace(")\\/", ""); } } catch (Exception e) { } return(res); }
public static string SearchData(string bncode, string pncode, string location, string fdate, string tdate) { string res = string.Empty; try { string sql = "SELECT [BarcodeNO],[PartNO],[Location],[Creater],[CreateDate] " + "FROM [WMS_BarCode_V10].[dbo].[ARGPackingWIP_t] where 1=1 and BPstatus = '0'"; //查询条件 if (!String.IsNullOrEmpty(bncode)) { sql = sql + " and [BarcodeNO] like '" + bncode + "'"; } if (!String.IsNullOrEmpty(pncode)) { sql = sql + " and [PartNO] like '" + pncode + "'"; } if (!String.IsNullOrEmpty(location)) { if (location == "All") { sql = sql + " and [location] = [location]"; } else { sql = sql + " and [location] = '" + location + "'"; } } if (!String.IsNullOrEmpty(fdate)) { sql = sql + " and [createdate] >= cast('" + fdate + "' as datetime)"; } if (!String.IsNullOrEmpty(tdate)) { sql = sql + " and [createdate] <= cast('" + tdate + "' as datetime)"; } sql = sql + " order by cast(replace(substring(location,2,len(location)-1),'-','') as int)"; DataSet ds = new DataSet(); ds = FGA_DAL.Base.SQLServerHelper_WMS.Query(sql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { List <BarcodeHelperModel> luw = new List <BarcodeHelperModel>(); foreach (DataRow row in ds.Tables[0].Rows) { BarcodeHelperModel ERM = new BarcodeHelperModel(row); luw.Add(ERM); } JavaScriptSerializer jssl = new JavaScriptSerializer(); res = jssl.Serialize(luw); res = res.Replace("\\/Date(", "").Replace(")\\/", ""); } } catch (Exception e) { } return(res); }
public static string SearchData(string bncode, string pncode, string location, string fdate, string tdate) { string res = string.Empty; try { string sql = "SELECT [BarcodeNO],[PartNO],[BoxType],[OrderQty],[Quantity] " + ",[Creator],[CreateDate],[BoxStatus],[Location] " + " FROM [WMS_BarCode_V10].[dbo].[ARGPartialBox_T] where isnull(dr,0) = 0 and len(barcodeno) > 7"; //查询条件 if (!String.IsNullOrEmpty(bncode)) { sql = sql + " and [BarcodeNO] like '%" + bncode + "%' "; } if (!String.IsNullOrEmpty(pncode)) { sql = sql + " and [PartNO] like '%" + pncode + "%' "; } if (!String.IsNullOrEmpty(location)) { if (location == "All") { sql = sql + " and [location] = [location]"; } else { sql = sql + " and [location] like '%" + location + "%' "; } } if (!String.IsNullOrEmpty(fdate)) { sql = sql + " and [createdate] >= cast('" + fdate + "' as datetime)"; } if (!String.IsNullOrEmpty(tdate)) { sql = sql + " and [createdate] <= cast('" + tdate + "' as datetime)"; } sql = sql + " order by location"; DataSet ds = new DataSet(); ds = FGA_DAL.Base.SQLServerHelper_WMS.Query(sql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { List <BarcodeHelperModel> luw = new List <BarcodeHelperModel>(); foreach (DataRow row in ds.Tables[0].Rows) { BarcodeHelperModel ERM = new BarcodeHelperModel(row); luw.Add(ERM); } JavaScriptSerializer jssl = new JavaScriptSerializer(); res = jssl.Serialize(luw); res = res.Replace("\\/Date(", "").Replace(")\\/", ""); } } catch (Exception e) { } return(res); }