private void CBO_KND_SelectedIndexChanged(object sender, EventArgs e)
{
SpreadCommon.Gf_Sp_Cls(Sc1);
TXT_KND.Text = CBO_KND.Text.Substring(0, 1);
if (TXT_KND.Text == "1")
{
Ulabel5.Text = "退判时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_REASON).Text = "退判原因";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_DATE).Text = "退判时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_CL_DATE).Text = "删除时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_ID).Text = "退判人员";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_USER_ID).Text = "删除人员";
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_1, true);
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_CL_DATE, true);
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_USER_ID, true);
}
else if (TXT_KND.Text == "4")
{
Ulabel5.Text = "钢板删除时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_REASON).Text = "申请原因";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_DATE).Text = "申请时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_CL_DATE).Text = "删除时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_ID).Text = "申请人员";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_USER_ID).Text = "删除人员";
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_1, false);
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_CL_DATE, false);
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_USER_ID, false);
}
else if (TXT_KND.Text == "6")
{
Ulabel5.Text = "退入库时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_REASON).Text = "退入库原因";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_DATE).Text = "退入库时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_CL_DATE).Text = "删除时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_ID).Text = "退入库人员";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_USER_ID).Text = "删除人员";
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_1, true);
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_CL_DATE, true);
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_USER_ID, true);
}
else if (TXT_KND.Text == "8")
{
Ulabel5.Text = "强制排产时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_REASON).Text = "强制排产原因";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_DATE).Text = "强制排产时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_CL_DATE).Text = "删除时间";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_SQ_ID).Text = "强制排产人员";
ss1.Sheets[0].ColumnHeader.Cells.Get(0, SPD_USER_ID).Text = "删除人员";
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_1, true);
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_CL_DATE, true);
SpreadCommon.Gp_Sp_ColHidden(ss1, SPD_USER_ID, true);
}
}
private void ss3_Click(int Col, int ROW)
{
int P;
int iRow;
int iCol;
if (ss2.ActiveSheet.RowCount <= 0)
{
TXT_MPLATE_NO.Text = "";
SpreadCommon.Gf_Sp_Cls(Sc3);
return;
}
SDB_SLAB_EDT_SEQ.Text = ss2.ActiveSheet.Cells[ROW, SS3_SLAB_EDT_SEQ].Text;
SDB_MPLATE_EDT_SEQ.Text = ss2.ActiveSheet.Cells[ROW, SS3_MPLATE_EDT_SEQ].Text;
p_Ref(3, 3, false, false);
}
private void ss1_Click(int Col, int ROW)
{
int C;
int M;
int iRow;
int iCol;
string SEND_SLAB;
if (ss1.ActiveSheet.RowCount <= 0)
{
SpreadCommon.Gf_Sp_Cls(Sc2);
SpreadCommon.Gf_Sp_Cls(Sc3);
return;
}
if (opt_from.Checked == true)
{
txt_from.Text = ss1.ActiveSheet.Cells[ROW, SS1_SLAB_NO].Text;
from_y.Text = ss1.ActiveSheet.Cells[ROW, SS1_L2_SEND].Text;
sSlab_Edt_Seq_Fr = ss1.ActiveSheet.Cells[ROW, SS1_SLAB_EDT_SEQ].Text;
}
else if (opt_to.Checked == true)
{
txt_to.Text = ss1.ActiveSheet.Cells[ROW, SS1_SLAB_NO].Text;
to_y.Text = ss1.ActiveSheet.Cells[ROW, SS1_L2_SEND].Text;
sSlab_Edt_Seq_To = ss1.ActiveSheet.Cells[ROW, SS1_SLAB_EDT_SEQ].Text;
}
else if (opt_target.Checked == true)
{
txt_target.Text = ss1.ActiveSheet.Cells[ROW, SS1_SLAB_NO].Text;
target_y.Text = ss1.ActiveSheet.Cells[ROW, SS1_L2_SEND].Text;
sSlab_Edt_Seq_Tg = ss1.ActiveSheet.Cells[ROW, SS1_SLAB_EDT_SEQ].Text;
}
//检查L2_SEND是否已为'Y'
if ((opt_sent.Checked == true | opt_delete.Checked == true))
{
if (ss1.ActiveSheet.Cells[ROW, SS1_L2_SEND].Text == "Y")
{
GeneralCommon.Gp_MsgBoxDisplay("板坯号 " + ss1.ActiveSheet.Cells[ROW, SS1_SLAB_NO].Text + " 作业指示已下达！", "I", "提示");
if (opt_from.Checked == true)
{
txt_from.Text = "";
from_y.Text = "";
sSlab_Edt_Seq_Fr = "0";
}
else if (opt_to.Checked == true)
{
txt_to.Text = "";
to_y.Text = "";
sSlab_Edt_Seq_To = "0";
}
else if (opt_target.Checked == true)
{
txt_target.Text = "";
target_y.Text = "";
sSlab_Edt_Seq_Tg = "0";
}
return;
}
}
//检查是否已入炉
if (ss1.ActiveSheet.Cells[ROW, SS1_PRC_STS].Text == "B" & (opt_sent.Checked == true | opt_move.Checked == true | opt_cancel.Checked == true | opt_delete.Checked == true))
{
GeneralCommon.Gp_MsgBoxDisplay("板坯号 " + ss1.ActiveSheet.Cells[ROW, SS1_SLAB_NO].Text + " 已入炉，不能调整！", "I", "提示");
if (opt_from.Checked == true)
{
txt_from.Text = "";
from_y.Text = "";
sSlab_Edt_Seq_Fr = "0";
}
else if (opt_to.Checked == true)
{
txt_to.Text = "";
to_y.Text = "";
sSlab_Edt_Seq_To = "0";
}
else if (opt_target.Checked == true)
{
txt_target.Text = "";
target_y.Text = "";
sSlab_Edt_Seq_Tg = "0";
}
return;
}
if (opt_sent.Checked == false & opt_cancel.Checked == false & opt_move.Checked == false & opt_delete.Checked == false & opt_return.Checked == false)
{
txt_to.Text = ss1.ActiveSheet.Cells[ROW, SS1_SLAB_NO].Text;
if (txt_to.Text.Trim().Length == 10)
{
SDB_SLAB_EDT_SEQ.Text = ss1.ActiveSheet.Cells[ROW, SS1_SLAB_EDT_SEQ].Text;
p_Ref(2, 2, false, false);
}
txt_to.Text = "";
}
}
public override void Form_Ref()
{
string sTemp;
string sL2_Send;
string sSlab_No;
string sPrc_Sts;
string sProd_Date;
string sHcr_Fl;
int iOrd_cnt;
int iRow;
int iCol;
Color cBackColor;
string sUrgnt_Fl;
string sOVER_FL;
string sSmpdote;
string sDate;
if (p_Ref(1, 1, false, false))
{
SpreadCommon.Gf_Sp_Cls(Sc2);
SpreadCommon.Gf_Sp_Cls(Sc3);
sSlab_Edt_Seq_Fr = "0";
sSlab_Edt_Seq_To = "0";
sSlab_Edt_Seq_Tg = "0";
}
for (iRow = 1; iRow <= ss1.ActiveSheet.RowCount; iRow++)
{
sSlab_No = ss1.ActiveSheet.Cells[iRow - 1, SS1_SLAB_NO].Text.Trim();
sL2_Send = ss1.ActiveSheet.Cells[iRow - 1, SS1_L2_SEND].Text.Trim();
sPrc_Sts = ss1.ActiveSheet.Cells[iRow - 1, SS1_PRC_STS].Text.Trim();
iOrd_cnt = convertI(ss1.ActiveSheet.Cells[iRow - 1, SS1_ORD_CNT].Text.Trim());
sProd_Date = ss1.ActiveSheet.Cells[iRow - 1, SS1_PROD_DATE].Text.Trim();
sHcr_Fl = ss1.ActiveSheet.Cells[iRow - 1, SS1_HCR_FL].Text.Trim();
sUrgnt_Fl = ss1.ActiveSheet.Cells[iRow - 1, SS1_URGNT_FL].Text.Trim();
sOVER_FL = ss1.ActiveSheet.Cells[iRow - 1, SS1_OVER_FL].Text.Trim();
sSmpdote = ss1.ActiveSheet.Cells[iRow - 1, SS1_SMP_DOTE1].Text.Trim();
sDate = ss1.ActiveSheet.Cells[iRow - 1, SS1_DATE].Text.Trim();
if (sPrc_Sts == "B")
{
Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Black, SSPpdt.BackColor);
}
else
{
if (sL2_Send == "Y")
{
Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Black, SSPsend.BackColor);
}
}
if (iOrd_cnt > 1)
{
Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Black, SSOrd.BackColor);
}
cBackColor = ss1.ActiveSheet.Cells[iRow - 1, 0].BackColor;
if (sProd_Date == "" && sHcr_Fl == "H")
{
Gp_Sp_BlockColor(ss1, SS1_SLAB_NO, SS1_SLAB_NO, iRow - 1, iRow - 1, Color.Red, cBackColor);
}
//紧急订单绿色显示 add by liqian 2012-08-16
if (sUrgnt_Fl == "Y")
{
Gp_Sp_BlockColor(ss1, SS1_SLAB_NO, SS1_SLAB_NO, iRow - 1, iRow - 1, Color.Green, Color.White);
Gp_Sp_BlockColor(ss1, SS1_ORD_NO, SS1_ORD_NO, iRow - 1, iRow - 1, Color.Green, Color.White);
Gp_Sp_BlockColor(ss1, SS1_URGNT_FL, SS1_URGNT_FL, iRow - 1, iRow - 1, Color.Green, Color.White);
}
if (sOVER_FL != "")
{
Gp_Sp_BlockColor(ss1, SS1_OVER_FL, SS1_OVER_FL, iRow - 1, iRow - 1, Color.Red, Color.White);
}
if (convertX(sDate) < convertX(sSmpdote))
{
Gp_Sp_BlockColor(ss1, 0, ss1.ActiveSheet.ColumnCount - 1, iRow - 1, iRow - 1, Color.Red, Color.White);
}
}
ss1.ActiveSheet.SetActiveCell(ss1.ActiveSheet.RowCount - 1, 0);
}
