摘要: SELECT NVL(COLUMN1,'') || NVL(COLUMN2,'') AS TEST from TABLE1 阅读全文
posted @ 2017-07-11 15:42 jep 阅读(502) 评论(0) 推荐(0) 编辑
摘要: table tbody { display: block; height: 195px; overflow-y: scroll; } table thead, tbody tr { display: table; width: 100%; table-layout: fixed; } table t 阅读全文
posted @ 2017-06-23 17:31 jep 阅读(2847) 评论(0) 推荐(0) 编辑
摘要: const int WM_PARENTNOTIFY = 0x210; const int WM_LBUTTONDOWN = 0x201; protected override void WndProc(ref Message m) { if (m.Msg == WM_LBUTTONDOWN || ( 阅读全文
posted @ 2017-06-19 14:36 jep 阅读(213) 评论(2) 推荐(0) 编辑
摘要: public DataTable IListOut(IList<excelModel> _list) { DataTable dtReturn = new DataTable(); PropertyInfo[] oProps = null; foreach (excelModel rec in _l 阅读全文
posted @ 2017-06-19 14:02 jep 阅读(103) 评论(0) 推荐(0) 编辑
摘要: public class ConvertHelper<T> where T : new() { public static IList<T> ConvertToModel(DataTable dt) { // 定义集合 IList<T> ts = new List<T>(); // 获得此模型的类型 阅读全文
posted @ 2017-06-19 14:01 jep 阅读(135) 评论(0) 推荐(0) 编辑
摘要: public DataTable GetDgvToTable(DataGridView dgv) { DataTable dt = new DataTable(); for (int count = 0; count < dgv.Columns.Count; count++) { DataColum 阅读全文
posted @ 2017-06-16 10:02 jep 阅读(306) 评论(0) 推荐(0) 编辑