private FacilityInfo GetFacilitiesValues(DataRow dr) { FacilityInfo Facility = new FacilityInfo(); Facility.FacilityId = Convert.ToInt32(dr["FacilityId"]); if (!dr.IsNull("FacilityTypeId")) { Facility.FacilityTypeId = Convert.ToInt32(dr["FacilityTypeId"]); } if (!dr.IsNull("FacilityTypeName")) { Facility.FacilityTypeName = Convert.ToString(dr["FacilityTypeName"]); } if (!dr.IsNull("FacilityName")) { Facility.FacilityName = Convert.ToString(dr["FacilityName"]); } if (!dr.IsNull("IsActive")) { Facility.IsActive = Convert.ToBoolean(dr["IsActive"]); } return(Facility); }
public List <SqlParameter> SetValuesInFacility(FacilityInfo facility) { List <SqlParameter> sqlParam = new List <SqlParameter>(); if (facility.FacilityId != 0) { sqlParam.Add(new SqlParameter("FacilityId", facility.FacilityId)); } else { sqlParam.Add(new SqlParameter("CreatedDate", facility.CreatedDate)); sqlParam.Add(new SqlParameter("CreatedBy", facility.CreatedBy)); } sqlParam.Add(new SqlParameter("FacilityTypeId", facility.FacilityTypeId)); Logger.Debug("Facility Controller FacilityTypeId:" + facility.FacilityTypeId); sqlParam.Add(new SqlParameter("FacilityName", facility.FacilityName)); Logger.Debug("Facility Controller FacilityName:" + facility.FacilityName); sqlParam.Add(new SqlParameter("IsActive", facility.IsActive)); Logger.Debug("Facility Controller IsActive:" + facility.IsActive); sqlParam.Add(new SqlParameter("UpdatedBy", facility.UpdatedBy)); sqlParam.Add(new SqlParameter("UpdatedDate", facility.UpdatedDate)); return(sqlParam); }
public FacilityInfo AddFacilityInfo(GameObject Object) { FacilityInfo newFacility = new FacilityInfo(); newFacility.Object = Object; newFacility.ObjectActCall = Object.GetComponent <InstallableObjectAct>(); newFacility.isActive = true; newFacility.SuppliedElectricity = 0f; newFacility.SuppliedLabor = 0; newFacility.InstallDate = TimeManagerCall.TimeValue; FacilityList.Add(newFacility); InstalledFacilityAmount++; CompanyValueCall.GetEconomyValue().GetComponent <EconomyValue>().AddHistory(TimeManagerCall.TimeValue, "Install", newFacility.ObjectActCall.Info.Name, "Install " + Object.name, -newFacility.ObjectActCall.Info.Price); CompanyValueCall.GetEconomyValue().GetComponent <EconomyValue>().AddPersistHistory(TimeManagerCall.GetNextMonth(0, newFacility.ObjectActCall.Info.UpkeepMonthTerm) + (TimeManagerCall.TimeValue % TimeManagerCall.Month), newFacility.ObjectActCall.Info.UpkeepMonthTerm * TimeManagerCall.Month, "Upkeep", newFacility.ObjectActCall.Info.Name, Object.name + "'s Upkeep Price", -newFacility.ObjectActCall.Info.UpkeepPrice); CompanyValueCall.GetElectricityValue().GetComponent <ElectricityValue>().AddObject(newFacility); CompanyValueCall.GetEmployeeValue().GetComponent <EmployeeValue>().AddLaborInfo(newFacility); return(newFacility); }
private void Update() { if (canvas.enabled) { if (selectedToggle != toggleGroup.ActiveToggles().FirstOrDefault <Toggle>()) { selectedToggle = toggleGroup.ActiveToggles().FirstOrDefault <Toggle>(); selectedFacilityInfo = facilityList.GetFacilityByName(selectedToggle.transform.Find("Name").GetComponent <Text>().text); } if (selectedToggle != null) { if (playerStats.GetCompanyFunds() >= selectedFacilityInfo.costToBuy && selectedFacility.CheckFacilitySize(selectedFacilityInfo)) { confirmButton.interactable = true; } else { confirmButton.interactable = false; } } else { confirmButton.interactable = false; } } }
public ActionResult DeleteConfirmed(int id) { FacilityInfo facilityInfo = db.FacilityInfo.Find(id); db.FacilityInfo.Remove(facilityInfo); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,FacilityId,LocationKind,LocationName,Address,City,State,ZipCode,PhoneNumber,Directions,OperationalHours")] FacilityInfo facilityInfo) { if (ModelState.IsValid) { db.Entry(facilityInfo).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(facilityInfo)); }
private FacilityInfo CreateFacilityInfo() { var fi = new FacilityInfo(); fi.FacilityId = "JPN999999999999"; fi.FacilityName = "医療法人 オルカ医院"; fi.PostNumber = "113-0021"; fi.AddressText = "東京都文京区本駒込2-28-16"; return(fi); }
public FacilityViewModel() { FriendlyMessage = new List <FriendlyMessage>(); Pager = new PaginationInfo(); Facility = new FacilityInfo(); Facilities = new List <FacilityInfo>(); FacilityTypes = new List <FacilityTypeInfo>(); Filter = new FacilityFilter(); }
// GET: FacilityInfoes/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FacilityInfo facilityInfo = db.FacilityInfo.Find(id); if (facilityInfo == null) { return(HttpNotFound()); } return(View(facilityInfo)); }
public FacilityInfo GetFacilityInfo(string Name) { FacilityInfo Result = null; foreach (var Facility in FacilityList) { if (Facility.Name == Name) { Result = Facility; } } return(Result); }
public AlarmRuleSaveResponse Execute(AlarmRuleSaveRequest request) { AlarmRuleSaveResponse ruleSaveResponse = new AlarmRuleSaveResponse(); if (string.IsNullOrEmpty(request.AlarmRuleDID)) { AlarmRuleInfo alarmRuleInfo = new AlarmRuleInfo(); FacilityInfo facility = ServiceHelper.LoadService <IProductionService>().GetFacility(request.CraftDID); alarmRuleInfo.RuleDID = ServiceHelper.LoadService <IAlarmService>().GetNextAlarmRuleDID(facility.Process.Craft.CraftNO); alarmRuleInfo.FacilityDID = facility.FacilityDID; alarmRuleInfo.UnitDID = facility.ProcessDID; alarmRuleInfo.CraftDID = facility.Process.CraftDID; alarmRuleInfo.UnitDID = request.UnitDID; alarmRuleInfo.AlarmContent = request.AlarmContent; alarmRuleInfo.AlarmReason = request.AlarmReason; alarmRuleInfo.Solution = new SolutionInfo() { Content = request.SolutionText }; alarmRuleInfo.AlarmTypeDID = request.AlarmTypeDID; string str1 = "Upload/SolutionImages/"; string str2 = alarmRuleInfo.RuleDID + ".jpg"; if (!Directory.Exists(this.Server.MapPath("~/" + str1))) { Directory.CreateDirectory(this.Server.MapPath("~/" + str1)); } ImageHelper.SaveImage(ImageHelper.BytesToImage(request.GetFileParameters()["SolutionImage"].GetContent()), this.Server.MapPath("~/" + str1 + str2)); string str3 = "Upload/AlarmLocationImages/"; string str4 = alarmRuleInfo.RuleDID + ".jpg"; if (!Directory.Exists(this.Server.MapPath("~/" + str3))) { Directory.CreateDirectory(this.Server.MapPath("~/" + str3)); } ImageHelper.SaveImage(ImageHelper.BytesToImage(request.GetFileParameters()["AlarmLocationImage"].GetContent()), this.Server.MapPath("~/" + str3 + str4)); alarmRuleInfo.AlarmLocationImage = new AlarmLocationImageInfo() { Path = str3 + str4 }; alarmRuleInfo.SolutionImage = new SolutionImageInfo() { Path = str1 + str2 }; ServiceHelper.LoadService <IAlarmService>().AddAlarmRule(alarmRuleInfo); ServiceHelper.LoadService <IAlarmService>().SaveAlarmRuleFields(alarmRuleInfo.RuleDID, request.Fields); ruleSaveResponse.AlarmRuleDID = alarmRuleInfo.RuleDID; } return(ruleSaveResponse); }
private void LoadDefaults() { myF = new FacilityInfo(); if (myF.ShowFacility() > 0) { strFcode = FacilityInfo.FCode; txtFacility.Text = FacilityInfo.FName; } else { LiveClear(); Interactive.LInfoWarningOK("Facility informantion is required", "Facility Settings"); FrmFacility f = new FrmFacility(); f.ShowDialog(); } }
private FacilityInfo GetFacilityInfo(SqlDataReader dr) { FacilityInfo facility = new FacilityInfo { Id = DatabaseHelper.GetInt32("FacilityId", dr), DistrictId = DatabaseHelper.GetInt32("DistrictId", dr), FacilityName = DatabaseHelper.GetString("FacilityName", dr), DistrictName = DatabaseHelper.GetString("DistrictName", dr), ProvinceName = DatabaseHelper.GetString("ProvinceName", dr), FacilityCode = DatabaseHelper.GetString("FacilityCode", dr), FacilityLevel = DatabaseHelper.GetString("FacilityLevel", dr), ProvinceId = DatabaseHelper.GetInt32("ProvinceId", dr), FacilityTypeName = DatabaseHelper.GetString("FacilityTypeName", dr), }; return(facility); }
public async Task <IActionResult> Create([Bind("User,FacilityId,ActiveStatus,DateEstablished,DistCode,FacilityName,FacilityNameDari,FacilityNamePashto,FacilityType,Gpslattitude,Gpslongtitude,Implementer,Lat,Location,LocationDari,LocationPashto,Lon,SubImplementer,ViliCode")] FacilityInfo facilityInfo) { if (ModelState.IsValid) { _context.Add(facilityInfo); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } var users = _db.Users.Where(m => m.Active.Equals(true)).Select(m => new ApplicationUser() { FirstName = m.FirstName + " " + m.LastName + "-" + m.UserName, UserName = m.UserName, }).ToList(); ViewData["User"] = new SelectList(users, "UserName", "FirstName", facilityInfo.User); ViewData["DistCode"] = new SelectList(_context.Districts, "DistCode", "DistName", facilityInfo.DistCode); return(View(facilityInfo)); }
public async Task <IActionResult> Create([Bind("Implementer,FacilityId,ActiveStatus,DateEstablished,DistCode,FacilityName,FacilityNameDari,FacilityNamePashto,FacilityType,Gpslattitude,Gpslongtitude,Lat,Location,LocationDari,LocationPashto,Lon,SubImplementer,ViliCode")] FacilityInfo facilityInfo) { if (ModelState.IsValid) { _context.Add(facilityInfo); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } var items = _context.FacilityTypes.Select(s => new { FacTypeCode = s.FacTypeCode, description = string.Format("{0} - {1}", s.FacTypeCatCode, s.FacType) }); var imps = _context.Implementers.ToList(); ViewData["fac"] = new SelectList(items, "FacTypeCode", "description"); ViewData["imps"] = new SelectList(imps, "ImpAcronym", "ImpAcronym"); ViewData["Districts"] = new SelectList(_context.Districts, "DistCode", "DistName"); return(View(facilityInfo)); }
public IList <AlarmTemporaryInfo> GetAlarmTemporarys() { DataTable tb = getAlarmTemporarys(); List <AlarmTemporaryInfo> lst = new List <AlarmTemporaryInfo>(); if (tb != null && tb.Rows.Count > 0) { foreach (DataRow row in tb.Rows) { AlarmTemporaryInfo info = new AlarmTemporaryInfo(); info.AlarmTemporaryDID = int.Parse(row[0].ToString()); info.RuleDID = row[1].ToString(); info.FacilityDID = int.Parse(row[2].ToString()); info.AlarmTime = DateTime.Parse(row[3].ToString()); if (row[4].ToString() != "") { info.DisposeState = int.Parse(row[4].ToString()); } if (row[5].ToString() != "") { info.DisposeTime = DateTime.Parse(row[5].ToString()); } info.Handler = row[6].ToString(); if (row[7].ToString() != "") { info.Duration = int.Parse(row[7].ToString()); } info.Address = row[8].ToString(); info.Remark = row[9].ToString(); ProductionDB p = new ProductionDB(); FacilityInfo f = p.GetFacilityByID(info.FacilityDID); info.Facility = f; lst.Add(info); } } return(lst); }
public async Task <IActionResult> Edit(int id, [Bind("FacilityId,User,ActiveStatus,DateEstablished,DistCode,FacilityName,FacilityNameDari,FacilityNamePashto,FacilityType,Gpslattitude,Gpslongtitude,Implementer,Lat,Location,LocationDari,LocationPashto,Lon,SubImplementer,ViliCode")] FacilityInfo facilityInfo) { if (id != facilityInfo.FacilityId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(facilityInfo); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FacilityInfoExists(facilityInfo.FacilityId)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } var users = _db.Users.Where(m => m.Active.Equals(true)).Select(m => new ApplicationUser() { FirstName = m.FirstName + " " + m.LastName + "-" + m.UserName, UserName = m.UserName, }).ToList(); ViewData["User"] = new SelectList(users, "UserName", "FirstName", facilityInfo.User); ViewData["DistCode"] = new SelectList(_context.Districts, "DistCode", "DistName", facilityInfo.DistCode); return(View(facilityInfo)); }
public AlarmTemporaryInfo GetAlarmTemporaryByID(int alarmTemporaryDID) { DataTable tb = getAlarmTemporaryByID(alarmTemporaryDID); if (tb != null && tb.Rows.Count > 0) { AlarmTemporaryInfo info = new AlarmTemporaryInfo(); info.AlarmTemporaryDID = int.Parse(tb.Rows[0][0].ToString()); info.RuleDID = tb.Rows[0][1].ToString(); info.FacilityDID = int.Parse(tb.Rows[0][2].ToString()); info.AlarmTime = DateTime.Parse(tb.Rows[0][3].ToString()); if (tb.Rows[0][4].ToString() != "") { info.DisposeState = int.Parse(tb.Rows[0][4].ToString()); } if (tb.Rows[0][5].ToString() != "") { info.DisposeTime = DateTime.Parse(tb.Rows[0][5].ToString()); } info.Handler = tb.Rows[0][6].ToString(); if (tb.Rows[0][7].ToString() != "") { info.Duration = int.Parse(tb.Rows[0][7].ToString()); } info.Address = tb.Rows[0][8].ToString(); info.Remark = tb.Rows[0][9].ToString(); ProductionDB p = new ProductionDB(); FacilityInfo f = p.GetFacilityByID(info.FacilityDID); info.Facility = f; return(info); } else { throw new Exception("执行 getAlarmTemporaryByID 查询到空值"); } }
public async Task <IActionResult> Edit(int id, [Bind("Implementer,FacilityId,ActiveStatus,DateEstablished,DistCode,FacilityName,FacilityNameDari,FacilityNamePashto,FacilityType,Gpslattitude,Gpslongtitude,Lat,Location,LocationDari,LocationPashto,Lon,SubImplementer,ViliCode")] FacilityInfo facilityInfo) { if (id != facilityInfo.FacilityId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(facilityInfo); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FacilityInfoExists(facilityInfo.FacilityId)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } var items = _context.FacilityTypes.Select(s => new { FacTypeCode = s.FacTypeCode, description = string.Format("{0} - {1}", s.FacTypeCatCode, s.FacType) }); ViewData["fac"] = new SelectList(items, "FacTypeCode", "description"); ViewData["Districts"] = new SelectList(_context.Districts, "DistCode", "DistName"); return(View(facilityInfo)); }
public void DeleteFacilityInfo(GameObject Object) { FacilityInfo Target = null; foreach (var Info in FacilityList) { if (Info.Object == Object) { Target = Info; break; } } if (Target != null) { InstalledFacilityAmount--; CompanyValueCall.GetEconomyValue().GetComponent <EconomyValue>().DeletePersistHistory(Object.name + "'s Upkeep Price"); CompanyValueCall.GetElectricityValue().GetComponent <ElectricityValue>().DeleteObject(Target); CompanyValueCall.GetEmployeeValue().GetComponent <EmployeeValue>().DeleteLaborInfo(Target); FacilityList.Remove(Target); } }
public HotelViewModel() { FriendlyMessage = new List <FriendlyMessage>(); Pager = new PaginationInfo(); Hotel = new HotelInfo(); Hotels = new List <HotelInfo>(); Cities = new List <CityInfo>(); RoomTypes = new List <RoomTypeInfo>(); HotelTypes = new List <HotelTypeInfo>(); Designations = new List <DesignationInfo>(); HotelFacility = new FacilityInfo(); HotelFacilities = new List <FacilityInfo>(); HotelRoomType = new HotelRoomTypeDetailsInfo(); HotelRoomTypes = new List <HotelRoomTypeDetailsInfo>(); ContactPerson = new HotelContactPersonInfo(); ContactPersons = new List <HotelContactPersonInfo>(); HotelFacilityDetails = new List <HotelFacilityDetailsInfo>(); HotelBankFilter = new HotelBankFilter(); Images = new List <AccessoriesInfo>(); }
public DataTable getFacSearch(FacilityInfo facInfo) { DataTable dtable = new DataTable(); try { SqlConnection con = new SqlConnection(conStr); SqlCommand sqlCmd = new SqlCommand("select * from Facility_Info where Facility_Name = '" + facInfo.FacilityName + "' and Facility_Code = '" + facInfo.FacilityID + "'", con); SqlDataReader sqlDr; con.Open(); sqlDr = sqlCmd.ExecuteReader(); dtable.Load(sqlDr); con.Close(); } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); } return dtable; }
public int Ins_FacilityInfo(FacilityInfo facInfo,Clinic clinic,string userID) { int flag = 0; try { SqlConnection con = new SqlConnection(conStr); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = con; sqlCmd.CommandText = "sp_set_Facility_Info"; sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter FacilityID = sqlCmd.Parameters.Add("@Facility_ID", SqlDbType.VarChar, 15); if (facInfo.FacilityID != null) FacilityID.Value = facInfo.FacilityID; else FacilityID.Value = Convert.DBNull; SqlParameter FacilityName = sqlCmd.Parameters.Add("@Facility_Name", SqlDbType.VarChar, 50); if (facInfo.FacilityName != null) FacilityName.Value = facInfo.FacilityName; else FacilityName.Value = Convert.DBNull; SqlParameter FacilityAddress = sqlCmd.Parameters.Add("@Facility_Address", SqlDbType.VarChar, 50); if(facInfo.FacilityAddress != null) FacilityAddress.Value = facInfo.FacilityAddress; else FacilityAddress.Value = Convert.DBNull; SqlParameter FacilityCity = sqlCmd.Parameters.Add("@Facility_City", SqlDbType.VarChar, 50); if (facInfo.FacilityCity != null) FacilityCity.Value = facInfo.FacilityCity; else FacilityCity.Value = Convert.DBNull; SqlParameter FacilityState = sqlCmd.Parameters.Add("@Facility_State", SqlDbType.Char, 2); if (facInfo.FacilityState != null) FacilityState.Value = facInfo.FacilityState.ToCharArray(); else FacilityState.Value = Convert.DBNull; SqlParameter FacilityZip = sqlCmd.Parameters.Add("@Facility_Zip", SqlDbType.Char, 10); if (facInfo.FacilityZip != null) FacilityZip.Value = facInfo.FacilityZip.ToCharArray(); else FacilityZip.Value = Convert.DBNull; SqlParameter FacilityTPhone = sqlCmd.Parameters.Add("@Facility_TPhone", SqlDbType.VarChar, 15); if (facInfo.FacilityTPhone != null) FacilityTPhone.Value = facInfo.FacilityTPhone; else FacilityTPhone.Value = Convert.DBNull; SqlParameter FacilityFax = sqlCmd.Parameters.Add("@Facility_Fax", SqlDbType.VarChar, 15); if (FacilityFax != null) FacilityFax.Value = facInfo.FacilityFax; else FacilityFax.Value = Convert.DBNull; SqlParameter FacilityEMail = sqlCmd.Parameters.Add("@Facility_EMail", SqlDbType.VarChar, 50); if (facInfo.FacilityEMail != null) FacilityEMail.Value = facInfo.FacilityEMail; else FacilityEMail.Value = Convert.DBNull; SqlParameter FacilityTaxID = sqlCmd.Parameters.Add("@Facility_TaxID", SqlDbType.VarChar, 20); if (facInfo.FacilityTaxID != null) FacilityTaxID.Value = facInfo.FacilityTaxID; else FacilityTaxID.Value = Convert.DBNull; SqlParameter FacilitySpeciality = sqlCmd.Parameters.Add("@Facility_Speciality", SqlDbType.VarChar, 20); if (facInfo.FacilitySpeciality != null) FacilitySpeciality.Value = facInfo.FacilitySpeciality; else FacilitySpeciality.Value =Convert.DBNull; SqlParameter FacilityProvID = sqlCmd.Parameters.Add("@Facility_ProvID", SqlDbType.VarChar, 20); if (facInfo.FacilityProvID != null) FacilityProvID.Value = facInfo.FacilityProvID; else FacilityProvID.Value = Convert.DBNull; SqlParameter ClinicID = sqlCmd.Parameters.Add("@ClinicID",SqlDbType.Int); if (clinic.ClinicID != null) ClinicID.Value = clinic.ClinicID; else ClinicID.Value = Convert.DBNull; SqlParameter pUserID = sqlCmd.Parameters.Add("@UserID", SqlDbType.VarChar, 20); pUserID.Value = userID; SqlParameter parmIsStamps = sqlCmd.Parameters.Add("@IsStamps", SqlDbType.Char, 1); parmIsStamps.Value = facInfo.IsStamps; con.Open(); sqlCmd.ExecuteNonQuery(); flag = 1; con.Close(); } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); } return flag; }
public int Delete_facInfo(FacilityInfo facInfo,string userID) { int flag = 0; try { SqlConnection con = new SqlConnection(conStr); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = con; sqlCmd.CommandText = "sp_delete_Facility_Info"; sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter FacilityNo = sqlCmd.Parameters.Add("@Facility_No", SqlDbType.Int); FacilityNo.Value = facInfo.FacilityNO; SqlParameter pUserID = sqlCmd.Parameters.Add("@UserID", SqlDbType.VarChar, 20); pUserID.Value = userID; SqlParameter parmFlag = sqlCmd.Parameters.Add("@Flag", SqlDbType.Int); parmFlag.Direction = ParameterDirection.Output; con.Open(); sqlCmd.ExecuteNonQuery(); flag = (int)parmFlag.Value; con.Close(); } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); } return flag ; }
public DataTable get_LocationNamesByName(string prefixText) { SqlConnection sqlCon = new SqlConnection(conStr); FacilityInfo facInfo = new FacilityInfo(); string Fac_Search_String = prefixText; string[] words = Fac_Search_String.Split(','); facInfo.FacilityName = words[0]; facInfo.FacilityID = words[1]; string sqlQuery = "select Facility_ID from Facility_Info where Facility_Name = '" + facInfo.FacilityName + "' and Facility_Code = '" +facInfo.FacilityID+"'"; SqlDataAdapter sqlDa = new SqlDataAdapter(sqlQuery, sqlCon); DataSet dsLocnames = new DataSet(); try { sqlDa.Fill(dsLocnames, "Names"); } catch (Exception ex) { objNLog.Error("Exception : " + ex.Message); } return dsLocnames.Tables["Names"]; }
public void Update(FacilityInfo facility) { _sqlHelper.ExecuteNonQuery(SetValuesInFacility(facility), Storeprocedures.spUpdateFacility.ToString(), CommandType.StoredProcedure); }
public int Insert(FacilityInfo facility) { return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInFacility(facility), Storeprocedures.spInsertFacility.ToString(), CommandType.StoredProcedure))); }
public int getFacilityID(FacilityInfo facInfo) { SqlConnection con = new SqlConnection(ConStr); SqlCommand sqlCmd = new SqlCommand("select Facility_ID from Facility_Info where Facility_Name = '" + facInfo.FacilityName + "'", con); // SqlDataReader sqlDr; // DataTable dtable = new DataTable(); // DataRow dr; con.Open(); int FacilityID = Convert.ToInt32(sqlCmd.ExecuteScalar()); con.Close(); return FacilityID; }
/// <summary> /// GetFacilities by craftDID /// </summary> /// <param name="craftDID">craftDID</param> /// <returns></returns> public IList <FacilityInfo> GetFacilities(int craftDID) { List <FacilityInfo> lst = new List <FacilityInfo>(); DataTable dt = getFacilities(craftDID); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { FacilityInfo info = new FacilityInfo(); info.FacilityDID = int.Parse(row[0].ToString()); info.MMName = row[1].ToString(); info.ProcessDID = int.Parse(row[2].ToString()); info.DeviceGroupDID = int.Parse(row[3].ToString()); info.State = int.Parse(row[4].ToString()); info.MMIP = row[5].ToString(); info.MMPort = row[6].ToString(); info.MMIsUse = row[7].ToString() == "1" ? true : false; info.MMClearAddr = row[8].ToString(); info.MMRestAddr = row[9].ToString(); if (row[10].ToString() != "") { info.MMSeq = int.Parse(row[10].ToString()); } info.MAAddress = row[11].ToString(); info.IsUse = row[12].ToString() == "1" ? true : false; info.Remark = row[13].ToString(); ProcessInfo processInfo = new ProcessInfo(); DataTable tbProcess = getProcessesByID(info.ProcessDID); if (tbProcess != null && tbProcess.Rows.Count > 0) { processInfo.ProcessDID = int.Parse(tbProcess.Rows[0][0].ToString()); processInfo.ProcessNO = tbProcess.Rows[0][1].ToString(); processInfo.ProcessName = tbProcess.Rows[0][2].ToString(); processInfo.CraftDID = int.Parse(tbProcess.Rows[0][3].ToString()); DataTable tb = getCraftsByID(processInfo.CraftDID); if (tb != null && tb.Rows.Count > 0) { CraftInfo craftInfo = new CraftInfo(); craftInfo.CraftDID = processInfo.CraftDID; craftInfo.CraftNO = tb.Rows[0][1].ToString(); craftInfo.CraftName = tb.Rows[0][2].ToString(); processInfo.Craft = craftInfo; } else { processInfo.Craft = null; throw new Exception("执行getCraftsByID查询为空"); } info.Process = processInfo; } else { info.Process = null; processInfo = null; throw new Exception("执行getProcessesByID查询为空"); } DataTable tbDeviceGroup = getDeviceGroupByID(info.DeviceGroupDID); if (tbDeviceGroup != null && tbDeviceGroup.Rows.Count > 0) { DeviceGroupInfo deviceGroupInfo = new DeviceGroupInfo(); deviceGroupInfo.DeviceGroupDID = info.DeviceGroupDID; deviceGroupInfo.DeviceGroupNO = tbDeviceGroup.Rows[0][1].ToString(); deviceGroupInfo.DeviceGroupName = tbDeviceGroup.Rows[0][2].ToString(); deviceGroupInfo.CraftDID = int.Parse(tbDeviceGroup.Rows[0][3].ToString()); DataTable tb = getCraftsByID(deviceGroupInfo.CraftDID); if (tb != null && tb.Rows.Count > 0) { CraftInfo craftInfo = new CraftInfo(); craftInfo.CraftDID = processInfo.CraftDID; craftInfo.CraftNO = tb.Rows[0][1].ToString(); craftInfo.CraftName = tb.Rows[0][2].ToString(); deviceGroupInfo.Craft = craftInfo; } else { deviceGroupInfo.Craft = null; throw new Exception("执行getCraftsByID查询为空"); } info.DeviceGroup = deviceGroupInfo; } else { info.DeviceGroup = null; throw new Exception("执行getDeviceGroupByID查询为空"); } lst.Add(info); } } return(lst); }
public DayCareModel ExtractDayCareDetailList(string url) { var model = new DayCareModel(); model.FacilityInformation = new FacilityInfo(); model.DaysOpen = new DaysOpen(); model.LicenseeInformation = new LicenseeInfo(); model.LicenseInformation = new LicenseInfo(); model.ServicesOffered = new ServicesOffered(); HtmlDocument doc = web.Load(url); HtmlNodeCollection dayCareCenterNodes = doc.DocumentNode.SelectNodes("//div[@class='col-lg-6 profile']"); foreach (HtmlNode table in dayCareCenterNodes) { var rows = table.SelectNodes("tr"); var title = rows[0].InnerHtml.Replace("\r", "").Replace(" ", "").Replace("\n", ""); if (title.IndexOf("FacilityInformation") > 0) { var facilityInformation = new FacilityInfo(); facilityInformation.Name = rows[1].SelectNodes("td")[1].FirstChild.InnerText; var addressFont = rows[2].SelectNodes("td")[1].SelectNodes("font"); facilityInformation.Street = addressFont[0].InnerText.Replace("\r", "").Replace("\n", "").Replace(" ", "").Trim(); var address = addressFont[3].InnerText; facilityInformation.City = address.Split(',')[0].Trim(); var stateAndZip = address.Split(',')[1].Replace(" ", ","); facilityInformation.State = stateAndZip.Split(',')[0].Trim(); facilityInformation.ZipCode = stateAndZip.Split(',')[1].Trim(); //if(facilityInformation.ZipCode.Length>5) //{ // facilityInformation.ZipCode = facilityInformation.ZipCode.Substring(0, 5); //} facilityInformation.ZipOrder = Convert.ToInt32(facilityInformation.ZipCode); facilityInformation.County = rows[3].SelectNodes("td")[1].SelectSingleNode("font").InnerText; facilityInformation.Phone = rows[4].SelectNodes("td")[1].SelectSingleNode("font").InnerText; facilityInformation.LicenseStatus = rows[4].SelectNodes("td")[3].SelectSingleNode("font").InnerText; facilityInformation.Status = ""; model.FacilityInformation = facilityInformation; } if (title.IndexOf("LicenseeInfo") > 0) { var licenseeInfo = new LicenseeInfo(); licenseeInfo.Name = rows[1].SelectNodes("td")[1].FirstChild.InnerText; licenseeInfo.Address = rows[2].SelectNodes("td")[1].FirstChild.InnerText.Replace(" ", ""); licenseeInfo.Phone = rows[3].SelectNodes("td")[1].FirstChild.InnerText.Replace("\r", "").Replace("\n", "").TrimEnd().TrimStart(); model.LicenseeInformation = licenseeInfo; } if (title.IndexOf("LicenseInfo") > 0) { var licenseInfo = new LicenseInfo(); licenseInfo.Number = rows[2].SelectNodes("td")[0].SelectSingleNode("div").SelectSingleNode("font").InnerText; licenseInfo.FacilityType = rows[2].SelectNodes("td")[1].SelectSingleNode("div").SelectSingleNode("font").InnerText.Replace("\r", "").Replace("\n", "").TrimEnd().TrimStart(); licenseInfo.Capacity = rows[2].SelectNodes("td")[2].SelectSingleNode("div").SelectSingleNode("font").InnerText; licenseInfo.EffectiveDate = rows[2].SelectNodes("td")[3].SelectSingleNode("div").SelectSingleNode("font").InnerText; licenseInfo.ExpirationDate = rows[2].SelectNodes("td")[4].SelectSingleNode("div").SelectSingleNode("font").InnerText; licenseInfo.PeriodOfOperation = rows[2].SelectNodes("td")[5].SelectSingleNode("div").SelectSingleNode("font").InnerText; model.LicenseInformation = licenseInfo; } if (title.IndexOf("DaysOpen") > 0) { var daysOpen = new DaysOpen(); daysOpen.Sunday = rows[2].SelectNodes("td")[0].SelectSingleNode("div").SelectSingleNode("font").InnerText; daysOpen.Monday = rows[2].SelectNodes("td")[1].SelectSingleNode("div").SelectSingleNode("font").InnerText; daysOpen.Tuesday = rows[2].SelectNodes("td")[2].SelectSingleNode("div").SelectSingleNode("font").InnerText; daysOpen.Wednesday = rows[2].SelectNodes("td")[3].SelectSingleNode("div").SelectSingleNode("font").InnerText; daysOpen.Thursday = rows[2].SelectNodes("td")[4].SelectSingleNode("div").SelectSingleNode("font").InnerText; daysOpen.Friday = rows[2].SelectNodes("td")[5].SelectSingleNode("div").SelectSingleNode("font").InnerText; daysOpen.Saturday = rows[2].SelectNodes("td")[6].SelectSingleNode("div").SelectSingleNode("font").InnerText; model.DaysOpen = daysOpen; } if (title.IndexOf("ServicesOffered") > 0) { var servicesOffered = new ServicesOffered(); servicesOffered.FullDayProgram = rows[1].SelectNodes("td")[1].SelectSingleNode("font").InnerText; servicesOffered.Provides = rows[2].SelectNodes("td")[1].SelectSingleNode("font").InnerText.Replace("\r", "").Replace("\n", "").TrimEnd().TrimStart(); model.ServicesOffered = servicesOffered; } } return(model); }
public FacilityApplyResponse Post([FromBody] FacilityApplyRequest req) { FacilityApplyResponse resp = new FacilityApplyResponse(); try { if (req.starttime >= req.endtime) { resp.result = "fail"; return(resp); } //确保申请时间晚于当前 DateTime today = DateTime.Now; //获取当前时间 string applyHour = req.starttime.ToString("00"); //转换小时为字符串 string testTime = req.date.ToString("yyyy-MM-dd") + " " + applyHour + ":00:00"; //连接成申请时刻 if (DateTime.Compare(today, Convert.ToDateTime(testTime)) > 0) { resp.result = "fail"; return(resp); } MySqlConnection conn = SQLManager.getConn(); //连接数据库 conn.Open(); //打开数据库连接 MySqlCommand test = null; //创建查询指令 test = new MySqlCommand("select start_time,end_time,max_capacity,start_day,end_day " + "from facilities where facility_ID=?facility;", conn); test.Parameters.AddWithValue("?facility", req.facility); MySqlDataReader mdr = test.ExecuteReader();//查询设施信息 if (!mdr.HasRows) { resp.result = "wrong facility";//id错误 mdr.Close(); conn.Close(); return(resp); } else { mdr.Read(); FacilityInfo info = new FacilityInfo(); //存储设施信息类 info.start = Convert.ToInt32(mdr.GetValue(0)); //存储开放起始时间 info.end = Convert.ToInt32(mdr.GetValue(1)); //存储开放结束时间 info.capacity = Convert.ToInt32(mdr.GetValue(2)); //存储容量 info.startday = Convert.ToInt32(mdr.GetValue(3)); //开放起始日期 info.endday = Convert.ToInt32(mdr.GetValue(4)); //开放最后日期 mdr.Close(); if (req.starttime < info.start || req.endtime > info.end) //检查申请时间是否符合要求 { conn.Close(); resp.result = "invalid time"; return(resp); } int weekday = GetWeek(req.date); //转换int星期几 if (weekday < info.startday || weekday > info.endday) //检查日期是否符合要求 { conn.Close(); resp.result = "invalid date"; return(resp); } MySqlCommand cmd = null;//创建查询指令 //查询健康状态 cmd = new MySqlCommand("select currenthealth_status from student " + "where student_ID=@id;", conn); cmd.Parameters.AddWithValue("@id", req.id); mdr = cmd.ExecuteReader(); mdr.Read(); if (!mdr.HasRows) { resp.result = "wrong id";//id错误 mdr.Close(); conn.Close(); return(resp); } int health = Convert.ToInt32(mdr.GetValue(0)); mdr.Close(); if (health != 0)//若健康状态不为“健康”,申请失败 { conn.Close(); resp.result = "unqualified"; return(resp); } // 查询违约记录 cmd = new MySqlCommand("select count(*) from default_record " + "where applicant_ID=@id;", conn); cmd.Parameters.AddWithValue("@id", req.id); mdr = cmd.ExecuteReader(); mdr.Read(); int count = Convert.ToInt32(mdr.GetValue(0)); mdr.Close(); if (count != 0 && count % 3 == 0)//若违约次数为3的整数倍,检查是否在最近一周违约 { cmd = new MySqlCommand("select date from default_record " + "where applicant_ID=@id and count=@count;", conn); cmd.Parameters.AddWithValue("@id", req.id); cmd.Parameters.AddWithValue("@count", count); mdr = cmd.ExecuteReader(); mdr.Read(); DateTime lastdate = Convert.ToDateTime(mdr.GetValue(0)); mdr.Close(); DateTime current = DateTime.Now; TimeSpan ts1 = new TimeSpan(lastdate.Ticks); TimeSpan ts2 = new TimeSpan(current.Ticks); TimeSpan ts = ts1.Subtract(ts2).Duration(); int days = Convert.ToInt32(ts.Days.ToString()); if (days < 7)//最后一次违约记录在7天以内 { conn.Close(); resp.result = "unqualified"; return(resp); } } string date = req.date.ToString("yyyy-MM-dd"); //检查同一申请人申请时间段是否已有其他申请 cmd = new MySqlCommand("select applicant_ID from application " + "where applicant_ID=@id and date=@date and " + "((start_time>=@start and start_time<@end) or (end_time<=@end and end_time>@start));", conn); cmd.Parameters.AddWithValue("@id", req.id); cmd.Parameters.AddWithValue("@date", date); cmd.Parameters.AddWithValue("@start", req.starttime); cmd.Parameters.AddWithValue("@end", req.endtime); mdr = cmd.ExecuteReader(); if (mdr.HasRows)//已有其他申请 { mdr.Close(); conn.Close(); resp.result = "time overlap"; return(resp); } mdr.Close(); /* * int[] quantity;//存储每一时间段人数 * int hours = req.endtime - req.starttime; * quantity = new int[hours];*/ //查看每一时间段申请总人数 for (int i = req.starttime; i < req.endtime; i++) { cmd = new MySqlCommand("select count(*) from application " + "where facility_ID=@id and date=@date and start_time<=@start and end_time>=@end;", conn); cmd.Parameters.AddWithValue("@id", req.facility); cmd.Parameters.AddWithValue("@date", date); cmd.Parameters.AddWithValue("@start", i); cmd.Parameters.AddWithValue("@end", i + 1); mdr = cmd.ExecuteReader(); if (mdr.HasRows) { mdr.Read(); /* * quantity[i - req.starttime] = Convert.ToInt32(mdr.GetValue(0));*/ int number = Convert.ToInt32(mdr.GetValue(0)); if (number >= info.capacity) //若有时间段预约数已达到容量上限,预约失败 { mdr.Close(); conn.Close(); resp.result = "no left"; return(resp); } }/* * else * quantity[i - req.starttime] = 0;*/ mdr.Close(); } //所有条件符合,插入记录 cmd = new MySqlCommand("insert into application (applicant_ID,facility_ID,date,start_time,end_time)" + "values(@id,@facility,@date,@start,@end);", conn); cmd.Parameters.AddWithValue("@id", req.id); cmd.Parameters.AddWithValue("@facility", req.facility); cmd.Parameters.AddWithValue("@date", date); cmd.Parameters.AddWithValue("@start", req.starttime); cmd.Parameters.AddWithValue("@end", req.endtime); cmd.Prepare(); cmd.ExecuteNonQuery();//执行insert语句 resp.result = "success"; } conn.Close();//关闭连接 } catch (Exception ex) { Console.WriteLine(ex); resp.result = "fail"; } return(resp); }
public string Update_Patient(PatientName Pat_Name, PatientPersonalDetails Pat_Per_Details, PatientAddress Pat_Add, PatientInsuranceDetails Pat_Ins_Details, PatientAllergies Pat_Allergies, FacilityInfo Fac_Info, PharmacyInfo Phrm_Info,ProviderInfo Prov_Info) { SqlConnection sqlCon = new SqlConnection(ConStr); SqlCommand sqlCmd = new SqlCommand("sp_update_Patient", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter P_ID = sqlCmd.Parameters.Add("@Pat_ID", SqlDbType.Int); P_ID.Value = Pat_Name.Pat_ID; SqlParameter P_MName = sqlCmd.Parameters.Add("@Pat_MName", SqlDbType.VarChar, 50); if (Pat_Name.MiddleName != null) P_MName.Value = Pat_Name.MiddleName; else P_MName.Value = Convert.DBNull; SqlParameter P_Gender = sqlCmd.Parameters.Add("@Pat_Gender", SqlDbType.Char, 1); if (Pat_Per_Details.Gender != null) P_Gender.Value = Pat_Per_Details.Gender; else P_Gender.Value = Convert.DBNull; SqlParameter P_DOB = sqlCmd.Parameters.Add("@Pat_DOB", SqlDbType.DateTime); if (Pat_Per_Details.DOB != null) P_DOB.Value = DateTime.Parse(Pat_Per_Details.DOB); else { Nullable<DateTime> NullDate = null; P_DOB.Value = NullDate; } SqlParameter P_SSN = sqlCmd.Parameters.Add("@Pat_SSN", SqlDbType.VarChar, 50); if (Pat_Per_Details.SSN != null) P_SSN.Value = Pat_Per_Details.SSN; else P_SSN.Value = Convert.DBNull; SqlParameter P_Address1 = sqlCmd.Parameters.Add("@Pat_Address1", SqlDbType.VarChar, 50); if (Pat_Add.Address1 != null) P_Address1.Value = Pat_Add.Address1; else P_Address1.Value = Convert.DBNull; SqlParameter P_Address2 = sqlCmd.Parameters.Add("@Pat_Address2", SqlDbType.VarChar, 50); if (Pat_Add.Address2 != null) P_Address2.Value = Pat_Add.Address2; else P_Address2.Value = Convert.DBNull; SqlParameter P_City = sqlCmd.Parameters.Add("@Pat_City", SqlDbType.VarChar, 50); if (Pat_Add.City != null) P_City.Value = Pat_Add.City; else P_City.Value = Convert.DBNull; SqlParameter P_State = sqlCmd.Parameters.Add("@Pat_State", SqlDbType.VarChar, 50); if (Pat_Add.State != null) P_State.Value = Pat_Add.State; else P_State.Value = Convert.DBNull; SqlParameter P_ZIP = sqlCmd.Parameters.Add("@Pat_Zip", SqlDbType.VarChar, 50); if (Pat_Add.Zip != null) P_ZIP.Value = Pat_Add.Zip; else P_ZIP.Value = Convert.DBNull; SqlParameter P_PDoc = sqlCmd.Parameters.Add("@Pat_PDoc", SqlDbType.VarChar, 50); if (Pat_Per_Details.Pat_Pre_Doc != null) P_PDoc.Value = Pat_Per_Details.Pat_Pre_Doc; else P_PDoc.Value = Convert.DBNull; SqlParameter P_MRN = sqlCmd.Parameters.Add("@Pat_MRN", SqlDbType.VarChar, 15); if (Pat_Per_Details.MRN != null) P_MRN.Value = Pat_Per_Details.MRN; else P_MRN.Value = Convert.DBNull; SqlParameter Fac_ID = sqlCmd.Parameters.Add("@Fac_ID", SqlDbType.Int); if (Fac_Info.FacilityNO != null) Fac_ID.Value = Fac_Info.FacilityNO; else Fac_ID.Value = Convert.DBNull; SqlParameter Phrm_ID = sqlCmd.Parameters.Add("@Phrm_ID", SqlDbType.Int); if (Phrm_Info.PhrmID != null) Phrm_ID.Value = Phrm_Info.PhrmID; else Phrm_ID.Value = Convert.DBNull; //SqlParameter PI_InsName = sqlCmd.Parameters.Add("@Ins_Name", SqlDbType.VarChar, 50); //if (Pat_Ins_Details.InsuranceName != null) // PI_InsName.Value = Pat_Ins_Details.InsuranceName; //else // PI_InsName.Value = Convert.DBNull; int InsID = getInsuranceID(Pat_Ins_Details); Pat_Ins_Details.InsuranceID = InsID; SqlParameter Ins_ID = sqlCmd.Parameters.Add("@Ins_ID", SqlDbType.Int); if (Pat_Ins_Details.InsuranceID.ToString() != "0") Ins_ID.Value = Pat_Ins_Details.InsuranceID; else Ins_ID.Value = Convert.DBNull; SqlParameter PI_No = sqlCmd.Parameters.Add("@PI_Number", SqlDbType.Int); if (Pat_Ins_Details.PI_PolicyNo.ToString() != "0") PI_No.Value = Pat_Ins_Details.PI_PolicyNo; else PI_No.Value = Convert.DBNull; SqlParameter PI_PolicyID = sqlCmd.Parameters.Add("@PI_PolicyID", SqlDbType.Int); if (Pat_Ins_Details.PI_PolicyID.ToString() != "0") PI_PolicyID.Value = Pat_Ins_Details.PI_PolicyID; else PI_PolicyID.Value = Convert.DBNull; SqlParameter PI_GroupNo = sqlCmd.Parameters.Add("@PI_GroupNo", SqlDbType.Int); if (Pat_Ins_Details.PI_GroupNo.ToString() != "0") PI_GroupNo.Value = Pat_Ins_Details.PI_GroupNo; else PI_GroupNo.Value = Convert.DBNull; SqlParameter PI_BINNo = sqlCmd.Parameters.Add("@PI_BINNo", SqlDbType.Int); if (Pat_Ins_Details.PI_BINNo.ToString() != "0") PI_BINNo.Value = Pat_Ins_Details.PI_BINNo; else PI_BINNo.Value = Convert.DBNull; SqlParameter PI_InsdName = sqlCmd.Parameters.Add("@PI_InsdName", SqlDbType.VarChar, 50); if (Pat_Ins_Details.InsuredName != null) PI_InsdName.Value = Pat_Ins_Details.InsuredName; else PI_InsdName.Value = Convert.DBNull; SqlParameter PI_InsdDOB = sqlCmd.Parameters.Add("@PI_InsdDOB", SqlDbType.DateTime); if (Pat_Ins_Details.InsuredDOB != null) PI_InsdDOB.Value = DateTime.Parse( Pat_Ins_Details.InsuredDOB); else { Nullable<DateTime> NullDate = null; PI_InsdDOB.Value = NullDate; } SqlParameter PI_InsdSSN = sqlCmd.Parameters.Add("@PI_InsdSSN", SqlDbType.VarChar, 50); if (Pat_Ins_Details.InsuredSSN != null) PI_InsdSSN.Value = Pat_Ins_Details.InsuredSSN; else PI_InsdSSN.Value = Convert.DBNull; SqlParameter PI_InsdRel = sqlCmd.Parameters.Add("@PI_InsdRel", SqlDbType.VarChar, 50); if (Pat_Ins_Details.InsuredRelation != null) PI_InsdRel.Value = Pat_Ins_Details.InsuredRelation; else PI_InsdRel.Value = Convert.DBNull; SqlParameter PA_Desc = sqlCmd.Parameters.Add("@PA_Desc", SqlDbType.VarChar, 200); if (Pat_Allergies.AllergyDescription != null) PA_Desc.Value = Pat_Allergies.AllergyDescription; else PA_Desc.Value = Convert.DBNull; try { sqlCon.Open(); sqlCmd.ExecuteNonQuery(); } catch (Exception ex) { return ex.ToString(); } finally { sqlCon.Close(); } return "Updated Patient Information Successfully"; }
public MockBredInfo() { FacilityInfo.AddRange(MockFacility.Facilities); }
public void BuyFacility(FacilityInfo facilityInformation) { PlayerStats.instance.ChangeCompanyFunds(-facilityInformation.costToBuy); ChangeFacility(facilityInformation); }
public string getFacilityName(FacilityInfo facInfo) { SqlConnection con = new SqlConnection(ConStr); SqlCommand sqlCmd = new SqlCommand("select Facility_Name from Facility_Info where Facility_ID = '" + facInfo.FacilityNO + "'", con); // SqlDataReader sqlDr; // DataTable dtable = new DataTable(); // DataRow dr; con.Open(); string FacilityName = sqlCmd.ExecuteScalar().ToString(); con.Close(); return FacilityName; }
void InitializingArray() { string[] FieldName; List <string[]> DataList; TechInfoList = new List <TechInfo>(); FieldName = new string[] { "Name", "UnlockFacility", "UnlockActor", "UpgradeType", "UpgradeAmount", "RequiredIndex", "RequiredValue", "WorkLoad" }; DataList = new List <string[]>(); xmlReader.xmlReaderAccess.ReadXml("Data/Tech/XML/TechInfo", "TechInfo/Tech", FieldName, DataList); foreach (string[] Data in DataList) { TechInfo newRecipe = new TechInfo(); newRecipe.Name = Data[0]; newRecipe.UnlockFacility = Data[1].Split(','); newRecipe.UnlockActor = Data[2].Split(','); newRecipe.UpgradeValueType = Data[3]; newRecipe.UpgradeValueAmount = System.Convert.ToSingle(Data[4]); string[] RequiredIndex = Data[5].Split(','); newRecipe.RequiredTech = new int[RequiredIndex.Length]; for (int i = 0; i < RequiredIndex.Length; i++) { newRecipe.RequiredTech[i] = System.Convert.ToInt32(RequiredIndex[i]); } newRecipe.RequiredValue = System.Convert.ToInt32(Data[6]); newRecipe.RequiredWorkLoad = System.Convert.ToInt32(Data[7]); TechInfoList.Add(newRecipe); } FacilityList = new List <FacilityInfo>(); FieldName = new string[] { "Type", "Name", "Price", "UpkeepPrice", "UpkeepMonthTerm", "ElectricConsum", "LaborRequirement" }; DataList = new List <string[]>(); xmlReader.xmlReaderAccess.ReadXml("Data/Tech/XML/FacilityInfo", "FacilityInfo/Facility", FieldName, DataList); foreach (string[] Data in DataList) { FacilityInfo newFacility = new FacilityInfo(); newFacility.Type = Data[0]; newFacility.Name = Data[1]; newFacility.Price = System.Convert.ToInt32(Data[2]); newFacility.UpkeepPrice = System.Convert.ToInt32(Data[3]); newFacility.UpkeepMonthTerm = System.Convert.ToInt32(Data[4]); newFacility.ElectricConsum = System.Convert.ToSingle(Data[5]); newFacility.LaborRequirement = System.Convert.ToSingle(Data[6]); newFacility.Object = Resources.Load <GameObject>("GameSystem/InstallableObject/Object/" + newFacility.Name); FacilityList.Add(newFacility); } ProcessorList = new List <ProcessorInfo>(); FieldName = new string[] { "Type", "Name", "PerformanceQuality", "PerformanceSpeed", "ActorList" }; DataList = new List <string[]>(); xmlReader.xmlReaderAccess.ReadXml("Data/Tech/XML/ProcessorInfo", "ProcessorInfo/Processor", FieldName, DataList); foreach (string[] Data in DataList) { ProcessorInfo newProcessor = new ProcessorInfo(); newProcessor.Type = Data[0]; newProcessor.Name = Data[1]; newProcessor.PerformanceQuality = System.Convert.ToSingle(Data[2]); newProcessor.PerformanceSpeed = System.Convert.ToSingle(Data[3]); newProcessor.ActorList = Data[4].Split(','); ProcessorList.Add(newProcessor); } ActorList = new List <ProcessActorInfo>(); FieldName = new string[] { "Name", "TechPoint", "Cost" }; DataList = new List <string[]>(); xmlReader.xmlReaderAccess.ReadXml("Data/Tech/XML/ActorInfo", "ActorInfo/Actor", FieldName, DataList); foreach (string[] Data in DataList) { ProcessActorInfo newActor = new ProcessActorInfo(); newActor.Name = Data[0]; newActor.TechPoint = System.Convert.ToSingle(Data[1]); newActor.Cost = System.Convert.ToInt32(Data[2]); ActorList.Add(newActor); } }
public static FacilityModel ToModel(this FacilityInfo entity) { return(Mapper.Map <FacilityInfo, FacilityModel>(entity)); }