www.pudn.com > GoodsReportManage.rar > CompanyInfo.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using GoodsReportManage.ItemClass; //添加引用
namespace GoodsReportManage.BaseRecord
{
public partial class CompanyInfo : Form
{
public CompanyInfo()
{
InitializeComponent();
}
SqlBaseClass G_SqlClass = new SqlBaseClass(); //声明数据库操作类的对象
WinOperationClass G_OperationForm = new WinOperationClass(); //声明对窗体操作的类对象
int G_Int_status; //保存操作按钮数据
///
/// 控制控件状态
///
private void ControlStatus()
{
this.toolSave.Enabled = !this.toolSave.Enabled;
this.toolAdd.Enabled = !this.toolAdd.Enabled;
this.toolCancel.Enabled = !this.toolCancel.Enabled;
this.toolAmend.Enabled = !this.toolAmend.Enabled;
this.txtAddress.ReadOnly = !this.txtAddress.ReadOnly;
this.txtCompanyName.ReadOnly = !this.txtCompanyName.ReadOnly;
this.txtDirector.ReadOnly = !this.txtDirector.ReadOnly;
this.txtFax.ReadOnly = !this.txtFax.ReadOnly;
this.txtPhone.ReadOnly = !this.txtPhone.ReadOnly;
this.txtRemark.ReadOnly = !this.txtRemark.ReadOnly;
}
///
/// 在控件中填充选中的DataGridView控件的数据
///
private void FillControls()
{
try
{
this.txtCompanyName.Text = this.dgvCompanyInfo[1, this.dgvCompanyInfo.CurrentCell.RowIndex].Value.ToString();
this.txtDirector.Text = this.dgvCompanyInfo[2, this.dgvCompanyInfo.CurrentCell.RowIndex].Value.ToString();
this.txtFax.Text = this.dgvCompanyInfo[4, this.dgvCompanyInfo.CurrentCell.RowIndex].Value.ToString();
this.txtPhone.Text = this.dgvCompanyInfo[3, this.dgvCompanyInfo.CurrentCell.RowIndex].Value.ToString();
this.txtRemark.Text = this.dgvCompanyInfo[6, this.dgvCompanyInfo.CurrentCell.RowIndex].Value.ToString();
this.txtAddress.Text = this.dgvCompanyInfo[5, this.dgvCompanyInfo.CurrentCell.RowIndex].Value.ToString();
}
catch { }
}
///
/// 将控件恢复到原始状态
///
private void ClearControls()
{
this.txtAddress.Text = "";
this.txtCompanyName.Text = "";
this.txtDirector.Text = "";
this.txtFax.Text = "";
this.txtPhone.Text = "";
this.txtRemark.Text = "";
}
private void CompanyInfo_Load(object sender, EventArgs e)
{
string cmdtxt = "SELECT CompanyID as 供应商ID,CompanyName as 供应商名称,CompanyDirector as 供应商主管,CompanyPhone as 供应商电话";
cmdtxt += ",CompanyFax as 供应商传真,CompanyAddress as 供应商地址,CompanyRemark as 备注 FROM tb_Company";
this.dgvCompanyInfo.DataSource = G_SqlClass.GetDs(cmdtxt).Tables[0];
this.cbxCondition.SelectedIndex = 0;
this.dgvCompanyInfo.Columns[0].Visible = false;
}
private void toolSave_Click(object sender, EventArgs e)
{
string P_Str_condition, P_Str_cmdtxt;
switch (G_Int_status)
{
case 1:
//下面是要执行的SQL语句
P_Str_cmdtxt = "INSERT INTO tb_Company(CompanyName,CompanyDirector,CompanyPhone,CompanyFax,CompanyAddress,CompanyRemark)";
P_Str_cmdtxt += " VALUES('" + this.txtCompanyName.Text + "','" + this.txtDirector.Text + "','" + this.txtPhone.Text + "'";
P_Str_cmdtxt += ",'" + this.txtFax.Text + "','" + this.txtAddress.Text + "','" + this.txtRemark.Text + "')";
if (this.txtCompanyName.Text == "")
{
MessageBox.Show("供应商名称不能为空！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
//执行SQL语句并返回执行结果
if (G_SqlClass.GetExecute(P_Str_cmdtxt))
{
MessageBox.Show("数据添加成功！");
ControlStatus();
}
else
{
MessageBox.Show("数据添加失败！");
}
}
break;
case 2:
P_Str_condition = this.dgvCompanyInfo[0, this.dgvCompanyInfo.CurrentCell.RowIndex].Value.ToString();
P_Str_cmdtxt = "UPDATE tb_Company SET CompanyName='" + this.txtCompanyName.Text + "',CompanyDirector='" + this.txtDirector.Text + "'";
P_Str_cmdtxt += ",CompanyPhone='" + this.txtPhone.Text + "',CompanyFax='" + this.txtFax.Text + "'";
P_Str_cmdtxt += ",CompanyAddress='" + this.txtAddress.Text + "',CompanyRemark='" + this.txtRemark.Text + "'";
P_Str_cmdtxt += " WHERE CompanyID=" + P_Str_condition + "";
if (G_SqlClass.GetExecute(P_Str_cmdtxt))
{
MessageBox.Show("数据修改成功！");
ControlStatus();
}
else
{
MessageBox.Show("数据修改失败！");
}
break;
default:
break;
//绑定数据显示控件
}
string cmdtxt = "SELECT CompanyID as 供应商ID,CompanyName as 供应商名称,CompanyDirector as 供应商主管,CompanyPhone as 供应商电话";
cmdtxt += ",CompanyFax as 供应商传真,CompanyAddress as 供应商地址,CompanyRemark as 备注 FROM tb_Company";
this.dgvCompanyInfo.DataSource = G_SqlClass.GetDs(cmdtxt).Tables[0];
}
private void toolCancel_Click(object sender, EventArgs e)
{
ControlStatus();
ClearControls();
}
private void toolAdd_Click(object sender, EventArgs e)
{
ControlStatus();
ClearControls();
G_Int_status = 1;
}
private void toolAmend_Click(object sender, EventArgs e)
{
ControlStatus();
G_Int_status = 2;
}
private void toolDelete_Click(object sender, EventArgs e)
{
string P_Str_condition = this.dgvCompanyInfo[0, this.dgvCompanyInfo.CurrentCell.RowIndex].Value.ToString();
string P_Str_cmdtxt = "DELETE FROM tb_Company WHERE CompanyID=" + P_Str_condition + "";
if (G_SqlClass.GetExecute(P_Str_cmdtxt))
{
MessageBox.Show("数据删除成功！");
}
else
{
MessageBox.Show("数据删除失败！");
}
string cmdtxt = "SELECT CompanyID as 供应商ID,CompanyName as 供应商名称,CompanyDirector as 供应商主管,CompanyPhone as 供应商电话";
cmdtxt += ",CompanyFax as 供应商传真,CompanyAddress as 供应商地址,CompanyRemark as 备注 FROM tb_Company";
this.dgvCompanyInfo.DataSource = G_SqlClass.GetDs(cmdtxt).Tables[0];
}
private void toolreflush_Click(object sender, EventArgs e)
{
string P_Str_cmdtxt = "SELECT CompanyID as 供应商ID,CompanyName as 供应商名称,CompanyDirector as 供应商主管,CompanyPhone as 供应商电话";
P_Str_cmdtxt += ",CompanyFax as 供应商传真,CompanyAddress as 供应商地址,CompanyRemark as 备注 FROM tb_Company";
this.dgvCompanyInfo.DataSource = G_SqlClass.GetDs(P_Str_cmdtxt).Tables[0];
}
private void txtOK_Click(object sender, EventArgs e)
{
string P_Str_cmdtxt = String.Empty;
string P_Str_selectcondition = this.cbxCondition.Items[this.cbxCondition.SelectedIndex].ToString();
switch (P_Str_selectcondition)
{
case "供应商名称":
P_Str_cmdtxt = "SELECT CompanyID as 供应商ID,CompanyName as 供应商名称,CompanyDirector as 供应商主管,CompanyPhone as 供应商电话";
P_Str_cmdtxt += ",CompanyFax as 供应商传真,CompanyAddress as 供应商地址,CompanyRemark as 备注 FROM tb_Company ";
P_Str_cmdtxt += " WHERE CompanyName LIKE '%" + this.txtKeyWord.Text + "%'";
this.dgvCompanyInfo.DataSource = G_SqlClass.GetDs(P_Str_cmdtxt).Tables[0];
break;
case "供应商主管":
P_Str_cmdtxt = "SELECT CompanyID as 供应商ID,CompanyName as 供应商名称,CompanyDirector as 供应商主管,CompanyPhone as 供应商电话";
P_Str_cmdtxt += ",CompanyFax as 供应商传真,CompanyAddress as 供应商地址,CompanyRemark as 备注 FROM tb_Company ";
P_Str_cmdtxt += " WHERE CompanyDirector LIKE '%" + this.txtKeyWord.Text + "%'";
this.dgvCompanyInfo.DataSource = G_SqlClass.GetDs(P_Str_cmdtxt).Tables[0];
break;
default:
break;
}
}
private void toolExit_Click(object sender, EventArgs e)
{
this.Close();
}
private void dgvCompanyInfo_CellClick(object sender, DataGridViewCellEventArgs e)
{
FillControls();
}
}
}