public static List<Emp_Salary> Emp_Salary_Select(string SalaryName, int State)
       {
           List<Emp_Salary> list = new List<Emp_Salary>();

           using (SqlCeConnection con = new SqlCeConnection(Data_Share.LocalConStr))
           {
               con.Open();

               SqlCeCommand com = con.CreateCommand();
               com.CommandType = CommandType.Text;
               com.Connection = con;

               string SQL = @"SELECT [ESID]
      ,[ESName]
      ,[ESValue]
      ,[ESunitPrice]
      ,[ESDesc]
      ,[ESetUser]
      ,[ESetTime]
      ,[ESState]
      ,[EEndUser]
      ,[EEndTIme]
  FROM [TBL_EmployeeSalary]
  WHERE 1=1";
               if (!string.IsNullOrEmpty(SalaryName))
               {
                   SQL += " and [ESName] like ('%'+@ESName+'%')";
                   com.Parameters.Add("@ESName", DbType.String);
                   com.Parameters["@ESName"].Value = SalaryName;
               }

               if (State >= 0)
               {
                   SQL += " and [ESState]=@ESState";
                   com.Parameters.Add("@ESState", DbType.Boolean);
                   com.Parameters["@ESState"].Value = State == 1;
               }

               com.CommandText = SQL;
               using (IDataReader ireader = com.ExecuteReader())
               {
                   Guid gd_tp = default(Guid);
                   double db_tp = 0D;
                   DateTime dt_tp = default(DateTime);
                   bool bl_tp = false;
                   while (ireader.Read())
                   {
                       Emp_Salary salary = new Emp_Salary();
                       salary.ESID = Guid.TryParse(ireader["ESID"].ToString(),out gd_tp) ? gd_tp : default(Guid);
                       salary.ESName = ireader["ESName"].ToString();
                       salary.ESValue = double.TryParse(ireader["ESValue"].ToString(), out db_tp) ? db_tp : 0D;
                       salary.ESUnitPrice = ireader["ESunitPrice"].ToString();
                       salary.ESDesc = ireader["ESDesc"].ToString();
                       salary.ESetUser = Data_SysUser.Sys_User_SelectSingle(Guid.TryParse(ireader["ESetUser"].ToString(), out gd_tp) ? gd_tp : default(Guid));
                       salary.ESetTime = DateTime.TryParse(ireader["ESetTime"].ToString(), out dt_tp) ? dt_tp : default(DateTime);
                       salary.ESState = bool.TryParse(ireader["ESState"].ToString(), out bl_tp) ? bl_tp : false;
                       salary.EEndUser = Data_SysUser.Sys_User_SelectSingle(Guid.TryParse(ireader["EEndUser"].ToString(), out gd_tp) ? gd_tp : default(Guid));
                       salary.EEndTime = DateTime.TryParse(ireader["EEndTIme"].ToString(), out dt_tp) ? dt_tp : default(DateTime);
                       list.Add(salary);
                   }
                   ireader.Close();
               }



               con.Close();
            }

           return list;
       }

--USE [Sync_ProjectManagementDB]
--GO
/****** 对象:  Table [dbo].[TBL_EmployeeSalary]    脚本日期: 05/19/2012 17:00:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
--newsequentialid()  SQL 2005 sp2中才有该函数
CREATE TABLE [dbo].[TBL_EmployeeSalary](
    [ESID] [uniqueidentifier] NOT NULL DEFAULT (newsequentialid()),
    [ESName] [varchar](50) NULL,
    [ESValue] [money] NULL,
    [ESunitPrice] [varchar](20) NULL,
    [ESDesc] [varchar](200) NULL,
    [ESetUser] [uniqueidentifier] NULL,
    [ESetTime] [datetime] NULL,
    [ESState] [bit] NULL,
    [EEndUser] [uniqueidentifier] NULL,
    [EEndTIme] [datetime] NULL,
    [LastEditDate] [datetime] NULL CONSTRAINT [DF_TBL_EmployeeSalary_LastEditDate]  DEFAULT (getutcdate()),
    [CreationDate] [datetime] NULL CONSTRAINT [DF_TBL_EmployeeSalary_CreationDate]  DEFAULT (getutcdate()),
PRIMARY KEY CLUSTERED 
(
    [ESID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
--SET ANSI_PADDING OFF
--GO
--ALTER TABLE [dbo].[TBL_EmployeeSalary]  WITH CHECK ADD  CONSTRAINT [FK_TBL_EmployeeSalary_TBL_SysUser_EEndUSer] FOREIGN KEY([EEndUser])
--REFERENCES [dbo].[TBL_SysUser] ([UNID])
--GO
--ALTER TABLE [dbo].[TBL_EmployeeSalary] CHECK CONSTRAINT [FK_TBL_EmployeeSalary_TBL_SysUser_EEndUSer]
--GO
--ALTER TABLE [dbo].[TBL_EmployeeSalary]  WITH CHECK ADD  CONSTRAINT [FK_TBL_EmployeeSalary_TBL_SysUser_ESetUser] FOREIGN KEY([ESetUser])
--REFERENCES [dbo].[TBL_SysUser] ([UNID])
--GO
--ALTER TABLE [dbo].[TBL_EmployeeSalary] CHECK CONSTRAINT [FK_TBL_EmployeeSalary_TBL_SysUser_ESetUser]

SELECT [ESID]
      ,[ESName]
      ,[ESValue]
      ,[ESunitPrice]
      ,[ESDesc]
      ,[ESetUser]
      ,[ESetTime]
      ,[ESState]
      ,[EEndUser]
      ,[EEndTIme]
  FROM [TBL_EmployeeSalary]
  WHERE 1=1 and [ESName] like ('%'+@ESName+'%')