public bool LineNightInsert(LineInputNight line) { return(obj.LineInputNightInsert(line)); }
public bool LineNightUpdate(LineInputNight line) { return(obj.LineInputNightUpdate(line)); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { string color; if (ddlShift.SelectedValue.Equals("Day")) //DAY #region Day { LineColorDay_BLL colorLine = new LineColorDay_BLL(); LineInputDay lineStocking = new LineInputDay(); lineStocking = inputDay_BLL.InputDay_GetStocking(planid); stockingPosition = lineStocking.line; if (e.Row.RowType == DataControlRowType.Footer) { int index = GridView1.Rows.Count; GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Footer, DataControlRowState.Normal); TableCell cell = new TableCell(); cell.Text = "Stocking:"; cell.ColumnSpan = 4; row.Cells.Add(cell); cell = new TableCell(); cell.Text = "-"; row.Cells.Add(cell); cell = new TableCell(); cell.Text = "-"; row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.plan.ToString(); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.actual.ToString(); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.diff.ToString(); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.target.ToString(); row.Cells.Add(cell); cell = new TableCell(); float actualrateStocking = 0; if (lineStocking.target != 0) { actualrateStocking = (float)lineStocking.actual / lineStocking.target * 100; } cell.Text = actualrateStocking.ToString("F1") + "%"; row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h07.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color07H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h08.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color08H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h09.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color09H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h10.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color10H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h11.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color11H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h12.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color12H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h13.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color13H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h14.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color14H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h15.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color15H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h16.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color16H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h17.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color17H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h18.ToString(); cell.BackColor = setColor(colorLine.getColorDayByColum("Color18H", stockingPosition, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.comment.ToString(); row.Cells.Add(cell); GridView1.Controls[0].Controls.Add(row); } if (e.Row.RowType == DataControlRowType.DataRow) { int line = int.Parse(e.Row.Cells[0].Text); int lineNew = line + 7; if (line >= 44) { e.Row.Cells[0].Text = lineNew.ToString(); } if (inputDay_BLL.InputDay_CheckRSbyLine(line, planid)) { if (!e.Row.Cells[4].Text.Equals("")) { totalPW += common.ConvertInt(e.Row.Cells[4].Text); } if (!e.Row.Cells[5].Text.Equals("")) { totalAW += common.ConvertInt(e.Row.Cells[5].Text); } if (!e.Row.Cells[6].Text.Equals("")) { totalPl += common.ConvertInt(e.Row.Cells[6].Text); } if (!e.Row.Cells[7].Text.Equals("")) { totalAC += common.ConvertInt(e.Row.Cells[7].Text); } if (!e.Row.Cells[8].Text.Equals("")) { totalDiff += common.ConvertInt(e.Row.Cells[8].Text); } if (!e.Row.Cells[9].Text.Equals("")) { totalTarget += common.ConvertInt(e.Row.Cells[9].Text); } if (!e.Row.Cells[11].Text.Equals("")) { color = colorLine.getColorDayByColum("Color07H", line, planid); e.Row.Cells[11].BackColor = setColor(color); total7 += common.ConvertInt(e.Row.Cells[11].Text); } if (!e.Row.Cells[12].Text.Equals("")) { color = colorLine.getColorDayByColum("Color08H", line, planid); e.Row.Cells[12].BackColor = setColor(color); total8 += common.ConvertInt(e.Row.Cells[12].Text); } if (!e.Row.Cells[13].Text.Equals("")) { color = colorLine.getColorDayByColum("Color09H", line, planid); e.Row.Cells[13].BackColor = setColor(color); total9 += common.ConvertInt(e.Row.Cells[13].Text); } if (!e.Row.Cells[14].Text.Equals("")) { color = colorLine.getColorDayByColum("Color10H", line, planid); e.Row.Cells[14].BackColor = setColor(color); total10 += common.ConvertInt(e.Row.Cells[14].Text); } if (!e.Row.Cells[15].Text.Equals("")) { color = colorLine.getColorDayByColum("Color11H", line, planid); e.Row.Cells[15].BackColor = setColor(color); total11 += common.ConvertInt(e.Row.Cells[15].Text); } if (!e.Row.Cells[16].Text.Equals("")) { color = colorLine.getColorDayByColum("Color12H", line, planid); e.Row.Cells[16].BackColor = setColor(color); total12 += common.ConvertInt(e.Row.Cells[16].Text); } if (!e.Row.Cells[17].Text.Equals("")) { color = colorLine.getColorDayByColum("Color13H", line, planid); e.Row.Cells[17].BackColor = setColor(color); total13 += common.ConvertInt(e.Row.Cells[17].Text); } if (!e.Row.Cells[18].Text.Equals("")) { color = colorLine.getColorDayByColum("Color14H", line, planid); e.Row.Cells[18].BackColor = setColor(color); total14 += common.ConvertInt(e.Row.Cells[18].Text); } if (!e.Row.Cells[19].Text.Equals("")) { color = colorLine.getColorDayByColum("Color15H", line, planid); e.Row.Cells[19].BackColor = setColor(color); total15 += common.ConvertInt(e.Row.Cells[19].Text); } if (!e.Row.Cells[20].Text.Equals("")) { color = colorLine.getColorDayByColum("Color16H", line, planid); e.Row.Cells[20].BackColor = setColor(color); total16 += common.ConvertInt(e.Row.Cells[20].Text); } if (!e.Row.Cells[21].Text.Equals("")) { color = colorLine.getColorDayByColum("Color17H", line, planid); e.Row.Cells[21].BackColor = setColor(color); total17 += common.ConvertInt(e.Row.Cells[21].Text); } if (!e.Row.Cells[22].Text.Equals("")) { color = colorLine.getColorDayByColum("Color18H", line, planid); e.Row.Cells[22].BackColor = setColor(color); total18 += common.ConvertInt(e.Row.Cells[22].Text); } if (e.Row.Cells[23].Text.Trim().Equals("Run")) { e.Row.Cells[23].Text = "R"; e.Row.Cells[23].BackColor = Color.FromArgb(0, 204, 0); } else if (e.Row.Cells[23].Text.Trim().Equals("Stop")) { e.Row.Cells[23].Text = "S"; e.Row.Cells[23].BackColor = Color.Red; } } else { for (int i = 1; i < 23; i++) { e.Row.Cells[i].Text = ""; } e.Row.Cells[23].Text = "-"; } } } #endregion else //Night #region Night { LineColorNight_BLL colorLine = new LineColorNight_BLL(); LineInputNight lineStocking = new LineInputNight(); lineStocking = inputNight_BLL.InputNight_GetStocking(planid); if (e.Row.RowType == DataControlRowType.Footer) { int index = GridView1.Rows.Count; GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Footer, DataControlRowState.Normal); TableCell cell = new TableCell(); cell.Text = "Stocking:"; cell.ColumnSpan = 4; row.Cells.Add(cell); cell = new TableCell(); cell.Text = "-"; row.Cells.Add(cell); cell = new TableCell(); cell.Text = "-"; row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.plan.ToString(); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.actual.ToString(); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.diff.ToString(); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.target.ToString(); row.Cells.Add(cell); cell = new TableCell(); float actualrateStocking = 0; if (lineStocking.target != 0) { actualrateStocking = (float)lineStocking.actual / lineStocking.target * 100; } cell.Text = actualrateStocking.ToString("F1") + "%"; row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h19.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color19H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h20.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color20H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h21.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color21H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h22.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color22H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h23.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color23H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h00.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color00H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h01.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color01H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h02.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color02H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h03.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color03H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h04.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color04H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h05.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color05H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.h06.ToString(); cell.BackColor = setColor(colorLine.getColorNightByColum("Color06H", 39, planid)); row.Cells.Add(cell); cell = new TableCell(); cell.Text = lineStocking.comment.ToString(); row.Cells.Add(cell); GridView1.Controls[0].Controls.Add(row); } if (e.Row.RowType == DataControlRowType.DataRow) { int line = int.Parse(e.Row.Cells[0].Text); int lineNew = line + 7; if (line >= 44) { e.Row.Cells[0].Text = lineNew.ToString(); } if (inputNight_BLL.InputNight_CheckRSbyLine(line, planid)) { if (!e.Row.Cells[4].Text.Equals("")) { totalPW += common.ConvertInt(e.Row.Cells[4].Text); } if (!e.Row.Cells[5].Text.Equals("")) { totalAW += common.ConvertInt(e.Row.Cells[5].Text); } if (!e.Row.Cells[6].Text.Equals("")) { totalPl += common.ConvertInt(e.Row.Cells[6].Text); } if (!e.Row.Cells[7].Text.Equals("")) { totalAC += common.ConvertInt(e.Row.Cells[7].Text); } if (!e.Row.Cells[8].Text.Equals("")) { totalDiff += common.ConvertInt(e.Row.Cells[8].Text); } if (!e.Row.Cells[9].Text.Equals("")) { totalTarget += common.ConvertInt(e.Row.Cells[9].Text); } if (!e.Row.Cells[11].Text.Equals("")) { color = colorLine.getColorNightByColum("Color19H", line, planid); e.Row.Cells[11].BackColor = setColor(color); total19 += common.ConvertInt(e.Row.Cells[11].Text); } if (!e.Row.Cells[12].Text.Equals("")) { color = colorLine.getColorNightByColum("Color20H", line, planid); e.Row.Cells[12].BackColor = setColor(color); total20 += common.ConvertInt(e.Row.Cells[12].Text); } if (!e.Row.Cells[13].Text.Equals("")) { color = colorLine.getColorNightByColum("Color21H", line, planid); e.Row.Cells[13].BackColor = setColor(color); total21 += common.ConvertInt(e.Row.Cells[13].Text); } if (!e.Row.Cells[14].Text.Equals("")) { color = colorLine.getColorNightByColum("Color22H", line, planid); e.Row.Cells[14].BackColor = setColor(color); total22 += common.ConvertInt(e.Row.Cells[14].Text); } if (!e.Row.Cells[15].Text.Equals("")) { color = colorLine.getColorNightByColum("Color23H", line, planid); e.Row.Cells[15].BackColor = setColor(color); total23 += common.ConvertInt(e.Row.Cells[15].Text); } if (!e.Row.Cells[16].Text.Equals("")) { color = colorLine.getColorNightByColum("Color00H", line, planid); e.Row.Cells[16].BackColor = setColor(color); total0 += common.ConvertInt(e.Row.Cells[16].Text); } if (!e.Row.Cells[17].Text.Equals("")) { color = colorLine.getColorNightByColum("Color01H", line, planid); e.Row.Cells[17].BackColor = setColor(color); total1 += common.ConvertInt(e.Row.Cells[17].Text); } if (!e.Row.Cells[18].Text.Equals("")) { color = colorLine.getColorNightByColum("Color02H", line, planid); e.Row.Cells[18].BackColor = setColor(color); total2 += common.ConvertInt(e.Row.Cells[18].Text); } if (!e.Row.Cells[19].Text.Equals("")) { color = colorLine.getColorNightByColum("Color03H", line, planid); e.Row.Cells[19].BackColor = setColor(color); total3 += common.ConvertInt(e.Row.Cells[19].Text); } if (!e.Row.Cells[20].Text.Equals("")) { color = colorLine.getColorNightByColum("Color04H", line, planid); e.Row.Cells[20].BackColor = setColor(color); total4 += common.ConvertInt(e.Row.Cells[20].Text); } if (!e.Row.Cells[21].Text.Equals("")) { color = colorLine.getColorNightByColum("Color05H", line, planid); e.Row.Cells[21].BackColor = setColor(color); total5 += common.ConvertInt(e.Row.Cells[21].Text); } if (!e.Row.Cells[22].Text.Equals("")) { color = colorLine.getColorNightByColum("Color06H", line, planid); e.Row.Cells[22].BackColor = setColor(color); total6 += common.ConvertInt(e.Row.Cells[22].Text); } if (e.Row.Cells[23].Text.Trim().Equals("Run")) { e.Row.Cells[23].Text = "R"; e.Row.Cells[23].BackColor = Color.FromArgb(0, 204, 0); } else if (e.Row.Cells[23].Text.Trim().Equals("Stop")) { e.Row.Cells[23].Text = "S"; e.Row.Cells[23].BackColor = Color.Red; } } else { for (int i = 1; i < 23; i++) { e.Row.Cells[i].Text = ""; } e.Row.Cells[23].Text = "-"; } } } #endregion }
public LineInputNight LineInputSelectNightByLine(int line, int planid) { DataTable dt = new DataTable(); LineInputNight objLine = new LineInputNight(); try { using (SqlCommand command = new SqlCommand("LineInputNight_SelectByLine", openConnection())) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Line", line); command.Parameters.AddWithValue("@PlanId", planid); SqlDataAdapter da = new SqlDataAdapter(command); da.Fill(dt); objLine.line = int.Parse(dt.Rows[0]["LineName"].ToString()); objLine.rs = bool.Parse(dt.Rows[0]["RS"].ToString()); objLine.model = dt.Rows[0]["Model"].ToString(); objLine.changemodel = dt.Rows[0]["ChangeModel"].ToString(); objLine.planed_woker = commonFun.ConvertInt2(dt.Rows[0]["Planed_Worker"].ToString()); objLine.actual_woker = commonFun.ConvertInt2(dt.Rows[0]["Actual_Worker"].ToString()); objLine.acchived_rate = (float)commonFun.ConvertDouble(dt.Rows[0]["Archived_Rate"].ToString()); objLine.rank = dt.Rows[0]["Rank"].ToString(); objLine.plan = commonFun.ConvertInt2(dt.Rows[0]["Plan"].ToString()); objLine.tact_time = (float)commonFun.ConvertDouble(dt.Rows[0]["Tact_Time"].ToString()); objLine.total_min = commonFun.ConvertInt2(dt.Rows[0]["Total_Minute"].ToString()); objLine.actual = commonFun.ConvertInt2(dt.Rows[0]["Actual"].ToString()); objLine.diff = commonFun.ConvertInt2(dt.Rows[0]["Diff"].ToString()); objLine.target = commonFun.ConvertInt2(dt.Rows[0]["Target"].ToString()); objLine.h19 = commonFun.ConvertInt2(dt.Rows[0]["H19"].ToString()); objLine.h20 = commonFun.ConvertInt2(dt.Rows[0]["H20"].ToString()); objLine.h21 = commonFun.ConvertInt2(dt.Rows[0]["H21"].ToString()); objLine.h22 = commonFun.ConvertInt2(dt.Rows[0]["H22"].ToString()); objLine.h23 = commonFun.ConvertInt2(dt.Rows[0]["H23"].ToString()); objLine.h00 = commonFun.ConvertInt2(dt.Rows[0]["H00"].ToString()); objLine.h01 = commonFun.ConvertInt2(dt.Rows[0]["H01"].ToString()); objLine.h02 = commonFun.ConvertInt2(dt.Rows[0]["H02"].ToString()); objLine.h03 = commonFun.ConvertInt2(dt.Rows[0]["H03"].ToString()); objLine.h04 = commonFun.ConvertInt2(dt.Rows[0]["H04"].ToString()); objLine.h05 = commonFun.ConvertInt2(dt.Rows[0]["H05"].ToString()); objLine.h06 = commonFun.ConvertInt2(dt.Rows[0]["H06"].ToString()); objLine.from1 = dt.Rows[0]["From1"].ToString(); objLine.to1 = dt.Rows[0]["To1"].ToString(); objLine.from2 = dt.Rows[0]["From2"].ToString(); objLine.to2 = dt.Rows[0]["To2"].ToString(); objLine.from3 = dt.Rows[0]["From3"].ToString(); objLine.to3 = dt.Rows[0]["To3"].ToString(); objLine.from4 = dt.Rows[0]["From4"].ToString(); objLine.to4 = dt.Rows[0]["To4"].ToString(); objLine.from5 = dt.Rows[0]["From5"].ToString(); objLine.to5 = dt.Rows[0]["To5"].ToString(); objLine.from6 = dt.Rows[0]["From6"].ToString(); objLine.to6 = dt.Rows[0]["To6"].ToString(); objLine.comment = dt.Rows[0]["Comments"].ToString(); objLine.status = dt.Rows[0]["Status"].ToString(); objLine.changedActual = bool.Parse(dt.Rows[0]["ChangedPlaned"].ToString()); } } catch (System.Exception) { } this.closeConnection(); return(objLine); }
public bool LineInputNightUpdate(LineInputNight line) { int result = 0; using (SqlCommand command = new SqlCommand("LineInputNight_Update", openConnection())) { try { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@LineName", line.line)); command.Parameters.Add(new SqlParameter("@PlanId", line.planid)); command.Parameters.Add(new SqlParameter("@Model", line.model)); command.Parameters.Add(new SqlParameter("@ModelA", line.modelA)); command.Parameters.Add(new SqlParameter("@ModelB", line.modelB)); command.Parameters.Add(new SqlParameter("@ModelC", line.modelC)); command.Parameters.Add(new SqlParameter("@RS", line.rs)); command.Parameters.Add(new SqlParameter("@ChangeModel", line.changemodel)); // if (line.planed_woker == -1) { command.Parameters.Add(new SqlParameter("@Planed_Worker", null)); } else { command.Parameters.Add(new SqlParameter("@Planed_Worker", line.planed_woker)); } // if (line.actual_woker == -1) { command.Parameters.Add(new SqlParameter("@Actual_Worker", null)); } else { command.Parameters.Add(new SqlParameter("@Actual_Worker", line.actual_woker)); } // if (line.plan == -1) { command.Parameters.Add(new SqlParameter("@Plan", null)); } else { command.Parameters.Add(new SqlParameter("@Plan", line.plan)); } // command.Parameters.Add(new SqlParameter("@Tact_Time", line.tact_time)); // if (line.total_min == -1) { command.Parameters.Add(new SqlParameter("@Total_Minute", null)); } else { command.Parameters.Add(new SqlParameter("@Total_Minute", line.total_min)); } // if (line.actual == -1) { command.Parameters.Add(new SqlParameter("@Actual", null)); } else { command.Parameters.Add(new SqlParameter("@Actual", line.actual)); } // if (line.diff == -1) { command.Parameters.Add(new SqlParameter("@Diff", null)); } else { command.Parameters.Add(new SqlParameter("@Diff", line.diff)); } // if (line.target == -1) { command.Parameters.Add(new SqlParameter("@Target", null)); } else { command.Parameters.Add(new SqlParameter("@Target", line.target)); } // command.Parameters.Add(new SqlParameter("@Archived_Rate", line.acchived_rate)); command.Parameters.Add(new SqlParameter("@Rank", line.rank)); command.Parameters.Add(new SqlParameter("@From1", line.from1)); command.Parameters.Add(new SqlParameter("@To1", line.to1)); command.Parameters.Add(new SqlParameter("@From2", line.from2)); command.Parameters.Add(new SqlParameter("@To2", line.to2)); command.Parameters.Add(new SqlParameter("@From3", line.from3)); command.Parameters.Add(new SqlParameter("@To3", line.to3)); command.Parameters.Add(new SqlParameter("@From4", line.from4)); command.Parameters.Add(new SqlParameter("@To4", line.to4)); command.Parameters.Add(new SqlParameter("@From5", line.from5)); command.Parameters.Add(new SqlParameter("@To5", line.to5)); command.Parameters.Add(new SqlParameter("@From6", line.from6)); command.Parameters.Add(new SqlParameter("@To6", line.to6)); // if (line.h19 == -1) { command.Parameters.Add(new SqlParameter("@H19", null)); } else { command.Parameters.Add(new SqlParameter("@H19", line.h19)); } // if (line.h20 == -1) { command.Parameters.Add(new SqlParameter("@H20", null)); } else { command.Parameters.Add(new SqlParameter("@H20", line.h20)); } // if (line.h21 == -1) { command.Parameters.Add(new SqlParameter("@H21", null)); } else { command.Parameters.Add(new SqlParameter("@H21", line.h21)); } // if (line.h22 == -1) { command.Parameters.Add(new SqlParameter("@H22", null)); } else { command.Parameters.Add(new SqlParameter("@H22", line.h22)); } // if (line.h23 == -1) { command.Parameters.Add(new SqlParameter("@H23", null)); } else { command.Parameters.Add(new SqlParameter("@H23", line.h23)); } // if (line.h00 == -1) { command.Parameters.Add(new SqlParameter("@H00", null)); } else { command.Parameters.Add(new SqlParameter("@H00", line.h00)); } // if (line.h01 == -1) { command.Parameters.Add(new SqlParameter("@H01", null)); } else { command.Parameters.Add(new SqlParameter("@H01", line.h01)); } // if (line.h02 == -1) { command.Parameters.Add(new SqlParameter("@H02", null)); } else { command.Parameters.Add(new SqlParameter("@H02", line.h02)); } // if (line.h03 == -1) { command.Parameters.Add(new SqlParameter("@H03", null)); } else { command.Parameters.Add(new SqlParameter("@H03", line.h03)); } // if (line.h04 == -1) { command.Parameters.Add(new SqlParameter("@H04", null)); } else { command.Parameters.Add(new SqlParameter("@H04", line.h04)); } // if (line.h05 == -1) { command.Parameters.Add(new SqlParameter("@H05", null)); } else { command.Parameters.Add(new SqlParameter("@H05", line.h05)); } if (line.h06 == -1) { command.Parameters.Add(new SqlParameter("@H06", null)); } else { command.Parameters.Add(new SqlParameter("@H06", line.h06)); } command.Parameters.Add(new SqlParameter("@Comments", line.comment)); command.Parameters.Add(new SqlParameter("@Status", line.status)); result = command.ExecuteNonQuery(); } catch (SqlException) { return(false); } finally { this.closeConnection(); } return(result > 0); } }
protected void btnSave_Click(object sender, ImageClickEventArgs e) { ImageButton btnBack = (ImageButton)sender; GridViewRow row = (GridViewRow)btnBack.NamingContainer; ImageButton btnSave = (ImageButton)row.FindControl("btnSave"); LineInputNight line_ = new LineInputNight(); int actualcount = 0; line_ = input.LineNightByLine(int.Parse(row.Cells[0].Text), planid); btnSave.Visible = false; btnBack.Visible = false; if (DateTime.Now.Hour <= 23 && DateTime.Now.Hour >= 19) { for (int i = 19; i <= DateTime.Now.Hour; i++) { int a = 0; string hourStr = this.convertIntegerLessThan10(i); Label lblhour = (Label)row.FindControl("lbl" + hourStr + "H"); TextBox txthour = (TextBox)row.FindControl("txt" + hourStr + "H"); if (int.TryParse(txthour.Text, out a)) { actualcount += a; if (i == 19) { line_.h19 = a; } else if (i == 20) { line_.h20 = a; } else if (i == 21) { line_.h21 = a; } else if (i == 22) { line_.h22 = a; } else if (i == 23) { line_.h23 = a; } } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Error: " + txthour.ID + " is not integer type');", true); return; } } } else if (DateTime.Now.Hour <= 6) { for (int i = 19; i <= 23; i++) { int a = 0; string hourStr = this.convertIntegerLessThan10(i); Label lblhour = (Label)row.FindControl("lbl" + hourStr + "H"); TextBox txthour = (TextBox)row.FindControl("txt" + hourStr + "H"); if (int.TryParse(txthour.Text, out a)) { actualcount += a; if (i == 19) { line_.h19 = a; } else if (i == 20) { line_.h20 = a; } else if (i == 21) { line_.h21 = a; } else if (i == 22) { line_.h22 = a; } else if (i == 23) { line_.h23 = a; } } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Error: " + txthour.ID + " is not integer type');", true); return; } } for (int i = 0; i <= DateTime.Now.Hour; i++) { int a = 0; string hourStr = this.convertIntegerLessThan10(i); Label lblhour = (Label)row.FindControl("lbl" + hourStr + "H"); TextBox txthour = (TextBox)row.FindControl("txt" + hourStr + "H"); if (int.TryParse(txthour.Text, out a)) { actualcount += a; if (i == 0) { line_.h00 = a; } else if (i == 1) { line_.h01 = a; } else if (i == 2) { line_.h02 = a; } else if (i == 3) { line_.h03 = a; } else if (i == 4) { line_.h04 = a; } else if (i == 5) { line_.h05 = a; } else if (i == 6) { line_.h06 = a; } } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Error: " + txthour.ID + " is not integer type');", true); return; } } } else { for (int i = 19; i <= 23; i++) { int a = 0; string hourStr = this.convertIntegerLessThan10(i); Label lblhour = (Label)row.FindControl("lbl" + hourStr + "H"); TextBox txthour = (TextBox)row.FindControl("txt" + hourStr + "H"); if (int.TryParse(txthour.Text, out a)) { actualcount += a; if (i == 19) { line_.h19 = a; } else if (i == 20) { line_.h20 = a; } else if (i == 21) { line_.h21 = a; } else if (i == 22) { line_.h22 = a; } else if (i == 23) { line_.h23 = a; } } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Error: " + txthour.ID + " is not integer type');", true); return; } } for (int i = 0; i <= 6; i++) { int a = 0; string hourStr = this.convertIntegerLessThan10(i); Label lblhour = (Label)row.FindControl("lbl" + hourStr + "H"); TextBox txthour = (TextBox)row.FindControl("txt" + hourStr + "H"); if (int.TryParse(txthour.Text, out a)) { actualcount += a; if (i == 0) { line_.h00 = a; } else if (i == 1) { line_.h01 = a; } else if (i == 2) { line_.h02 = a; } else if (i == 3) { line_.h03 = a; } else if (i == 4) { line_.h04 = a; } else if (i == 5) { line_.h05 = a; } else if (i == 6) { line_.h06 = a; } } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Error: " + txthour.ID + " is not integer type');", true); return; } } } line_.actual = actualcount; line_.planid = planid; if (input.LineNightUpdate(line_)) { if (DateTime.Now.Hour >= 7 && DateTime.Now.Hour <= 18) { for (int i = 0; i <= 6; i++) { string hourStr = this.convertIntegerLessThan10(i); Label lblhour = (Label)row.FindControl("lbl" + hourStr + "H"); TextBox txthour = (TextBox)row.FindControl("txt" + hourStr + "H"); lblhour.Text = txthour.Text; lblhour.Visible = true; txthour.Visible = false; setActiveRowEvent(row, false); } for (int i = 19; i <= 23; i++) { string hourStr = this.convertIntegerLessThan10(i); Label lblhour = (Label)row.FindControl("lbl" + hourStr + "H"); TextBox txthour = (TextBox)row.FindControl("txt" + hourStr + "H"); lblhour.Text = txthour.Text; lblhour.Visible = true; txthour.Visible = false; setActiveRowEvent(row, false); } input_BLL.LineInputNight_ChangeActual(int.Parse(row.Cells[0].Text), true, planid); Response.Redirect("ChangeActualInputNight.aspx"); } else { if (DateTime.Now.Hour >= 19 && DateTime.Now.Hour <= 23) { for (int i = 19; i <= DateTime.Now.Hour; i++) { string hourStr = this.convertIntegerLessThan10(i); Label lblhour = (Label)row.FindControl("lbl" + hourStr + "H"); TextBox txthour = (TextBox)row.FindControl("txt" + hourStr + "H"); lblhour.Text = txthour.Text; lblhour.Visible = true; txthour.Visible = false; setActiveRowEvent(row, false); } input_BLL.LineInputNight_ChangeActual(int.Parse(row.Cells[0].Text), true, planid); Response.Redirect("ChangeActualInputNight.aspx"); } else { for (int i = 19; i <= 23; i++) { string hourStr = this.convertIntegerLessThan10(i); Label lblhour = (Label)row.FindControl("lbl" + hourStr + "H"); TextBox txthour = (TextBox)row.FindControl("txt" + hourStr + "H"); lblhour.Text = txthour.Text; lblhour.Visible = true; txthour.Visible = false; setActiveRowEvent(row, false); } for (int i = 0; i <= DateTime.Now.Hour; i++) { string hourStr = this.convertIntegerLessThan10(i); Label lblhour = (Label)row.FindControl("lbl" + hourStr + "H"); TextBox txthour = (TextBox)row.FindControl("txt" + hourStr + "H"); lblhour.Text = txthour.Text; lblhour.Visible = true; txthour.Visible = false; setActiveRowEvent(row, false); } input_BLL.LineInputNight_ChangeActual(int.Parse(row.Cells[0].Text), true, planid); Response.Redirect("ChangeActualInputNight.aspx"); } } } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Error: Can't save to Database, try again');", true); return; } }
public LineInputNight LineNight_GetStocking(int planid) { DataTable dt = new DataTable(); LineInputNight line_ = new LineInputNight(); using (SqlCommand command = new SqlCommand("Select * FROM LineInputNight Where Model = @Model And PlanId= @PlanId", openConnection())) { command.Parameters.Add(new SqlParameter("@Model", "Stocking")); command.Parameters.Add(new SqlParameter("@PlanId", planid)); SqlDataAdapter da = new SqlDataAdapter(command); da.Fill(dt); int i = 0; this.closeConnection(); line_.line = int.Parse(dt.Rows[0]["LineName"].ToString()); if (int.TryParse(dt.Rows[0]["Actual"].ToString(), out i)) { line_.actual = i; } if (int.TryParse(dt.Rows[0]["Plan"].ToString(), out i)) { line_.plan = i; } if (int.TryParse(dt.Rows[0]["Diff"].ToString(), out i)) { line_.diff = i; } if (int.TryParse(dt.Rows[0]["Target"].ToString(), out i)) { line_.target = i; } if (int.TryParse(dt.Rows[0]["H19"].ToString(), out i)) { line_.h19 = i; } if (int.TryParse(dt.Rows[0]["H20"].ToString(), out i)) { line_.h20 = i; } if (int.TryParse(dt.Rows[0]["H21"].ToString(), out i)) { line_.h21 = i; } if (int.TryParse(dt.Rows[0]["H22"].ToString(), out i)) { line_.h22 = i; } if (int.TryParse(dt.Rows[0]["H23"].ToString(), out i)) { line_.h23 = i; } if (int.TryParse(dt.Rows[0]["H00"].ToString(), out i)) { line_.h00 = i; } if (int.TryParse(dt.Rows[0]["H01"].ToString(), out i)) { line_.h01 = i; } if (int.TryParse(dt.Rows[0]["H02"].ToString(), out i)) { line_.h02 = i; } if (int.TryParse(dt.Rows[0]["H03"].ToString(), out i)) { line_.h03 = i; } if (int.TryParse(dt.Rows[0]["H04"].ToString(), out i)) { line_.h04 = i; } if (int.TryParse(dt.Rows[0]["H05"].ToString(), out i)) { line_.h05 = i; } if (int.TryParse(dt.Rows[0]["H06"].ToString(), out i)) { line_.h06 = i; } line_.comment = dt.Rows[0]["Comments"].ToString(); line_.status = dt.Rows[0]["Status"].ToString(); } return(line_); }