/// <summary>
/// 生成树节点
/// </summary>
/// <param name="parentId">父级节点ID</param>
/// <param name="parentNode">父级节点</param>
/// <param name="isShowAll">是否显示已加工节点</param>
private void InitialTree(object parentId, TreeNode parentNode, bool isShowAll)
{
List <object[]> list = SqlHelper.ExecuteColumnsQuery($"SELECT bfi_id, bfi_name, bfi_path, bfi_state, bfi_type FROM backup_files_info WHERE bfi_pid='{parentId}' ORDER BY bfi_type, bfi_name", 5);
for (int i = 0; i < list.Count; i++)
{
int state = ToolHelper.GetIntValue(list[i][3], 0);
if (state != 1 || isShowAll)
{
int imageIndex = GetFileIconIndex(state, ToolHelper.GetValue(list[i][1]), list[i][4]);
TreeNode treeNode = new TreeNode()
{
Name = ToolHelper.GetValue(list[i][0]),
Text = ToolHelper.GetValue(list[i][1]),
Tag = ToolHelper.GetValue(list[i][2]),
ImageIndex = imageIndex,
SelectedImageIndex = imageIndex,
ToolTipText = ToolHelper.GetValue(list[i][4]),
StateImageKey = state.ToString(),
};
parentNode.Nodes.Add(treeNode);
InitialTree(treeNode.Name, treeNode, isShowAll);
}
}
}
/// <param name="boxId">盒主键</param>
public Frm_BorrowEditBox(object boxId, object borrowId, bool isLog)
{
string queryCon = string.Empty;
if (isLog)
{
queryCon = $"AND bl.bl_id='{borrowId}'";
}
BOX_ID = boxId;
InitializeComponent();
cbo_FileType.Items.AddRange(new object[] { "原件", "复印件", "电子" });
DataRow row = SqlHelper.ExecuteSingleRowQuery("SELECT * FROM processing_box " +
"LEFT JOIN(" +
" SELECT pi_id, pi_code, pi_name FROM project_info UNION ALL " +
" SELECT ti_id, ti_code, ti_name FROM topic_info UNION ALL " +
" SELECT imp_id, imp_code, imp_name FROM imp_info UNION ALL " +
" SELECT imp_id, imp_code, imp_name FROM imp_dev_info UNION ALL " +
" SELECT si_id, si_code, si_name FROM subject_info)A ON A.pi_id = pb_obj_id " +
$"LEFT JOIN borrow_log bl ON bl.bl_file_id = pb_id {queryCon} WHERE pb_id = '{boxId}'");
if (row != null)
{
lbl_Code.Tag = string.IsNullOrEmpty(ToolHelper.GetValue(row["bl_id"])) ? null : row["bl_id"];
lbl_pCode.Text = ToolHelper.GetValue(row["pi_code"]);
lbl_pName.Text = ToolHelper.GetValue(row["pi_name"]);
lbl_pGC.Text = ToolHelper.GetValue(row["pb_gc_id"]);
lbl_pBoxId.Text = ToolHelper.GetValue(row["pb_box_number"]);
if (isLog)
{
txt_Unit.Text = ToolHelper.GetValue(row["bl_user_unit"]);
txt_User.Text = ToolHelper.GetValue(row["bl_user"]);
txt_Phone.Text = ToolHelper.GetValue(row["bl_user_phone"]);
txt_Borrow_Date.Text = ToolHelper.GetDateValue(row["bl_date"], "yyyy-MM-dd HH:mm");
txt_Borrow_Term.Text = ToolHelper.GetValue(row["bl_term"]);
cbo_FileType.SelectedIndex = ToolHelper.GetIntValue(row["bl_form"], -1);
txt_Should_Return_Date.Text = ToolHelper.GetValue(row["bl_should_return_term"]);
txt_Real_Return_Date.Text = ToolHelper.GetValue(row["bl_real_return_term"]);
lbl_Code.Text = ToolHelper.GetValue(row["bl_code"]);
lbl_LogUser.Text = ToolHelper.GetValue(row["bl_log_user"]);
txt_Remark.Text = ToolHelper.GetValue(row["bl_remark"]);
string value = ToolHelper.GetValue(row["bl_id"]);
if (!string.IsNullOrEmpty(value))
{
lbl_Code.Tag = value;
int bstate = ToolHelper.GetIntValue(row["bl_return_state"], 0);
if (bstate != 0)
{
btn_Sure.Enabled = false;
}
else
{
btn_Sure.Text = "确认归还";
}
}
}
}
}
/// <summary>
/// 获取文件数/页数
/// </summary>
/// <param name="boxId">盒ID</param>
/// <param name="type">获取类型
/// <para>1：文件数</para>
/// <para>2：页数</para>
/// </param>
private int GetFilePageCount(object boxId, int type)
{
int fileAmount = 0, filePages = 0;
object[] pages = SqlHelper.ExecuteSingleColumnQuery($"SELECT pfl_pages FROM processing_file_list WHERE pfl_box_id='{boxId}'");
for (int i = 0; i < pages.Length; i++)
{
fileAmount++;
if (type == 2)
{
filePages += ToolHelper.GetIntValue(pages[i], 0);
}
}
return(type == 1 ? fileAmount : filePages);
}
/// <summary>
/// 重置控件
/// </summary>
private void ResetControl()
{
foreach (Control item in Controls)
{
if (item is TextBox || item is DateTimePicker)
{
if (!"txt_Unit".Equals(item.Name))
{
item.ResetText();
}
}
else if (item is NumericUpDown)
{
(item as NumericUpDown).Value = ToolHelper.GetIntValue(item.Tag, 0);
}
else if (item is System.Windows.Forms.ComboBox)
{
if ("txt_fileName".Equals(item.Name))
{
System.Windows.Forms.ComboBox comboBox = item as System.Windows.Forms.ComboBox;
comboBox.Items.Clear();
comboBox.Text = null;
}
else if ("cbo_categor".Equals(item.Name))
{
(item as System.Windows.Forms.ComboBox).SelectedIndex = 0;
}
}
else if (item is Panel)
{
foreach (Control _item in item.Controls)
{
if (_item is RadioButton)
{
(_item as RadioButton).Checked = false;
}
else if (_item is CheckBox)
{
(_item as CheckBox).Checked = false;
}
}
}
else if (item is ListView)
{
(item as ListView).Items.Clear();
}
}
}
/// <summary>
/// 卷内目录
/// </summary>
private string GetFileList(object boxId, object docCode, object GCNumber)
{
string jnmlString = Resources.jnml;
jnmlString = jnmlString.Replace("id=\"ajbh\">", $"id=\"ajbh\">{docCode}");
jnmlString = jnmlString.Replace("id=\"gch\">", $"id=\"gch\">{GCNumber}");
DataTable dataTable = new DataTable();
dataTable.Columns.AddRange(new DataColumn[]
{
new DataColumn("pfl_code"),
new DataColumn("pfl_user"),
new DataColumn("pfl_name"),
new DataColumn("pfl_pages"),
new DataColumn("pfl_date"),
new DataColumn("pfl_remark"),
});
DataTable table = SqlHelper.ExecuteQuery($"SELECT pfl_code, pfl_user, pfl_name, pfl_pages, pfl_date, pfl_remark FROM processing_file_list WHERE pfl_box_id='{boxId}' ORDER BY pfl_box_sort");
foreach (DataRow row in table.Rows)
{
dataTable.ImportRow(row);
}
int fileCount = dataTable.Rows.Count, pageCount = 0;
int i = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
int _page = ToolHelper.GetIntValue(dataRow["pfl_pages"], 0);
string newRr = "<tr>" +
$"<td>{++i}</td>" +
$"<td>{dataRow["pfl_code"]} </td>" +
$"<td style=\"\">{dataRow["pfl_user"]} </td>" +
$"<td style='text-align: left;'>{dataRow["pfl_name"]} </td>" +
$"<td>{ToolHelper.GetDateValue(dataRow["pfl_date"], "yyyy-MM-dd")} </td>" +
$"<td>{(_page == 0 ? string.Empty : _page.ToString())} </td>" +
$"<td> </td>" +
$"</tr>";
jnmlString = jnmlString.Replace("</tbody>", $"{newRr}</tbody>");
pageCount += ToolHelper.GetIntValue(dataRow["pfl_pages"]);
}
jnmlString = jnmlString.Replace("id=\"fileCount\">", $"id=\"fileCount\">{fileCount}");
jnmlString = jnmlString.Replace("id=\"pageCount\">", $"id=\"pageCount\">{pageCount}");
return(jnmlString);
}
private void 打印预览PToolStripMenuItem_Click(object sender, EventArgs e)
{
DataGridViewCell cell = view.CurrentCell;
object ptId = cell.OwningRow.Tag;
object boxId = cell.OwningRow.Cells["print"].Tag;
object GCNumber = cell.OwningRow.Cells["id"].Tag;
string HTML_STRING = string.Empty;
if ("fm".Equals(cell.OwningColumn.Name))
{
HTML_STRING = Resources.fm;
object fontObject = cell.OwningRow.Cells["font"].Tag;
if (fontObject != null)
{
Font font = (Font)fontObject;
HTML_STRING = HTML_STRING.Replace("id=\"ajmc\"", $"style=\"font-family:{font.FontFamily.Name}; \" id=\"ajmc\"");
HTML_STRING = HTML_STRING.Replace($"style=\"font-family:{font.FontFamily.Name}; \" id=\"ajmc\"", $"style=\"font-family:{font.FontFamily.Name}; font-size:{font.Size}pt; \" id=\"ajmc\"");
}
object fontObject2 = cell.OwningRow.Cells["fmbj"].Tag;
if (fontObject2 != null)
{
Font font = (Font)fontObject2;
HTML_STRING = HTML_STRING.Replace("id=\"ktmc\"", $"style=\"font-family:{font.FontFamily.Name}; \" id=\"ktmc\"");
HTML_STRING = HTML_STRING.Replace($"style=\"font-family:{font.FontFamily.Name}; \" id=\"ktmc\"", $"style=\"font-family:{font.FontFamily.Name}; font-size:{font.Size}pt; \" id=\"ktmc\"");
}
object bj = cell.OwningRow.Cells["fmbj"].Value;
object docName = SqlHelper.ExecuteOnlyOneQuery($"SELECT pt_name FROM processing_tag WHERE pt_id='{ptId}'");
HTML_STRING = GetCoverHtmlString(docName, HTML_STRING, bj, GCNumber);
}
else if ("bkb".Equals(cell.OwningColumn.Name))
{
object docCode = SqlHelper.ExecuteOnlyOneQuery($"SELECT pt_code FROM processing_tag WHERE pt_id='{ptId}'");
object boxNumber = cell.OwningRow.Cells["id"].Value;
HTML_STRING = GetBackupTable(boxId, docCode, ToolHelper.GetIntValue(boxNumber, 1));
}
else if ("jnml".Equals(cell.OwningColumn.Name))
{
object docCode = SqlHelper.ExecuteOnlyOneQuery($"SELECT pt_code FROM processing_tag WHERE pt_id='{ptId}'");
HTML_STRING = GetFileList(boxId, docCode, GCNumber);
}
new WebBrowser()
{
DocumentText = HTML_STRING, Size = new Size(500, 500)
}.DocumentCompleted += Preview_DocumentCompleted;
}
/// <summary>
/// 删除选中数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Btn_Delete_Click(object sender, EventArgs e)
{
int amount = dgv_SWDJ.SelectedRows.Count;
if (amount > 0)
{
int index = ToolHelper.GetIntValue(btn_Delete.Tag, -1);
string tipString = $"此操作会删除选中{(index == 1 ? "批次" : "光盘")}下所有已存在数据，是否确认继续？";
if (XtraMessageBox.Show(tipString, "删除确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
int type = tc_ToR.SelectedTabPageIndex;
if (type == 0)
{
if (index == 1)
{
foreach (DataGridViewRow row in dgv_SWDJ.SelectedRows)
{
string tipMsg = $"即将删除{row.Cells["trp_code"].Value}批次下所有数据，请确认是否继续？";
if (XtraMessageBox.Show(tipMsg, "确认提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK)
{
object pid = row.Cells["trp_id"].Value;
DeleteBatchById(pid);
}
}
LoadPCDataScoure(null);
}
else if (index == 2)
{
foreach (DataGridViewRow row in dgv_SWDJ.SelectedRows)
{
object cid = row.Cells["trc_id"].Value;
DeleteCDById(cid);
}
RefreshCDAmountByPid(BatchID);
LoadCDDataScoure(BatchID, BatchName);
}
}
XtraMessageBox.Show("删除成功。", "提示");
}
}
else
{
XtraMessageBox.Show("请先至少选择一条要删除的数据!", "尚未选择数据", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
private void LoadFileInfo(object fileId)
{
DataRow row = SqlHelper.ExecuteSingleRowQuery($"SELECT * FROM processing_file_list WHERE pfl_id='{fileId}'");
if (row != null)
{
cbo_stage.SelectedValue = row["pfl_stage"];
cbo_categor.SelectedValue = row["pfl_categor"];
txt_fileCode.Text = GetValue(row["pfl_code"]);
txt_User.Text = GetValue(row["pfl_user"]);
txt_fileName.Text = GetValue(row["pfl_name"]);
txt_date.Text = ToolHelper.GetDateValue(row["pfl_date"], "yyyy-MM-dd");
num_Pages.Value = ToolHelper.GetIntValue(row["pfl_pages"], 0);
num_Count.Value = ToolHelper.GetIntValue(row["pfl_count"], 0);
num_Amount.Value = ToolHelper.GetIntValue(row["pfl_amount"], 0);
SetRadioValue(row["pfl_type"], pal_type);
txt_Unit.Text = GetValue(row["pfl_unit"]);
LoadFileLinkList(GetValue(row["pfl_file_id"]));
txt_Remark.Text = GetValue(row["pfl_remark"]);
LoadFileLinkList(fileId);
}
}
/// <summary>
/// 获取统计数(若结果为null或非数字，则默认返回0)
/// </summary>
public static int ExecuteCountQuery(string querySql)
{
object value = ExecuteOnlyOneQuery(querySql);
return(ToolHelper.GetIntValue(value, 0));
}
/// <summary>
/// 加载光盘列表
/// </summary>
private void LoadGPDJ(string _querySql)
{
dgv_GPDJ.Rows.Clear();
dgv_GPDJ.Columns.Clear();
dgv_GPDJ.Columns.AddRange(new DataGridViewColumn[]
{
new DataGridViewTextBoxColumn()
{
Name = "trc_id"
},
new DataGridViewTextBoxColumn()
{
Name = "dd_name", HeaderText = "来源单位", FillWeight = 15, SortMode = DataGridViewColumnSortMode.NotSortable
},
new DataGridViewTextBoxColumn()
{
Name = "trc_code", HeaderText = "光盘编号", FillWeight = 15, SortMode = DataGridViewColumnSortMode.NotSortable
},
new DataGridViewTextBoxColumn()
{
Name = "trc_name", HeaderText = "光盘名称", FillWeight = 15, SortMode = DataGridViewColumnSortMode.NotSortable
},
new DataGridViewTextBoxColumn()
{
Name = "trc_project_amount", HeaderText = "项目数", FillWeight = 6, SortMode = DataGridViewColumnSortMode.NotSortable
},
new DataGridViewTextBoxColumn()
{
Name = "trc_subject_amount", HeaderText = "课题数", FillWeight = 6, SortMode = DataGridViewColumnSortMode.NotSortable
},
new DataGridViewTextBoxColumn()
{
Name = "trc_file_amount", HeaderText = "文件数", FillWeight = 6, SortMode = DataGridViewColumnSortMode.NotSortable
},
new DataGridViewTextBoxColumn()
{
Name = "trc_status", HeaderText = "读写状态", FillWeight = 10, SortMode = DataGridViewColumnSortMode.NotSortable
},
new DataGridViewButtonColumn()
{
Name = "control", HeaderText = "操作", FillWeight = 7, Text = "读写", UseColumnTextForButtonValue = true, SortMode = DataGridViewColumnSortMode.NotSortable
},
});
DataTable table = null;
if (_querySql == null)
{
StringBuilder querySql = new StringBuilder("SELECT trc_id, trp_submit_status, dd_name, trc_code, trc_name, trc_status, trp_name " +
"FROM transfer_registraion_cd trc LEFT JOIN(" +
"SELECT trp.trp_id, trp.trp_submit_status, dd_name, dd_sort, trp_name FROM transfer_registration_pc trp, data_dictionary dd WHERE trp.com_id = dd.dd_id ) tb " +
"ON trc.trp_id = tb.trp_id WHERE 1=1 AND trp_submit_status=1 ORDER BY CASE WHEN dd_name IS NULL THEN 1 ELSE 0 END, trc_status ASC, dd_sort, trc_sort, trc_code");
table = SqlHelper.ExecuteQuery(querySql.ToString());
}
else
{
table = SqlHelper.ExecuteQuery(_querySql);
}
foreach (DataRow row in table.Rows)
{
int _index = dgv_GPDJ.Rows.Add();
dgv_GPDJ.Rows[_index].Tag = row["trp_name"];
dgv_GPDJ.Rows[_index].Cells["trc_id"].Value = row["trc_id"];
dgv_GPDJ.Rows[_index].Cells["dd_name"].Value = row["dd_name"];
dgv_GPDJ.Rows[_index].Cells["trc_code"].Value = row["trc_code"];
dgv_GPDJ.Rows[_index].Cells["trc_name"].Value = row["trc_name"];
dgv_GPDJ.Rows[_index].Cells["trc_project_amount"].Value = GetProjectAmount(row["trc_id"]);
dgv_GPDJ.Rows[_index].Cells["trc_subject_amount"].Value = GetSubjectAmount(row["trc_id"]);
dgv_GPDJ.Rows[_index].Cells["trc_file_amount"].Value = GetFileAmount(row["trc_id"]);
dgv_GPDJ.Rows[_index].Cells["trc_status"].Tag = row["trc_status"];
int statuNum = ToolHelper.GetIntValue(row["trc_status"]);
if (statuNum != 2)
{
dgv_GPDJ.Rows[_index].Cells["trc_status"].Style.ForeColor = System.Drawing.Color.DarkRed;
}
dgv_GPDJ.Rows[_index].Cells["trc_status"].Value = GetReadStatus(statuNum);
}
if (dgv_GPDJ.Columns.Count > 0)
{
dgv_GPDJ.Columns[0].Visible = false;
}
}