private void Initialize(SqlDataReader reader, V_MaterialInventoryIOModel obj)
{
try
{
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "IOType")) != DBNull.Value)
{
obj.IOType = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "IOType"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "IOTypeName")) != DBNull.Value)
{
obj.IOTypeName = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "IOTypeName"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialCode")) != DBNull.Value)
{
obj.MaterialCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialCode"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialName")) != DBNull.Value)
{
obj.MaterialName = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialName"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Spec")) != DBNull.Value)
{
obj.Spec = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Spec"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Unit")) != DBNull.Value)
{
obj.Unit = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Unit"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "IODate")) != DBNull.Value)
{
obj.IODate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "IODate"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InQty")) != DBNull.Value)
{
obj.InQty = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InQty"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutQty")) != DBNull.Value)
{
obj.OutQty = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutQty"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialIODtlCode")) != DBNull.Value)
{
obj.MaterialIODtlCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialIODtlCode"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialIOCode")) != DBNull.Value)
{
obj.MaterialIOCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialIOCode"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialIOID")) != DBNull.Value)
{
obj.MaterialIOID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialIOID"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCode")) != DBNull.Value)
{
obj.ProjectCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCode"));
}
}
catch (Exception exception)
{
throw exception;
}
}
public LocaleViseCostDAL(SqlConnection Connection)
{
this._DataProcess = new SqlDataProcess(Connection);
}
public LocaleViseCostDAL(SqlTransaction Transaction)
{
this._DataProcess = new SqlDataProcess(Transaction);
}
public MaterialDAL(SqlTransaction Transaction)
{
this._DataProcess = new SqlDataProcess(Transaction);
}
public MaterialDAL(SqlConnection Connection)
{
this._DataProcess = new SqlDataProcess(Connection);
}
public DesignChangeDAL(SqlTransaction Transaction)
{
this._DataProcess = new SqlDataProcess(Transaction);
}
public DesignChangeDAL(SqlConnection Connection)
{
this._DataProcess = new SqlDataProcess(Connection);
}
private void Initialize(SqlDataReader reader, MaterialOutModel obj)
{
try
{
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialOutCode")) != DBNull.Value)
{
obj.MaterialOutCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialOutCode"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialOutID")) != DBNull.Value)
{
obj.MaterialOutID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialOutID"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCode")) != DBNull.Value)
{
obj.ProjectCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCode"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupCode")) != DBNull.Value)
{
obj.GroupCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupCode"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutDate")) != DBNull.Value)
{
obj.OutDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutDate"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutPerson")) != DBNull.Value)
{
obj.OutPerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutPerson"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Status")) != DBNull.Value)
{
obj.Status = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Status"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputPerson")) != DBNull.Value)
{
obj.InputPerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputPerson"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputDate")) != DBNull.Value)
{
obj.InputDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputDate"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckPerson")) != DBNull.Value)
{
obj.CheckPerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckPerson"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckDate")) != DBNull.Value)
{
obj.CheckDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckDate"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractCode")) != DBNull.Value)
{
obj.ContractCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractCode"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Remark")) != DBNull.Value)
{
obj.Remark = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Remark"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractID")) != DBNull.Value)
{
obj.ContractID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractID"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractName")) != DBNull.Value)
{
obj.ContractName = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractName"));
}
}
catch (Exception exception)
{
throw exception;
}
}
