📄 moas1203.aspx.cs
字号:
using System;
using System.IO;
using System.Web;
using System.Data;
using System.Web.UI;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Data.SqlClient;
using System.Web.SessionState;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace MOAS
{
//MOAS1203的说明
//该画面是从MOAS1201.[座席管理画面]迁移过来的;
//该画面也是MOAS1204.[缺席原因输入]的入口画面;
//当员工结束休假或外出，座席情况由不在转为在席;
//提前结束假期，UKISAKI表中的END_DATE字段作相应的修改。
public class MOAS1203 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.Label Label6;
protected System.Web.UI.WebControls.Label Label7;
protected System.Web.UI.WebControls.Label Label8;
protected System.Web.UI.WebControls.Label Label9;
protected System.Web.UI.WebControls.Label Label10;
protected System.Web.UI.WebControls.Label Label11;
protected System.Web.UI.WebControls.Label Label12;
protected System.Web.UI.WebControls.Label Label13;
protected System.Web.UI.WebControls.Label Label14;
protected System.Web.UI.WebControls.Label Label15;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.Button Button3;
protected System.Web.UI.WebControls.Button Button4;
protected System.Web.UI.WebControls.Table Table1;
DataSet dsSeat=null,dsUser=null,dsUkis=null;
private void Page_Load(object sender, System.EventArgs e)
{
//防止页面闪烁
this.Page.SmartNavigation = false;
pageCreat();
creatTable();
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button3.Click += new System.EventHandler(this.Button3_Click);
this.Button4.Click += new System.EventHandler(this.Button4_Click);
this.Button2.Click += new System.EventHandler(this.Button2_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
//[座席信息一览]画面座席颜色的创建
public void pageCreat()
{
try
{
//用SEAT表实例化CCoSearchFromDatabase类
string[] sqlSeat={"select * from SEAT","SEAT"};
CCoSearchFromDatabase dscSeat=new CCoSearchFromDatabase();
dsSeat=dscSeat.getDataSet(sqlSeat);
//用USERS表实例化CCoSearchFromDatabase类
string[] sqlUser={"select * from USERS","USERS"};
CCoSearchFromDatabase dscUser=new CCoSearchFromDatabase();
dsUser=dscUser.getDataSet(sqlUser);
//用UKISAKI表实例化DataSetClass类
string[] sqlUkis={"select * from UKISAKI","UKISAKI"};
CCoSearchFromDatabase dscUkis=new CCoSearchFromDatabase();
dsUkis=dscUkis.getDataSet(sqlUkis);
//color
int counSeat=dsSeat.Tables["SEAT"].Rows.Count;
string[] striColo=new string[counSeat];
//name
string[] striName=new string[counSeat];
//取SEAT表中的OWNERID
string striSeatOwne="";
//取USERS表中的NAME
string striUserName="";
//取USERS表中的GetSessId
string striUserId="";
//取USERS表中的STATUS
string striUserStat="";
//得到SEAT表中的OWNERID的长度
int intSeatOwneLeng;
//得到Session中的GetSessId的值
string striSessId="";
striSessId=((string[])Session["strArrayLoginInfo"]).GetValue(0).ToString();
string strFilePath="AppProConfig\\colorPro.txt";
CCoOptionFile m_ReadFile=new CCoOptionFile(strFilePath,'=');
int iCount=m_ReadFile.iFileCount ;
//建立10行25列的表格
for(int i=0;i<10;i++)
{
for(int j=0;j<25;j++)
{
striSeatOwne=dsSeat.Tables["SEAT"].Rows[i*25+j].ItemArray.GetValue(3).ToString().Trim();
int count=dsUser.Tables["USERS"].Rows.Count+1;
for(int k=0;k<count-1;k++)
{
//USERS.GetSessId
striUserId=dsUser.Tables["USERS"].Rows[k].ItemArray.GetValue(0).ToString().Trim();
if(striUserId==striSeatOwne)
{
striUserName=dsUser.Tables["USERS"].Rows[k].ItemArray.GetValue(1).ToString().Trim();
striUserStat=dsUser.Tables["USERS"].Rows[k].ItemArray.GetValue(12).ToString().Trim();
}
}
//ownerid.length
intSeatOwneLeng=dsSeat.Tables["SEAT"].Rows[i*25+j].ItemArray.GetValue(3).ToString().Trim().Length;
if(intSeatOwneLeng==9)
{
if(striUserStat.Equals("1"))
{
striColo[i*25+j]="Gray";
striName[i*25+j]=striUserName;
}
else if(striUserStat.Equals("2"))
{
striColo[i*25+j]="#c00000";
striName[i*25+j]=striUserName;
}
else
{
striColo[i*25+j]="#66cccc";
striName[i*25+j]="";
}
}
else
{
for(int k=0;k<=iCount;k++)
{
if(striSeatOwne==m_ReadFile.strParseContext .GetValue (k).ToString ())
{
striColo[i*25+j]=m_ReadFile.strParseColor.GetValue (k).ToString ();
striName[i*25+j]="";
break;
}
else
{
striColo[i*25+j]="ffffff";
striName[i*25+j]="";
}
}
}
}
}
//内部传递Session
Session.Add("GetStriColo",striColo);
Session.Add("GetStriName",striName);
}
catch(Exception ex)
{
HttpContext.Current.Response.Redirect("ErrorMessage.aspx?message="+ex.Message+"");
}
}
//[座席信息一览]画面的创建
public void creatTable()
{
try
{
for(int i=0;i<10;i++)
{
TableRow temRow=new TableRow();
for(int j=0;j<25;j++)
{
string strColor=((string[])Session["GetStriColo"]).GetValue(i*25+j).ToString ();
TableCell temCell=new TableCell();
temCell.Width=32;
temCell.Height=50;
temCell.BackColor=System.Drawing .Color .FromName(strColor);
temCell.Text=((string[])Session["GetStriName"]).GetValue(i*25+j).ToString ();
temRow.Cells.Add(temCell);
}
Table1.Rows.Add(temRow);
}
}
catch(Exception ex)
{
HttpContext.Current.Response.Redirect("ErrorMessage.aspx?message="+ex.Message+"");
}
}
//[座席信息一览]画面的的入口
private void Button1_Click(object sender, System.EventArgs e)
{
Response.Redirect("MOAS1203.aspx");
}
//在席Button功能的实现
private void Button2_Click(object sender, System.EventArgs e)
{
try
{
string GetSessId=((string[])Session["strArrayLoginInfo"]).GetValue(0).ToString();
string GetSessIdTran="'"+GetSessId+"'";
string update="UPDATE USERS SET STATUS='1' WHERE ID="+GetSessIdTran+"";
//修改结果传给数据库连接公共类
CCoSearchFromDatabase GetCCoSearchFromDatabase=new CCoSearchFromDatabase();
GetCCoSearchFromDatabase.Execute(update);
int intUkisCoun=dsUkis.Tables["UKISAKI"].Rows.Count;
for(int m=0;m<intUkisCoun;m++)
{
if((dsUkis.Tables["UKISAKI"].Rows[m].ItemArray.GetValue(1).ToString().Trim())==((string[])Session["strArrayLoginInfo"]).GetValue(0).ToString())
{
//字符串变量类型转换
string striNowt=DateTime.Now.ToString();
string striNowtTran;
long longNowtTran;
striNowtTran=DateTime.Parse(striNowt).ToString("yyyyMMddHHmm");
longNowtTran=Convert.ToInt64(striNowtTran);
string[] striEndt=new string[intUkisCoun];
string[] striEndtTran=new string[intUkisCoun];
long[] longEndtTran=new long[intUkisCoun];
striEndt[m]=dsUkis.Tables["UKISAKI"].Rows[m].ItemArray.GetValue(4).ToString().Trim();
striEndtTran[m]=DateTime.Parse(striEndt[m]).ToString("yyyyMMddHHmm");
longEndtTran[m]=Convert.ToInt64(striEndtTran[m]);
if(longEndtTran[m]>=longNowtTran)
{
string striUkisNo="'"+dsUkis.Tables["UKISAKI"].Rows[m].ItemArray.GetValue(0)+"'";
string iid=((string[])Session["strArrayLoginInfo"]).GetValue(0).ToString();
string strDate2=DateTime.Now.ToString();
string strDate3="'"+strDate2+"'";
string update2="UPDATE UKISAKI SET END_DATE="+strDate3+" WHERE USER_ID='"+iid+"' and NO="+striUkisNo+"" ;
CCoSearchFromDatabase update3=new CCoSearchFromDatabase();
update3.Execute(update2);
}
else
{
}
}
else
{
}
}
}
catch(Exception ex)
{
HttpContext.Current.Response.Redirect("ErrorMessage.aspx?message="+ex.Message+"");
}
}
//[缺席原因输入]画面的的入口
private void Button3_Click(object sender, System.EventArgs e)
{
Response.Redirect("MOAS1204.aspx");
}
//[座席管理]画面的的入口
private void Button4_Click(object sender, System.EventArgs e)
{
Response.Redirect("MOAS1201.aspx");
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -