📄 jzgl.cs
字号:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace 中小型酒店管理信息系统
{
/// <summary>
/// jzgl 的摘要说明。
/// </summary>
public class jzgl : System.Windows.Forms.Form
{
private System.Windows.Forms.ImageList imageList1;
private System.Windows.Forms.ToolBar toolBar1;
private System.Windows.Forms.ToolBarButton tbarBtnSave;
private System.Windows.Forms.ToolBarButton tbarBtnDelete;
private System.Windows.Forms.ComboBox comboBox1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.RichTextBox richTextBox1;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.TextBox textBox5;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.TextBox textBox6;
private System.Windows.Forms.TextBox textBox7;
private System.Windows.Forms.Label label9;
private System.Windows.Forms.TextBox textBox8;
private System.Windows.Forms.CheckBox checkBox1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.DataGrid dgrd_StockerData;
private System.ComponentModel.IContainer components;
private DataSet ds = new DataSet();
private DataSet ds1 = new DataSet();
private DataSet ds2 = new DataSet();
private DataSet ds3 = new DataSet();
private DataSet ds4 = new DataSet();
private LinkDataBase link = new LinkDataBase();
private LinkDataBase link1 = new LinkDataBase();
private LinkDataBase link2 = new LinkDataBase();
private LinkDataBase link3 = new LinkDataBase();
private LinkDataBase link4 = new LinkDataBase();
public bool que=false;
public jzgl()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
DateTime dt = DateTime.Now;
string shijian = dt.Year.ToString()+"-"+dt.Month.ToString()+"-"+dt.Day.ToString();
string sendTableName = "jud_gzxx";
string sendStrSQL ="select bh as '编号',pzhm as '凭证号码',rq as '日期',dwbh as '单位名称',zy as '摘要',zsje as '住宿金额',qkje as '欠款金额',hkje as '还款金额',jelj as '金额累计',xm as '姓名',zjmc as '证件名称',zjhm as '证件号码',sj as '时间',sfjq as '是否结清' from jud_gzxx where rq>='"+shijian+"'";
ds1 = link1.SelectDataBase(sendStrSQL,sendTableName);
this.dgrd_StockerData.DataSource = ds1;
this.dgrd_StockerData.DataMember = "jud_gzxx";
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(jzgl));
this.imageList1 = new System.Windows.Forms.ImageList(this.components);
this.toolBar1 = new System.Windows.Forms.ToolBar();
this.tbarBtnSave = new System.Windows.Forms.ToolBarButton();
this.tbarBtnDelete = new System.Windows.Forms.ToolBarButton();
this.comboBox1 = new System.Windows.Forms.ComboBox();
this.button1 = new System.Windows.Forms.Button();
this.label1 = new System.Windows.Forms.Label();
this.textBox1 = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.textBox2 = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.richTextBox1 = new System.Windows.Forms.RichTextBox();
this.label4 = new System.Windows.Forms.Label();
this.textBox3 = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.textBox4 = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
this.textBox5 = new System.Windows.Forms.TextBox();
this.label7 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.textBox6 = new System.Windows.Forms.TextBox();
this.textBox7 = new System.Windows.Forms.TextBox();
this.label9 = new System.Windows.Forms.Label();
this.textBox8 = new System.Windows.Forms.TextBox();
this.checkBox1 = new System.Windows.Forms.CheckBox();
this.button2 = new System.Windows.Forms.Button();
this.dgrd_StockerData = new System.Windows.Forms.DataGrid();
((System.ComponentModel.ISupportInitialize)(this.dgrd_StockerData)).BeginInit();
this.SuspendLayout();
//
// imageList1
//
this.imageList1.ImageSize = new System.Drawing.Size(16, 16);
this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
//
// toolBar1
//
this.toolBar1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
this.tbarBtnSave,
this.tbarBtnDelete});
this.toolBar1.DropDownArrows = true;
this.toolBar1.ImageList = this.imageList1;
this.toolBar1.Location = new System.Drawing.Point(0, 0);
this.toolBar1.Name = "toolBar1";
this.toolBar1.ShowToolTips = true;
this.toolBar1.Size = new System.Drawing.Size(716, 29);
this.toolBar1.TabIndex = 7;
this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
//
// tbarBtnSave
//
this.tbarBtnSave.ImageIndex = 0;
this.tbarBtnSave.ToolTipText = "保存修改";
//
// tbarBtnDelete
//
this.tbarBtnDelete.ImageIndex = 1;
this.tbarBtnDelete.ToolTipText = "删除数据";
//
// comboBox1
//
this.comboBox1.Location = new System.Drawing.Point(40, 40);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(160, 20);
this.comboBox1.TabIndex = 9;
this.comboBox1.Text = "comboBox1";
//
// button1
//
this.button1.Location = new System.Drawing.Point(224, 40);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(176, 23);
this.button1.TabIndex = 10;
this.button1.Text = "选择挂账的入住登记凭证号";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// label1
//
this.label1.Location = new System.Drawing.Point(40, 80);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(32, 16);
this.label1.TabIndex = 11;
this.label1.Text = "日期";
//
// textBox1
//
this.textBox1.Enabled = false;
this.textBox1.Location = new System.Drawing.Point(80, 72);
this.textBox1.Name = "textBox1";
this.textBox1.TabIndex = 12;
this.textBox1.Text = "textBox1";
//
// label2
//
this.label2.Location = new System.Drawing.Point(208, 80);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(32, 16);
this.label2.TabIndex = 13;
this.label2.Text = "单位";
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(256, 72);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(336, 21);
this.textBox2.TabIndex = 14;
this.textBox2.Text = "textBox2";
//
// label3
//
this.label3.Location = new System.Drawing.Point(16, 112);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(32, 16);
this.label3.TabIndex = 15;
this.label3.Text = "摘要";
//
// richTextBox1
//
this.richTextBox1.Location = new System.Drawing.Point(56, 112);
this.richTextBox1.Name = "richTextBox1";
this.richTextBox1.Size = new System.Drawing.Size(640, 56);
this.richTextBox1.TabIndex = 16;
this.richTextBox1.Text = "richTextBox1";
//
// label4
//
this.label4.Location = new System.Drawing.Point(16, 184);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(56, 16);
this.label4.TabIndex = 17;
this.label4.Text = "住宿金额";
//
// textBox3
//
this.textBox3.Enabled = false;
this.textBox3.Location = new System.Drawing.Point(80, 176);
this.textBox3.Name = "textBox3";
this.textBox3.TabIndex = 18;
this.textBox3.Text = "textBox3";
//
// label5
//
this.label5.Location = new System.Drawing.Point(208, 184);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(56, 16);
this.label5.TabIndex = 19;
this.label5.Text = "欠款金额";
//
// textBox4
//
this.textBox4.Enabled = false;
this.textBox4.Location = new System.Drawing.Point(272, 176);
this.textBox4.Name = "textBox4";
this.textBox4.TabIndex = 20;
this.textBox4.Text = "textBox4";
//
// label6
//
this.label6.Location = new System.Drawing.Point(392, 184);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(64, 16);
this.label6.TabIndex = 21;
this.label6.Text = "还款金额";
//
// textBox5
//
this.textBox5.Location = new System.Drawing.Point(456, 176);
this.textBox5.Name = "textBox5";
this.textBox5.TabIndex = 22;
this.textBox5.Text = "textBox5";
//
// label7
//
this.label7.Location = new System.Drawing.Point(24, 216);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(40, 16);
this.label7.TabIndex = 23;
this.label7.Text = "姓名";
//
// label8
//
this.label8.Location = new System.Drawing.Point(208, 216);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(64, 16);
this.label8.TabIndex = 24;
this.label8.Text = "证件名称";
//
// textBox6
//
this.textBox6.Location = new System.Drawing.Point(80, 216);
this.textBox6.Name = "textBox6";
this.textBox6.TabIndex = 25;
this.textBox6.Text = "textBox6";
//
// textBox7
//
this.textBox7.Location = new System.Drawing.Point(272, 216);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -