private void SponsorModificationDialog_Load(object sender, EventArgs e)
{
using (DataTable dt = DocumentHelperClient.GetRequestChangeUnOP(DataID))
{
if (dt != null && dt.Rows.Count > 0)
{
Info.ID = new Guid(dt.Rows[0]["ID"].ToString());
Info.Caption = dt.Rows[0]["Caption"].ToString();
Info.Reason = dt.Rows[0]["Reason"].ToString();
Info.IsRequestStadium = int.Parse(dt.Rows[0]["IsRequestStadium"].ToString());
}
else
{
Info.ID = Guid.Empty;
Info.Caption = "";
Info.Reason = "";
Info.IsRequestStadium = 0;
}
Info.DocumentID = DataID;
txtContent.Text = Info.Caption;
txtReason.Text = Info.Reason;
chkIsRequestStadium.Checked = Info.IsRequestStadium == 1 ? true : false;
//SponsorModifyInfo.Visible = != Guid.Empty;
//ButtonOk.Enabled = !SponsorModifyInfo.Visible;
}
}
private void ButtonOk_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtContent.Text.Trim()))
{
txtContent.Focus();
return;
}
if (string.IsNullOrEmpty(txtReason.Text.Trim()))
{
txtReason.Focus();
return;
}
Info.DocumentID = DataID;
Info.Caption = txtContent.Text;
Info.Reason = txtReason.Text;
Info.IsRequestStadium = chkIsRequestStadium.Checked == true ? 1 : 0;
Boolean Result = DocumentHelperClient.NewRequestChange(Info);
String Message = (Result ? "申请修改成功。" : "申请修改失败！");
MessageBoxIcon Icon = (Result ? MessageBoxIcon.Information : MessageBoxIcon.Error);
MessageBox.Show(Message, "提示", MessageBoxButtons.OK, Icon);
Close();
}
private void BindTestOverTime(Object c)
{
try
{
Yqun.Common.ContextCache.ApplicationContext.Current = c as Yqun.Common.ContextCache.ApplicationContext;
this.OverTimeTable = DocumentHelperClient.GetTestOverTimeData();
var table = GroupOverTime(OverTimeTable);
this.Invoke(new MethodInvoker(delegate
{
sheet_test_overtime.Rows.Count = 0;
if (table != null)
{
sheet_test_overtime.Rows.Count = table.Rows.Count;
if (table.Rows.Count > 0)
{
sheet_test_overtime.Rows[0, sheet_test_overtime.Rows.Count - 1].Height = 20;
sheet_test_overtime.Rows[0, sheet_test_overtime.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
}
int j;
foreach (DataRow Row in table.Rows)
{
j = table.Rows.IndexOf(Row);
sheet_test_overtime.Rows[j].Tag = Row;
sheet_test_overtime.Cells[j, 0].Value = Row["DataID"].ToString();
sheet_test_overtime.Cells[j, 1].Value = Row["标段名称"].ToString();
sheet_test_overtime.Cells[j, 2].Value = Row["单位名称"].ToString();
sheet_test_overtime.Cells[j, 3].Value = Row["试验室名称"].ToString();
sheet_test_overtime.Cells[j, 4].Value = Row["模板名称"].ToString();
sheet_test_overtime.Cells[j, 5].Value = Row["WTBH"].ToString();
sheet_test_overtime.Cells[j, 6].Value = Row["TestData"].ToString();
//spread_test_sheet.Cells[j, 5].Value = DateTime.Parse(Row["龄期到期日期"].ToString()).ToString("yyyy-MM-dd");
//spread_test_sheet.Cells[j, 6].Value = Row["试验员"].ToString();
//spread_test_sheet.Cells[j, 7].Value = DateTime.Parse(Row["实际试验日期"].ToString()).ToString("yyyy-MM-dd");
//spread_test_sheet.Cells[j, 8].Value = Row["SerialNumber"].ToString();
}
AddView(spread_test_overtime, sheet_test_overtime);
ChangeTabTitle(tabPage4, "待审批过期试验【" + spread_test_overtime.Sheets[0].RowCount + "】");
//AddViewDelegate avd = new AddViewDelegate(AddView);
//spread_test_overtime.Invoke(avd, spread_test_overtime, sheet_test_overtime);
//ChangeTabTitleDelegate cttd = new ChangeTabTitleDelegate(ChangeTabTitle);
//tabPage4.Invoke(cttd, tabPage4, "待审批过期试验【" + spread_test_overtime.Sheets[0].RowCount + "】");
}
}));
}
catch
{
}
}
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 bt_save_Click(object sender, EventArgs e)
{
String json = Newtonsoft.Json.JsonConvert.SerializeObject(views).Replace("'", "''");
Boolean flag = DocumentHelperClient.SaveCustomView(moduleID, testRoomCode, json);
if (!flag)
{
MessageBox.Show("保存失败，请稍后再试");
}
else
{
this.Close();
}
}
private void bt_save_yyfx_Click(object sender, EventArgs e)
{
bool flag = false;
RequestID = DocumentHelperClient.GetRequestChangeID(new Guid(invalidReportID));
if (chkSGRequest.Checked && RequestID == Guid.Empty && string.IsNullOrEmpty(tb_yyfx.Text.Trim()))
{
MessageBox.Show("原因分析不能为空！");
return;
}
if (tb_yyfx.Text.Trim() == "")
{
if (MessageBox.Show("当前内容为空，您确定保存吗？", "保存确定对话框", MessageBoxButtons.OKCancel)
== DialogResult.OK)
{
flag = true;
}
else
{
return;
}
}
else
{
flag = true;
}
if (flag)
{
DepositoryEvaluateDataList.SaveInvalidReportNote(invalidReportID, tb_yyfx.Text.Trim(), 0);
if (RequestID == Guid.Empty && chkSGRequest.Checked == true)
{
Sys_RequestChange Info = new Sys_RequestChange();
Info.DocumentID = new Guid(invalidReportID);
Info.Caption = "";// TextBox_Content.Text;
Info.Reason = tb_yyfx.Text;
Boolean Result = DocumentHelperClient.NewRequestChange(Info);
}
MessageBox.Show("保存成功");
//this.Close();
}
}
private void BindProcess()
{
DataTable dt = DocumentHelperClient.GetInvalidProcessInfo(invalidReportID);
if (dt != null && dt.Rows.Count > 0)
{
documentTestRoomCode = dt.Rows[0]["TestRoomCode"].ToString();
tb_yyfx.Text = dt.Rows[0]["SGComment"] == DBNull.Value ? "" : dt.Rows[0]["SGComment"].ToString();
tb_jlyj.Text = dt.Rows[0]["JLComment"] == DBNull.Value ? "" : dt.Rows[0]["JLComment"].ToString();
tb_cljg.Text = dt.Rows[0]["DealResult"] == DBNull.Value ? "" : dt.Rows[0]["DealResult"].ToString();
}
#region 控制原因分析,监理意见,处理结果的填写顺序
if (string.IsNullOrEmpty(tb_yyfx.Text))
{
tb_jlyj.Enabled = false;
tb_cljg.Enabled = false;
bt_save_jlyj.Enabled = false;
bt_save_cljg.Enabled = false;
}
else
{
tb_jlyj.Enabled = true;
tb_cljg.Enabled = true;
bt_save_jlyj.Enabled = true;
bt_save_cljg.Enabled = true;
}
if (string.IsNullOrEmpty(tb_jlyj.Text))
{
tb_cljg.Enabled = false;
bt_save_cljg.Enabled = false;
tb_yyfx.Enabled = true;
bt_save_yyfx.Enabled = true;
}
else
{
tb_cljg.Enabled = true;
bt_save_cljg.Enabled = true;
tb_yyfx.Enabled = false;
bt_save_yyfx.Enabled = false;
}
#endregion
}
private void 除ToolStripMenuItem_Click(object sender, EventArgs e)
{
var sheet = spread_test_overtime.ActiveSheet;
var rows = FarPointExtensions.GetSelectionRows(sheet);
if (rows == null || rows.Length == 0)
{
MessageBox.Show("没有选中要删除的数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
var ids = new List <string>();
foreach (var row in rows)
{
ids.Add(sheet.Cells[row.Index, 0].Value.ToString());
}
DocumentHelperClient.DeleteTestOverTime(ids);
BindTestOverTime(Yqun.Common.ContextCache.ApplicationContext.Current);
}
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
if (MessageBox.Show("您是否确定将所选记录的龄期设置到今天提醒？", "确认操作", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Row Row = spread_stadium_sheet.ActiveRow;
if (Row != null && Row.Tag is String)
{
String[] Tokens = Row.Tag.ToString().Split(',');
Guid stadiumID = new Guid(Tokens[2]);
Boolean flag = DocumentHelperClient.ResetStadiumToToday(stadiumID);
if (flag)
{
MessageBox.Show("设置成功！");
}
else
{
MessageBox.Show("设置失败，请稍后再试！");
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//if (TextCustomTemerature.Visible)
//{
// SaveCustom();
//}
//else
//{
// SaveChoice();
//}
var result = DocumentHelperClient.SaveDocumentTemperatureType(DocumentID, Convert.ToInt32(ComboAllTemperature.SelectedValue));
if (result)
{
MessageBox.Show("设置成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("设置失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
Close();
//int TemperatureType = 0;
//if (rbSDNei.Checked)
//{
// TemperatureType = 1;
//}
//Boolean bResult = DocumentHelperClient.SaveDocumentTemperatureType(DocumentID, TemperatureType);
//if (bResult)
//{
// MessageBox.Show("设置成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//}
//else
//{
// MessageBox.Show("设置失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//}
//this.Close();
}
private void LoadImage()
{
DataTable dtImage = DocumentHelperClient.GetInvalidImageList(invalidReportID);
if (dtImage != null && dtImage.Rows.Count > 0)
{
for (int i = 0; i < dtImage.Rows.Count; i++)
{
MemoryStream _tempMemoryStream = new MemoryStream(
(byte[])dtImage.Rows[i]["ImgContent"]);
if (dtImage.Rows[i]["ImgRemark"] == DBNull.Value || dtImage.Rows[i]["ImgRemark"].ToString() == "")
{
AddImage(Image.FromStream(_tempMemoryStream), 0, dtImage.Rows[i]["ImgID"], false);
AddImage(Image.FromStream(_tempMemoryStream), 1, dtImage.Rows[i]["ImgID"], false);
AddImage(Image.FromStream(_tempMemoryStream), 2, dtImage.Rows[i]["ImgID"], false);
}
else
{
switch (dtImage.Rows[i]["ImgRemark"].ToString())
{
case "原因分析":
AddImage(Image.FromStream(_tempMemoryStream), 0, dtImage.Rows[i]["ImgID"], false);
break;
case "监理意见":
AddImage(Image.FromStream(_tempMemoryStream), 1, dtImage.Rows[i]["ImgID"], false);
break;
case "处理结果":
AddImage(Image.FromStream(_tempMemoryStream), 2, dtImage.Rows[i]["ImgID"], false);
break;
default:
break;
}
}
}
}
}
private void RequestChange()
{
RequestID = DocumentHelperClient.GetRequestChangeID(new Guid(invalidReportID));
rdoYes.Enabled = false;
rdoNo.Enabled = false;
if (RequestID == Guid.Empty)
{
chkSGRequest.Enabled = true;
chkSGRequest.Checked = false;
}
else
{
chkSGRequest.Checked = true;
chkSGRequest.Enabled = false;
dtRequest = DepositoryDataModificationInfo.HaveDataModificationInfoByID(RequestID.ToString());
if (dtRequest != null && dtRequest.Rows.Count > 0)
{
if (dtRequest.Rows[0]["State"].ToString() == "已提交")
{
if (Yqun.Common.ContextCache.ApplicationContext.Current.InCompany.Type == "@unit_监理单位" ||
Yqun.Common.ContextCache.ApplicationContext.Current.IsAdministrator)
{
rdoYes.Enabled = true;
rdoNo.Enabled = true;
}
}
else if (dtRequest.Rows[0]["State"].ToString() == "通过")
{
rdoYes.Checked = true;
}
else if (dtRequest.Rows[0]["State"].ToString() == "不通过")
{
rdoNo.Checked = true;
}
}
}
}
private void BindStadiumData()
{
DataTable Data = DocumentHelperClient.SearchStadiumByWTBH(toolStripTextBox1.Text.Trim());
if (Data != null)
{
spread_stadium.ShowRow(spread_stadium.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
spread_stadium_sheet.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count == 0)
{
return;
}
int HiddenColumnCount = 4;
spread_stadium_sheet.Columns.Count = Data.Columns.Count - HiddenColumnCount;
if (spread_stadium_sheet.Columns.Count > 0)
{
spread_stadium_sheet.Columns[0].Width = 90;
spread_stadium_sheet.Columns[1].Width = 120;
spread_stadium_sheet.Columns[2].Width = 140;
spread_stadium_sheet.Columns[3].Width = 120;
spread_stadium_sheet.Columns[4].Width = 110;
spread_stadium_sheet.Columns[5].Width = 80;
spread_stadium_sheet.Columns[6].Width = 90;
spread_stadium_sheet.Columns[7].Width = 80;
spread_stadium_sheet.Columns[8].Width = 120;
spread_stadium_sheet.Columns[9].Width = 120;
spread_stadium_sheet.Columns[10].Width = 120;
spread_stadium_sheet.Columns[0, spread_stadium_sheet.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
spread_stadium_sheet.Columns[0, spread_stadium_sheet.Columns.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
}
DateTimeCellType datetime = new DateTimeCellType();
datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate;
FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType();
text.Multiline = true;
text.WordWrap = true;
spread_stadium_sheet.Columns[5].CellType = datetime;
spread_stadium_sheet.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].Height = 35;
spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].Locked = true;
spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
spread_stadium_sheet.Rows[0, spread_stadium_sheet.Rows.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
}
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "DataID" || Column.ColumnName == "ModuleID" || Column.ColumnName == "DateSpan")
{
continue;
}
i = Data.Columns.IndexOf(Column);
spread_stadium_sheet.Columns[i - HiddenColumnCount].VerticalAlignment = CellVerticalAlignment.Center;
spread_stadium_sheet.Columns[i - HiddenColumnCount].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_stadium_sheet.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
spread_stadium_sheet.Cells[j, i - HiddenColumnCount].Value = Row[Column.ColumnName].ToString();
}
}
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_stadium_sheet.Rows[j].Tag = Row["DataID"].ToString() + "," + Row["ModuleID"].ToString() + "," + Row["ID"].ToString();
}
spread_stadium.CellDoubleClick -= new CellClickEventHandler(spread_stadium_CellDoubleClick);
spread_stadium.CellDoubleClick += new CellClickEventHandler(spread_stadium_CellDoubleClick);
}
if (Data == null || Data.Rows.Count == 0)
{
MessageBox.Show("未找到数据，请检查委托编号是否正确；或重新保存资料！");
}
}
private void lb_img_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
OpenFileDialog _OpenFileDialog = new OpenFileDialog();
_OpenFileDialog.Filter = "图片文件(*.jpg,*.gif,*.bmp)|*.jpg|*.gif|*.bmp";
//int MAX_IMAGE_SIZE = 100;//图片最大上传大小,单位KB
int MAX_IMAGE_WIDTH = 800; //图片最大宽度
int MAX_IMAGE_HEIGHT = 600; //图片最大高度
float MAX_RATE = (float)MAX_IMAGE_HEIGHT / MAX_IMAGE_WIDTH; //高宽比
if (_OpenFileDialog.ShowDialog() == DialogResult.OK)
{
MemoryStream tempms = new MemoryStream(File.ReadAllBytes(_OpenFileDialog.FileName));
//long size = tempms.Length / 1024;
//if (size > MAX_IMAGE_SIZE)
//{
// MessageBox.Show(string.Format("图片大小不能超出{0}KB", MAX_IMAGE_SIZE), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return;
//}
Bitmap bitmap = new Bitmap(tempms);
#region 判断要裁剪的图片的高度
int imgWidth, imgHeight, imgCutWidth, imgCutHeight;
imgWidth = bitmap.Width;
imgHeight = bitmap.Height;
if (imgWidth <= MAX_IMAGE_WIDTH && imgHeight <= MAX_IMAGE_HEIGHT)
{
imgCutWidth = imgWidth;
imgCutHeight = imgHeight;
}
else
{
float imgRate;
imgRate = (float)imgHeight / imgWidth;
if (imgRate < MAX_RATE)
{//高小了
if (imgWidth < MAX_IMAGE_WIDTH)
{
imgCutWidth = imgWidth;
}
else
{
imgCutWidth = MAX_IMAGE_WIDTH;
}
imgCutHeight = (int)(imgCutWidth * imgRate);
}
else
{
if (imgHeight < MAX_IMAGE_HEIGHT)
{
imgCutHeight = imgHeight;
}
else
{
imgCutHeight = MAX_IMAGE_HEIGHT;
}
imgCutWidth = (int)(imgCutHeight / imgRate);
}
}
#endregion
Bitmap imgCut = JZCommonHelper.KiResizeImage(bitmap, imgCutWidth, imgCutHeight, 0);
//ImageCodecInfo jgpEncoder = GetEncoder(ImageFormat.Jpeg);
//System.Drawing.Imaging.Encoder myEncoder =
// System.Drawing.Imaging.Encoder.Quality;
//EncoderParameters myEncoderParameters = new EncoderParameters(1);
//EncoderParameter myEncoderParameter = new EncoderParameter(myEncoder, 100L);
//myEncoderParameters.Param[0] = myEncoderParameter;
//using (MemoryStream stream = new MemoryStream())
//{
// b.Save(stream, jgpEncoder, myEncoderParameters);
// b = new Bitmap(stream);
//}
MemoryStream stream = new MemoryStream();
imgCut.Save(stream, ImageFormat.Jpeg);
JZFile file = new JZFile();
file.FileData = stream.ToArray();
String newImgID = DocumentHelperClient.SaveInvalidImage(invalidReportID, file, GetSeletedText());
if (newImgID != "")
{
//AddImage(new Bitmap(tempms), tabControl1.SelectedIndex, newImgID, true);
AddImage(new Bitmap(stream), tabControl1.SelectedIndex, newImgID, true);
tempms.Close();
tempms.Dispose();
stream.Close();
stream.Dispose();
}
else
{
MessageBox.Show("图片上传失败");
}
}
}
private void BindInvalid(Object c)
{
try
{
Yqun.Common.ContextCache.ApplicationContext.Current = c as Yqun.Common.ContextCache.ApplicationContext;
SheetView spread_invalide_sheet = new SheetView();
spread_invalide_sheet.Rows.Count = 0;
spread_invalide_sheet.Columns.Count = 12;
spread_invalide_sheet.ColumnHeader.Cells[0, 0].Text = "标段";
spread_invalide_sheet.ColumnHeader.Cells[0, 1].Text = "单位";
spread_invalide_sheet.ColumnHeader.Cells[0, 2].Text = "试验室";
spread_invalide_sheet.ColumnHeader.Cells[0, 3].Text = "试验报告";
spread_invalide_sheet.ColumnHeader.Cells[0, 4].Text = "报告编号";
spread_invalide_sheet.ColumnHeader.Cells[0, 5].Text = "报告日期";
spread_invalide_sheet.ColumnHeader.Cells[0, 6].Text = "试验项目";
spread_invalide_sheet.ColumnHeader.Cells[0, 7].Text = "标准值";
spread_invalide_sheet.ColumnHeader.Cells[0, 8].Text = "实测值";
spread_invalide_sheet.ColumnHeader.Cells[0, 9].Text = "原因分析";
spread_invalide_sheet.ColumnHeader.Cells[0, 10].Text = "监理意见";
spread_invalide_sheet.ColumnHeader.Cells[0, 11].Text = "处理结果";
spread_invalide_sheet.Columns[0].Width = 80;
spread_invalide_sheet.Columns[1].Width = 100;
spread_invalide_sheet.Columns[2].Width = 100;
spread_invalide_sheet.Columns[3].Width = 190;
spread_invalide_sheet.Columns[4].Width = 200;
spread_invalide_sheet.Columns[5].Width = 90;
spread_invalide_sheet.Columns[6].Width = 110;
spread_invalide_sheet.Columns[7, 8].Width = 90;
spread_invalide_sheet.Columns[9].Width = 200;
spread_invalide_sheet.Columns[10].Width = 200;
spread_invalide_sheet.Columns[11].Width = 200;
FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType();
datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate;
spread_invalide_sheet.Columns[5].CellType = datetime;
Boolean isSG = false;
if (userType.IndexOf("施工") > 0)
{
isSG = true;
}
DataTable Data = DocumentHelperClient.GetUndoInvalidDocumentList(isSG);
if (Data != null)
{
//spread_invalide.ShowRow(spread_invalide.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
spread_invalide_sheet.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType();
text.Multiline = true;
text.WordWrap = true;
spread_invalide_sheet.Columns[0, 2].CellType = text;
spread_invalide_sheet.Rows[0, spread_invalide_sheet.Rows.Count - 1].Height = 25;
spread_invalide_sheet.Rows[0, spread_invalide_sheet.Rows.Count - 1].Locked = true;
spread_invalide_sheet.Columns[0, spread_invalide_sheet.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
spread_invalide_sheet.Rows[0, spread_invalide_sheet.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "ModuleID")
{
continue;
}
i = Data.Columns.IndexOf(Column);
spread_invalide_sheet.Columns[i - 2].VerticalAlignment = CellVerticalAlignment.Center;
spread_invalide_sheet.Columns[i - 2].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_invalide_sheet.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
spread_invalide_sheet.Cells[j, i - 2].Value = Row[Column.ColumnName].ToString();
}
}
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_invalide_sheet.Rows[j].Tag = Row["ID"].ToString() + "," + Row["ModuleID"].ToString();
}
}
}
AddViewDelegate avd = new AddViewDelegate(AddView);
spread_invalide.Invoke(avd, spread_invalide, spread_invalide_sheet);
ChangeTabTitleDelegate cttd = new ChangeTabTitleDelegate(ChangeTabTitle);
tabPage2.Invoke(cttd, tabPage2, "待处理不合格报告【" + spread_invalide.Sheets[0].RowCount + "】");
}
catch
{
}
}
private void BindRequest(Object c)
{
try
{
Yqun.Common.ContextCache.ApplicationContext.Current = c as Yqun.Common.ContextCache.ApplicationContext;
SheetView spread_request_sheet = new SheetView();
spread_request_sheet.Columns.Count = 11;
spread_request_sheet.Columns[0].Width = 80;
spread_request_sheet.Columns[1].Width = 100;
spread_request_sheet.Columns[2].Width = 200;
spread_request_sheet.Columns[3].Width = 150;
spread_request_sheet.Columns[4].Width = 240;
spread_request_sheet.Columns[5].Width = 80;
spread_request_sheet.Columns[6].Width = 130;
spread_request_sheet.Columns[7].Width = 120;
spread_request_sheet.Columns[8].Width = 300;
spread_request_sheet.Columns[9].Width = 300;
spread_request_sheet.Columns[0, spread_request_sheet.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
TextCellType text = new TextCellType();
text.Multiline = true;
text.WordWrap = true;
spread_request_sheet.Columns[0, 2].CellType = text;
DataTable Data = DocumentHelperClient.GetUnPreocessedRequestList();
spread_request_sheet.Rows.Count = 0;
if (Data != null)
{
//spread_request.ShowRow(spread_request.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
spread_request_sheet.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
spread_request_sheet.Rows[0, spread_request_sheet.Rows.Count - 1].Height = 20;
spread_request_sheet.Rows[0, spread_request_sheet.Rows.Count - 1].Locked = true;
spread_request_sheet.Rows[0, spread_request_sheet.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
}
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "DataID" || Column.ColumnName == "ModuleID")
{
continue;
}
i = Data.Columns.IndexOf(Column);
spread_request_sheet.Columns[i - 3].VerticalAlignment = CellVerticalAlignment.Center;
spread_request_sheet.Columns[i - 3].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_request_sheet.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
spread_request_sheet.Cells[j, i - 3].Value = Row[Column.ColumnName].ToString();
}
}
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_request_sheet.Rows[j].Tag = Row["ID"].ToString() + "," + Row["DataID"].ToString() + "," + Row["ModuleID"].ToString();
}
}
AddViewDelegate avd = new AddViewDelegate(AddView);
spread_request.Invoke(avd, spread_request, spread_request_sheet);
ChangeTabTitleDelegate cttd = new ChangeTabTitleDelegate(ChangeTabTitle);
tabPage3.Invoke(cttd, tabPage3, "待审批用户申请【" + spread_request.Sheets[0].RowCount + "】");
}
catch
{
}
}
private void toolStripButton1_Click_1(object sender, EventArgs e)
{
Boolean flag = DocumentHelperClient.GeneratePLDTable();
MessageBox.Show(flag.ToString());
}
private void ModelFieldSettingDialog_Load(object sender, EventArgs e)
{
views = DocumentHelperClient.GetCustomViewList(moduleID, testRoomCode);
LoadCustomView();
}
private void bt_apply_Click(object sender, EventArgs e)
{
DocumentHelperClient.ApplyExtFields(moduleID);
MessageBox.Show("完成");
}
private void LogDialog_Load(object sender, EventArgs e)
{
ProgressScreen.Current.ShowSplashScreen();
this.AddOwnedForm(ProgressScreen.Current);
InitLogCategoryInfo();
Dictionary <Guid, SheetView> SheetCollection = new Dictionary <Guid, SheetView>();
try
{
List <FarPoint.CalcEngine.FunctionInfo> Infos = FunctionItemInfoUtil.getFunctionItemInfos();
FpSpread.Sheets.Clear();
if (dataID == Guid.Empty)
{
return;
}
JZDocument document = DocumentHelperClient.GetDocumentByID(dataID);
JZDocument defaultDocument = ModuleHelperClient.GetDefaultDocument(moduleID);
List <JZFormulaData> CrossSheetFormulaInfos = ModuleHelperClient.GetFormulaByModuleIndex(moduleID);
foreach (JZSheet sheet in defaultDocument.Sheets)
{
ProgressScreen.Current.SetStatus = "正在初始化表单‘" + sheet.Name + "’";
String sheetXML = ModuleHelperClient.GetSheetXMLByID(sheet.ID);
SheetView SheetView = Serializer.LoadObjectXml(typeof(SheetView), sheetXML, "SheetView") as SheetView;
SheetView.Tag = sheet.ID;
SheetView.SheetName = sheet.Name;
SheetView.Cells[0, 0].Value = "";
SheetView.Protect = true;
FpSpread.Sheets.Add(SheetView);
SheetCollection.Add(sheet.ID, SheetView);
foreach (FarPoint.CalcEngine.FunctionInfo Info in Infos)
{
SheetView.AddCustomFunction(Info);
}
foreach (JZCell dataCellDefault in sheet.Cells)
{
Cell cell = SheetView.Cells[dataCellDefault.Name];
Object value = JZCommonHelper.GetCellValue(document, sheet.ID, dataCellDefault.Name);
Boolean hasValue = true;
if (value == null || value.ToString() == "")
{
hasValue = false;
}
if (cell != null)
{
cell.Font = defaultFont;
if (cell.CellType is DownListCellType)
{
DownListCellType CellType = cell.CellType as DownListCellType;
CellType.DropDownButton = false;
CellType.DesignMode = false;
cell.Value = value;
}
else if (cell.CellType is TextCellType)
{
TextCellType CellType = cell.CellType as TextCellType;
if (CellType.FieldType.Description == FieldType.Text.Description)
{
CellType.Multiline = true;
CellType.WordWrap = true;
}
CellType.MaxLength = CellType.FieldType.Length;
if (hasValue)
{
cell.Value = value.ToString().Trim('\r', '\n');;
}
}
else if (cell.CellType is LongTextCellType)
{
LongTextCellType CellType = cell.CellType as LongTextCellType;
if (CellType.FieldType.Description == FieldType.LongText.Description)
{
CellType.Multiline = true;
CellType.WordWrap = true;
}
CellType.MaxLength = CellType.FieldType.Length;
if (hasValue)
{
cell.Value = value.ToString().Trim('\r', '\n');;
}
}
else if (cell.CellType is DateTimeCellType)
{
DateTimeCellType CellType = cell.CellType as DateTimeCellType;
CellType.MinimumDate = new DateTime(1753, 1, 1);
CellType.MaximumDate = new DateTime(9999, 12, 31);
cell.Value = value;
}
else if (cell.CellType is RichTextCellType)
{
RichTextCellType CellType = cell.CellType as RichTextCellType;
CellType.Multiline = false;
CellType.WordWrap = false;
CellType.MaxLength = CellType.FieldType.Length;
if (hasValue)
{
cell.Value = value.ToString().Trim('\r', '\n');;
}
}
else if (cell.CellType is NumberCellType)
{
NumberCellType CellType = cell.CellType as NumberCellType;
CellType.MaximumValue = 999999999.9999;
CellType.MinimumValue = -999999999.9999;
cell.Value = value;
}
else if (cell.CellType is MaskCellType)
{
MaskCellType CellType = cell.CellType as MaskCellType;
CellType.Mask = "00000000000000000000000000000000000";
if (CellType.CustomMaskCharacters != null && CellType.CustomMaskCharacters.Length > 0)
{
CellType.CustomMaskCharacters[0] = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-()（）复检";
}
cell.Value = value;
}
else if (cell.CellType is ImageCellType)
{
if (value != null)
{
cell.Value = JZCommonHelper.StringToBitmap(value.ToString());
}
}
else
{
cell.Value = value;
}
}
}
}
ProgressScreen.Current.SetStatus = "正在初始化跨表公式...";
foreach (JZFormulaData formula in CrossSheetFormulaInfos)
{
SheetView Sheet = SheetCollection[formula.SheetIndex];
try
{
Sheet.Cells[formula.RowIndex, formula.ColumnIndex].Formula = formula.Formula;
}
catch
{
}
}
FpSpread.LoadFormulas(true);
ProgressScreen.Current.SetStatus = "正在显示资料...";
UpdateChart();
UpdateEquation();
SetNotes();
//设置只读模式
if (ReadOnly)
{
foreach (SheetView sheet in FpSpread.Sheets)
{
sheet.OperationMode = OperationMode.ReadOnly;
}
}
}
catch (TimeoutException ex1)
{
MessageBox.Show("网络原因造成数据无法访问，请检查本机网络连接，或稍后再试！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show("加载试验模板出错！\r\n原因：" + (ex.InnerException != null ? ex.InnerException.Message : ex.Message), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
try
{
this.RemoveOwnedForm(ProgressScreen.Current);
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
}
catch (Exception ex1) { }
}
}
private void DataDialog_Load(object sender, EventArgs e)
{
ProgressScreen.Current.ShowSplashScreen();
this.AddOwnedForm(ProgressScreen.Current);
Dictionary <Guid, SheetView> SheetCollection = new Dictionary <Guid, SheetView>();
JZDocument document = DocumentHelperClient.GetDocumentByID(DataID);
JZDocument defaultDocument = ModuleHelperClient.GetDefaultDocument(ModuleID);
List <JZFormulaData> CrossSheetFormulaInfos = ModuleHelperClient.GetLineFormulaByModuleIndex(ModuleID);
FpSpread.Sheets.Clear();
LoadSpread(FpSpread, ModuleID);
#region 初始化表单
foreach (JZSheet sheet in defaultDocument.Sheets)
{
SheetView SheetView = GetSheet(sheet.ID);
foreach (JZCell dataCellDefault in sheet.Cells)
{
Cell cell = SheetView.Cells[dataCellDefault.Name];
Object value = JZCommonHelper.GetCellValue(document, sheet.ID, dataCellDefault.Name);
Boolean hasValue = true;
if (value == null || value.ToString() == "")
{
hasValue = false;
}
if (cell != null)
{
#region 处理单元格
cell.Locked = false;
cell.Font = defaultFont;
if (cell.CellType is DownListCellType)
{
DownListCellType CellType = cell.CellType as DownListCellType;
CellType.DropDownButton = false;
CellType.DesignMode = false;
cell.Value = value;
}
else if (cell.CellType is TextCellType)
{
TextCellType CellType = cell.CellType as TextCellType;
if (CellType.FieldType.Description == FieldType.Text.Description)
{
CellType.Multiline = true;
CellType.WordWrap = true;
}
CellType.MaxLength = CellType.FieldType.Length;
if (hasValue)
{
cell.Value = value.ToString().Trim('\r', '\n');;
}
else
{
cell.Value = value;
}
}
else if (cell.CellType is LongTextCellType)
{
LongTextCellType CellType = cell.CellType as LongTextCellType;
if (CellType.FieldType.Description == FieldType.LongText.Description)
{
CellType.Multiline = true;
CellType.WordWrap = true;
}
CellType.MaxLength = CellType.FieldType.Length;
if (hasValue)
{
cell.Value = value.ToString().Trim('\r', '\n');;
}
else
{
cell.Value = value;
}
}
else if (cell.CellType is DateTimeCellType)
{
DateTimeCellType CellType = cell.CellType as DateTimeCellType;
CellType.MinimumDate = new DateTime(1753, 1, 1);
CellType.MaximumDate = new DateTime(9999, 12, 31);
cell.Value = value;
}
else if (cell.CellType is RichTextCellType)
{
RichTextCellType CellType = cell.CellType as RichTextCellType;
CellType.Multiline = false;
CellType.WordWrap = false;
CellType.MaxLength = CellType.FieldType.Length;
if (hasValue)
{
cell.Value = value.ToString().Trim('\r', '\n');
}
else
{
cell.Value = value;
}
}
else if (cell.CellType is DeleteLineCellType)
{//删除线
DeleteLineCellType CellType = cell.CellType as DeleteLineCellType;
CellType.Multiline = true;
CellType.WordWrap = true;
CellType.MaxLength = CellType.FieldType.Length;
cell.CellType = CellType;
object objOld = cell.Text;
if (hasValue)
{
cell.Value = new System.Text.RegularExpressions.Regex("'+").Replace(value.ToString(), "'"); //value.ToString();
if (string.IsNullOrEmpty(cell.Text))
{
RichTextBox rt = new RichTextBox();
rt.Text = objOld == null ? "" : objOld.ToString();
rt.Font = new Font("宋体", 10.5f, FontStyle.Regular);
cell.Value = rt.Rtf;
}
}
else
{
RichTextBox rt = new RichTextBox();
rt.Text = objOld == null ? "" : objOld.ToString();
rt.Font = new Font("宋体", 10.5f, FontStyle.Regular);
cell.Value = rt.Rtf;
}
}
else if (cell.CellType is NumberCellType)
{
NumberCellType CellType = cell.CellType as NumberCellType;
CellType.MaximumValue = 999999999.9999;
CellType.MinimumValue = -999999999.9999;
cell.Value = value;
}
else if (cell.CellType is MaskCellType)
{
MaskCellType CellType = cell.CellType as MaskCellType;
for (int i = CellType.Mask.Length; i < CellType.FieldType.Length; i++)
{
CellType.Mask += "0";
}
if (CellType.CustomMaskCharacters != null && CellType.CustomMaskCharacters.Length > 0)
{
CellType.CustomMaskCharacters[0] = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-()ⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩ（）复检";
}
if (value == null || value.ToString().Trim() == "")
{
cell.Value = null;
}
else
{
cell.Value = value.ToString().Trim();
}
}
else if (cell.CellType is ImageCellType)
{
if (value != null)
{
cell.Value = JZCommonHelper.StringToBitmap(value.ToString());
}
else
{
cell.Value = null;
}
}
else if (cell.CellType is HyperLinkCellType)
{
if (value != null)
{
List <string> lstLink = new List <string>();
HyperLinkCellType hlnkCell = new HyperLinkCellType();
try
{
lstLink = Newtonsoft.Json.JsonConvert.DeserializeObject <List <string> >(value.ToString());
hlnkCell.Text = lstLink[0];
hlnkCell.Link = lstLink[1];
}
catch
{
hlnkCell.Text = value.ToString();
hlnkCell.Link = "";
}
cell.CellType = hlnkCell;
//cell.Value = value;
}
else
{
HyperLinkCellType hlnkCell = new HyperLinkCellType();
cell.CellType = hlnkCell;
}
}
else
{
cell.Value = value;
}
#endregion
JZCellProperty p = cell.Tag as JZCellProperty;
#region 处理单元格属性
if (p != null)
{
cell.Locked = false;
}
else
{
// logger.Error("未能设置数据区信息：单元格" + dataCellDefault.Name + "，表单：" + sheet.Name);
}
#endregion
}
}
#region 线路单元格样式
DataTable dtCellStyle = ModuleHelperClient.GetCellStyleBySheetID(sheet.ID);
for (int i = 0; i < dtCellStyle.Rows.Count; i++)
{
if (dtCellStyle.Rows[i]["CellStyle"] != null)
{
JZCellStyle CurrentCellStyle = Newtonsoft.Json.JsonConvert.DeserializeObject <JZCellStyle>(dtCellStyle.Rows[i]["CellStyle"].ToString());
if (CurrentCellStyle != null)
{
string strCellName = dtCellStyle.Rows[i]["CellName"].ToString();
Cell cell = SheetView.Cells[strCellName];
cell.ForeColor = CurrentCellStyle.ForColor;
cell.BackColor = CurrentCellStyle.BackColor;
cell.Font = new Font(CurrentCellStyle.FamilyName, CurrentCellStyle.FontSize, CurrentCellStyle.FontStyle);
}
}
}
#endregion
}
#endregion
UpdateChart();
UpdateEquation();
//设置只读模式
if (ReadOnly)
{
foreach (SheetView sheet in FpSpread.Sheets)
{
sheet.OperationMode = OperationMode.ReadOnly;
}
}
}
private void Button_Query_Click(object sender, EventArgs e)
{
ProgressScreen.Current.ShowSplashScreen();
ProgressScreen.Current.SetStatus = "正在获取数据...";
String segment = "";
String company = "";
String testroom = "";
if (ComboBox_Segments.SelectedItem is Prjsct)
{
segment = (ComboBox_Segments.SelectedItem as Prjsct).PrjsctCode;
}
else
{
segment = "";
}
if (ComboBox_Company.SelectedItem is Orginfo)
{
company = (ComboBox_Company.SelectedItem as Orginfo).DepCode;
}
else
{
company = "";
}
if (ComboBox_TestRooms.SelectedItem is PrjFolder)
{
testroom = (ComboBox_TestRooms.SelectedItem as PrjFolder).FolderCode;
}
else
{
testroom = "";
}
DateTime StartDate = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", DateTimePicker_Start.Value.Year, DateTimePicker_Start.Value.Month, DateTimePicker_Start.Value.Day));
DateTime EndDate = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", DateTimePicker_End.Value.Year, DateTimePicker_End.Value.Month, DateTimePicker_End.Value.Day));
String sReportName = TextBox_ReportName.Text;
String sReportNumber = TextBox_ReportNumber.Text;
String sTestItems = TextBox_TestItems.Text;
int SameCountSum = 0;
DataTable Data = DocumentHelperClient.GetInvalidDocumentList(segment, company, testroom, sReportName, sReportNumber, StartDate, EndDate, sTestItems);
if (Data != null)
{
FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
FpSpread_Info.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType();
text.Multiline = true;
text.WordWrap = true;
FpSpread_Info.Columns[0, 2].CellType = text;
FpSpread_Info.Columns[11].CellType = text;
FpSpread_Info.Columns[12].CellType = text;
FpSpread_Info.Columns[13].CellType = text;
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Height = 25;
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Locked = true;
FpSpread_Info.Columns[0, FpSpread_Info.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "ModuleID")
{
continue;
}
i = Data.Columns.IndexOf(Column);
FpSpread_Info.Columns[i - 2].VerticalAlignment = CellVerticalAlignment.Center;
FpSpread_Info.Columns[i - 2].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
FpSpread_Info.Cells[j, i - 2].Value = Row[Column.ColumnName].ToString();
}
}
string strIsHeGe, strID;
//foreach (DataRow Row in Data.Rows)
//{
// j = Data.Rows.IndexOf(Row);
// FpSpread_Info.Rows[j].Tag = Row["ID"].ToString() + "," + Row["ModuleID"].ToString();
// strIsHeGe = Row["是否合格"].ToString();
// if (strIsHeGe == "已合格")
// {
// FpSpread_Info.Rows[j].BackColor = Color.FromArgb(240, 180, 120);
// }
// else
// {
// FpSpread_Info.Rows[j].BackColor = Color.White;
// }
// strInvalidItem = Row["不合格项目"].ToString();
// FpSpread_Info.Rows[j].Height = strInvalidItem.Split('\r').Length * 24;
// strID = Row["ID"].ToString();
//}
DataRow drRow;
int SameCount;
for (int m = 0; m < Data.Rows.Count; m++)
{
FpSpread_Info.Rows[m].Tag = Data.Rows[m]["ID"].ToString() + "," + Data.Rows[m]["ModuleID"].ToString();
strIsHeGe = Data.Rows[m]["是否合格"].ToString();
if (strIsHeGe == "已合格")
{
FpSpread_Info.Rows[m].BackColor = Color.FromArgb(240, 180, 120);
}
else
{
FpSpread_Info.Rows[m].BackColor = Color.White;
}
drRow = Data.Rows[m];
strID = drRow["ID"].ToString();
SameCount = -1;
foreach (DataRow drItem in Data.Rows)
{
if (strID == drItem["ID"].ToString())
{
SameCount++;
}
}
if (SameCount > 0)
{
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "ModuleID" || Column.ColumnName == "不合格项目" || Column.ColumnName == "标准规定值" || Column.ColumnName == "实测值")
{
continue;
}
i = Data.Columns.IndexOf(Column);
FpSpread_Info.Cells[m, i - 2].RowSpan = SameCount + 1;
}
SameCountSum += SameCount;
m += SameCount;
}
}
FpSpread.MouseUp += new MouseEventHandler(FpSpread_MouseUp);
}
else
{
FpSpread.MouseUp -= new MouseEventHandler(FpSpread_MouseUp);
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
MessageBox.Show("无数据，请重新选择条件!");
}
}
else
{
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
FpSpread.MouseUp -= new MouseEventHandler(FpSpread_MouseUp);
MessageBox.Show("无数据，请重新选择条件!");
}
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
if (Data == null)
{
TotalCount.Text = string.Format("本次查询共 {0} 条记录", 0);
}
else
{
TotalCount.Text = string.Format("本次查询共 {0} 条记录", Data.Rows.Count - SameCountSum);
}
}
private void Button_Query_Click(object sender, EventArgs e)
{
ProgressScreen.Current.ShowSplashScreen();
ProgressScreen.Current.SetStatus = "正在获取数据...";
String segment = "";
String company = "";
String testroom = "";
String SelectedState = cb_state.SelectedItem.ToString();
if (ComboBox_Segments.SelectedItem is Prjsct)
{
segment = (ComboBox_Segments.SelectedItem as Prjsct).PrjsctCode;
}
if (ComboBox_Company.SelectedItem is Orginfo)
{
company = (ComboBox_Company.SelectedItem as Orginfo).DepCode;
}
if (ComboBox_TestRooms.SelectedItem is PrjFolder)
{
testroom = (ComboBox_TestRooms.SelectedItem as PrjFolder).FolderCode;
}
DateTime start = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", StartDateTimePicker.Value.Year, StartDateTimePicker.Value.Month, StartDateTimePicker.Value.Day));
DateTime end = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", EndDateTimePicker.Value.Year, EndDateTimePicker.Value.Month, EndDateTimePicker.Value.Day));
DataTable Data = DocumentHelperClient.GetRequestChangeList(segment, company, testroom, start, end, SelectedState, tb_content.Text.Trim(), tb_user.Text.Trim());
if (Data != null)
{
FpSpread FpSpread = fpSpread1;
SheetView FpSpread_Info = fpSpread1_Sheet;
FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
FpSpread_Info.Columns.Count = 12;
FpSpread_Info.Columns[0].Width = 60;
FpSpread_Info.Columns[1].Width = 60;
FpSpread_Info.Columns[2].Width = 80;
FpSpread_Info.Columns[3].Width = 80;
FpSpread_Info.Columns[4].Width = 240;
FpSpread_Info.Columns[5].Width = 160;
FpSpread_Info.Columns[6].Width = 80;
FpSpread_Info.Columns[7].Width = 50;
FpSpread_Info.Columns[8].Width = 120;
FpSpread_Info.Columns[9].Width = 300;
FpSpread_Info.Columns[10].Width = 300;
FpSpread_Info.Columns[0, FpSpread_Info.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
TextCellType text = new TextCellType();
text.Multiline = true;
text.WordWrap = true;
FpSpread_Info.Columns[0, 2].CellType = text;
FpSpread_Info.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Height = 20;
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Locked = true;
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
}
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "DataID" || Column.ColumnName == "ModuleID")
{
continue;
}
i = Data.Columns.IndexOf(Column);
FpSpread_Info.Columns[i - 3].VerticalAlignment = CellVerticalAlignment.Center;
FpSpread_Info.Columns[i - 3].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
FpSpread_Info.Cells[j, i - 3].Value = Row[Column.ColumnName].ToString();
}
}
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
FpSpread_Info.Rows[j].Tag = Row["ID"].ToString() + "," + Row["DataID"].ToString() + "," + Row["ModuleID"].ToString();// Row["ID"].ToString();
}
if (Data.Rows.Count == 0)
{
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
MessageBox.Show("无数据，请重新选择条件!");
}
}
else
{
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
MessageBox.Show("无数据，请重新选择条件!");
}
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
}
void worker_DoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker worker = sender as BackgroundWorker;
DataExportClass Params = e.Argument as DataExportClass;
Font defaultFont = new Font("宋体", 9f);
String Path = Params.path;
if (string.IsNullOrEmpty(Path))
{
return;
}
MyCell fpSpread = new MyCell();
fpSpread.Watermark = ModuleHelperClient.GetWatermarkByModuleID(moduleID);
//初始化模板样式
List <FarPoint.CalcEngine.FunctionInfo> Infos = FunctionItemInfoUtil.getFunctionItemInfos();
List <JZFormulaData> CrossSheetFormulaInfos = ModuleHelperClient.GetFormulaByModuleIndex(moduleID);
Dictionary <Sys_Document, JZDocument> list = DocumentHelperClient.GetDocumentDataListByModuleIDAndTestRoomCode(moduleID, testRoomCode);
if (list.Count == 0)
{
return;
}
Dictionary <Sys_Document, JZDocument> .Enumerator em = list.GetEnumerator();
int i = 0;
while (em.MoveNext())
{
Sys_Document docBase = em.Current.Key;
JZDocument doc = em.Current.Value;
if (i == 0)
{
foreach (JZSheet sheet in doc.Sheets)
{
ProgressScreen.Current.SetStatus = string.Format("正在准备表单{0}...", sheet.Name);
String sheetXML = ModuleHelperClient.GetSheetXMLByID(sheet.ID);
SheetView SheetView = Serializer.LoadObjectXml(typeof(SheetView), sheetXML, "SheetView") as SheetView;
SheetView.Tag = sheet.ID;
SheetView.SheetName = sheet.Name;
SheetView.Cells[0, 0].Value = "";
SheetView.Protect = true;
fpSpread.Sheets.Add(SheetView);
foreach (FarPoint.CalcEngine.FunctionInfo Info in Infos)
{
SheetView.AddCustomFunction(Info);
}
}
fpSpread.LoadFormulas(true);
}
i = i + 1;
worker.ReportProgress((int)(((float)i / (float)list.Count) * 100));
foreach (JZSheet sheet in doc.Sheets)
{
SheetView sheetV = null;
for (int j = 0; j < fpSpread.Sheets.Count; j++)
{
if (new Guid(fpSpread.Sheets[j].Tag.ToString()) == sheet.ID)
{
sheetV = fpSpread.Sheets[j];
break;
}
}
if (sheetV == null)
{
break;
}
foreach (JZCell dataCell in sheet.Cells)
{
Cell cell = sheetV.Cells[dataCell.Name];
if (cell != null)
{
cell.Font = defaultFont;
if (cell.CellType is ImageCellType)
{
if (dataCell.Value != null)
{
cell.Value = JZCommonHelper.StringToBitmap(dataCell.Value.ToString());
}
}
else
{
cell.Value = dataCell.Value;
}
}
}
}
try
{
//保存资料到指定目录
String reportNumber = docBase.BGBH == "" ? "无报告编号" + i.ToString() : docBase.BGBH;
ExcelWarningList ewl = new ExcelWarningList();
string fileName = Path + "\\" + moduleName + "-" + reportNumber + ".xls";
fpSpread.SaveExcel(fileName, ExcelSaveFlags.NoFlagsSet, ewl);
}
catch
{ }
}
}
