lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/TimeAndAttendance/SetSmallForm/AttendanceDetailsSmallForm.cs

using LYFZ.Software.MainBusiness.DoorCityProcess;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace LYFZ.Software.MainBusiness.TimeAndAttendance.SetSmallForm
{
    public partial class AttendanceDetailsSmallForm : LYFZ.Software.UI.TimeAndAttendance.SetSmallForm.AttendanceDetailsSmallForm
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        public AttendanceDetailsSmallForm()
        {
            this.Shown += AttendanceDetailsSmallForm_Shown;
        }
        /// <summary>
        /// 员工姓名
        /// </summary>
        public string StrUserName = "";
        /// <summary>
        /// 员工编号
        /// </summary>
        public string StrUserNumber = "";
        /// <summary>
        /// 日期
        /// </summary>
        public string StrDateTime = "";
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void AttendanceDetailsSmallForm_Shown(object sender, EventArgs e)
        {
            this.label5.Text = this.StrUserName;
            this.label8.Text = this.StrDateTime;
            this.label6.Text = "";
            this.label7.Text = "";
            this.label9.Text = "";
            DataTable dtPaiBan = orbll.GetView_Custom("select name,time1,time2,time3,time4 from loninbansets Left Join lonintimeset on fixed = name Where User_ID = '" + StrUserNumber + "' " + PublicCodeClasses.GetDateTime("Time", StrDateTime, StrDateTime)).Tables[0];
            if (dtPaiBan.Rows.Count > 0)
            {
                this.label6.Text = dtPaiBan.Rows[0]["name"].ToString().Trim();
                this.label6.Text += "                    " + dtPaiBan.Rows[0]["time1"].ToString().Trim();
                this.label6.Text += "                    " + dtPaiBan.Rows[0]["time2"].ToString().Trim();
                this.label6.Text += "                    " + dtPaiBan.Rows[0]["time3"].ToString().Trim();
                this.label6.Text += "                    " + dtPaiBan.Rows[0]["time4"].ToString().Trim();
            }
            DataTable dtTongJi = orbll.GetView_Custom("select dbo.fn_CheckDateTime(datetime) AS datetime from lonindata Left Join tb_ErpUser on (User_FirstFingerprintID = [no] or User_SecondaryFingerprintID = [no]) Where User_EmployeeID = '" + this.StrUserNumber + "'" + PublicCodeClasses.GetDateTime("datetime", StrDateTime, StrDateTime) + " Group By dbo.fn_CheckDateTime(datetime) order by datetime").Tables[0];
            for (int i = 0; i < dtTongJi.Rows.Count; i++)
            {
                if (i % 2 == 0)
                { this.label9.Text += dtTongJi.Rows[i]["datetime"].ToString().Trim() + "                    "; }
                else
                { this.label9.Text += dtTongJi.Rows[i]["datetime"].ToString().Trim() + "\r\n"; }
            }
            DataTable dtDaKa = orbll.GetView_Custom("select datetime from lonindata Left Join tb_ErpUser on (User_FirstFingerprintID = [no] or User_SecondaryFingerprintID = [no]) Where User_EmployeeID = '" + this.StrUserNumber + "'" + PublicCodeClasses.GetDateTime("datetime", StrDateTime, StrDateTime) + " Order by datetime").Tables[0];
            for (int i = 0; i < dtDaKa.Rows.Count; i++)
            {
                if (i % 2 == 0)
                { this.label7.Text += dtDaKa.Rows[i]["datetime"].ToString().Trim() + "                    "; }
                else
                { this.label7.Text += dtDaKa.Rows[i]["datetime"].ToString().Trim() + "\r\n"; }
            }
        }
    }
}