实例介绍
【实例简介】
【实例截图】
【核心代码】
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CHEXC.ClassInfo;
using CHEXC.GoodMenhod;
using System.Data.SqlClient;
namespace CHEXC
{
public partial class frmJhGoodsInfo : Form
{
public frmJhGoodsInfo()
{
InitializeComponent();
}
public frmJhGoodsInfo(int intCdo)
{
InitializeComponent();
}
tb_JhGoodsInfo jhGood=new tb_JhGoodsInfo();
tb_JhGoodsInfoMenthod jhMenthod=new tb_JhGoodsInfoMenthod();
public static int intFalg = 0;
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.tollDelete.Enabled = !this.tollDelete.Enabled;
}
public void ClearContorl()
{
txtGoodsNum.Text = "";
txtGoodsRemark.Text = "";
txtGoodsSellPrice.Text = "";
txtJhCompName.Text = "";
txtGoodsNoPrice.Text = "";
txtGoodsNeedPrice.Text = "";
txtGoodsName.Text = "";
txtGoodsJhPrice.Text = "";
txtGoodsID.Text = "";
txtEmpId.Text = "";
cmbDepotName.Text = "";
}
public int getIntCount()
{
int intReslut = 0;
if (intFalg == 1)
{
if (txtGoodsID.Text == "")
{
MessageBox.Show("商品编号不能为空！");
return intReslut;
}
if (txtGoodsName.Text == "")
{
MessageBox.Show("商品名称不能为空！");
return intReslut;
}
if (txtJhCompName.Text == "")
{
MessageBox.Show("供应商名称不能为空！");
return intReslut;
}
if (txtEmpId.Text == "")
{
MessageBox.Show("进货人姓名不能为空！");
return intReslut;
}
if (txtGoodsNum.Text == "")
{
MessageBox.Show("数量不能为空！");
return intReslut;
}
if (txtGoodsName.Text == "")
{
MessageBox.Show("进货单价不能为空！");
return intReslut;
}
}
if (intFalg == 2)
{
if (txtGoodsID.Text == "")
{
MessageBox.Show("商品编号不能为空！,选择要修改记录","提示");
return intReslut;
}
}
if (intFalg == 3)
{
if (txtGoodsID.Text == "")
{
MessageBox.Show("商品编号不能为空！,选择要删除记录", "提示");
return intReslut;
}
}
jhGood.strGoodsID = txtGoodsID.Text;
jhGood.strEmpId = txtEmpId.Text;
jhGood.strJhCompName = txtGoodsName.Text;
jhGood.strDepotName = cmbDepotName.Text;
jhGood.strGoodsNum = Convert.ToInt32(txtGoodsNum.Text);
jhGood.strGoodsName = txtGoodsName.Text;
jhGood.strGoodsUnit = cmbGoodsUnit.Text;
jhGood.deGoodsJhPrice = txtGoodsJhPrice.Text;
jhGood.deGoodsNeedPrice = txtGoodsNeedPrice.Text;
jhGood.deGoodsNoPrice = txtGoodsNoPrice.Text;
jhGood.deGoodsSellPrice = txtGoodsSellPrice.Text;
jhGood.strGoodsRemark = txtGoodsRemark.Text;
jhGood.DaGoodTime = dateTimePicker1.Value;
if (intFalg != 3)
{
jhGood.Falg = 0;
}
else
{
jhGood.Falg = 1;
}
intReslut = 1;
return intReslut;
}
private void frmJhGoodsInfo_Load(object sender, EventArgs e)
{
jhMenthod.tb_JhGoodsInfoFind("", 5, dataGridView1);
}
private void FillControls()
{
try
{
SqlDataReader sqldr = jhMenthod.tb_JhGoodsInfoFind(this.dataGridView1[0, this.dataGridView1.CurrentCell.RowIndex].Value.ToString(),1);
sqldr.Read();
if (sqldr.HasRows)
{
txtEmpId.Text=sqldr[1].ToString();
txtGoodsName.Text=sqldr[4].ToString();
cmbDepotName.Text = sqldr[3].ToString();
txtGoodsNum.Text=sqldr[5].ToString();
cmbGoodsUnit.Text=sqldr[6].ToString();
txtGoodsJhPrice.Text=sqldr[7].ToString();
txtGoodsNeedPrice.Text=sqldr[9].ToString();
txtGoodsNoPrice.Text=sqldr[10].ToString();
txtGoodsSellPrice.Text=sqldr[8].ToString();
txtGoodsRemark.Text=sqldr[11].ToString();
txtJhCompName.Text = sqldr[2].ToString();
txtGoodsID.Text = sqldr[0].ToString();
txtGoodsID.Enabled = false;
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
}
private void toolAdd_Click(object sender, EventArgs e)
{
ControlStatus();
ClearContorl();
intFalg = 1;//添加标记
txtGoodsID.Text = jhMenthod.JhGoodsID();
txtGoodsID.Enabled = false;
}
private void toolAmend_Click(object sender, EventArgs e)
{
ControlStatus();
ClearContorl();
intFalg = 2;//添加标记
}
private void toolrefulsh_Click(object sender, EventArgs e)
{
ControlStatus();
ClearContorl();
}
private void toolExit_Click(object sender, EventArgs e)
{
this.Close();
}
private void toolCancel_Click(object sender, EventArgs e)
{
ControlStatus();
ClearContorl();
}
private void toolSave_Click(object sender, EventArgs e)
{
if (getIntCount() == 1)
{
if (intFalg == 1)
{
if (jhMenthod.tb_JhGoodsInfoMenthodAdd(jhGood)==2)
{
MessageBox.Show("添加成功","提示");
intFalg = 0;
jhMenthod.tb_JhGoodsInfoFind("",5,dataGridView1);
ControlStatus();
ClearContorl();
}
else
{
MessageBox.Show("添加失败", "提示");
intFalg = 0;
jhMenthod.tb_JhGoodsInfoFind("", 5, dataGridView1);
ControlStatus();
ClearContorl();
}
}
if (intFalg == 2)
{
if (jhMenthod.tb_JhGoodsInfoMenthodUpdate(jhGood)==1)
{
MessageBox.Show("修改成功", "提示");
intFalg = 0;
jhMenthod.tb_JhGoodsInfoFind("", 5, dataGridView1);
ControlStatus();
ClearContorl();
}
else
{
MessageBox.Show("修改失败", "提示");
intFalg = 0;
jhMenthod.tb_JhGoodsInfoFind("", 5, dataGridView1);
ControlStatus();
ClearContorl();
}
}
if (intFalg == 3)
{
if (jhMenthod.tb_JhGoodsInfoMenthodDelete(jhGood)==1)
{
MessageBox.Show("删除成功", "提示");
intFalg = 0;
jhMenthod.tb_JhGoodsInfoFind("", 5, dataGridView1);
ControlStatus();
ClearContorl();
}
else
{
MessageBox.Show("删除失败", "提示");
intFalg = 0;
jhMenthod.tb_JhGoodsInfoFind("", 5, dataGridView1);
ControlStatus();
ClearContorl();
}
}
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (intFalg == 2 || intFalg == 3)
{
FillControls();
}
}
private void txtGoodsJhPrice_TextChanged(object sender, EventArgs e)
{
if (txtGoodsNum.Text != "")
{
txtGoodsNeedPrice.Text = Convert.ToString(Convert.ToInt32(txtGoodsJhPrice.Text)*Convert.ToInt32(txtGoodsNum.Text));
}
}
private void txtGoodsSellPrice_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar != 8 && !char.IsDigit(e.KeyChar)&&e.KeyChar!='.')
{
MessageBox.Show("请输入数字");
e.Handled = true;
}
}
private void txtGoodsNum_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar != 8 && !char.IsDigit(e.KeyChar))
{
MessageBox.Show("请输入数字");
e.Handled = true;
}
}
private void txtGoodsJhPrice_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar != 8 && !char.IsDigit(e.KeyChar) && e.KeyChar != '.')
{
MessageBox.Show("请输入数字");
e.Handled = true;
}
}
private void txtGoodsNoPrice_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar != 8 && !char.IsDigit(e.KeyChar) && e.KeyChar != '.')
{
MessageBox.Show("请输入数字");
e.Handled = true;
}
}
//供应商信息
private void button1_Click(object sender, EventArgs e)
{
frmGonYingShang frmgong = new frmGonYingShang();
frmgong.Owner = this;
frmgong.ShowDialog();
}
private void tollDelete_Click(object sender, EventArgs e)
{
ControlStatus();
ClearContorl();
intFalg = 3;//添加标记
}
}
}
好例子网口号：伸出你的我的手 — 分享！
网友评论
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
支持(0) 盖楼(回复)