Exemple #1
0
    protected void btnFix_Click(object sender, EventArgs e)
    {
        if (!string.IsNullOrEmpty(txtDOC_NBR.Text.Trim()))
        {
            KYTJsonDict dict        = null;
            JObject     joInnerText = null;
            string      TASK_ID     = "";
            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", txtDOC_NBR.Text.Trim());
                    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='KYTI_SCSHR_TRAVEL']"); // 取出外掛欄位資料
                            dict        = JsonConvert.DeserializeObject <KYTJsonDict>(HttpUtility.HtmlDecode(node.InnerText));
                            joInnerText = JObject.Parse(HttpUtility.HtmlDecode(node.InnerText));
                            TASK_ID     = dr["TASK_ID"].ToString();
                        }
                    }
                    catch (Exception ex)
                    {
                        string message = string.Format(@"Temp_FixTravelTBY.btnFix_Click.TB_WKF_TASK.SELECT.ERROR:{0}", ex.Message);
                        DebugLog.Log(DebugLog.LogLevel.Error, message);
                    }

                    DataTable _dtPLs = dict.GetDataTable("gvPLs");
                    foreach (DataRow dr in _dtPLs.Rows)
                    {
                        dr["TBY"] = "高鐵";
                    }

                    if (joInnerText != null)
                    {
                        using (MemoryStream ms = new MemoryStream())
                        {
                            BinaryFormatter formatter = new BinaryFormatter();
                            try
                            {
                                formatter.Serialize(ms, _dtPLs);
                                joInnerText["gvPLs"]["FieldValue"] = Convert.ToBase64String(ms.ToArray());
                            }
                            catch (Exception ex)
                            {
                                DebugLog.Log(DebugLog.LogLevel.Error, string.Format(@"Temp_FixTravelTBY.btnFix_Click.MemoryStream.Serialize._dtPLs.ERROR:{0}", ex.Message));
                            }
                        }
                    }
                    JGlobalLibs.UOFUtils.ReplaceDocumentContent(TASK_ID, "KYTI_SCSHR_TRAVEL", JsonConvert.SerializeObject(joInnerText));
                }
        }
    }
    private DataTable getDetailData(string DOC_NBR)
    {
        DataTable   dtReturn     = new DataTable();
        KYTJsonDict dict         = null;
        bool        isRightField = false;

        using (SqlDataAdapter sda = new SqlDataAdapter(@"
            SELECT * FROM TB_WKF_TASK WHERE DOC_NBR = @DOC_NBR
            ", 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='KYTI_SCSHR_OVERTIME_BATCH']"); // 取出外掛欄位資料
                        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_OVERTIME_BATCH_ERR_FIX.getDetailData.TB_WKF_TASK.ERROR:{0}", ex.Message));
                }
                if (isRightField)
                {
                    dtReturn = dict.GetDataTable("gvOVs");
                    dtReturn.Columns.Add(new DataColumn("SUB_DOC_NBR", typeof(string)));
                    dtReturn.Columns.Add(new DataColumn("ZTABLE_STATUS", typeof(string)));
                    dtReturn.Columns.Add(new DataColumn("WS_STATUS", typeof(string)));
                    for (int i = 0; i < dtReturn.Rows.Count; i++)
                    {
                        DataRow dr = dtReturn.Rows[i];
                        dr["SUB_DOC_NBR"] = DOC_NBR + (i + 1).ToString("00");
                    }
                }
            }
        return(dtReturn);
    }
Exemple #3
0
    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");
            }
        }
    }