protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
OTHER_TRAVELLER_DETAIL theEntity = (OTHER_TRAVELLER_DETAIL)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.MOVEMENT_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_MOVEMENT_ID", theEntity.MOVEMENT_ID));
}
if (!string.IsNullOrEmpty(theEntity.SNO))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_SNO", theEntity.SNO));
}
if (!string.IsNullOrEmpty(theEntity.PERSON))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PERSON", theEntity.PERSON));
}
if (!string.IsNullOrEmpty(theEntity.RELATION))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RELATION", theEntity.RELATION));
}
if (!string.IsNullOrEmpty(theEntity.GOODS_CARRIED))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_GOODS_CARRIED", theEntity.GOODS_CARRIED));
}
if (!string.IsNullOrEmpty(theEntity.QTY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_QTY", theEntity.QTY));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
GOOD_TRANSPORTATION_DETAIL theEntity = (GOOD_TRANSPORTATION_DETAIL)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.GOOD_TRANSPORT_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_GOOD_TRANSPORT_ID", theEntity.GOOD_TRANSPORT_ID));
}
if (!string.IsNullOrEmpty(theEntity.SNO))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_SNO", theEntity.SNO));
}
if (!string.IsNullOrEmpty(theEntity.PARTICULAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PARTICULAR", theEntity.PARTICULAR));
}
if (!string.IsNullOrEmpty(theEntity.UNIT))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_UNIT", theEntity.UNIT));
}
if (!string.IsNullOrEmpty(theEntity.QTY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_QTY", theEntity.QTY));
}
if (!string.IsNullOrEmpty(theEntity.REMARKS))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_REMARKS", theEntity.REMARKS));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
DISTRICT theEntity = (DISTRICT)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.DISTRICT_NAME))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DISTRICT_NAME", theEntity.DISTRICT_NAME));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
BASE_STATION theEntity = (BASE_STATION)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.BASESTATION))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_BASE_STATION", theEntity.BASESTATION));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
GetCalendar theEntity = (GetCalendar)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.MONTH))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("C_MONTH", theEntity.MONTH));
}
if (!string.IsNullOrEmpty(theEntity.YEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("C_YEAR", theEntity.YEAR));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
VEHICLE_USER theEntity = (VEHICLE_USER)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.VEHICLEUSER))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_VEHICLE_USER", theEntity.VEHICLEUSER));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
VEHICHLE_TAX theEntity = (VEHICHLE_TAX)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.VECHICLE_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_VECHICLE_ID", theEntity.VECHICLE_ID));
}
if (!string.IsNullOrEmpty(theEntity.RECEIPT_NO))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIPT_NO", theEntity.RECEIPT_NO));
}
if (!string.IsNullOrEmpty(theEntity.RECEIPT_DAY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIPT_DAY", theEntity.RECEIPT_DAY));
}
if (!string.IsNullOrEmpty(theEntity.RECEIPT_MONTH))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIPT_MONTH", theEntity.RECEIPT_MONTH));
}
if (!string.IsNullOrEmpty(theEntity.RECEIPT_YEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIPT_YEAR", theEntity.RECEIPT_YEAR));
}
if (!string.IsNullOrEmpty(theEntity.AMOUNT))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_AMOUNT", theEntity.AMOUNT));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
ACCESSORIES_GROUP theEntity = (ACCESSORIES_GROUP)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.ACCESSORIESGROUP))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ACCESSORIES_GROUP", theEntity.ACCESSORIESGROUP));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateInsertParameters(EntityBase anEntity)
{
PasswordReset theEntity = (PasswordReset)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "i"));
if (!string.IsNullOrEmpty(theEntity.EMPLOYEE_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("var_EMPLOYEE_ID", theEntity.EMPLOYEE_ID));
}
if (!string.IsNullOrEmpty(theEntity.CONFIRMATION_CODE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("var_CONFIRMATION_CODE", theEntity.CONFIRMATION_CODE));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateDeleteParameters(EntityBase anEntity)
{
TRAVEL_DESCRIPTION theEntity = (TRAVEL_DESCRIPTION)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "d"));
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.MOVEMENT_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_MOVEMENT_ID", theEntity.MOVEMENT_ID));
}
if (!string.IsNullOrEmpty(theEntity.TRAVEL_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_TRAVEL_DATE", theEntity.TRAVEL_DATE));
}
if (!string.IsNullOrEmpty(theEntity.TRAVEL_TIME))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_TRAVEL_TIME", theEntity.TRAVEL_TIME));
}
if (!string.IsNullOrEmpty(theEntity.PLACE_FROM))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PLACE_FROM", theEntity.PLACE_FROM));
}
if (!string.IsNullOrEmpty(theEntity.PLACE_TO))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PLACE_TO", theEntity.PLACE_TO));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateDeleteParameters(EntityBase anEntity)
{
UNIT theEntity = (UNIT)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "d"));
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.UNIT_NAME))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_UNIT_NAME", theEntity.UNIT_NAME));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateUpdateParameters(EntityBase anEntity)
{
MODEL_YEAR theEntity = (MODEL_YEAR)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "u"));
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.MODELYEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_MODEL_YEAR", theEntity.MODELYEAR));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateUpdateParameters(EntityBase anEntity)
{
VEHICLE_CATEGORY theEntity = (VEHICLE_CATEGORY)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "u"));
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.VEHICLECATEGORY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_VEHICLE_CATEGORY", theEntity.VEHICLECATEGORY));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateInsertParameters(EntityBase anEntity)
{
FUEL_TYPE theEntity = (FUEL_TYPE)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "i"));
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.FUELTYPE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_FUEL_TYPE", theEntity.FUELTYPE));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
USERGROUP theEntity = (USERGROUP)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.USERGROUPID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("userGROUP_ID", theEntity.USERGROUPID));
}
if (!string.IsNullOrEmpty(theEntity.USERID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("user_id", theEntity.USERID));
}
if (!string.IsNullOrEmpty(theEntity.GROUPID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("group_ID", theEntity.GROUPID));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected IDbDataParameter[] CreateSelectModuleParameters(EntityBase anEntity, string CurrentM_ID)
{
UserProfileEntity theEntity = (UserProfileEntity)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.UserGroupID.ToString()))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("group_id", theEntity.UserGroupID));
}
if (!string.IsNullOrEmpty(theEntity.UserGroupID.ToString()))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("Module_ID", CurrentM_ID));
}
// This is the output parameter that is required for Oracle Connection.
// This is required only when the database is oracle as it will return curson.
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
SubModules theEntity = (SubModules)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.SUBMODULE_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("SUBMODULE_ID", theEntity.SUBMODULE_ID));
}
if (!string.IsNullOrEmpty(theEntity.SUBMODULE_NAME))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("SUBMODULE_NAME", theEntity.SUBMODULE_NAME));
}
if (!string.IsNullOrEmpty(theEntity.MODULE_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("MODULE_ID", theEntity.MODULE_ID));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected IDbDataParameter[] CreateSelectLinkParameters(EntityBase anEntity, string Group_ID)
{
ModuleSubmoduleEntity theEntity = (ModuleSubmoduleEntity)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.Submoduleid.ToString()))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("v_submoduleid", theEntity.Submoduleid));
}
if (!string.IsNullOrEmpty(theEntity.Submoduleid.ToString()))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("Group_ID", Group_ID));
}
// This is the output parameter that is required for Oracle Connection.
// This is required only when the database is oracle as it will return curson.
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
fiscalyear theEntity = (fiscalyear)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.FISCAL_YEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("FISCAL_YEAR", theEntity.FISCAL_YEAR));
}
if (!string.IsNullOrEmpty(theEntity.START_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("START_DATE", theEntity.START_DATE));
}
if (!string.IsNullOrEmpty(theEntity.END_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("END_DATE", theEntity.END_DATE));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateDeleteParameters(EntityBase anEntity)
{
PRODUCT_TYPE theEntity = (PRODUCT_TYPE)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "d"));
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCT_CATEGORY_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_CATEGORY_ID", theEntity.PRODUCT_CATEGORY_ID));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCTTYPE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_TYPE", theEntity.PRODUCTTYPE));
}
if (!string.IsNullOrEmpty(theEntity.REMARKS))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_REMARKS", theEntity.REMARKS));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCT_TYPE_CODE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_TYPE_CODE", theEntity.PRODUCT_TYPE_CODE));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateDeleteParameters(EntityBase anEntity)
{
SCRAP_RETURN_DETAIL theEntity = (SCRAP_RETURN_DETAIL)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "d"));
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.SCRAP_RETURN_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_SCRAP_RETURN_ID", theEntity.SCRAP_RETURN_ID));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCT_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_ID", theEntity.PRODUCT_ID));
}
if (!string.IsNullOrEmpty(theEntity.STORE_AT))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_STORE_AT", theEntity.STORE_AT));
}
if (!string.IsNullOrEmpty(theEntity.REMARKS))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_REMARKS", theEntity.REMARKS));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateDeleteParameters(EntityBase anEntity)
{
GOOD_TRANSPORTATION theEntity = (GOOD_TRANSPORTATION)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "d"));
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.MOVEMENT_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_MOVEMENT_ID", theEntity.MOVEMENT_ID));
}
if (!string.IsNullOrEmpty(theEntity.ORDER_OFFICE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ORDER_OFFICE", theEntity.ORDER_OFFICE));
}
if (!string.IsNullOrEmpty(theEntity.ORDER_BY_HEAD))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ORDER_BY_HEAD", theEntity.ORDER_BY_HEAD));
}
if (!string.IsNullOrEmpty(theEntity.ORDER_BY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ORDER_BY", theEntity.ORDER_BY));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateInsertParameters(EntityBase anEntity)
{
Pages theEntity = (Pages)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("p_transmode", "i"));
if (!string.IsNullOrEmpty(theEntity.ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("p_id", theEntity.ID));
}
if (!string.IsNullOrEmpty(theEntity.LINKNAME))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("p_linkname", theEntity.LINKNAME));
}
if (!string.IsNullOrEmpty(theEntity.PAGENAME))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("p_pagename", theEntity.PAGENAME));
}
if (!string.IsNullOrEmpty(theEntity.SUBMODULEID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("p_submoduleid", theEntity.SUBMODULEID));
}
if (!string.IsNullOrEmpty(theEntity.BREADCRUMBS))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("p_BREADCRUMBS", theEntity.BREADCRUMBS));
}
if (!string.IsNullOrEmpty(theEntity.SHOWINMODULE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("p_showinmodule", theEntity.SHOWINMODULE));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
M_LABOR_TYPE theEntity = (M_LABOR_TYPE)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.LABOUR_MASTER))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_LABOUR_MASTER", theEntity.LABOUR_MASTER));
}
if (!string.IsNullOrEmpty(theEntity.PARENT))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PARENT", theEntity.PARENT));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
POST_OPERATION_LIST theEntity = (POST_OPERATION_LIST)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.VEHICLE_DISPATCH_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_VEHICLE_DISPATCH_ID", theEntity.VEHICLE_DISPATCH_ID));
}
if (!string.IsNullOrEmpty(theEntity.POST_OPERATIONLIST))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_POST_OPERATION_LIST", theEntity.POST_OPERATIONLIST));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
OFFICE theEntity = (OFFICE)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.OFFICECODE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_OFFICECODE", theEntity.OFFICECODE));
}
if (!string.IsNullOrEmpty(theEntity.OFFICENAME))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_OFFICENAME", theEntity.OFFICENAME));
}
if (!string.IsNullOrEmpty(theEntity.WARDNO))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_WARDNO", theEntity.WARDNO));
}
if (!string.IsNullOrEmpty(theEntity.STREET))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_STREET", theEntity.STREET));
}
if (!string.IsNullOrEmpty(theEntity.VDCMUNICIPALITY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_VDCMUNICIPALITY", theEntity.VDCMUNICIPALITY));
}
if (!string.IsNullOrEmpty(theEntity.OFFICETYPEID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_OFFICETYPEID", theEntity.OFFICETYPEID));
}
if (!string.IsNullOrEmpty(theEntity.WORKSASDEPOT))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_WORKSASDEPOT", theEntity.WORKSASDEPOT));
}
if (!string.IsNullOrEmpty(theEntity.REGIONID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_REGIONID", theEntity.REGIONID));
}
if (!string.IsNullOrEmpty(theEntity.CONTACT_PERSON))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_CONTACT_PERSON", theEntity.CONTACT_PERSON));
}
if (!string.IsNullOrEmpty(theEntity.PHONE_NO))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PHONE_NO", theEntity.PHONE_NO));
}
if (!string.IsNullOrEmpty(theEntity.MOBILE_NO))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_MOBILE_NO", theEntity.MOBILE_NO));
}
if (!string.IsNullOrEmpty(theEntity.EMAIL))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_EMAIL", theEntity.EMAIL));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateDeleteParameters(EntityBase anEntity)
{
VEHICLE_ISSUE theEntity = (VEHICLE_ISSUE)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "d"));
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.VEHICLE_ISSUE_CODE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_VEHICLE_ISSUE_CODE", theEntity.VEHICLE_ISSUE_CODE));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_DAY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_DAY", theEntity.ISSUE_DAY));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_MONTH))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_MONTH", theEntity.ISSUE_MONTH));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_YEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_YEAR", theEntity.ISSUE_YEAR));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_DATE", theEntity.ISSUE_DATE));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_FISCAL_YEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_FISCAL_YEAR", theEntity.ISSUE_FISCAL_YEAR));
}
if (!string.IsNullOrEmpty(theEntity.VEHICLE_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_VEHICLE_ID", theEntity.VEHICLE_ID));
}
if (!string.IsNullOrEmpty(theEntity.ODOMETER))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ODOMETER", theEntity.ODOMETER));
}
if (!string.IsNullOrEmpty(theEntity.DAMAGE_DESCRIPTION))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DAMAGE_DESCRIPTION", theEntity.DAMAGE_DESCRIPTION));
}
if (!string.IsNullOrEmpty(theEntity.ISSUER_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUER_ID", theEntity.ISSUER_ID));
}
if (!string.IsNullOrEmpty(theEntity.ENTRY_DAY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ENTRY_DAY", theEntity.ENTRY_DAY));
}
if (!string.IsNullOrEmpty(theEntity.ENTRY_MONTH))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ENTRY_MONTH", theEntity.ENTRY_MONTH));
}
if (!string.IsNullOrEmpty(theEntity.ENTRY_YEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ENTRY_YEAR", theEntity.ENTRY_YEAR));
}
if (!string.IsNullOrEmpty(theEntity.ENTRY_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ENTRY_DATE", theEntity.ENTRY_DATE));
}
if (!string.IsNullOrEmpty(theEntity.RECEIVER_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIVER_ID", theEntity.RECEIVER_ID));
}
if (!string.IsNullOrEmpty(theEntity.RECEIVE_DAY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIVE_DAY", theEntity.RECEIVE_DAY));
}
if (!string.IsNullOrEmpty(theEntity.RECEIVE_MONTH))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIVE_MONTH", theEntity.RECEIVE_MONTH));
}
if (!string.IsNullOrEmpty(theEntity.RECEIVE_YEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIVE_YEAR", theEntity.RECEIVE_YEAR));
}
if (!string.IsNullOrEmpty(theEntity.RECEIVER_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIVER_DATE", theEntity.RECEIVER_DATE));
}
if (!string.IsNullOrEmpty(theEntity.VEHICLE_CHECK_BY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_VEHICLE_CHECK_BY", theEntity.VEHICLE_CHECK_BY));
}
if (!string.IsNullOrEmpty(theEntity.RECEIVER_ID_COPY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIVER_ID_COPY", theEntity.RECEIVER_ID_COPY));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
PRODUCT theEntity = (PRODUCT)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCT_TYPE_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_TYPE_ID", theEntity.PRODUCT_TYPE_ID));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCT_CODE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_CODE", theEntity.PRODUCT_CODE));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCT_NAME))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_NAME", theEntity.PRODUCT_NAME));
}
if (!string.IsNullOrEmpty(theEntity.NATURE_CATEGORY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_NATURE_CATEGORY", theEntity.NATURE_CATEGORY));
}
if (!string.IsNullOrEmpty(theEntity.PRICE_CATEGORY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRICE_CATEGORY", theEntity.PRICE_CATEGORY));
}
if (!string.IsNullOrEmpty(theEntity.UNIT))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_UNIT", theEntity.UNIT));
}
if (!string.IsNullOrEmpty(theEntity.REORDER_LEVEL))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_REORDER_LEVEL", theEntity.REORDER_LEVEL));
}
if (!string.IsNullOrEmpty(theEntity.MAXIMUM_QTY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_MAXIMUM_QTY", theEntity.MAXIMUM_QTY));
}
if (!string.IsNullOrEmpty(theEntity.STORAGE_DETAIL))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_STORAGE_DETAIL", theEntity.STORAGE_DETAIL));
}
if (!string.IsNullOrEmpty(theEntity.FORMAT))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_FORMAT", theEntity.FORMAT));
}
if (!string.IsNullOrEmpty(theEntity.SPECIFICATION))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_SPECIFICATION", theEntity.SPECIFICATION));
}
if (!string.IsNullOrEmpty(theEntity.STATUS))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_STATUS", theEntity.STATUS));
}
if (!string.IsNullOrEmpty(theEntity.BUDGET_CODE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_BUDGET_CODE", theEntity.BUDGET_CODE));
}
if (!string.IsNullOrEmpty(theEntity.CLASSIFICATION_CODE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_CLASSIFICATION_CODE", theEntity.CLASSIFICATION_CODE));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateDeleteParameters(EntityBase anEntity)
{
PRODUCT_ISSUE theEntity = (PRODUCT_ISSUE)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
cmdParams.Add(DataAccessFactory.CreateDataParameter("transmode", "d"));
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_NO))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_NO", theEntity.ISSUE_NO));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_DAY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_DAY", theEntity.ISSUE_DAY));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_MONTH))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_MONTH", theEntity.ISSUE_MONTH));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_YEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_YEAR", theEntity.ISSUE_YEAR));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_DATE", theEntity.ISSUE_DATE));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_FISCALYEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_FISCALYEAR", theEntity.ISSUE_FISCALYEAR));
}
if (!string.IsNullOrEmpty(theEntity.INTERNAL_EXTERNAL))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_INTERNAL_EXTERNAL", theEntity.INTERNAL_EXTERNAL));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_TO_OFFICE_NAME))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_TO_OFFICE_NAME", theEntity.ISSUE_TO_OFFICE_NAME));
}
if (!string.IsNullOrEmpty(theEntity.DECISION_DAY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DECISION_DAY", theEntity.DECISION_DAY));
}
if (!string.IsNullOrEmpty(theEntity.DECISION_MONTH))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DECISION_MONTH", theEntity.DECISION_MONTH));
}
if (!string.IsNullOrEmpty(theEntity.DECISION_YEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DECISION_YEAR", theEntity.DECISION_YEAR));
}
if (!string.IsNullOrEmpty(theEntity.DECISION_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DECISION_DATE", theEntity.DECISION_DATE));
}
if (!string.IsNullOrEmpty(theEntity.DELIVERY_OFFICE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DELIVERY_OFFICE", theEntity.DELIVERY_OFFICE));
}
if (!string.IsNullOrEmpty(theEntity.DELIVERY_BY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DELIVERY_BY", theEntity.DELIVERY_BY));
}
if (!string.IsNullOrEmpty(theEntity.DELIVERY_DESIGNATION))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DELIVERY_DESIGNATION", theEntity.DELIVERY_DESIGNATION));
}
if (!string.IsNullOrEmpty(theEntity.DELIVERY_REC_THROUGH))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DELIVERY_REC_THROUGH", theEntity.DELIVERY_REC_THROUGH));
}
if (!string.IsNullOrEmpty(theEntity.RECEIVED_BY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIVED_BY", theEntity.RECEIVED_BY));
}
if (!string.IsNullOrEmpty(theEntity.RECEIVED_BY_DESIGNATION))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIVED_BY_DESIGNATION", theEntity.RECEIVED_BY_DESIGNATION));
}
if (!string.IsNullOrEmpty(theEntity.RECEIVED_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_RECEIVED_DATE", theEntity.RECEIVED_DATE));
}
if (!string.IsNullOrEmpty(theEntity.PRODUCT_DEMAND_NO))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PRODUCT_DEMAND_NO", theEntity.PRODUCT_DEMAND_NO));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("errmsg", ""));
return(cmdParams.ToArray());
}
protected override IDbDataParameter[] CreateSelectParameters(EntityBase anEntity)
{
PURCHASE_ORDER theEntity = (PURCHASE_ORDER)anEntity;
List <IDbDataParameter> cmdParams = new List <IDbDataParameter>();
if (!string.IsNullOrEmpty(theEntity.PK_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PK_ID", theEntity.PK_ID));
}
if (!string.IsNullOrEmpty(theEntity.PURCHASE_ORDER_NUMBER))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_PURCHASE_ORDER_NUMBER", theEntity.PURCHASE_ORDER_NUMBER));
}
if (!string.IsNullOrEmpty(theEntity.ORDER_DAY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ORDER_DAY", theEntity.ORDER_DAY));
}
if (!string.IsNullOrEmpty(theEntity.ORDER_MONTH))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ORDER_MONTH", theEntity.ORDER_MONTH));
}
if (!string.IsNullOrEmpty(theEntity.ORDER_YEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ORDER_YEAR", theEntity.ORDER_YEAR));
}
if (!string.IsNullOrEmpty(theEntity.ORDER_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ORDER_DATE", theEntity.ORDER_DATE));
}
if (!string.IsNullOrEmpty(theEntity.ORDER_FISCALYEAR))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ORDER_FISCALYEAR", theEntity.ORDER_FISCALYEAR));
}
if (!string.IsNullOrEmpty(theEntity.SUPPLIER_ID))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_SUPPLIER_ID", theEntity.SUPPLIER_ID));
}
if (!string.IsNullOrEmpty(theEntity.DELIVERY_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DELIVERY_DATE", theEntity.DELIVERY_DATE));
}
if (!string.IsNullOrEmpty(theEntity.DELIVERY_PLACE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DELIVERY_PLACE", theEntity.DELIVERY_PLACE));
}
if (!string.IsNullOrEmpty(theEntity.ISSUE_BY))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_ISSUE_BY", theEntity.ISSUE_BY));
}
if (!string.IsNullOrEmpty(theEntity.DEPARTMENT_HEAD))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_DEPARTMENT_HEAD", theEntity.DEPARTMENT_HEAD));
}
if (!string.IsNullOrEmpty(theEntity.GRAND_TOTAL))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_GRAND_TOTAL", theEntity.GRAND_TOTAL));
}
if (!string.IsNullOrEmpty(theEntity.SUPPLIER_REPRESENTATIVE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_SUPPLIER_REPRESENTATIVE", theEntity.SUPPLIER_REPRESENTATIVE));
}
if (!string.IsNullOrEmpty(theEntity.SUPPLY_RECEIVE_DATE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_SUPPLY_RECEIVE_DATE", theEntity.SUPPLY_RECEIVE_DATE));
}
if (!string.IsNullOrEmpty(theEntity.OFFICE_CODE))
{
cmdParams.Add(DataAccessFactory.CreateDataParameter("VAR_OFFICE_CODE", theEntity.OFFICE_CODE));
}
cmdParams.Add(DataAccessFactory.CreateDataParameter("Result", ""));
return(cmdParams.ToArray());
}