using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using SQLHelper;
|
using Pub_Class;
|
|
namespace Kanban
|
{
|
public partial class Sc_WorkBillProcTimeReportKB2 : Form
|
{
|
public Sc_WorkBillProcTimeReportKB2()
|
{
|
InitializeComponent();
|
}
|
public string ViewName = "h_p_Sc_WorkBillProcTimeReportKB2";
|
public string sDeptID = "0";
|
public int iRow = 0;
|
public DateTime oBegintime = new DateTime();
|
public DateTime otimeNow = new DateTime();
|
public int oWorkTime = 0;
|
public Int64 HICMOInterID = 0;
|
DataSet DSet;
|
bool sTrue = false;
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
//得到当前日期 时间
|
lblTimeNow.Text = DBUtility.ClsPub.GetServerDate(-1);
|
}
|
|
private void timer2_Tick(object sender, EventArgs e)
|
{
|
if (sTrue == false)
|
return;
|
//计算倒计时时间
|
|
DataSet Ds;
|
SQLHelper.ClsCN oCn = new ClsCN();
|
oWorkTime = DBUtility.ClsPub.isInt(DSet.Tables[0].Rows[iRow]["HWorkTime"]) * 60;
|
oBegintime = DBUtility.ClsPub.isDate(DSet.Tables[0].Rows[iRow]["HBeginTime"]);
|
HICMOInterID = DBUtility.ClsPub.isLong(DSet.Tables[0].Rows[iRow]["HInterID"]) ;
|
Ds = oCn.RunProcReturn("exec h_p_Sc_WorkBillProcTimeReportKB2_ByWorkTime " + sDeptID + "," + HICMOInterID + "," + oWorkTime + ",'" + oBegintime + "'", "Gy_WorkTime");
|
string sZF = "";
|
int HHour = 0;
|
int HMinute = 0;
|
int HSecond = 0;
|
int HZF = 0;
|
HHour = ClsPub.isInt(Ds.Tables[0].Rows[0]["HHOur"]);
|
HMinute = ClsPub.isInt(Ds.Tables[0].Rows[0]["HMinute"]);
|
HSecond = ClsPub.isInt(Ds.Tables[0].Rows[0]["HSecond"]);
|
HZF = ClsPub.isInt(Ds.Tables[0].Rows[0]["HZF"]);
|
if (HZF == 0)
|
{
|
sZF = "-";
|
}
|
else
|
{
|
sZF = "";
|
}
|
TimeSpan ts = new TimeSpan(HHour, HMinute, HSecond);
|
string sSeconds = DBUtility.ClsPub.isStrNull("00" + ts.Seconds.ToString());
|
lblTimeCD.Text = sZF + (int)ts.TotalMinutes + ":" + sSeconds.Substring(sSeconds.Length - 2);
|
|
|
//string sZF = "";
|
//int cyDays = 0;
|
//int cyDayseconds = 0;
|
//int cySeconds = 0;
|
//int EndTime = 0;
|
//DateTime oAMSBTime2 = DBUtility.ClsPub.isDate(DateTime.Today.ToShortDateString() + " 00:00:01");
|
//DateTime oAMSBTime = DBUtility.ClsPub.isDate(DateTime.Today.ToShortDateString() + " 08:00:00");
|
//DateTime oAMXBTime = DBUtility.ClsPub.isDate(DateTime.Today.ToShortDateString() + " 11:30:00");
|
//DateTime oPMSBTime = DBUtility.ClsPub.isDate(DateTime.Today.ToShortDateString() + " 12:30:00");
|
//DateTime oPMXBTime = DBUtility.ClsPub.isDate(DateTime.Today.ToShortDateString() + " 17:00:00");
|
//DateTime oPMXBTime2 = DBUtility.ClsPub.isDate(DateTime.Today.ToShortDateString() + " 23:59:59");
|
//otimeNow = ClsPub.isDate(DBUtility.ClsPub.GetServerDate(-1));
|
//oWorkTime = DBUtility.ClsPub.isInt(DSet.Tables[0].Rows[iRow]["HWorkTime"]) * 60;
|
//oBegintime = DBUtility.ClsPub.isDate(DSet.Tables[0].Rows[iRow]["HBeginTime"]);
|
//TimeSpan TsDate1 = otimeNow.Subtract(oBegintime);
|
//cyDays = (int)TsDate1.TotalDays;
|
//cyDayseconds = cyDays * 16 * 60 * 60;
|
////计算上班下班时间
|
//if (otimeNow >= oAMSBTime2 && otimeNow < oAMSBTime)
|
//{
|
// return;
|
// //otimeNow = DBUtility.ClsPub.isDate(DateTime.Today.AddDays(-1).ToShortDateString() + " 17:00:00");
|
//}
|
//if (otimeNow > oAMXBTime && otimeNow < oPMSBTime)
|
//{
|
// return;
|
// //otimeNow = oPMXBTime;
|
//}
|
//if (otimeNow > oPMXBTime && otimeNow <= oPMXBTime2)
|
//{
|
// return;
|
// //otimeNow = oPMXBTime;
|
//}
|
//TimeSpan TsDate = otimeNow.Subtract(oBegintime);
|
//cySeconds = (int)TsDate.TotalSeconds;
|
//EndTime = oWorkTime - cySeconds + cyDayseconds;
|
//if (EndTime < 0)
|
//{
|
// sZF = "-";
|
//}
|
//else
|
//{
|
// sZF = "";
|
//}
|
//EndTime = System.Math.Abs(EndTime);
|
//TimeSpan ts = new TimeSpan(0, 0, EndTime);
|
//string sSeconds = DBUtility.ClsPub.isStrNull("00" + ts.Seconds.ToString());
|
//lblTimeCD.Text = sZF + (int)ts.TotalMinutes + ":" + sSeconds.Substring(sSeconds.Length - 2);
|
}
|
|
private void timer3_Tick(object sender, EventArgs e)
|
{
|
DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
|
//全局刷新
|
if (sTrue == false)
|
return;
|
lblICMOBillNo.Text = DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[iRow]["HBillNO"]);
|
lblEmp.Text = "人员：" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[iRow]["HEmpName"]);
|
lblMater.Text = DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[iRow]["HMaterName"]);
|
lblWorkTime.Text = "标准工时(m):" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[iRow]["HWorkTime"]);
|
lblBeginTime.Text = DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[iRow]["HBeginTime"]);
|
lblTimeCD.Text = "0000:00";
|
if (oEmp.GetInfoByID(DBUtility.ClsPub.isLong(DSet.Tables[0].Rows[iRow]["HEmpID"])))
|
{
|
//pEmpPic.Image = oEmp.omodel.HPic;
|
}
|
else
|
{
|
//pEmpPic.Image = null;
|
}
|
iRow = iRow + 1;
|
if (iRow > DSet.Tables[0].Rows.Count - 1)
|
{
|
iRow = 0;
|
}
|
}
|
|
private void Sc_WorkBillProcTimeReportKB2_Load(object sender, EventArgs e)
|
{
|
ClsIni oIni = new ClsIni();
|
string sID = ClsIni.ReadIni("Dept", "DeptID", Pub_Class.ClsPub.AppPath + @"\" + "HXErp_SY.ini");
|
sDeptID = sID;
|
//
|
int iHeight = 0;
|
int iWidth = 0;
|
iHeight = DBUtility.ClsPub.isInt(Math.Round(this.Height / 2.0, 0));
|
iWidth = DBUtility.ClsPub.isInt(Math.Round(this.Width / 2.0, 0));
|
pPic.Width = DBUtility.ClsPub.isInt(Math.Round(iWidth / 2.0, 0));
|
pMater.Width = iWidth + 160;
|
pEmp.Width = DBUtility.ClsPub.isInt(Math.Round(this.Width / 3.0, 0)) - 60;
|
pBaseTime.Width = DBUtility.ClsPub.isInt(Math.Round(this.Width / 3.0, 0)) - 30;
|
//
|
pBillNo.Height = DBUtility.ClsPub.isInt(Math.Round(iHeight / 5.0, 0));
|
panel2.Height = DBUtility.ClsPub.isInt(Math.Round(iHeight / 3.0, 0)) + 60;
|
splitContainer1.Height = iHeight;
|
splitContainer1.SplitterDistance= DBUtility.ClsPub.isInt(Math.Round(this.Width / 3.0, 0)) - 60;
|
//
|
Display();
|
FirstShow();
|
lblICMOBillNo.Focus();
|
}
|
|
private void FirstShow()
|
{
|
DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
|
//全局刷新
|
if (sTrue == false)
|
return;
|
lblICMOBillNo.Text = DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[iRow]["HBillNO"]);
|
lblEmp.Text = "人员：" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[iRow]["HEmpName"]);
|
lblMater.Text = DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[iRow]["HMaterName"]);
|
lblWorkTime.Text = "标准工时(m):" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[iRow]["HWorkTime"]);
|
lblBeginTime.Text = DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[iRow]["HBeginTime"]);
|
lblTimeCD.Text = "0000:00";
|
if (oEmp.GetInfoByID(DBUtility.ClsPub.isLong(DSet.Tables[0].Rows[iRow]["HEmpID"])))
|
{
|
//pEmpPic.Image = oEmp.omodel.HPic;
|
}
|
else
|
{
|
//pEmpPic.Image = null;
|
}
|
|
if (iRow > DSet.Tables[0].Rows.Count - 1)
|
{
|
iRow = 0;
|
}
|
}
|
|
private void Display()
|
{
|
try
|
{
|
ClsCN SubCn = new ClsCN();
|
string sSql = "";
|
string sWhere = "";
|
//过滤条件
|
//if (frmCondition.SqlStr.Trim().Length == 0)
|
// return;
|
//sSql = frmCondition.SqlStr + sWhere + " order by HStatus,HDate ";
|
sSql = "exec h_p_Sc_WorkBillProcTimeReportKB2 " + sDeptID;
|
//
|
DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
|
//生成首行标题
|
if (DSet == null || DSet.Tables[0].Rows.Count == 0)
|
{
|
sTrue = false;
|
//MessageBox.Show("没有返回任何结果,请在过滤框中点击【恢复】按钮,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo);
|
SubCn.CnClose();
|
SubCn.CnDispose();
|
return;
|
}
|
sTrue = true;
|
SubCn.CnClose();
|
SubCn.CnDispose();
|
}
|
catch (Exception e)
|
{
|
return;
|
}
|
}
|
|
//下拉式 选择框 GRID
|
bool enterkey;
|
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
|
{
|
enterkey = false;
|
if (keyData == Keys.Left) //监听方向键 左 事件
|
{
|
iRow = iRow - 1;
|
if (iRow > DSet.Tables[0].Rows.Count - 1)
|
{
|
iRow = 0;
|
}
|
if (iRow < 0)
|
{
|
iRow = 0;
|
}
|
FirstShow();
|
}
|
if (keyData == Keys.Right) //监听方向键 右 事件
|
{
|
iRow = iRow + 1;
|
if (iRow > DSet.Tables[0].Rows.Count - 1)
|
{
|
iRow = 0;
|
}
|
if (iRow < 0)
|
{
|
iRow = 0;
|
}
|
FirstShow();
|
}
|
//继续原来base.ProcessCmdKey中的处理
|
return base.ProcessCmdKey(ref msg, keyData);
|
}
|
|
private void timer4_Tick(object sender, EventArgs e)
|
{
|
Display();
|
}
|
|
|
|
|
}
|
}
|
