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