using System;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using System.Collections;
|
using DBUtility;
|
|
namespace APSM
|
{
|
public partial class Gy_WorkTimes : Form
|
{
|
private DateTime BDate;
|
private DateTime EDate;
|
private DateTime XQDate;
|
public DBUtility.frm_B_BillQueryCondition_New frmCondition;
|
public const string ViewName = "h_v_Gy_WorkTimesList";
|
//public string CheckProcName = "h_p_Gy_WorkTimes"; //20141020
|
public string ModName = "工厂日历";
|
public const string BillName = "Gy_WorkTimes";
|
public const string ModRightNameEdit = BillName + "_Edit";
|
public const string ModRightNameDelete = BillName + "_Delete";
|
public DBUtility.ClsPub.Enum_InputMode InputMode; //录入状态标志(0-非录入状态 1-增加 2-修改)
|
public long HItemID;//项目ID
|
public long HSourceID;//资源ID
|
DAL.ClsGy_PlanShifts_Ctl oPs = new DAL.ClsGy_PlanShifts_Ctl();
|
DAL.ClsGy_PlanShifts_View oPsHlp = new DAL.ClsGy_PlanShifts_View();
|
DAL.ClsGy_Source_Ctl oSou = new DAL.ClsGy_Source_Ctl();
|
DAL.ClsGy_Source_View oSouHlp = new DAL.ClsGy_Source_View();
|
TreeNode CurNode = new TreeNode();
|
|
public Gy_WorkTimes()
|
{
|
InitializeComponent();
|
}
|
#region 固定代码
|
//保存GRID列宽
|
|
//窗体加载
|
private void Gy_WorkTimes_Load(object sender, EventArgs e)
|
{
|
cmbYear.Items.Clear();
|
cmbYear.Items.Add(DateTime.Today.Year - 3);
|
cmbYear.Items.Add(DateTime.Today.Year - 2);
|
cmbYear.Items.Add(DateTime.Today.Year - 1);
|
cmbYear.Items.Add(DateTime.Today.Year);
|
cmbYear.Items.Add(DateTime.Today.Year + 1);
|
cmbYear.Items.Add(DateTime.Today.Year + 2);
|
cmbYear.Items.Add(DateTime.Today.Year + 3);
|
cmbYear.Items.Add(DateTime.Today.Year + 4);
|
cmbYear.Items.Add(DateTime.Today.Year + 5);
|
cmbYear.Items.Add(DateTime.Today.Year + 6);
|
cmbYear.Items.Add(DateTime.Today.Year + 7);
|
cmbYear.SelectedIndex = 3;
|
frmCondition = new DBUtility.frm_B_BillQueryCondition_New();
|
LoadTree();
|
initGrid();
|
RefreshTool();
|
}
|
//加载子结点
|
private void LoadAllNodes(TreeNode sNode)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
|
|
if (sNode != null)
|
{
|
try
|
{
|
long sName = Convert.ToInt64(sNode.Name.Substring(1, sNode.Name.Length - 1));
|
sNode.Nodes.Clear();
|
string sSQL = "";
|
if (HSourceID == 0)
|
{
|
sSQL = "select hitemid,hnumber,hname from Gy_Source where HParentID='" + sName + "' order by Hnumber";
|
}
|
else
|
{
|
sSQL = "select hitemid,hnumber,hname from Gy_Source where HItemID=" + HSourceID + " order by Hnumber";
|
}
|
DataSet Ds = oCn.RunProcReturn(sSQL, "Gy_Source", ref ClsPub.sExeReturnInfo);
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
TreeNode oNode = sNode.Nodes.Add("T" + Ds.Tables[0].Rows[i]["HItemID"].ToString(), Ds.Tables[0].Rows[i]["HNumber"].ToString() + "-" + Ds.Tables[0].Rows[i]["HName"].ToString(), 0, 1);
|
}
|
sNode.Expand();
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("加载子项目失败！" + e.Message, "提示");
|
}
|
}
|
}
|
//加载树形
|
private void LoadTree()
|
{
|
try
|
{
|
tv.Nodes.Clear();
|
tv.ImageList = imageList1;
|
TreeNode sNode = tv.Nodes.Add("T0", "生产资源", 0, 1);
|
LoadAllNodes(sNode);
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("加载树型失败！" + e.Message, "提示");
|
}
|
}
|
//树型 单击
|
private void tv_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
|
{
|
CurNode = e.Node;
|
if (CurNode != null)
|
{
|
if (CurNode.Nodes.Count == 0 && HSourceID == 0)
|
LoadAllNodes(CurNode);
|
Display();
|
}
|
}
|
//初始化GRID
|
private void initGrid()
|
{
|
//Gy_ICMOSortBillFun.initGridVS_Times(grd, ref BDate, ref EDate, this.Name, ref XQDate, cmbYear);
|
}
|
//显示列表
|
private void Display()
|
{
|
DateTime Date;
|
////禁用 红色显示 20141020
|
//Sub_ShowStopFlag();
|
//得到工作中心默认上班时间
|
long sID = Convert.ToInt64(CurNode.Name.Substring(1, CurNode.Name.Length - 1));
|
Single sWorkTimes = 8;
|
//sWorkTimes = oSouHlp.GetInfoByName(sName); //根据资源得到工作中心的工时
|
//
|
//
|
for (int r = 0; r <= 22; r = r + 2)
|
{
|
BDate = DBUtility.ClsPub.isDate(cmbYear.Text.ToString() + "-" + Convert.ToString(r / 2 + 1) + "-01");
|
EDate = BDate.AddMonths(1);
|
EDate = EDate.AddDays(-1);
|
|
TimeSpan t = EDate - BDate;//获取2个时间的相隔天数
|
//
|
for (int c = 1; c <= DBUtility.ClsPub.isInt(t.Days + 1); c++)
|
{
|
if (DBUtility.ClsPub.isStrNull(CurNode.Name) != null && DBUtility.ClsPub.isStrNull(CurNode.Text) != "")
|
{
|
Date = DBUtility.ClsPub.isDate(cmbYear.Text.ToString() + "-" + Convert.ToString(r / 2 + 1) + "-" + grd.Rows[r].Cells[c].Value.ToString());
|
if (oPsHlp.GetInfoByDate_Line(sID, Date.ToShortDateString()))
|
{
|
grd.Rows[r + 1].Cells[c].Value = DBUtility.ClsPub.isDoule(oPsHlp.omodel.HOverTimes, 0);
|
}
|
else
|
{
|
if (Date.DayOfWeek == DayOfWeek.Sunday)
|
{
|
grd.Rows[r + 1].Cells[c].Value = "0";
|
}
|
else
|
{
|
if (oSouHlp.GetInfoByID(sID))
|
{
|
//grd.set_TextMatrix(r + 1, c, DBUtility.ClsPub.isDoule(oPsHlp.omodel.HOverTimes, 1));
|
grd.Rows[r + 1].Cells[c].Value = DBUtility.ClsPub.isDoule(oSouHlp.omodel.HWorkTimes, 0);
|
}
|
else
|
{
|
//grd.set_TextMatrix(r + 1, c, sWorkTimes.ToString());
|
grd.Rows[r + 1].Cells[c].Value = sWorkTimes.ToString();
|
}
|
}
|
}
|
|
}
|
}
|
}
|
}
|
//退出模块
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
//刷新
|
private void xs_Click(object sender, EventArgs e)
|
{
|
Display();
|
}
|
//刷新TOOLBAR
|
private void RefreshTool()
|
{
|
|
if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_View)
|
{
|
stTab.SelectedIndex = 0;
|
stTab.TabPages.Remove(this.tabPage1);
|
stTab.TabPages.Add(this.tabPage1);
|
grd.Enabled = true;
|
tc.Enabled = true;
|
//tz.Enabled = true;
|
xs.Enabled = true;
|
}
|
else
|
{
|
stTab.SelectedIndex = 1;
|
stTab.TabPages.Remove(this.tabPage1);
|
stTab.TabPages[0].Hide();
|
grd.Enabled = false;
|
//tc.Enabled = true;
|
//tz.Enabled = false;
|
xs.Enabled = false;
|
}
|
}
|
//取消按钮
|
private void cmdCancel_Click(object sender, EventArgs e)
|
{
|
InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View;
|
RefreshTool();
|
}
|
//得到对应列
|
private Int32 Fun_GetCol(string sCol,DataGridView grd)
|
{
|
return 1;
|
//return Gy_ICMOSortBillFun.Fun_GetCol_VS(sCol, grd);
|
}
|
//private void bclk_Click(object sender, EventArgs e)
|
//{
|
// //保存列宽
|
// Gy_ICMOSortBillFun.SaveGrid(grd, this.Name, DBUtility.ClsPub.AppPath);
|
//}
|
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
//for (int i = 1; i <= 12; i++)
|
//{
|
// grdMain(i).AutoSize(0, grdMain(i).Cols - 1, false, 1);
|
|
|
// //参数解释 开始列 ，结束列，是否以最大列宽为准，最小列宽
|
// Gy_ICMOSortBillFun.SaveGrid(grdMain(i), this.Name, DBUtility.ClsPub.AppPath);
|
//}
|
}
|
////选中行是否正常
|
//private bool AllowRow()
|
//{
|
|
// if (grdMain.Row >= grdMain.FixedRows && grdMain.Row <= grdMain.Rows - 1)
|
// return true;
|
// else
|
// return false;
|
//}
|
|
|
//时间控件
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
LoadTree();
|
initGrid();
|
}
|
|
#endregion
|
|
|
#region 类的读写
|
//读取类 到 控件
|
private void ShowData(long sItemID)
|
{
|
//
|
}
|
|
//写入类 从控件
|
private bool WriteClass(double sWorktimes, Int64 sSourceID, DateTime sDate)
|
{
|
oPs.oModel.HOverTimes = sWorktimes;
|
oPs.oModel.HRemark = "";
|
oPs.oModel.HShiftsID = 0;
|
oPs.oModel.HSourceID = sSourceID;
|
oPs.oModel.HDate = sDate;
|
return true;
|
}
|
#endregion
|
|
|
#region 界面控件处理
|
|
#endregion
|
|
////检测按钮 20141020
|
//private void jc_Click(object sender, EventArgs e)
|
//{
|
// BLL.ClsPub_BLL.Sub_CheckUseStatus(grdMain, HItemIDCol, CheckProcName);
|
// Display();
|
//}
|
|
|
////禁用项目 红色字体 20141020
|
//public void Sub_ShowStopFlag()
|
//{
|
// BLL.ClsPub_BLL.Sub_ShowStopFlag(grdMain, Fun_GetCol("禁用标记"));
|
//}
|
private void cmbYear_TextChanged(object sender, EventArgs e)
|
{
|
initGrid();
|
}
|
|
private void cmbYear_SelectedIndexChanged(object sender, EventArgs e)
|
{
|
initGrid();
|
}
|
//查询
|
private void cx_Click(object sender, EventArgs e)
|
{
|
frmCondition = new DBUtility.frm_B_BillQueryCondition_New();
|
DBUtility.Gy_BaseFun.SetCondition(frmCondition, ViewName, this.Name);
|
frmCondition.ShowDialog();
|
if (frmCondition.Tag.ToString() == "OK")
|
{
|
Display();
|
}
|
}
|
//修改(批量修改)
|
private void xg_Click(object sender, EventArgs e)
|
{
|
Gy_WorkTimesDlg oDlg = new Gy_WorkTimesDlg();
|
oDlg.ShowDialog();
|
//Display();
|
}
|
|
//CellBeginEdit事件：在触发该事件时单元格还没有获得焦点，我们可以通过设置事件参数e来决定是否执行对单元格的编辑，如下
|
private void grd_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
|
{
|
// //执行编辑，这个一般不用写
|
|
// e.Cancel = true;
|
|
// //不执行编辑，这个一般是通过条件判断是否执行编辑，如果条件不成立，即不允许对单元格进行编辑
|
|
// e.Cancel = false;
|
}
|
|
//CellParsing事件：在该事件中我们可以对输入的文本进行格式化，如将输入的英文字母全部改成大写等等，如下
|
private void grd_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
|
{
|
/*
|
|
* 这里必须是通过e.Value来获得重新输入的值
|
|
* 如果是通过this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()这种方法获得
|
|
* 那么获得值将是原来的值，并不是用户刚刚输入的值
|
|
* 这个也正可以对用户输入的数据进行验证，如果不符合则将原来的值再赋给该单元格，不进行修改
|
|
* 切记！！！！！
|
|
* 在这里必须将e.ParsingApplied属性设置为true，否则刚刚用户输入的值不会更新
|
|
* 还是会将原来的值赋给该单元格
|
|
* */
|
|
e.Value = e.Value.ToString().ToUpper();
|
|
e.ParsingApplied = true;
|
|
//MessageBox.Show(this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString());
|
}
|
private void grd_CellEndEdit(object sender, DataGridViewCellEventArgs e)
|
{
|
DateTime Date = DBUtility.ClsPub.isDate(cmbYear.Text.ToString() + "-" + DBUtility.ClsPub.isInt(e.RowIndex / 2 + 1).ToString() + "-" + grd.Rows[e.RowIndex - 1].Cells[e.ColumnIndex].Value.ToString());
|
if (DBUtility.ClsPub.isStrNull(CurNode.Name) != null && DBUtility.ClsPub.isStrNull(CurNode.Text) != "")
|
{
|
Int64 sName = Convert.ToInt64(CurNode.Name.Substring(1, CurNode.Name.Length - 1));
|
double sWorktimes = DBUtility.ClsPub.isDoule(grd.Rows[e.RowIndex].Cells[e.ColumnIndex].Value);
|
//
|
WriteClass(sWorktimes, sName, Date);
|
oPs.AddNew();
|
Display();
|
}
|
}
|
|
|
|
//private void grdMain_BeforeEdit(object sender, AxVSFlex7._IVSFlexGridEvents_BeforeEditEvent e)
|
//{
|
// if (DBUtility.ClsPub.GridToColor(grdMain.get_Cell(VSFlex7.CellPropertySettings.flexcpBackColor, grdMain.Row, grdMain.Col, grdMain.Row, grdMain.Col)) == DBUtility.ClsPub.Enum_Color.hx_Write)
|
// {
|
// //
|
// }
|
// else
|
// {
|
// e.cancel = true;
|
// }
|
//}
|
|
//private void tz_Click(object sender, EventArgs e)
|
//{
|
// Gy_WorkTimesDlg oDlg = new Gy_WorkTimesDlg();
|
// oDlg.ShowDialog();
|
// Display();
|
//}
|
|
//private void grdMain_AfterEdit(object sender, AxVSFlex7._IVSFlexGridEvents_AfterEditEvent e)
|
//{
|
|
// DateTime Date = DBUtility.ClsPub.isDate(cmbYear.Text.ToString() + "-" + DBUtility.ClsPub.isInt(grdMain.Row / 2 + 1).ToString() + "-" + grdMain.get_TextMatrix(grdMain.Row - 1, grdMain.Col).ToString());
|
// if (DBUtility.ClsPub.isStrNull(CurNode.Name) != null && DBUtility.ClsPub.isStrNull(CurNode.Text) != "")
|
// {
|
// Int64 sName = Convert.ToInt64(CurNode.Name.Substring(1, CurNode.Name.Length - 1));
|
// double sWorktimes = DBUtility.ClsPub.isDoule(grdMain.get_TextMatrix(grdMain.Row, grdMain.Col));
|
// //
|
// WriteClass(sWorktimes, sName, Date);
|
// oPs.AddNew();
|
// Display();
|
// }
|
//}
|
|
//private void cmdHSource_Click(object sender, EventArgs e)
|
//{
|
// DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
|
// oSource.WherePart = txtHSource.Text.Trim();
|
// if (oSource.RefreshView())
|
// {
|
// txtHSource.Text = oSource.oModel.HName;
|
// txtHSource.Tag = oSource.oModel.HItemID;
|
// HSourceID = oSource.oModel.HItemID;
|
// }
|
// else
|
// {
|
// txtHSource.Text = "";
|
// txtHSource.Tag = "0";
|
// HSourceID = 0;
|
// }
|
// LoadTree();
|
//}
|
|
//private void ww_Click(object sender, EventArgs e)
|
//{
|
// Gy_WorkTimesWWDlg oDlg = new Gy_WorkTimesWWDlg();
|
// oDlg.HSourceID = DBUtility.ClsPub.isLong(txtHSource.Tag);
|
// oDlg.ShowDialog();
|
// Display();
|
//}
|
|
}
|
}
|
