private static MyEnums.SysSequence GetDimSequence(TableBase.TableEnum _dimTable)
{
MyEnums.SysSequence sequ = MyEnums.SysSequence.None;
switch (_dimTable)
{
case TableBase.TableEnum.Customer:
sequ = MyEnums.SysSequence.CUSTOMER_DIM_SEQU;
break;
case TableBase.TableEnum.MainAccount:
sequ = MyEnums.SysSequence.MAIN_ACCOUNT_DIM_SEQU;
break;
case TableBase.TableEnum.Vendor:
sequ = MyEnums.SysSequence.VENDOR_DIM_SEQU;
break;
case TableBase.TableEnum.Employee:
sequ = MyEnums.SysSequence.EMPLOYEE_DIM_SEQU;
break;
case TableBase.TableEnum.Department:
sequ = MyEnums.SysSequence.DEPARTMENT_DIM_SEQU;
break;
case TableBase.TableEnum.Location:
sequ = MyEnums.SysSequence.LOCATION_DIM_SEQU;
break;
case TableBase.TableEnum.Project:
sequ = MyEnums.SysSequence.PROJECT_DIM_SEQU;
break;
case TableBase.TableEnum.Purpose:
sequ = MyEnums.SysSequence.PURPOSE_DIM_SEQU;
break;
case TableBase.TableEnum.Equipment:
sequ = MyEnums.SysSequence.EQUIPMENT_DIM_SEQU;
break;
case TableBase.TableEnum.FixedAsset:
sequ = MyEnums.SysSequence.FIXED_ASSET_DIM_SEQU;
break;
case TableBase.TableEnum.Item:
sequ = MyEnums.SysSequence.INVENTORY_DIM_SEQU;
break;
;
}
return(sequ);
}
public static long NextVal(Session unitOfWork, MyEnums.SysSequence sysSequenceName, long startWith = 0)
{
long returnIndex = 0;
var sequIdParm = new DevExpress.Xpo.DB.SprocParameter("@SequenceId", sysSequenceName);
var sequNameParm = new DevExpress.Xpo.DB.SprocParameter("@SequenceName", Enum.GetName(typeof(MyEnums.SysSequence), sysSequenceName));
var startWithParm = new DevExpress.Xpo.DB.SprocParameter("@StartWith", startWith);
var outputParm = new DevExpress.Xpo.DB.SprocParameter()
{
ParameterName = "@NewID",
Direction = DevExpress.Xpo.DB.SprocParameterDirection.Output,
DbType = DevExpress.Xpo.DB.DBColumnType.Int32
};
var data = unitOfWork.ExecuteSprocParametrized(SP_NEXT_TASK_LINE, sequIdParm, sequNameParm, startWithParm, outputParm);
SelectStatementResultRow row = data.ResultSet[1].Rows[0];
returnIndex = (int)row.Values[1];// data.ResultSet[1].Rows[1].Values[1];
return(returnIndex);
}
