/// <summary> /// 课题列表 /// </summary> /// <param name="pid">项目ID</param> private bool LoadTopicList(object pid, object parentObjName) { dgv_ShowData.Rows.Clear(); dgv_ShowData.Columns.Clear(); dgv_ShowData.Columns.AddRange(new DataGridViewColumn[] { new DataGridViewTextBoxColumn() { Name = "top_id", HeaderText = "序号", FillWeight = 3 }, new DataGridViewTextBoxColumn() { Name = "top_code", HeaderText = "编号", FillWeight = 8 }, new DataGridViewTextBoxColumn() { Name = "top_name", HeaderText = "名称", FillWeight = 10 }, new DataGridViewTextBoxColumn() { Name = "top_unit", HeaderText = "承担单位", FillWeight = 8 }, new DataGridViewTextBoxColumn() { Name = "top_user", HeaderText = "负责人", FillWeight = 5 }, new DataGridViewTextBoxColumn() { Name = "top_phone", HeaderText = "手机", FillWeight = 4 }, new DataGridViewLinkColumn() { Name = "top_totalFileAmount", HeaderText = "总文件数", FillWeight = 3 }, new DataGridViewLinkColumn() { Name = "top_lostFileAmount", HeaderText = "必备文件缺失数", FillWeight = 5 }, new DataGridViewLinkColumn() { Name = "top_subjectAmount", HeaderText = "子课题数", FillWeight = 4 }, }); DataTable topicTable = SQLiteHelper.ExecuteQuery($"SELECT * FROM topic_info WHERE ti_obj_id='{pid}'"); for (int i = 0; i < topicTable.Rows.Count; i++) { int index = dgv_ShowData.Rows.Add(); dgv_ShowData.Rows[index].Tag = topicTable.Rows[i]["ti_id"]; dgv_ShowData.Rows[index].Cells["top_id"].Value = i + 1; dgv_ShowData.Rows[index].Cells["top_code"].Value = topicTable.Rows[i]["ti_code"]; dgv_ShowData.Rows[index].Cells["top_name"].Value = topicTable.Rows[i]["ti_name"]; dgv_ShowData.Rows[index].Cells["top_unit"].Value = topicTable.Rows[i]["ti_unit"]; dgv_ShowData.Rows[index].Cells["top_user"].Value = topicTable.Rows[i]["ti_contacts"]; dgv_ShowData.Rows[index].Cells["top_phone"].Value = topicTable.Rows[i]["ti_contacts_phone"]; dgv_ShowData.Rows[index].Cells["top_totalFileAmount"].Value = GetFileAmount(topicTable.Rows[i]["ti_id"]); dgv_ShowData.Rows[index].Cells["top_lostFileAmount"].Value = GetLostFileAmount(topicTable.Rows[i]["ti_id"]); dgv_ShowData.Rows[index].Cells["top_subjectAmount"].Value = GetSubjectAmount(topicTable.Rows[i]["ti_id"]); } dgv_ShowData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dgv_ShowData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DataGridViewStyleHelper.SetAlignWithCenter(dgv_ShowData, new string[] { "top_id", "top_totalFileAmount", "top_subjectAmount", "top_lostFileAmount" }); btn_Query.Tag = "TOPIC"; lbl_position.Text = parentObjName != null ? $"{UserHelper.GetUser().SpecialName} >> {parentObjName}" : lbl_position.Text; return(topicTable.Rows.Count == 0 ? false : true); }
private void btn_Sure_Click(object sender, EventArgs e) { object id = cbo_ChooseIdentity.SelectedValue; string name = cbo_ChooseIdentity.Text; string depName = txt_Unit.Text; if (string.IsNullOrEmpty(depName)) { new ErrorProvider().SetError(txt_Unit, "提示:单位名称不能为空。"); } else if (MessageBox.Show($"选择后不可修改,确定是属于{name}吗?", "确认提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes) { SQLiteHelper.ExecuteNonQuery($"UPDATE user_info SET ui_department='{depName}', ui_special_id='{id}' WHERE ui_id='{UserHelper.GetUser().UserId}'"); DialogResult = DialogResult.OK; Close(); } }
/// <summary> /// 项目列表 /// </summary> /// <param name="spid">专项ID</param> private void LoadProjectList(object spid) { dgv_ShowData.Rows.Clear(); dgv_ShowData.Columns.Clear(); dgv_ShowData.Columns.AddRange(new DataGridViewColumn[] { new DataGridViewTextBoxColumn() { Name = "pro_id", HeaderText = "序号", FillWeight = 3 }, new DataGridViewTextBoxColumn() { Name = "pro_code", HeaderText = "编号", FillWeight = 8 }, new DataGridViewTextBoxColumn() { Name = "pro_name", HeaderText = "名称", FillWeight = 10 }, new DataGridViewTextBoxColumn() { Name = "pro_unit", HeaderText = "承担单位", FillWeight = 8 }, new DataGridViewTextBoxColumn() { Name = "pro_user", HeaderText = "负责人", FillWeight = 5 }, new DataGridViewTextBoxColumn() { Name = "pro_phone", HeaderText = "手机", FillWeight = 4 }, new DataGridViewLinkColumn() { Name = "pro_totalFileAmount", HeaderText = "总文件数", FillWeight = 3 }, new DataGridViewLinkColumn() { Name = "pro_lostFileAmount", HeaderText = "必备文件缺失数", FillWeight = 5 }, new DataGridViewLinkColumn() { Name = "pro_topicAmount", HeaderText = "课题/子课题数", FillWeight = 4 }, }); DataTable projectTable = SQLiteHelper.ExecuteQuery($"SELECT * FROM project_info WHERE pi_obj_id='{spid}'"); for (int i = 0; i < projectTable.Rows.Count; i++) { int index = dgv_ShowData.Rows.Add(); dgv_ShowData.Rows[index].Tag = projectTable.Rows[i]["pi_id"]; dgv_ShowData.Rows[index].Cells["pro_id"].Value = index + 1; dgv_ShowData.Rows[index].Cells["pro_code"].Value = projectTable.Rows[i]["pi_code"]; dgv_ShowData.Rows[index].Cells["pro_name"].Value = projectTable.Rows[i]["pi_name"]; dgv_ShowData.Rows[index].Cells["pro_unit"].Value = projectTable.Rows[i]["pi_unit"]; dgv_ShowData.Rows[index].Cells["pro_user"].Value = projectTable.Rows[i]["pi_contacts"]; dgv_ShowData.Rows[index].Cells["pro_phone"].Value = projectTable.Rows[i]["pi_contacts_phone"]; dgv_ShowData.Rows[index].Cells["pro_totalFileAmount"].Value = GetFileAmount(projectTable.Rows[i]["pi_id"]); dgv_ShowData.Rows[index].Cells["pro_lostFileAmount"].Value = GetLostFileAmount(projectTable.Rows[i]["pi_id"]); dgv_ShowData.Rows[index].Cells["pro_topicAmount"].Value = GetTopicAmount(projectTable.Rows[i]["pi_id"]); } DataTable topicTable = SQLiteHelper.ExecuteQuery($"SELECT * FROM topic_info WHERE ti_obj_id='{spid}'"); for (int i = 0; i < topicTable.Rows.Count; i++) { int index = dgv_ShowData.Rows.Add(); dgv_ShowData.Rows[index].Tag = topicTable.Rows[i]["ti_id"]; dgv_ShowData.Rows[index].Cells["pro_id"].Value = index + 1; dgv_ShowData.Rows[index].Cells["pro_code"].Value = topicTable.Rows[i]["ti_code"]; dgv_ShowData.Rows[index].Cells["pro_name"].Value = topicTable.Rows[i]["ti_name"]; dgv_ShowData.Rows[index].Cells["pro_unit"].Value = topicTable.Rows[i]["ti_unit"]; dgv_ShowData.Rows[index].Cells["pro_user"].Value = topicTable.Rows[i]["ti_contacts"]; dgv_ShowData.Rows[index].Cells["pro_phone"].Value = topicTable.Rows[i]["ti_contacts_phone"]; dgv_ShowData.Rows[index].Cells["pro_totalFileAmount"].Value = GetFileAmount(topicTable.Rows[i]["ti_id"]); dgv_ShowData.Rows[index].Cells["pro_lostFileAmount"].Value = GetLostFileAmount(topicTable.Rows[i]["ti_id"]); dgv_ShowData.Rows[index].Cells["pro_topicAmount"].Value = GetSubjectAmount(topicTable.Rows[i]["ti_id"]); } dgv_ShowData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dgv_ShowData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DataGridViewStyleHelper.SetAlignWithCenter(dgv_ShowData, new string[] { "pro_id", "pro_totalFileAmount", "pro_topicAmount", "pro_lostFileAmount" }); btn_Query.Tag = "PROJECT"; lbl_position.Text = $"{UserHelper.GetUser().SpecialName}"; }