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;
     }
 }
Beispiel #2
0
 public LocaleViseCostDAL(SqlConnection Connection)
 {
     this._DataProcess = new SqlDataProcess(Connection);
 }
Beispiel #3
0
 public LocaleViseCostDAL(SqlTransaction Transaction)
 {
     this._DataProcess = new SqlDataProcess(Transaction);
 }
Beispiel #4
0
 public MaterialDAL(SqlTransaction Transaction)
 {
     this._DataProcess = new SqlDataProcess(Transaction);
 }
Beispiel #5
0
 public MaterialDAL(SqlConnection Connection)
 {
     this._DataProcess = new SqlDataProcess(Connection);
 }
Beispiel #6
0
 public DesignChangeDAL(SqlTransaction Transaction)
 {
     this._DataProcess = new SqlDataProcess(Transaction);
 }
Beispiel #7
0
 public DesignChangeDAL(SqlConnection Connection)
 {
     this._DataProcess = new SqlDataProcess(Connection);
 }
Beispiel #8
0
 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;
     }
 }