private void WriteLeitungsliste(ExcelWorksheet ws, PlanData data) { var outNodes = data.treeNodeDatas.Values .OfType <TreeNodeDataOut>().ToList(); int rowNo = 1; int leitungNr = 1; ws.Cells[rowNo, 1].Value = "Nr"; ws.Column(1).Width = 4; ws.Cells[rowNo, 2].Value = "Klemmleiste"; ws.Column(2).Width = 5; ws.Cells[rowNo, 3].Value = "Klemme"; ws.Column(3).Width = 5; ws.Cells[rowNo, 4].Value = "L-Nummer"; ws.Column(4).Width = 13; ws.Cells[rowNo, 5].Value = "Leitungsname"; ws.Column(5).Width = 38; ws.Cells[rowNo, 6].Value = "Leitungstyp"; ws.Column(6).Width = 12; ws.Cells[rowNo, 7].Value = "Anz. Adern"; ws.Column(7).Width = 3; ws.Cells[rowNo, 8].Value = "Querschnitt"; ws.Column(8).Width = 4; ws.Cells[rowNo, 9].Value = "Leitungstyp"; ws.Column(9).Width = 16; ws.Cells[rowNo, 10].Value = "Individuelle Leitungsbezeichnung"; ws.Column(10).Width = 40; rowNo++; foreach (var nodeData in outNodes.OrderBy(x => x.KlemmleisteNummer).ThenBy(x => x.klemmenBlockNummer)) { //To set values in the spreadsheet use the Cells indexer. ws.Cells[rowNo, 1].Value = leitungNr++; ws.Cells[rowNo, 2].Value = nodeData.klemmleiste; ws.Cells[rowNo, 3].Value = nodeData.klemmenBlockNummer; ws.Cells[rowNo, 4].Value = nodeData.leitungsnummer; ws.Cells[rowNo, 5].Value = nodeData.leitungsname; ws.Cells[rowNo, 6].Value = nodeData.leitungstyp; ws.Cells[rowNo, 7].Value = nodeData.adern.Length; ws.Cells[rowNo, 8].Value = nodeData.querschnitt; ws.Cells[rowNo, 9].Value = ReihenklemmenCreator.CreateLeitungstypWithQuerschnitt(nodeData); if (nodeData.individuelleLeitungsbezeichnungActive) { ws.Cells[rowNo, 10].Value = $"{nodeData.leitungsnummer}\n{nodeData.individuelleLeitungsbezeichnung}"; } ++rowNo; } }
private void ExportKlemmliste(ExcelPackage xlPackage, PlanData data) { var outNodes = data.treeNodeDatas.Values .OfType <TreeNodeDataOut>().ToList(); const int PROJECT_NAME_MAX_LENGTH = 15; var projectName = data.documentData.projectName.Truncate(PROJECT_NAME_MAX_LENGTH); //A workbook must have at least on cell, so lets add one... Console.Write($"Datenliste erstellen ... "); var ws = xlPackage.Workbook.Worksheets.Add($"{projectName}-LL"); WriteLeitungsliste(ws, data); Console.WriteLine("ok"); Console.Write($"Klemmenplan (Vertikal) erstellen ... "); ws = xlPackage.Workbook.Worksheets.Add($"{projectName}-KL-V"); WriteKlemmlisteVertikal(ws, data); Console.WriteLine("ok"); Console.Write($"Klemmenplan (Horizontal) erstellen ... "); ws = xlPackage.Workbook.Worksheets.Add($"{projectName}-KL-H"); WriteKlemmlisteHorizontal(ws, data); Console.WriteLine("ok"); }
/// <summary> /// Gets engangement plan data /// </summary> /// <param name="engagementId">The id of the engangement plan</param> /// <returns></returns> public static PlanData GetPlanData(Guid engagementId) { // this is the only thing there is needed right now, should be changed to a sql statement, if there are properties //See Sitecore.Modules.EmailCampaign.Core.Analytics.GetPlanData and Sitecore.Modules.EmailCampaign.Core.Analytics.GetPlanData var properties = typeof(PlanData).GetProperties().Where(t => Attribute.IsDefined(t, typeof(StateNameAttribute))); var database = Sitecore.Context.ContentDatabase ?? Sitecore.Context.Database; var engagementPlan = database.GetItem(ID.Parse(engagementId)); var childList = engagementPlan.Children; var planData = new PlanData(); foreach (var propertyInfo in properties) { var attribute = propertyInfo.GetCustomAttributes(typeof(StateNameAttribute), true).First() as StateNameAttribute; var stateItem = childList.FirstOrDefault(t => t.Name == attribute.StateName); Assert.IsNotNull(stateItem, "StateItem could not be found on {0} engangement plan", engagementId); var numberStateVisitors = VisitorManager.GetNumberStateVisitors(stateItem.ID); propertyInfo.SetValue(planData, numberStateVisitors); } return(planData); }
private TrickleInfo GetTrickleInfo(MessageItem message, VisitData visitData, PlanData planData) { MessageStateInfo messageStateInfo = this.GetMessageStateInfo(message); TrickleInfo info3 = new TrickleInfo(); info3.ID = messageStateInfo.ID; info3.Name = messageStateInfo.Name; info3.HasAbn = messageStateInfo.HasAbn; TrickleInfo info2 = info3; int emailCount = -1; if (planData != null) { PlanStatistics planStatistics = this.analyticsFactory.GetPlanStatistics(planData); info2.OpenRate = planStatistics.GetOpenRate(); info2.Recipients = planStatistics.GetTotal(); emailCount = planStatistics.GetActual(); } if (visitData != null) { info2.ValuePerVisit = visitData.ValuePerVisit; if (emailCount > -1) { info2.ValuePerEmail = this.analyticsFactory.GetVisitStatistics(visitData).GetValuePerEmail(emailCount); } } return(info2); }
public List <PlanData> getLevel() { string response = ""; List <PlanData> Plan_data = new List <PlanData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select * From LEVELS Order By LEVELCODE"; try { DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { PlanData Level_data = new PlanData(); Level_data.Level_Code = rowData["LEVELCODE"].ToString(); //รหัสระดับการศึกษา Level_data.Level_Name = rowData["LEVELNAME"].ToString(); //รหัสระดับการศึกษา Plan_data.Add(Level_data); } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:Plan: ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(Plan_data); }
public List <PlanData> getPlan() { string response = ""; List <PlanData> Plan_data = new List <PlanData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select * From CURRTYPE Order By CURRTYPECODE"; try { DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { PlanData Paln = new PlanData(); Paln.plan_code = rowData["CURRTYPECODE"].ToString(); //รหัสหลักสูตร Paln.plan_levalcode = rowData["LEVELCODE"].ToString(); //ระดับการศึกษา Paln.plan_name = rowData["CURRTYPENAME"].ToString(); //ชื่อประเภทหลักสูตร Plan_data.Add(Paln); } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:Paln: ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(Plan_data); }
public string updatePlan(PlanData updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update CURRTYPE Set LEVELCODE = '" + updateData.plan_levalcode + "', CURRTYPENAME='" + updateData.plan_name + "' Where CURRTYPECODE='" + updateData.plan_code + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:Plan: ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
private DispatchedMessageInfo BuildDispatchMessageInfo(MessageItem message, PlanData planData, VisitData visitData) { MessageStateInfo info = new MessageStateInfo(message); DispatchedMessageInfo info3 = new DispatchedMessageInfo(); info3.ID = info.ID; info3.Name = info.Name; info3.MessageType = info.Type; info3.Date = info.StartDate; info3.State = info.Status; DispatchedMessageInfo info2 = info3; if (planData != null) { DateTime time; DateTime time2; PlanStatistics planStatistics = AnalyticsFactory.Instance.GetPlanStatistics(planData); AnalyticsHelper.TryGetCampaignDates(message.CampaignId.ToGuid(), out time, out time2); info2.Sent = (time != time2) ? planStatistics.GetTotal() : 0; info2.OpenRate = planStatistics.GetOpenRate(); info2.ClickRate = planStatistics.GetClickRate(); } if (visitData != null) { info2.ValuePerVisit = visitData.ValuePerVisit; info2.Value = visitData.Value; } return info2; }
protected void btnSAVE_Click(object sender, EventArgs e) { PlanData dataSave = new PlanData(); dataSave.plan_code = txtEDU_PLAN_CODE.Text; dataSave.plan_name = txtEDU_PLAN_NAME.Text; dataSave.plan_levalcode = ddlLEVEL.SelectedValue; string result = ""; try { result = new Plan().updatePlan(dataSave); if (result == "OK") { Response.Redirect("list_Edu_Plan.aspx"); } else { Response.Redirect("list_Edu_Plan.aspx"); } } catch (Exception E) { //string response = E.Message.ToString(); //HttpContext.Current.Session["response"] = "Unit Test: " + response; //HttpContext.Current.Response.Redirect("err_response.aspx"); } }
private DispatchedMessageInfo BuildDispatchMessageInfo(MessageItem message, PlanData planData, VisitData visitData) { MessageStateInfo info = new MessageStateInfo(message); DispatchedMessageInfo info3 = new DispatchedMessageInfo(); info3.ID = info.ID; info3.Name = info.Name; info3.MessageType = info.Type; info3.Date = info.StartDate; info3.State = info.Status; DispatchedMessageInfo info2 = info3; if (planData != null) { DateTime time; DateTime time2; PlanStatistics planStatistics = AnalyticsFactory.Instance.GetPlanStatistics(planData); AnalyticsHelper.TryGetCampaignDates(message.CampaignId.ToGuid(), out time, out time2); info2.Sent = (time != time2) ? planStatistics.GetTotal() : 0; info2.OpenRate = planStatistics.GetOpenRate(); info2.ClickRate = planStatistics.GetClickRate(); } if (visitData != null) { info2.ValuePerVisit = visitData.ValuePerVisit; info2.Value = visitData.Value; } return(info2); }
public int DameIndexEspecialidad(int p) { List <Plan> planes = PlanData.GetAll(); int idEsp = 0; foreach (Plan pl in planes) { if (pl.ID == p) { idEsp = pl.IDEspecialidad; break; } } List <Especialidad> especialidades = new EspecialidadLogic().GetAll(); int i = 0; foreach (Especialidad esp in especialidades) { if (esp.ID == idEsp) { break; } ++i; } return(i); }
public string insertPlan(PlanData dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = ""; sql = "Insert Into CURRTYPE(CURRTYPECODE, LEVELCODE, CURRTYPENAME) Values('" + dataInsert.plan_code + "','" + dataInsert.plan_levalcode + "','" + dataInsert.plan_name + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); HttpContext.Current.Session["response"] = "Unit Test:Plan: ไม่สามารถดำเนินการได้"; HttpContext.Current.Response.Redirect("err_response.aspx"); } return(response); }
public UpdateStatePlanCommand(int reportId, PlanData planData) { ReportId = reportId; PlanData = planData ?? throw new ArgumentNullException(nameof(planData)); }
protected void btnSAVE_Click(object sender, EventArgs e) { string sql = "Select * From CURRTYPE Where CURRTYPECODE='" + txtEDU_PLAN_CODE.Text + "'"; List <PlanData> chkDup = new Plan().getPlanManual(sql); if (chkDup.Count > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('รหัสแผนการศึกษาซ้ำ!');", true); } else { PlanData data = new PlanData(); data.plan_code = txtEDU_PLAN_CODE.Text; data.plan_name = txtEDU_PLAN_NAME.Text; data.plan_levalcode = ddlLEVEL.SelectedValue; string result = ""; result = new Plan().insertPlan(data); if (result == "OK") { Response.Redirect("list_Edu_Plan.aspx"); } else { Response.Redirect("list_Edu_Plan.aspx"); } } }
public void BuildPath(PlanData pathToCheck) { path.Add(pathToCheck.interactableObject); if (pathToCheck.previousNode != null) { BuildPath(pathToCheck.previousNode); } }
private void btnNewPlan_Click(object sender, EventArgs e) { PlanData data = PlanData.Create(); PlanHelper.Create().AddPlanData(data); LoadPlanData(); lvPlan.SelectedIndex = lvPlan.Items.Count - 1; }
private void btnTestPlan_Click(object sender, EventArgs e) { //此处运行计划测试 frmSync sync = new frmSync(); PlanData pd = dsPlan[lvPlan.SelectedIndex]; sync.PlanData = pd; sync.ShowDialog(); }
private void btnRemovePlan_Click(object sender, EventArgs e) { PlanData data = dsPlan[lvPlan.SelectedIndex]; PlanHelper.Create().DeletePlanData(data); LoadPlanData(); lvPlan_SelectedIndexChanged(lvPlan, e); }
public void Init(AddPlanPanel addPlanPanel, PlanData planData) { _addPlanPanel = addPlanPanel; this.planData = planData; planName.text = planData.name; statsText.text = planData.workoutsPerWeek() + WORKOUTS_PER_WEEK_LABEL; UpdateColor(); fitBoyDifficulty.Init(WorkoutGenerator.Instance.GetSpriteForDifficulty(planData.planDifficulty)); }
private void btnRemoveStep_Click(object sender, EventArgs e) { if (dgvSqlSteps.Tag != null && (!LoadItem)) { PlanData dr = (PlanData)dgvSqlSteps.Tag; int index = dgvSqlSteps.SelectedRows[0].Index; DataGridViewCellCollection cells = dgvSqlSteps.Rows[index].Cells; int PlanDataID = (int)cells["PlanDataID_col"].Value; PlanHelper.Create().DeletePlanItemData(PlanDataID); LoadPlanDataItem(dr); } }
private void LoadPlanDataItem(PlanData dr) { LoadItem = true; dsPlanData = PlanHelper.Create().GetPlanItemData(dr.ID); FailMode.DataSource = fm; FailMode.DisplayMember = "Name"; FailMode.ValueMember = "Value"; dgvSqlSteps.DataSource = dsPlanData; dgvSqlSteps.Tag = dr; dgvSqlSteps.Refresh(); LoadItem = false; }
internal MonitorResourceData(ResourceIdentifier id, string name, ResourceType resourceType, SystemData systemData, IDictionary <string, string> tags, AzureLocation location, IdentityProperties identity, MonitoringStatus?monitoringStatus, MarketplaceSubscriptionStatus?marketplaceSubscriptionStatus, DynatraceEnvironmentProperties dynatraceEnvironmentProperties, UserInfo userInfo, PlanData planData, LiftrResourceCategories?liftrResourceCategory, int?liftrResourcePreference, ProvisioningState?provisioningState) : base(id, name, resourceType, systemData, tags, location) { Identity = identity; MonitoringStatus = monitoringStatus; MarketplaceSubscriptionStatus = marketplaceSubscriptionStatus; DynatraceEnvironmentProperties = dynatraceEnvironmentProperties; UserInfo = userInfo; PlanData = planData; LiftrResourceCategory = liftrResourceCategory; LiftrResourcePreference = liftrResourcePreference; ProvisioningState = provisioningState; }
private void ExportKomponenten(ExcelPackage xlPackage, PlanData data) { const int PROJECT_NAME_MAX_LENGTH = 15; var projectName = data.documentData.projectName.Truncate(PROJECT_NAME_MAX_LENGTH); //A workbook must have at least on cell, so lets add one... Console.Write($"Datenliste erstellen ... "); var ws = xlPackage.Workbook.Worksheets.Add($"{projectName}-Komponenten"); WriteKomponentenliste(ws, data); Console.WriteLine("ok"); }
public DailyPlan(DateTime date, PlanData job) { InitializeComponent(); this.Date = date; this.Job = job; fPanel.Width = pnlJob.Width; fPanel.Height = pnlJob.Height; pnlJob.Controls.Add(fPanel); dtpkDate.Value = Date; }
private static void WriteTrageschieneToCsv(CsvWriter csv, ref int lineNo, PlanData data, TrageschieneKonfiguration tragschienenKonfiguration) { csv.WriteRecord( new Rail { Name = $"{data.documentData.projectName} - {tragschienenKonfiguration.Name}", LineNumber = lineNo++, ArticleNumber = "801733", ArticleName = "NS 35/7,5 PERF 2000MM", }); csv.NextRecord(); }
/// <summary> /// /// add a plan to the billboard view /// /// </summary> /// <param name="plan">Plan object</param> /// <param name="data">PlanData metrics</param> public static void addPlanData(DataObjects.Plan plan, PlanData data) { // add the plan to a dictionary dashboardData[plan] = data; // sets the maximum bounds for each variable maxProfit = Math.Max(maxProfit, data.profit); maxOperatingCost = Math.Max(maxOperatingCost, data.operatingCost); maxstartupCost = Math.Max(maxstartupCost, data.startupCost); maxDeliveries = Math.Max(maxDeliveries, data.deliveries); maxMassDelivered = Math.Max(maxMassDelivered, data.massDelivered); maxParcelMass = Math.Max(maxParcelMass, data.parcelMass); maxFoodMass = Math.Max(maxFoodMass, data.foodMass); }
private void WriteKomponentenliste(ExcelWorksheet ws, PlanData data) { var treeNodes = data.treeNodes .First(x => x.text == "KNX-Komponenten").children.ToList(); int rowNo = 1; ws.Cells[rowNo, 1].Value = "Text"; ws.Column(1).Width = 40; ws.Cells[rowNo, 2].Value = "Typ"; ws.Column(2).Width = 40; WriteTreeNodes(ws, treeNodes, ref rowNo); }
public int DameIndex(int id) { List <Business.Entities.Plan> planes = PlanData.GetAll(); int i = 0; foreach (Plan pl in planes) { if (pl.ID == id) { break; } ++i; } return(i); }
void SetDefaultJob() { Job = new PlanData(); Job.Job = new List <Dulieu>(); Job.Job.Add(new Dulieu() { WorkDate = DateTime.Now, FromTime = new Point(4, 0), ToTime = new Point(5, 0), WorkName = "Thử nghiệm thôi", WorkStatus = Dulieu.ListStatus[(int)EPlanItem.COMING], DepartmentName = "CNTT", StaffName = "Tiến" }); }
private void btnNewStep_Click(object sender, EventArgs e) { if (dgvSqlSteps.Tag != null && (!LoadItem)) { PlanData dr = (PlanData)dgvSqlSteps.Tag; PlanDataItem item = PlanDataItem.Create(); item.PlanID = dr.ID; PlanHelper.Create().AddPlanItemData(item); LoadPlanDataItem(dr); int index = dgvSqlSteps.Rows.Count - 1; DataGridViewCellCollection cells = dgvSqlSteps.Rows[index].Cells; dgvSqlSteps.CurrentCell = cells[1]; dgvSqlSteps.BeginEdit(true); } }
private void btnSaveStep_Click(object sender, EventArgs e) { if (dgvSqlSteps.Tag != null && (!LoadItem)) { PlanData dr = (PlanData)dgvSqlSteps.Tag; int index = dgvSqlSteps.SelectedRows[0].Index; DataGridViewCellCollection cells = dgvSqlSteps.Rows[index].Cells; PlanDataItem item = PlanDataItem.Create(); item.PlanID = dr.ID; item.PlanDataID = (int)cells["PlanDataID_col"].Value; item.PlanDataName = cells["PlanDataName_col"].Value.ToString(); item.PlanSql = cells["PlanSql_col"].Value.ToString(); item.Index = (int)cells["Index"].Value; item.FailMode = (FailMode)(int)cells["FailMode"].Value; PlanHelper.Create().UpdatePlanItemData(item); LoadPlanDataItem(dr); } }
private SummaryReportMessageInfo GetSummaryInfo(MessageItem message, PlanData planData) { MessageStateInfo messageStateInfo = this.GetMessageStateInfo(message); SummaryReportMessageInfo info = new SummaryReportMessageInfo { ID = messageStateInfo.ID, Name = messageStateInfo.Name, Sent = messageStateInfo.Total, //returns GetAutomationStatesCount Delivered = messageStateInfo.Sent, //return (this.Processed - this.Failed); Processed means all that are not in RecipientsQueued or Send In Progress state Date = messageStateInfo.Updated, }; //int emailCount = -1; if (planData != null) { PlanStatistics planStatistics = this.analyticsFactory.GetPlanStatistics(planData); info.Opens = planStatistics.GetOpened(); info.Clicks = planStatistics.GetClicked(); //emailCount = planStatistics.GetActual(); // return (((this.GetTotal() - this.Data.InvalidAddress) - this.Data.MailBounced) - this.Data.Unsent); } return info; }
private DispatchedMessageInfo GetDispatchedInfo(MessageItem message, VisitData visitData, PlanData planData) { MessageStateInfo messageStateInfo = this.GetMessageStateInfo(message); DispatchedMessageInfo info3 = new DispatchedMessageInfo(); info3.ID = messageStateInfo.ID; info3.Name = messageStateInfo.Name; info3.State = messageStateInfo.Status; info3.Date = messageStateInfo.Updated; info3.Sent = messageStateInfo.Sent; info3.NumSubscribers = messageStateInfo.NumSubscribers; info3.MessageState = messageStateInfo.MessageState; DispatchedMessageInfo info2 = info3; int emailCount = -1; if (planData != null) { PlanStatistics planStatistics = AnalyticsFactory.Instance.GetPlanStatistics(planData); info2.OpenRate = planStatistics.GetOpenRate(); info2.ClickRate = planStatistics.GetClickRate(); emailCount = planStatistics.GetActual(); } if (visitData != null) { info2.ValuePerVisit = visitData.ValuePerVisit; if (emailCount > -1) { VisitStatistics visitStatistics = AnalyticsFactory.Instance.GetVisitStatistics(visitData); info2.ValuePerEmail = visitStatistics.GetValuePerEmail(emailCount); info2.VisitsPerEmail = visitStatistics.GetVisitPerEmail(emailCount); } } return info2; }
private TrickleInfo GetTrickleInfo(MessageItem message, VisitData visitData, PlanData planData) { MessageStateInfo messageStateInfo = this.GetMessageStateInfo(message); TrickleInfo info3 = new TrickleInfo(); info3.ID = messageStateInfo.ID; info3.Name = messageStateInfo.Name; info3.HasAbn = messageStateInfo.HasAbn; TrickleInfo info2 = info3; int emailCount = -1; if (planData != null) { PlanStatistics planStatistics = this.analyticsFactory.GetPlanStatistics(planData); info2.OpenRate = planStatistics.GetOpenRate(); info2.Recipients = planStatistics.GetTotal(); emailCount = planStatistics.GetActual(); } if (visitData != null) { info2.ValuePerVisit = visitData.ValuePerVisit; if (emailCount > -1) { info2.ValuePerEmail = this.analyticsFactory.GetVisitStatistics(visitData).GetValuePerEmail(emailCount); } } return info2; }