private void search() { MyWordsClass myWordsClass1 = new MyWordsClass(); DataGridView dataGridView = this.grid_myTask; MyWordsClass myWordsClass2 = myWordsClass1; int userId = sys.LoginUser.ID; DateTime dateTime = this.dateTimePicker1.Value; string rq = dateTime.ToString("yyyy-MM-dd 00:00:00"); dateTime = this.dateTimePicker2.Value; string rq2 = dateTime.ToString("yyyy-MM-dd 23:59:59"); DataTable myTask = myWordsClass2.getMyTask(userId, rq, rq2); dataGridView.DataSource = (object) myTask; }
private void search() { MyWordsClass myWordsClass1 = new MyWordsClass(); DataGridView dataGridView = this.grid_myTask; MyWordsClass myWordsClass2 = myWordsClass1; int userId = sys.LoginUser.ID; DateTime dateTime = this.dateTimePicker1.Value; string rq = dateTime.ToString("yyyy-MM-dd 00:00:00"); dateTime = this.dateTimePicker2.Value; string rq2 = dateTime.ToString("yyyy-MM-dd 23:59:59"); DataTable myTask = myWordsClass2.getMyTask(userId, rq, rq2); dataGridView.DataSource = (object)myTask; }
private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { sys.myWordsId = -1; frm_myWords frmMyWords = new frm_myWords(); int num = (int)frmMyWords.ShowDialog(); if (frmMyWords.DialogResult != DialogResult.OK || sys.myWordsId == -1) return; DataRow dataRow = new MyWordsClass().SelectRecordByID(sys.myWordsId).Rows[0]; this.rw_txt_key.Text = dataRow["keyword"].ToString().Trim(); this.rw_com_ww.Text = dataRow["ww"].ToString().Trim(); this.rw_txt_title.Text = dataRow["title"].ToString().Trim(); this.rw_txt_price1.Text = dataRow["price1"].ToString().Trim().Replace("-1", ""); this.rw_txt_price2.Text = dataRow["price2"].ToString().Trim().Replace("-1", ""); this.rw_txt_dq.Text = dataRow["dq"].ToString().Trim(); this.rw_com_jd.Text = dataRow["comeType"].ToString().Trim(); this.rw_com_page.Text = dataRow["pageNum"].ToString().Trim(); this.rw_howe_time1.Text = dataRow["homeTime1"].ToString().Trim(); this.rw_howe_time2.Text = dataRow["homeTime2"].ToString().Trim(); this.rw_txt_cjsl1.Text = dataRow["downNum1"].ToString().Trim(); this.rw_txt_cjsl2.Text = dataRow["downNum2"].ToString().Trim(); this.rw_jd_sj1.Text = dataRow["jdTime1"].ToString().Trim(); this.rw_jd_sj2.Text = dataRow["jdTime2"].ToString().Trim(); this.rw_dn_sj1.Text = dataRow["dnTime1"].ToString().Trim(); this.rw_dn_sj2.Text = dataRow["dnTime2"].ToString().Trim(); this.rw_com_lm1.Text = dataRow["lm1"].ToString().Trim(); this.rw_com_lm2.Text = dataRow["lm2"].ToString().Trim(); this.txt_spid.Text = dataRow["spid"].ToString().Trim(); if (dataRow["spid"].ToString().Trim() == "展现") { this.rw_rao_zx1.Checked = true; } else { this.txt_spid.Visible = true; //this.label44.Visible = true; this.linkLabel4.Visible = true; this.rw_rao_zx1.Checked = false; this.txt_spid.Text = dataRow["spid"].ToString().Trim(); } if (dataRow["urltaobao"].ToString().Trim() != null && dataRow["urltaobao"].ToString().Trim() != "") { //this.button7.Visible = false; //this.button8.Visible = true; //this.button3.Visible = true; //this.button4.Visible = true; //this.button5.Visible = true; //this.button6.Visible = true; //this.button9.Visible = true; //this.button10.Visible = true; this.Urlflag = true; this.strResultUrl = dataRow["urltaobao"].ToString().Trim(); } else { //this.button7.Visible = true; //this.button8.Visible = false; //this.button3.Visible = false; //this.button4.Visible = false; //this.button5.Visible = false; //this.button6.Visible = false; //this.button9.Visible = false; //this.button10.Visible = false; this.Urlflag = false; this.strResultUrl = dataRow["urltaobao"].ToString().Trim(); } if (dataRow["xinpin"].ToString().Trim() == "新品") this.checkBox2.Checked = true; if (dataRow["baoyou"].ToString().Trim() == "包邮") this.checkBox6.Checked = true; if (dataRow["zsyfx"].ToString().Trim() == "赠送退货运费险") this.checkBox9.Checked = true; if (dataRow["hdfk"].ToString().Trim() == "货到付款") this.checkBox13.Checked = true; if (dataRow["hwsp"].ToString().Trim() == "海外商品") this.checkBox12.Checked = true; if (dataRow["tianmao"].ToString().Trim() == "天猫") this.checkBox15.Checked = true; if (dataRow["zpbz"].ToString().Trim() == "正品保障") this.checkBox8.Checked = true; if (dataRow["xiaoshi24"].ToString().Trim() == "24小时内发货") this.checkBox3.Checked = true; if (dataRow["tian7"].ToString().Trim() == "7+天内退货") this.checkBox7.Checked = true; if (dataRow["wwzx"].ToString().Trim() == "旺旺在线") this.checkBox4.Checked = true; if (dataRow["xykzf"].ToString().Trim() == "信用卡支付") this.checkBox5.Checked = true; if (dataRow["zhekou"].ToString().Trim() == "折扣促销") this.checkBox11.Checked = true; if (dataRow["mfhx"].ToString().Trim() == "免费换新") this.checkBox10.Checked = true; if (dataRow["pzcn"].ToString().Trim() == "品质承诺") this.checkBox14.Checked = true; if (this.rw_howe_time2.Text.Trim() != "" && this.rw_howe_time2.Text.Trim() != "0") this.rw_chk_home.Checked = true; sys.myWordsId = -1; }