protected void btnCheckAll_Click(object sender, EventArgs e)
{
if (rptOVHBatch.Items.Count > 0)
{
foreach (RepeaterItem ri in rptOVHBatch.Items)
{
Label lblDOC_NBR = ri.FindControl("lblDOC_NBR") as Label;
Label lblError = ri.FindControl("lblError") as Label;
GridView gvOVHBatch = ri.FindControl("gvOVHBatch") as GridView;
foreach (GridViewRow gr in gvOVHBatch.Rows)
{
Label lblZTABLE_STATUS = gr.FindControl("lblZTABLE_STATUS") as Label;
Label lblWS_STATUS = gr.FindControl("lblWS_STATUS") as Label;
Label lblSUB_DOC_NBR = gr.FindControl("lblSUB_DOC_NBR") as Label;
Label lblMSG = gr.FindControl("lblMSG") as Label;
string ZTABLE_STATUS = ReBuildSCSHRForm.CheckZTableHasData(lblDOC_NBR.Text, "KYTI_SCSHR_OVERTIME_BATCH");
string WS_STATUS = ReBuildSCSHRForm.CheckWSHasData(lblSUB_DOC_NBR.Text, "KYTI_SCSHR_OVERTIME_BATCH");
lblZTABLE_STATUS.Text = !string.IsNullOrEmpty(ZTABLE_STATUS) ? ZTABLE_STATUS == "0" ? "O" : "X" : "?";
lblZTABLE_STATUS.ForeColor = !string.IsNullOrEmpty(ZTABLE_STATUS) ? ZTABLE_STATUS == "0" ? Color.Green : Color.Red : Color.Yellow;
lblWS_STATUS.Text = !string.IsNullOrEmpty(WS_STATUS) ? WS_STATUS == "0" ? "O" : "X" : "?";
lblWS_STATUS.ForeColor = !string.IsNullOrEmpty(WS_STATUS) ? WS_STATUS == "0" ? Color.Green : Color.Red : Color.Yellow;
}
}
}
}
protected void btnReBuild_Click(object sender, EventArgs e)
{
if (gvPUNCH.Rows.Count > 0)
{
foreach (GridViewRow gr in gvPUNCH.Rows)
{
Label lblZTABLE_STATUS = gr.FindControl("lblZTABLE_STATUS") as Label;
Label lblWS_STATUS = gr.FindControl("lblWS_STATUS") as Label;
Label lblDOC_NBR = gr.FindControl("lblDOC_NBR") as Label;
Label lblAPPLICANT = gr.FindControl("lblAPPLICANT") as Label;
Label lblAPPLICANTDATE = gr.FindControl("lblAPPLICANTDATE") as Label;
Label lblSTARTTIME = gr.FindControl("lblSTARTTIME") as Label;
Label lblENDTIME = gr.FindControl("lblENDTIME") as Label;
Label lblMSG = gr.FindControl("lblMSG") as Label;
if (!string.IsNullOrEmpty(lblDOC_NBR.Text))
{
// 重新呼叫
string ZTABLE_STATUS = ReBuildSCSHRForm.ReUpdateZTable(lblDOC_NBR.Text, Field_ID);
string WS_STATUS = ReBuildSCSHRForm.ReCallWSUpdateStatus(lblDOC_NBR.Text, Field_ID);
lblZTABLE_STATUS.Text = !string.IsNullOrEmpty(ZTABLE_STATUS) ? ZTABLE_STATUS == "0" ? "O" : "X" : "?";
lblZTABLE_STATUS.ForeColor = !string.IsNullOrEmpty(ZTABLE_STATUS) ? ZTABLE_STATUS == "0" ? Color.Green : Color.Red : Color.Yellow;
lblMSG.Text = lblZTABLE_STATUS.Text != "O" ? ZTABLE_STATUS + "<br />" : "";
lblWS_STATUS.Text = !string.IsNullOrEmpty(WS_STATUS) ? WS_STATUS == "0" ? "O" : "X" : "?";
lblWS_STATUS.ForeColor = !string.IsNullOrEmpty(WS_STATUS) ? WS_STATUS == "0" ? Color.Green : Color.Red : Color.Yellow;
lblMSG.Text += lblWS_STATUS.Text != "O" ? WS_STATUS + "<br />" : "";
Thread.Sleep(3000);
}
}
}
}
protected void btnReCalcByBOFind_Click(object sender, EventArgs e)
{
if (gvOVH.Rows.Count > 0)
{
foreach (GridViewRow gr in gvOVH.Rows)
{
Label lblRECALC_STATUS = gr.FindControl("lblRECALC_STATUS") as Label;
Label lblZTABLE_STATUS = gr.FindControl("lblZTABLE_STATUS") as Label;
Label lblWS_STATUS = gr.FindControl("lblWS_STATUS") as Label;
Label lblDOC_NBR = gr.FindControl("lblDOC_NBR") as Label;
Label lblAPPLICANT_NAME = gr.FindControl("lblAPPLICANT_NAME") as Label;
Label lblTRAVEL_NAME = gr.FindControl("lblTRAVEL_NAME") as Label;
Label lblAGENT_NAME = gr.FindControl("lblAGENT_NAME") as Label;
Label lblTRAVEL_POINT_NAME = gr.FindControl("lblTRAVEL_POINT_NAME") as Label;
Label lblTRAVELCURR_NAME = gr.FindControl("lblTRAVELCURR_NAME") as Label;
Label lblTRAVELFD = gr.FindControl("lblTRAVELFD") as Label;
Label lblSTARTTIME = gr.FindControl("lblSTARTTIME") as Label;
Label lblENDTIME = gr.FindControl("lblENDTIME") as Label;
Label lblMSG = gr.FindControl("lblMSG") as Label;
if (!string.IsNullOrEmpty(lblDOC_NBR.Text))
{
// 重新呼叫
string RECALC_STATUS = ReBuildSCSHRForm.ReCalcWSAndReplaceOVHFormByBOFind(lblDOC_NBR.Text);
lblRECALC_STATUS.Text = !string.IsNullOrEmpty(RECALC_STATUS) ? RECALC_STATUS == "0" ? "O" : "X" : "?";
lblRECALC_STATUS.ForeColor = !string.IsNullOrEmpty(RECALC_STATUS) ? RECALC_STATUS == "0" ? Color.Green : Color.Red : Color.Yellow;
lblMSG.Text = lblRECALC_STATUS.Text != "O" ? RECALC_STATUS + "<br />" : "";
Thread.Sleep(2000);
}
}
}
}
protected void btnPartReBuild_Click(object sender, EventArgs e)
{
if (gvTravel.Rows.Count > 0)
{
foreach (GridViewRow gr in gvTravel.Rows)
{
Label lblZTABLE_STATUS = gr.FindControl("lblZTABLE_STATUS") as Label;
Label lblWS_STATUS = gr.FindControl("lblWS_STATUS") as Label;
Label lblDOC_NBR = gr.FindControl("lblDOC_NBR") as Label;
Label lblAPPLICANT_NAME = gr.FindControl("lblAPPLICANT_NAME") as Label;
Label lblTRAVEL_NAME = gr.FindControl("lblTRAVEL_NAME") as Label;
Label lblAGENT_NAME = gr.FindControl("lblAGENT_NAME") as Label;
Label lblTRAVEL_POINT_NAME = gr.FindControl("lblTRAVEL_POINT_NAME") as Label;
Label lblTRAVELCURR_NAME = gr.FindControl("lblTRAVELCURR_NAME") as Label;
Label lblTRAVELFD = gr.FindControl("lblTRAVELFD") as Label;
Label lblSTARTTIME = gr.FindControl("lblSTARTTIME") as Label;
Label lblENDTIME = gr.FindControl("lblENDTIME") as Label;
Label lblMSG = gr.FindControl("lblMSG") as Label;
if (!string.IsNullOrEmpty(lblDOC_NBR.Text))
{
// 重新呼叫
//string fixDetail = ReBuildSCSHRForm.FixTravelDetail(lblDOC_NBR.Text, Field_ID);
//lblMSG.Text = fixDetail != "0" ? fixDetail + "<br />" : "";
string fixTravel = ReBuildSCSHRForm.FixTravelTravelIsEmpty(lblDOC_NBR.Text, Field_ID);
lblMSG.Text = fixTravel != "0" ? fixTravel + "<br />" : "";
if (fixTravel == "0" &&
string.IsNullOrEmpty(lblTRAVEL_NAME.Text))
{
lblTRAVEL_NAME.Text = lblAPPLICANT_NAME.Text;
}
if (string.IsNullOrEmpty(lblMSG.Text.Trim()))
{
if (lblZTABLE_STATUS.Text != "O")
{
string ZTABLE_STATUS = ReBuildSCSHRForm.ReUpdateZTable(lblDOC_NBR.Text, Field_ID);
lblZTABLE_STATUS.Text = !string.IsNullOrEmpty(ZTABLE_STATUS) ? ZTABLE_STATUS == "0" ? "O" : "X" : "?";
lblZTABLE_STATUS.ForeColor = !string.IsNullOrEmpty(ZTABLE_STATUS) ? ZTABLE_STATUS == "0" ? Color.Green : Color.Red : Color.Yellow;
lblMSG.Text = lblZTABLE_STATUS.Text != "O" ? ZTABLE_STATUS + "<br />" : "";
}
if (lblWS_STATUS.Text != "O")
{
string WS_STATUS = ReBuildSCSHRForm.ReCallWSUpdateStatus(lblDOC_NBR.Text, Field_ID);
lblWS_STATUS.Text = !string.IsNullOrEmpty(WS_STATUS) ? WS_STATUS == "0" ? "O" : "X" : "?";
lblWS_STATUS.ForeColor = !string.IsNullOrEmpty(WS_STATUS) ? WS_STATUS == "0" ? Color.Green : Color.Red : Color.Yellow;
lblMSG.Text += lblWS_STATUS.Text != "O" ? WS_STATUS + "<br />" : "";
Thread.Sleep(3000); // 呼叫WS才需要休眠
}
}
}
}
}
}
protected void gvLVH_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
GridViewRow gr = e.Row;
if (gr.RowType == DataControlRowType.DataRow)
{
KYTJsonDict dict = null;
DataRowView row = (DataRowView)e.Row.DataItem;
Label lblZTABLE_STATUS = gr.FindControl("lblZTABLE_STATUS") as Label;
Label lblWS_STATUS = gr.FindControl("lblWS_STATUS") as Label;
Label lblDOC_NBR = gr.FindControl("lblDOC_NBR") as Label;
Label lblLEAEMP = gr.FindControl("lblLEAEMP") as Label;
Label lblAPPLICANTDATE = gr.FindControl("lblAPPLICANTDATE") as Label;
Label lblLEAAGENT = gr.FindControl("lblLEAAGENT") as Label;
Label lblLEACODE = gr.FindControl("lblLEACODE") as Label;
Label lblLEACODENAME = gr.FindControl("lblLEACODENAME") as Label;
Label lblSTARTTIME = gr.FindControl("lblSTARTTIME") as Label;
Label lblENDTIME = gr.FindControl("lblENDTIME") as Label;
Label lblLEAHOURS = gr.FindControl("lblLEAHOURS") as Label;
Label lblLEADAYS = gr.FindControl("lblLEADAYS") as Label;
bool isRightField = false;
string DOC_NBR = row["DOC_NBR"].ToString();
using (SqlDataAdapter sda = new SqlDataAdapter(@"
SELECT TOP 1 *
FROM TB_WKF_TASK
WHERE DOC_NBR = @DOC_NBR
", new DatabaseHelper().Command.Connection.ConnectionString))
using (DataSet ds = new DataSet())
{
sda.SelectCommand.Parameters.AddWithValue("@DOC_NBR", DOC_NBR);
try
{
if (sda.Fill(ds) > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
XmlDocument doc = new XmlDocument();
doc.LoadXml(dr["CURRENT_DOC"].ToString());
XmlNode node = doc.SelectSingleNode("//Form/FormFieldValue/FieldItem[@fieldId='" + Field_ID + "']"); // 取出外掛欄位資料
isRightField = node != null;
if (isRightField)
{
dict = JsonConvert.DeserializeObject <KYTJsonDict>(HttpUtility.HtmlDecode(node.InnerText));
}
}
}
catch (Exception ex)
{
DebugLog.Log(DebugLog.LogLevel.Error, string.Format(@"WEB_KYTI_SCSHR_LEAVE_ERR_FIX.gvLVH_RowDataBound.TB_WKF_TASK.SELECT.ERROR:{0}", ex.Message));
}
}
if (isRightField)
{
string ZTABLE_STATUS = ReBuildSCSHRForm.CheckZTableHasData(DOC_NBR, Field_ID);
string WS_STATUS = ReBuildSCSHRForm.CheckWSHasData(DOC_NBR, Field_ID);
lblZTABLE_STATUS.Text = !string.IsNullOrEmpty(ZTABLE_STATUS) ? ZTABLE_STATUS == "0" ? "O" : "X" : "?";
lblZTABLE_STATUS.ForeColor = !string.IsNullOrEmpty(ZTABLE_STATUS) ? ZTABLE_STATUS == "0" ? Color.Green : Color.Red : Color.Yellow;
lblWS_STATUS.Text = !string.IsNullOrEmpty(WS_STATUS) ? WS_STATUS == "0" ? "O" : "X" : "?";
lblWS_STATUS.ForeColor = !string.IsNullOrEmpty(WS_STATUS) ? WS_STATUS == "0" ? Color.Green : Color.Red : Color.Yellow;
lblLEACODENAME.Text = ReBuildSCSHRForm.FindDropDownListText(dict.GetDataTable("kddlLEACODE"), dict.GetString("kddlLEACODE").ToString());
lblSTARTTIME.Text = (string)dict.GetString("kdtpSTARTTIME");
lblENDTIME.Text = (string)dict.GetString("kdtpENDTIME");
lblLEAEMP.Text = (string)dict.GetString("ktxtLEAEMP");
lblAPPLICANTDATE.Text = (string)dict.GetString("ktxtAPPLICANTDATE");
lblLEAAGENT.Text = (string)dict.GetString("ktxtLEAAGENT");
lblLEACODE.Text = (string)dict.GetString("kddlLEACODE");
lblLEAHOURS.Text = (string)dict.GetString("ktxtLEAHOURS");
lblLEADAYS.Text = (string)dict.GetString("ktxtLEADAYS");
}
}
}
