private void TemperatureDialog_Load(object sender, EventArgs e)
{
ComboTemperature.DataSource = TemperatureHelperClient.GetTemperatureTypes(TestRoomCode);
FpSpread_Info.Rows.Count = 0;
FpSpread_Info.Columns.Count = 12;
FpSpread_Info.ColumnHeader.Cells[0, 0].Text = "ID";
FpSpread_Info.ColumnHeader.Cells[0, 1].Text = "试验室编码";
FpSpread_Info.ColumnHeader.Cells[0, 2].Text = "试验日期";
FpSpread_Info.ColumnHeader.Cells[0, 3].Text = "早晨温度";
FpSpread_Info.ColumnHeader.Cells[0, 4].Text = "中午温度";
FpSpread_Info.ColumnHeader.Cells[0, 5].Text = "傍晚温度";
FpSpread_Info.ColumnHeader.Cells[0, 6].Text = "平均温度";
FpSpread_Info.ColumnHeader.Cells[0, 7].Text = "备注";
FpSpread_Info.ColumnHeader.Cells[0, 8].Text = "LastEditUser";
FpSpread_Info.ColumnHeader.Cells[0, 9].Text = "LastEditTime";
FpSpread_Info.ColumnHeader.Cells[0, 10].Text = "IsUpdated";
FpSpread_Info.ColumnHeader.Cells[0, 11].Text = "TemperatureType";
FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType();
datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate;
FarPoint.Win.Spread.CellType.NumberCellType number = new FarPoint.Win.Spread.CellType.NumberCellType();
number.DecimalPlaces = 1;
number.FixedPoint = true;
FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType();
//number
var TemperatureType = Convert.ToInt32(ComboTemperature.SelectedValue);
DataTable Data = ModuleHelperClient.GetTemperatureList("000", new DateTime(2014, 1, 2), new DateTime(2014, 1, 1), TemperatureType);
FpSpread_Info.DataSource = Data;
FpSpread_Info.Columns[0].Visible = false;
FpSpread_Info.Columns[1].Visible = false;
FpSpread_Info.Columns[2].CellType = datetime;
FpSpread_Info.Columns[2].Locked = true;
FpSpread_Info.Columns[3].CellType = number;
FpSpread_Info.Columns[4].CellType = number;
FpSpread_Info.Columns[5].CellType = number;
FpSpread_Info.Columns[6].CellType = number;
FpSpread_Info.Columns[6].Locked = true;
FpSpread_Info.Columns[7].CellType = text;
FpSpread_Info.Columns[8].Visible = false;
FpSpread_Info.Columns[9].Visible = false;
FpSpread_Info.Columns[10].Visible = false;
FpSpread_Info.Columns[11].Visible = false;
FpSpread_Info.Columns[2].Width = 100;
FpSpread_Info.Columns[3].Width = 100;
FpSpread_Info.Columns[4].Width = 100;
FpSpread_Info.Columns[5].Width = 100;
FpSpread_Info.Columns[6].Width = 100;
FpSpread_Info.Columns[7].Width = 200;
DateTimePicker_Start.Value = DateTime.Now.AddMonths(-1);
DateTimePicker_End.Value = DateTime.Now;
SetDefaultStyle();
}
private void LineRename_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
var row = ComboTemperature.SelectedItem as DataRowView;
if (row == null)
{
return;
}
var temperature = new Sys_Temperature()
{
ID = Convert.ToInt32(row.Row["ID"]),
TestRoomCode = Convert.ToString(row.Row["TestRoomCode"]),
CreateTime = Convert.ToString(row.Row["CreateTime"]),
CreateBy = Convert.ToString(row.Row["CreateBy"]),
IsSystem = Convert.ToInt32(row.Row["IsSystem"]),
Name = Convert.ToString(row.Row["Name"])
};
var form = new TemperatureEditor(temperature);
if (form.ShowDialog() == DialogResult.OK)
{
ComboTemperature.DataSource = TemperatureHelperClient.GetTemperatureTypes(TestRoomCode);
}
}
private void LinkCustom_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
var form = new TemperatureEditor(TestRoomCode);
if (form.ShowDialog() == DialogResult.OK)
{
ComboTemperature.DataSource = TemperatureHelperClient.GetTemperatureTypes(TestRoomCode);
}
}
private void TemperatureUseDialog_Load(object sender, EventArgs e)
{
ComboAllTemperature.DataSource = TemperatureHelperClient.GetTemperatureTypes(TestRoomCode);
var table = DocumentHelperClient.GetDocumentExt(DocumentID);
if (table != null && table.Rows.Count > 0)
{
var type = int.Parse(table.Rows[0]["TemperatureType"].ToString());
ComboAllTemperature.SelectedValue = type;
}
}
private void LinkDelete_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (MessageBox.Show("删除后将不可恢复, 继续吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
var id = Convert.ToString(ComboTemperature.SelectedValue);
var result = TemperatureHelperClient.DeleteTemperature(id);
if (string.IsNullOrEmpty(result))
{
MessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
ComboTemperature.DataSource = TemperatureHelperClient.GetTemperatureTypes(TestRoomCode);
}
else
{
MessageBox.Show(result, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void New()
{
if (string.IsNullOrEmpty(TextName.Text))
{
MessageBox.Show("请输入温度类型名称");
TextName.Focus();
return;
}
Temperature = new Sys_Temperature()
{
IsSystem = (Yqun.Common.ContextCache.ApplicationContext.Current.IsAdministrator && CheckIsSystem.Checked) ? 1 : 0,
Name = TextName.Text,
CreateBy = Yqun.Common.ContextCache.ApplicationContext.Current.UserName,
CreateTime = DateTime.Now.ToString("yyyy-MM-dd hh:MM:ss"),
};
if (Yqun.Common.ContextCache.ApplicationContext.Current.IsAdministrator)
{
if (string.IsNullOrEmpty(TestRoomCode))
{
Temperature.TestRoomCode = "0000000000000000";
}
else
{
Temperature.TestRoomCode = TestRoomCode;
}
}
else
{
Temperature.TestRoomCode = Yqun.Common.ContextCache.ApplicationContext.Current.InTestRoom.Code;
}
var result = TemperatureHelperClient.NewTemperature(Temperature);
if (string.IsNullOrEmpty(result))
{
MessageBox.Show("保存成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show(result, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void Modify()
{
if (string.IsNullOrEmpty(TextName.Text))
{
MessageBox.Show("请输入温度类型名称");
TextName.Focus();
return;
}
Temperature.Name = TextName.Text;
var result = TemperatureHelperClient.RenameTemperature(Convert.ToString(Temperature.ID), Temperature.Name);
if (string.IsNullOrEmpty(result))
{
MessageBox.Show("保存成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show(result, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void ShowWithDocument(string documentID)
{
Show();
var table = TemperatureHelperClient.GetDocumentTemperaturesRange(documentID);
if (table != null && table.Rows.Count > 0)
{
var row = table.Rows[0];
if (Convert.IsDBNull(row["TemperatureID"]))
{
MessageBox.Show("请为该报告设置温度类型后再查看", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (Convert.IsDBNull(row["StartTime"]))
{
MessageBox.Show("不能获取龄期的制件时间, 请重试", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (Convert.IsDBNull(row["EndTime"]))
{
MessageBox.Show("不能获取龄期的开始时间, 请重试", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
var start = Convert.ToDateTime(row["StartTime"]);
var end = Convert.ToDateTime(row["EndTime"]);
var temperature = Convert.ToInt32(row["TemperatureID"]);
DateTimePicker_Start.Value = start;
DateTimePicker_End.Value = end;
ComboTemperature.SelectedValue = temperature;
Button_Query_Click(this, EventArgs.Empty);
}
}
