private void LoadLoginLog(string key)
{
view.Rows.Clear();
searchControl.Properties.Items.Clear();
string querySQL = $"SELECT TOP(1000) sll.*, ul.real_name FROM sys_login_log sll " +
$"LEFT JOIN user_list ul ON sll_user_id = ul_id WHERE 1=1 ";
if (key != null)
{
querySQL += $" AND ul.real_name LIKE '%{key}%' ";
}
querySQL += "ORDER BY CONVERT(DATETIME, sll_online_date) DESC";
DataTable table = SqlHelper.ExecuteQuery(querySQL);
foreach (DataRow row in table.Rows)
{
int i = view.Rows.Add();
view.Rows[i].Cells["id"].Value = i + 1;
view.Rows[i].Cells["username"].Value = row["real_name"];
view.Rows[i].Cells["ipaddress"].Value = row["sll_ipaddress"];
view.Rows[i].Cells["login"].Value = ToolHelper.GetDateValue(row["sll_online_date"], "yyyy-MM-dd HH:mm:dd");
view.Rows[i].Cells["logout"].Value = ToolHelper.GetDateValue(row["sll_offline_date"], "yyyy-MM-dd HH:mm:dd");
searchControl.Properties.Items.Add(row["real_name"]);
}
}
public static void AddWorkLog(WorkLogType logType, int amount, object batchCode, int segment, object objectId, object userid)
{
if (string.IsNullOrEmpty(ToolHelper.GetValue(batchCode)))
{
return;
}
string date = ToolHelper.GetDateValue(DateTime.Now, "yyyy-MM-dd");
int type = (int)logType;
string existQuery = $"SELECT wl_id FROM work_log WHERE wl_user_id='{userid}' AND wl_datetime='{date}' AND wl_batch_code='{batchCode}' AND wl_type='{type}' AND wl_segment={segment}";
object result = SqlHelper.ExecuteOnlyOneQuery(existQuery);
if (result != null)
{
string updateSQL = $"UPDATE work_log SET wl_amount += {amount} WHERE wl_id='{result}'";
SqlHelper.ExecuteNonQuery(updateSQL);
}
else
{
//新增记录
string insertSQL = "INSERT INTO work_log(wl_id, wl_type, wl_batch_code, wl_amount, wl_datetime, wl_user_id, wl_segment, wl_object_id) VALUES" +
$"('{Guid.NewGuid().ToString()}', '{type}', '{batchCode}', '{amount}', '{date}', '{userid}', {segment}, '{objectId}')";
SqlHelper.ExecuteNonQuery(insertSQL);
}
}
private void simpleButton1_Click(object sender, System.EventArgs e)
{
object sourceFile = objectName;
object destDiskCode = treeView1.SelectedNode.Tag;
object destFolder = treeView1.SelectedNode.Text;
string queryString = $"确定将光盘({trcCode})下的文件[{sourceFile}]移动到光盘({destDiskCode})的文件夹[{destFolder}]下吗？";
DialogResult dialogResult = DevExpress.XtraEditors.XtraMessageBox.Show(queryString, "确认提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dialogResult == DialogResult.OK)
{
string sourceFilePath = ToolHelper.GetValue(SqlHelper.ExecuteOnlyOneQuery($"SELECT bfi_path+'\\'+bfi_name FROM backup_files_info WHERE bfi_id='{objectId}';"));
string destFolderId = treeView1.SelectedNode.Name;
string destFolderPath = ToolHelper.GetValue(SqlHelper.ExecuteOnlyOneQuery($"SELECT bfi_path+'\\'+bfi_name FROM backup_files_info WHERE bfi_id='{destFolderId}';"));
if (File.Exists(sourceFilePath))
{
string updateSQL = $"UPDATE backup_files_info SET bfi_path='{destFolderPath}', bfi_pid='{destFolderId}', bfi_date='{DateTime.Now}', bfi_userid='{UserHelper.GetUser().UserKey}' WHERE bfi_id='{objectId}'";
SqlHelper.ExecuteNonQuery(updateSQL);
FileInfo file = new FileInfo(sourceFilePath);
if (!Directory.Exists(destFolderPath))
{
Directory.CreateDirectory(destFolderPath);
}
string newDestFilePath = destFolderPath + "\\" + Path.GetFileName(sourceFilePath);
file.CopyTo(newDestFilePath, true);
}
DevExpress.XtraEditors.XtraMessageBox.Show("操作成功");
DialogResult = DialogResult.OK;
Close();
}
}
private void Btn_Sure_Click(object sender, EventArgs e)
{
if (CheckDatas())
{
object primaryKey = Guid.NewGuid().ToString();
if (lbl_FIleName.Tag == null)
{
string code = lbl_Code.Text;
string unit = txt_Unit.Text;
string user = txt_User.Text;
string phone = txt_Phone.Text;
int ftype = cbo_FileType.SelectedIndex;
string bdate = ToolHelper.GetDateValue(txt_Borrow_Date.EditValue, "yyyy-MM-dd HH:mm");
string bterm = txt_Borrow_Term.Text;
string sbdate = ToolHelper.GetDateValue(txt_Should_Return_Date.EditValue, "yyyy-MM-dd");
string loguser = lbl_LogUser.Text;
string remark = txt_Remark.Text;
string insertSQL = "INSERT INTO borrow_log(bl_id, bl_code, bl_file_id, bl_borrow_state, bl_return_state, bl_form, bl_user, bl_user_unit, bl_user_phone, bl_date, bl_term, bl_should_return_term, bl_log_user, bl_remark) " +
$"VALUES ('{primaryKey}', '{code}', '{FILE_ID}', '{1}', '{0}', '{ftype}', '{user}', '{unit}', '{phone}', '{bdate}', '{bterm}', '{sbdate}', '{loguser}', '{remark}')";
SqlHelper.ExecuteNonQuery(insertSQL);
}
else
{
primaryKey = lbl_FIleName.Tag;
string rbdate = ToolHelper.GetDateValue(txt_Real_Return_Date.EditValue, "yyyy-MM-dd HH:mm:dd");
string updateSQL = $"UPDATE borrow_log SET bl_real_return_term='{rbdate}', bl_borrow_state=0, bl_return_state=1 WHERE bl_id='{primaryKey}'";
SqlHelper.ExecuteNonQuery(updateSQL);
}
DevExpress.XtraEditors.XtraMessageBox.Show("操作成功。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
DialogResult = DialogResult.OK;
Tag = primaryKey;
Close();
}
}
/// <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);
}
}
}
private static string GetTrueValue(object value)
{
return(ToolHelper.GetValue(value)
.Replace(",", "，")
.Replace("\n", string.Empty)
.Replace("\t", string.Empty)
.Replace("\r", string.Empty));
}
/// <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>
/// 获取时间对象的DATE格式对象，若转换失败则返回当前时间
/// </summary>
internal static DateTime GetDateValue(object value)
{
string dateStr = ToolHelper.GetValue(value);
if (DateTime.TryParse(dateStr, out DateTime date))
{
return(date);
}
return(new DateTime());
}
/// <summary>
/// 查询唯一结果的SQL(无结果返回null)
/// </summary>
public static object ExecuteOnlyOneQuery(string querySql)
{
SqlCommand sqlCommand = new SqlCommand(querySql, GetConnect());
object result = sqlCommand.ExecuteScalar();
if (result != null)
{
if (string.IsNullOrEmpty(ToolHelper.GetValue(result)))
{
result = null;
}
}
return(result);
}
/// <summary>
/// 重置指定批次下所有数据状态为 未提交
/// </summary>
/// <param name="type">类型<para>1：计划</para><para>2：专项</para></param>
/// <param name="batchIds">批次ID</param>
private void SetStateToUnsubmit(int type, object[] batchIds)
{
string updateSQL = string.Empty;
List <object> projectIds = new List <object>();
if (type == 1)
{
object[] planIds = SqlHelper.ExecuteSingleColumnQuery($"SELECT pi_id FROM project_info WHERE pi_categor=1 AND pi_obj_id IN ({ToolHelper.GetStringBySplit(batchIds, ",", "'")})");
string proQuerySql = "SELECT A.pi_id FROM project_info p LEFT JOIN ( " +
"SELECT pi_id, pi_obj_id FROM project_info WHERE pi_categor=2 UNION ALL " +
"SELECT ti_id, ti_obj_id FROM topic_info WHERE ti_categor=-3)A ON A.pi_obj_id=p.pi_id " +
$"WHERE p.pi_id IN ({ToolHelper.GetStringBySplit(planIds, ",", "'")})";
object[] proIds = SqlHelper.ExecuteSingleColumnQuery(proQuerySql);
projectIds.AddRange(proIds);
}
else if (type == 2)
{
string querySQL = "SELECT idi.imp_id FROM imp_dev_info idi INNER JOIN imp_info ii ON idi.imp_obj_id = ii.imp_id INNER JOIN transfer_registration_pc trp ON ii.imp_obj_id = trp.trp_id " +
$"WHERE trp.trp_id IN({ToolHelper.GetStringBySplit(batchIds, ",", "'")})";
object[] specialIds = SqlHelper.ExecuteSingleColumnQuery(querySQL);
string proQuerySql = "SELECT A.pi_id FROM imp_dev_info idi LEFT JOIN ( " +
"SELECT pi_id, pi_obj_id FROM project_info WHERE pi_categor=2 UNION ALL " +
"SELECT ti_id, ti_obj_id FROM topic_info WHERE ti_categor=-3)A ON A.pi_obj_id=idi.imp_id " +
$"WHERE idi.imp_id IN ({ToolHelper.GetStringBySplit(specialIds, ",", "'")})";
object[] proIds = SqlHelper.ExecuteSingleColumnQuery(proQuerySql);
projectIds.AddRange(proIds);
}
if (projectIds.Count > 0)
{
string pids = ToolHelper.GetStringBySplit(projectIds.ToArray(), ",", "'");
updateSQL +=
$"UPDATE project_info SET pi_submit_status=1, pi_worker_id=null, pi_checker_id=null WHERE pi_id IN ({pids});" +
$"UPDATE topic_info SET ti_submit_status=1, ti_worker_id=null, ti_checker_id=null WHERE ti_id IN ({pids});";
string topQuerySql = "SELECT A.ti_id FROM( " +
"SELECT ti_id, ti_obj_id FROM topic_info WHERE ti_categor = 3 UNION ALL " +
"SELECT si_id, si_obj_id FROM subject_info )A " +
$"WHERE A.ti_obj_id IN({pids})";
object[] topIds = SqlHelper.ExecuteSingleColumnQuery(topQuerySql);
if (topIds.Length > 0)
{
string tids = ToolHelper.GetStringBySplit(topIds, ",", "'");
updateSQL +=
$"UPDATE subject_info SET si_submit_status=1, si_worker_id=null, si_checker_id=null WHERE si_id IN ({tids});" +
$"UPDATE topic_info SET ti_submit_status=1, ti_worker_id=null, ti_checker_id=null WHERE ti_id IN ({tids});" +
$"UPDATE subject_info SET si_submit_status=1, si_worker_id=null, si_checker_id=null WHERE si_obj_id IN ({tids});";
}
}
SqlHelper.ExecuteNonQuery(updateSQL);
}
/// <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);
}
private void SimpleButton1_Click(object sender, System.EventArgs e)
{
List <object> list = new List <object>();
for (int i = 0; i < chkl.CheckedItems.Count; i++)
{
ObjectEntity entity = chkl.CheckedItems[i] as ObjectEntity;
list.Add(entity.ID);
}
if (list.Count > 0)
{
objectCode = ToolHelper.GetStringBySplit(list.ToArray(), ",", "'");
DialogResult = System.Windows.Forms.DialogResult.OK;
}
}
private void Frm_DomRec_Load(object sender, EventArgs e)
{
//来源单位
DataRow row = SqlHelper.ExecuteSingleRowQuery("SELECT dd_name, trp_log_data FROM transfer_registration_pc " +
$"LEFT JOIN data_dictionary ON dd_id = com_id WHERE trp_id = '{trpId}';");
if (row != null)
{
lbl_Body.Text = $" {row["dd_name"]}：\n";
lbl_Body.Text += $" 今中国科学技术信息研究所于{ToolHelper.GetDateValue(row["trp_log_data"], "yyyy年MM月")}收到贵单位提交的 捆纸质档案， 电子档案 件，" +
$"并于{ToolHelper.GetDateValue(DateTime.Now, "yyyy年MM月")}完成确认，" +
$"共计纸质档案 卷，电子档案 件，并附案卷列表（附件一）。 此据。";
}
txt_Head.Focus();
}
private void Btn_Sure_Click(object sender, EventArgs e)
{
SelectedFileId = new string[lsv_Selected.Items.Count];
SelectedFileName = new string[lsv_Selected.Items.Count];
for (int i = 0; i < SelectedFileId.Length; i++)
{
SelectedFileId[i] = lsv_Selected.Items[i].Name;
SelectedFileName[i] = ToolHelper.GetValue(lsv_Selected.Items[i].Tag);
}
if (SelectedFileId.Length > 0)
{
DialogResult = DialogResult.OK;
}
Close();
}
private void OpenFile_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
string ids = ToolHelper.GetFullStringBySplit(GetValue(trcId), ';', ",", "'");
if (string.IsNullOrEmpty(ids))
{
XtraMessageBox.Show("尚未导入文件。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Frm_DiskList diskList = new Frm_DiskList(ids);
if (diskList.ShowDialog() == DialogResult.OK)
{
string querySQL = "SELECT bfi_id FROM backup_files_info A " +
"LEFT JOIN transfer_registraion_cd B ON A.bfi_trcid = B.trc_id " +
$"WHERE bfi_trcid IN({diskList.objectCode}) AND bfi_type = -1 " +
"ORDER BY trc_code";
object[] rootId = SqlHelper.ExecuteSingleColumnQuery(querySQL);
if (rootId.Length == 0)
{
XtraMessageBox.Show("生成文件树失败，请确认当前编号已导入对应电子文件。", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Frm_FileSelect frm = new Frm_FileSelect(rootId);
if (frm.ShowDialog() == DialogResult.OK)
{
string[] fullPath = frm.SelectedFileName;
for (int i = 0; i < fullPath.Length; i++)
{
if (File.Exists(fullPath[i]))
{
if (NotExist(fullPath[i]))
{
AddFileToList(fullPath[i], frm.SelectedFileId[i]);
}
else
{
XtraMessageBox.Show($"{Path.GetFileName(fullPath[i])}文件已存在，不可重复添加。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
else
{
XtraMessageBox.Show($"无法访问指定文件[{Path.GetFileName(fullPath[i])}]", "打开失败", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
}
}
/// <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 void LoadCompanySource()
{
string querySql = "SELECT dd_id, dd_name FROM data_dictionary WHERE dd_pId=" +
"(SELECT dd_id FROM data_dictionary WHERE dd_code = 'dic_key_company_source') ORDER BY dd_sort";
DataTable table = SqlHelper.ExecuteQuery(querySql);
for (int i = 0; i < table.Rows.Count; i++)
{
AccordionControlElement element = new AccordionControlElement()
{
Style = ElementStyle.Item,
Name = ToolHelper.GetValue(table.Rows[i]["dd_id"]),
Text = ToolHelper.GetValue(table.Rows[i]["dd_name"]),
};
acg_Register.Elements.Add(element);
}
}
/// <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);
}
/// <summary>
/// 获取文件相关链接列表
/// </summary>
private object[] GetFileLink()
{
List <object> list = new List <object>();
foreach (DataGridViewRow row in dgv_link.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
string value = ToolHelper.GetValue(cell.Value);
if (!string.IsNullOrEmpty(value))
{
list.Add(value);
}
}
}
return(list.ToArray());
}
private void BatchRecInfo_Load(object sender, EventArgs e)
{
string querySQL = "SELECT C.trp_code, B.real_name, A.wr_source_id, A.wr_date FROM work_registration A " +
"LEFT JOIN user_list B ON B.ul_id = A.wr_source_id " +
"LEFT JOIN transfer_registration_pc C on A.trp_id = C.trp_id " +
$"WHERE A.trp_id = '{TRP_ID}' ORDER BY A.wr_date ";
DataTable table = SqlHelper.ExecuteQuery(querySQL);
foreach (DataRow row in table.Rows)
{
int i = view.Rows.Add();
view.Rows[i].Cells[0].Value = row["trp_code"];
view.Rows[i].Cells[1].Value = ToolHelper.GetDateValue(row["wr_date"], "yyyy-MM-dd HH:mm");
view.Rows[i].Cells[2].Value = row["real_name"];
view.Rows[i].Cells[3].Value = GetWorkAmount(TRP_ID, row["wr_source_id"]);
}
}
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);
}
}
/// <summary>
/// 获取完整的封面HTML模板页
/// </summary>
/// <param name="bj">边距mm数</param>
private string GetCoverHtmlString(object docName, string fmString, object bj, object GCNumber)
{
fmString = fmString.Replace("20mm", $"{bj}");
if (string.IsNullOrEmpty(ToolHelper.GetValue(parentObjectName)))
{
fmString = fmString.Replace("id=\"ajmc\">", $"id=\"ajmc\">{docName}");
}
else
{
fmString = fmString.Replace("id=\"ajmc\">", $"id=\"ajmc\">{parentObjectName}");
fmString = fmString.Replace("id=\"ktmc\">", $"id=\"ktmc\">{docName}");
}
fmString = fmString.Replace("id=\"bzdw\">", $"id=\"bzdw\">{unitName}");
fmString = fmString.Replace("id=\"bzrq\">", $"id=\"bzrq\">{ToolHelper.GetDateValue(ljDate, "yyyy-MM-dd")}");
fmString = fmString.Replace("id=\"bgqx\">", $"id=\"bgqx\">永久");
fmString = fmString.Replace("id=\"gch\">", $"id=\"gch\">{GCNumber}");
return(fmString);
}
private void LoadDiskList(object trpID, object trcCode)
{
object batchCode = SqlHelper.ExecuteOnlyOneQuery($"SELECT trp_name+'['+ trp_code+']' FROM transfer_registration_pc WHERE trp_id='{trpID}';");
TreeNode batchNode = new TreeNode(ToolHelper.GetValue(batchCode))
{
ImageIndex = 0
};
treeView1.Nodes.Add(batchNode);
string querySQL = $"SELECT A.bfi_id, B.trc_code, B.trc_name FROM backup_files_info A LEFT JOIN transfer_registraion_cd B ON A.bfi_trcid = B.trc_id " +
$"WHERE B.trp_id ='{trpID}' AND A.bfi_type = -1 ORDER BY b.trc_code";
DataTable table = SqlHelper.ExecuteQuery(querySQL);
foreach (DataRow row in table.Rows)
{
TreeNode diskNode = new TreeNode()
{
Name = ToolHelper.GetValue(row["bfi_id"]),
Text = $"{row["trc_name"]}[{row["trc_code"]}]",
ImageIndex = 1,
Tag = row["trc_code"]
};
batchNode.Nodes.Add(diskNode);
string _querySQL = $"SELECT bfi_id, bfi_name FROM backup_files_info WHERE bfi_pid ='{row["bfi_id"]}' AND bfi_type = 1 ORDER BY bfi_path";
DataTable _table = SqlHelper.ExecuteQuery(_querySQL);
foreach (DataRow _row in _table.Rows)
{
TreeNode folderNode = new TreeNode()
{
Name = ToolHelper.GetValue(_row["bfi_id"]),
Text = $"{_row["bfi_name"]}",
ImageIndex = 1,
Tag = row["trc_code"]
};
diskNode.Nodes.Add(folderNode);
}
}
if (treeView1.Nodes.Count > 0)
{
treeView1.ExpandAll();
}
}
private void Frm_QueryDetail_Load(object sender, System.EventArgs e)
{
txt_Project_Code.Text = ToolHelper.GetValue(row["pi_code"]);
txt_Project_Name.Text = ToolHelper.GetValue(row["pi_name"]);
txt_Project_Field.Text = ToolHelper.GetValue(row["pi_field"]);
txt_Project_Theme.Text = ToolHelper.GetValue(row["pb_theme"]);
txt_Project_StartTime.Text = ToolHelper.GetValue(row["pi_start_datetime"]);
txt_Project_EndTime.Text = ToolHelper.GetValue(row["pi_end_datetime"]);
txt_Project_Unit.Text = ToolHelper.GetValue(row["pi_unit"]);
txt_Project_Province.Text = ToolHelper.GetValue(row["pi_province"]);
txt_Project_ProUser.Text = ToolHelper.GetValue(row["pi_prouser"]);
txt_Project_Funds.Text = ToolHelper.GetValue(row["pi_funds"]);
txt_Project_Year.Text = ToolHelper.GetValue(row["pi_year"]);
txt_Project_UnitUser.Text = ToolHelper.GetValue(row["pi_uniter"]);
txt_Project_Intro.Text = ToolHelper.GetValue(row["pi_intro"]);
txt_Project_Intro.SelectionStart = 0;
Btn_Close.Focus();
}
//查询
private void UG_btnSearch(object sender, EventArgs e)
{
string key = userGroup_SearchKey.Text;
if (!string.IsNullOrEmpty(key))
{
view.ClearSelection();
foreach (DataGridViewRow row in view.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
if (ToolHelper.GetValue(cell.Value).Contains(key))
{
cell.Selected = true;
return;
}
}
}
}
}
/// <summary>
/// 判断指定文件夹节点下的所有文件是否全部已加工，如果是，则移除此文件夹
/// </summary>
private bool ClearHasWordedWithFolder(TreeNode node)
{
bool result = true;
bool flag = true;
for (int i = 0; i < node.Nodes.Count; i++)
{
TreeNode item = node.Nodes[i];
int type = Convert.ToInt32(item.ToolTipText);//0:文件 1:文件夹
if (type == 0)
{
flag = false;
}
else if (type == 1)
{
result = ClearHasWordedWithFolder(item);
}
}
if (result)
{
foreach (TreeNode item in node.Nodes)
{
int type = Convert.ToInt32(item.ToolTipText); //0:文件 1:文件夹
int state = item.ImageIndex; //3:已加工
if (type == 0 && state != 3)
{
result = false;
break;
}
}
}
if (result && flag)
{
if (!string.IsNullOrEmpty(ToolHelper.GetValue(node.Tag)))//批次名称永不消逝
{
node.Remove();
}
}
return(result);
}
/// <summary>
/// 加载根节点树（调用树节点方法）
/// </summary>
/// <param name="isShowAll">是否显示已加工节点</param>
private void LoadRootTree(bool isShowAll)
{
object batchCode = SqlHelper.ExecuteOnlyOneQuery($"SELECT bfi_name FROM backup_files_info WHERE bfi_id='{rootId[0]}'");
tv_file.Nodes.Clear();
//一级节点【批次编号】
TreeNode batchNode = new TreeNode()
{
Text = ToolHelper.GetValue(batchCode),
ToolTipText = "-1",
};
tv_file.Nodes.Add(batchNode);
for (int i = 0; i < rootId.Length; i++)
{
object[] objs = SqlHelper.ExecuteRowsQuery("SELECT bfi_id, bfi_name, bfi_path, bfi_type, trc_code FROM backup_files_info a " +
$"LEFT JOIN transfer_registraion_cd b on a.bfi_trcid = b.trc_id WHERE bfi_id='{rootId[i]}'");
//二级节点【光盘编号】
string rootFileName = ToolHelper.GetValue(objs[4]);
TreeNode diskNode = new TreeNode()
{
Text = rootFileName,
ToolTipText = ToolHelper.GetValue(objs[3]),
};
batchNode.Nodes.Add(diskNode);
InitialTree(rootId[i], diskNode, isShowAll);
}
if (tv_file.Nodes.Count > 0)
{
tv_file.Nodes[0].Expand();
if (!chk_ShowAll.Checked)
{
ClearHasWordedWithFolder(tv_file.Nodes[0]);
}
if (IsMoveMode)
{
tv_file.ExpandAll();
}
}
}
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>
/// 根据指定批次ID获取其补录的其他批次根节点ID
/// </summary>
/// <param name="batchId">待查找批次ID</param>
/// <param name="type">查找类型<para>0：计划</para><para>1：专项</para></param>
public static object[] GetOtherBatchRootIds(object batchId, int type)
{
object otherBatchIds = ExecuteOnlyOneQuery($"SELECT br_auxiliary_id FROM batch_relevance WHERE br_main_id='{batchId}'");
string otherBatchIdString = ToolHelper.GetFullStringBySplit(ToolHelper.GetValue(otherBatchIds), ',', ",", "'");
if (otherBatchIdString.Length > 0)
{
if (type == 0)
{
string querySql = $"SELECT pi_id FROM project_info WHERE pi_categor = 1 AND pi_obj_id IN ({otherBatchIdString})";
return(ExecuteSingleColumnQuery(querySql));
}
else
{
string querySql = "SELECT idi.imp_id FROM imp_info ii " +
"INNER JOIN imp_dev_info idi ON idi.imp_obj_id = ii.imp_id " +
$"WHERE ii.imp_obj_id IN ({otherBatchIdString})";
return(ExecuteSingleColumnQuery(querySql));
}
}
return(null);
}