Exemplo n.º 1
0
        private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex > -1)
            {
                int        rowIndex = e.RowIndex;
                DoubleBoll data     = new DoubleBoll();
                data.QiShu          = dataGridView1.Rows[rowIndex].Cells[0].Value.ToString();
                data.OpenDate       = DateTime.Parse(dataGridView1.Rows[rowIndex].Cells[1].Value.ToString());
                data.SaleTotal      = int.Parse(dataGridView1.Rows[rowIndex].Cells[10].Value.ToString());
                data.Red1           = int.Parse(dataGridView1.Rows[rowIndex].Cells[2].Value.ToString());
                data.Red2           = int.Parse(dataGridView1.Rows[rowIndex].Cells[3].Value.ToString());
                data.Red3           = int.Parse(dataGridView1.Rows[rowIndex].Cells[4].Value.ToString());
                data.Red4           = int.Parse(dataGridView1.Rows[rowIndex].Cells[5].Value.ToString());
                data.Red5           = int.Parse(dataGridView1.Rows[rowIndex].Cells[6].Value.ToString());
                data.Red6           = int.Parse(dataGridView1.Rows[rowIndex].Cells[7].Value.ToString());
                data.Blue           = int.Parse(dataGridView1.Rows[rowIndex].Cells[8].Value.ToString());
                data.TouJiangZhuShu = int.Parse(dataGridView1.Rows[rowIndex].Cells[11].Value.ToString());
                //data.TouJiang = int.Parse(dataGridView1.Rows[rowIndex].Cells[11].Value.ToString());
                data.ErJiangZhuShu = int.Parse(dataGridView1.Rows[rowIndex].Cells[12].Value.ToString());
                //data.ErJiang = int.Parse(dataGridView1.Rows[rowIndex].Cells[13].Value.ToString());
                // data.SanJiangZhuShu = int.Parse(dataGridView1.Rows[rowIndex].Cells[14].Value.ToString());
                //data.SanJiang = int.Parse(dataGridView1.Rows[rowIndex].Cells[15].Value.ToString());

                Detail d = new Detail(data);
                d.Show();
            }
        }
Exemplo n.º 2
0
 public Detail(DoubleBoll data)
 {
     InitializeComponent();
     if (data != null)
     {
         _data = data;
     }
     LoadData();
 }
Exemplo n.º 3
0
        int IQueryComparator.Compare(object first, object second)
        {
            DoubleBoll f         = (DoubleBoll)first;
            DoubleBoll s         = (DoubleBoll)second;
            int        first_qi  = int.Parse(f.QiShu);
            int        second_qi = int.Parse(s.QiShu);

            return(-(first_qi - second_qi));
        }
Exemplo n.º 4
0
 void LoadBack()
 {
     if (_data != null)
     {
         //Update
         DoubleBoll newOne = new DoubleBoll();
         newOne.OpenDate       = DateTime.Parse(textbox_date.Text);
         newOne.TouJiang       = int.Parse(textBox_fBonus.Text);
         newOne.TouJiangZhuShu = int.Parse(textBox_fNo.Text);
         newOne.QiShu          = textBox_qi.Text;
         newOne.SaleTotal      = int.Parse(textBox_sales.Text);
         newOne.ErJiang        = int.Parse(textBox_seBonus.Text);
         newOne.ErJiangZhuShu  = int.Parse(textBox_seNo.Text);
         newOne.SanJiang       = int.Parse(textBox_thBonus.Text);
         newOne.SanJiangZhuShu = int.Parse(textBox_thNo.Text);
         newOne.Red1           = int.Parse(Red1.Text);
         newOne.Red2           = int.Parse(Red2.Text);
         newOne.Red3           = int.Parse(Red3.Text);
         newOne.Red4           = int.Parse(Red4.Text);
         newOne.Red5           = int.Parse(Red5.Text);
         newOne.Red6           = int.Parse(Red6.Text);
         newOne.Blue           = int.Parse(Blue1.Text);
         DBHelper.UpdateFromDB(MainWindow._db, newOne);
     }
     else
     {
         _data                = new DoubleBoll();//ADD
         _data.OpenDate       = DateTime.Parse(textbox_date.Text);
         _data.TouJiang       = int.Parse(textBox_fBonus.Text.Replace(",", string.Empty));
         _data.TouJiangZhuShu = int.Parse(textBox_fNo.Text);
         _data.QiShu          = textBox_qi.Text;
         _data.SaleTotal      = int.Parse(textBox_sales.Text.Replace(",", string.Empty));
         _data.ErJiang        = int.Parse(textBox_seBonus.Text.Replace(",", string.Empty));
         _data.ErJiangZhuShu  = int.Parse(textBox_seNo.Text);
         _data.SanJiang       = int.Parse(textBox_thBonus.Text.Replace(",", string.Empty));
         _data.SanJiangZhuShu = int.Parse(textBox_thNo.Text.Replace(",", string.Empty));
         _data.Red1           = int.Parse(Red1.Text);
         _data.Red2           = int.Parse(Red2.Text);
         _data.Red3           = int.Parse(Red3.Text);
         _data.Red4           = int.Parse(Red4.Text);
         _data.Red5           = int.Parse(Red5.Text);
         _data.Red6           = int.Parse(Red6.Text);
         _data.Blue           = int.Parse(Blue1.Text);
         DBHelper.SaveToDB(MainWindow._db, _data, true);
     }
 }
