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