private void ss1_Clk(int col, int row) { if (ss1.ActiveSheet.RowCount <= 0) { return; } if ((col == SS1_SMP_YN | col == SS1_LINE1 | col == SS1_LINE2 | col == SS1_LINE3 | col == SS1_LINE4)) { //ss1.EditMode = true; //if (ss1.ActiveSheet.Cells[row, col].Text == "False") //{ // ss1.ActiveSheet.Cells[row, col].Value = 1; //} else { // ss1.ActiveSheet.Cells[row, col].Value = 0; //} if (ss1.ActiveSheet.Cells[row, col].Text == "True") { if (col == SS1_LINE1) { ss1.ActiveSheet.Cells[row, SS1_LINE2].Value = 0; ss1.ActiveSheet.Cells[row, SS1_LINE3].Value = 0; ss1.ActiveSheet.Cells[row, SS1_LINE4].Value = 0; ss1.ActiveSheet.Cells[row, SS1_OFFLINE_DATE].Text = ""; } else if (col == SS1_LINE2) { ss1.ActiveSheet.Cells[row, SS1_LINE1].Value = 0; ss1.ActiveSheet.Cells[row, SS1_LINE3].Value = 0; ss1.ActiveSheet.Cells[row, SS1_LINE4].Value = 0; ss1.ActiveSheet.Cells[row, SS1_OFFLINE_DATE].Text = ""; } else if (col == SS1_LINE3) { ss1.ActiveSheet.Cells[row, SS1_LINE1].Value = 0; ss1.ActiveSheet.Cells[row, SS1_LINE2].Value = 0; ss1.ActiveSheet.Cells[row, SS1_LINE4].Value = 0; } else if (col == SS1_LINE4) { ss1.ActiveSheet.Cells[row, SS1_LINE1].Value = 0; ss1.ActiveSheet.Cells[row, SS1_LINE2].Value = 0; ss1.ActiveSheet.Cells[row, SS1_LINE3].Value = 0; } } else { ss1.ActiveSheet.RowHeader.Cells[row, 0].Text = ""; } ss1.ActiveSheet.Cells[row, SS1_USERID].Text = GeneralCommon.sUserID; SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, row, row, Color.Black, SSP1.BackColor); //txt_tmpseq.Text = ss1.ActiveSheet.ActiveRowIndex; } }
public override void Form_Ref() { string SMESG; int lRow; string sSmp_color; string sCnt_color; p_Ref(1, 1, true, true); for (lRow = 1; lRow <= ss1.ActiveSheet.RowCount; lRow++) { // 一坯多订单,字体显示蓝色 2011-08-18 by LiQian if (ss1.ActiveSheet.Cells[lRow - 1, SS1_ORD_CNT].Text != "") { if (Convert.ToInt32(ss1.ActiveSheet.Cells[lRow - 1, SS1_ORD_CNT].Text) > 1) { sCnt_color = "#0000FF"; } else { sCnt_color = "#000000"; } SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, ColorTranslator.FromHtml(sCnt_color), Color.White); } if (ss1.ActiveSheet.Cells[lRow - 1, SS1_PRC_LINE].Text != "X") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP2.BackColor); } if (ss1.ActiveSheet.Cells[lRow - 1, SS1_PLAN_SMP].Text != "") { if (ss1.ActiveSheet.Cells[lRow - 1, SS1_PLAN_SMP].Text == "Y") { sSmp_color = "#FF0000"; } else { sSmp_color = "#000000"; } SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, ColorTranslator.FromHtml(sSmp_color), SSP3.BackColor); } //紧急订单绿色标记 2012-08-16 by LiQian if (ss1.ActiveSheet.Cells[lRow - 1, SS1_URGNT_FL].Text == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_MPLATE_NO, SS1_MPLATE_NO, lRow - 1, lRow - 1, Color.Green, Color.White); SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_TRNS_CMPY_CD, SS1_TRNS_CMPY_CD, lRow - 1, lRow - 1, Color.Green, Color.White); SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_URGNT_FL, SS1_URGNT_FL, lRow - 1, lRow - 1, Color.Green, Color.White); } if (ss1.ActiveSheet.Cells[lRow - 1, SS1_IMP_CONT].Text == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_MPLATE_NO, SS1_MPLATE_NO, lRow - 1, lRow - 1, SSP4.BackColor, Color.White); SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_IMP_CONT, SS1_IMP_CONT, lRow - 1, lRow - 1, SSP4.BackColor, Color.White); } } }
public override void Spread_Can() { int ss1Row; int ss2Row; int iCnt; int iCnt1; string iPlate_no; //ss2.Col = 0; //ss2.ROW = ss2.ActiveSheet.ActiveRowIndex; if (ss2.ActiveSheet.RowHeader.Cells[ss2.ActiveSheet.ActiveRowIndex, 0].Text == "增加") { for (ss2Row = ss2.ActiveSheet.ActiveRowIndex; ss2Row >= 0; ss2Row += -1) { //ss2.Col = 2; //ss2.ROW = ss2Row; if (ss2.ActiveSheet.Cells[ss2Row, 1].Text.Length == 14) { iPlate_no = ss2.ActiveSheet.Cells[ss2Row, 1].Text; ss2.ActiveSheet.Cells[ss2Row, 1].Text = ""; //ss2.Col = 0; ss2.ActiveSheet.RowHeader.Cells[ss2Row, 0].Text = ""; for (ss1Row = 1; ss1Row <= ss1.ActiveSheet.RowCount; ss1Row++) { //ss1.ROW = ss1Row; //ss1.Col = 0; if (ss1.ActiveSheet.RowHeader.Cells[ss1Row - 1, 0].Text == "增加") { //ss1.Col = 1; if (ss1.ActiveSheet.Cells[ss1Row - 1, 0].Text == iPlate_no) { //ss1.Col = 0; ss1.ActiveSheet.RowHeader.Cells[ss1Row - 1, 0].Text = ""; SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, ss1Row - 1, ss1Row - 1, Color.Black, ColorTranslator.FromHtml("#FFFFFF")); //ss1.Col = 7; TXT_CNT.Text = (Convert.ToInt32(TXT_CNT.Text) - 1).ToString(); TXT_WGT.Text = (Convert.ToDouble(TXT_WGT.Text) - Convert.ToDouble(ss1.ActiveSheet.Cells[ss1Row - 1, 6].Text)).ToString(); if (TXT_CNT.Text == "0") { TXT_CNT.Text = ""; TXT_WGT.Text = ""; } } } } } } } }
private void ss1_CellClick(object sender, CellClickEventArgs e) { int lRow; string sBlockSeq; string sSeq; if (ss1.ActiveSheet.RowCount <= 0) { return; } TXT_SLAB_NO.Text = ss1.ActiveSheet.Cells[e.Row, 0].Text; SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, 0, ss1.ActiveSheet.RowCount - 1, Color.Black, Color.White); Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, e.Row, e.Row, Color.Black, SSP1.BackColor); if (OPT_FP_SLAB_DES.Checked) { p_Ref(2, 2, false, false); } else if (OPT_FP_SLAB_DES1.Checked) { p_Ref(4, 4, false, false); } else { p_Ref(6, 6, false, false); } TXT_SLAB_NO.Text = ""; for (lRow = 1; lRow <= ss2.ActiveSheet.RowCount; lRow++) { sBlockSeq = ss2.ActiveSheet.Cells[lRow - 1, SS2_BLOCK_SEQ].Text; sSeq = ss2.ActiveSheet.Cells[lRow - 1, SS2_SEQ].Text; if (sBlockSeq + sSeq == "0000") { Gp_Sp_BlockColor(ss2, 0, ss2.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP1.BackColor); ss2.ActiveSheet.Cells[lRow - 1, SS2_PROD_CD].Text = "轧件"; } else if (sSeq == "00") { Gp_Sp_BlockColor(ss2, 0, ss2.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP2.BackColor); ss2.ActiveSheet.Cells[lRow - 1, SS2_PROD_CD].Text = "母板" + sBlockSeq; } else { Gp_Sp_BlockColor(ss2, 0, ss2.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP3.BackColor); ss2.ActiveSheet.Cells[lRow - 1, SS2_PROD_CD].Text = "钢板"; } } }
public override void Form_Ref() { string SMESG; int iRow; string sCurDate; string sDel_To_Date; string sURGNT; sCurDate = DateTime.Now.ToString("yyyyMM"); if (!opt_LineFlag0.Checked & !opt_LineFlag2.Checked) { GeneralCommon.Gp_MsgBoxDisplay("请选择精整等待或精整保留...!", "I", ""); return; } p_Ref(1, 1, true, true); //无数据则退出 if (ss1.ActiveSheet.RowCount <= 0) { return; } //超交货期用红色显示 add by liqian 2012-07-23 { for (iRow = 1; iRow <= ss1.ActiveSheet.RowCount; iRow++) { sDel_To_Date = substr(ss1.ActiveSheet.Cells[iRow - 1, SS1_DEL_DATE_TO].Text, 0, 6); if (sDel_To_Date != "" && convertX(sDel_To_Date) < convertX(sCurDate)) { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Red, Color.White); } //是否紧急订单警示 sURGNT = ss1.ActiveSheet.Cells[iRow - 1, SPD_URGNT_FL].Text; if (sURGNT == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Green, Color.White); } } Text1_PLATE_NO.Text = ss1.ActiveSheet.Cells[0, SS1_PLATE_NO].Text; txt_REMARKS.Text = ""; p_Ref(2, 0, true, false); } }
// 重写查询 public override void Form_Ref() { //// 板坯查询(1 有计划未装炉 / 2 已入炉未出炉) //if (chk_ref.Checked) //{ // p_Ref(3, 1, true, false); //} //// 板坯装炉 //if (SSCheck1.Checked & txt_SlabNo.Text.Trim().Length == 10) //{ // p_Ref(1, 0, true, false); //} //// 板坯出炉 //if (sc3.Checked & txt_SlabNo.Text.Trim().Length == 10) //{ // p_Ref(2, 0, true, false); //} int iRow; int iCol; string sCurDate; string sDel_To_Date; string sUrgnt_Fl; string simpcont; string simpcont1; sCurDate = System.DateTime.Now.ToString("yyyyMM"); if (0 == tabControl1.SelectedIndex) { p_Ref(0, 1, true, false); opt_EntCan0.Checked = true; iCol = 0; iRow = txt_tmpseq.Text == "" ? 0 : Convert.ToInt32(txt_tmpseq.Text); //ss1.SetActiveCell 1, ss1.ROW if (ss1.ActiveSheet.RowCount > 0) { if (SSCheck1.Checked & opt_EntCan0.Checked) { txt_SlabNo.Text = ss1.ActiveSheet.Cells[iRow, SS1_SLAB_NO].Value.ToString(); TXT_SLAB_SIZE.Text = ss1.ActiveSheet.Cells[iRow, SS1_SLAB_SIZE].Value.ToString(); txt_RollingSize.Text = ss1.ActiveSheet.Cells[iRow, SS1_MILL_SIZE].Value.ToString(); } else if (sc3.Checked) { } } for (iRow = 1; iRow <= ss1.ActiveSheet.RowCount; iRow++) { if (ss1.ActiveSheet.RowCount <= 0) { break; } sUrgnt_Fl = ss1.ActiveSheet.Cells[iRow - 1, SS1_URGNT_FL].Value.ToString(); sDel_To_Date = ss1.ActiveSheet.Cells[iRow - 1, SS1_DEL_TO_DATE].Value.ToString().Substring(0, 6); if (Convert.ToInt32(sDel_To_Date) < Convert.ToInt32(sCurDate)) { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Red, Color.White); } //紧急订单绿色显示 add by liqian 2012-08-15 if (sUrgnt_Fl == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Green, Color.White); } simpcont = ss1.ActiveSheet.Cells[iRow - 1, SS1_IMP_CONT].Text; if (simpcont == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_SLAB_NO, SS1_SLAB_NO, iRow - 1, iRow - 1, SSP4.BackColor, Color.White); SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_IMP_CONT, SS1_IMP_CONT, iRow - 1, iRow - 1, SSP4.BackColor, Color.White); } } for (iRow = 1; iRow <= ss2.ActiveSheet.RowCount; iRow++) { if (ss2.ActiveSheet.RowCount <= 0) { break; } simpcont = ss2.ActiveSheet.Cells[iRow - 1, SS2_IMP_CONT].Text; if (simpcont == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, SS2_SLAB_NO, SS2_SLAB_NO, iRow - 1, iRow - 1, SSP4.BackColor, Color.White); SpreadCommon.Gp_Sp_BlockColor(ss1, SS2_IMP_CONT, SS2_IMP_CONT, iRow - 1, iRow - 1, SSP4.BackColor, Color.White); } } } else if (1 == tabControl1.SelectedIndex) { p_Ref(3, 2, true, false); } }
public override void Form_Ref() { int iRow; int iCol; string sCurDate; string sDel_To_Date; string sUrgnt_Fl; string sUst_Fl; string sFlag; string sexport; string sOrdcnt; unlockSpread(ss2); sCurDate = DateTime.Now.ToString("yyyyMM"); if (tab1.SelectedIndex == 0) { p_Ref(0, 2, true, false); p_Ref(0, 4, true, false); if (ss2.ActiveSheet.RowCount <= 0) { return; //防止报错 VB没有这段代码 } if (ss2.ActiveSheet.Cells[0, 0].Text.ToString() != "") { txt_SlabNo.Text = ss2.ActiveSheet.Cells[0, 0].Text.ToString(); if (p_Ref(1, 0, true, false) & p_Ref(2, 1, true, false)) { TXT_MILL_STA_TIME.Text = Gf_DTSet("", "X"); TXT_SHIFT.Text = Gf_ShiftSet3(""); TXT_GROUP.Text = Gf_GroupSet(TXT_SHIFT.Text, Gf_DTSet("", "X")); TXT_EMP1.Text = GeneralCommon.sUserID; } } else { txt_SlabNo.Text = ""; } //超交货期用红色显示 add by liqian 2012-06-11 { for (iRow = 1; iRow <= ss2.ActiveSheet.RowCount; iRow++) { sDel_To_Date = ss2.ActiveSheet.Cells[iRow - 1, SS2_DEL_TO_DATE].Text.ToString().Substring(0, 6); sUrgnt_Fl = ss2.ActiveSheet.Cells[iRow - 1, SS2_URGNT_FL].Text.ToString().Trim(); if (Convert.ToDouble(sDel_To_Date) < Convert.ToDouble(sCurDate)) { SpreadCommon.Gp_Sp_BlockColor(ss2, 0, ss2.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Red, Color.White); } //紧急订单绿色显示 add by liqian 2012-08-15 if (sUrgnt_Fl == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss2, 0, ss2.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Green, Color.White); } //是否探伤 add by liqian 2013-04-08 sUst_Fl = ss2.ActiveSheet.Cells[iRow - 1, SS2_UST_FL].Text.ToString().Trim(); if (sUst_Fl == "是") { SpreadCommon.Gp_Sp_BlockColor(ss2, SS2_SLAB_NO, SS2_SLAB_NO, iRow - 1, iRow - 1, Color.Fuchsia, Color.White); SpreadCommon.Gp_Sp_BlockColor(ss2, SS2_UST_FL, SS2_UST_FL, iRow - 1, iRow - 1, Color.Fuchsia, Color.White); } //是否定制配送 sFlag = ss2.ActiveSheet.Cells[iRow - 1, SS2_FLAG].Text.ToString().Trim(); if (sFlag == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss2, SS2_SLAB_NO, SS2_SLAB_NO, iRow - 1, iRow - 1, SSP4.BackColor, Color.White); } //是否出口订单 sexport = ss2.ActiveSheet.Cells[iRow - 1, SS2_EXPORT].Text.ToString().Trim(); if (sexport == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss2, SS2_SLAB_NO, SS2_SLAB_NO, iRow - 1, iRow - 1, SSP1.BackColor, Color.White); } //是否一坯多订单 //ss2.ActiveSheet.Cells[iRow - 1, SS2_ORD_CNT].Value.ToString(); sOrdcnt = ss2.ActiveSheet.Cells[iRow - 1, SS2_ORD_CNT].Text.ToString(); if (sOrdcnt != "" && Convert.ToInt32(sOrdcnt) > 1)//解决为空导致无法转换报错的问题 { SpreadCommon.Gp_Sp_BlockColor(ss2, 0, ss2.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Black, SSP2.BackColor); } } } } else if (tab1.SelectedIndex == 1) { p_Ref(3, 3, true, false); if (ss3.ActiveSheet.RowCount <= 0) { return; //防止报错 VB版本没有这段代码 } if (ss3.ActiveSheet.Cells[0, 0].Text.ToString() != "") { txt_SlabNo.Text = ss3.ActiveSheet.Cells[0, 0].Text.ToString(); if (p_Ref(4, 0, true, false) & p_Ref(2, 1, true, false)) { } } } lockSpread(ss2); // Call MDIMain.FormMenuSetting(Me, FormType, "RE", sAuthority) }
public override void Form_Ref() { string SMESG; int lRow; //定义一个变量标记,用来控制颜色显示 int iColor = 0; int sord_cnt; string sHtm_Meth; string sIncarno; string sEXCEPTION; string sEXCEPTIONFH; p_Ref(1, 1, true, true); unlockSpread(ss1); for (lRow = 1; lRow <= ss1.ActiveSheet.RowCount; lRow++) { //取母板号,初始值为空,把颜色标记置为1 if (mOplate_No == "") { iColor = 1; } else { //母板号不为空时,检查与上一母板号是否为相同母板号 if (ss1.ActiveSheet.Cells[lRow - 1, SS1_MOTHER_NO].Text != mOplate_No) { //如果是不同母板号,而且颜色标记为1,那么颜色标记改为2,表示改变颜色 if (iColor == 1) { iColor = 2; //如果母板号相同,那么颜色标记还为1,表示颜色不变 } else { iColor = 1; } } } //用1表示颜色置为浅灰色,用2表示颜色置为白色 //每次循环结束,如果iColor为1,则颜色为浅灰色,否则颜色为白色 if (iColor == 1) { //取样颜色改变,如果为Y表示取样,则该行字体颜色变红色 if (ss1.ActiveSheet.Cells[lRow - 1, SS1_PLAN_SMP].Text == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Red, ColorTranslator.FromHtml("#e0e0e0")); //浅灰色 } else { //浅灰色 SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, ColorTranslator.FromHtml("#e0e0e0")); } } else { //取样颜色改变,如果为Y表示取样,则该行字体颜色变红色 if (ss1.ActiveSheet.Cells[lRow - 1, SS1_PLAN_SMP].Text == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Red, ColorTranslator.FromHtml("#ffffff")); //白 } else { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, ColorTranslator.FromHtml("#ffffff")); //白 } } //把值还原为for循环中母板号的取值 mOplate_No = ss1.ActiveSheet.Cells[lRow - 1, SS1_MOTHER_NO].Text; sord_cnt = Convert.ToInt32(ss1.ActiveSheet.Cells[lRow - 1, SS1_ORD_CNT].Text); if (sord_cnt > 1) { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP1.BackColor); } sIncarno = ss1.ActiveSheet.Cells[lRow - 1, SS1_IN_CAR_NO].Text; if (txt_place.Text == "2") { if (sIncarno == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP4.BackColor); } } else { if (sIncarno != "") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP4.BackColor); } } sEXCEPTION = ss1.ActiveSheet.Cells[lRow - 1, SS1_MILL_EXCEPTION].Text; sEXCEPTIONFH = ss1.ActiveSheet.Cells[lRow - 1, SS1_MILL_EXCEPTION_FH].Text; if (sEXCEPTION == "B" | sEXCEPTION == "C" | sEXCEPTIONFH == "B" | sEXCEPTIONFH == "C") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP5.BackColor); } //热处理指示蓝色显示 sHtm_Meth = ss1.ActiveSheet.Cells[lRow - 1, SS1_HTM_METH].Text; if (sHtm_Meth.Substring(0, 1) == "N" & sHtm_Meth.Substring(0, 1) != "/") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, ColorTranslator.FromHtml("#0000ff")); } } lockSpread(ss1); ss1.ActiveSheet.Columns[0].Locked = false; ss1.ActiveSheet.Columns[SS1_SUSERID].Locked = false; }
public override void Form_Ref() { int iRow; int iCol; string sUrgnt_Fl; string simpcont; string sFlag; string sexport; unlockSpread(ss1); if (Tab1.SelectedIndex == 0) { p_Ref(0, 1, true, false); p_Ref(0, 3, true, false); if (ss1.ActiveSheet.RowCount <= 0) { return; } if (ss1.ActiveSheet.Cells[0, 0].Text.ToString() != "") { ss1_DblClk(0, 0); } //紧急订单绿色显示 add by liqian 2012-08-15 { for (iRow = 1; iRow <= ss1.ActiveSheet.RowCount; iRow++) { sUrgnt_Fl = ss1.ActiveSheet.Cells[iRow - 1, SS1_URGNT_FL].Text.ToString().Trim(); simpcont = ss1.ActiveSheet.Cells[iRow - 1, SS1_IMP_CONT].Text.ToString().Trim(); if (sUrgnt_Fl == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Red, Color.White); } if (simpcont == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Black, SSP4.BackColor); } //是否定制配送 sFlag = ss1.ActiveSheet.Cells[iRow - 1, SS1_FLAG].Text.ToString().Trim(); if (sFlag == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_MILL_NO, SS1_MILL_NO, iRow - 1, iRow - 1, SSP5.BackColor, Color.White); } //是否出口订单 sexport = ss1.ActiveSheet.Cells[iRow - 1, SS1_EXPORT].Text.ToString().Trim(); if (sexport == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_MILL_NO, SS1_MILL_NO, iRow - 1, iRow - 1, SSP1.BackColor, Color.White); } } } } else if (Tab1.SelectedIndex == 1) { p_Ref(2, 2, true, false); } lockSpread(ss1); }
public override void Form_Ref() { int iRow; int iCol; string sUrgnt_Fl; string simpcont; string PILECOOL; string sFlag; string sexport; string sDuileng; if (Tab1.SelectedIndex == 0) { p_Ref(0, 1, true, false); // TXT_SEQ = Gf_FloatFind(M_CN1, CUT_SEQ) ss1_DblClk(0, 0); unlockSpread(ss1); //紧急订单绿色显示 add by liqian 2012-08-16 { for (iRow = 1; iRow <= ss1.ActiveSheet.RowCount; iRow++) { sUrgnt_Fl = ss1.ActiveSheet.Cells[iRow - 1, SS1_URGNT_FL].Text.ToString().Trim(); simpcont = ss1.ActiveSheet.Cells[iRow - 1, SS1_IMP_CONT].Text.ToString().Trim(); PILECOOL = ss1.ActiveSheet.Cells[iRow - 1, SS1_PILECOOL].Text.ToString().Trim(); sFlag = ss1.ActiveSheet.Cells[iRow - 1, SS1_FLAG].Text.ToString().Trim(); sexport = ss1.ActiveSheet.Cells[iRow - 1, SS1_EXPORT].Text.ToString().Trim(); if (sUrgnt_Fl == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Red, Color.White); } if (simpcont == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, SSP4.BackColor, Color.White); } if (PILECOOL == "Y" & simpcont != "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Black, Color.Yellow); } //是否定制配送 if (sFlag == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_SLAB_NO, SS1_SLAB_NO, iRow - 1, iRow - 1, SSP5.BackColor, Color.White); } //是否出口订单 if (sexport == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_SLAB_NO, SS1_SLAB_NO, iRow - 1, iRow - 1, SSP6.BackColor, Color.White); } } } lockSpread(ss1); unlockSpread(ss2); { for (iRow = 1; iRow <= ss2.ActiveSheet.RowCount; iRow++) { sDuileng = ss2.ActiveSheet.Cells[iRow - 1, SS2_DUILENG].Text.ToString().Trim();; if (sDuileng == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss2, SS2_MPLATE_NO, SS2_MPLATE_NO, iRow - 1, iRow - 1, SSPanel1.BackColor, Color.White); } } } lockSpread(ss2); } else if (Tab1.SelectedIndex == 1) { p_Ref(2, 2, true, false); // TXT_SEQ = Gf_FloatFind(M_CN1, CUT_SEQ) } }
public override void Form_Ref() { string SMESG; int lRow; //定义一个变量标记,用来控制颜色显示 string iColor = ""; int sord_cnt; string sHtm_Meth; p_Ref(1, 1, true, true); unlockSpread(ss1); for (lRow = 1; lRow <= ss1.ActiveSheet.RowCount; lRow++) { //取母板号,初始值为空,把颜色标记置为1 if (mOplate_No == "") { iColor = "1"; } else { //母板号不为空时,检查与上一母板号是否为相同母板号 if (ss1.ActiveSheet.Cells[lRow - 1, SS1_MOTHER_NO].Text != mOplate_No) { //如果是不同母板号,而且颜色标记为1,那么颜色标记改为2,表示改变颜色 if (iColor == "1") { iColor = "2"; //如果母板号相同,那么颜色标记还为1,表示颜色不变 } else { iColor = "1"; } } } //用1表示颜色置为浅灰色,用2表示颜色置为白色 //每次循环结束,如果iColor为1,则颜色为浅灰色,否则颜色为白色 if (iColor == "1") { //取样颜色改变,如果为Y表示取样,则该行字体颜色变红色 if (ss1.ActiveSheet.Cells[lRow - 1, SS1_PLAN_SMP].Text == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Red, ColorTranslator.FromHtml("#e0e0e0")); //浅灰色 } else { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, ColorTranslator.FromHtml("#e0e0e0")); //浅灰色 } } else { //取样颜色改变,如果为Y表示取样,则该行字体颜色变红色 if (ss1.ActiveSheet.Cells[lRow - 1, SS1_PLAN_SMP].Text == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Red, ColorTranslator.FromHtml("#ffffff")); //白 } else { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, ColorTranslator.FromHtml("#ffffff")); //白 } } //把值还原为for循环中母板号的取值 mOplate_No = ss1.ActiveSheet.Cells[lRow - 1, SS1_MOTHER_NO].Text; sord_cnt = Convert.ToInt32(ss1.ActiveSheet.Cells[lRow - 1, SS1_ORD_CNT].Text); if (sord_cnt > 1) { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP1.BackColor); } //热处理指示蓝色显示 sHtm_Meth = ss1.ActiveSheet.Cells[lRow - 1, SS1_HTM_METH].Text; if (sHtm_Meth.Substring(0, 1) == "N" & sHtm_Meth.Substring(0, 1) != "/ / /") { // If sHtm_Meth <> "/ / /" Then SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP2.BackColor); } } lockSpread(ss1); }
private void ss1_Click(int Col, int ROW) { int lRow; string sBlockSeq; string sSeq; // Call Gp_Sp_Sort(sc1.Item("Spread"), Col, ROW) //lBlkcol1 = 0; //lBlkcol2 = 0; //lBlkrow1 = 0; //lBlkrow2 = 0; if (ROW < 0) { return; } if (Col > 0) { return; } TXT_SLAB_NO.Text = ss1.ActiveSheet.Cells[ROW, 0].Text; //unlockSpread(ss1); //SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, ROW, ROW, Color.Black, SSP1.BackColor); if (OPT_FP_SLAB_DES.Checked) { p_Ref(2, 4, true, true); } else if (OPT_FP_SLAB_DES1.Checked) { p_Ref(2, 5, true, true); } else { p_Ref(2, 6, true, true); } TXT_SLAB_NO.Text = ""; unlockSpread(ss2); for (lRow = 1; lRow <= ss2.ActiveSheet.RowCount; lRow++) { sBlockSeq = ss2.ActiveSheet.Cells[lRow - 1, SS2_BLOCK_SEQ].Text; sSeq = ss2.ActiveSheet.Cells[lRow - 1, SS2_SEQ].Text; if (sBlockSeq + sSeq == "0000") { SpreadCommon.Gp_Sp_BlockColor(ss2, 0, ss2.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP1.BackColor); ss2.ActiveSheet.Cells[lRow - 1, SS2_PROD_CD].Text = "轧件"; } else if (sSeq == "00") { SpreadCommon.Gp_Sp_BlockColor(ss2, 0, ss2.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP2.BackColor); ss2.ActiveSheet.Cells[lRow - 1, SS2_PROD_CD].Text = "母板" + sBlockSeq; } else { SpreadCommon.Gp_Sp_BlockColor(ss2, 0, ss2.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP3.BackColor); ss2.ActiveSheet.Cells[lRow - 1, SS2_PROD_CD].Text = "钢板"; } } lockSpread(ss2); }
//ss1列头双击 private void ss1_DblClk(int col, int row) { string plate_no; int iCnt; int iPlate_cnt; double iPlate_wgt; int tRow; iPlate_cnt = 0; iPlate_wgt = 0; if (ss1.ActiveSheet.RowCount <= 0) { return; } if (ss1.ActiveSheet.RowHeader.Cells[row, 0].Text == "增加") { plate_no = ss1.ActiveSheet.Cells[row, 0].Text; for (iCnt = ss2.ActiveSheet.RowCount; iCnt >= 1; iCnt += -1) { if (ss2.ActiveSheet.RowHeader.Cells[iCnt - 1, 0].Text == "增加") { if (ss2.ActiveSheet.Cells[iCnt - 1, 1].Text == plate_no) { ss2.ActiveSheet.Cells[iCnt - 1, 1].Text = ""; SpreadCommon.Gp_Sp_BlockColor(ss2, 0, ss2.ActiveSheet.ColumnCount - 1, iCnt - 1, iCnt - 1, Color.Black, Color.White); ss2.ActiveSheet.RowHeader.Cells[iCnt - 1, 0].Text = ""; break; // TODO: might not be correct. Was : Exit For } } } ss1.ActiveSheet.RowHeader.Cells[row, 0].Text = ""; SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, row, row, Color.Black, Color.White); for (iCnt = 1; iCnt <= ss1.ActiveSheet.RowCount; iCnt += 1) { if (ss1.ActiveSheet.RowHeader.Cells[iCnt - 1, 0].Text != "") { iPlate_cnt = iPlate_cnt + 1; iPlate_wgt = iPlate_wgt + Convert.ToDouble(ss1.ActiveSheet.Cells[iCnt - 1, 6].Text); } } TXT_CNT.Text = iPlate_cnt.ToString(); TXT_WGT.Text = iPlate_wgt.ToString(); return; } plate_no = ss1.ActiveSheet.Cells[row, 0].Text; if (ss2.ActiveSheet.RowCount <= 0) { return; } ss1.ActiveSheet.RowHeader.Cells[row, 0].Text = "增加"; SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, row, row, Color.Black, ColorTranslator.FromHtml("#FFC0FF")); for (iCnt = 1; iCnt <= ss1.ActiveSheet.RowCount; iCnt += 1) { if (ss1.ActiveSheet.RowHeader.Cells[iCnt - 1, 0].Text != "") { iPlate_cnt = iPlate_cnt + 1; iPlate_wgt = iPlate_wgt + Convert.ToDouble(ss1.ActiveSheet.Cells[iCnt - 1, 6].Text); } } TXT_CNT.Text = iPlate_cnt.ToString(); TXT_WGT.Text = iPlate_wgt.ToString(); tRow = ss2.ActiveSheet.ActiveRowIndex; if (ss2.ActiveSheet.Cells[tRow, 1].Text.Length == 14) { for (iCnt = ss2.ActiveSheet.RowCount; iCnt >= 1; iCnt += -1) { //ss2.Col = 2; //ss2.ROW = iCnt; if (ss2.ActiveSheet.Cells[iCnt - 1, 1].Text == "") { ss2.ActiveSheet.Cells[iCnt - 1, 1].Text = plate_no; ss2.ActiveSheet.RowHeader.Cells[iCnt - 1, 0].Text = "增加"; ss2.ActiveSheet.Cells[iCnt - 1, 10].Text = GeneralCommon.sUserID; return; } } } else { if (ss2.ActiveSheet.Cells[tRow, 1].Text == "") { ss2.ActiveSheet.Cells[tRow, 1].Text = plate_no; ss2.ActiveSheet.RowHeader.Cells[tRow, 0].Text = "增加"; ss2.ActiveSheet.Cells[tRow, 10].Text = GeneralCommon.sUserID; if (tRow >= 0) { ss2.ActiveSheet.SetActiveCell(tRow - 1, 0); } return; } } }
public override void Form_Pro() { int iCount; string sPlateNo; int inum; int lRow; string sSmp_color; string sCnt_color; p_pro(1, 1, true, true); // If Gf_Sp_Process(M_CN1, Proc_Sc("SC"), Mc1) Then // Call MDIMain.FormMenuSetting(Me, FormType, "RE", sAuthority) // ss1.ROW = IIf(Val(txt_tmpseq.Text) = 0, 1, Val(txt_tmpseq.Text)) // ss1.SetActiveCell ss1.ActiveCol, ss1.ROW // End If for (lRow = 1; lRow <= ss1.ActiveSheet.RowCount; lRow++) { if (ss1.ActiveSheet.Cells[lRow - 1, SS1_PRC_LINE].Text != "X") { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, SSP2.BackColor); } if (ss1.ActiveSheet.Cells[lRow - 1, SS1_PLAN_SMP].Text != "") { if (ss1.ActiveSheet.Cells[lRow - 1, SS1_PLAN_SMP].Text == "Y") { sSmp_color = "#FF0000"; } else { sSmp_color = "#000000"; } SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, ColorTranslator.FromHtml(sSmp_color), SSP3.BackColor); } // 一坯多订单,字体显示蓝色 2011-08-18 by LiQian if (ss1.ActiveSheet.Cells[lRow - 1, SS1_ORD_CNT].Text != "") { if (Convert.ToInt32(ss1.ActiveSheet.Cells[lRow - 1, SS1_ORD_CNT].Text) > 1) { sCnt_color = "#0000FF"; } else { sCnt_color = "#000000"; } SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, ColorTranslator.FromHtml(sCnt_color), Color.White); } //紧急订单绿色标记 2012-08-16 by LiQian if (ss1.ActiveSheet.Cells[lRow - 1, SS1_URGNT_FL].Text == "Y") { SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_MPLATE_NO, SS1_MPLATE_NO, lRow - 1, lRow - 1, Color.Green, Color.White); SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_TRNS_CMPY_CD, SS1_TRNS_CMPY_CD, lRow - 1, lRow - 1, Color.Green, Color.White); SpreadCommon.Gp_Sp_BlockColor(ss1, SS1_URGNT_FL, SS1_URGNT_FL, lRow - 1, lRow - 1, Color.Green, Color.White); } } }
public override void Form_Ref() { string SMESG; int iCount; int iCol; string sCurDate; string sDel_To_Date; int lRow; int iColor = 0; string iPlate_no = ""; string simpcont; double sWgt; sCurDate = DateTime.Now.ToString("yyyyMM"); if (convertX(SDT_PROD_DATE_FROM.RawDate) - convertX(SDT_PROD_DATE_TO.RawDate) > 0) { SMESG = " 时间范围输入错误,请重新输入时间信息 !!!"; GeneralCommon.Gp_MsgBoxDisplay(SMESG, "I", "系统提示信息"); return; } p_Ref(1, 1, true, true); //Add by LiQian at 2012.09.14 两次以上检验记录区分 for (lRow = 1; lRow <= ss1.ActiveSheet.RowCount; lRow++) { if (iPlate_no == "") { iColor = 1; } else { if (ss1.ActiveSheet.Cells[lRow - 1, SS1_PLATE_NO].Text != iPlate_no) { if (iColor == 1) { iColor = 2; } else { iColor = 1; } } } if (iColor == 1) { SpreadCommon.Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, Color.White); //白 } else { Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, lRow - 1, lRow - 1, Color.Black, Color.Gray); //浅灰色 } iPlate_no = ss1.ActiveSheet.Cells[lRow - 1, SS1_PLATE_NO].Text; simpcont = ss1.ActiveSheet.Cells[lRow - 1, SS1_IMP_CONT].Text; if (simpcont == "Y") { Gp_Sp_BlockColor(ss1, SS1_PLATE_NO, SS1_PLATE_NO, lRow - 1, lRow - 1, SSP4.BackColor, Color.White); Gp_Sp_BlockColor(ss1, SS1_IMP_CONT, SS1_IMP_CONT, lRow - 1, lRow - 1, SSP4.BackColor, Color.White); } } }