Exemplo n.º 5
0
        bool ICaiCompare.Compare(object first, object second)
        {
            DoubleBoll f = (DoubleBoll)first;
            DoubleBoll s = (DoubleBoll)second;

            if (f.Red1 == s.Red1 &&
                f.Red2 == s.Red2 &&
                f.Red3 == s.Red3 &&
                f.Red4 == s.Red4 &&
                f.Red5 == s.Red5 &&
                f.Red6 == s.Red6 &&
                f.Blue == s.Blue
                )
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemplo n.º 6
0
        private void bt_syncRecent_Click(object sender, EventArgs e)
        {
            if (CommonHelper.IsInterNetConnected())
            {
                try
                {
                    string ulrPrefix = @"http://kaijiang.zhcw.com/zhcw/html/ssq/list_";
                    string ulrSufix  = @".html";

                    string realUlr = ulrPrefix + "1" + ulrSufix;
                    HtmlHelper.HtmlFromWebReq req = new HtmlHelper.HtmlFromWebReq(
                        realUlr, delegate(byte[] data)
                    {
                        string constructedString         = System.Text.Encoding.UTF8.GetString(data);
                        HtmlAgilityPack.HtmlDocument doc = new HtmlAgilityPack.HtmlDocument();
                        doc.LoadHtml(constructedString);
                        //HtmlAgilityPack.HtmlNode node = doc.DocumentNode.SelectSingleNode("/html[1]/body[1]/table[1]/tr[3]/td[3]");
                        HtmlAgilityPack.HtmlNodeCollection _nodes = doc.DocumentNode.SelectNodes("/html[1]/body[1]/table[1]/tr[position()>2]");
                        foreach (HtmlAgilityPack.HtmlNode no in _nodes)
                        {
                            string s             = no.InnerText;
                            s                    = s.Trim().Replace(" ", "");//.Replace('\n',' ').Replace('\r',' ');//Replace(" ","|");
                            string[] lines       = s.Split(new char[] { '\r', '\n' });
                            List <string> _infos = new List <string>();
                            foreach (string ss in lines)
                            {
                                if (string.IsNullOrEmpty(ss))
                                {
                                    continue;
                                }
                                _infos.Add(ss);
                            }
                            if (!(_infos.Count == 12 || _infos.Count == 13))
                            {
                                continue;
                            }
                            DoubleBoll temp = new DoubleBoll();
                            string riqi     = _infos[0];
                            string qishu    = _infos[1];
                            string r1       = _infos[2];
                            string r2       = _infos[3];
                            string r3       = _infos[4];
                            string r4       = _infos[5];
                            string r5       = _infos[6];
                            string r6       = _infos[7];
                            string b1       = _infos[8];
                            string allmoney = _infos[9];
                            string fno      = "", fpro = "", sno = "";
                            if (_infos.Count == 13)
                            {
                                fno  = _infos[10];
                                fpro = _infos[11];
                                sno  = _infos[12];
                            }
                            else if (_infos.Count == 12)
                            {
                                fno = _infos[10];
                                sno = _infos[11];
                            }

                            string[] ymd        = riqi.Split(new char[] { '-' });
                            DateTime opendate   = new DateTime(Convert.ToInt32(ymd[0]), Convert.ToInt32(ymd[1]), Convert.ToInt32(ymd[2]));
                            temp.OpenDate       = opendate;
                            temp.Red1           = Convert.ToInt32(r1);
                            temp.Red2           = Convert.ToInt32(r2);
                            temp.Red3           = Convert.ToInt32(r3);
                            temp.Red4           = Convert.ToInt32(r4);
                            temp.Red5           = Convert.ToInt32(r5);
                            temp.Red6           = Convert.ToInt32(r6);
                            temp.Blue           = Convert.ToInt32(b1);
                            temp.SaleTotal      = Convert.ToInt32(allmoney.Replace(",", ""));
                            temp.TouJiangZhuShu = Convert.ToInt32(fno);
                            temp.ErJiangZhuShu  = Convert.ToInt32(sno);
                            temp.FirstProvince  = fpro;
                            temp.QiShu          = qishu;
                            if (!DBHelper.SaveToDB(_db, temp, true))
                            {
                                DBHelper.UpdateFromDB(_db, temp);
                            }
                        }
                        //string temp = node.InnerText;

                        MessageBox.Show("完成");
                    });

                    req.BeginCreateHtml();
                }
                catch (Exception ex)
                {
                    LOGGER.Error("**************导入数据错误***********", ex);
                }
            }
            else
            {
                MessageBox.Show("没有互联网!");
            }
        }