/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="dr">The dr.</param>
public UserInfo(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.LoginID = SQLUtil.TrimNull(dr["LoginID"]);
this.LoginPwd = SQLUtil.TrimNull(dr["LoginPwd"]);
this.Name = SQLUtil.TrimNull(dr["Name"]);
this.Role.ID = SQLUtil.ConvertInt(dr["RoleID"]);
this.Role.Name = Manager.LookupManager.GetRoleDesc(this.Role.ID);
this.Mobile = SQLUtil.TrimNull(dr["Mobile"]);
this.Email = SQLUtil.TrimNull(dr["Email"]);
this.Address = SQLUtil.TrimNull(dr["Address"]);
this.IsActive = SQLUtil.ConvertBoolean(dr["IsActive"]);
this.LastLoginDate = SQLUtil.ConvertDateTime(dr["LastLoginDate"]);
this.SessionID = SQLUtil.TrimNull(dr["SessionID"]);
this.WebSessionID = SQLUtil.TrimNull(dr["WebSessionID"]);
this.CreatedDate = SQLUtil.ConvertDateTime(dr["CreatedDate"]);
this.RegistrationID = SQLUtil.TrimNull(dr["RegistrationID"]);
this.OSName = SQLUtil.TrimNull(dr["OSName"]);
this.VerifyStatus.ID = SQLUtil.ConvertInt(dr["VerifyStatus"]);
this.VerifyStatus.Name = BusinessObjects.Domain.VerifyStatus.GetVerifyStatusDesc(this.VerifyStatus.ID);
this.Comments = SQLUtil.TrimNull(dr["Comments"]);
this.Department.ID = SQLUtil.ConvertInt(dr["Department"]);
this.Department.Name = Manager.LookupManager.GetDepartmentDesc(this.Department.ID);
if (dr.Table.Columns.Contains("HasOpenDispatch"))
{
this.HasOpenDispatch = SQLUtil.ConvertBoolean(dr["HasOpenDispatch"]);
}
}
/// <summary>
/// 修改耗材信息
/// </summary>
/// <param name="info">耗材信息</param>
/// <returns>耗材id</returns>
public int UpdateConsumable(ConsumableInfo info)
{
sqlStr = "UPDATE tblConsumable Set FujiClass2ID=@FujiClass2ID,Name=@Name,Description=@Description,TypeID=@TypeID,StdPrice=@StdPrice, " +
" ReplaceTimes=@ReplaceTimes,CostPer=@CostPer,IsIncluded=@IsIncluded,IncludeContract=@IncludeContract," +
" IsActive=@IsActive,UpdateDate=GetDate() " +
" WHERE ID = @ID";
using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr))
{
command.Parameters.Add("@ID", SqlDbType.Int).Value = info.ID;
command.Parameters.Add("@FujiClass2ID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.FujiClass2.ID);
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Name);
command.Parameters.Add("@Description", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Description);
command.Parameters.Add("@TypeID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Type.ID);
command.Parameters.Add("@ReplaceTimes", SqlDbType.Decimal).Value = info.ReplaceTimes;
command.Parameters.Add("@CostPer", SqlDbType.Decimal).Value = info.CostPer;
command.Parameters.Add("@StdPrice", SqlDbType.Decimal).Value = info.StdPrice;
command.Parameters.Add("@IsIncluded", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IsIncluded);
command.Parameters.Add("@IncludeContract", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IncludeContract);
command.Parameters.Add("@IsActive", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IsActive);
command.ExecuteNonQuery();
return(info.ID);
}
}
/// <summary>
/// 获取耗材修改字段dt
/// </summary>
/// <param name="newInfo">修改后的耗材信息</param>
/// <returns>耗材修改字段dt</returns>
public DataTable GetChangedFields(ConsumableInfo newInfo)
{
DataTable dt = new DataTable();
dt.Columns.Add("FieldName");
dt.Columns.Add("OldValue");
dt.Columns.Add("NewValue");
if (this.FujiClass2.ID != newInfo.FujiClass2.ID)
{
dt.Rows.Add("ConsumableFujiClass2", SQLUtil.TrimNull(this.FujiClass2.Name), SQLUtil.TrimNull(newInfo.FujiClass2.Name));
}
if (this.Name != SQLUtil.TrimNull(newInfo.Name))
{
dt.Rows.Add("ConsumableName", this.Name, newInfo.Name);
}
if (this.Description != SQLUtil.TrimNull(newInfo.Description))
{
dt.Rows.Add("ConsumableDescription", this.Description, SQLUtil.TrimNull(newInfo.Description));
}
if (this.Type.ID != newInfo.Type.ID)
{
dt.Rows.Add("ConsumableType", this.Type.Name, LookupManager.GetConsumabletypeDesc(newInfo.Type.ID));
}
if (this.StdPrice != newInfo.StdPrice)
{
dt.Rows.Add("ConsumableStdPrice", SQLUtil.ConvertDouble(this.StdPrice), SQLUtil.ConvertDouble(newInfo.StdPrice));
}
if (this.ReplaceTimes != newInfo.ReplaceTimes)
{
dt.Rows.Add("ConsumableReplaceTimes", SQLUtil.ConvertDouble(this.ReplaceTimes), SQLUtil.ConvertDouble(newInfo.ReplaceTimes));
}
if (this.CostPer != newInfo.CostPer)
{
dt.Rows.Add("ConsumableCostPer", SQLUtil.ConvertDouble(this.CostPer), SQLUtil.ConvertDouble(newInfo.CostPer));
}
if (this.IsIncluded != newInfo.IsIncluded)
{
dt.Rows.Add("ConsumableIsIncluded", SQLUtil.ConvertBoolean(this.IsIncluded) ? "是" : "否", SQLUtil.ConvertBoolean(newInfo.IsIncluded) ? "是" : "否");
}
if (this.IncludeContract != newInfo.IncludeContract)
{
dt.Rows.Add("ConsumableIncludeContract", SQLUtil.ConvertBoolean(this.IncludeContract) ? "是" : "否", SQLUtil.ConvertBoolean(newInfo.IncludeContract) ? "是" : "否");
}
if (this.IsActive != newInfo.IsActive)
{
dt.Rows.Add("ConsumableIsActive", SQLUtil.ConvertBoolean(this.IsActive) ? "启用" : "停用", SQLUtil.ConvertBoolean(newInfo.IsActive) ? "启用" : "停用");
}
return(dt);
}
/// <summary>
/// 添加零件
/// </summary>
/// <param name="info">零件信息</param>
/// <returns>零件id</returns>
public int AddComponent(ComponentInfo info)
{
sqlStr = "INSERT INTO tblComponent(FujiClass2ID,Name,Description,TypeID,StdPrice,Usage,TotalSeconds,SecondsPer,IsIncluded,IncludeContract,MethodID,LifeTime,IsActive,AddDate) " +
" VALUES(@FujiClass2ID,@Name,@Description,@TypeID,@StdPrice,@Usage,@TotalSeconds,@SecondsPer,@IsIncluded,@IncludeContract,@MethodID,@LifeTime,@IsActive,GetDate()); " +
" SELECT @@IDENTITY ";
using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr))
{
command.Parameters.Add("@FujiClass2ID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.FujiClass2.ID);
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Name);
command.Parameters.Add("@Description", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Description);
command.Parameters.Add("@TypeID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Type.ID);
command.Parameters.Add("@StdPrice", SqlDbType.Decimal).Value = info.StdPrice;
command.Parameters.Add("@Usage", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Usage);
command.Parameters.Add("@TotalSeconds", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.TotalSeconds);
command.Parameters.Add("@SecondsPer", SqlDbType.Decimal).Value = info.SecondsPer;
command.Parameters.Add("@IsIncluded", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IsIncluded);
command.Parameters.Add("@IncludeContract", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IncludeContract);
command.Parameters.Add("@MethodID", SqlDbType.Int).Value = (int)info.Method == 0 ? FujiClass2Info.Method.Manual : info.Method;
command.Parameters.Add("@LifeTime", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.LifeTime);
command.Parameters.Add("@IsActive", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IsActive);
info.ID = SQLUtil.ConvertInt(command.ExecuteScalar());
return(info.ID);
}
}
/// <summary>
/// 获取作业报告信息
/// </summary>
/// <param name="dr">The dr.</param>
public DispatchReportInfo(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.Dispatch.ID = SQLUtil.ConvertInt(dr["DispatchID"]);
this.Type.ID = SQLUtil.ConvertInt(dr["TypeID"]);
this.Type = LookupManager.GetDispatchReportType(this.Type.ID);
this.FaultCode = SQLUtil.TrimNull(dr["FaultCode"]);
this.FaultDesc = SQLUtil.TrimNull(dr["FaultDesc"]);
this.SolutionCauseAnalysis = SQLUtil.TrimNull(dr["SolutionCauseAnalysis"]);
this.SolutionWay = SQLUtil.TrimNull(dr["SolutionWay"]);
this.IsPrivate = SQLUtil.ConvertBoolean(dr["IsPrivate"]);
this.ServiceProvider.ID = SQLUtil.ConvertInt(dr["ServiceProvider"]);
this.ServiceProvider.Name = ServiceProviders.GetDescByID(this.ServiceProvider.ID);
this.SolutionResultStatus.ID = SQLUtil.ConvertInt(dr["SolutionResultStatusID"]);
this.SolutionResultStatus.Name = LookupManager.GetSolutionResultStatusDesc(this.SolutionResultStatus.ID);
this.SolutionUnsolvedComments = SQLUtil.TrimNull(dr["SolutionUnsolvedComments"]);
this.DelayReason = SQLUtil.TrimNull(dr["DelayReason"]);
this.Comments = SQLUtil.TrimNull(dr["Comments"]);
this.FujiComments = SQLUtil.TrimNull(dr["FujiComments"]);
this.Status.ID = SQLUtil.ConvertInt(dr["StatusID"]);
this.Status.Name = LookupManager.GetDispatchDocStatusDesc(this.Status.ID);
this.PurchaseAmount = SQLUtil.ConvertDouble(dr["PurchaseAmount"]); this.ServiceScope = SQLUtil.ConvertBoolean(dr["ServiceScope"]);
this.ServiceScope = SQLUtil.ConvertBoolean(dr["ServiceScope"]);
this.Result = SQLUtil.TrimNull(dr["Result"]);
this.IsRecall = SQLUtil.ConvertBoolean(dr["IsRecall"]);
this.AcceptanceDate = SQLUtil.ConvertDateTime(dr["AcceptanceDate"]);
this.EquipmentStatus.ID = SQLUtil.ConvertInt(dr["EquipmentStatus"]);
this.EquipmentStatus.Name = MachineStatuses.GetMachineStatusesDesc(this.EquipmentStatus.ID);
}
/// <summary>
/// 修改零件信息
/// </summary>
/// <param name="info">零件信息</param>
/// <returns>零件id</returns>
public int UpdateComponent(ComponentInfo info)
{
sqlStr = "UPDATE tblComponent Set FujiClass2ID=@FujiClass2ID,Name=@Name,Description=@Description,TypeID=@TypeID,StdPrice=@StdPrice, " +
" Usage=@Usage,TotalSeconds=@TotalSeconds,SecondsPer=@SecondsPer,IsIncluded=@IsIncluded,IncludeContract=@IncludeContract," +
" MethodID=@MethodID,LifeTime=@LifeTime,IsActive=@IsActive,UpdateDate=GetDate() " +
" WHERE ID = @ID";
using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr))
{
command.Parameters.Add("@ID", SqlDbType.Int).Value = info.ID;
command.Parameters.Add("@FujiClass2ID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.FujiClass2.ID);
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Name);
command.Parameters.Add("@Description", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Description);
command.Parameters.Add("@TypeID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Type.ID);
command.Parameters.Add("@StdPrice", SqlDbType.Decimal).Value = info.StdPrice;
command.Parameters.Add("@Usage", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Usage);
command.Parameters.Add("@TotalSeconds", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.TotalSeconds);
command.Parameters.Add("@SecondsPer", SqlDbType.Decimal).Value = info.SecondsPer;
command.Parameters.Add("@IsIncluded", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IsIncluded);
command.Parameters.Add("@IncludeContract", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IncludeContract);
command.Parameters.Add("@MethodID", SqlDbType.Int).Value = (int)info.Method == 0 ? FujiClass2Info.Method.Manual : info.Method;
command.Parameters.Add("@LifeTime", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.LifeTime);
command.Parameters.Add("@IsActive", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IsActive);
command.ExecuteNonQuery();
return(info.ID);
}
}
/// <summary>
/// 估价执行：零件清单Info
/// </summary>
/// <param name="dr">数据</param>
public ValComponentInfo(DataRow dr)
: this()
{
this.User.ID = SQLUtil.ConvertInt(dr["UserID"]);
this.User.Name = SQLUtil.TrimNull(dr["UserName"]);
this.InSystem = SQLUtil.ConvertBoolean(dr["InSystem"]);
this.Equipment.ID = SQLUtil.ConvertInt(dr["EquipmentID"]);
this.Equipment.Name = SQLUtil.TrimNull(dr["Name"]);
this.Equipment.AssetCode = SQLUtil.TrimNull(dr["AssetCode"]);
this.EquipmentType.ID = SQLUtil.ConvertInt(dr["EquipmentType"]);
this.EquipmentType.Name = LookupManager.GetEquipmentTypeDesc(this.EquipmentType.ID);
this.Equipment.FujiClass2.Name = SQLUtil.TrimNull(dr["FujiClass2Name"]);
this.Component.ID = SQLUtil.ConvertInt(dr["ComponentID"]);
this.Component.Name = this.Component.ID == 0 ? ComponentType.WholeMachine : SQLUtil.TrimNull(dr["ComponentName"]);
this.Component.Type.ID = SQLUtil.ConvertInt(dr["TypeID"]);
this.Component.StdPrice = SQLUtil.ConvertDouble(dr["StdPrice"]);
this.Component.SecondsPer = SQLUtil.ConvertDouble(dr["SecondsPer"]);
this.Component.TotalSeconds = SQLUtil.ConvertInt(dr["TotalSeconds"]);
this.Component.Usage = SQLUtil.ConvertInt(dr["ComponentUsage"]);
this.Qty = SQLUtil.ConvertInt(dr["Qty"]);
this.Usage = SQLUtil.ConvertInt(dr["Usage"]);
this.Seconds = SQLUtil.ConvertDouble(dr["Seconds"]);
this.UsedSeconds = SQLUtil.ConvertDouble(dr["UsedSeconds"]);
this.IncludeContract = SQLUtil.ConvertBoolean(dr["IncludeContract"]);
this.UsageRefere = SQLUtil.ConvertInt(dr["UsageRefere"]);
if (dr.Table.Columns.Contains("UseageDate"))
{
this.UseageDate = SQLUtil.ConvertDateTime(dr["UseageDate"]);
}
}
/// <summary>
/// 获取广播信息
/// </summary>
/// <param name="dr">The dr.</param>
public NoticeInfo(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.Name = SQLUtil.TrimNull(dr["Name"]);
this.Content = SQLUtil.TrimNull(dr["Content"]);
this.Comments = SQLUtil.TrimNull(dr["Comments"]);
this.IsLoop = SQLUtil.ConvertBoolean(dr["IsLoop"]);
this.CreatedDate = SQLUtil.ConvertDateTime(dr["CreatedDate"]);
}
public UserInfo(DataRow dr) : this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.IsAdmin = SQLUtil.ConvertBoolean(dr["IsAdmin"]);
this.LoginID = SQLUtil.TrimNull(dr["LoginID"]);
this.LoginPwd = SQLUtil.TrimNull(dr["LoginPwd"]);
this.Name = SQLUtil.TrimNull(dr["Name"]);
this.Email = SQLUtil.TrimNull(dr["Email"]);
this.CreatedDate = SQLUtil.ConvertDateTime(dr["CreatedDate"]);
}
/// <summary>
/// 服务库info
/// </summary>
/// <param name="dr">dr</param>
public InvServiceInfo(DataRow dr)
: this()
{
if (dr.Table.Columns.Contains("ID"))
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
}
this.FujiClass2.ID = SQLUtil.ConvertInt(dr["FujiClass2ID"]);
if (dr.Table.Columns.Contains("FujiClass2Name"))
{
this.FujiClass2.Name = SQLUtil.TrimNull(dr["FujiClass2Name"]);
}
this.Name = SQLUtil.TrimNull(dr["Name"]);
this.TotalTimes = SQLUtil.ConvertInt(dr["TotalTimes"]);
this.Price = SQLUtil.ConvertDouble(dr["Price"]);
this.StartDate = SQLUtil.ConvertDateTime(dr["StartDate"]);
this.EndDate = SQLUtil.ConvertDateTime(dr["EndDate"]);
if (dr.Table.Columns.Contains("SupplierID"))
{
this.Supplier.ID = SQLUtil.ConvertInt(dr["SupplierID"]);
}
if (dr.Table.Columns.Contains("SupplierName"))
{
this.Supplier.Name = SQLUtil.TrimNull(dr["SupplierName"]);
}
this.Purchase.ID = SQLUtil.ConvertInt(dr["PurchaseID"]);
this.Purchase.Name = LookupManager.GetObjectOID(ObjectTypes.PurchaseOrder, this.Purchase.ID);
if (dr.Table.Columns.Contains("PurchaseDate"))
{
this.PurchaseDate = SQLUtil.ConvertDateTime(dr["PurchaseDate"]);
}
if (dr.Table.Columns.Contains("Comments"))
{
this.Comments = SQLUtil.TrimNull(dr["Comments"]);
}
if (dr.Table.Columns.Contains("AddDate"))
{
this.AddDate = SQLUtil.ConvertDateTime(dr["AddDate"]);
}
if (dr.Table.Columns.Contains("AvaibleTimes"))
{
this.AvaibleTimes = SQLUtil.ConvertInt(dr["AvaibleTimes"]);
}
if (dr.Table.Columns.Contains("UpdateDate"))
{
this.UpdateDate = SQLUtil.ConvertDateTime(dr["UpdateDate"]);
}
if (dr.Table.Columns.Contains("Inbounded"))
{
this.Inbounded = SQLUtil.ConvertBoolean(dr["Inbounded"]);
}
}
/// <summary>
/// 估价执行条件:维保对耗材的覆盖情况Info
/// </summary>
/// <param name="dr">数据</param>
public ValConsumableInfo(DataRow dr)
: this()
{
this.User.ID = SQLUtil.ConvertInt(dr["UserID"]);
this.User.Name = SQLUtil.TrimNull(dr["UserName"]);
this.Consumable.FujiClass2.ID = SQLUtil.ConvertInt(dr["FujiClass2ID"]);
this.Consumable.FujiClass2.Name = SQLUtil.TrimNull(dr["FujiClass2Name"]);
this.Consumable.ID = SQLUtil.ConvertInt(dr["ConsumableID"]);
this.Consumable.Name = SQLUtil.TrimNull(dr["ConsumableName"]);
this.Consumable.CostPer = SQLUtil.ConvertDouble(dr["CostPer"]);
this.Consumable.ReplaceTimes = SQLUtil.ConvertDouble(dr["ReplaceTimes"]);
this.IncludeContract = SQLUtil.ConvertBoolean(dr["IncludeContract"]);
}
public SupplierInfo(DataRow dr)
: this()
{
this.SupplierType.ID = SQLUtil.ConvertInt(dr["TypeID"]);
this.Name = SQLUtil.TrimNull(dr["Name"]);
this.Province = SQLUtil.TrimNull(dr["State/City"]);
this.Mobile = SQLUtil.TrimNull(dr["Phone"]);
this.Address = SQLUtil.TrimNull(dr["Address"]);
this.Contact = SQLUtil.TrimNull(dr["ContactPerson"]);
this.ContactMobile = SQLUtil.TrimNull(dr["ContactPhone"]);
this.AddDate = SQLUtil.ConvertDateTime(dr["AddDate"]);
this.IsActive = SQLUtil.ConvertBoolean(dr["Status"]);
}
/// <summary>
/// 获取修改的字段
/// </summary>
/// <param name="newInfo">修改后的信息</param>
/// <returns>修改的字段</returns>
public DataTable GetChangedFields(SupplierInfo newInfo)
{
DataTable dt = new DataTable();
dt.Columns.Add("FieldName");
dt.Columns.Add("OldValue");
dt.Columns.Add("NewValue");
if (this.SupplierType.ID != newInfo.SupplierType.ID)
{
dt.Rows.Add("SupplierType", this.SupplierType.Name, Manager.LookupManager.GetSupplierTypeDesc(newInfo.SupplierType.ID));
}
if (this.Name != SQLUtil.TrimNull(newInfo.Name))
{
dt.Rows.Add("SupplierName", this.Name, newInfo.Name == null ? "" : newInfo.Name);
}
if (this.Province != SQLUtil.TrimNull(newInfo.Province))
{
dt.Rows.Add("SupplierProvince", this.Province, newInfo.Province == null ? "" : newInfo.Province);
}
if (this.Mobile != SQLUtil.TrimNull(newInfo.Mobile))
{
dt.Rows.Add("SupplierMobile", this.Mobile, newInfo.Mobile == null ? "" : newInfo.Mobile);
}
if (this.Address != SQLUtil.TrimNull(newInfo.Address))
{
dt.Rows.Add("SupplierAddress", this.Address, newInfo.Address == null ? "" : newInfo.Address);
}
if (this.Contact != SQLUtil.TrimNull(newInfo.Contact))
{
dt.Rows.Add("SupplierContact", this.Contact, newInfo.Contact == null ? "" : newInfo.Contact);
}
if (this.ContactMobile != SQLUtil.TrimNull(newInfo.ContactMobile))
{
dt.Rows.Add("SupplierContactMobile", this.ContactMobile, newInfo.ContactMobile == null ? "" : newInfo.ContactMobile);
}
if (this.IsActive != newInfo.IsActive)
{
dt.Rows.Add("SupplierStatus", SQLUtil.ConvertBoolean(this.IsActive) ? "启用" : "停用", SQLUtil.ConvertBoolean(newInfo.IsActive) ? "启用" : "停用");
}
return(dt);
}
/// <summary>
/// 获取供应商信息
/// </summary>
/// <param name="dr">The dr.</param>
public SupplierInfo(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.SupplierType.ID = SQLUtil.ConvertInt(dr["TypeID"]);
this.SupplierType.Name = Manager.LookupManager.GetSupplierTypeDesc(this.SupplierType.ID);
this.Name = SQLUtil.TrimNull(dr["Name"]);
this.Province = SQLUtil.TrimNull(dr["Province"]);
this.Mobile = SQLUtil.TrimNull(dr["Mobile"]);
this.Address = SQLUtil.TrimNull(dr["Address"]);
this.Contact = SQLUtil.TrimNull(dr["Contact"]);
this.ContactMobile = SQLUtil.TrimNull(dr["ContactMobile"]);
this.AddDate = SQLUtil.ConvertDateTime(dr["AddDate"]);
this.IsActive = SQLUtil.ConvertBoolean(dr["IsActive"]);
}
/// <summary>
/// 获取系统信息
/// </summary>
/// <param name="dr">The dr.</param>
public SmtpInfo(DataRow dr)
: this()
{
this.AdminEmail = SQLUtil.TrimNull(dr["AdminEmail"]);
this.Host = SQLUtil.TrimNull(dr["SmtpHost"]);
this.Port = SQLUtil.ConvertInt(dr["SmtpPort"]);
this.UseSsl = SQLUtil.ConvertBoolean(dr["SmtpUseSsl"]);
this.UserName = SQLUtil.TrimNull(dr["SmtpUserName"]);
this.Pwd = SQLUtil.TrimNull(dr["SmtpPwd"]);
this.EmailFrom = SQLUtil.TrimNull(dr["SmtpEmailFrom"]);
this.MessageKey = SQLUtil.TrimNull(dr["MessageKey"]);
this.MessageEnabled = SQLUtil.ConvertBoolean(dr["MessageEnabled"]);
this.AppValidVersion = SQLUtil.TrimNull(dr["AppValidVersion"]);
this.MobilePhone = SQLUtil.TrimNull(dr["MobilePhone"]);
}
public EquipmentInfo(DataRow dr)
: this()
{
this.EquipmentLevel.ID = SQLUtil.ConvertInt(dr["EquipmentLevel"]);
this.Name = SQLUtil.TrimNull(dr["Name"]);
this.EquipmentCode = SQLUtil.TrimNull(dr["Model"]);
this.SerialCode = SQLUtil.TrimNull(dr["SerialNo#"]);
this.ManufacturerID = SQLUtil.ConvertInt(dr["ManufacturerID"]);
this.EquipmentClass1 = SQLUtil.ConvertInt(dr["EquipmentClass1"]);
this.EquipmentClass2 = SQLUtil.ConvertInt(dr["EquipmentClass2"]);
this.EquipmentClass3 = SQLUtil.ConvertInt(dr["EquipmentClass3"]);
this.ResponseTimeLength = SQLUtil.ConvertInt(dr["StandardResponseTime(minutes)"]);
this.FixedAsset = SQLUtil.ConvertBoolean(dr["FixedAsset"]);
this.AssetCode = SQLUtil.TrimNull(dr["AssetNumber"]);
this.AssetLevel.ID = SQLUtil.ConvertInt(dr["AssetClassID"]);
this.DepreciationYears = SQLUtil.ConvertInt(dr["DepreciationYears"]);
this.ValidityStartDate = SQLUtil.ConvertDateTime(dr["DurationofCertificateStartDate"]);
this.ValidityEndDate = SQLUtil.ConvertDateTime(dr["DurationofCertificateEndDate"]);
this.SaleContractName = SQLUtil.TrimNull(dr["SalesContract"]);
this.SupplierID = SQLUtil.ConvertInt(dr["DealerID"]);
this.PurchaseWay = SQLUtil.TrimNull(dr["PurchaseType"]);
this.PurchaseAmount = SQLUtil.ConvertDouble(dr["PurchaseAmount"]);
this.PurchaseDate = SQLUtil.ConvertDateTime(dr["PurchaseDate"]);
this.IsImport = SQLUtil.ConvertBoolean(dr["ProductionDistrict"]);
this.Department.ID = SQLUtil.ConvertInt(dr["DepartmentID"]);
this.InstalSite = SQLUtil.TrimNull(dr["InstallationLocation"]);
this.InstalStartDate = SQLUtil.ConvertDateTime(dr["InstalStartDate"]);
this.InstalEndDate = SQLUtil.ConvertDateTime(dr["InstalEndDate"]);
this.Accepted = SQLUtil.ConvertBoolean(dr["AcceptanceStatus"]);
this.AcceptanceDate = SQLUtil.ConvertDateTime(dr["AcceptanceDate"]);
this.UsageStatus.ID = SQLUtil.ConvertInt(dr["StatusofUse"]);
this.EquipmentStatus.ID = SQLUtil.ConvertInt(dr["EquipmentStatusID"]);
this.ScrapDate = SQLUtil.ConvertDateTime(dr["DisposalDate"]);
this.MaintenancePeriod = SQLUtil.ConvertInt(dr["MaintenancePeriod"]);
this.MaintenanceType.ID = SQLUtil.ConvertInt(dr["MaintenanceTypeID"]);
this.PatrolPeriod = SQLUtil.ConvertInt(dr["PatrolPeriod"]);
this.PatrolType.ID = SQLUtil.ConvertInt(dr["PatrolTypeID"]);
this.CorrectionPeriod = SQLUtil.ConvertInt(dr["CalibrationPeriod"]);
this.CorrectionType.ID = SQLUtil.ConvertInt(dr["CalibrationTypeID"]);
this.MandatoryTestStatus.ID = SQLUtil.ConvertInt(dr["InspectionFlag"]);
this.MandatoryTestDate = SQLUtil.ConvertDateTime(dr["InspectionDate"]);
this.RecallFlag = SQLUtil.ConvertBoolean(dr["RecallFlag"]);
this.RecallDate = SQLUtil.ConvertDateTime(dr["RecallDate"]);
this.CreateDate = SQLUtil.ConvertDateTime(dr["CreateDate"]);
this.CreateUserID = SQLUtil.ConvertInt(dr["CreateUserID"]);
}
public DispatchReportInfo(DataRow dr)
: this()
{
this.DispatchID = SQLUtil.ConvertInt(dr["DispatchID"]);
this.Type.ID = SQLUtil.ConvertInt(dr["ReportTypeID"]);
this.FaultCode = SQLUtil.TrimNull(dr["ErrorCode"]);
this.FaultDesc = SQLUtil.TrimNull(dr["FaultDescription"]);
this.SolutionCauseAnalysis = SQLUtil.TrimNull(dr["Reason"]);
this.SolutionWay = SQLUtil.TrimNull(dr["Solution"]);
this.IsPrivate = SQLUtil.ConvertBoolean(dr["SpecialFormat"]);
this.ServiceProvider.ID = SQLUtil.ConvertInt(dr["ServiceProvider"]);
this.SolutionResultStatus.ID = SQLUtil.ConvertInt(dr["WorkSummaryID"]);
this.SolutionUnsolvedComments = SQLUtil.TrimNull(dr["ProblemEscalation"]);
this.DelayReason = SQLUtil.TrimNull(dr["MissedworkNote"]);
this.Comments = SQLUtil.TrimNull(dr["Note"]);
this.FujiComments = SQLUtil.TrimNull(dr["ReviewNote"]);
this.Status.ID = SQLUtil.ConvertInt(dr["ServiceReportStatusID"]);
}
/// <summary>
/// 获取服务凭证信息
/// </summary>
/// <param name="dr">The dr.</param>
public DispatchJournalInfo(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.Dispatch.ID = SQLUtil.ConvertInt(dr["DispatchID"]);
this.FaultCode = SQLUtil.TrimNull(dr["FaultCode"]);
this.JobContent = SQLUtil.TrimNull(dr["JobContent"]);
this.FollowProblem = SQLUtil.TrimNull(dr["FollowProblem"]);
this.Advice = SQLUtil.TrimNull(dr["Advice"]);
this.UserName = SQLUtil.TrimNull(dr["UserName"]);
this.UserMobile = SQLUtil.TrimNull(dr["UserMobile"]);
this.Signed = SQLUtil.ConvertBoolean(dr["Signed"]);
this.Status.ID = SQLUtil.ConvertInt(dr["StatusID"]);
this.Status.Name = LookupManager.GetDispatchDocStatusDesc(this.Status.ID);
this.ResultStatus.ID = SQLUtil.ConvertInt(dr["ResultStatusID"]);
this.ResultStatus.Name = LookupManager.GetDispatchJournalResultStatusDesc(this.ResultStatus.ID);
this.FujiComments = SQLUtil.TrimNull(dr["FujiComments"]);
}
/// <summary>
/// 耗材info
/// </summary>
/// <param name="dr">dr</param>
public ConsumableInfo(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.FujiClass2.ID = SQLUtil.ConvertInt(dr["FujiClass2ID"]);
this.FujiClass2.Name = SQLUtil.TrimNull(dr["FujiClass2Name"]);
this.Name = SQLUtil.TrimNull(dr["Name"]);
this.Description = SQLUtil.TrimNull(dr["Description"]);
this.Type.ID = SQLUtil.ConvertInt(dr["TypeID"]);
this.Type.Name = LookupManager.GetConsumabletypeDesc(this.Type.ID);
this.ReplaceTimes = SQLUtil.ConvertDouble(dr["ReplaceTimes"]);
this.CostPer = SQLUtil.ConvertDouble(dr["CostPer"]);
this.StdPrice = SQLUtil.ConvertDouble(dr["StdPrice"]);
this.IsIncluded = SQLUtil.ConvertBoolean(dr["IsIncluded"]);
this.IncludeContract = SQLUtil.ConvertBoolean(dr["IncludeContract"]);
this.IsActive = SQLUtil.ConvertBoolean(dr["IsActive"]);
this.AddDate = SQLUtil.ConvertDateTime(dr["AddDate"]);
this.UpdateDate = SQLUtil.ConvertDateTime(dr["UpdateDate"]);
}
/// <summary>
/// 估价执行条件：设备清单Info
/// </summary>
/// <param name="dr"></param>
public ValEquipmentInfo(DataRow dr)
: this()
{
this.User.ID = SQLUtil.ConvertInt(dr["UserID"]);
this.User.Name = SQLUtil.TrimNull(dr["UserName"]);
this.Equipment.ID = SQLUtil.ConvertInt(dr["EquipmentID"]);
this.Equipment.AssetCode = SQLUtil.TrimNull(dr["AssetCode"]);
this.Equipment.Name = SQLUtil.TrimNull(dr["Name"]);
this.Equipment.SerialCode = SQLUtil.TrimNull(dr["SerialCode"]);
this.Equipment.Manufacturer.Name = SQLUtil.TrimNull(dr["Manufacturer"]);
this.Equipment.FujiClass2.ID = SQLUtil.ConvertInt(dr["FujiClass2ID"]);
this.Equipment.FujiClass2.Name = SQLUtil.TrimNull(dr["FujiClass2Name"]);
this.Equipment.FujiClass2.FujiClass1.ID = SQLUtil.ConvertInt(dr["FujiClass1ID"]);
this.Equipment.FujiClass2.FujiClass1.Name = SQLUtil.TrimNull(dr["FujiClass1Name"]);
if (dr.Table.Columns.Contains("EquipmentTypeID"))
{
this.Equipment.FujiClass2.EquipmentType.ID = SQLUtil.ConvertInt(dr["EquipmentTypeID"]);
this.Equipment.FujiClass2.EquipmentType.Name = LookupManager.GetEquipmentTypeDesc(this.Equipment.FujiClass2.EquipmentType.ID);
}
if (dr.Table.Columns.Contains("FullCoveragePtg"))
{
this.Equipment.FujiClass2.FullCoveragePtg = SQLUtil.ConvertDouble(dr["FullCoveragePtg"]);
}
if (dr.Table.Columns.Contains("TechCoveragePtg"))
{
this.Equipment.FujiClass2.TechCoveragePtg = SQLUtil.ConvertDouble(dr["TechCoveragePtg"]);
}
this.Equipment.Department.Name = SQLUtil.TrimNull(dr["Department"]);
this.Equipment.PurchaseAmount = SQLUtil.ConvertDouble(dr["PurchaseAmount"]);
this.Equipment.UseageDate = SQLUtil.ConvertDateTime(dr["UseageDate"]);
this.CurrentScope.ID = SQLUtil.ConvertInt(dr["CurrentScopeID"]);
this.CurrentScope.Name = ScopeTypes.GetScopeDesc(this.CurrentScope.ID);
this.NextScope.ID = SQLUtil.ConvertInt(dr["NextScopeID"]);
this.NextScope.Name = ScopeTypes.GetScopeDesc(this.NextScope.ID);
this.EndDate = SQLUtil.ConvertDateTime(dr["EndDate"]);
this.InSystem = SQLUtil.ConvertBoolean(dr["InSystem"]);
this.PatrolHours = SQLUtil.ConvertDouble(dr["PatrolHours"]);
this.MaintenanceHours = SQLUtil.ConvertDouble(dr["MaintenanceHours"]);
this.RepairHours = SQLUtil.ConvertDouble(dr["RepairHours"]);
}
/// <summary>
/// 获取作业报告报表的部分字段描述信息
/// </summary>
/// <param name="dr">报表所有字段信息</param>
/// <param name="fieldsInRpt">选取的报表字段</param>
/// <returns>报表信息</returns>
public DataRow GetDispatchReportDesc(DataRow dr, List <string> fieldsInRpt)
{
if (SQLUtil.ConvertInt(dr["ReportID"]) != 0)
{
if (fieldsInRpt.Contains("ReportTypeDesc"))
{
dr["ReportTypeDesc"] = LookupManager.GetDispatchReportType(SQLUtil.ConvertInt(dr["TypeID"])).Name;
}
if (fieldsInRpt.Contains("ReportStatusDesc"))
{
dr["ReportStatusDesc"] = LookupManager.GetDispatchDocStatusDesc(SQLUtil.ConvertInt(dr["DispatchReportStatusID"]));
}
if (fieldsInRpt.Contains("ServiceProviderDesc"))
{
dr["ServiceProviderDesc"] = DispatchReportInfo.ServiceProviders.GetDescByID(SQLUtil.ConvertInt(dr["ServiceProvider"]));
}
if (fieldsInRpt.Contains("ReportEquipmentStatusDesc"))
{
dr["ReportEquipmentStatusDesc"] = LookupManager.GetEquipmentStatusDesc(SQLUtil.ConvertInt(dr["reportEquipmentStatus"]));
}
if (fieldsInRpt.Contains("ServiceScopeDesc"))
{
dr["ServiceScopeDesc"] = SQLUtil.ConvertBoolean(dr["ServiceScope"]) ? "是" : "否";
}
if (fieldsInRpt.Contains("SolutionResultStatusDesc"))
{
dr["SolutionResultStatusDesc"] = LookupManager.GetSolutionResultStatusDesc(SQLUtil.ConvertInt(dr["SolutionResultStatusID"]));
}
if (fieldsInRpt.Contains("ReportIsRecallDesc"))
{
dr["ReportIsRecallDesc"] = SQLUtil.ConvertBoolean(dr["ReportIsRecall"]) ? "是" : "否";
}
if (fieldsInRpt.Contains("IsPrivateDesc"))
{
dr["IsPrivateDesc"] = SQLUtil.ConvertBoolean(dr["IsPrivate"]) ? "是" : "否";
}
}
return(dr);
}
/// <summary>
/// 获取服务凭证报表的部分字段描述信息
/// </summary>
/// <param name="dr">报表所有字段信息</param>
/// <param name="fieldsInRpt">选取的报表字段</param>
/// <returns>报表信息</returns>
public DataRow GetDispatchJournalDesc(DataRow dr, List <string> fieldsInRpt)
{
if (SQLUtil.ConvertInt(dr["JournalID"]) != 0)
{
if (fieldsInRpt.Contains("ResultStatusDesc"))
{
dr["ResultStatusDesc"] = LookupManager.GetDispatchJournalResultStatusDesc(SQLUtil.ConvertInt(dr["ResultStatusID"]));
}
if (fieldsInRpt.Contains("SignedDesc"))
{
dr["SignedDesc"] = (SQLUtil.ConvertInt(dr["JournalID"]) > 0) ? (SQLUtil.ConvertBoolean(dr["Signed"]) ? "是" : "否") : "";
}
if (fieldsInRpt.Contains("JournalStatusDesc"))
{
dr["JournalStatusDesc"] = LookupManager.GetDispatchDocStatusDesc(SQLUtil.ConvertInt(dr["DispatchJournalStatusID"]));
}
}
return(dr);
}
/// <summary>
/// 获取合同报表的部分字段描述信息
/// </summary>
/// <param name="dr">报表所有字段信息</param>
/// <param name="fieldsInRpt">选取的报表字段</param>
/// <returns>报表信息</returns>
public DataRow GetContractDesc(DataRow dr, List <string> fieldsInRpt)
{
if (fieldsInRpt.Contains("TypeDesc"))
{
dr["TypeDesc"] = LookupManager.GetContractTypeDesc(SQLUtil.ConvertInt(dr["TypeID"]));
}
if (fieldsInRpt.Contains("ScopeDesc"))
{
dr["ScopeDesc"] = LookupManager.GetContractScopeDesc(SQLUtil.ConvertInt(dr["ScopeID"]));
}
if (fieldsInRpt.Contains("SupplierType"))
{
dr["SupplierType"] = LookupManager.GetSupplierTypeDesc(SQLUtil.ConvertInt(dr["SupplierTypeID"]));
}
if (fieldsInRpt.Contains("SupplierStatus"))
{
dr["SupplierStatus"] = SQLUtil.ConvertBoolean(dr["SupplierStatusID"]) ? "启用" : "停用";
}
return(dr);
}
/// <summary>
/// 富士II类info
/// </summary>
/// <param name="dr">dr</param>
public FujiClass2Info(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.Name = SQLUtil.TrimNull(dr["Name"]);
this.Description = SQLUtil.TrimNull(dr["Description"]);
this.FujiClass1.ID = SQLUtil.ConvertInt(dr["FujiClass1ID"]);
if (dr.Table.Columns.Contains("FujiClass1Name"))
{
this.FujiClass1.Name = SQLUtil.TrimNull(dr["FujiClass1Name"]);
}
this.IncludeLabour = SQLUtil.ConvertBoolean(dr["IncludeLabour"]);
this.PatrolTimes = SQLUtil.ConvertDouble(dr["PatrolTimes"]);
this.PatrolHours = SQLUtil.ConvertDouble(dr["PatrolHours"]);
this.MaintenanceTimes = SQLUtil.ConvertDouble(dr["MaintenanceTimes"]);
this.MaintenanceHours = SQLUtil.ConvertDouble(dr["MaintenanceHours"]);
this.RepairHours = SQLUtil.ConvertDouble(dr["RepairHours"]);
this.IncludeContract = SQLUtil.ConvertBoolean(dr["IncludeContract"]);
this.FullCoveragePtg = SQLUtil.ConvertDouble(dr["FullCoveragePtg"]);
this.TechCoveragePtg = SQLUtil.ConvertDouble(dr["TechCoveragePtg"]);
this.IncludeSpare = SQLUtil.ConvertBoolean(dr["IncludeSpare"]);
this.SparePrice = SQLUtil.ConvertDouble(dr["SparePrice"]);
this.SpareRentPtg = SQLUtil.ConvertDouble(dr["SpareRentPtg"]);
this.IncludeRepair = SQLUtil.ConvertBoolean(dr["IncludeRepair"]);
this.Usage = SQLUtil.ConvertInt(dr["Usage"]);
this.EquipmentType.ID = SQLUtil.ConvertInt(dr["EquipmentType"]);
this.EquipmentType.Name = LookupManager.GetEquipmentTypeDesc(this.EquipmentType.ID);
this.RepairComponentCost = SQLUtil.ConvertDouble(dr["RepairComponentCost"]);
this.Repair3partyRatio = SQLUtil.ConvertDouble(dr["Repair3partyRatio"]);
this.Repair3partyCost = SQLUtil.ConvertDouble(dr["Repair3partyCost"]);
this.RepairCostRatio = SQLUtil.ConvertDouble(dr["RepairCostRatio"]);
this.MethodID = SQLUtil.ConvertEnum <Method>(dr["MethodID"]);
this.AddDate = SQLUtil.ConvertDateTime(dr["AddDate"]);
this.UpdateDate = SQLUtil.ConvertDateTime(dr["UpdateDate"]);
}
public RequestInfo(DataRow dr)
: this()
{
this.Source.ID = SQLUtil.ConvertInt(dr["Category"]);
this.IsRecall = SQLUtil.ConvertBoolean(dr["IsRecall"]);
this.RequestType.ID = SQLUtil.ConvertInt(dr["RequestType"]);
this.RequestUser.ID = SQLUtil.ConvertInt(dr["CustomerID"]);
this.RequestUser.Name = SQLUtil.TrimNull(dr["CustomerName"]);
this.RequestUser.Mobile = SQLUtil.TrimNull(dr["CustomerMobile"]);
this.Subject = SQLUtil.TrimNull(dr["Subject"]);
this.FaultDesc = SQLUtil.TrimNull(dr["FaultDescription"]);
this.MachineStatus.ID = SQLUtil.ConvertInt(dr["EquipmentStatusID"]);
this.FaultType.ID = SQLUtil.ConvertInt(dr["FaultTypeID"]);
this.Status.ID = SQLUtil.ConvertInt(dr["RequestStatusID"]);
this.DealType.ID = SQLUtil.ConvertInt(dr["SolutionID"]);
this.Priority.ID = SQLUtil.ConvertInt(dr["EmergencyLevelID"]);
this.RequestDate = SQLUtil.ConvertDateTime(dr["RequestDate"]);
this.DistributeDate = SQLUtil.ConvertDateTime(dr["DistributeDate"]);
this.ResponseDate = SQLUtil.ConvertDateTime(dr["ResponseDate"]);
this.CloseDate = SQLUtil.ConvertDateTime(dr["CloseDate"]);
this.SelectiveDate = SQLUtil.ConvertDateTime(dr["RescheduledDate"]);
}
/// <summary>
/// 估价前提条件Info
/// </summary>
/// <param name="dr">数据</param>
public ValControlInfo(DataRow dr)
: this()
{
this.CtlFlag = SQLUtil.TrimNull(dr["CtlFlag"]);
this.User.ID = SQLUtil.ConvertInt(dr["UserID"]);
this.UpdateDate = SQLUtil.ConvertDateTime(dr["UpdateDate"]);
this.IsExecuted = SQLUtil.ConvertBoolean(dr["IsExecuted"]);
this.EndDate = SQLUtil.ConvertDateTime(dr["EndDate"]);
this.ContractStartDate = SQLUtil.ConvertDateTime(dr["ContractStartDate"]);
this.Years = SQLUtil.ConvertInt(dr["Years"]);
this.HospitalLevel.ID = SQLUtil.ConvertInt(dr["HospitalLevel"]);
this.ImportCost = SQLUtil.ConvertDouble(dr["ImportCost"]);
this.ProfitMargins = SQLUtil.ConvertDouble(dr["ProfitMargins"]);
this.RiskRatio = SQLUtil.ConvertDouble(dr["RiskRatio"]);
this.VarAmount = SQLUtil.ConvertDouble(dr["VarAmount"]);
this.ComputeEngineer = SQLUtil.ConvertInt(dr["ComputeEngineer"]);
this.ForecastEngineer = SQLUtil.ConvertInt(dr["ForecastEngineer"]);
this.HospitalFactor1 = SQLUtil.ConvertDouble(dr["HospitalFactor1"]);
this.HospitalFactor2 = SQLUtil.ConvertDouble(dr["HospitalFactor2"]);
this.HospitalFactor3 = SQLUtil.ConvertDouble(dr["HospitalFactor3"]);
}
/// <summary>
/// 零件info
/// </summary>
/// <param name="dr">dr</param>
public ComponentInfo(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.FujiClass2.ID = SQLUtil.ConvertInt(dr["FujiClass2ID"]);
this.FujiClass2.Name = SQLUtil.TrimNull(dr["FujiClass2Name"]);
this.Name = SQLUtil.TrimNull(dr["Name"]);
this.Description = SQLUtil.TrimNull(dr["Description"]);
this.Type.ID = SQLUtil.ConvertInt(dr["TypeID"]);
this.Type.Name = LookupManager.GetComponentTypeDesc(this.Type.ID);
this.StdPrice = SQLUtil.ConvertDouble(dr["StdPrice"]);
this.Usage = SQLUtil.ConvertInt(dr["Usage"]);
this.TotalSeconds = SQLUtil.ConvertInt(dr["TotalSeconds"]);
this.SecondsPer = SQLUtil.ConvertDouble(dr["SecondsPer"]);
this.IsIncluded = SQLUtil.ConvertBoolean(dr["IsIncluded"]);
this.IncludeContract = SQLUtil.ConvertBoolean(dr["IncludeContract"]);
this.Method = SQLUtil.ConvertEnum <FujiClass2Info.Method>(dr["MethodID"]);
this.LifeTime = SQLUtil.ConvertInt(dr["LifeTime"]);
this.IsActive = SQLUtil.ConvertBoolean(dr["IsActive"]);
this.AddDate = SQLUtil.ConvertDateTime(dr["AddDate"]);
this.UpdateDate = SQLUtil.ConvertDateTime(dr["UpdateDate"]);
}
/// <summary>
/// 富士类别关联信息
/// </summary>
/// <param name="dr">dr</param>
public FujiClassLink(DataRow dr)
: this()
{
this.FujiClass2.ID = SQLUtil.ConvertInt(dr["ID"]);
this.FujiClass2.Name = SQLUtil.TrimNull(dr["Name"]);
this.FujiClass2.Description = SQLUtil.TrimNull(dr["Description"]);
if (dr.Table.Columns.Contains("EquipmentType1ID"))
{
this.EquipmentType1.Code = SQLUtil.TrimNull(dr["EquipmentType1ID"]);
this.EquipmentType1.Description = LookupManager.GetEquipmentClassDesc(this.EquipmentType1.Code, 1);
}
if (dr.Table.Columns.Contains("EquipmentType2ID"))
{
this.EquipmentType2.Code = SQLUtil.TrimNull(dr["EquipmentType2ID"]);
this.EquipmentType2.Description = LookupManager.GetEquipmentClassDesc(this.EquipmentType2.Code, 2, this.EquipmentType1.Code);
}
if (dr.Table.Columns.Contains("FujiClass1ID"))
{
this.FujiClass2.FujiClass1.ID = SQLUtil.ConvertInt(dr["FujiClass1ID"]);
}
if (dr.Table.Columns.Contains("FujiClass1Name"))
{
this.FujiClass2.FujiClass1.Name = SQLUtil.TrimNull(dr["FujiClass1Name"]);
}
if (dr.Table.Columns.Contains("FujiClass1Description"))
{
this.FujiClass2.FujiClass1.Description = SQLUtil.TrimNull(dr["FujiClass1Description"]);
}
if (dr.Table.Columns.Contains("FujiClass2Count"))
{
this.FujiClass2.FujiClass1.FujiClass2Count = SQLUtil.ConvertInt(dr["FujiClass2Count"]);
}
if (dr.Table.Columns.Contains("hasEdited"))
{
this.FujiClass2.hasEdited = SQLUtil.ConvertBoolean(dr["hasEdited"]);
}
}
/// <summary>
/// 获取请求信息
/// </summary>
/// <param name="dr">The dr.</param>
public RequestInfo(DataRow dr)
: this()
{
this.ID = SQLUtil.ConvertInt(dr["ID"]);
this.Source.ID = SQLUtil.ConvertInt(dr["Source"]);
this.Source.Name = Sources.GetSourceDesc(this.Source.ID);
this.RequestType.ID = SQLUtil.ConvertInt(dr["RequestType"]);
this.RequestType.Name = Manager.LookupManager.GetRequestTypeDesc(this.RequestType.ID);
this.RequestUser.ID = SQLUtil.ConvertInt(dr["RequestUserID"]);
this.RequestUser.Name = SQLUtil.TrimNull(dr["RequestUserName"]);
this.RequestUser.Mobile = SQLUtil.TrimNull(dr["RequestUserMobile"]);
if (dr.Table.Columns.Contains("RequestUserRoleID"))
{
this.RequestUser.Role.Name = Manager.LookupManager.GetRoleDesc(SQLUtil.ConvertInt(dr["RequestUserRoleID"]));
}
this.Subject = SQLUtil.TrimNull(dr["Subject"]);
this.FaultDesc = SQLUtil.TrimNull(dr["FaultDesc"]);
this.MachineStatus.ID = SQLUtil.ConvertInt(dr["EquipmentStatus"]);
this.MachineStatus.Name = MachineStatuses.GetMachineStatusesDesc(this.MachineStatus.ID);
this.FaultType.ID = SQLUtil.ConvertInt(dr["FaultTypeID"]);
this.FaultType.Name = RequestTypes.GetFaultTypeDesc(this.RequestType.ID, this.FaultType.ID);
this.Status.ID = SQLUtil.ConvertInt(dr["StatusID"]);
this.Status.Name = Manager.LookupManager.GetRequestStatusDesc(this.Status.ID);
this.DealType.ID = SQLUtil.ConvertInt(dr["DealTypeID"]);
this.DealType.Name = Manager.LookupManager.GetDealTypeDesc(this.DealType.ID);
this.Priority.ID = SQLUtil.ConvertInt(dr["PriorityID"]);
this.Priority.Name = Manager.LookupManager.GetUrgencyDesc(this.Priority.ID);
this.RequestDate = SQLUtil.ConvertDateTime(dr["RequestDate"]);
this.DistributeDate = SQLUtil.ConvertDateTime(dr["DistributeDate"]);
this.DispatchDate = SQLUtil.ConvertDateTime(dr["DispatchDate"]);
this.ResponseDate = SQLUtil.ConvertDateTime(dr["ResponseDate"]);
this.CloseDate = SQLUtil.ConvertDateTime(dr["CloseDate"]);
this.LastStatus.ID = SQLUtil.ConvertInt(dr["LastStatusID"]);
this.LastStatus.Name = Manager.LookupManager.GetRequestStatusDesc(this.LastStatus.ID);
this.IsRecall = SQLUtil.ConvertBoolean(dr["IsRecall"]);
this.SelectiveDate = SQLUtil.ConvertDateTime(dr["SelectiveDate"]);
}
/// <summary>
/// 添加耗材
/// </summary>
/// <param name="info">耗材信息</param>
/// <returns>耗材id</returns>
public int AddConsumable(ConsumableInfo info)
{
sqlStr = "INSERT INTO tblConsumable(FujiClass2ID,Name,Description,TypeID,ReplaceTimes, CostPer,StdPrice,IsIncluded,IncludeContract,IsActive,AddDate) " +
" VALUES(@FujiClass2ID,@Name,@Description,@TypeID,@ReplaceTimes,@CostPer,@StdPrice,@IsIncluded,@IncludeContract,@IsActive,GetDate()); " +
" SELECT @@IDENTITY ";
using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr))
{
command.Parameters.Add("@FujiClass2ID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.FujiClass2.ID);
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Name);
command.Parameters.Add("@Description", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Description);
command.Parameters.Add("@TypeID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Type.ID);
command.Parameters.Add("@ReplaceTimes", SqlDbType.Decimal).Value = info.ReplaceTimes;
command.Parameters.Add("@CostPer", SqlDbType.Decimal).Value = info.CostPer;
command.Parameters.Add("@StdPrice", SqlDbType.Decimal).Value = info.StdPrice;
command.Parameters.Add("@IsIncluded", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IsIncluded);
command.Parameters.Add("@IncludeContract", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IncludeContract);
command.Parameters.Add("@IsActive", SqlDbType.Bit).Value = SQLUtil.ConvertBoolean(info.IsActive);
info.ID = SQLUtil.ConvertInt(command.ExecuteScalar());
return(info.ID);
}
}
