/// <summary> /// 添加工作记录 /// </summary> /// <param name="logType">记录类别</param> /// <param name="amount">数量</param> /// <param name="batchCode">批次编号</param> /// <param name="segment">环节<para>1:加工</para><para>2:质检</para></param> public static void AddWorkLog(WorkLogType logType, int amount, object batchCode, int segment, object objectId) { if (string.IsNullOrEmpty(ToolHelper.GetValue(batchCode))) { return; } string date = ToolHelper.GetDateValue(DateTime.Now, "yyyy-MM-dd"); string userid = UserHelper.GetUser().UserKey; 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); } }
/// <summary> /// 根据指定角色获取模块名称 /// </summary> public static object[] GetModelByRole() { string querySQL = "SELECT m_name FROM module " + "LEFT JOIN data_dictionary ON dd_id = m_code " + $"WHERE dd_id = '{UserHelper.GetUser().Role}'"; return(SqlHelper.ExecuteSingleColumnQuery(querySQL)); }
private void InitalForm() { //当前登录人信息 txt_RealName.Text = UserHelper.GetUser().RealName; subForm.MdiParent = this; subForm.WindowState = FormWindowState.Maximized; subForm.Show(); }
private void Frm_BorrowEdit_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(lbl_Code.Text)) { lbl_Code.Text = GetCode(); } if (string.IsNullOrEmpty(lbl_LogUser.Text)) { lbl_LogUser.Text = UserHelper.GetUser().RealName; } }
private void Demo_Click(object sender, EventArgs e) { foreach (Form item in MdiChildren) { item.Close(); } string element = (sender as AccordionControlElement).Name; //编码规则 if ("ace_CodeRule".Equals(element)) { Frm_CodeRule frm = new Frm_CodeRule(UserHelper.GetUser().UserKey); frm.MdiParent = this; frm.Show(); } }
/// <summary> /// 保存光盘列表信息 /// </summary> /// <param name="trpId">批次主键</param> private void SaveCDList(object trpId) { for (int i = 0; i < dgv_CDlist.RowCount - 1; i++) { object cdName = dgv_CDlist.Rows[i].Cells["gpmc"].Value; object cdCode = dgv_CDlist.Rows[i].Cells["gpbh"].Value; object cdRemark = GetString(dgv_CDlist.Rows[i].Cells["bz"].Value); StringBuilder cdInfo_querySql = new StringBuilder("INSERT INTO transfer_registraion_cd "); cdInfo_querySql.Append("(trc_id,trc_name,trc_code,trp_id,trc_remark,trc_status,trc_complete_status,trc_people,trc_handle_time, trc_sort)"); cdInfo_querySql.Append(" VALUES("); cdInfo_querySql.Append("'" + Guid.NewGuid().ToString() + "',"); cdInfo_querySql.Append("'" + cdName + "',"); cdInfo_querySql.Append("'" + cdCode + "',"); cdInfo_querySql.Append("'" + trpId + "',"); cdInfo_querySql.Append("'" + cdRemark + "',"); cdInfo_querySql.Append("'" + (int)ReadStatus.NonRead + "',"); cdInfo_querySql.Append("'" + (int)WorkStatus.NonWork + "',"); cdInfo_querySql.Append("'" + UserHelper.GetUser().UserKey + "',"); cdInfo_querySql.Append("'" + DateTime.Now + "', '" + i + "')"); SqlHelper.ExecuteNonQuery(cdInfo_querySql.ToString()); } }
/// <summary> /// 根据指定的对象ID和类型获取意见 /// </summary> /// <param name="id">主键</param> /// <param name="type">类型</param> /// <returns> /// 对象数组:[0]主键[1]名称 /// </returns> private object[] GetAdvice(object id, int type) { object[] _obj = SqlHelper.ExecuteRowsQuery($"SELECT qa_id, qa_advice FROM quality_advices WHERE qa_obj_id='{id}' AND qa_user='******' AND qa_type={type}"); return(_obj ?? null); }
private void Btn_Upload_Click(object sender, EventArgs e) { if (UserHelper.GetUserRole() != UserRole.DocManager) { XtraMessageBox.Show("仅档案管理员可以上传文件。", "提示"); return; } Frm_UploadFile uploadFile = new Frm_UploadFile(); if (uploadFile.ShowDialog() == DialogResult.OK) { string filePath = uploadFile.txt_filePath.Text; string fileName = uploadFile.txt_fileName.Text; string fileCode = uploadFile.txt_fileCode.Text; string fileVersion = uploadFile.txt_fileVersion.Text; int fileType = uploadFile.cbo_fileType.SelectedIndex; progressBar.Visible = true; progressBar.Properties.Stopped = false; progressBar.Text = "正在上传文件..."; new Thread(delegate() { string insertSQL = string.Empty; SqlConnection con = SqlHelper.GetConnect(); FileInfo info = new FileInfo(filePath); string primaryKey = Guid.NewGuid().ToString(); insertSQL += "INSERT INTO Attachment(at_id, at_name, at_size, at_date, at_uploader, at_entity, at_version, at_type, at_code) " + $"VALUES ('{primaryKey}' ,'{fileName}' ,'{(float)(info.Length / 1024f)}' ,'{DateTime.Now}' ,'{UserHelper.GetUser().UserKey}', @fileByte, '{fileVersion}', {fileType}, '{fileCode}');"; byte[] fileByte = GetByteFromFile(info); SqlCommand com = new SqlCommand(insertSQL, con); com.Parameters.Add("@fileByte", SqlDbType.Image, fileByte.Length); com.Parameters["@fileByte"].Value = fileByte; com.ExecuteNonQuery(); progressBar.Properties.Stopped = true; progressBar.Text = "文件上传成功。"; }).Start(); } }
/// <summary> /// 添加信息到指定表格 /// </summary> private void SaveFileInfo(bool isAdd) { bool isOtherType = cbo_categor.SelectedIndex == -1; object primaryKey = Guid.NewGuid().ToString(); object stage = cbo_stage.SelectedValue; object categor = cbo_categor.SelectedValue ?? cbo_categor.Tag; object categorName = isOtherType ? cbo_categor.Text.Split('-')[1].Trim() : null; object code = txt_fileCode.Text; object name = txt_fileName.Text.Replace("'", "''"); object user = txt_User.Text; object type = GetRadioValue(pal_type); object pages = num_Pages.Value; object count = num_Count.Value; object amount = num_Amount.Value; object date = txt_date.Text; object unit = txt_Unit.Text; object carrier = GetCarrierValue(); object link = GetFullStringBySplit(GetLinkList(2), ";", string.Empty); string _fileId = GetFullStringBySplit(GetLinkList(1), ",", "'"); object remark = txt_Remark.Text; object[] flink = GetFileLink(); if (isAdd) { if (isOtherType) { categor = Guid.NewGuid().ToString(); object pid = cbo_stage.SelectedValue; string value = txt_fileCode.Text.Split('-')[0]; int sort = cbo_categor.Items.Count - 1; object dicId = SqlHelper.ExecuteOnlyOneQuery($"SELECT dd_id FROM data_dictionary WHERE dd_name='{value}' AND dd_pId='{pid}'"); string sqlString = string.Empty; if (dicId != null) { categor = dicId; sqlString += $"DELETE FROM data_dictionary WHERE dd_name='{value}' AND dd_pId='{stage}';"; } sqlString += "INSERT INTO data_dictionary (dd_id, dd_name, dd_note, dd_pId, dd_sort, extend_3, extend_4) " + $"VALUES('{categor}', '{value}', '{name}', '{pid}', '{sort}', '{categorName}', '{1}');"; SqlHelper.ExecuteNonQuery(sqlString); } StringBuilder insertSql = new StringBuilder(); insertSql.Append("INSERT INTO processing_file_list (pfl_id, pfl_stage, pfl_categor, pfl_code, pfl_name, pfl_user, pfl_type, pfl_pages, pfl_count, pfl_amount, pfl_date, pfl_unit, pfl_carrier, pfl_link, pfl_file_id, pfl_obj_id, pfl_status, pfl_sort, pfl_remark, pfl_worker_id, pfl_worker_date) " + $"VALUES( '{primaryKey}', '{stage}', '{categor}', '{code}', '{name}', '{user}', '{type}', '{pages}', '{count}', '{amount}', '{date}', '{unit}', '{carrier}', '{link}', '{GetFullStringBySplit(GetLinkList(1), ",", string.Empty)}', '{parentId}', -1, '{view.RowCount}', '{remark}', '{UserHelper.GetUser().UserKey}', '{DateTime.Now}');"); //将备份表中的文件标记为已选取 if (!string.IsNullOrEmpty(_fileId)) { insertSql.Append($"UPDATE backup_files_info SET bfi_state=1 WHERE bfi_id IN ({_fileId});"); } foreach (object item in flink) { insertSql.Append($"INSERT INTO file_link(id, code, fid) VALUES('{Guid.NewGuid().ToString()}', '{item}', '{primaryKey}');"); } SqlHelper.ExecuteNonQuery(insertSql.ToString()); LogsHelper.AddWorkLog(WorkLogType.File, 1, BATCH_ID, 1, primaryKey); } else { string oldFileId = GetValue(SqlHelper.ExecuteOnlyOneQuery($"SELECT pfl_file_id FROM processing_file_list WHERE pfl_id='{fileId}';")); StringBuilder updateSql = new StringBuilder(); if (!string.IsNullOrEmpty(oldFileId)) { updateSql.Append($"UPDATE backup_files_info SET bfi_state=0 WHERE bfi_id IN ({ToolHelper.GetFullStringBySplit(oldFileId, ',', ",", "'")});"); } updateSql.Append("UPDATE processing_file_list SET " + $"[pfl_stage] = '{stage}'" + $",[pfl_categor] = '{categor}'" + $",[pfl_code] = '{code}'" + $",[pfl_name] = '{name}'" + $",[pfl_user] = '{user}'" + $",[pfl_type] = '{type}'" + $",[pfl_pages] = '{pages}'" + $",[pfl_count] = '{count}'" + $",[pfl_amount] = '{amount}'" + $",[pfl_date] = '{date}'" + $",[pfl_unit] = '{unit}'" + $",[pfl_carrier] = '{carrier}'" + $",[pfl_link] = '{link}'" + $",[pfl_remark] = '{remark}'" + $",[pfl_file_id] = '{GetFullStringBySplit(GetLinkList(1), ",", string.Empty)}'" + $" WHERE pfl_id= '{fileId}';"); if (!string.IsNullOrEmpty(_fileId)) { updateSql.Append($"UPDATE backup_files_info SET bfi_state=1 WHERE bfi_id IN ({_fileId});"); } updateSql.Append($"DELETE FROM file_link WHERE fid='{fileId}';"); foreach (object item in flink) { updateSql.Append($"INSERT INTO file_link(id, code, fid) VALUES('{Guid.NewGuid().ToString()}', '{item}', '{fileId}');"); } SqlHelper.ExecuteNonQuery(updateSql.ToString()); } XtraMessageBox.Show("操作成功。", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); UpdateDataSource?.Invoke(view, parentId, -1); }
private void Btn_Sure_Click(object sender, EventArgs e) { object planCode = SqlHelper.ExecuteOnlyOneQuery($"SELECT dd_code FROM data_dictionary WHERE dd_id='{cbo_TypeSelect.SelectedValue}'"); object planName = cbo_TypeSelect.Text; bool isSpecial = pal_Special.Enabled;//是否是专项 if (listbox.SelectedItems.Count > 0) { string queryString = $"是否确定要补录选中的{listbox.SelectedItems.Count}个批次?"; if (XtraMessageBox.Show(queryString, "确认提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes) { StringBuilder sb = new StringBuilder($"DELETE FROM batch_relevance WHERE br_main_id='{batchId}';"); List <object> batchIds = new List <object>(); foreach (object item in listbox.SelectedItems) { SelectEntity entity = (SelectEntity)item; batchIds.Add(entity.batchId); } sb.Append($"INSERT INTO batch_relevance(br_id, br_main_id, br_auxiliary_id, br_type) " + $"VALUES('{Guid.NewGuid().ToString()}', '{batchId}', '{string.Join(",", batchIds.ToArray())}', {(isSpecial ? 2 : 1)});"); if (isSpecial) { string primaryKey = Guid.NewGuid().ToString(); string subPriKey = Guid.NewGuid().ToString(); object speCode = SqlHelper.GetValueByKey(cbo_SpecialType.SelectedValue, "dd_code"); object speName = SqlHelper.GetValueByKey(cbo_SpecialType.SelectedValue, "dd_name"); //重大专项 sb.Append("INSERT INTO imp_info(imp_id, imp_code, imp_name, pi_categor, imp_submit_status, imp_obj_id, imp_source_id, imp_type) " + $"VALUES ('{primaryKey}', 'ZX', '国家重大专项', 5, 1, '{batchId}', '{UserHelper.GetUser().UserKey}', 5);"); //专项 sb.Append("INSERT INTO imp_dev_info(imp_id, imp_code, imp_name, pi_categor, imp_submit_status, imp_obj_id, imp_source_id) " + $"VALUES ('{subPriKey}', '{speCode}', '{speName}', 6, 1, '{primaryKey}', '{UserHelper.GetUser().UserKey}');"); } else { string primaryKey = Guid.NewGuid().ToString(); sb.Append("INSERT INTO project_info (pi_id, pi_code, pi_name, pi_obj_id, pi_categor, pi_submit_status, pi_source_id, pi_orga_id, pi_worker_id, pi_worker_date) VALUES" + $"('{primaryKey}', '{planCode}', '{planName}', '{batchId}', 1, 1, '{planCode}', '{unitCode}', '{UserHelper.GetUser().UserKey}', '{DateTime.Now}');"); } SetStateToUnsubmit(isSpecial ? 2 : 1, batchIds.ToArray()); SqlHelper.ExecuteNonQuery(sb.ToString()); XtraMessageBox.Show("操作成功,请重新进入。", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); Close(); } return; } Hide(); WorkType _type = WorkType.Default; ControlType _ctype = ControlType.Default; if ("ZX".Equals(planCode)) { if (workType == WorkType.PaperWork) { _type = WorkType.PaperWork_Imp; } else if (workType == WorkType.CDWork) { _type = WorkType.CDWork_Imp; } _ctype = ControlType.Imp; } //else if("YF".Equals(obj)) //{ // if(workType == WorkType.PaperWork) // _type = WorkType.PaperWork_Special; // else if(workType == WorkType.CDWork) // _type = WorkType.CDWork_Special; // _ctype = ControlType.Special; //} else { if (workType == WorkType.PaperWork) { _type = WorkType.PaperWork_Plan; } else if (workType == WorkType.CDWork) { _type = WorkType.CDWork_Plan; } _ctype = ControlType.Plan; } if (_type != WorkType.Default) { Frm_MyWork frm = new Frm_MyWork(_type, cbo_TypeSelect.SelectedValue, objId, _ctype, false); frm.planCode = planCode; frm.unitCode = unitCode; frm.trcId = batchId; frm.Show(); } }
private void Dgv_DataShow_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1 && e.ColumnIndex != -1) { string columnName = dgv_DataShow.Columns[e.ColumnIndex].Name; if ("control".Equals(columnName)) { if (MessageBox.Show("本批次完结,请线下发送确认函和文件清单。", "温馨提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK) { object trpId = dgv_DataShow.Rows[e.RowIndex].Cells["id"].Value; SqlHelper.ExecuteNonQuery($"UPDATE transfer_registration_pc SET trp_complete_status='{(int)SubmitStatus.Completed}', trp_complete_user='******' WHERE trp_id='{trpId}'"); LoadDataGridView(string.Empty); } } else if ("file".Equals(columnName)) { object value = dgv_DataShow.Rows[e.RowIndex].Cells[e.ColumnIndex].Value; object trpId = dgv_DataShow.Rows[e.RowIndex].Cells["id"].Value; if ("齐备".Equals(value)) { Frm_Print frm = GetFormHelper.GetPrintDoc(this, 1, trpId); frm.Show(); frm.Activate(); } else { Frm_Print frm = GetFormHelper.GetPrintDoc(this, 2, trpId); frm.Show(); frm.Activate(); } } } }
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_Save_Click(object sender, EventArgs e) { if (cbo_Type.Tag == null) { cbo_Type.Tag = Guid.NewGuid().ToString(); object type = cbo_Type.SelectedIndex; object symbol = txt_Mdi.Text; object[] values = lbl_Template.Text.Split(txt_Mdi.Text.ToCharArray()); string insertSql = "INSERT INTO code_rule(cr_id, cr_type, cr_fixed, "; for (int i = 0; i < values.Length; i++) { insertSql += $"cr_param_{i + 1},"; } insertSql += $" cr_split_symbol, cr_template, cr_create_date, cr_special_id) VALUES ('{cbo_Type.Tag}', '{type}', '{txt_Fixed.Text}', "; for (int i = 0; i < values.Length; i++) { insertSql += $"'{values[i]}', "; } insertSql += $"'{symbol}', '{lbl_Template.Text}', '{DateTime.Now}', '{UserHelper.GetUser().UserKey}')"; SqlHelper.ExecuteNonQuery(insertSql); DevExpress.XtraEditors.XtraMessageBox.Show("保存成功。"); } else { SqlHelper.ExecuteNonQuery($"DELETE FROM code_rule WHERE cr_id='{cbo_Type.Tag}'"); cbo_Type.Tag = null; Btn_Save_Click(sender, e); } }
private void Btn_Sure_Click(object sender, System.EventArgs e) { int index = cbo_AdviceType.SelectedIndex; if (index != -1) { object advice = txt_Advice.Text; string primaryKey = Guid.NewGuid().ToString(); string insertSql = $"INSERT INTO quality_advices VALUES('{primaryKey}','{UserHelper.GetUser().UserKey}','{DateTime.Now}','{objId}','{advice}',{index})"; SqlHelper.ExecuteNonQuery(insertSql); lbl_ObjName.Tag = primaryKey; btn_Delete.Enabled = true; XtraMessageBox.Show("保存成功。"); Close(); } }
/// <summary> /// 保存/更新 /// </summary> private void Btn_Save_Click(object sender, EventArgs e) { if (!ValidData()) { XtraMessageBox.Show("请先将表单信息补充完整!"); return; } if (XtraMessageBox.Show("确定要保存当前数据吗?", "确认提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK) { //保存批次基本信息 string batchName = txt_BatchName.Text.Trim(); string batchCode = txt_BatchCode.Text.Trim(); string sourceUnit = cbo_SourceUnit.SelectedValue.ToString().Trim(); DateTime transferTime = dtp_TransferTime.Value; string receiver = txt_Receiver.Text.Trim(); string giver = txt_giver.Text.Trim(); string remark = txt_Remark.Text.Trim(); string fileUpload = txt_UploadFile.Text.Trim(); object trpId = Guid.NewGuid().ToString(); int cdCount = dgv_CDlist.RowCount - 1; //新增信息 if (isAdd) { //查重 string querySQL = $"SELECT COUNT(trp_id) FROM transfer_registration_pc WHERE trp_code='{batchCode}' OR trp_name='{batchName}'"; int amount = SqlHelper.ExecuteCountQuery(querySQL); if (amount == 0) { StringBuilder basicInfo_QuerySql = new StringBuilder("INSERT INTO transfer_registration_pc "); basicInfo_QuerySql.Append("(trp_id,com_id,trp_name,trp_code,trp_log_data,trp_receiver,trp_giver,trp_remark,trp_cd_amount,trp_attachment_id,trp_submit_status,trp_work_status,trp_people,trp_handle_time) VALUES("); basicInfo_QuerySql.Append("'" + trpId + "',"); basicInfo_QuerySql.Append("'" + sourceUnit + "',"); basicInfo_QuerySql.Append("'" + batchName + "',"); basicInfo_QuerySql.Append("'" + batchCode + "',"); basicInfo_QuerySql.Append("'" + transferTime + "',"); basicInfo_QuerySql.Append("'" + receiver + "',"); basicInfo_QuerySql.Append("'" + giver + "',"); basicInfo_QuerySql.Append("'" + remark + "',"); basicInfo_QuerySql.Append("'" + cdCount + "',"); basicInfo_QuerySql.Append("'" + fileUpload + "',"); basicInfo_QuerySql.Append("'" + (int)SubmitStatus.NonSubmit + "',"); basicInfo_QuerySql.Append("'" + (int)WorkStatus.NonWork + "',"); basicInfo_QuerySql.Append("'" + UserHelper.GetUser().UserKey + "',"); basicInfo_QuerySql.Append("'" + DateTime.Now + "')"); SqlHelper.ExecuteNonQuery(basicInfo_QuerySql.ToString()); //保存光盘基本信息 SaveCDList(trpId); } else { XtraMessageBox.Show("批次编号或名称已存在,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } } //更新信息 else { StringBuilder basicInfo_QuerySql = new StringBuilder("UPDATE transfer_registration_pc SET "); basicInfo_QuerySql.Append("com_id='" + sourceUnit + "',"); basicInfo_QuerySql.Append("trp_name='" + batchName + "',"); basicInfo_QuerySql.Append("trp_code='" + batchCode + "',"); basicInfo_QuerySql.Append("trp_log_data='" + transferTime + "',"); basicInfo_QuerySql.Append("trp_receiver='" + receiver + "',"); basicInfo_QuerySql.Append("trp_giver='" + giver + "',"); basicInfo_QuerySql.Append("trp_remark='" + remark + "',"); basicInfo_QuerySql.Append("trp_cd_amount='" + cdCount + "',"); basicInfo_QuerySql.Append("trp_attachment_id='" + fileUpload + "',"); basicInfo_QuerySql.Append("trp_submit_status=1, trp_work_status=1,"); basicInfo_QuerySql.Append("trp_people='" + UserHelper.GetUser().UserKey + "',"); basicInfo_QuerySql.Append("trp_handle_time='" + DateTime.Now + "'"); basicInfo_QuerySql.Append(" WHERE trp_id='" + unitCode + "'"); SqlHelper.ExecuteNonQuery(basicInfo_QuerySql.ToString()); //保存光盘基本信息【先删除当前批次下的所有光盘,再执行新增】 SqlHelper.ExecuteNonQuery("DELETE FROM transfer_registraion_cd WHERE trp_id = '" + unitCode + "'"); SaveCDList(unitCode); } if (XtraMessageBox.Show((isAdd ? "添加" : "更新") + "成功,是否返回列表页", "恭喜", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes) { DialogResult = DialogResult.OK; Close(); } } }