/// <summary>
/// This will not be called directly from the page. and will act like a support function for Write multi Tables to generate new master number
/// </summary>
/// <param name="argsCode"></param>
/// <param name="argsType">Type value in M_NUMBERS</param>
/// <returns>New Transaction Number</returns>
/// <remarks></remarks>
public string GetNewMasterNumber(string argsCode, string argsType)
{
var objReadData = new DbReadEngine {
ConnectionString = ConnectionString
};
var ds = objReadData.ExecuteSprocDs("ezyadmin.Usp_Ezy_Common_GenNewMasterNumber",
new SqlParameter("@Pvc_Code", argsCode),
new SqlParameter("@Pvc_Type", argsType));
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
return(ds.Tables[0].Rows[0][0].ToString().Trim());
}
return(string.Empty);
}
/// <summary>
/// This will not be called directly from the page. and will act like a support function for Write multi Tables to generate new transaction number
/// </summary>
/// <param name="argsType">Type value in M_NUMBERS</param>
/// <param name="argsBno">BNo Value in M_NUMBERS</param>
/// <param name="argsBranch">Branch value in M_NUMBERS</param>
/// <param name="argsBu">Bu value in M_NUMBERS</param>
/// <param name="argsTd"></param>
/// <param name="argsJb"></param>
/// <returns>New Transaction Number</returns>
/// <remarks></remarks>
public string GetNewTrnNumber(string argsType, string argsTd, string argsBno, string argsBranch, string argsBu)
{
var objReadData = new DbReadEngine {
ConnectionString = ConnectionString
};
var ds = objReadData.ExecuteSprocDs("ezyadmin.Usp_Ezy_Common_GenNewTransNumber",
new SqlParameter("@Pvc_Type", argsType),
new SqlParameter("@Pvc_Td", argsTd),
new SqlParameter("@Pvc_Bno", argsBno),
new SqlParameter("@Pvc_Branch", argsBranch),
new SqlParameter("@Pvc_Bu", argsBu));
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
return(ds.Tables[0].Rows[0][0].ToString().Trim());
}
return(string.Empty);
}