摘要：
sqlcode sqlstate 说明 000 00000 SQL语句成功完成 01xxx SQL语句成功完成，但是有警告 +012 01545 未限定的列名被解释为一个有相互关系的引用 +098 01568 动态SQL语句用分号结束 +100 02000 没有找到满足SQL语句的行 +110 01 阅读全文
posted @ 2024-07-19 16:55
Wangbin0007
阅读(55)
评论(0)
推荐(0)
摘要：
SELECT TBNAME,NAME,REMARKS FROM SYSIBM.SYSCOLUMNS WHERE REMARKS IN ('出口厚度','厚度负公差','厚度正公差','厚度补偿值') AND TBNAME='TQMTOMA12' 阅读全文
posted @ 2024-07-19 16:40
Wangbin0007
阅读(10)
评论(0)
推荐(0)
摘要：
EP.GeneralPrintReport myPrintReport = new EP.GeneralPrintReport(); //获取默认打印机 //string printname = myPrintReport.GetCurrentPrinterName(); int num = 2;/ 阅读全文
posted @ 2024-07-19 16:39
Wangbin0007
阅读(12)
评论(0)
推荐(0)
摘要：
private void gridView1_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e) { if (e.Column.FieldName == "SPARE_ITEM_6") { str 阅读全文
posted @ 2024-07-19 16:39
Wangbin0007
阅读(20)
评论(0)
推荐(0)
摘要：
private void gridView2_RowStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowStyleEventArgs e) { try { if (gridView2.GetDataRow(e.RowHandle) == nu 阅读全文
posted @ 2024-07-19 16:38
Wangbin0007
阅读(39)
评论(0)
推荐(0)
摘要：
EFX.EFCGrid.GetEFCGridBase(efDevGrid_Q).SetGridCellValue(0, "TIME_FROM", System.DateTime.Now.AddDays(-Convert.ToInt32(System.DateTime.Now.Day) + 1)); 阅读全文
posted @ 2024-07-19 16:37
Wangbin0007
阅读(19)
评论(0)
推荐(0)
摘要：
this.gridView1.OptionsCustomization.AllowQuickHideColumns = false;//禁止列隐藏 this.efDevGrid1.ShowSelectionColumn = true; //设置选择是否可见 this.efDevGrid1.ShowC 阅读全文
posted @ 2024-07-19 16:36
Wangbin0007
阅读(11)
评论(0)
推荐(0)
摘要：
insert into TMMBWSM01 SELECT REC_CREATOR, REC_CREATE_TIME, REC_REVISOR, REC_REVISE_TIME, REC_ERASOR, REC_ERASE_TIME, ARCHIVE_FLAG, ARCHIVE_STAMP_NO, C 阅读全文
posted @ 2024-07-19 16:36
Wangbin0007
阅读(47)
评论(0)
推荐(0)
摘要：
insert into TMMBW01 SELECT REC_CREATOR, REC_CREATE_TIME, REC_REVISOR, REC_REVISE_TIME, REC_ERASOR, REC_ERASE_TIME, ARCHIVE_FLAG, ARCHIVE_STAMP_NO, COM 阅读全文
posted @ 2024-07-19 16:35
Wangbin0007
阅读(51)
评论(0)
推荐(0)
摘要：
1、 WITH T AS ( SELECT ( SELECT CODE_DESC_1_CONTENT FROM TEP0002 WHERE CODE_CLASS = 'MMKH2' AND CODE = SGP1Z1.TMMSMASS.DUTY_UNIT) AS DUTY_UNIT, DUTY_US 阅读全文
posted @ 2024-07-19 16:34
Wangbin0007
阅读(12)
评论(0)
推荐(0)
浙公网安备 33010602011771号