private CheckInfo GetModelFromDataReader(SqlDataReader dr) { CheckInfo model = new CheckInfo(); model.ID = dr["ID"].ToInt32(); model.CheckNo = dr["CheckNo"].ToDBString(); model.CheckType = dr["CheckType"].ToInt32(); model.DutyUser = dr["DutyUser"].ToDBString(); model.CheckDesc = dr["CheckDesc"].ToDBString(); model.CheckStatus = dr["CheckStatus"].ToInt32(); model.BeginTime = dr["BeginTime"].ToDateTimeNull(); model.DoneTime = dr["DoneTime"].ToDateTimeNull(); model.Remarks = dr["Remarks"].ToDBString(); model.IsDel = dr["ISDEL"].ToInt32(); model.Creater = dr["CREATER"].ToDBString(); model.CreateTime = dr["CREATETIME"].ToDateTime(); model.Modifyer = dr["MODIFYER"].ToDBString(); model.ModifyTime = dr["MODIFYTIME"].ToDateTimeNull(); if (Common_Func.readerExists(dr, "StrCheckType")) { model.StrCheckType = dr["StrCheckType"].ToDBString(); } if (Common_Func.readerExists(dr, "StrCheckStatus")) { model.StrCheckStatus = dr["StrCheckStatus"].ToDBString(); } model.EditText = model.CheckStatus == 1 ? "编辑" : "查看"; return(model); }
internal AppVersionInfo GetModelFromDataReader(IDataReader dr) { AppVersionInfo model = new AppVersionInfo(); model.ID = dr["ID"].ToInt32(); model.AppName = dr["AppName"].ToDBString(); model.AppVersion = dr["AppVersion"].ToDBString(); model.VersionType = dr["VersionType"].ToInt32(); model.VersionLevel = dr["VersionLevel"].ToInt32(); model.VersionTitle = dr["VersionTitle"].ToDBString(); model.VersionDesc = dr["VersionDesc"].ToDBString(); model.Creater = dr["Creater"].ToDBString(); model.CreateTime = dr["CreateTime"].ToDateTime(); if (Common_Func.readerExists(dr, "StrVersionType")) { model.StrVersionType = dr["StrVersionType"].ToDBString(); } if (Common_Func.readerExists(dr, "StrVersionLevel")) { model.StrVersionLevel = dr["StrVersionLevel"].ToDBString(); } return(model); }
private UserGroupInfo GetModelFromDataReader(SqlDataReader dr) { UserGroupInfo model = new UserGroupInfo(); model.ID = dr["ID"].ToInt32(); model.UserGroupNo = dr["UserGroupNo"].ToDBString(); model.UserGroupName = dr["UserGroupName"].ToDBString(); model.UserGroupAbbName = dr["UserGroupAbbName"].ToDBString(); model.UserGroupType = dr["UserGroupType"].ToInt32(); model.UserGroupStatus = dr["UserGroupStatus"].ToInt32(); model.Description = dr["Description"].ToDBString(); model.IsDel = dr["ISDEL"].ToInt32(); model.Creater = dr["CREATER"].ToDBString(); model.CreateTime = dr["CREATETIME"].ToDateTime(); model.Modifyer = dr["MODIFYER"].ToDBString(); model.ModifyTime = dr["MODIFYTIME"].ToDateTimeNull(); if (Common_Func.readerExists(dr, "IsChecked")) { model.BIsChecked = dr["IsChecked"].ToBoolean(); } if (Common_Func.readerExists(dr, "StrUserGroupType")) { model.StrUserGroupType = dr["StrUserGroupType"].ToDBString(); } if (Common_Func.readerExists(dr, "StrUserGroupStatus")) { model.StrUserGroupStatus = dr["StrUserGroupStatus"].ToDBString(); } return(model); }
private TempMaterialInfo GetModelFromDataReader(SqlDataReader dr) { TempMaterialInfo model = new TempMaterialInfo(); model.ID = dr["ID"].ToInt32(); model.TempMaterialNo = dr["TempMaterialNo"].ToDBString(); model.TempMaterialDesc = dr["TempMaterialDesc"].ToDBString(); model.MaterialNo = dr["MaterialNo"].ToDBString(); model.MaterialDesc = dr["MaterialDesc"].ToDBString(); model.SapMaterialDoc = dr["SapMaterialDoc"].ToDBString(); model.ReplaceUser = dr["ReplaceUser"].ToDBString(); model.ReplaceTime = dr["ReplaceTime"].ToDateTimeNull(); model.TempMaterialStatus = dr["TempMaterialStatus"].ToInt32(); model.IsDel = dr["ISDEL"].ToInt32(); model.Creater = dr["CREATER"].ToDBString(); model.CreateTime = dr["CREATETIME"].ToDateTime(); model.Modifyer = dr["MODIFYER"].ToDBString(); model.ModifyTime = dr["MODIFYTIME"].ToDateTimeNull(); if (Common_Func.readerExists(dr, "StrTempMaterialStatus")) { model.StrTempMaterialStatus = dr["StrTempMaterialStatus"].ToDBString(); } model.Unit = string.Empty; model.IsRohs = 2; return(model); }
private OverViewInfo GetModelFromDataReader(SqlDataReader dr) { OverViewInfo model = new OverViewInfo(); model.ID = dr["ID"].ToInt32(); model.TaskNo = dr["TaskNo"].ToDBString(); model.VoucherType = dr["VoucherType"].ToInt32(); model.TaskType = dr["TaskType"].ToInt32(); model.SupcusNo = dr["SupcusNo"].ToDBString(); model.SupcusName = dr["SupcusName"].ToDBString(); model.TaskStatus = dr["TaskStatus"].ToInt32(); model.AuditUserNo = dr["AuditUserNo"].ToDBString(); model.AuditDateTime = dr["AuditDateTime"].ToDateTimeNull(); model.TaskIssued = dr["TaskIssued"].ToDateTimeNull(); model.ReceiveUserNo = dr["ReceiveUserNo"].ToDBString(); model.CreateDateTime = dr["CreateDateTime"].ToDateTimeNull(); model.Remark = dr["Remark"].ToDBString(); model.Reason = dr["Reason"].ToDBString(); model.CreateUserNo = dr["CreateUserNo"].ToDBString(); model.IsShelvePost = dr["IsShelvePost"].ToInt32(); model.DeliveryNo = dr["DeliveryNo"].ToDBString(); model.IsQuality = dr["IsQuality"].ToInt32(); model.IsReceivePost = dr["IsReceivePost"].ToInt32(); model.Plant = dr["Plant"].ToDBString(); model.PlantName = dr["PlantName"].ToDBString(); model.Receive_Id = dr["Receive_Id"].ToInt32(); model.StrVoucherType = dr["StrVoucherType"].ToDBString(); model.StrTaskType = dr["StrTaskType"].ToDBString(); model.StrIsQuality = dr["StrIsQuality"].ToDBString(); model.StrIsShelvePost = dr["StrIsShelvePost"].ToDBString(); model.StrIsReceivePost = dr["StrIsReceivePost"].ToDBString(); model.StrTaskStatus = dr["StrTaskStatus"].ToDBString(); model.WarehouseCode = dr["WarehouseCode"].ToDBString(); model.WarehouseName = dr["WarehouseName"].ToDBString(); model.AuditUserName = dr["AuditUserName"].ToDBString(); model.ReceiveUserName = dr["ReceiveUserName"].ToDBString(); model.CreateUserName = dr["CreateUserName"].ToDBString(); model.PostStatus = dr["PostStatus"].ToInt32(); model.StrPostStatus = dr["StrPostStatus"].ToDBString(); if (Common_Func.readerExists(dr, "MaterialDoc")) { model.MaterialDoc = dr["MaterialDoc"].ToDBString(); } model.CreateTime = model.CreateDateTime; switch (model.VoucherType) { case 50: case 60: if (string.IsNullOrEmpty(model.CreateUserName)) { model.ReceiveUserNo = model.CreateUserNo; model.ReceiveUserName = model.CreateUserName; } break; } return(model); }
/// <summary> /// 将获取的单条数据转封装成对象返回 /// </summary> protected override T_WareHouseInfo ToModel(IDataReader reader) { T_WareHouseInfo t_warehouse = new T_WareHouseInfo(); t_warehouse.ID = dbFactory.ToModelValue(reader, "ID").ToInt32(); t_warehouse.WareHouseNo = (string)dbFactory.ToModelValue(reader, "WAREHOUSENO"); t_warehouse.WareHouseName = (string)dbFactory.ToModelValue(reader, "WAREHOUSENAME"); t_warehouse.WareHouseType = dbFactory.ToModelValue(reader, "WAREHOUSETYPE").ToInt32(); t_warehouse.ContactUser = (string)dbFactory.ToModelValue(reader, "CONTACTUSER"); t_warehouse.ContactPhone = (string)dbFactory.ToModelValue(reader, "CONTACTPHONE"); t_warehouse.HouseCount = dbFactory.ToModelValue(reader, "HOUSECOUNT").ToInt32(); t_warehouse.HouseUsingCount = dbFactory.ToModelValue(reader, "HOUSEUSINGCOUNT").ToInt32(); t_warehouse.Address = (string)dbFactory.ToModelValue(reader, "ADDRESS"); t_warehouse.LocationDesc = (string)dbFactory.ToModelValue(reader, "LOCATIONDESC"); t_warehouse.WareHouseStatus = dbFactory.ToModelValue(reader, "WAREHOUSESTATUS").ToInt32(); t_warehouse.IsDel = dbFactory.ToModelValue(reader, "ISDEL").ToDecimal(); t_warehouse.Creater = (string)dbFactory.ToModelValue(reader, "CREATER"); t_warehouse.CreateTime = (DateTime?)dbFactory.ToModelValue(reader, "CREATETIME"); t_warehouse.Modifyer = (string)dbFactory.ToModelValue(reader, "MODIFYER"); t_warehouse.ModifyTime = (DateTime?)dbFactory.ToModelValue(reader, "MODIFYTIME"); if (Common_Func.readerExists(reader, "IsChecked")) { t_warehouse.BIsChecked = reader["IsChecked"].ToBoolean(); } if (Common_Func.readerExists(reader, "StrWarehouseStatus")) { t_warehouse.StrWarehouseStatus = reader["StrWarehouseStatus"].ToDBString(); } if (Common_Func.readerExists(reader, "AreaCount")) { t_warehouse.AreaCount = reader["AreaCount"].ToInt32(); } if (Common_Func.readerExists(reader, "AreaUsingCount")) { t_warehouse.AreaUsingCount = reader["AreaUsingCount"].ToInt32(); } t_warehouse.HouseRate = t_warehouse.HouseCount >= 1 ? t_warehouse.HouseUsingCount.ToDecimal() / t_warehouse.HouseCount.ToDecimal() : 0; t_warehouse.AreaRate = t_warehouse.AreaCount >= 1 ? t_warehouse.AreaUsingCount.ToDecimal() / t_warehouse.AreaCount.ToDecimal() : 0; t_warehouse.StrCreateTime = t_warehouse.CreateTime.ToShowTime(); t_warehouse.StrModifyTime = t_warehouse.ModifyTime.ToShowTime(); t_warehouse.SamplerCode = dbFactory.ToModelValue(reader, "Samplercode").ToDBString(); t_warehouse.SamplerName = dbFactory.ToModelValue(reader, "Samplername").ToDBString(); t_warehouse.DisplayID = t_warehouse.WareHouseNo; t_warehouse.DisplayName = t_warehouse.WareHouseName; t_warehouse.ISVWAREHOUSE = dbFactory.ToModelValue(reader, "ISVWAREHOUSE").ToInt32(); t_warehouse.DefaultAreaNo = dbFactory.ToModelValue(reader, "DefaultAreaNo").ToDBString(); t_warehouse.ZhAreaNo = dbFactory.ToModelValue(reader, "ZhAreaNo").ToDBString(); t_warehouse.FixAreaNo = dbFactory.ToModelValue(reader, "FixAreaNo").ToDBString(); t_warehouse.ZCAreaNo = dbFactory.ToModelValue(reader, "ZCAreaNo").ToDBString(); return(t_warehouse); }
/// <summary> /// 将获取的单条数据转封装成对象返回 /// </summary> protected override T_HouseInfo ToModel(IDataReader reader) { T_HouseInfo t_house = new T_HouseInfo(); t_house.ID = dbFactory.ToModelValue(reader, "ID").ToInt32(); t_house.HouseNo = (string)dbFactory.ToModelValue(reader, "HOUSENO"); t_house.HouseName = (string)dbFactory.ToModelValue(reader, "HOUSENAME"); t_house.HouseType = dbFactory.ToModelValue(reader, "HOUSETYPE").ToInt32(); t_house.ContactUser = (string)dbFactory.ToModelValue(reader, "CONTACTUSER"); t_house.ContactPhone = (string)dbFactory.ToModelValue(reader, "CONTACTPHONE"); t_house.AreaCount = dbFactory.ToModelValue(reader, "AREACOUNT").ToInt32(); t_house.AreaUsingCount = dbFactory.ToModelValue(reader, "AREAUSINGCOUNT").ToInt32(); t_house.Address = (string)dbFactory.ToModelValue(reader, "ADDRESS"); t_house.LocationDesc = (string)dbFactory.ToModelValue(reader, "LOCATIONDESC"); t_house.HouseStatus = dbFactory.ToModelValue(reader, "HOUSESTATUS").ToInt32(); t_house.WarehouseID = dbFactory.ToModelValue(reader, "WAREHOUSEID").ToInt32(); t_house.IsDel = dbFactory.ToModelValue(reader, "ISDEL").ToInt32(); t_house.Creater = (string)dbFactory.ToModelValue(reader, "CREATER"); t_house.CreateTime = (DateTime?)dbFactory.ToModelValue(reader, "CREATETIME"); t_house.Modifyer = (string)dbFactory.ToModelValue(reader, "MODIFYER"); t_house.ModifyTime = (DateTime?)dbFactory.ToModelValue(reader, "MODIFYTIME"); if (Common_Func.readerExists(reader, "WarehouseNo")) { t_house.WarehouseNo = reader["WarehouseNo"].ToDBString(); } if (Common_Func.readerExists(reader, "WarehouseName")) { t_house.WarehouseName = reader["WarehouseName"].ToDBString(); } if (Common_Func.readerExists(reader, "StrHouseStatus")) { t_house.StrHouseStatus = reader["StrHouseStatus"].ToDBString(); } if (Common_Func.readerExists(reader, "StrHouseType")) { t_house.StrHouseType = reader["StrHouseType"].ToDBString(); } if (Common_Func.readerExists(reader, "StrFloorType")) { t_house.StrFloorType = reader["StrFloorType"].ToDBString(); } t_house.AreaRate = t_house.AreaCount >= 1 ? t_house.AreaUsingCount.ToDecimal() / t_house.AreaCount.ToDecimal() : 0; t_house.FloorType = dbFactory.ToModelValue(reader, "FloorType").ToInt32(); t_house.MaterialClassCode = dbFactory.ToModelValue(reader, "MaterialClassCode").ToDBString(); t_house.MaterialClassName = dbFactory.ToModelValue(reader, "MaterialClassName").ToDBString(); t_house.HouseProp = dbFactory.ToModelValue(reader, "HouseProp").ToInt32(); t_house.StrHouseProp = dbFactory.ToModelValue(reader, "StrHouseProp").ToDBString(); return(t_house); }
/// <summary> /// 将获取的单条数据转封装成对象返回 /// </summary> protected override T_QualityDetailInfo ToModel(IDataReader reader) { T_QualityDetailInfo t_qualitydetail = new T_QualityDetailInfo(); t_qualitydetail.ID = dbFactory.ToModelValue(reader, "ID").ToInt32(); //t_qualitydetail.ErpVoucherNo = (string)dbFactory.ToModelValue(reader, "ERPVOUCHERNO"); t_qualitydetail.StrongHoldCode = (string)dbFactory.ToModelValue(reader, "STRONGHOLDCODE"); t_qualitydetail.StrongHoldName = (string)dbFactory.ToModelValue(reader, "STRONGHOLDNAME"); t_qualitydetail.CompanyCode = (string)dbFactory.ToModelValue(reader, "COMPANYCODE"); t_qualitydetail.ERPCreater = (string)dbFactory.ToModelValue(reader, "ERPCREATER"); t_qualitydetail.VouDate = (DateTime?)dbFactory.ToModelValue(reader, "VOUDATE"); t_qualitydetail.VouUser = (string)dbFactory.ToModelValue(reader, "VOUUSER"); t_qualitydetail.ERPStatus = dbFactory.ToModelValue(reader, "ERPSTATUS").ToDBString(); t_qualitydetail.ERPNote = (string)dbFactory.ToModelValue(reader, "ERPNOTE"); t_qualitydetail.CreateTime = (DateTime?)dbFactory.ToModelValue(reader, "CREATETIME"); t_qualitydetail.Creater = (string)dbFactory.ToModelValue(reader, "CREATER"); t_qualitydetail.Modifyer = (string)dbFactory.ToModelValue(reader, "MODIFYER"); t_qualitydetail.ModifyTime = (DateTime?)dbFactory.ToModelValue(reader, "MODIFYTIME"); t_qualitydetail.Status = dbFactory.ToModelValue(reader, "STATUS").ToInt32(); t_qualitydetail.TimeStamp = (DateTime?)dbFactory.ToModelValue(reader, "TIMESTAMP"); t_qualitydetail.IsDel = dbFactory.ToModelValue(reader, "ISDEL").ToInt32(); t_qualitydetail.NoticeStatus = dbFactory.ToModelValue(reader, "NOTICESTATUS").ToInt32(); t_qualitydetail.QualityType = dbFactory.ToModelValue(reader, "QUALITYTYPE").ToInt32(); t_qualitydetail.MaterialNo = (string)dbFactory.ToModelValue(reader, "MATERIALNO"); t_qualitydetail.MaterialDesc = (string)dbFactory.ToModelValue(reader, "MATERIALDESC"); t_qualitydetail.InSQty = (decimal?)dbFactory.ToModelValue(reader, "INSQTY"); t_qualitydetail.Unit = (string)dbFactory.ToModelValue(reader, "UNIT"); t_qualitydetail.UnitName = (string)dbFactory.ToModelValue(reader, "UNITNAME"); t_qualitydetail.QuanQty = (decimal?)dbFactory.ToModelValue(reader, "QUANQTY"); t_qualitydetail.UnQuanQty = (decimal?)dbFactory.ToModelValue(reader, "UNQUANQTY"); t_qualitydetail.DesQty = (decimal?)dbFactory.ToModelValue(reader, "DESQTY"); t_qualitydetail.WarehouseNo = (string)dbFactory.ToModelValue(reader, "WAREHOUSENO"); t_qualitydetail.BatchNo = (string)dbFactory.ToModelValue(reader, "BATCHNO"); t_qualitydetail.ErpVoucherNo = (string)dbFactory.ToModelValue(reader, "ErpVoucherNo"); t_qualitydetail.ErpInVoucherNo = (string)dbFactory.ToModelValue(reader, "inerpvoucherno"); //t_qualitydetail.SampQty = (decimal)dbFactory.ToModelValue(reader, "SampQty"); t_qualitydetail.RemainQty = (decimal?)dbFactory.ToModelValue(reader, "RemainQty"); t_qualitydetail.QuanQty = (decimal?)dbFactory.ToModelValue(reader, "QuanQty"); t_qualitydetail.UnQuanQty = (decimal?)dbFactory.ToModelValue(reader, "UnQuanQty"); t_qualitydetail.MaterialNoID = dbFactory.ToModelValue(reader, "MaterialNoID").ToInt32(); if (Common_Func.readerExists(reader, "Areano")) { t_qualitydetail.AreaNo = (string)dbFactory.ToModelValue(reader, "Areano"); } if (Common_Func.readerExists(reader, "AreaType")) { t_qualitydetail.AreaType = reader["AreaType"].ToInt32(); } return(t_qualitydetail); }
internal MenuInfo GetModelFromDataReader(SqlDataReader dr) { MenuInfo model = new MenuInfo(); model.ID = dr["ID"].ToInt32(); model.MenuNo = dr["MenuNo"].ToDBString(); model.MenuName = dr["MenuName"].ToDBString(); model.MenuAbbName = dr["MenuAbbName"].ToDBString(); model.MenuType = dr["MenuType"].ToInt32(); model.ProjectName = dr["ProjectName"].ToDBString(); model.IcoName = dr["IcoName"].ToDBString(); model.SafeLevel = dr["SafeLevel"].ToInt32(); model.IsDefault = dr["IsDefault"].ToInt32(); model.Mnemonic = dr["Mnemonic"].ToInt32(); model.MnemonicCode = dr["MnemonicCode"].ToDBString(); model.NodeUrl = dr["NodeUrl"].ToDBString(); model.NodeLevel = dr["NodeLevel"].ToInt32(); model.NodeSort = dr["NodeSort"].ToInt32(); model.ParentID = dr["ParentID"].ToInt32(); model.MenuStatus = dr["MenuStatus"].ToInt32(); model.Description = dr["Description"].ToDBString(); model.IsDel = dr["ISDEL"].ToInt32(); model.Creater = dr["CREATER"].ToString(); model.CreateTime = dr["CREATETIME"].ToDateTime(); model.Modifyer = dr["MODIFYER"].ToString(); model.ModifyTime = dr["MODIFYTIME"].ToDateTimeNull(); if (Common_Func.readerExists(dr, "IsChecked")) { model.BIsChecked = dr["IsChecked"].ToBoolean(); } if (Common_Func.readerExists(dr, "StrMenuType")) { model.StrMenuType = dr["StrMenuType"].ToDBString(); } if (Common_Func.readerExists(dr, "StrMenuStatus")) { model.StrMenuStatus = dr["StrMenuStatus"].ToDBString(); } if (Common_Func.readerExists(dr, "SonQty")) { model.SonQty = dr["SonQty"].ToInt32(); } model.BIsDefault = model.IsDefault.ToBoolean(); model.BHaveParameter = model.MenuType == 2 && model.ProjectName.IndexOf(':') >= 0; return(model); }
private AreaInfo GetModelFromDataReader(SqlDataReader dr) { AreaInfo model = new AreaInfo(); model.ID = dr["ID"].ToInt32(); model.AreaNo = dr["AREANO"].ToDBString(); model.AreaName = dr["AREANAME"].ToDBString(); model.AreaType = dr["AREATYPE"].ToInt32(); model.ContactUser = dr["CONTACTUSER"].ToDBString(); model.ContactPhone = dr["CONTACTPHONE"].ToDBString(); model.Address = dr["ADDRESS"].ToDBString(); model.LocationDesc = dr["LOCATIONDESC"].ToDBString(); model.AreaStatus = dr["AreaStatus"].ToInt32(); model.HouseID = dr["HOUSEID"].ToInt32(); model.IsDel = dr["ISDEL"].ToInt32(); model.Creater = dr["CREATER"].ToDBString(); model.CreateTime = dr["CREATETIME"].ToDateTime(); model.Modifyer = dr["MODIFYER"].ToDBString(); model.ModifyTime = dr["MODIFYTIME"].ToDateTimeNull(); if (Common_Func.readerExists(dr, "HouseNo")) { model.HouseNo = dr["HouseNo"].ToDBString(); } if (Common_Func.readerExists(dr, "isHost")) { model.isHost = dr["isHost"].ToInt32() == 1; } if (Common_Func.readerExists(dr, "HouseName")) { model.HouseName = dr["HouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "WarehouseNo")) { model.WarehouseNo = dr["WarehouseNo"].ToDBString(); } if (Common_Func.readerExists(dr, "WarehouseName")) { model.WarehouseName = dr["WarehouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "StrAreaStatus")) { model.StrAreaStatus = dr["StrAreaStatus"].ToDBString(); } return(model); }
private WarehouseInfo GetModelFromDataReader(SqlDataReader dr) { WarehouseInfo model = new WarehouseInfo(); model.ID = dr["ID"].ToInt32(); model.WarehouseNo = dr["WAREHOUSENO"].ToDBString(); model.WarehouseName = dr["WAREHOUSENAME"].ToDBString(); model.WarehouseType = dr["WAREHOUSETYPE"].ToInt32(); model.ContactUser = dr["CONTACTUSER"].ToDBString(); model.ContactPhone = dr["CONTACTPHONE"].ToDBString(); model.HouseCount = dr["HOUSECOUNT"].ToInt32(); model.HouseUsingCount = dr["HOUSEUSINGCOUNT"].ToInt32(); model.Address = dr["ADDRESS"].ToDBString(); model.LocationDesc = dr["LOCATIONDESC"].ToDBString(); model.WarehouseStatus = dr["WarehouseStatus"].ToInt32(); model.IsDel = dr["ISDEL"].ToInt32(); model.Creater = dr["CREATER"].ToDBString(); model.CreateTime = dr["CREATETIME"].ToDateTime(); model.Modifyer = dr["MODIFYER"].ToDBString(); model.ModifyTime = dr["MODIFYTIME"].ToDateTimeNull(); if (Common_Func.readerExists(dr, "IsChecked")) { model.BIsChecked = dr["IsChecked"].ToBoolean(); } if (Common_Func.readerExists(dr, "StrWarehouseStatus")) { model.StrWarehouseStatus = dr["StrWarehouseStatus"].ToDBString(); } if (Common_Func.readerExists(dr, "AreaCount")) { model.AreaCount = dr["AreaCount"].ToInt32(); } if (Common_Func.readerExists(dr, "AreaUsingCount")) { model.AreaUsingCount = dr["AreaUsingCount"].ToInt32(); } model.HouseRate = model.HouseCount >= 1 ? model.HouseUsingCount.ToDecimal() / model.HouseCount.ToDecimal() : 0; model.AreaRate = model.AreaCount >= 1 ? model.AreaUsingCount.ToDecimal() / model.AreaCount.ToDecimal() : 0; return(model); }
/// <summary> /// 将获取的单条数据转封装成对象返回 /// </summary> protected override T_UserGroupInfo ToModel(IDataReader reader) { T_UserGroupInfo t_usergroup = new T_UserGroupInfo(); t_usergroup.ID = dbFactory.ToModelValue(reader, "ID").ToInt32(); t_usergroup.UserGroupNo = (string)dbFactory.ToModelValue(reader, "USERGROUPNO"); t_usergroup.UserGroupName = (string)dbFactory.ToModelValue(reader, "USERGROUPNAME"); t_usergroup.UserGroupAbbname = (string)dbFactory.ToModelValue(reader, "USERGROUPABBNAME"); t_usergroup.UserGroupType = dbFactory.ToModelValue(reader, "USERGROUPTYPE").ToInt32(); t_usergroup.UserGroupStatus = dbFactory.ToModelValue(reader, "USERGROUPSTATUS").ToInt32(); t_usergroup.Description = (string)dbFactory.ToModelValue(reader, "DESCRIPTION"); t_usergroup.IsDel = dbFactory.ToModelValue(reader, "ISDEL").ToDecimal(); t_usergroup.Creater = (string)dbFactory.ToModelValue(reader, "CREATER"); t_usergroup.CreateTime = (DateTime?)dbFactory.ToModelValue(reader, "CREATETIME"); t_usergroup.Modifyer = (string)dbFactory.ToModelValue(reader, "MODIFYER"); t_usergroup.ModifyTime = (DateTime?)dbFactory.ToModelValue(reader, "MODIFYTIME"); if (Common_Func.readerExists(reader, "IsChecked")) { t_usergroup.BIsChecked = reader["IsChecked"].ToBoolean(); } if (Common_Func.readerExists(reader, "StrUserGroupType")) { t_usergroup.StrUserGroupType = reader["StrUserGroupType"].ToDBString(); } if (Common_Func.readerExists(reader, "StrUserGroupStatus")) { t_usergroup.StrUserGroupStatus = reader["StrUserGroupStatus"].ToDBString(); } t_usergroup.StrCreateTime = t_usergroup.CreateTime.ToShowTime(); t_usergroup.StrModifyTime = t_usergroup.ModifyTime.ToShowTime(); t_usergroup.DisplayID = t_usergroup.ID.ToString(); t_usergroup.DisplayName = t_usergroup.UserGroupName; t_usergroup.MainTypeCode = (string)dbFactory.ToModelValue(reader, "MainTypeCode"); t_usergroup.PickLeaderUserNo = (string)dbFactory.ToModelValue(reader, "PickLeaderUserNo"); return(t_usergroup); }
private CheckTransInfo GetModelFromDataReader(SqlDataReader dr) { CheckTransInfo model = new CheckTransInfo(); if (Common_Func.readerExists(dr, "ID")) model.ID = dr["ID"].ToInt32(); if (Common_Func.readerExists(dr, "CheckID")) model.CheckID = dr["CheckID"].ToInt32(); if (Common_Func.readerExists(dr, "WarehouseNo")) model.WarehouseNo = dr["WarehouseNo"].ToDBString(); if (Common_Func.readerExists(dr, "HouseNo")) model.HouseNo = dr["HouseNo"].ToDBString(); if (Common_Func.readerExists(dr, "AreaNo")) model.AreaNo = dr["AreaNo"].ToDBString(); if (Common_Func.readerExists(dr, "MaterialNo")) model.MaterialNo = dr["MaterialNo"].ToDBString(); if (Common_Func.readerExists(dr, "MaterialDesc")) model.MaterialDesc = dr["MaterialDesc"].ToDBString(); if (Common_Func.readerExists(dr, "Barcode")) model.Barcode = dr["Barcode"].ToDBString(); if (Common_Func.readerExists(dr, "SerialNo")) model.SerialNo = dr["SerialNo"].ToDBString(); if (Common_Func.readerExists(dr, "BatchNo")) model.BatchNo = dr["BatchNo"].ToDBString(); if (Common_Func.readerExists(dr, "ScanQty")) model.ScanQty = dr["ScanQty"].ToDecimal(); if (Common_Func.readerExists(dr, "Operator")) model.Operator = dr["Operator"].ToDBString(); if (Common_Func.readerExists(dr, "OperationTime")) model.OperationTime = dr["OperationTime"].ToDateTime(); if (Common_Func.readerExists(dr, "WarehouseName")) model.WarehouseName = dr["WarehouseName"].ToDBString(); if (Common_Func.readerExists(dr, "HouseName")) model.HouseName = dr["HouseName"].ToDBString(); if (Common_Func.readerExists(dr, "AreaName")) model.AreaName = dr["AreaName"].ToDBString(); return model; }
private ProfitLossInfo GetModelFromDataReader(SqlDataReader dr) { ProfitLossInfo model = new ProfitLossInfo(); if (Common_Func.readerExists(dr, "CheckID")) { model.CheckID = dr["CheckID"].ToInt32(); } if (Common_Func.readerExists(dr, "WarehouseNo")) { model.WarehouseNo = dr["WarehouseNo"].ToDBString(); } if (Common_Func.readerExists(dr, "HouseNo")) { model.HouseNo = dr["HouseNo"].ToDBString(); } if (Common_Func.readerExists(dr, "AreaNo")) { model.AreaNo = dr["AreaNo"].ToDBString(); } if (Common_Func.readerExists(dr, "ScanWarehouseNo")) { model.ScanWarehouseNo = dr["ScanWarehouseNo"].ToDBString(); } if (Common_Func.readerExists(dr, "ScanHouseNo")) { model.ScanHouseNo = dr["ScanHouseNo"].ToDBString(); } if (Common_Func.readerExists(dr, "ScanAreaNo")) { model.ScanAreaNo = dr["ScanAreaNo"].ToDBString(); } if (Common_Func.readerExists(dr, "Barcode")) { model.Barcode = dr["Barcode"].ToDBString(); } if (Common_Func.readerExists(dr, "SerialNo")) { model.SerialNo = dr["SerialNo"].ToDBString(); } if (Common_Func.readerExists(dr, "BatchNo")) { model.BatchNo = dr["BatchNo"].ToDBString(); } if (Common_Func.readerExists(dr, "SN")) { model.SN = dr["SN"].ToDBString(); } if (Common_Func.readerExists(dr, "MaterialNo")) { model.MaterialNo = dr["MaterialNo"].ToDBString(); } if (Common_Func.readerExists(dr, "MaterialDesc")) { model.MaterialDesc = dr["MaterialDesc"].ToDBString(); } if (Common_Func.readerExists(dr, "AccountQty")) { model.AccountQty = dr["AccountQty"].ToDecimal(); } if (Common_Func.readerExists(dr, "ScanQty")) { model.ScanQty = dr["ScanQty"].ToDecimal(); } if (Common_Func.readerExists(dr, "WarehouseName")) { model.WarehouseName = dr["WarehouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "HouseName")) { model.HouseName = dr["HouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "AreaName")) { model.AreaName = dr["AreaName"].ToDBString(); } if (Common_Func.readerExists(dr, "WarehouseName")) { model.WarehouseName = dr["WarehouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "HouseName")) { model.HouseName = dr["HouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "AreaName")) { model.AreaName = dr["AreaName"].ToDBString(); } model.DifferenceQty = model.AccountQty - model.ScanQty; if (model.DifferenceQty < 0) { model.ProfitLoss = 2; model.StrProfitLoss = "盘盈"; } else if (model.DifferenceQty > 0) { model.ProfitLoss = 3; model.StrProfitLoss = "盘亏"; } else { model.ProfitLoss = 1; model.StrProfitLoss = "平衡"; } model.DifferenceQty = Math.Abs(model.DifferenceQty); return(model); }
private CheckInfo GetModelFromDataReader(SqlDataReader dr) { CheckInfo model = new CheckInfo(); model.ID = dr["ID"].ToInt32(); model.CheckNo = dr["CheckNo"].ToDBString(); model.CheckType = dr["CheckType"].ToInt32(); model.DutyUser = dr["DutyUser"].ToDBString(); model.CheckDesc = dr["CheckDesc"].ToDBString(); model.CheckStatus = dr["CheckStatus"].ToInt32(); model.BeginTime = dr["BeginTime"].ToDateTimeNull(); model.DoneTime = dr["DoneTime"].ToDateTimeNull(); model.Remarks = dr["Remarks"].ToDBString(); model.IsDel = dr["ISDEL"].ToInt32(); model.Creater = dr["CREATER"].ToDBString(); model.CreateTime = dr["CREATETIME"].ToDateTime(); model.Modifyer = dr["MODIFYER"].ToDBString(); model.ModifyTime = dr["MODIFYTIME"].ToDateTimeNull(); if (Common_Func.readerExists(dr, "CheckStyle")) { model.CheckStyle = dr["CheckStyle"].ToInt32(); } if (Common_Func.readerExists(dr, "MainCheckID")) { model.MainCheckID = dr["MainCheckID"].ToInt32(); } if (Common_Func.readerExists(dr, "ReCheckCount")) { model.ReCheckCount = dr["ReCheckCount"].ToInt32(); } if (Common_Func.readerExists(dr, "EditText")) { model.EditText = dr["EditText"].ToDBString(); } if (Common_Func.readerExists(dr, "StrCheckType")) { model.StrCheckType = dr["StrCheckType"].ToDBString(); } if (Common_Func.readerExists(dr, "StrCheckStatus")) { model.StrCheckStatus = dr["StrCheckStatus"].ToDBString(); } if (Common_Func.readerExists(dr, "DifferenceQty")) { model.DifferenceQty = dr["DifferenceQty"].ToDecimal(); } if (Common_Func.readerExists(dr, "StrCheckStyle")) { model.StrCheckStyle = dr["StrCheckStyle"].ToDBString(); } model.StrCreateTime = model.CreateTime.ToSqlTimeString(); model.StrModifyTime = model.ModifyTime.ToSqlTimeString(); model.BIsMainCheck = model.CheckStyle == 1; if (!model.BIsMainCheck) { model.EditText = "查看"; } return(model); }
/// <summary> /// 将获取的单条数据转封装成对象返回 /// </summary> protected override T_AreaInfo ToModel(IDataReader reader) { T_AreaInfo t_area = new T_AreaInfo(); t_area.ID = dbFactory.ToModelValue(reader, "ID").ToInt32(); t_area.AreaNo = (string)dbFactory.ToModelValue(reader, "AREANO"); t_area.AreaName = (string)dbFactory.ToModelValue(reader, "AREANAME"); t_area.AreaType = dbFactory.ToModelValue(reader, "AREATYPE").ToInt32(); t_area.ContactUser = (string)dbFactory.ToModelValue(reader, "CONTACTUSER"); t_area.ContactPhone = (string)dbFactory.ToModelValue(reader, "CONTACTPHONE"); t_area.Address = (string)dbFactory.ToModelValue(reader, "ADDRESS"); t_area.LocationDesc = (string)dbFactory.ToModelValue(reader, "LOCATIONDESC"); t_area.AreaStatus = dbFactory.ToModelValue(reader, "AREASTATUS").ToInt32(); t_area.HouseID = dbFactory.ToModelValue(reader, "HOUSEID").ToInt32(); t_area.IsDel = dbFactory.ToModelValue(reader, "ISDEL").ToInt32(); t_area.Creater = (string)dbFactory.ToModelValue(reader, "CREATER"); t_area.CreateTime = (DateTime?)dbFactory.ToModelValue(reader, "CREATETIME"); t_area.Modifyer = (string)dbFactory.ToModelValue(reader, "MODIFYER"); t_area.ModifyTime = (DateTime?)dbFactory.ToModelValue(reader, "MODIFYTIME"); t_area.CheckID = dbFactory.ToModelValue(reader, "CHECKID").ToInt32(); t_area.Length = dbFactory.ToModelValue(reader, "Length").ToDecimal(); t_area.Wide = dbFactory.ToModelValue(reader, "Wide").ToDecimal(); t_area.Hight = dbFactory.ToModelValue(reader, "Hight").ToDecimal(); t_area.WeightLimit = dbFactory.ToModelValue(reader, "WeightLimit").ToDecimal(); t_area.VolumeLimit = dbFactory.ToModelValue(reader, "VolumeLimit").ToDecimal(); t_area.QuantityLimit = dbFactory.ToModelValue(reader, "QuantityLimit").ToDecimal(); t_area.PalletLimit = dbFactory.ToModelValue(reader, "PalletLimit").ToDecimal(); t_area.TemperaturePry = dbFactory.ToModelValue(reader, "TemperaturePry").ToDBString(); t_area.CustomerNo = dbFactory.ToModelValue(reader, "CustomerNo").ToDBString(); t_area.CustomerName = dbFactory.ToModelValue(reader, "CustomerName").ToDBString(); t_area.ProjectNo = dbFactory.ToModelValue(reader, "ProjectNo").ToDBString(); t_area.IEscrow = dbFactory.ToModelValue(reader, "IEscrow").ToInt32(); if (Common_Func.readerExists(reader, "HouseNo")) { t_area.HouseNo = reader["HouseNo"].ToDBString(); } if (Common_Func.readerExists(reader, "HouseName")) { t_area.HouseName = reader["HouseName"].ToDBString(); } if (Common_Func.readerExists(reader, "WarehouseNo")) { t_area.WarehouseNo = reader["WarehouseNo"].ToDBString(); } if (Common_Func.readerExists(reader, "WarehouseName")) { t_area.WarehouseName = reader["WarehouseName"].ToDBString(); } if (Common_Func.readerExists(reader, "StrAreaStatus")) { t_area.StrAreaStatus = reader["StrAreaStatus"].ToDBString(); } if (Common_Func.readerExists(reader, "StrAreaType")) { t_area.StrAreaStatus = reader["StrAreaType"].ToDBString(); } if (Common_Func.readerExists(reader, "CheckID")) { t_area.CheckID = reader["CheckID"].ToInt32(); } t_area.StrCreateTime = t_area.CreateTime.ToShowTime(); t_area.StrModifyTime = t_area.ModifyTime.ToShowTime(); t_area.WarehouseID = dbFactory.ToModelValue(reader, "WarehouseID").ToInt32(); t_area.HeightArea = dbFactory.ToModelValue(reader, "HeightArea").ToInt32(); t_area.StrHeightArea = dbFactory.ToModelValue(reader, "StrHeightArea").ToDBString(); t_area.QuanUserNo = dbFactory.ToModelValue(reader, "Samplercode").ToDBString(); t_area.QuanUserName = dbFactory.ToModelValue(reader, "Samplername").ToDBString(); t_area.SortArea = dbFactory.ToModelValue(reader, "SortArea").ToDBString(); t_area.StrAreaStatus = dbFactory.ToModelValue(reader, "StrAreaStatus").ToDBString(); t_area.StrAreaType = dbFactory.ToModelValue(reader, "StrAreaType").ToDBString(); t_area.HouseProp = dbFactory.ToModelValue(reader, "HouseProp").ToDBString(); return(t_area); }
private Stock_Model GetModelFromDataReader(SqlDataReader dr) { Stock_Model model = new Stock_Model(); if (Common_Func.readerExists(dr, "StockType")) { model.StockType = dr["StockType"].ToInt32(); } if (Common_Func.readerExists(dr, "Barcode")) { model.Barcode = dr["Barcode"].ToDBString(); } if (Common_Func.readerExists(dr, "SerialNo")) { model.SerialNo = dr["SerialNo"].ToDBString(); } if (Common_Func.readerExists(dr, "MaterialNo")) { model.MaterialNo = dr["MaterialNo"].ToDBString(); } if (Common_Func.readerExists(dr, "MaterialDesc")) { model.MaterialENDesc = dr["MaterialDesc"].ToDBString(); } if (Common_Func.readerExists(dr, "WarehouseNo")) { model.WarehouseNo = dr["WarehouseNo"].ToDBString(); } if (Common_Func.readerExists(dr, "HouseNo")) { model.HouseNo = dr["HouseNo"].ToDBString(); } if (Common_Func.readerExists(dr, "AreaNo")) { model.AreaNo = dr["AreaNo"].ToDBString(); } if (Common_Func.readerExists(dr, "Qty")) { model.Qty = dr["Qty"].ToDecimal(); } if (Common_Func.readerExists(dr, "TempMaterialNo")) { model.TempMaterialNo = dr["TempMaterialNo"].ToDBString(); } if (Common_Func.readerExists(dr, "TempMaterialDesc")) { model.TempMaterialDesc = dr["TempMaterialDesc"].ToDBString(); } if (Common_Func.readerExists(dr, "PickAreaNo")) { model.PickAreaNo = dr["PickAreaNo"].ToDBString(); } if (Common_Func.readerExists(dr, "CelAreaNo")) { model.CelAreaNo = dr["CelAreaNo"].ToDBString(); } if (Common_Func.readerExists(dr, "BatchNo")) { model.BatchNo = dr["BatchNo"].ToDBString(); } if (Common_Func.readerExists(dr, "StrStockType")) { model.StrStockType = dr["StrStockType"].ToDBString(); } if (Common_Func.readerExists(dr, "WarehouseName")) { model.WarehouseName = dr["WarehouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "HouseName")) { model.HouseName = dr["HouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "AreaName")) { model.AreaName = dr["AreaName"].ToDBString(); } if (Common_Func.readerExists(dr, "SN")) { model.SN = dr["SN"].ToDBString(); } if (Common_Func.readerExists(dr, "Creater")) { model.Creater = dr["Creater"].ToDBString(); } if (Common_Func.readerExists(dr, "CreateTime")) { model.CreateTime = dr["CreateTime"].ToDateTime(); } return(model); }
/// <summary> /// 将获取的单条数据转封装成对象返回 /// </summary> protected override T_MenuInfo ToModel(IDataReader reader) { T_MenuInfo t_menu = new T_MenuInfo(); t_menu.ID = dbFactory.ToModelValue(reader, "ID").ToInt32(); t_menu.MenuNo = (string)dbFactory.ToModelValue(reader, "MENUNO"); t_menu.MenuName = (string)dbFactory.ToModelValue(reader, "MENUNAME"); t_menu.MemuAbbName = (string)dbFactory.ToModelValue(reader, "MENUABBNAME"); t_menu.MenuType = dbFactory.ToModelValue(reader, "MENUTYPE").ToInt32(); t_menu.ProjectName = (string)dbFactory.ToModelValue(reader, "PROJECTNAME"); t_menu.IcoName = (string)dbFactory.ToModelValue(reader, "ICONAME"); t_menu.SafeLevel = dbFactory.ToModelValue(reader, "SAFELEVEL").ToDecimal(); t_menu.IsDefault = dbFactory.ToModelValue(reader, "ISDEFAULT").ToDecimal(); t_menu.Mnemonic = dbFactory.ToModelValue(reader, "MNEMONIC").ToDecimal(); t_menu.Mnemoniccode = (string)dbFactory.ToModelValue(reader, "MNEMONICCODE"); t_menu.NodeUrl = (string)dbFactory.ToModelValue(reader, "NODEURL"); t_menu.NodeLevel = dbFactory.ToModelValue(reader, "NODELEVEL").ToInt32(); t_menu.NodeSort = dbFactory.ToModelValue(reader, "NODESORT").ToInt32(); t_menu.ParentID = dbFactory.ToModelValue(reader, "PARENTID").ToInt32(); t_menu.MenuStatus = dbFactory.ToModelValue(reader, "MENUSTATUS").ToInt32(); t_menu.Description = (string)dbFactory.ToModelValue(reader, "DESCRIPTION"); t_menu.IsDel = dbFactory.ToModelValue(reader, "ISDEL").ToDecimal(); t_menu.Creater = (string)dbFactory.ToModelValue(reader, "CREATER"); t_menu.CreateTime = (DateTime?)dbFactory.ToModelValue(reader, "CREATETIME"); t_menu.Modifyer = (string)dbFactory.ToModelValue(reader, "MODIFYER"); t_menu.ModifyTime = (DateTime?)dbFactory.ToModelValue(reader, "MODIFYTIME"); t_menu.MenuStyle = dbFactory.ToModelValue(reader, "MENUSTYLE").ToDecimal(); if (Common_Func.readerExists(reader, "ParentName")) { t_menu.ParentName = reader["ParentName"].ToDBString(); } if (Common_Func.readerExists(reader, "MenuStyle")) { t_menu.MenuStyle = reader["MenuStyle"].ToInt32(); } if (Common_Func.readerExists(reader, "IsChecked")) { t_menu.IsChecked = reader["IsChecked"].ToBoolean(); } if (Common_Func.readerExists(reader, "StrMenuType")) { t_menu.StrMenuType = reader["StrMenuType"].ToDBString(); } if (Common_Func.readerExists(reader, "StrMenuStatus")) { t_menu.StrMenuStatus = reader["StrMenuStatus"].ToDBString(); } if (Common_Func.readerExists(reader, "SonQty")) { t_menu.SonQty = reader["SonQty"].ToInt32(); } if (Common_Func.readerExists(reader, "StrMenuStyle")) { t_menu.StrMenuStyle = reader["StrMenuStyle"].ToDBString(); } t_menu.BIsDefault = t_menu.IsDefault.ToBoolean(); t_menu.BHaveParameter = t_menu.MenuType == 2 && t_menu.ProjectName.IndexOf(':') >= 0; t_menu.StrCreateTime = t_menu.CreateTime.ToShowTime(); t_menu.StrModifyTime = t_menu.ModifyTime.ToShowTime(); return(t_menu); }
protected override UserInfo ToModel(IDataReader reader) { UserInfo t_user = new UserInfo(); t_user.ID = dbFactory.ToModelValue(reader, "ID").ToInt32(); t_user.UserNo = (string)dbFactory.ToModelValue(reader, "USERNO"); t_user.UserName = (string)dbFactory.ToModelValue(reader, "USERNAME"); t_user.PassWord = Secretkey.JieMi((string)dbFactory.ToModelValue(reader, "PASSWORD")); t_user.UserType = dbFactory.ToModelValue(reader, "USERTYPE").ToInt32(); t_user.PinYin = (string)dbFactory.ToModelValue(reader, "PINYIN"); t_user.Duty = (string)dbFactory.ToModelValue(reader, "DUTY"); t_user.Tel = (string)dbFactory.ToModelValue(reader, "TEL"); t_user.Mobile = (string)dbFactory.ToModelValue(reader, "MOBILE"); t_user.Email = (string)dbFactory.ToModelValue(reader, "EMAIL"); t_user.Sex = dbFactory.ToModelValue(reader, "SEX").ToInt32(); t_user.IsPick = dbFactory.ToModelValue(reader, "ISPICK").ToInt32(); t_user.IsReceive = dbFactory.ToModelValue(reader, "ISRECEIVE").ToInt32(); t_user.IsQuality = dbFactory.ToModelValue(reader, "ISQUALITY").ToInt32(); t_user.UserStatus = dbFactory.ToModelValue(reader, "USERSTATUS").ToInt32(); t_user.Address = (string)dbFactory.ToModelValue(reader, "ADDRESS"); t_user.GroupCode = (string)dbFactory.ToModelValue(reader, "GROUPCODE"); t_user.WarehouseCode = (string)dbFactory.ToModelValue(reader, "WAREHOUSECODE"); t_user.Description = (string)dbFactory.ToModelValue(reader, "DESCRIPTION"); t_user.LoginIP = (string)dbFactory.ToModelValue(reader, "LOGINIP"); t_user.LoginTime = (DateTime?)dbFactory.ToModelValue(reader, "LOGINTIME"); t_user.IsDel = dbFactory.ToModelValue(reader, "ISDEL").ToDecimal(); t_user.Creater = (string)dbFactory.ToModelValue(reader, "CREATER"); t_user.CreateTime = (DateTime?)dbFactory.ToModelValue(reader, "CREATETIME"); t_user.Modifyer = (string)dbFactory.ToModelValue(reader, "MODIFYER"); t_user.ModifyTime = (DateTime?)dbFactory.ToModelValue(reader, "MODIFYTIME"); t_user.LoginDevice = (string)dbFactory.ToModelValue(reader, "LOGINDEVICE"); t_user.Deviceversion = (string)dbFactory.ToModelValue(reader, "DEVICEVERSION"); if (Common_Func.readerExists(reader, "IsAdmin")) { t_user.BIsAdmin = reader["IsAdmin"].ToBoolean(); } if (Common_Func.readerExists(reader, "StrUserType")) { t_user.StrUserType = reader["StrUserType"].ToDBString(); } if (Common_Func.readerExists(reader, "StrUserStatus")) { t_user.StrUserStatus = reader["StrUserStatus"].ToDBString(); } if (Common_Func.readerExists(reader, "StrSex")) { t_user.StrSex = reader["StrSex"].ToDBString(); } if (Common_Func.readerExists(reader, "GroupName")) { t_user.GroupName = reader["GroupName"].ToDBString(); } if (Common_Func.readerExists(reader, "WarehouseName")) { t_user.WarehouseName = reader["WarehouseName"].ToDBString(); } t_user.RePassword = t_user.PassWord; t_user.StrIsAdmin = t_user.BIsAdmin ? "管理员" : "标准用户"; t_user.StrIsPick = t_user.IsPick == 1 ? "拣货" : "不拣货"; t_user.StrIsReceive = t_user.IsReceive == 1 ? "收货" : "不收货"; t_user.BIsOnline = !string.IsNullOrEmpty(t_user.LoginIP); t_user.IsOnline = t_user.BIsOnline.ToInt32(); t_user.StrCreateTime = t_user.CreateTime.ToShowTime(); t_user.StrModifyTime = t_user.ModifyTime.ToShowTime(); t_user.WarehouseID = dbFactory.ToModelValue(reader, "WAREHOUSECODE").ToInt32(); t_user.DisplayID = t_user.UserNo; t_user.DisplayName = t_user.UserName; t_user.IsPickLeader = dbFactory.ToModelValue(reader, "IsPickLeader").ToInt32(); t_user.StrIsPickLeader = t_user.IsPickLeader == 2 ? "是" : "否"; t_user.PickLeader = t_user.IsPickLeader == 2 ? true : false; t_user.CYAccount = dbFactory.ToModelValue(reader, "CYAccount").ToDBString(); t_user.CXAccount = dbFactory.ToModelValue(reader, "CXAccount").ToDBString(); t_user.FCAccount = dbFactory.ToModelValue(reader, "FCAccount").ToDBString(); //t_user.PostAccount = GetPostAccount(t_user); return(t_user); }
private TaskTransInfo GetModelFromDataReader(SqlDataReader dr) { TaskTransInfo model = new TaskTransInfo(); model.ID = dr["ID"].ToInt32(); model.TaskType = dr["TaskType"].ToInt32(); model.FromWarehouseNo = dr["FromWarehouseNo"].ToDBString(); model.ToWarehouseNo = dr["ToWarehouseNo"].ToDBString(); model.FromHouseNo = dr["FromHouseNo"].ToDBString(); model.ToHouseNo = dr["ToHouseNo"].ToDBString(); model.FromAreaNo = dr["FromAreaNo"].ToDBString(); model.ToAreaNo = dr["ToAreaNo"].ToDBString(); model.TaskNo = dr["TaskNo"].ToDBString(); model.Barcode = dr["Barcode"].ToDBString(); model.SerialNo = dr["SerialNo"].ToDBString(); model.VoucherType = dr["VoucherType"].ToInt32(); model.DeliveryNo = dr["DeliveryNo"].ToDBString(); model.SupCusCode = dr["SupCusCode"].ToDBString(); model.SupCusName = dr["SupCusName"].ToDBString(); model.MaterialNo = dr["MaterialNo"].ToDBString(); model.MaterialDesc = dr["MaterialDesc"].ToDBString(); model.Qty = dr["Qty"].ToDecimal(); model.CreateTime = dr["CreateDate"].ToDateTimeNull(); if (Common_Func.readerExists(dr, "TaskDetail_ID")) { model.TaskDetail_ID = dr["TaskDetail_ID"].ToInt32(); } if (Common_Func.readerExists(dr, "SN")) { model.SN = dr["SN"].ToDBString(); } if (Common_Func.readerExists(dr, "AndalaNo")) { model.AndalaNo = dr["AndalaNo"].ToDBString(); } if (Common_Func.readerExists(dr, "FromWarehouseName")) { model.FromWarehouseName = dr["FromWarehouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "ToWarehouseName")) { model.ToWarehouseName = dr["ToWarehouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "FromHouseName")) { model.FromHouseName = dr["FromHouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "ToHouseName")) { model.ToHouseName = dr["ToHouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "FromAreaName")) { model.FromAreaName = dr["FromAreaName"].ToDBString(); } if (Common_Func.readerExists(dr, "ToAreaName")) { model.ToAreaName = dr["ToAreaName"].ToDBString(); } if (Common_Func.readerExists(dr, "StrTaskType")) { model.StrTaskType = dr["StrTaskType"].ToDBString(); } if (Common_Func.readerExists(dr, "StrVoucherType")) { model.StrVoucherType = dr["StrVoucherType"].ToDBString(); } return(model); }
private CheckDetailsInfo GetModelFromDataReader(SqlDataReader dr) { CheckDetailsInfo model = new CheckDetailsInfo(); if (Common_Func.readerExists(dr, "ID")) { model.ID = dr["ID"].ToInt32(); } if (Common_Func.readerExists(dr, "CheckID")) { model.CheckID = dr["CheckID"].ToInt32(); } if (Common_Func.readerExists(dr, "WarehouseNo")) { model.WarehouseNo = dr["WarehouseNo"].ToDBString(); } if (Common_Func.readerExists(dr, "HouseNo")) { model.HouseNo = dr["HouseNo"].ToDBString(); } if (Common_Func.readerExists(dr, "AreaNo")) { model.AreaNo = dr["AreaNo"].ToDBString(); } if (Common_Func.readerExists(dr, "MaterialNo")) { model.MaterialNo = dr["MaterialNo"].ToDBString(); } if (Common_Func.readerExists(dr, "MaterialDesc")) { model.MaterialDesc = dr["MaterialDesc"].ToDBString(); } if (Common_Func.readerExists(dr, "AccountQty")) { model.AccountQty = dr["AccountQty"].ToDecimal(); } if (Common_Func.readerExists(dr, "ScanQty")) { model.ScanQty = dr["ScanQty"].ToDecimal(); } if (Common_Func.readerExists(dr, "Status")) { model.Status = dr["Status"].ToInt32(); } if (Common_Func.readerExists(dr, "StockTime")) { model.StockTime = dr["StockTime"].ToDateTimeNull(); } if (Common_Func.readerExists(dr, "Operator")) { model.Operator = dr["Operator"].ToDBString(); } if (Common_Func.readerExists(dr, "OperationTime")) { model.OperationTime = dr["OperationTime"].ToDateTimeNull(); } if (Common_Func.readerExists(dr, "ProfitLoss")) { model.ProfitLoss = dr["ProfitLoss"].ToInt32(); } if (Common_Func.readerExists(dr, "DifferenceQty")) { model.DifferenceQty = dr["DifferenceQty"].ToDecimal(); } if (Common_Func.readerExists(dr, "IsDel")) { model.IsDel = dr["ISDEL"].ToInt32(); } if (Common_Func.readerExists(dr, "Creater")) { model.Creater = dr["CREATER"].ToDBString(); } if (Common_Func.readerExists(dr, "CreateTime")) { model.CreateTime = dr["CREATETIME"].ToDateTime(); } if (Common_Func.readerExists(dr, "Modifyer")) { model.Modifyer = dr["MODIFYER"].ToDBString(); } if (Common_Func.readerExists(dr, "ModifyTime")) { model.ModifyTime = dr["MODIFYTIME"].ToDateTimeNull(); } if (Common_Func.readerExists(dr, "WarehouseName")) { model.WarehouseName = dr["WarehouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "HouseName")) { model.HouseName = dr["HouseName"].ToDBString(); } if (Common_Func.readerExists(dr, "AreaName")) { model.AreaName = dr["AreaName"].ToDBString(); } if (Common_Func.readerExists(dr, "StrStatus")) { model.StrStatus = dr["StrStatus"].ToDBString(); } if (Common_Func.readerExists(dr, "IsChecked")) { model.BIsChecked = dr["IsChecked"].ToBoolean(); } model.StrHaveDiff = model.HaveDiff.ToBoolean() ? "有差异" : "无差异"; return(model); }
internal UserInfo GetModelFromDataReader(SqlDataReader dr) { UserInfo model = new UserInfo(); model.ID = dr["ID"].ToInt32(); model.UserNo = dr["UserNo"].ToDBString(); model.UserName = dr["UserName"].ToDBString(); model.Password = dr["Password"].ToDBString(); model.UserType = dr["UserType"].ToInt32(); model.PinYin = dr["PinYin"].ToDBString(); model.Duty = dr["Duty"].ToDBString(); model.Tel = dr["Tel"].ToDBString(); model.Mobile = dr["Mobile"].ToDBString(); model.Email = dr["Email"].ToDBString(); model.Sex = dr["Sex"].ToInt32(); model.IsPick = dr["IsPick"].ToInt32(); model.IsReceive = dr["IsReceive"].ToInt32(); model.IsQuality = dr["IsQuality"].ToInt32(); model.UserStatus = dr["UserStatus"].ToInt32(); model.Address = dr["Address"].ToDBString(); model.GroupCode = dr["GroupCode"].ToDBString(); model.WarehouseCode = dr["WarehouseCode"].ToDBString(); model.Description = dr["Description"].ToDBString(); model.LoginIP = dr["LoginIP"].ToDBString(); model.LoginTime = dr["LoginTime"].ToDateTimeNull(); if (Common_Func.readerExists(dr, "LoginDevice")) { model.LoginDevice = dr["LoginDevice"].ToDBString(); } model.IsDel = dr["ISDEL"].ToInt32(); model.Creater = dr["CREATER"].ToDBString(); model.CreateTime = dr["CREATETIME"].ToDateTime(); model.Modifyer = dr["MODIFYER"].ToDBString(); model.ModifyTime = dr["MODIFYTIME"].ToDateTimeNull(); if (Common_Func.readerExists(dr, "IsAdmin")) { model.BIsAdmin = dr["IsAdmin"].ToBoolean(); } if (Common_Func.readerExists(dr, "StrUserType")) { model.StrUserType = dr["StrUserType"].ToDBString(); } if (Common_Func.readerExists(dr, "StrUserStatus")) { model.StrUserStatus = dr["StrUserStatus"].ToDBString(); } if (Common_Func.readerExists(dr, "StrSex")) { model.StrSex = dr["StrSex"].ToDBString(); } if (Common_Func.readerExists(dr, "GroupName")) { model.GroupName = dr["GroupName"].ToDBString(); } if (Common_Func.readerExists(dr, "WarehouseName")) { model.WarehouseName = dr["WarehouseName"].ToDBString(); } model.RePassword = model.Password; model.StrIsAdmin = model.BIsAdmin ? "管理员" : "标准用户"; model.BIsPick = model.IsPick.ToBoolean(); model.BIsReceive = model.IsReceive.ToBoolean(); model.BIsQuality = model.IsQuality.ToBoolean(); model.StrIsPick = model.BIsPick ? "拣货" : "不拣货"; model.StrIsReceive = model.BIsReceive ? "收货" : "不收货"; model.StrIsQuality = model.BIsQuality ? "提示" : "不提示"; model.BIsOnline = !string.IsNullOrEmpty(model.LoginIP); model.IsOnline = model.BIsOnline.ToInt32(); return(model); }