OA.DAL/ManualSignService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

//============================================================
// Producnt name:		TenXiang.Code
// Coded by:			hotboart
// Auto generated at: 	2014/1/5 11:46:50
//============================================================



using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using OA.Models;



namespace OA.DAL
{

    public static partial class ManualSignService
    {
        //Add Mothed Start
        public static readonly string InsertSql = "INSERT ManualSign (UserId, SignTime, SignDesc, SignTag)VALUES (@UserId, @SignTime, @SignDesc, @SignTag)";
        public static readonly string UpdateSql = "Update ManualSign set UserId=@UserId, SignTime=@SignTime, SignDesc=@SignDesc, SignTag=@SignTag where SignId=@SignId";
        public static readonly string DeleteSql = "Delete FROM ManualSign  where SignId=@SignId";
        public static readonly string SelectSql = "Select * FROM ManualSign";
        public static readonly string SelectSqlById = "Select * FROM ManualSign where SignId =@SignId";

        public static IList<ManualSign> GetByTime(DateTime t1, DateTime t2, string userid)
        {

            string sql = "select * from ManualSign where SignTime between @t1 and @t2 and UserId=@UserId";
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@t1",t1),
                                        new SqlParameter("@t2",t2),
                                        new SqlParameter("@UserId",userid)
								  };
            IList<ManualSign> list = GetListBySql(sql, para);

            return list;
        }
        //查询个人的考勤
        public static int getCD(DateTime t1, DateTime t2, string name, int signTag)
        {

            string sql = "select COUNT(*) from ManualSign where UserId=@userId and SignTag=@SignTag and SignTime between @t1 and @t2";
            SqlParameter[] para = new SqlParameter[]
           						  {
                                      	new SqlParameter("@t1",t1),
                                        	new SqlParameter("@SignTag",signTag),
                                        new SqlParameter("@t2",t2),
										new SqlParameter("@userId",name)
								  };
            return (int)DBHelper.getScalar(sql, para);
        }


        public static IList<ManualSign> GetBydepId(int dep)