![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DevExpress
郑先生Ethan
该博主比较懒,闲着无聊会更新
展开
-
C# winform 过滤条件
图列代码 //加载数据(时间用的dev的dateEdit) private void GetData() { try { if (MyHelper.IsConn()) { string strEmpName = txtEmpName.Text.Trim(); stri原创 2022-02-24 08:53:30 · 370 阅读 · 0 评论 -
C# menuStrip 配置
双击事件(隐藏功能) private void menuStrip1_DoubleClick(object sender, EventArgs e) { if (toolStripMenuItem20.Visible == true) { toolStripMenuItem20.Visible = false; return; }原创 2021-09-29 23:03:02 · 253 阅读 · 0 评论 -
C# gridview控件设置
gridView1.OptionsView.RowAutoHeight = true //自动适应行高gridView1.OptionsView .ShowIndicator=False //隐藏、显示最左列gridView1.OptionsView.ColumnAutoWidth = False //自动调整宽度gridView1.OptionsBehavior.CopyToClipboardWithColumnHeaders = False //复制粘贴行,单元格.原创 2021-09-29 23:02:29 · 297 阅读 · 0 评论 -
C# form.close 返回值
窗口2this.DialogResult = DialogResult.OK;this.Close();窗口1按钮private void Setting_Click(object sender, EventArgs e) { Setting f1 = new Setting(); f1.ShowDialog(); ConfigurationManager.RefreshSection("appSetting原创 2021-09-29 23:01:56 · 750 阅读 · 0 评论 -
C# for循环创建数组
#region 获取数组//将dt stockid字段数据传进listList<int> liststock = new List<int>();for (int i = 0; i < dtStock.Rows.Count; i++){ liststock.Add(int.Parse(dtStock.Rows[i]["FSTOCKID"].ToString()));}List<int> listNew = new List<int>(原创 2021-09-29 23:00:22 · 2319 阅读 · 0 评论 -
C# Dev 多级表头
界面c# 代码设置using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using DevExpress.XtraEditors.R原创 2021-09-29 22:59:40 · 1046 阅读 · 0 评论 -
C# dt排序
#region 补全12个月数据并排序for (int m = 1; m <= 12; m++){ //月份需补全0才能正确排序 String monthname; if (m < 10) { monthname = "0" + m.ToString() + "月"; } else { monthname = m.ToString() + "月"; } //判断是否存在,不存在插入一行原创 2021-09-29 22:58:06 · 327 阅读 · 0 评论 -
C# ChartControl
Line //获取折线图数据方法 [Obsolete] public void GetDataLine(string OrganizationName, int year,int month) { /*传入参数 OrganizationName //组织名称 year //年份 month //超出月份 */原创 2021-09-29 22:57:21 · 870 阅读 · 0 评论 -
C# 筛选时间
dateEdit控件原创 2021-09-29 22:55:24 · 255 阅读 · 0 评论 -
C# app.config方法
c#方法 //appconfig方法 #region config操作 private static Configuration config = System.Configuration.ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); public static string GetAppSetting(string key) {原创 2021-09-29 22:54:27 · 677 阅读 · 2 评论 -
C# 隐藏按钮,鼠标移动显示
设置鼠标移动事件(鼠标移动显示)//定时事件private void timerRoll_Tick(object sender, EventArgs e){ timerRoll.Interval = 3000; Setting.Visible = false; Exit.Visible = false;}//鼠标移动显示按钮private void gridControl1_MouseMove(object sender, MouseEventArgs e){原创 2021-09-29 22:52:14 · 521 阅读 · 0 评论 -
C# 选中行
选中行FID//选中行的FIDpublic string GSR_Fid(){ //MessageBox.Show(Row_zhi); int selectRow = gridView1.GetSelectedRows()[0]; string Row_zhi = this.gridView1.GetRowCellValue(selectRow, "FID").ToString();//获取第一个单元格的值 return Row_zhi;}...原创 2021-09-29 22:51:18 · 296 阅读 · 0 评论 -
C# 序列号
序号自动生成//序号自动生成/// <summary>/// 说明:序号自动生成。/// </summary>private void gridView1_CustomDrawRowIndicator(object sender, DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs e){ if (e.Info.IsRowIndicator && e.RowHandle原创 2021-09-29 22:50:20 · 824 阅读 · 0 评论 -
C# 修改label字体(字体、大小、样式)
status.Font = new Font("宋体", 20, FontStyle.Bold); //第一个是字体,第二个大小,第三个是样式status.ForeColor = Color.Red; //颜色 status.Text = "扫描的条码为派工单号!";return;原创 2021-09-29 22:45:33 · 12850 阅读 · 0 评论 -
C# 修改行(弹窗)
formusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using DevExpress.XtraEditors;using System.Data.SqlClient;using System.Reflection;n原创 2021-09-29 22:43:52 · 216 阅读 · 0 评论 -
C# 新增行变色,设置列背景色
//新增行变色,设置列背景色 private void gridView1_RowCellStyle(object sender, RowCellStyleEventArgs e) { try { GridView currentView = sender as GridView; DataRow row = this.gridView1.GetDa...原创 2021-09-29 22:41:37 · 446 阅读 · 0 评论 -
C# 新增行(弹窗)
form源码using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using DevExpress.XtraEditors;using System.Data.SqlClient;using System.Reflection原创 2021-09-12 17:03:19 · 236 阅读 · 0 评论 -
C# 新增行
//新增一行private void insert_Click(object sender, EventArgs e){ try { DataTable dt = (DataTable)gridControl1.DataSource; if (dt != null) { if (dt.Rows.Count > 80) { MessageBox.Show("原创 2021-09-12 17:02:17 · 391 阅读 · 0 评论 -
C# 下拉框 datasource
//GridView下拉框string sql11 = "select FTaskMach 班组 from m_task_001";DataTable dt22 = BHWS.MExecSQL(MyHelper.strVerify, MyHelper.strIP, "", MyHelper.strProjName + "-" + this.AccessibleName, MyHelper.strUser, sql11);RepositoryItemSearchLookUpEdit RepItem4 =原创 2021-09-12 17:01:23 · 562 阅读 · 0 评论 -
C# 下拉框 Conbobox
//筛选数据旧 string comboboxnameold=null; //筛选数据新 string comboboxnamenew; //加载conbobox数据 My_Conbobox(); //定时器定时刷新时间(获取选择数据) private void timerclock_Tick(object sender, EventArgs e) {...原创 2021-09-12 17:00:39 · 861 阅读 · 0 评论 -
C# 无边框
C# 有两种办法1.代码中加 form1.FormBorderStyle = FormBorderStyle.None;//无边框2.在窗本属性栏找FormBorderStyle选择nonec#关闭FormBorderStyle private void Form1_Load(object sender, EventArgs e) { this.FormBorderStyle = FormBorderStyle.None;//无边框原创 2021-09-12 16:59:16 · 824 阅读 · 0 评论 -
C# 退出
//退出private void ExitToolStripMenuItem_Click(object sender, EventArgs e){ this.Close(); //关窗口 //Application.Exit(); //退程序}原创 2021-09-12 16:57:51 · 97 阅读 · 0 评论 -
C# 停止编辑带出信息
//停止编辑后带出信息功能private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e){ DataRow row = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle); if (row["FID"].ToString() != "") {原创 2021-09-12 16:57:12 · 109 阅读 · 0 评论 -
C# 时间
//定时器定时刷新时间(记得开启定时器)private void timerclock_Tick(object sender, EventArgs e){ timerclock.Interval = 1000; //1000代表1秒 //这里用的label框体 time1.Text = DateTime.Now.ToString("HH:mm:ss"); time2.Text = DateTime.Now.ToString("yyyy/MM/dd"原创 2021-09-12 16:55:55 · 123 阅读 · 0 评论 -
C# 设置框体位置
//winform框体private void frmReport_Load(object sender, EventArgs e){ //设置框体位置 label1.Left = (panelControl1.Width - label1.Width) / 2; label1.Top = (panelControl1.Height - label1.Height) / 3; panel1.Left = panelControl1.Width - panel1.Width原创 2021-09-12 16:54:58 · 119 阅读 · 0 评论 -
C# 删除行(弹窗)
form源码using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using DevExpress.XtraEditors;using System.Data.SqlClient;using System.Reflection原创 2021-09-12 16:53:50 · 490 阅读 · 0 评论 -
C# 删除行
//删除一行private void delete_Click(object sender, EventArgs e){ try { SqlConnection conn = new SqlConnection(DRIVER); conn.Open(); SqlDataAdapter daAuthors = new SqlDataAdapter(sql_select, conn); DataSet dsPubs = new原创 2021-09-12 16:52:34 · 1251 阅读 · 0 评论 -
C# 全选checkbox
//全选方法private void checkBoxAll_CheckStateChanged(object sender, EventArgs e){ //判断checkbox是否被选中 if (checkBoxAll.CheckState == CheckState.Checked) { checkBoxQQ.Checked = true; checkBoxWechat.Checked = true; checkBoxDIng原创 2021-09-12 16:51:39 · 748 阅读 · 0 评论 -
C# 清除
//清除private void clean_Click(object sender, EventArgs e){ if (textFName.Text.ToString() != "") { textFName.Text = ""; } if (textFNumber.Text.ToString() != "") { textFNumber.Text = ""; } if (textSName.Text.ToStr原创 2021-09-12 16:50:44 · 253 阅读 · 0 评论 -
C# 启动程序
Process p = new Process();if (checkBoxQQ.CheckState==CheckState.Checked){ //QQ p.StartInfo.FileName = "" + PATHqq.Text + ""; try { p.Start(); } catch (Exception ex) { MessageBox.Show("没有找到QQ程序" + ex); }}原创 2021-09-12 16:50:00 · 71 阅读 · 0 评论 -
C# 判断dt是否存在某个数据
//判断是否存在,不存在插入一行 DataRow[] dataRows = dt.Select("月份" + "='" + monthname + "'"); if (dataRows.Length > 0) { continue; } else { DataRow newRow = dt.NewRow(); newRow["FNAME"] = dt.Rows[0][0]; newRow["FSTOCKID"] = dt.Rows[0][1]; .原创 2021-09-12 16:49:17 · 1129 阅读 · 0 评论 -
C# 判断是否为回车
if (e.KeyCode.ToString() == "Return"){ if (txtValue.Text.Trim() == "") { txtValue.Text = ""; MessageBox.Show("请扫描有效条码!"); return; } else { string FCode = txtValue.Text原创 2021-09-12 16:48:28 · 2208 阅读 · 0 评论 -
c# 列显示设置
c# MESprivate void button3_Click(object sender, EventArgs e){ DataTable dt = (DataTable)gridControl1.DataSource; if (dt == null) { MessageBox.Show("请先获取数据!", "系统提示"); return; } string strPage = "MES_BR_" + strFuncNumbe原创 2021-09-12 16:47:29 · 307 阅读 · 0 评论 -
C# 列变色RGB
源码 //列变色(在数据库中添加列"背景颜色") private void gridView1_RowCellStyle(object sender, RowCellStyleEventArgs e) { try { if (gridView1.Columns.Contains(gridView1.Columns["背景颜色"])) {原创 2021-09-12 16:42:04 · 62 阅读 · 0 评论 -
C# 连接数据库,查询数据
//获取数据private void GetData(){ //查询条件 int day11,day12,day21,day22,month; day11 = 61; day12 = 90; //时间段1 day21 = 91; day22 = 180; //时间段2 month = 6; //时间段3 try { //连接字符串 string connectString = "Data Source=192.168原创 2021-09-12 16:39:25 · 1655 阅读 · 0 评论 -
C# 键盘事件
//按ESC提示是否退出protected override bool ProcessCmdKey(ref Message msg, Keys keyData){ int WM_KEYDOWN = 256; int WM_SYSKEYDOWN = 260; if (msg.Msg == WM_KEYDOWN | msg.Msg == WM_SYSKEYDOWN) { switch (keyData) { case K原创 2021-09-12 16:36:45 · 633 阅读 · 0 评论 -
C# 横向合并
方法1(表格线仍在)using System;using System.Collections.Generic;using System.Linq;using DevExpress.XtraGrid.Columns;using DevExpress.XtraGrid.Views.Grid;using System.Drawing;using DevExpress.XtraGrid.Views.Grid.ViewInfo;using DevExpress.XtraGrid.Views.Base原创 2021-09-06 09:32:02 · 393 阅读 · 0 评论 -
C# 合计
源码#region 添加合计行,计算每列数据//合计行DataRow dr = dtNew.NewRow();dr["仓库名称"] = "合计";for (int j = 1; j < dt.Columns.Count; j++){ float value = 0; //单个数据值 float sum = 0; //数据总和 string returnstr = ""; //列字段返回值 int k = 0; //当前列数 string st原创 2021-09-04 12:48:42 · 233 阅读 · 0 评论 -
C# 合并单元格
gridview事件CellMerge 单元格合并合并列 //合并(在查询中开启 bandedGridView1.OptionsView.AllowCellMerge = true;) private void gridView1_CellMerge(object sender, CellMergeEventArgs e) { int rowHandle1 = e.RowHandle1; int rowHa原创 2021-09-04 12:47:29 · 1526 阅读 · 0 评论 -
C# 滚动
定时器设置滚动事件拉取控件定时器 Timer源码 //开启定时器 timerScroll.Start(); //定时器定时滚动事件(在查询中开启) private void timerScroll_Tick(object sender, EventArgs e) { timerScroll.Interval = 2000; if (gridView原创 2021-09-04 12:45:44 · 157 阅读 · 0 评论