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);
}
}
}
