mainform.cs

食堂管理提示系统。适用于各种环境下。能自动完成各种统计和计算工作。

			ti.Text = _val + " 的就餐明细";
			Public.SizeColumnsToContent(ti.dataGrid1,-1,t,null);

			if(Public.CheckIsRule("R_006")){
				for(int i=1;i<4;i++){
					DataGridTextBoxColumn dgtb = (DataGridTextBoxColumn)ti.dataGrid1.TableStyles[0].GridColumnStyles[i]; 
					dgtb.TextBox.Click += new EventHandler(TextBox_Click_FOR);
					dgtb.TextBox.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
				}
			}

			ti.ShowDialog();
		}

		private void TextBox_Click_FOR(object sender,System.EventArgs e){

			DataGrid dg = (DataGrid)((TextBox)sender).Parent;
			DataTable tb = (DataTable)dg.DataSource;
			if(tb.Rows.Count == 1 || dg.CurrentCell.RowNumber == tb.Rows.Count - 1) return;

			System.Windows.Forms.DataGridCell dc = dg.CurrentCell;
			string _val = tb.Rows[dc.RowNumber][dc.ColumnNumber].ToString();
			if(_val == "√"){
				tb.Rows[dc.RowNumber][dc.ColumnNumber] = "";
			}else{
				tb.Rows[dc.RowNumber][dc.ColumnNumber] = "√";
			}

			string _IT = "00" + Convert.ToInt32(dc.ColumnNumber);

			string _dgt   = tb.Rows[dc.RowNumber][0].ToString();
			int    index  = _dgt.LastIndexOf("/");
			this._UID     = _dgt.Substring(index+1,_dgt.Length - index -1);
			this._DAT     = dg.CaptionText;

			this.needSave = true;

			if(_val == "√"){
				DBConn.DeleteSelected_(_IT,_UID,_DAT);
				tb.Rows[tb.Rows.Count - 1][dc.ColumnNumber] = Int32.Parse(tb.Rows[tb.Rows.Count - 1][dc.ColumnNumber].ToString()) - 1;
			}else{
				DBConn.SaveSelected_(_IT,_UID,_DAT);
				tb.Rows[tb.Rows.Count - 1][dc.ColumnNumber] = Int32.Parse(tb.Rows[tb.Rows.Count - 1][dc.ColumnNumber].ToString()) + 1;
			}

			//当前状态
			string _results = "";

			DataTable selected = DBConn.GetDaySelected(_UID,Convert.ToDateTime(_DAT));

			foreach(DataRow row in selected.Rows){
				if(row["itemClassID"].ToString() == "001"){
					_results += "001,";
				}else if(row["itemClassID"].ToString() == "002"){
					_results += "002,";
				}else if(row["itemClassID"].ToString() == "003"){
					_results += "001,";
				}
			}

			//记录更改日志
			string _sr= DBConn.SaveEditLog(DBConn.GetServerTime().ToString(),_results,_UID,Public.currentUserID);

			if(_sr != "OK"){
				MessageBox.Show(_sr.ToString());
				return;
			}
		}

		/// <summary>
		/// 查询数据
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void button1_Click(object sender, System.EventArgs e) {

			if(!Public.CheckIsRule("R_001")) return;

			string sd = this.startDate.Text.Replace("年","-").Replace("月","-").Replace("日","") + " 0:00:00";
			string ed = this.endDate.Text.Replace("年","-").Replace("月","-").Replace("日","") + " 23:59:59";

			string ud = "";

			//时间检查
			if(Convert.ToDateTime(this.startDate.Text) > Convert.ToDateTime(this.endDate.Text)){
				MessageBox.Show("超始时间只能小于结束时间！");
				return;
			}

			if(this.userID.Text.Trim() == ""){
				MessageBox.Show("用户名不能为空！");
				return;
			}

			if(this.userID.Text.IndexOf("(") > 0 && this.userID.Text.IndexOf(")") > 0 && this.userID.Text.EndsWith(")")){
				ud = this.userID.Text.Substring(0,this.userID.Text.IndexOf("("));
			}else{
				ud = this.userID.Text;
			}

			try{
				this.ds = DBConn.GetResults(ud,"","",sd,ed);
			}catch(Exception ex){
				MessageBox.Show(ex.Message.ToString());
				return;
			}

			this.dataGrid1.TableStyles.Clear();
			this.dataGrid1.DataSource = this.ds.Tables[0];
			Public.SizeColumnsToContent(this.dataGrid1,-1,this.ds.Tables[0],null);

			this.dataGrid1.CaptionText = this.userID.Text + "在 " + this.startDate.Text + " 至 " + this.endDate.Text + " 这段期间内的就餐情况：";

			if(Public.CheckIsRule("R_006")){
				for(int i=2;i<5;i++){
					DataGridTextBoxColumn dgtb = (DataGridTextBoxColumn)this.dataGrid1.TableStyles[0].GridColumnStyles[i]; 
					dgtb.TextBox.Click += new EventHandler(TextBox_Click);
					dgtb.TextBox.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
				}
			}
		}

		/// <summary>
		/// 
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void TextBox_Click(object sender,System.EventArgs e){

			System.Windows.Forms.DataGridCell dc = this.dataGrid1.CurrentCell;
			string _val = this.ds.Tables[0].Rows[dc.RowNumber][dc.ColumnNumber].ToString();
			if(_val == "√"){
				this.ds.Tables[0].Rows[dc.RowNumber][dc.ColumnNumber] = "";
			}else{
				this.ds.Tables[0].Rows[dc.RowNumber][dc.ColumnNumber] = "√";
			}

			string _IT = "00" + Convert.ToInt32(dc.ColumnNumber - 1);

			string _dgt   = this.dataGrid1.CaptionText;
			this._UID     = _dgt.Substring(0,_dgt.IndexOf("("));
			this._DAT     = this.ds.Tables[0].Rows[dc.RowNumber][0].ToString();
			this.needSave = true;

			if(_val == "√"){
				DBConn.DeleteSelected_(_IT,_UID,_DAT);
				this.ds.Tables[0].Rows[this.ds.Tables[0].Rows.Count - 1][dc.ColumnNumber] = Int32.Parse(this.ds.Tables[0].Rows[this.ds.Tables[0].Rows.Count - 1][dc.ColumnNumber].ToString()) - 1;
				this.ds.Tables[0].Rows[dc.RowNumber][5] = "";
			}else{
				DBConn.SaveSelected_(_IT,_UID,_DAT);
				this.ds.Tables[0].Rows[this.ds.Tables[0].Rows.Count - 1][dc.ColumnNumber] = Int32.Parse(this.ds.Tables[0].Rows[this.ds.Tables[0].Rows.Count - 1][dc.ColumnNumber].ToString()) + 1;
				this.ds.Tables[0].Rows[dc.RowNumber][5] = _DAT + " 1:01:01";
			}

			//当前状态
			string _results = "";

			DataTable selected = DBConn.GetDaySelected(_UID,Convert.ToDateTime(_DAT));

			foreach(DataRow row in selected.Rows){
				if(row["itemClassID"].ToString() == "001"){
					_results += "001,";
				}else if(row["itemClassID"].ToString() == "002"){
					_results += "002,";
				}else if(row["itemClassID"].ToString() == "003"){
					_results += "001,";
				}
			}

			//记录更改日志
			string _sr= DBConn.SaveEditLog(DBConn.GetServerTime().ToString(),_results,_UID,Public.currentUserID);

			if(_sr != "OK"){
				MessageBox.Show(_sr.ToString());
				return;
			}
		}

		/// <summary>
		/// 打印数据
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void button2_Click(object sender, System.EventArgs e) {
			//
		}

		/// <summary>
		/// 年份更改
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void year_SelectedIndexChanged(object sender, System.EventArgs e) {
			this.month_SelectedIndexChanged(null,null);
		}

		/// <summary>
		/// 打印
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void menuItem5_Click(object sender, System.EventArgs e) {

			if(!Public.CheckIsRule("R_001")) return;
			
			this.rd = new ReportLibrary.ReportDocument(((DataTable)this.dataGrid1.DataSource));

			this.rd.RestoreProperty("SystemID=0SystemName=ReportID=0ReportCode=ReportName=ReportType=ReportMemo=PageTitle="+ this.dataGrid1.CaptionText.Replace("：","") +"PageSubTitle=PageHeader={[\n]}PageFooter=GridPrintWhere=GridSelectStyle=GridPrintFields=GridTotalFields=GridChineseField=GridSortFields=GridPaginationFields=GridStatisticsFields=GridSumFields=GridRowToColFields=PdPropertys=PrinterName=EPSON LQ-1600KIIIPaperName=A4PaperWidth=827PaperHeight=1169PaperIsLandscape=falsePaperMargin.Left=30PaperMargin.Right=51PaperMargin.Top=51PaperMargin.Bottom=31");

			this.rd.GridIsFillblank       = false;
			this.rd.PaperFooterIsNearGrid = true;
			this.rd.PaperCols             = 1;
			this.rd.FontHeader            = new Font("宋体",11F);
			this.rd.FontGrid              = new Font("宋体",11F);
			this.rd.FontFooter            = new Font("宋体",11F);
			this.rd.FontTitle             = new Font("黑体",20F,FontStyle.Bold);

			string ptitle = this.dataGrid1.CaptionText;

			if(ptitle.Length > 20){
				this.rd.FontTitle             = new Font("黑体",14F,FontStyle.Bold);
			}

			this.rd.PrintPreview();
		}

		/// <summary>
		/// 取出所有用户
		/// </summary>
		private void LoadAllUsers(){
			try{
				DataSet ds = DBConn.GetAllUsers();
				for(int i=0;i<ds.Tables[0].Rows.Count;i++){
					DataRow row = ds.Tables[0].Rows[i];
					this.userID.Items.Add(row["email"].ToString() + "("+ row["name"].ToString() +")");
				}
			}catch(Exception ex){
				MessageBox.Show(ex.Message.ToString());
				return;
			}
		}

		/// <summary>
		/// 移除主菜单
		/// </summary>
		public void RemoveMenu(){
			this.Menu = null;
		}

		/// <summary>
		/// 设置UID
		/// </summary>
		/// <param name="_uid"></param>
		public void SetUserID(string _uid){
			this.UID = _uid;
			this.userID.Text = _uid;
			this.userID.Enabled = false;
			this.Text = "历史数据查询";
			month_SelectedIndexChanged(null,null);
		}

		/// <summary>
		/// 单击控件时发生
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void dataGrid1_Click(object sender, System.EventArgs e) {
			
			if(((DataTable)this.dataGrid1.DataSource).Rows.Count > 0){
			
				/*
				System.Windows.Forms.DataGridCell dc = this.dataGrid1.CurrentCell;
				if(dc.ColumnNumber >= 2 && dc.ColumnNumber <= 4){
					string _val = this.ds.Tables[0].Rows[dc.RowNumber][dc.ColumnNumber].ToString();
					DataGridTextBoxColumn dgtb = (DataGridTextBoxColumn)this.dataGrid1.TableStyles[0].GridColumnStyles[dc.ColumnNumber]; 
					if(_val == "√"){
						((CheckBox)dgtb.TextBox.Controls[0]).Checked = true;
					}else{
						((CheckBox)dgtb.TextBox.Controls[0]).Checked = false;
					}
				}
				*/
			}
		}

		private void dataGrid1_CurrentCellChanged(object sender, System.EventArgs e) {
			if(((DataTable)this.dataGrid1.DataSource).Rows.Count > 0 && this.needSave){
				//if(MessageBox.Show("数据已更改，是否保存？","更改确认",MessageBoxButtons.YesNo,MessageBoxIcon.Question) == DialogResult.Yes){
					//
				//}

				this.needSave = false;
			}
		}
	}
}