private void Goiss() { if (textBox15.Text.Trim() != "") { string sql = "SELECT xuhao as '工序号',gongxumingcheng as '工序名称',jihuariqi as '计划完成日期'," + "shengchanyuan as '生产班组',wanshengsuliang as'完成数量',jgsu as '加工数',xujah as'序价号'," + "xujia as '序价',buzu as '补助',gongsi as '公式',hezhi as '件资合计',lururiqi as '录入日期'," + "luruyan as '录入人',qiugairiqi as '修改日期',qgren as '修改人' FROM tf_sgdantwo " + $"WHERE shigongdanhao='{textBox15.Text.Trim()}'"; DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.GetConnection(), CommandType.Text, sql); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].Width = 60; dataGridView1.Columns[1].Width = 75; dataGridView1.Columns[2].Width = 90; dataGridView1.Columns[3].Width = 70; dataGridView1.Columns[4].Width = 60; dataGridView1.Columns[5].Width = 60; dataGridView1.Columns[6].Width = 60; dataGridView1.Columns[7].Width = 60; dataGridView1.Columns[8].Width = 50; dataGridView1.Columns[9].Width = 50; dataGridView1.Columns[10].Width = 100; dataGridView1.Columns[11].Width = 100; dataGridView1.Columns[12].Width = 60; dataGridView1.Columns[13].Width = 100; dataGridView1.Columns[14].Width = 60; dataGridView1.Sort(dataGridView1.Columns[0], System.ComponentModel.ListSortDirection.Ascending); } }
/// <summary> /// DataGridView的绑定数据 /// </summary> private void BindData() { _wono = txtWONo.Text.Trim(); if (_wono == "") { return; } var sql = "SELECT xuhao '工序号',gongxumingcheng '工序名称',jihuariqi '计划完成日期'," + "shengchanyuan '生产班组',wanshengsuliang '完成数量',jgsu '加工数',xujah '序价号',xujia '序价'," + "buzu '补助',hezhi '件资合计',lururiqi '录入日期',luruyan '录入人',qiugairiqi '修改日期'," + $"qgren '修改人' FROM tf_sgdantwo WHERE shigongdanhao='{txtWONo.Text.Trim()}'"; var ds = SqlHelper.ExecuteDataset(SqlHelper.GetConnection(), CommandType.Text, sql); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Sort(dataGridView1.Columns[0], ListSortDirection.Ascending); if (IsChecked(_wono)) { lblCheck.Visible = true; } }
private void BindData() { var sql = $"SELECT Craft FROM PD_ProcCard_UPrice WHERE DeptId='{SqlHelper.DeptId}' ORDER BY ID"; var ds = SqlHelper.ExecuteDataset(SqlHelper.GetConnectionString("dzdj"), CommandType.Text, sql); cbxCraft.DataSource = ds.Tables[0]; cbxCraft.DisplayMember = "Craft"; cbxCraft.ValueMember = "Craft"; sql = "SELECT IDO '流水',iname '工序名称',qtime '时间起',ztime '时间止'," + "jilu '单价基数',jisu '计算折率',beizu '备注' FROM udodt ORDER BY iname , ztime "; ds = SqlHelper.ExecuteDataset(SqlHelper.GetConnection(), CommandType.Text, sql); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].Width = 60; dataGridView1.Columns[1].Width = 80; dataGridView1.Columns[2].Width = 80; dataGridView1.Columns[3].Width = 80; dataGridView1.Columns[4].Width = 80; dataGridView1.Columns[5].Width = 80; dataGridView1.Columns[6].Width = 200; dataGridView1.Sort(dataGridView1.Columns[0], System.ComponentModel.ListSortDirection.Ascending); }
private void BindData() { panel1.Visible = false; panel2.Visible = false; panel3.Visible = true; const string sql = "SELECT xujhao '序价号',xujia '序价',buzu '补助',gongsi '公式'," + "shiyong '适用班组',beizu '序价说明',cjren '创建',cjriqi '创建日期',qgren '修改',qgriqi '修改日期' FROM xujia "; var ds = SqlHelper.ExecuteDataset(SqlHelper.GetConnection(), CommandType.Text, sql); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].Width = 80; dataGridView1.Columns[1].Width = 80; dataGridView1.Columns[2].Width = 80; dataGridView1.Columns[3].Width = 55; dataGridView1.Columns[4].Width = 80; dataGridView1.Columns[5].Width = 222; dataGridView1.Columns[6].Width = 55; dataGridView1.Columns[7].Width = 80; dataGridView1.Columns[8].Width = 55; dataGridView1.Columns[9].Width = 80; dataGridView1.Sort(dataGridView1.Columns[0], System.ComponentModel.ListSortDirection.Ascending); }