private void ShowLabel(Guid id) { var table = CaiJiHelperClient.GetTestOverTimeByID(id); if (table == null || table.Rows.Count == 0) { return; } var row = table.Rows[0]; tb_reason.Text = (row["SGComment"] ?? "").ToString(); tb_process.Text = (row["JLComment"] ?? "").ToString(); int Status = int.Parse(row["Status"].ToString()); if (Status == 0) { tb_reason.Enabled = true; bt_save.Enabled = true; } else { tb_reason.Enabled = false; bt_save.Enabled = false; } #region 显示填写与处理 if (row["LastSGUser"] != DBNull.Value) { lb_reason.Text = row["LastSGUser"].ToString() + " 于 " + row["LastSGTime"].ToString() + " 填写"; } else { lb_reason.Text = "未填写"; } if (row["ApprovedJLUser"] != DBNull.Value) { int status = int.Parse(row["Status"].ToString()); String result = " 未处理"; if (status == 1) { result = " 通过"; } else if (status == 2) { result = " 拒绝"; } lb_process.Text = row["ApprovedJLUser"].ToString() + " 于 " + row["ApprovedTime"].ToString() + result; } else { lb_process.Text = "未处理"; } #endregion }
private void Table_SelectionChanged(object sender, FarPoint.Win.Spread.SelectionChangedEventArgs e) { if (e.Range.Row > 0) { string ID = ""; var row = Sheet.Rows[e.Range.Row]; if (row == null) { return; } ID = row.Tag.ToString(); DataTable dt = CaiJiHelperClient.GetTestOverTimeByID(new Guid(ID)); if (dt != null && dt.Rows.Count > 0) { tb_reason.Text = (dt.Rows[0]["SGComment"] ?? "").ToString(); } } else { tb_reason.Text = ""; } }