using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace BLL
|
{
|
public partial class KB_KanbanPlaySet : Form
|
{
|
public KB_KanbanPlaySet()
|
{
|
InitializeComponent();
|
}
|
|
public const Int16 HItemIDCol = 0;
|
public const Int16 HSnoCol = 1;
|
public const Int16 HKanBanNameCol = 2;
|
public const Int16 HDisplayTimesCol = 3;
|
//
|
public Int64 HCurNo = 1; //µ±Ç°¿´°å
|
public Int64 HCurSumTimes = 0; //µ±Ç°¿´°å×Üʱ¼ä
|
public Int64 HCurTimes = 0; //µ±Ç°¿´°åÒѺÄÓÃʱ¼ä
|
public Int64 HSumNo = 0; //×Ü¿´°åÊýÁ¿
|
public string HCurKanbanName = "";
|
Form frm;
|
|
private void KB_KanbanPlaySet_Load(object sender, EventArgs e)
|
{
|
initGrid();
|
ShowBill();
|
|
}
|
|
private void ShowBill()
|
{
|
try
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//
|
//»ñÈ¡IP
|
string sIP = DBUtility.ClsPub.IPAddress;
|
DataSet ds;
|
ds = oCn.RunProcReturn("select * from KB_KanbanPlaySet Where HIPAddr='" + sIP + "'", "KB_KanbanPlaySet");
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
return;
|
}
|
else
|
{
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
{
|
grdMain.Rows[i].Cells[HSnoCol].Value = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[i]["HSNO"]);
|
grdMain.Rows[i].Cells[HKanBanNameCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HKanBanName"]);
|
grdMain.Rows[i].Cells[HDisplayTimesCol].Value = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[i]["HDisplayTimes"]);
|
}
|
}
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("ÏÔʾʧ°Ü!" + e.Message);
|
|
}
|
}
|
|
//³õʼ»¯Íø¸ñ
|
private void initGrid()
|
{
|
grdMain.ColumnCount = 4; //×ÜÁÐÊý
|
DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name);
|
//=
|
grdMain.Columns[HSnoCol].HeaderText = "ÐòºÅ";
|
grdMain.Columns[HKanBanNameCol].HeaderText = "¿´°åÃû³Æ";
|
grdMain.Columns[HDisplayTimesCol].HeaderText = "²¥·Åʱ¼ä";
|
//==
|
grdMain.Columns[HItemIDCol].Visible = false;
|
//
|
DBUtility.ClsPub.GetGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
}
|
|
private void cmdCancel_Click(object sender, EventArgs e)
|
{
|
DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
this.Close();
|
}
|
|
private void cmdSave_Click(object sender, EventArgs e)
|
{
|
SaveBill();
|
}
|
|
private void SaveBill()
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//
|
DisNo();
|
//»ñÈ¡IP
|
string sIP = DBUtility.ClsPub.IPAddress;
|
oCn.RunProc("delete from KB_KanbanPlaySet Where HIPAddr='" + sIP + "'");
|
for (int i = 0; i < grdMain.Rows.Count; i++)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HKanBanNameCol].Value) != "")
|
{
|
oCn.RunProc("insert into KB_KanbanPlaySet(HSNO,HIPAddr,HMaker,HMakeDate,HKanBanName " +
|
",HMouldName,HDisplayTimes,HRelTimes) " +
|
" values( " +
|
"'" + DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HSnoCol].Value) + "'" +
|
",'" + DBUtility.ClsPub.isStrNull(sIP) + "'" +
|
",'" + DBUtility.ClsPub.CurUserName + "'" +
|
",getdate()" +
|
",'" + DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HKanBanNameCol].Value) + "'" +
|
",''" +
|
"," + DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HDisplayTimesCol].Value) + "" +
|
"," + DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HDisplayTimesCol].Value)/30 + "" +
|
")");
|
}
|
else
|
{
|
//
|
}
|
}
|
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
if (HCurSumTimes <= HCurTimes)
|
{
|
Display();
|
}
|
else
|
{
|
HCurTimes = HCurTimes + 1;
|
}
|
}
|
|
private void Display()
|
{
|
try
|
{
|
//
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//
|
if (HSumNo <= HCurNo)
|
{
|
HCurNo = 0;
|
}
|
//»ñÈ¡IP
|
string sIP = DBUtility.ClsPub.IPAddress;
|
DataSet ds;
|
ds = oCn.RunProcReturn("select top 1 HSNO,HKanBanName,HDisplayTimes,HRelTimes from KB_KanbanPlaySet Where HIPAddr='" + sIP + "' and HSNO>" + HCurNo + " order by hsno ", "KB_KanbanPlaySet");
|
if (ds == null)
|
{
|
MessageBox.Show("¶ÁÈ¡Òì³£!");
|
return;
|
}
|
else
|
{
|
if (ds.Tables[0].Rows.Count == 0)
|
{
|
MessageBox.Show("¶ÁÈ¡Òì³£2!");
|
HCurNo = 0;
|
return;
|
}
|
else
|
{
|
HCurSumTimes = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HRelTimes"]); ; //µ±Ç°¿´°å×Üʱ¼ä
|
HCurTimes = 0; //µ±Ç°¿´°åÒѺÄÓÃʱ¼ä
|
HCurNo = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HSNO"]);//µ±Ç°¿´°åÐòºÅ
|
HCurKanbanName = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HKanBanName"]);//µ±Ç°¿´°å
|
//¸ù¾Ý¿´°åÃûÏÔʾ¶ÔÓ¦¿´°å
|
CloseAllKanban();
|
ShowKanbanByName(HCurKanbanName);
|
|
}
|
}
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("È¡Êýʧ°Ü!" + e.Message);
|
}
|
}
|
|
//¹Ø±ÕÈ«²¿¿´°å
|
private void CloseAllKanban()
|
{
|
try
|
{
|
if (frm == null)
|
{
|
}
|
else
|
{
|
frm.Close();
|
frm = null;
|
}
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("¹Ø±Õʧ°Ü!" + e.Message);
|
}
|
}
|
|
//¸ù¾ÝÃû×ÖÏÔʾ¶ÔÓ¦¿´°å
|
private void ShowKanbanByName(string sCurKanbanName)
|
{
|
try
|
{
|
switch (sCurKanbanName)
|
{
|
case "1":
|
frm = new Xt_AccountPeriod();
|
frm.Show();
|
break;
|
case "2":
|
frm = new Frm_SQLInfo();
|
frm.Show();
|
break;
|
case "3":
|
frm = new Frm_SQLInfo();
|
frm.Show();
|
break;
|
default:
|
|
break;
|
}
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("È¡Êýʧ°Ü!" + e.Message);
|
}
|
}
|
|
private bool GetKanbanSet()
|
{
|
try
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//
|
//´ÓÊý¾Ý¿â»ñÈ¡Êý¾Ý²¢Ð´Èë±äÁ¿
|
HCurNo = 1; //µ±Ç°¿´°å
|
HSumNo = 0; //×Ü¿´°åÊýÁ¿
|
//»ñÈ¡IP
|
string sIP = DBUtility.ClsPub.IPAddress;
|
DataSet ds;
|
ds = oCn.RunProcReturn("select count(1) HCount from KB_KanbanPlaySet Where HIPAddr='" + sIP + "'", "KB_KanbanPlaySet");
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
MessageBox.Show("ûÓÐÕÒµ½¸ÃIPÉèÖõĿ´°åÐÅÏ¢!");
|
return false;
|
}
|
else
|
{
|
HSumNo = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0][0]);
|
}
|
if (HSumNo < HCurNo)
|
{
|
MessageBox.Show("×Ü¿´°åÊýÁ¿Ð¡ÓÚµ±Ç°¿´°å±àºÅ!");
|
return false;
|
}
|
return true;
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("ÉèÖÃʧ°Ü!" + e.Message);
|
return false;
|
}
|
}
|
|
private void cmdPlay_Click(object sender, EventArgs e)
|
{
|
//»ñÈ¡Êý¾Ý¿âÊý¾Ý
|
if (GetKanbanSet()==false)
|
{
|
timer1.Enabled = false;
|
return;
|
}
|
//
|
timer1.Enabled = true;
|
cmdPlay.Enabled = false;
|
cmdPause.Enabled = true;
|
tabControl1.Visible = false;
|
groupBox2.Visible = false;
|
HCurNo = 0;
|
Display();
|
|
}
|
|
private void cmdPause_Click(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
cmdPlay.Enabled = true;
|
cmdPause.Enabled = false;
|
tabControl1.Visible = true;
|
groupBox2.Visible = true;
|
}
|
|
private void DisNo()
|
{
|
for (int i = 0; i < grdMain.Rows.Count; i++)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HKanBanNameCol].Value) != "")
|
{
|
grdMain.Rows[i].Cells[HSnoCol].Value = i + 1;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSnoCol].Value = "";
|
}
|
}
|
}
|
|
private void cmdDisNo_Click(object sender, EventArgs e)
|
{
|
DisNo();
|
}
|
|
|
|
|
}
|
}
|
