private void Initialize(SqlDataReader reader, ProjectCostModel obj) { try { if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCostCode")) != DBNull.Value) { obj.ProjectCostCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCostCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectName")) != DBNull.Value) { obj.ProjectName = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectName")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupCode")) != DBNull.Value) { obj.GroupCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Area")) != DBNull.Value) { obj.Area = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Area")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Price")) != DBNull.Value) { obj.Price = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Price")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Money")) != DBNull.Value) { obj.Money = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Money")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Qty")) != DBNull.Value) { obj.Qty = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Qty")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Unit")) != DBNull.Value) { obj.Unit = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Unit")); } 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, "Remark")) != DBNull.Value) { obj.Remark = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Remark")); } } catch (Exception exception) { throw exception; } }
private void Initialize(SqlDataReader reader, MaterialInModel obj) { if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInCode")) != DBNull.Value) { obj.MaterialInCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInID")) != DBNull.Value) { obj.MaterialInID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInID")); } 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, "InDate")) != DBNull.Value) { obj.InDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InDate")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InPerson")) != DBNull.Value) { obj.InPerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InPerson")); } 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")); } }
private void Initialize(SqlDataReader reader, MaterialOutDtlModel obj) { try { if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialOutDtlCode")) != DBNull.Value) { obj.MaterialOutDtlCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialOutDtlCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialOutCode")) != DBNull.Value) { obj.MaterialOutCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialOutCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialCode")) != DBNull.Value) { obj.MaterialCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInDtlCode")) != DBNull.Value) { obj.MaterialInDtlCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInDtlCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutQty")) != DBNull.Value) { obj.OutQty = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutQty")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutPrice")) != DBNull.Value) { obj.OutPrice = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutPrice")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutMoney")) != DBNull.Value) { obj.OutMoney = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutMoney")); } 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, "GroupCode")) != DBNull.Value) { obj.GroupCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupName")) != DBNull.Value) { obj.GroupName = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupName")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupFullID")) != DBNull.Value) { obj.GroupFullID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupFullID")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupSortID")) != DBNull.Value) { obj.GroupSortID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupSortID")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialOutID")) != DBNull.Value) { obj.MaterialOutID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialOutID")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutDate")) != DBNull.Value) { obj.OutDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutDate")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractCode")) != DBNull.Value) { obj.ContractCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInCode")) != DBNull.Value) { obj.MaterialInCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInID")) != DBNull.Value) { obj.MaterialInID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInID")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InDate")) != DBNull.Value) { obj.InDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InDate")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InContractCode")) != DBNull.Value) { obj.InContractCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InContractCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InPrice")) != DBNull.Value) { obj.InPrice = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InPrice")); } } catch (Exception exception) { throw exception; } }
private void Initialize(SqlDataReader reader, V_MaterialInventoryModel obj) { try { if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCode")) != DBNull.Value) { obj.ProjectCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectName")) != DBNull.Value) { obj.ProjectName = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectName")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialCode")) != DBNull.Value) { obj.MaterialCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InQty")) != DBNull.Value) { obj.InQty = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InQty")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InMoney")) != DBNull.Value) { obj.InMoney = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InMoney")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutQty")) != DBNull.Value) { obj.OutQty = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "OutQty")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InvQty")) != DBNull.Value) { obj.InvQty = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InvQty")); } 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, "StandardPrice")) != DBNull.Value) { obj.StandardPrice = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "StandardPrice")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupCode")) != DBNull.Value) { obj.GroupCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupName")) != DBNull.Value) { obj.GroupName = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupName")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupFullID")) != DBNull.Value) { obj.GroupFullID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupFullID")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupSortID")) != DBNull.Value) { obj.GroupSortID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupSortID")); } } catch (Exception exception) { throw exception; } }
private void Initialize(SqlDataReader reader, LocaleViseModel obj) { try { if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseCode")) != DBNull.Value) { obj.ViseCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseId")) != DBNull.Value) { obj.ViseId = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseId")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseName")) != DBNull.Value) { obj.ViseName = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseName")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseDate")) != DBNull.Value) { obj.ViseDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseDate")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseType")) != DBNull.Value) { obj.ViseType = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseType")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "VisePerson")) != DBNull.Value) { obj.VisePerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "VisePerson")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseSupplier")) != DBNull.Value) { obj.ViseSupplier = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseSupplier")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseUnit")) != DBNull.Value) { obj.ViseUnit = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseUnit")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseEndDate")) != DBNull.Value) { obj.ViseEndDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseEndDate")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseRemark")) != DBNull.Value) { obj.ViseRemark = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseRemark")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseScrutiny")) != DBNull.Value) { obj.ViseScrutiny = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseScrutiny")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReason")) != DBNull.Value) { obj.ViseReason = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReason")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseStatus")) != DBNull.Value) { obj.ViseStatus = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseStatus")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseBalanceStatus")) != DBNull.Value) { obj.ViseBalanceStatus = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseBalanceStatus")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseProject")) != DBNull.Value) { obj.ViseProject = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseProject")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseContractCode")) != DBNull.Value) { obj.ViseContractCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseContractCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReasonItem")) != DBNull.Value) { obj.ViseReasonItem = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReasonItem")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseComeToMoney")) != DBNull.Value) { obj.ViseComeToMoney = reader.GetDecimal(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseComeToMoney")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseID2")) != DBNull.Value) { obj.ViseID2 = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseID2")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReferCode")) != DBNull.Value) { obj.ViseReferCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ViseReferCode")); } } catch (Exception exception) { throw exception; } }
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; } }