摘要：
/// <param name="tbs">树形结构数据源</param> /// <param name="idFaildName">梆定列的Key</param> /// <param name="catFaildName">梆定列的Value</param> /// <param name="parentFaild... 阅读全文
posted @ 2009-06-08 18:10 pony 阅读(323) 评论(1) 推荐(0)
摘要：
1.新建一个winform窗体,将CrystalReportViewer控件拖到窗体中.2.winform窗体后台代码如下:在项目解决方案中新增报表文件(.rpt文件)using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;usi... 阅读全文
posted @ 2007-08-11 09:31 pony 阅读(1060) 评论(3) 推荐(0)
摘要：
/// /// 分割字符串,分割后的字符串以数组的方法返回 /// public static string[] Split(string str, string spliter) { ArrayList list = new ArrayList(); while (str.I... 阅读全文
posted @ 2007-08-11 08:36 pony 阅读(375) 评论(4) 推荐(0)
摘要：
private void txt_Ecardforegift_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar '9') { e.Handled = true; } } 选择TextBo... 阅读全文
posted @ 2007-08-11 08:27 pony 阅读(386) 评论(4) 推荐(0)
摘要：
--年月报表create proc YMViewReport@bm varchar(2), ----部门编号@year varchar(4), ----要查询的年 @m... 阅读全文
posted @ 2007-06-12 00:50 pony 阅读(469) 评论(2) 推荐(0)
摘要：
create procedure SearchUnconvent@bm varchar(2), --部门编号@bh varchar(8), --人员编号@xm varchar(24), ... 阅读全文
posted @ 2007-06-12 00:40 pony 阅读(246) 评论(0) 推荐(0)
摘要：
Id EquipmentNo Type EspecialMark 1 ECB23232 A Mark12 ECB23323 B Mark23 ECB23545 C Mark14 ECB23454 C Mark3 Type A B C..............EspecialMarkMark1 1 1 0Mark2 0 1 0 Mark3 0 0 1 create table #T(Id i... 阅读全文
posted @ 2007-06-12 00:35 pony 阅读(144) 评论(1) 推荐(0)
摘要：
create function TranData(@InTime varchar(8))returns varchar(8)asbegin declare @OutTime varchar(8) if (left(@InTime,1)'0') begin select @OutTime=left(@InTime,2)+right(@InTime,2) end else begin if(sub... 阅读全文
posted @ 2007-06-12 00:34 pony 阅读(150) 评论(0) 推荐(0)
摘要：
--得到部门和员工姓名create function dbo.GetTreeInfo(@Employe_Number as varchar(10) -----员工编号)returns @TreeInformation table(Employe_Number varchar(10) not null, ... 阅读全文
posted @ 2007-06-12 00:31 pony 阅读(266) 评论(1) 推荐(0)
摘要：
create proc Add_p_OrdersId@p_OrdersId varchar(20) outputasselect @p_OrdersId='po060000'+convert(varchar(3),cast(right(max(right(p_OrdersId,3)),3)as int)+1) from p_Ordersprint @p_OrdersIdgo --自动增长部门编号c... 阅读全文
posted @ 2007-06-12 00:26 pony 阅读(191) 评论(1) 推荐(0)
浙公网安备 33010602011771号