private void simpleButtonExport_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string dept1, dept2, dept3, table_name, cmonth; table_name = "salary"; DataSet ds = new DataSet(); cmonth = dateTimePickerMonth.Text.ToString(); dept1 = comboBoxDept1.SelectedValue.ToString(); dept2 = comboBoxDept2.SelectedValue.ToString(); dept3 = comboBoxDept3.SelectedValue.ToString(); IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@cmonth", cmonth), new SqlParameter("@dept1", dept1), new SqlParameter("@dept2", dept2), new SqlParameter("@dept3", dept3) }; try { ds = conn.RunProcedure("COST_TEMP_EMPLOYEE_SALARY_SUM", parameters, table_name); } catch { MessageBox.Show("失败!"); } bool isok = Common.DataSetToExcel(ds, true); if (isok) { MessageBox.Show("导出完成!"); } }
private void simpleButtonExport_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string month, group; string table_name = "status"; DataSet ds = new DataSet(); month = dateTimePickerMonth.Text.ToString(); group = comboBoxGroup.Text.ToString(); IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@month", month), new SqlParameter("@group", group) }; try { ds = conn.RunProcedure("COST_TEMP_EMPLOYEE_STATUS", parameters, table_name); } catch { MessageBox.Show("失败!"); } bool isok = Common.DataSetToExcel(ds, true); if (isok) { MessageBox.Show("导出完成!"); } }
/// <summary> /// 更新部门 /// </summary> private void UpdateDept() { ConnDB conn = new ConnDB(); IDataParameter[] parameters = new IDataParameter[] { }; conn.RunProcedure("COST_DEPT_IMPORT", parameters); conn.Close(); }
/// <summary> /// 终端台数 /// </summary> private void ImportProduct(string month) { ConnDB conn = new ConnDB(); string strsql, sqldel; int rows, i; //string month = DateTime.Now.ToString("yyyy-MM"); //string month = "2017-10"; strsql = "select cdate from cost_product_quantity where cdate like '" + month + "%' and type = 1"; IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@cmonth", month), new SqlParameter("@type", "1") }; sqldel = "delete from cost_product_quantity where cdate like '" + month + "%' and type = 1"; rows = conn.ReturnRecordCount(strsql); if (rows > 0) { conn.EditDatabase(sqldel); conn.RunProcedure("COST_PRODUCT_IMPORT", parameters, out i); } else { conn.RunProcedure("COST_PRODUCT_IMPORT", parameters, out i); } conn.Close(); }
/// <summary> /// 系统成本计算 /// </summary> private void CalculateSys(string month) { ConnDB conn = new ConnDB(); //string month = DateTime.Now.ToString("yyyy-MM"); string sql; int i, rows; bool isok; isok = CheckData5(month); if (isok) { sql = "select * from COST_MONTH_CALCULATE where cmonth ='" + month + "' and sale_type_id =15"; IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@cmonth", month), new SqlParameter("@saletypeid", "15") }; rows = conn.ReturnRecordCount(sql); if (rows > 0) { string sql1, sql2, sql3, sql4; sql1 = "delete from COST_DAY_CALCULATE where cdate like '" + month + "%' and sale_type_id =15"; sql2 = "delete from COST_MONTH_CALCULATE where cmonth ='" + month + "' and sale_type_id =15"; sql3 = "delete from COST_DEPT_CALCULATE where cdate like '" + month + "%' and sale_type_id =15"; sql4 = "delete from COST_DEPT_MONTH_CALCULATE where cmonth ='" + month + "' and sale_type_id =15"; conn.EditDatabase(sql1); conn.EditDatabase(sql2); conn.EditDatabase(sql3); conn.EditDatabase(sql4); conn.RunProcedure("costing", parameters, out i); } else { conn.RunProcedure("costing", parameters, out i); } } conn.Close(); }
/// <summary> /// 导入考勤 /// </summary> private void ImportAttendance(string month) { ConnDB conn = new ConnDB(); string strsql, sqldel; int rows, i; //string month = DateTime.Now.ToString("yyyy-MM"); //string month = "2017-10"; strsql = "select * from COST_DIRECT_LABOUR_ATTENDANCE where cdate like '%" + month + "%'"; sqldel = "delete from COST_DIRECT_LABOUR_ATTENDANCE where cdate like '%" + month + "%'"; IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@cmonth", month) }; rows = conn.ReturnRecordCount(strsql); if (rows > 0) { conn.EditDatabase(sqldel); conn.RunProcedure("COST_ATTENDANCE_IMPORT", parameters, out i); } else { conn.RunProcedure("COST_ATTENDANCE_IMPORT", parameters, out i); } conn.Close(); }
private void showDetail() { ConnDB conn = new ConnDB(); string dept1, dept2, dept3, table_name, cmonth; table_name = "salary"; DataSet ds; cmonth = dateTimePickerMonth.Text.ToString(); dept1 = comboBoxDept1.SelectedValue.ToString(); dept2 = comboBoxDept2.SelectedValue.ToString(); dept3 = comboBoxDept3.SelectedValue.ToString(); bool success = true; IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@cmonth", cmonth), new SqlParameter("@dept1", dept1), new SqlParameter("@dept2", dept2), new SqlParameter("@dept3", dept3) }; try { ds = conn.RunProcedure("COST_TEMP_EMPLOYEE_SALARY_SUM", parameters, table_name); gridControl1.DataSource = ds.Tables[0].DefaultView; } catch { MessageBox.Show("失败!"); success = false; } if (success) { for (int i = 0; i <= 20; i++) { gridView1.Columns[i].OptionsColumn.ReadOnly = true; gridView1.Columns[i].OptionsColumn.FixedWidth = true; gridView1.Columns[i].Width = 70; } } //表头设置 gridView1.ColumnPanelRowHeight = 35; gridView1.OptionsView.AllowHtmlDrawHeaders = true; gridView1.Appearance.HeaderPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; //表头及行内容居中显示 //gridView1.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gridView1.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; conn.Close(); }
private void showDetail() { gridView1.Columns.Clear(); ConnDB conn = new ConnDB(); string month, group; string table_name = "status"; DataSet ds; month = dateTimePickerMonth.Text.ToString(); group = comboBoxGroup.Text.ToString(); bool success = true; IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@month", month), new SqlParameter("@group", group) }; try { ds = conn.RunProcedure("COST_TEMP_EMPLOYEE_STATUS", parameters, table_name); gridControl1.DataSource = ds.Tables[0].DefaultView; } catch { MessageBox.Show("失败!"); success = false; } if (success) { gridView1.Columns[0].OptionsColumn.ReadOnly = true; gridView1.Columns[1].OptionsColumn.ReadOnly = true; gridView1.Columns[2].OptionsColumn.ReadOnly = true; gridView1.Columns[3].OptionsColumn.ReadOnly = true; gridView1.Columns[4].OptionsColumn.ReadOnly = true; } //表头设置 //gridView1.ColumnPanelRowHeight = 35; //gridView1.OptionsView.AllowHtmlDrawHeaders = true; //gridView1.Appearance.HeaderPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; //表头及行内容居中显示 //gridView1.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gridView1.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; conn.Close(); }
private bool costing() { ConnDB conn = new ConnDB(); string month = dateTimePicker1.Text; string sql; int i, rows; bool isok; bool success = false; isok = CheckData(false); if (isok) { sql = "select * from COST_MONTH_CALCULATE where cmonth ='" + dateTimePicker1.Text.ToString() + "' and sale_type_id = 10"; IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@cmonth", month), new SqlParameter("@saletypeid", "10") }; rows = conn.ReturnRecordCount(sql); if (rows > 0) { MessageBox.Show("该月已经存在成本计算结果,如要重新计算,请先清空该月计算结果!"); } else { try { conn.RunProcedure("costing", parameters, out i); success = true; } catch { MessageBox.Show("失败!"); success = false; } if (success) { MessageBox.Show("计算完成!"); ShowDetail(); } } } conn.Close(); return(success); }
/// <summary> /// 从System.Data.DataTable导入数据到数据库 /// </summary> /// <param name="dt"></param> /// <returns></returns> private int InsertData(DataTable dt) { int i = 0; string cno = ""; string cname = ""; string person_level = ""; ConnDB conn = new ConnDB(); bool err = false; foreach (DataRow dr in dt.Rows) { if (dr["工号"].ToString().Trim() == null || dr["工号"].ToString().Trim() == "") { MessageBox.Show("工号格式有错误!"); err = true; break; } } if (!err) { foreach (DataRow dr in dt.Rows) { cno = dr["工号"].ToString().Trim(); cname = dr["姓名"].ToString().Trim(); person_level = dr["职级"].ToString().Trim(); if (person_level == "操作" || person_level == "操作族") { person_level = "4"; } string sql = string.Format("Insert into COST_DIRECT_LABOUR(CNO,CNAME,PERSON_LEVEL) Values ('{0}','{1}','{2}')", cno, cname, person_level); conn.EditDatabase(sql); i++; } //更新到IHPS_ID_USER_PROFILE,直接执行sql语句,提示分布式错误 //string strsql = "update i set i.e_band = d.PERSON_LEVEL from OPENQUERY (BARCODE, 'SELECT employee_id_,e_band FROM IHPS_ID_USER_PROFILE where department_ like ''制造中心%''') i left join COST_DIRECT_LABOUR d on i.employee_id_ = d.CNO"; IDataParameter[] parameters = new IDataParameter[] { }; conn.RunProcedure("COST_UPDATE_USER_LEVEL", parameters, out i); } conn.Close(); return(i); }
private bool Import() { ConnDB conn = new ConnDB(); string strsql; string month = dateTimePickerMonth.Text; int rows, i; bool success = true; strsql = "select cdate from COST_EMS_HH_HOURS where cdate like '" + dateTimePickerMonth.Text + "%'"; IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@cmonth", month), new SqlParameter("@type", 2) }; rows = conn.ReturnRecordCount(strsql); if (rows > 0) { MessageBox.Show("该月HH产出工时已经存在,要重新导入,请先清空该月数据!"); } else { try { conn.RunProcedure("COST_PRODUCT_IMPORT", parameters, out i); } catch { MessageBox.Show("失败!"); success = false; } if (success) { MessageBox.Show("导入成功!"); //showDetail(); } } conn.Close(); return(success); }
private void simpleButton导出到excel_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string matl, cmonth; matl = "matl"; DataSet ds; cmonth = dateTimePickerMonth.Text.ToString(); IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@cmonth", cmonth) }; try { ds = conn.RunProcedure("COST_MATL_QUERY_LINE", parameters, matl); bool isok = DataSetToExcel(ds, true); if (isok) { MessageBox.Show("导出完成!"); } } catch { MessageBox.Show("失败!"); } }
private void simpleButtonExport_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string cno, dept1, dept2, dept3, dept, status, days, cmonth; days = "days"; //DateTime begin_date, end_date; DataSet ds = new DataSet(); status = comboBoxStatus.SelectedIndex.ToString(); cno = textEditNo.Text.ToString().Trim(); cmonth = dateTimePickerMonth.Text.ToString(); //begin_date = Convert.ToDateTime(dateTimePickerBegin.Text.ToString()); //end_date = Convert.ToDateTime(dateTimePickerEnd.Text.ToString()); dept1 = comboBoxDept1.SelectedValue.ToString(); dept2 = comboBoxDept2.SelectedValue.ToString(); dept3 = comboBoxDept3.SelectedValue.ToString(); dept = comboBoxDept.SelectedValue.ToString(); IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@month", cmonth), new SqlParameter("@cno", cno), new SqlParameter("@dept1", dept1), new SqlParameter("@dept2", dept2), new SqlParameter("@dept3", dept3), new SqlParameter("@dept", dept) }; try { ds = conn.RunProcedure("COST_TEMP_EMPLOYEE_DAYS", parameters, days); } catch { MessageBox.Show("失败!"); } bool isok = Common.DataSetToExcel(ds, true); if (isok) { MessageBox.Show("导出完成!"); } }
private void showDetail() { ConnDB conn = new ConnDB(); string matl, cmonth; matl = "matl"; DataSet ds; cmonth = dateTimePickerMonth.Text.ToString(); bool success = true; IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@cmonth", cmonth) }; try { ds = conn.RunProcedure("COST_MATL_QUERY_LINE", parameters, matl); gridControl1.DataSource = ds.Tables[0].DefaultView; } catch { MessageBox.Show("失败!"); success = false; } if (success) { gridView1.Columns[0].OptionsColumn.ReadOnly = true; gridView1.Columns[1].OptionsColumn.ReadOnly = true; gridView1.Columns[2].OptionsColumn.ReadOnly = true; gridView1.Columns[3].OptionsColumn.ReadOnly = true; gridView1.Columns[4].OptionsColumn.ReadOnly = true; gridView1.Columns[5].OptionsColumn.ReadOnly = true; gridView1.Columns[6].OptionsColumn.ReadOnly = true; gridView1.Columns[2].Visible = false; gridView1.Columns[4].Visible = false; gridView1.Columns[5].Visible = false; //gridView1.Columns[0].OptionsColumn.FixedWidth = true; //gridView1.Columns[0].Width = 40; //gridView1.Columns[1].OptionsColumn.FixedWidth = true; //gridView1.Columns[1].Width = 80; //gridView1.Columns[2].OptionsColumn.FixedWidth = true; //gridView1.Columns[2].Width = 50; //gridView1.Columns[3].OptionsColumn.FixedWidth = true; //gridView1.Columns[3].Width = 80; //gridView1.Columns[4].OptionsColumn.FixedWidth = true; //gridView1.Columns[4].Width = 80; //for (int i = 11; i <= 46; i++) //{ // gridView1.Columns[i].OptionsColumn.FixedWidth = true; // gridView1.Columns[i].Width = 40; //} } ////表头设置 //gridView1.ColumnPanelRowHeight = 35; //gridView1.OptionsView.AllowHtmlDrawHeaders = true; //gridView1.Appearance.HeaderPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; ////表头及行内容居中显示 ////gridView1.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; //gridView1.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; conn.Close(); }
private void showDetail() { ConnDB conn = new ConnDB(); string cno, dept1, dept2, dept3, dept, status, days, cmonth; days = "days"; //DateTime begin_date, end_date; DataSet ds; status = comboBoxStatus.SelectedIndex.ToString(); cno = textEditNo.Text.ToString().Trim(); cmonth = dateTimePickerMonth.Text.ToString(); //begin_date = Convert.ToDateTime(dateTimePickerBegin.Text.ToString()); //end_date = Convert.ToDateTime(dateTimePickerEnd.Text.ToString()); dept1 = comboBoxDept1.SelectedValue.ToString(); dept2 = comboBoxDept2.SelectedValue.ToString(); dept3 = comboBoxDept3.SelectedValue.ToString(); dept = comboBoxDept.SelectedValue.ToString(); bool success = true; //IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@begin", begin_date), new SqlParameter("@end", end_date), new SqlParameter("@cno", cno), new SqlParameter("@dept1", dept1), new SqlParameter("@dept2", dept2), new SqlParameter("@dept3",dept3), new SqlParameter("@dept", dept), new SqlParameter("@status", status) }; IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@month", cmonth), new SqlParameter("@cno", cno), new SqlParameter("@dept1", dept1), new SqlParameter("@dept2", dept2), new SqlParameter("@dept3", dept3), new SqlParameter("@dept", dept) }; try { ds = conn.RunProcedure("COST_TEMP_EMPLOYEE_DAYS", parameters, days); gridControl1.DataSource = ds.Tables[0].DefaultView; } catch { MessageBox.Show("失败!"); success = false; } if (success) { gridView1.Columns[0].OptionsColumn.ReadOnly = true; gridView1.Columns[1].OptionsColumn.ReadOnly = true; gridView1.Columns[2].OptionsColumn.ReadOnly = true; gridView1.Columns[3].OptionsColumn.ReadOnly = true; gridView1.Columns[4].OptionsColumn.ReadOnly = true; gridView1.Columns[5].OptionsColumn.ReadOnly = true; gridView1.Columns[6].OptionsColumn.ReadOnly = true; gridView1.Columns[7].OptionsColumn.ReadOnly = true; gridView1.Columns[8].OptionsColumn.ReadOnly = true; gridView1.Columns[9].OptionsColumn.ReadOnly = true; gridView1.Columns[10].OptionsColumn.ReadOnly = true; gridView1.Columns[0].OptionsColumn.FixedWidth = true; gridView1.Columns[0].Width = 40; gridView1.Columns[1].OptionsColumn.FixedWidth = true; gridView1.Columns[1].Width = 80; gridView1.Columns[2].OptionsColumn.FixedWidth = true; gridView1.Columns[2].Width = 50; gridView1.Columns[3].OptionsColumn.FixedWidth = true; gridView1.Columns[3].Width = 80; gridView1.Columns[4].OptionsColumn.FixedWidth = true; gridView1.Columns[4].Width = 80; for (int i = 11; i <= 46; i++) { gridView1.Columns[i].OptionsColumn.FixedWidth = true; gridView1.Columns[i].Width = 40; } } //表头设置 gridView1.ColumnPanelRowHeight = 35; gridView1.OptionsView.AllowHtmlDrawHeaders = true; gridView1.Appearance.HeaderPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; //表头及行内容居中显示 //gridView1.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gridView1.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; conn.Close(); }
private void showDetail() { ConnDB conn = new ConnDB(); string cno, dept1, dept2, dept3, table_name, cmonth; table_name = "salary"; //DateTime begin_date, end_date; DataSet ds; cno = textEditNo.Text.ToString().Trim(); cmonth = dateTimePickerMonth.Text.ToString(); //begin_date = Convert.ToDateTime(dateTimePickerBegin.Text.ToString()); //end_date = Convert.ToDateTime(dateTimePickerEnd.Text.ToString()); dept1 = comboBoxDept1.SelectedValue.ToString(); dept2 = comboBoxDept2.SelectedValue.ToString(); dept3 = comboBoxDept3.SelectedValue.ToString(); bool success = true; IDataParameter[] parameters = new IDataParameter[] { new SqlParameter("@cmonth", cmonth), new SqlParameter("@cno", cno), new SqlParameter("@dept1", dept1), new SqlParameter("@dept2", dept2), new SqlParameter("@dept3", dept3) }; try { ds = conn.RunProcedure("COST_TEMP_EMPLOYEE_SALARY", parameters, table_name); gridControl1.DataSource = ds.Tables[0].DefaultView; } catch { MessageBox.Show("失败!"); success = false; } if (success) { gridView1.Columns[0].OptionsColumn.ReadOnly = true; gridView1.Columns[1].OptionsColumn.ReadOnly = true; gridView1.Columns[2].OptionsColumn.ReadOnly = true; gridView1.Columns[3].OptionsColumn.ReadOnly = true; gridView1.Columns[4].OptionsColumn.ReadOnly = true; gridView1.Columns[5].OptionsColumn.ReadOnly = true; gridView1.Columns[6].OptionsColumn.ReadOnly = true; gridView1.Columns[7].OptionsColumn.ReadOnly = true; gridView1.Columns[8].OptionsColumn.ReadOnly = true; gridView1.Columns[9].OptionsColumn.ReadOnly = true; gridView1.Columns[10].OptionsColumn.ReadOnly = true; gridView1.Columns[11].OptionsColumn.ReadOnly = true; gridView1.Columns[12].OptionsColumn.ReadOnly = true; gridView1.Columns[13].OptionsColumn.ReadOnly = true; gridView1.Columns[14].OptionsColumn.ReadOnly = true; gridView1.Columns[15].OptionsColumn.ReadOnly = true; gridView1.Columns[16].OptionsColumn.ReadOnly = true; gridView1.Columns[17].OptionsColumn.ReadOnly = true; gridView1.Columns[18].OptionsColumn.ReadOnly = true; gridView1.Columns[19].OptionsColumn.ReadOnly = true; gridView1.Columns[20].OptionsColumn.ReadOnly = true; gridView1.Columns[0].OptionsColumn.FixedWidth = true; gridView1.Columns[3].OptionsColumn.FixedWidth = true; gridView1.Columns[4].OptionsColumn.FixedWidth = true; gridView1.Columns[12].OptionsColumn.FixedWidth = true; gridView1.Columns[12].Width = 70; gridView1.Columns[1].OptionsColumn.FixedWidth = true; gridView1.Columns[1].Width = 50; gridView1.Columns[2].OptionsColumn.FixedWidth = true; gridView1.Columns[2].Width = 50; gridView1.Columns[5].OptionsColumn.FixedWidth = true; gridView1.Columns[5].Width = 50; gridView1.Columns[6].OptionsColumn.FixedWidth = true; gridView1.Columns[6].Width = 50; gridView1.Columns[9].OptionsColumn.FixedWidth = true; gridView1.Columns[9].Width = 50; gridView1.Columns[10].OptionsColumn.FixedWidth = true; gridView1.Columns[10].Width = 50; gridView1.Columns[11].OptionsColumn.FixedWidth = true; gridView1.Columns[11].Width = 50; gridView1.Columns[12].Width = 70; gridView1.Columns[13].OptionsColumn.FixedWidth = true; gridView1.Columns[13].Width = 70; gridView1.Columns[14].OptionsColumn.FixedWidth = true; gridView1.Columns[14].Width = 70; gridView1.Columns[15].OptionsColumn.FixedWidth = true; gridView1.Columns[15].Width = 53; gridView1.Columns[16].OptionsColumn.FixedWidth = true; gridView1.Columns[16].Width = 70; gridView1.Columns[17].OptionsColumn.FixedWidth = true; gridView1.Columns[17].Width = 70; gridView1.Columns[18].OptionsColumn.FixedWidth = true; gridView1.Columns[18].Width = 70; gridView1.Columns[19].OptionsColumn.FixedWidth = true; gridView1.Columns[19].Width = 70; gridView1.Columns[20].OptionsColumn.FixedWidth = true; gridView1.Columns[20].Width = 70; gridView1.Columns[21].OptionsColumn.FixedWidth = true; gridView1.Columns[21].Width = 70; gridView1.Columns[22].OptionsColumn.FixedWidth = true; gridView1.Columns[22].Width = 70; gridView1.Columns[23].OptionsColumn.FixedWidth = true; gridView1.Columns[23].Width = 70; gridView1.Columns[24].OptionsColumn.FixedWidth = true; gridView1.Columns[24].Width = 70; gridView1.Columns[25].OptionsColumn.FixedWidth = true; gridView1.Columns[25].Width = 70; gridView1.Columns[26].OptionsColumn.FixedWidth = true; gridView1.Columns[26].Width = 70; gridView1.Columns[27].OptionsColumn.FixedWidth = true; gridView1.Columns[27].Width = 70; gridView1.Columns[28].OptionsColumn.FixedWidth = true; gridView1.Columns[28].Width = 70; gridView1.Columns[29].OptionsColumn.FixedWidth = true; gridView1.Columns[29].Width = 70; gridView1.Columns[30].OptionsColumn.FixedWidth = true; gridView1.Columns[30].Width = 70; gridView1.Columns[31].OptionsColumn.FixedWidth = true; gridView1.Columns[31].Width = 70; gridView1.Columns[32].OptionsColumn.FixedWidth = true; gridView1.Columns[32].Width = 70; } //表头设置 gridView1.ColumnPanelRowHeight = 35; gridView1.OptionsView.AllowHtmlDrawHeaders = true; gridView1.Appearance.HeaderPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap; //表头及行内容居中显示 //gridView1.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gridView1.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; conn.Close(); }