private void новоеToolStripMenuItem_Click(object sender, EventArgs e)
{
SingleWindow singleWindow = new SingleWindow();
singleWindow.TopLevel = false;
singleWindow.Location = new Point(10, 50);
singleWindow.MdiParent = this;
int max = 0;
try
{
max = _childWindows.Where(w => w.Text != "").Max(c => Convert.ToInt32(c.Text.Split(' ')[2]));
}
catch
{
max = 0;
}
singleWindow.Text += " " + (max + 1);
singleWindow.Show();
singleWindow.WindowState = FormWindowState.Maximized;
menuStrip.BringToFront();
toolStrip.BringToFront();
ToolStripMenuItem toolStripMenuItem = new ToolStripMenuItem();
toolStripMenuItem.Text = singleWindow.Text;
toolStripMenuItem.Click += delegate
{
singleWindow.Focus();
foreach (var item in окноToolStripMenuItem.DropDownItems)
{
if (item is ToolStripMenuItem)
{
(item as ToolStripMenuItem).Checked = false;
}
}
toolStripMenuItem.Checked = true;
};
окноToolStripMenuItem.DropDownItems.Add(toolStripMenuItem);
_childWindows.Add(singleWindow);
foreach (var item in окноToolStripMenuItem.DropDownItems)
{
if (item is ToolStripMenuItem)
{
(item as ToolStripMenuItem).Checked = false;
}
}
toolStripMenuItem.Checked = true;
}
private static void DrawItem(Item item)
{
#if MM_EXP || UNITY_2020_1_OR_NEWER || UNITY_EDITOR_LINUX
SingleWindow menu = new SingleWindow()
{
rootItem = item
};
#else
PopupMenu menu = new PopupMenu()
{
items = item.subItems, minWidth = 150
};
#endif
menu.Show(Event.current.mousePosition);
}
private static void DrawItem(Item item)
{
#if !MM_EXP
PopupMenu menu = new PopupMenu()
{
items = item.subItems, minWidth = 150
};
#else
SingleWindow menu = new SingleWindow()
{
rootItem = item
};
#endif
menu.Show(Event.current.mousePosition);
}
public static TexturesCache texturesCache = new TexturesCache(); //to store icons
public static void DrawRightClickItems(UI ui, Vector2 mousePos, Graph graph)
{
Item item = RightClickItems(ui, mousePos, graph);
#if MM_EXP || UNITY_2020_1_OR_NEWER || UNITY_EDITOR_LINUX
SingleWindow menu = new SingleWindow()
{
rootItem = item
};
#else
PopupMenu menu = new PopupMenu()
{
items = item.subItems, minWidth = 150
};
#endif
menu.Show(Event.current.mousePosition);
}
public void OnGUI()
{
if (Event.current.type == EventType.MouseDown && Event.current.button == 1)
{
Item menu = new Item("Menu");
menu.subItems = new List <Item>()
{
new Item("Create", new Item("Map"), new Item("Objects"), new Item("Splines")),
new Item("Generator"),
new Item("Group"),
new Item("Graph")
};
menu.color = new Color(0.8f, 0.8f, 0.8f);
SingleWindow window = new SingleWindow()
{
rootItem = menu, width = 150
};
window.Show(Event.current.mousePosition);
}
}
public List <SingleWindow> GetListByDfno(SingleWindow singleWindow)
{
//构造要查询的sql语句
string sql = @"select id,batch,cust_dec_head_id from bg_cust_dec_detail
where batch='" + singleWindow.Batch + "' and cust_dec_head_id='" + singleWindow.Id + "'";
//使用helper进行查询，得到结果
DataTable dt = mysqlHelper.GetDataTable(sql);
//将dt中的数据转存到list中
List <SingleWindow> list = new List <SingleWindow>();
foreach (DataRow row in dt.Rows)
{
list.Add(new SingleWindow()
{
//Detail_id = row["id"].ToString(),
//Batch = singleWindow.Batch.ToString(),
//Cust_dec_head_id = row["cust_dec_head_id"].ToString(),
});
}
//将集合返回
return(list);
}
public List <SingleWindow> selectChecked(SingleWindow singleWindow)
{
StringBuilder sb = new StringBuilder();
//构造要查询的sql语句
string sql = @"select id,seq_no,batch,client_seq_no from bg_cust_dec_head_singlewindow where 1=1 ";
sb.Append(sql);
if (singleWindow.Batch != null && singleWindow.Batch != "")
{
sb.Append("and batch='" + singleWindow.Batch + "'");
}
if (singleWindow.SeqNo != null && singleWindow.SeqNo != "")
{
sb.Append("and seq_no in (" + singleWindow.SeqNo + ")");
}
if (singleWindow.ClientSeqNo != null && singleWindow.ClientSeqNo != "")
{
sb.Append("and client_seq_no < " + singleWindow.ClientSeqNo + "");
}
//使用helper进行查询，得到结果
DataTable dt = mysqlHelper.GetDataTable(sb.ToString());
//将dt中的数据转存到list中
List <SingleWindow> list = new List <SingleWindow>();
foreach (DataRow row in dt.Rows)
{
list.Add(new SingleWindow()
{
Id = row["id"].ToString(),
SeqNo = row["seq_no"].ToString(),
Batch = row["batch"].ToString(),
ClientSeqNo = row["client_seq_no"].ToString(),
});
}
//将集合返回
return(list);
}
public List <SingleWindow> GetDecDocList(SingleWindow singleWindow)
{
StringBuilder sb = new StringBuilder();
//构造要查询的sql语句
string sql = @"SELECT seq_no from bg_cust_dec_head WHERE batch = '" + singleWindow.Batch + "' and seq_no is not NULL and pro_df_no is NULL or pro_df_no=''";
sb.Append(sql);
//使用helper进行查询，得到结果
DataTable dt = mysqlHelper.GetDataTable(sb.ToString());
//将dt中的数据转存到list中
List <SingleWindow> list = new List <SingleWindow>();
foreach (DataRow row in dt.Rows)
{
list.Add(new SingleWindow()
{
SeqNo = row["seq_no"].ToString(),
});
}
//将集合返回
return(list);
}
public List <SingleWindow> GetCiqList(SingleWindow singleWindow)
{
StringBuilder sb = new StringBuilder();
//构造要查询的sql语句
string sql = @"SELECT A.seq_no,B.ciq_decl_no from bg_cust_dec_head A LEFT JOIN (SELECT bill_no,ciq_decl_no from bg_cust_dec_head WHERE batch = '" + singleWindow.Batch + "' AND ciq_decl_no is NOT NULL GROUP BY bill_no) B on A.bill_no=B.bill_no WHERE batch = '" + singleWindow.Batch + "' and (A.ciq_decl_no is NULL or A.ciq_decl_no='') and A.seq_no is not NULL and B.ciq_decl_no is not NULL";
sb.Append(sql);
//使用helper进行查询，得到结果
DataTable dt = mysqlHelper.GetDataTable(sb.ToString());
//将dt中的数据转存到list中
List <SingleWindow> list = new List <SingleWindow>();
foreach (DataRow row in dt.Rows)
{
list.Add(new SingleWindow()
{
SeqNo = row["seq_no"].ToString(),
CiqDeclNo = row["ciq_decl_no"].ToString(),
});
}
//将集合返回
return(list);
}
//获取报关单号
public List <SingleWindow> selectChecked(SingleWindow singleWindow)
{
//调用查询方法
return(miDal.selectChecked(singleWindow));
}
/// <summary>
/// Will Start the program. Note
/// </summary>
public void start()
{
SingleWindow.start(this, 800, 480);
}
//获取vin数据
public List <SingleWindow> GetListByDetailId(SingleWindow singleWindow)
{
//调用查询方法
return(miDal.GetListByDetailId(singleWindow));
}
//获取detailId数据
public List <SingleWindow> GetListByDfno(SingleWindow singleWindow)
{
//调用查询方法
return(miDal.GetListByDfno(singleWindow));
}
//获取报关委托协议号数据
public List <SingleWindow> GetDecDocList(SingleWindow singleWindow)
{
//调用查询方法
return(miDal.GetDecDocList(singleWindow));
}
//获取报关单号
public int UpdateHeadState(SingleWindow singleWindow)
{
//调用查询方法
return(miDal.UpdateHeadState(singleWindow));
}
//保存head表
public bool UpadteHeadInfo(SingleWindow mi)
{
return(miDal.UpadteHeadInfo(mi) > 0);
}
//保存Headsinglewindow
public bool Edit(SingleWindow mi)
{
return(miDal.Update(mi) > 0);
}
/// <summary>
/// 更新单一窗口表头
/// </summary>
/// <param name="mi"></param>
/// <returns></returns>
public int Update(SingleWindow mi)
{
//为什么要进行密码的判断：
//答：因为密码值是经过md5加密存储的，当修改时，需要判断用户是否改了密码，如果没有改，则不变，如果改了，则重新进行md5加密
//定义参数集合，可以动态添加元素
List <MySqlParameter> listPs = new List <MySqlParameter>();
//构造update的sql语句
string sql = @"update bg_cust_dec_head_singlewindow set
port_of_ie_code=@p1, port_of_ie_name=@p2, customs_status=@p3, customs_status_detail=@p4, seq_no=@p5,
pre_entry_no=@p6, df_no=@p7, ie_port=@p8,ie_port_name=@p9 ,contr_no =@p10 ,
date_of_ie=@p11 ,date_of_declaration =@p12 ,trade_co_scc=@p13 ,proprietor_company_code =@p14 ,trade_ciq_code=@p15 ,
proprietor_company_name=@p16 ,overseas_consignor_code =@p17 ,overseas_consignor_ename=@p18 ,owner_code_scc =@p19 ,owner_code=@p20 ,
owner_ciq_code=@p21 ,owner_name =@p22 ,agent_code_scc=@p23 ,agent_code =@p24 ,decl_ciq_code=@p25 ,
agent_name=@p26 ,traf_mode_std =@p27 ,traf_mode_std_name=@p28 ,traf_name =@p29 ,voyage_no=@p30 ,
bill_no=@p31 ,trade_method_code =@p32 ,trade_method_name=@p33 ,nc_code =@p34 ,nc_name=@p35 ,
licence_no=@p36 ,trade_country_std =@p37 ,trade_country_std_name=@p38 ,distinate_port_std =@p39 ,distinate_port_std_name=@p40 ,
terms_of_delivery_code=@p41 ,terms_of_delivery_name =@p42 ,total_piece=@p43 ,wrap_type_std =@p44 ,wrap_type_std_name=@p45 ,
total_gross_weight=@p46 ,total_net_weight =@p47 ,trade_country_code=@p48 ,trade_country_name =@p49 ,doc_type_code1=@p50 ,
enty_port_code=@p51 ,enty_port_name =@p52 ,goods_place=@p53 ,desp_port_code =@p54 ,desp_port_name=@p55 ,
dec_type=@p56 ,dec_type_name =@p57 ,label_remark=@p58 ,mark_no =@p59 ,org_code=@p60 ,
org_name=@p61 ,declaration_material_code =@p62 ,ent_qualif_no=@p63 ,vsa_org_code =@p64 ,vsa_org_name=@p65 ,
insp_org_code=@p66 ,insp_org_name =@p67 ,desp_date=@p68 ,bl_line_no =@p69 ,purp_org_code=@p70 ,
purp_org_name=@p71 ,correlation_no =@p72 ,correlation_reason_flag=@p73 ,use_org_person_code =@p74 ,use_org_person_tel=@p75 ,
file_type=@p76 ,file_type_name =@p77 ,rpr_flag=@p78 ,relation_flag =@p79 ,price_flag=@p80 ,
royalty_flag=@p81,file_type=@p82 ,file_type_name=@p83, appl_ori=@p84, appl_copy_quan=@p85 ,
domestic_consignee_ename=@p86,overseas_consignor_cname=@p87 ,overseas_consignor_addr=@p88, cmpl_dschrg_dt=@p89, pack_type=@p90 ,pack_type_name=@p91, doc_no1=@p92,
doc_type_code2=@p93,doc_no2=@p94, dec_g_no=@p95,eco_g_no=@p96,
client_seq_no=1, batch=@batch, update_date =@update ";
#region//参数
listPs.Add(new MySqlParameter("@p1", mi.PortOfIeCode));
listPs.Add(new MySqlParameter("@p2", mi.PortOfIeName));
listPs.Add(new MySqlParameter("@p3", mi.CustomsStatus));
listPs.Add(new MySqlParameter("@p4", mi.CustomsStatusDetail));
listPs.Add(new MySqlParameter("@p5", mi.SeqNo));
listPs.Add(new MySqlParameter("@p6", mi.PreEntryNo));
listPs.Add(new MySqlParameter("@p7", mi.DfNo));
listPs.Add(new MySqlParameter("@p8", mi.IePort));
listPs.Add(new MySqlParameter("@p9", mi.IePortName));
listPs.Add(new MySqlParameter("@p10", mi.ContrNo));
listPs.Add(new MySqlParameter("@p11", mi.DateOfIe));
listPs.Add(new MySqlParameter("@p12", mi.DateOfDeclaration));
listPs.Add(new MySqlParameter("@p13", mi.TradeCoScc));
listPs.Add(new MySqlParameter("@p14", mi.ProprietorCompanyCode));
listPs.Add(new MySqlParameter("@p15", mi.TradeCiqCode));
listPs.Add(new MySqlParameter("@p16", mi.ProprietorCompanyName));
listPs.Add(new MySqlParameter("@p17", mi.OverseasConsignorCode));
listPs.Add(new MySqlParameter("@p18", mi.OverseasConsignorEname));
listPs.Add(new MySqlParameter("@p19", mi.OwnerCodeScc));
listPs.Add(new MySqlParameter("@p20", mi.OwnerCode));
listPs.Add(new MySqlParameter("@p21", mi.OwnerCiqCode));
listPs.Add(new MySqlParameter("@p22", mi.OwnerName));
listPs.Add(new MySqlParameter("@p23", mi.AgentCodeScc));
listPs.Add(new MySqlParameter("@p24", mi.AgentCode));
listPs.Add(new MySqlParameter("@p25", mi.DeclCiqCode));
listPs.Add(new MySqlParameter("@p26", mi.AgentName));
listPs.Add(new MySqlParameter("@p27", mi.TrafModeStd));
listPs.Add(new MySqlParameter("@p28", mi.TrafModeStdName));
listPs.Add(new MySqlParameter("@p29", mi.TrafName));
listPs.Add(new MySqlParameter("@p30", mi.VoyageNo));
listPs.Add(new MySqlParameter("@p31", mi.BillNo));
listPs.Add(new MySqlParameter("@p32", mi.TradeMethodCode));
listPs.Add(new MySqlParameter("@p33", mi.TradeMethodName));
listPs.Add(new MySqlParameter("@p34", mi.NcCode));
listPs.Add(new MySqlParameter("@p35", mi.NcName));
listPs.Add(new MySqlParameter("@p36", mi.LicenceNo));
listPs.Add(new MySqlParameter("@p37", mi.TradeCountryStd));
listPs.Add(new MySqlParameter("@p38", mi.TradeCountryStdName));
listPs.Add(new MySqlParameter("@p39", mi.DistinatePortCode));
listPs.Add(new MySqlParameter("@p40", mi.DistinatePortName));
listPs.Add(new MySqlParameter("@p41", mi.TermsOfDeliveryCode));
listPs.Add(new MySqlParameter("@p42", mi.TermsOfDeliveryName));
listPs.Add(new MySqlParameter("@p43", mi.TotalPiece));
listPs.Add(new MySqlParameter("@p44", mi.WrapTypeStd));
listPs.Add(new MySqlParameter("@p45", mi.WrapTypeStdName));
listPs.Add(new MySqlParameter("@p46", mi.TotalGrossWeight));
listPs.Add(new MySqlParameter("@p47", mi.TotalNetWeight));
listPs.Add(new MySqlParameter("@p48", mi.TradeCountryCode));
listPs.Add(new MySqlParameter("@p49", mi.TradeCountryName));
listPs.Add(new MySqlParameter("@p50", mi.DocTypeCode1));
listPs.Add(new MySqlParameter("@p51", mi.EntyPortCode));
listPs.Add(new MySqlParameter("@p52", mi.EntyPortName));
listPs.Add(new MySqlParameter("@p53", mi.GoodsPlace));
listPs.Add(new MySqlParameter("@p54", mi.DespPortCode));
listPs.Add(new MySqlParameter("@p55", mi.DespPortName));
listPs.Add(new MySqlParameter("@p56", mi.DecType));
listPs.Add(new MySqlParameter("@p57", mi.DecTypeName));
listPs.Add(new MySqlParameter("@p58", mi.LabelRemark));
listPs.Add(new MySqlParameter("@p59", mi.MarkNo));
listPs.Add(new MySqlParameter("@p60", mi.OrgCode));
listPs.Add(new MySqlParameter("@p61", mi.OrgName));
listPs.Add(new MySqlParameter("@p62", mi.DeclarationMaterialCode));
listPs.Add(new MySqlParameter("@p63", mi.EntQualifNo));
listPs.Add(new MySqlParameter("@p64", mi.VsaOrgCode));
listPs.Add(new MySqlParameter("@p65", mi.VsaOrgName));
listPs.Add(new MySqlParameter("@p66", mi.InspOrgCode));
listPs.Add(new MySqlParameter("@p67", mi.InspOrgName));
listPs.Add(new MySqlParameter("@p68", mi.DespDate));
listPs.Add(new MySqlParameter("@p69", mi.BlLineNo));
listPs.Add(new MySqlParameter("@p70", mi.PurpOrgCode));
listPs.Add(new MySqlParameter("@p71", mi.PurpOrgName));
listPs.Add(new MySqlParameter("@p72", mi.CorrelationNo));
listPs.Add(new MySqlParameter("@p73", mi.CorrelationReasonFlag));
listPs.Add(new MySqlParameter("@p74", mi.UseOrgPersonCode));
listPs.Add(new MySqlParameter("@p75", mi.UseOrgPersonTel));
listPs.Add(new MySqlParameter("@p76", mi.FileType));
listPs.Add(new MySqlParameter("@p77", mi.FileTypeName));
listPs.Add(new MySqlParameter("@p78", mi.RprFlag));
listPs.Add(new MySqlParameter("@p79", mi.RelationFlag));
listPs.Add(new MySqlParameter("@p80", mi.PriceFlag));
listPs.Add(new MySqlParameter("@p81", mi.RoyaltyFlag));
listPs.Add(new MySqlParameter("@p82", mi.FileType));
listPs.Add(new MySqlParameter("@p83", mi.FileTypeName));
listPs.Add(new MySqlParameter("@p84", mi.ApplOri));
listPs.Add(new MySqlParameter("@p85", mi.ApplCopyQuan));
listPs.Add(new MySqlParameter("@p86", mi.DomesticConsigneeEname));
listPs.Add(new MySqlParameter("@p87", mi.OverseasConsignorCname));
listPs.Add(new MySqlParameter("@p88", mi.OverseasConsignorAddr));
listPs.Add(new MySqlParameter("@p89", mi.CmplDschrgDt));
listPs.Add(new MySqlParameter("@p90", mi.PackType));
listPs.Add(new MySqlParameter("@p91", mi.PackTypeName));
listPs.Add(new MySqlParameter("@p92", mi.DocNo1));
//原产地证
listPs.Add(new MySqlParameter("@p93", mi.DocTypeCode2));
listPs.Add(new MySqlParameter("@p94", mi.DocNo2));
listPs.Add(new MySqlParameter("@p95", mi.DecGNo));
listPs.Add(new MySqlParameter("@p96", mi.EcoGNo));
#endregion
listPs.Add(new MySqlParameter("@batch", mi.Batch));
listPs.Add(new MySqlParameter("@update", mi.UpdateDate));
listPs.Add(new MySqlParameter("@id", mi.Id));
listPs.Add(new MySqlParameter("@seqno", mi.SeqNo));
//继续拼接语句
sql += "where id=@id and seq_no = @seqno ";
//执行语句并返回结果
return(mysqlHelper.ExcuteNonQuery(sql, listPs.ToArray()));
}
