public DataSet sCutting() { clsDB obj = new clsDB(); string errMsg = ""; DataSet ds = new DataSet(); try { ds = obj.GetData("sMerchandiser", null); } catch (Exception ex) { errMsg = ex.Message; } finally { obj = null; } return(ds); }
public DataSet GetLayerInfo() { clsDB obj = new clsDB(); string errMsg = ""; DataSet ds = new DataSet(); try { ds = obj.GetData("sLayInfo", null); } catch (Exception ex) { errMsg = ex.Message; } finally { obj = null; } return(ds); }
public DataSet sBundleNumberFC() { clsDB obj = new clsDB(); string errMsg = ""; DataSet ds = new DataSet(); try { ds = obj.GetData("sBundleNumberFC", null); } catch (Exception ex) { errMsg = ex.Message; } finally { obj = null; } return(ds); }
public DataSet GetICSuplr(string icode) { clsDB obj = new clsDB(); string errMsg = ""; DataSet ds = new DataSet(); Hashtable ht = new Hashtable(); try { ht.Add("@ic", icode); ds = obj.GetData("sSuplrFC", ht); } catch (Exception ex) { errMsg = ex.Message; } finally { obj = null; } return(ds); }
public DataSet GetCanGenBundleNo(int LayBatchNo) { clsDB obj = new clsDB(); string errMsg = ""; DataSet ds = new DataSet(); Hashtable ht = new Hashtable(); try { ht.Add("@LBno", LayBatchNo); ds = obj.GetData("GetStatusGenBundleNo", ht); } catch (Exception ex) { errMsg = ex.Message; } finally { obj = null; } return(ds); }
public DataSet ShowLastBundleNo(string scode) { clsDB obj = new clsDB(); string errMsg = ""; DataSet ds = new DataSet(); Hashtable ht = new Hashtable(); try { ht.Add("@scode", scode); ds = obj.GetData("sSeriesCode", ht); } catch (Exception ex) { errMsg = ex.Message; } finally { obj = null; } return(ds); }
public DataSet GetSubCategoryForPcsPerBundle(string sid) { clsDB obj = new clsDB(); string errMsg = ""; DataSet ds = new DataSet(); Hashtable ht = new Hashtable(); try { ht.Add("@sid", sid); ds = obj.GetData("sSubcategorySelection", ht); } catch (Exception ex) { errMsg = ex.Message; } finally { obj = null; } return(ds); }
public DataSet GetSelectedFabWidth(string fid) { clsDB obj = new clsDB(); string errMsg = ""; DataSet ds = new DataSet(); Hashtable ht = new Hashtable(); try { ht.Add("@fid", fid); ds = obj.GetData("sFabwidthFT", ht); } catch (Exception ex) { errMsg = ex.Message; } finally { obj = null; } return(ds); }
public DataSet GetSizeType(string sid) { clsDB obj = new clsDB(); string errMsg = ""; DataSet ds = new DataSet(); Hashtable ht = new Hashtable(); try { ht.Add("@sid", sid); ds = obj.GetData("sSizetypeFC", ht); } catch (Exception ex) { errMsg = ex.Message; } finally { obj = null; } return(ds); }
public DataSet GetLayBundleData(int LayBatchNo, string StyleCode) { clsDB obj = new clsDB(); string errMsg = ""; DataSet ds = new DataSet(); Hashtable ht = new Hashtable(); try { ht.Add("@LayBatNo", LayBatchNo); ht.Add("@styleCode", StyleCode); ds = obj.GetData("sLayBundleData", ht); } catch (Exception ex) { errMsg = ex.Message; } finally { obj = null; } return(ds); }