try

            {

                //先判斷數據是否完整，例如分差，學校表和專業是否導入

                /*

                var cx_fsd = from aa in sjklj.zy_fswc

                             where aa.nd >= DateTime.Now.Year - 1 && aa.nd <= DateTime.Now.Year

                             && aa.lb.Contains("文科") && aa.lb.Contains("理科")

                             select aa;

                if(cx_fsd.Count()==0)

                {

                    this.Lbl_ts.Text = "zy_fswc：分數段數據沒有或者不完整";

                    return;

                }

                 */

 

                //還有zy_school以及zy_school_zy類似的查詢---處理中

                 string conn = "Data Source=.;Initial Catalog=jfzytb;Integrated Security=True";

                 string cmdtxt = string.Format("select * from zy_school where nd={0} and lb in ('{1}','{2}')",

                     DateTime.Now.Year - 1, "文科", "理科");

                 System.Data.DataTable dt_school = gj.sqlcx(conn, cmdtxt);

                 if (dt_school.Select("lb='文科'").Count() == 0 || dt_school.Select("lb='理科'").Count() == 0)

                 {   

                     this.Lbl_ts.Text = " zy_school：高校與分數表數據不完整";

                     return;

                 }

 

                 cmdtxt = string.Format("select * from zy_school_zy where nd={0} and lb in ('{1}','{2}')",

                      DateTime.Now.Year - 1, "文科", "理科");

                 System.Data.DataTable dt_school_zy = gj.sqlcx(conn, cmdtxt);

                 if (dt_school_zy.Select("lb='文科'").Count() == 0 || dt_school_zy.Select("lb='理科'").Count() == 0)

                 {

                     this.Lbl_ts.Text = "zy_school_zy:高校與專業以及分數表數據不完整";

                     return;

                 }

 

                 cmdtxt = string.Format("select * from zy_fswc where nd in ({0},{1}) and lb in ('{2}','{3}')",

                      DateTime.Now.Year - 1,DateTime.Now.Year, "文科", "理科");

                 System.Data.DataTable dt_fc = gj.sqlcx(conn, cmdtxt);

                 if (dt_fc.Select("lb='文科'").Count() == 0 || dt_fc.Select("lb='理科'").Count() == 0

                     || dt_fc.Select(string.Format("nd={0}", DateTime.Now.Year - 1)).Count() == 0 || 

                     dt_fc.Select(string.Format("nd={0}", DateTime.Now.Year)).Count() == 0)

                 {

                     this.Lbl_ts.Text = "zy_fswc:分數段數據沒有或者不完整";

                     return;

                 }

 

                var cx_xx = from aa in sjklj.zy_school

                            select aa;

                foreach (var kk in cx_xx)

                {

                    string dm = kk.dm;

                    string xxmc = kk.xxmc;

                    string pc = kk.pc;

                    int? nd = kk.nd;

                    string lb = kk.lb;

                    string zymc = "";

                    //文科，理科（學校代碼和批次相同，可能類別文理科不同）,同一批次，年度，類別，只要代碼相同即可

                    //就指向的是同一個學校，因此，代碼和學校名稱必須完全檢查(學校名單和專業表名單認真篩選查找修改核實)，學校名稱也匹配則更具有精確性

  

                    var cx_xxzy = from bb in sjklj.zy_school_zy

                                  where bb.dm == dm && bb.pc == pc  && bb.nd == nd && bb.lb == lb

                                  select bb;//找到該學校的專業

                    if (cx_xxzy.Count() > 0)

                    {

                        foreach (var gg in cx_xxzy)

                        {

                            zymc += gg.zymc + " ";

                        }

                    }

                    if (zymc != string.Empty)

                    {

                        kk.zymc = zymc;

                    }

                }

                sjklj.SaveChanges();

                System.Threading.Thread.Sleep(200);

                this.Lbl_ts.Text = "專業已經附加到學校名單表中";

            }

            catch (Exception err)

            {

                this.Lbl_ts.Text = err.Message;

            }