private void CaiJiChartView_Load(object sender, EventArgs e)
{
String str = CaiJiHelperClient.GetRealTimeTestData(caiJiID);
string RealTimeData = str;
try
{
str = BizCommon.JZCommonHelper.GZipDecompressString(RealTimeData);
}
catch
{
str = RealTimeData;
}
List <JZRealTimeData> list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JZRealTimeData> >(str);
if (list != null && list.Count > 0)
{
DateTime last = list[0].Time;
for (int i = 0; i < list.Count; i++)
{
ChartLine(Math.Round((list[i].Time - last).TotalMilliseconds / 1000, 2), list[i].Value);
}
}
}
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 btnManualUploadMQ_Click(object sender, EventArgs e)
{
CaiJiHelperClient.ManualUploadMQ();
EnableTime = 60;
btnManualUploadMQ.Enabled = false;
tmManual.AutoReset = true;
tmManual.Elapsed += new System.Timers.ElapsedEventHandler(tmManual_Elapsed);
tmManual.Interval = 1000;
tmManual.Enabled = true;
tmManual.Start();
}
private void ProcessOverTime(Int32 status, Guid[] ids)
{
try
{
CaiJiHelperClient.ProcessTestOverTime(ids, tb_process.Text.Trim(), status);
MessageBox.Show("处理成功，查看处理过的试验请到\"审批\"-->\"查看已审批的过期试验中查看\"");
if (ApplyAll.Checked == true)
{
this.Close();
}
SetDataSource();
}
catch
{
MessageBox.Show("保存失败，请联系管理员", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnReset_Click(object sender, EventArgs e)
{
var rows = FarPointExtensions.GetSelectionRows(Sheet);
var ids = new List <Guid>();
if (ApplyAll.Checked)
{
foreach (Row row in Sheet.Rows)
{
if (row.Tag == null)
{
continue;
}
var id = new Guid(row.Tag.ToString());
ids.Add(id);
}
}
else
{
foreach (var row in rows)
{
var id = new Guid(row.Tag.ToString());
if (id == null)
{
continue;
}
ids.Add(id);
}
}
if (ids.Count == 0)
{
MessageBox.Show("请选择要处理的数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
CaiJiHelperClient.UpdateTestOverTimeStatus(ids.ToArray(), 0);
SetDataSource();
this.Close();
//ProcessOverTime(1, ids.ToArray());
}
}
private void btnReloadMQ_Click(object sender, EventArgs e)
{
string strStartTime = txtWTBH.Text.Trim().Replace(",", "");
if (!string.IsNullOrEmpty(strStartTime))
{
bool bIsDate = false;
DateTime dtStartTime = new DateTime();
bIsDate = DateTime.TryParse(strStartTime, out dtStartTime);
if (Yqun.Common.ContextCache.ApplicationContext.Current.UserCode != "-2" && bIsDate == true)
{
return;
}
CaiJiHelperClient.ReloadRabbitMQ(strStartTime);
MessageBox.Show("重新入库成功");
}
}
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 = "";
}
}
private void SearchUnusedTestData(string strWTBH)
{
DataTable Data = CaiJiHelperClient.GetUnusedTestData(strWTBH);
if (Data != null)
{
FpSpread_Info.Columns[0].Width = 80;
FpSpread_Info.Columns[1].Width = 80;
FpSpread_Info.Columns[2].Width = 120;
FpSpread_Info.Columns[3].Width = 100;
FpSpread_Info.Columns[4].Width = 100;
FpSpread_Info.Columns[5].Width = 40;
FpSpread_Info.Columns[6].Width = 80;
FpSpread_Info.Columns[7].Width = 400;
FpSpread_Info.Columns[8].Width = 100;
FpSpread_Info.Columns[9].Width = 100;
FpSpread_Info.Columns[10].Width = 100;
FpSpread_Info.Columns[11].Width = 120;
FpSpread_Info.Rows.Count = Data.Rows.Count;
int i, j;
string strModuleIDs = string.Empty;
foreach (DataRow Row in Data.Rows)
{
strModuleIDs += "'" + Row["ModuleID"].ToString() + "',";
}
if (strModuleIDs.Length > 0)
{
strModuleIDs = strModuleIDs.Substring(0, strModuleIDs.Length - 1);
}
DataTable dtSheet = ModuleHelperClient.GetSheetIDAndName(strModuleIDs);
foreach (System.Data.DataColumn Column in Data.Columns)
{
i = Data.Columns.IndexOf(Column);
FpSpread_Info.Columns[i].VerticalAlignment = CellVerticalAlignment.Center;
FpSpread_Info.Columns[i].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
if (i == 7)//解析试验结果
{
string strTestData = Row[Column.ColumnName].ToString();
StringBuilder strTestDataName = new StringBuilder();
try
{
List <JZTestCell> lstJZTC = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JZTestCell> >(strTestData);
string strSheetName = string.Empty;
bool bHaveSheet = false;;
foreach (JZTestCell tcItem in lstJZTC)
{
if (bHaveSheet == false)
{
bHaveSheet = true;
strSheetName = GetSheetName(dtSheet, tcItem.SheetID.ToString());
if (string.IsNullOrEmpty(strSheetName))
{
strTestDataName.Append(tcItem.SheetID + "|");
}
else
{
strTestDataName.Append(strSheetName + "|");
}
}
switch (tcItem.Name)
{
case JZTestEnum.DHBJ:
strTestDataName.Append("断后标距:" + tcItem.Value);
break;
case JZTestEnum.LDZDL:
strTestDataName.Append("拉断最大力:" + tcItem.Value);
break;
case JZTestEnum.PHHZ:
strTestDataName.Append("破坏荷载:" + tcItem.Value);
break;
case JZTestEnum.QFL:
strTestDataName.Append("屈服力:" + tcItem.Value);
break;
default:
break;
}
strTestDataName.Append(";");
}
}
catch (Exception ex)
{
//logger.Error(string.Format("解析Json出错,TestData:{0},Exception:{1}", strTestData, ex.Message));
strTestDataName.Append(strTestData);
//continue;
}
FpSpread_Info.Cells[j, i].Value = strTestDataName.ToString();
}
else
{
FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
FpSpread_Info.Cells[j, i].Value = Row[Column.ColumnName].ToString();
}
FpSpread_Info.Rows[j].Tag = Row["ID"];
}
}
}
}
private void SetDataSource()
{
Sheet.Rows.Count = 0;
var result = CaiJiHelperClient.GetTestOverTimeByDataID(DataID);
if (result == null || result.Rows.Count == 0)
{
return;
}
Sheet.Rows.Count = result.Rows.Count;
for (var i = 0; i < result.Rows.Count; i++)
{
var row = result.Rows[i];
Sheet.Cells[i, 0].Value = row["标段名称"];
Sheet.Cells[i, 1].Value = row["单位名称"];
Sheet.Cells[i, 2].Value = row["试验室名称"];
Sheet.Cells[i, 3].Value = row["模板名称"];
Sheet.Cells[i, 4].Value = row["WTBH"];
Sheet.Cells[i, 6].Value = (row["实际试验日期"] == DBNull.Value || row["实际试验日期"] == null) ? "" : ((DateTime)(row["实际试验日期"])).ToString("yyyy-MM-dd");
Sheet.Cells[i, 7].Value = (row["龄期到期日期"] == DBNull.Value || row["龄期到期日期"] == null) ? "" : ((DateTime)(row["龄期到期日期"])).ToString("yyyy-MM-dd");
var builder = new StringBuilder();
var data = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JZTestCell> >(row["TestData"].ToString());
var value = string.Format("[{0}] ", row["SerialNumber"]);
foreach (var d in data)
{
switch (d.Name)
{
case JZTestEnum.DHBJ:
value += "断后标距：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.LDZDL:
value += "拉断最大力：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.PHHZ:
value += "破坏荷载：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.QFL:
value += "屈服力：" + (d.Value ?? "").ToString() + ";";
break;
default:
break;
}
}
if (!string.IsNullOrEmpty(value))
{
builder.Append(value + " ");
}
Sheet.Cells[i, 5].Value = builder.ToString();
Sheet.Rows[i].Tag = new Guid(row["ID"].ToString());
}
ShowLabel(new Guid(result.Rows[0]["ID"].ToString()));
}
private void SetDataSource()
{
Sheet.Rows.Count = 0;
var result = CaiJiHelperClient.GetTestOverTimeByDataID(DataID);
Sheet.Rows.Count = result.Rows.Count;
#region
for (var i = 0; i < result.Rows.Count; i++)
{
var row = result.Rows[i];
Sheet.Cells[i, 0].Value = row["标段名称"];
Sheet.Cells[i, 1].Value = row["单位名称"];
Sheet.Cells[i, 2].Value = row["试验室名称"];
Sheet.Cells[i, 3].Value = row["模板名称"];
Sheet.Cells[i, 4].Value = row["WTBH"];
Sheet.Cells[i, 6].Value = (row["实际试验日期"] == DBNull.Value || row["实际试验日期"] == null) ? "" : ((DateTime)(row["实际试验日期"])).ToString("yyyy-MM-dd");
Sheet.Cells[i, 7].Value = (row["龄期到期日期"] == DBNull.Value || row["龄期到期日期"] == null) ? "" : ((DateTime)(row["龄期到期日期"])).ToString("yyyy-MM-dd");
var builder = new StringBuilder();
var data = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JZTestCell> >(row["TestData"].ToString());
var value = string.Format("[{0}] ", row["SerialNumber"]);
foreach (var d in data)
{
switch (d.Name)
{
case JZTestEnum.DHBJ:
value += "断后标距：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.LDZDL:
value += "拉断最大力：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.PHHZ:
value += "破坏荷载：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.QFL:
value += "屈服力：" + (d.Value ?? "").ToString() + ";";
break;
default:
break;
}
}
if (!string.IsNullOrEmpty(value))
{
builder.Append(value + " ");
}
Sheet.Cells[i, 5].Value = builder.ToString();
Sheet.Rows[i].Tag = row["ID"];
}
#endregion
if (result.Rows.Count > 0)
{
ShowLabel(new Guid(result.Rows[0]["ID"].ToString()));
//DataTable dt = CaiJiHelperClient.GetTestOverTimeByID(new Guid(result.Rows[0]["ID"].ToString()));
//if (dt != null && dt.Rows.Count > 0)
//{
// tb_reason.Text = (dt.Rows[0]["SGComment"] ?? "").ToString();
// int Status = int.Parse(dt.Rows[0]["Status"].ToString());
// if (Status == 0)
// {
// tb_reason.Enabled = true;
// bt_save.Enabled = true;
// }
// else
// {
// tb_reason.Enabled = false;
// bt_save.Enabled = false;
// }
//}
}
}
private void bt_save_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tb_reason.Text.Trim()))
{
MessageBox.Show("延时原因不能为空！");
return;
}
var ids = new List <Guid>();
if (chkAll.Checked)
{
for (int i = 0; i < Sheet.Rows.Count; i++)
{
var t = Sheet.Rows[i].Tag.ToString();
if (string.IsNullOrEmpty(t))
{
continue;
}
ids.Add(new Guid(t));
}
}
else
{
var rows = FarPointExtensions.GetSelectionRows(Sheet);
foreach (var row in rows)
{
var t = row.Tag.ToString();
if (string.IsNullOrEmpty(t))
{
continue;
}
ids.Add(new Guid(t));
}
}
if (ids.Count <= 0)
{
MessageBox.Show("请选择要处理的数据！");
return;
}
try
{
CaiJiHelperClient.SubmitCommentMulti(ids.ToArray(), tb_reason.Text.Trim(), 2);
SetDataSource();
MessageBox.Show("保存成功，请等待监理审批！");
if (chkAll.Checked)
{
this.Close();
}
}
catch
{
MessageBox.Show("保存失败，请联系管理员");
}
//try
//{
// CaiJiHelperClient.SubmitComment(id, tb_reason.Text.Trim());
// MessageBox.Show("保存成功");
//}
//catch
//{
// MessageBox.Show("保存失败，请联系管理员");
//}
//this.Close();
}