private void btnDelDetail_Click(object sender, EventArgs e) { if (edtMemo.Visible) { if (MessageBox.Show("是否确定删除内容?", "注意", MessageBoxButtons.YesNo) == DialogResult.Yes) { edtMemo.Text = ""; } } else if (gridControlGrid.Visible) { if (gridMain.SelectedRowsCount <= 0) { MessageBox.Show("请选择要删除的行!"); return; } if (gridMain.FocusedRowHandle > -1) { int lHandel = gridMain.FocusedRowHandle; detailView _lInfo = this.mainView[this.gridMain.GetDataSourceRowIndex(lHandel)]; if (MessageBox.Show("是否确定删除该行内容(代码值" + _lInfo.code + ",属性值" + _lInfo.name + ")?", "注意", MessageBoxButtons.YesNo) == DialogResult.Yes) { mainView.Remove(_lInfo); this.gridControlGrid.DataSource = mainView; this.gridControlGrid.RefreshDataSource(); btnSave.PerformClick(); } } } }
private void btnAddDetail_Click(object sender, EventArgs e) { //如果是表格形式 if (gridControlGrid.Visible) { fmEnterContent frmCon = new fmEnterContent(); frmCon.ShowDialog(); if (frmCon.DialogResult == DialogResult.OK) { string strValue = frmCon.StrValue; string strName = frmCon.StrName; string strMemo = frmCon.StrMemo; string strDetail = frmCon.StrDetail; List <detailView> dataList = new List <detailView>(); detailView item = new detailView(); item.code = strValue; item.name = strName; item.note = strMemo; item.detail = strDetail; dataList.Add(item); addDataToView(dataList, false); //直接保存 btnSave.PerformClick(); } } if (edtMemo.Visible) { edtMemo.Enabled = true; } }
private void ShowToolTipsGrid() { toolinfo = new ToolTipControllerShowEventArgs(); detailView detailData = gridMain.GetFocusedRow() as detailView; if (detailData != null) { toolinfo.AllowHtmlText = DefaultBoolean.True; toolinfo.ToolTip = NewLineStr(detailData.detail.Replace('#', '\r').Replace('^', '\n'), 50); toolinfo.Rounded = true; //圆角 toolinfo.RoundRadius = 7; //圆角率 toolinfo.ToolTipType = ToolTipType.Standard; SetToolTipsSetting(toolinfo, pubDefines.toolTipsType.type_GridDetail); if (toolinfo.Title != "" || toolinfo.ToolTip != "") { Point pLocate = new Point(MousePosition.X, MousePosition.Y); // 0,0 是左上角 //pLocate = gridControlGrid.PointToScreen(pLocate); // p.X, p.Y 是控件左上角在屏幕上的坐标 SetToolTipsControllerSetting(toolTipControllerGrid, pubDefines.toolTipsType.type_GridDetail); if (toolinfo.ToolTip != "") { toolTipControllerGrid.ShowHint(toolinfo, pLocate); } else { toolTipControllerGrid.HideHint(); } } } }
/// <summary> /// 显示grid的内容 /// </summary> private void ShowGridContent() { string msg = string.Empty; #region 显示grid中的内容 string aaa = ""; try { string gridPath = Directory.GetFiles(pubDefines.allPathDefine.mainSavePath, "grid_" + listMain.SelectedItem.ToString() + ".txt").FirstOrDefault(); if (gridPath != "") { string[] contents = { }; contents = pubFunction.ReadContentFromTxtAll(gridPath, out msg); if (!string.IsNullOrWhiteSpace(msg)) { //MessageBox.Show("内容加载失败!" + msg); mainView.Clear(); gridControlGrid.DataSource = mainView; gridControlGrid.RefreshDataSource(); return; } else { mainView.Clear(); foreach (string detail in contents) { string[] strCont = detail.Split('\t'); detailView item = new detailView(); aaa = strCont[0].ToString(); item.code = strCont[0].ToString(); item.name = strCont[1].ToString(); item.note = strCont[2].ToString(); if (strCont.Length > 3) { item.detail = (strCont[3] ?? "").ToString(); } mainView.Add(item); } gridControlGrid.DataSource = mainView; gridControlGrid.RefreshDataSource(); } } } catch (Exception ex) { MessageBox.Show(ex.Message + "," + aaa); gridControlGrid.DataSource = null; gridControlGrid.RefreshDataSource(); return; } #endregion }
private void btnExcel_Click(object sender, EventArgs e) { if (listMain.SelectedItem != null) { //打开excel选择框 OpenFileDialog frm = new OpenFileDialog(); frm.Filter = "Excel文件(*.xls,xlsx)|*.xls;*.xlsx"; if (frm.ShowDialog() == DialogResult.OK) { string excelName = frm.FileName; DataTable dt = AsPoseHelper.ExcelToDataTable(excelName, null, false, false); if ((dt != null) && (dt.Rows.Count > 0)) { List <detailView> dataList = new List <detailView>(); for (int i = 0; i < dt.Rows.Count - 1; i++) { string strValue = dt.Rows[i][0].ToString(); string strName = dt.Rows[i][1].ToString(); string strMemo = dt.Rows[i][2].ToString(); string strDetail = (dt.Rows[i][3] ?? "").ToString(); detailView item = new detailView(); item.code = strValue; item.name = strName; item.note = strMemo; item.detail = strDetail; dataList.Add(item); } if (System.Windows.Forms.MessageBox.Show("是否覆盖现有的数据?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { addDataToView(dataList, true); } else { addDataToView(dataList, false); } //直接保存 btnSave.PerformClick(); } } } else { MessageBox.Show("请选择一个项目"); return; } }
/// <summary> /// excel导入的数据添加到grid中 /// </summary> /// <param name="dataDetailList">数据</param> /// <param name="isFold">是否覆盖</param> private void addDataToView(List <detailView> dataDetailList, bool isFold = false) { if (isFold) { mainView.Clear(); } for (int i = 0; i < dataDetailList.Count; i++) { detailView detail = new detailView(); detail.code = dataDetailList[i].code; detail.name = dataDetailList[i].name; detail.note = dataDetailList[i].note; detail.detail = dataDetailList[i].detail; mainView.Add(detail); } this.gridControlGrid.DataSource = mainView; this.gridControlGrid.RefreshDataSource(); }
private void btnUpdateByDataBase_Click(object sender, EventArgs e) { if (gridControlGrid.Visible) { MyKeyValueSetting currSetting; fmDataBase frm = new fmDataBase(); frm.ShowDialog(); if (frm.DialogResult == DialogResult.OK) { currSetting = frm.currConnection; try { SqlConnection con = new SqlConnection(); con.ConnectionString = currSetting.ConnectString; con.Open(); string[] tableArray = currSetting.table.Split(';'); string[] fieldArray = currSetting.column.Split(';'); string sSql = string.Empty; for (int i = 0; i < tableArray.Length; i++) { sSql += "select " + fieldArray[i] + " from " + tableArray[i] + "\r\n"; sSql += "union" + "\r\n"; } if (!string.IsNullOrEmpty(sSql)) { sSql = sSql.Substring(0, sSql.Length - 7); } SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = sSql; SqlDataReader dr = com.ExecuteReader();//执行SQL语句 List <detailView> dataList = new List <detailView>(); while (dr.Read()) { string strValue = dr.IsDBNull(0) ? "" : dr.GetValue(0).ToString(); string strName = dr.IsDBNull(1) ? "" : dr.GetValue(1).ToString(); string strMemo = dr.IsDBNull(2) ? "" : dr.GetValue(2).ToString(); string strDetail = dr.IsDBNull(3) ? "" : dr.GetValue(3).ToString(); detailView item = new detailView(); item.code = strValue; item.name = strName; item.note = strMemo.Replace('\t', ' ').Replace('\r', '#').Replace('\n', '^'); item.detail = strDetail.Replace('\t', ' ').Replace('\r', '#').Replace('\n', '^'); dataList.Add(item); } dr.Close(); //关闭执行 con.Close(); //关闭数据库 if (System.Windows.Forms.MessageBox.Show("是否覆盖现有的数据?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { addDataToView(dataList, true); } else { addDataToView(dataList, false); } //直接保存 btnSave.PerformClick(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } else { fmDataBase frm = new fmDataBase(false); frm.ShowDialog(); } }