public static bool CopyPt(List <string> lstSid, string _strZid, string _strDesZtId) { bool bRs = false; try { //MySqlDbAccess.ExecNoQuery(CommandType.Text, string.Format(strSqlTmp, _strSid, _strZid)); using (MySqlDataContext db = new MySqlDataContext()) { foreach (string _strSid in lstSid) { DAL.ShowBase stbase = db.ShowBase.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stbase != null) { DAL.ShowBase tmp = Clone(stbase); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.ShowBase.InsertOnSubmit(tmp); } DAL.STAnS stans = db.STAnS.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stans != null) { DAL.STAnS tmp = Clone(stans); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STAnS.InsertOnSubmit(tmp); } DAL.STCPc stcpc = db.STCPc.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stcpc != null) { DAL.STCPc tmp = Clone(stcpc); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STCPc.InsertOnSubmit(tmp); } DAL.STCt stct = db.STCt.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stct != null) { DAL.STCt tmp = Clone(stct); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STCt.InsertOnSubmit(tmp); } DAL.STDc stdc = db.STDc.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stdc != null) { DAL.STDc tmp = Clone(stdc); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STDc.InsertOnSubmit(tmp); } DAL.STDT stdt = db.STDT.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stdt != null) { DAL.STDT tmp = Clone(stdt); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STDT.InsertOnSubmit(tmp); } DAL.STEc stec = db.STEc.FirstOrDefault(x => x.Sid == _strSid && x.ZTID.Value.ToString() == _strZid); if (stec != null) { DAL.STEc tmp = Clone(stec); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STEc.InsertOnSubmit(tmp); } DAL.STFML stfml = db.STFML.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stfml != null) { DAL.STFML tmp = Clone(stfml); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STFML.InsertOnSubmit(tmp); } DAL.STIpc stipc = db.STIpc.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stipc != null) { DAL.STIpc tmp = Clone(stipc); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STIpc.InsertOnSubmit(tmp); } DAL.STIV stiv = db.STIV.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stiv != null) { DAL.STIV tmp = Clone(stiv); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STIV.InsertOnSubmit(tmp); } DAL.STPa stpa = db.STPa.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stpa != null) { DAL.STPa tmp = Clone(stpa); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STPa.InsertOnSubmit(tmp); } DAL.STPNS stpns = db.STPNS.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stpns != null) { DAL.STPNS tmp = Clone(stpns); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STPNS.InsertOnSubmit(tmp); } DAL.STPR stpr = db.STPR.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stpr != null) { DAL.STPR tmp = Clone(stpr); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STPR.InsertOnSubmit(tmp); } DAL.STZTList stztlist = db.STZTList.FirstOrDefault(x => x.ID == int.Parse(_strDesZtId)); if (stztlist != null) { stztlist.AppSum = stztlist.AppSum == null ? 1 : stztlist.AppSum.Value + 1; } } db.SubmitChanges(); } bRs = true; } catch (Exception ex) { bRs = false; } return(bRs); }
private void ExcelTemplate_Load(object sender, EventArgs e) { //if (tmp.ColumnMapping.Count == 0) //{ foreach (var s in colName) { if (tmp.ColumnMapping.ContainsKey(s)) continue; tmp.ColumnMapping.Add(s, new ColumnMapping() { ExcelColumnName = s, SystemColumnShowName = s }); } //} using (MySqlDataContext con = new MySqlDataContext()) { switch (tmp.Type.ToUpper()) { case "CPRS": ddl = (from x in con.CfGSTColumn where x.IsCN == 1 && x.IsiDX == 1 orderby x.ShownAme select x).ToList<CfGSTColumn>(); break; case "WPI": ddl = (from x in con.CfGSTColumn where x.IsWpi == 1 && x.IsiDX == 1 orderby x.ShownAme select x).ToList<CfGSTColumn>(); break; case "EPODOC": ddl = (from x in con.CfGSTColumn where x.IsEPodOC == 1 && x.IsiDX == 1 orderby x.ShownAme select x).ToList<CfGSTColumn>(); break; } } ddl.Insert(0, new CfGSTColumn() { ShownAme = "忽略" }); this.ExcelCol.DataSource = ddl; this.ExcelCol.DisplayMember = "ShownAme"; dataGridView1.AutoGenerateColumns = false; this.dataGridView1.DataSource = tmp.ColumnMapping.Values.ToList<ColumnMapping>(); }
public static bool CopyPt(string _strSid, string _strZid, string _strDesZtId) { bool bRs = false; string strSqlTmp = @"delete from show_base where sid='{0}' and ztid={1};" + "delete from st_ans where sid='{0}' and ztid={1};" + "delete from st_cpc where sid='{0}' and ztid={1};" + "delete from st_ct where sid='{0}' and ztid={1};" + "delete from st_dc where sid='{0}' and ztid={1};" + "delete from st_dt where sid='{0}' and ztid={1};" + "delete from st_ec where sid='{0}' and ztid={1};" + "delete from st_fml where sid='{0}' and ztid={1};" + "delete from st_ipc where sid='{0}' and ztid={1};" + "delete from st_iv where sid='{0}' and ztid={1};" + "delete from st_pa where sid='{0}' and ztid={1};" + "delete from st_pns where sid='{0}' and ztid={1};" + "delete from st_pr where sid='{0}' and ztid={1};" + "update st_ztlist set app_sum=app_sum+1 where id={2};"; try { //MySqlDbAccess.ExecNoQuery(CommandType.Text, string.Format(strSqlTmp, _strSid, _strZid)); using (MySqlDataContext db = new MySqlDataContext()) { DAL.ShowBase stbase = db.ShowBase.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stbase != null) { DAL.ShowBase tmp = Clone(stbase); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.ShowBase.InsertOnSubmit(tmp); } DAL.STAnS stans = db.STAnS.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stans != null) { DAL.STAnS tmp = Clone(stans); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STAnS.InsertOnSubmit(tmp); } DAL.STCPc stcpc = db.STCPc.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stcpc != null) { DAL.STCPc tmp = Clone(stcpc); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STCPc.InsertOnSubmit(tmp); } DAL.STCt stct = db.STCt.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stct != null) { DAL.STCt tmp = Clone(stct); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STCt.InsertOnSubmit(tmp); } DAL.STDc stdc = db.STDc.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stdc != null) { DAL.STDc tmp = Clone(stdc); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STDc.InsertOnSubmit(tmp); } DAL.STDT stdt = db.STDT.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stdt != null) { DAL.STDT tmp = Clone(stdt); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STDT.InsertOnSubmit(tmp); } DAL.STEc stec = db.STEc.FirstOrDefault(x => x.Sid == _strSid && x.ZTID.Value.ToString() == _strZid); if (stec != null) { DAL.STEc tmp = Clone(stec); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STEc.InsertOnSubmit(tmp); } DAL.STFML stfml = db.STFML.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stfml != null) { DAL.STFML tmp = Clone(stfml); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STFML.InsertOnSubmit(tmp); } DAL.STIpc stipc = db.STIpc.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stipc != null) { DAL.STIpc tmp = Clone(stipc); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STIpc.InsertOnSubmit(tmp); } DAL.STIV stiv = db.STIV.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stiv != null) { DAL.STIV tmp = Clone(stiv); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STIV.InsertOnSubmit(tmp); } DAL.STPa stpa = db.STPa.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stpa != null) { DAL.STPa tmp = Clone(stpa); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STPa.InsertOnSubmit(tmp); } DAL.STPNS stpns = db.STPNS.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stpns != null) { DAL.STPNS tmp = Clone(stpns); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STPNS.InsertOnSubmit(tmp); } DAL.STPR stpr = db.STPR.FirstOrDefault(x => x.SiD == _strSid && x.ZTID.Value.ToString() == _strZid); if (stpr != null) { DAL.STPR tmp = Clone(stpr); tmp.ZTID = int.Parse(_strDesZtId); tmp.ID = 0; db.STPR.InsertOnSubmit(tmp); } DAL.STZTList stztlist = db.STZTList.FirstOrDefault(x => x.ID == int.Parse(_strDesZtId)); if (stztlist != null) { stztlist.AppSum = stztlist.AppSum == null ? 1 : stztlist.AppSum.Value + 1; } db.SubmitChanges(); } bRs = true; } catch (Exception ex) { bRs = false; } return(bRs); }