/// <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();
}
}
}