示例#1
0
        public static IList <FjdcTm> GetTmList(string wjh)
        {
            SqlConnection cn  = new SqlConnection(new computer2011.ConnectDatabase().conn);
            var           cmd = new SqlCommand();

            cmd.Connection  = cn;
            cmd.CommandText = "select Th,Tm from Tm where Tm.Wjh=" + wjh + "";
            cmd.CommandType = System.Data.CommandType.Text;
            SqlDataAdapter da    = new SqlDataAdapter(cmd);
            DataTable      table = new DataTable();

            da.Fill(table);

            List <FjdcTm> tmlist = new List <FjdcTm>();

            for (int row = 0; row < table.Rows.Count; row++)
            {
                FjdcTm tm = new FjdcTm();
                tm.Th = (long)table.Rows[row][0];
                tm.Tm = table.Rows[row][1].ToString();
                tmlist.Add(tm);


                SqlDataAdapter da1    = new SqlDataAdapter("select ID,choice,tixing,number from choice,Tm where choice.th='" + tm.Th + "' and Tm.th='" + tm.Th + "'", cn);
                DataTable      table1 = new DataTable();
                da1.Fill(table1);
                List <FjdcChoice> choicelist = new List <FjdcChoice>();
                tm.Choices = choicelist;
                int sum = 0;
                for (int j = 0; j < table1.Rows.Count; j++)
                {
                    FjdcChoice choice = new FjdcChoice();
                    choice.Choice = table1.Rows[j][1].ToString();
                    choice.Number = (int)table1.Rows[j][3];
                    sum          += choice.Number;
                    choicelist.Add(choice);
                }

                foreach (var choice in choicelist)
                {
                    choice.Bfb = (int)(100.0 * choice.Number / sum);
                }
            }
            return(tmlist);
        }
示例#2
0
文件: FjdcDAL.cs 项目: pwf2/Tell1
        public static IList<FjdcTm> GetTmList(string wjh)
        {
            SqlConnection cn = new SqlConnection(new computer2011.ConnectDatabase().conn);
            var cmd = new SqlCommand();
            cmd.Connection = cn;
            cmd.CommandText = "select Th,Tm from Tm where Tm.Wjh="+wjh+"";
            cmd.CommandType = System.Data.CommandType.Text;
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable table = new DataTable();
            da.Fill(table);

            List<FjdcTm> tmlist = new List<FjdcTm>();
            for (int row = 0; row < table.Rows.Count; row++)
            {
                FjdcTm tm = new FjdcTm();
                tm.Th = (long)table.Rows[row][0];
                tm.Tm = table.Rows[row][1].ToString();
                tmlist.Add(tm);

                SqlDataAdapter da1 = new SqlDataAdapter("select ID,choice,tixing,number from choice,Tm where choice.th='" + tm.Th + "' and Tm.th='" + tm.Th + "'", cn);
                DataTable table1 = new DataTable();
                da1.Fill(table1);
                List<FjdcChoice> choicelist = new List<FjdcChoice>();
                tm.Choices = choicelist;
                int sum = 0;
                for (int j = 0; j < table1.Rows.Count; j++)
                {
                    FjdcChoice choice = new FjdcChoice();
                    choice.Choice = table1.Rows[j][1].ToString();
                    choice.Number = (int)table1.Rows[j][3];
                    sum += choice.Number;
                    choicelist.Add(choice);
                }

                foreach (var choice in choicelist)
                {
                    choice.Bfb = (int)(100.0 * choice.Number / sum);
                }
            }
            return tmlist;
        }