public static Frm_MyWork GetMyWork(WorkType workType, object planId, object objId, ControlType controlType, bool isBacked, bool isReadOnly)
{
if (myWork == null || myWork.IsDisposed)
{
myWork = new Frm_MyWork(workType, planId, objId, controlType, isBacked, isReadOnly);
}
return(myWork);
}
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();
}
}
