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 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"]);
}
}
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();
}
}
/// <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 = "确认归还";
}
}
}
}
}
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 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"]);
}
}
/// <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>
/// 获取完整的封面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 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>
/// 备考表
/// </summary>
private string GetBackupTable(object boxId, object docCode, int boxNumber)
{
string bkbString = Resources.bkb;
string fa = MicrosoftWordHelper.GetZN(GetFilePageCount(boxId, 1));
int _fp = GetFilePageCount(boxId, 2);
string fp = _fp == 0 ? string.Empty : MicrosoftWordHelper.GetZN(_fp);
string hh = MicrosoftWordHelper.GetZN(boxNumber);
bkbString = bkbString.Replace("name=\"count\"", $"name=\"count\" value=\"{fa}\"");
bkbString = bkbString.Replace("name=\"pages\"", $"name=\"pages\" value=\"{fp}\"");
bkbString = bkbString.Replace("name=\"number\"", $"name=\"number\" value=\"{hh}\"");
string newTr = string.Empty;
if (otherDoc.Rows.Count > 0)
{
foreach (DataRow row in otherDoc.Rows)
{
newTr += $"<tr><td>{row["od_name"]}</td>" +
$"<td>{row["od_code"]}</td>" +
$"<td>{row["od_carrier"]}</td>" +
$"<td>{row["od_intro"]}</td></tr>";
}
}
else
{
newTr = "<tr><td> </td><td> </td><td> </td><td> </td></tr>" +
"<tr><td> </td><td> </td><td> </td><td> </td></tr>";
}
bkbString = bkbString.Replace("</tbody>", $"{newTr}</tbody>");
bkbString = bkbString.Replace("id=\"dh\">", $"id=\"dh\">{docCode}");
bkbString = bkbString.Replace("id=\"ljr\">", $"id=\"dh\">{ljPeople}");
bkbString = bkbString.Replace("id=\"ljrq\">", $"id=\"dh\">{ToolHelper.GetDateValue(ljDate, "yyyy-MM-dd")}");
bkbString = bkbString.Replace("id=\"jcr\">", $"id=\"jcr\">{jcPeople}");
bkbString = bkbString.Replace("id=\"jcrq\">", $"id=\"jcrq\">{ToolHelper.GetDateValue(jcDate, "yyyy-MM-dd")}");
return(bkbString);
}