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);
}
