示例#1
0
 public void SaveBuju()
 {
     Dgvfuzhu.SaveDataGridViewStyle(this.Name, dataGridView1);
     Dgvfuzhu.SaveDataGridViewStyle(this.Name, dataGridView2);
     Dgvfuzhu.SaveDataGridViewStyle(this.Name, dataGridView3);
     MessageBox.Show("布局保存成功!");
 }
示例#2
0
 public void DelBuju()
 {
     Dgvfuzhu.deleteDataGridViewStyle(this.Name, dataGridView1);
     Dgvfuzhu.deleteDataGridViewStyle(this.Name, dataGridView2);
     //Dgvfuzhu.BindReadDataGridViewStyle(this.Name, dataGridView1);
     MessageBox.Show("请关掉界面重新打开,恢复初始布局!");
 }
示例#3
0
        private void UserControl1_Load(object sender, EventArgs e)
        {
            try
            {
                dataGridView2.AutoGenerateColumns = false;
                dataGridView1.AutoGenerateColumns = false;
                dataGridView3.AutoGenerateColumns = false;

                string sql = "select 0 as xz,* from zdy_lk_xunjia where byanfa = 1 and cyanfazt = '已提交' ";
                dtXunjia = DbHelper.ExecuteTable(sql);
                dataGridView1.DataSource = dtXunjia;

                comboBox1.Text = "已提交";

                sql  = "select cvalue from zdy_lk_para where lx = '101'";
                cFtp = DbHelper.GetDbString(DbHelper.ExecuteScalar(sql));

                Dgvfuzhu.BindReadDataGridViewStyle(this.Name, dataGridView1); // 初始化布局
                Dgvfuzhu.BindReadDataGridViewStyle(this.Name, dataGridView2); // 初始化布局


                //MessageBox.Show(cFtp);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
示例#4
0
        private void UserControl1_Load(object sender, EventArgs e)
        {
            dataGridView2.AutoGenerateColumns = false;
            dataGridView1.AutoGenerateColumns = false;

            Dgvfuzhu.BindReadDataGridViewStyle(this.Name, dataGridView1); // 初始化布局
            Dgvfuzhu.BindReadDataGridViewStyle(this.Name, dataGridView2); // 初始化布局
            string sql = @"select 0 as xz,[id]
      
      ,[xmbm]
      ,[cinvcode]
      ,[cinvaddcode]
      ,[cinvname],cEnglishname
      ,[cinvstd]
      ,[cqty1]
      ,[cqty2]
      ,[cqty3]
      ,[cqty4]
      ,[cqty5]
      ,[cmemo1]
      ,[czt]
      ,[cmaker]
      ,[ddate]
      ,[xunjiaid]
      ,[dmaketime]
      ,[dmodifytime]
      ,[bimportant]
      ,[burgent]
      ,[zdxjr]
      ,[fpxjr]
      ,[cztgbq]
      ,[dclosetime]
      ,[yid]
      ,[fpxjrxm]
      ,[cpersoncode]
      ,[cdefine1]
      ,[lx]
      ,[byanfa]
      ,[cyanfazt]
      ,[bself]
      ,[bsup]
      ,[bkucun]
      ,[cEnglishname] from zdy_lk_xunjia where czt = '已提交' and fpxjr = '" + canshu.userName + "'";

            dtXunjia = DbHelper.ExecuteTable(sql);
            dataGridView1.DataSource = dtXunjia;

            comboBox1.Text = "已提交";

            txtcgy.Text = canshu.userName;



            if (canshu.cQx == "1" || canshu.cQx == "2" || canshu.userName == "demo")
            {
                dataGridView1.Columns["fpxjr"].Visible = true;
            }
        }