string Numbering()
{
int GenGINNO;
DataTable dt = new DataTable();
dt = CommonClasses.Execute("SELECT max(SM_IWM_NO) as SM_IWM_NO from SCRAP_MASTER where SM_CM_CODE='" + Session["CompanyCode"] + "' and ES_DELETE=0");
if (dt.Rows[0]["SM_IWM_NO"] == null || dt.Rows[0]["SM_IWM_NO"].ToString() == "")
{
GenGINNO = 1;
}
else
{
GenGINNO = Convert.ToInt32(dt.Rows[0]["SM_IWM_NO"]) + 1;
}
return(GenGINNO.ToString());
}
string Numbering()
{
int GenGINNO;
DataTable dt = new DataTable();
dt = CommonClasses.Execute("select max(RCP_NO) as RCP_NO from RECIEPT_MASTER where RCP_CM_CODE='" + Session["CompanyCode"] + "' and ES_DELETE=0");
if (dt.Rows[0]["RCP_NO"] == null || dt.Rows[0]["RCP_NO"].ToString() == "")
{
GenGINNO = 1;
}
else
{
GenGINNO = Convert.ToInt32(dt.Rows[0]["RCP_NO"]) + 1;
}
return(GenGINNO.ToString());
}
string Numbering()
{
int GenGINNO;
DataTable dt = new DataTable();
dt = CommonClasses.Execute("select max(cast((isnull(PRM_NO,0)) as numeric(10,0))) as PRM_NO from PRUCHASE_REQUISITION_MASTER ");
if (dt.Rows[0]["PRM_NO"] == null || dt.Rows[0]["PRM_NO"].ToString() == "")
{
GenGINNO = 1;
}
else
{
GenGINNO = Convert.ToInt32(dt.Rows[0]["PRM_NO"]) + 1;
}
return(GenGINNO.ToString());
}
string Numbering()
{
int GenGINNO;
DataTable dt = new DataTable();
dt = CommonClasses.Execute("select max(WO_NO) as WO_NO from WORK_ORDER_MASTER ");
if (dt.Rows[0]["WO_NO"] == null || dt.Rows[0]["WO_NO"].ToString() == "")
{
GenGINNO = 1;
}
else
{
GenGINNO = Convert.ToInt32(dt.Rows[0]["WO_NO"]) + 1;
}
return(GenGINNO.ToString());
}
string Numbering()
{
int GenGINNO;
DataTable dt = new DataTable();
// dt = CommonClasses.Execute("select max(cast((isnull(PS_GIN_NO,0)) as numeric(10,0))) as PS_GIN_NO from PRODUCTION_TO_STORE_MASTER where PS_CM_COMP_CODE='" + Session["CompanyCode"] + "' ");
dt = CommonClasses.Execute("Select isnull(max(SAM_DOC_NO),0) as SAM_DOC_NO FROM STOCK_ADJUSTMENT_MASTER WHERE SAM_CM_COMP_CODE = " + (string)Session["CompanyCode"] + " and ES_DELETE=0");
if (dt.Rows[0]["SAM_DOC_NO"] == null || dt.Rows[0]["SAM_DOC_NO"].ToString() == "")
{
GenGINNO = 1;
}
else
{
GenGINNO = Convert.ToInt32(dt.Rows[0]["SAM_DOC_NO"]) + 1;
}
return(GenGINNO.ToString());
}
