实例介绍
【实例简介】
主要实现了支持多条件查询、批量填写进货单及销售单、与代理商和供应商往来账本明细,绝不存在假账、漏账、差账等情况、图表分析月销售状况、当外界环境(停电、网络病毒)干扰本系统时,系统可以自动保护原始数据的安全、强大的报表打印等功能。
【实例截图】
【核心代码】
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
{
public partial class frmBuyStock : Form
{
BaseClass.BaseInfo baseinfo = new EMS.BaseClass.BaseInfo();
BaseClass.cBillInfo billinfo = new EMS.BaseClass.cBillInfo();
BaseClass.cCurrentAccount currentAccount = new EMS.BaseClass.cCurrentAccount();
BaseClass.cStockInfo stockinfo = new EMS.BaseClass.cStockInfo();
public frmBuyStock()
{
InitializeComponent();
}
{
txtBillDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
string P_Str_newBillCode = "";
int P_Int_newBillCode = 0;
if (ds.Tables[0].Rows.Count == 0)
{
txtBillCode.Text = DateTime.Now.ToString("yyyyMMdd") "JH" "1000001";
}
else
{
P_Str_newBillCode = Convert.ToString(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["billcode"]);
P_Int_newBillCode = Convert.ToInt32(P_Str_newBillCode.Substring(10, 7)) 1;
P_Str_newBillCode = DateTime.Now.ToString("yyyyMMdd") "JH" P_Int_newBillCode.ToString();
txtBillCode.Text = P_Str_newBillCode;
}
txtHandle.Focus();
}
{
EMS.SelectDataDialog.frmSelectHandle selecthandle;
selecthandle= new EMS.SelectDataDialog.frmSelectHandle();
selecthandle.buyStock = this; //将新创建的窗体对象设置为同一个窗体类的实例(对象)
selecthandle.M_str_object = "BuyStock"; //用于识别 是那一个窗体调用的selecthandle窗口的
selecthandle.ShowDialog();
}
{
//往来单位和经手人不能为空!
if (txtHandle.Text == string.Empty || txtUnits.Text == string.Empty)
{
MessageBox.Show("供货单位和经手人为必填项!", "错误提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
//列表中数据不能为空
if (Convert.ToString(dgvStockList[3, 0].Value) == string.Empty || Convert.ToString(dgvStockList[4, 0].Value) == string.Empty || Convert.ToString(dgvStockList[5, 0].Value) == string.Empty)
{
MessageBox.Show("请核实列表中数据:‘数量’、‘单价’、‘金额’不能为空!", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//应付金额不能为空
if (txtFullPayment.Text.Trim() == "0")
{
MessageBox.Show("应付金额不能为‘0’!", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
billinfo.BillCode = txtBillCode.Text;
billinfo.Handle = txtHandle.Text;
billinfo.Units = txtUnits.Text;
billinfo.Summary = txtSummary.Text;
billinfo.FullPayment =Convert.ToSingle(txtFullPayment.Text);
billinfo.Payment = Convert.ToSingle(txtpayment.Text);
//执行添加
baseinfo.AddTableMainWarehouse(billinfo, "tb_warehouse_main");
for (int i = 0; i < dgvStockList.RowCount-1; i )
{
billinfo.BillCode = txtBillCode.Text;
billinfo.TradeCode = dgvStockList[0, i].Value.ToString();
billinfo.FullName = dgvStockList[1, i].Value.ToString();
billinfo.TradeUnit = dgvStockList[2, i].Value.ToString();
billinfo.Qty = Convert.ToSingle(dgvStockList[3, i].Value.ToString());
billinfo.Price = Convert.ToSingle(dgvStockList[4, i].Value.ToString());
billinfo.TSum = Convert.ToSingle(dgvStockList[5, i].Value.ToString());
//执行多行录入数据(添加到明细表中)
baseinfo.AddTableDetailedWarehouse(billinfo, "tb_warehouse_detailed");
//更改库存数量和加权平均价格
DataSet ds = null;
stockinfo.TradeCode=dgvStockList[0, i].Value.ToString();
ds=baseinfo.GetStockByTradeCode(stockinfo, "tb_Stock");
stockinfo.Price =Convert.ToSingle(ds.Tables[0].Rows[0]["price"]);
stockinfo.AveragePrice = Convert.ToSingle(ds.Tables[0].Rows[0]["averageprice"]);
//处理--加权平均价格
if (stockinfo.Price == 0)
{
stockinfo.AveragePrice = billinfo.Price; //第一次进货时,加权平均价格等于进货价格
stockinfo.Price = billinfo.Price;
}
else
{
//加权平均价格=(加权平均价*库存总数量 本次进货价格*本次进货数量)/(库存总数量 本次进货数量)
stockinfo.AveragePrice = ((stockinfo.AveragePrice * stockinfo.Qty billinfo.Price * billinfo.Qty) / (stockinfo.Qty billinfo.Qty));
}
//更新--商品库存数量
stockinfo.Qty = stockinfo.Qty billinfo.Qty;
int d = baseinfo.UpdateStock_QtyAndAveragerprice(stockinfo);
}
//向往来单位明细表--录入数据--这样以来为分析
currentAccount.BillCode = txtBillCode.Text;
currentAccount.ReduceGathering =Convert.ToSingle(txtFullPayment.Text);
currentAccount.FactReduceGathering =Convert.ToSingle(txtpayment.Text);
currentAccount.Balance =Convert.ToSingle(txtBalance.Text);
currentAccount.Units = txtUnits.Text;
//执行添加
int ca = baseinfo.AddCurrentAccount(currentAccount);
MessageBox.Show("进货单--过账成功!","成功提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
this.Close();
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
{
public partial class frmBuyStock : Form
{
BaseClass.BaseInfo baseinfo = new EMS.BaseClass.BaseInfo();
BaseClass.cBillInfo billinfo = new EMS.BaseClass.cBillInfo();
BaseClass.cCurrentAccount currentAccount = new EMS.BaseClass.cCurrentAccount();
BaseClass.cStockInfo stockinfo = new EMS.BaseClass.cStockInfo();
public frmBuyStock()
{
InitializeComponent();
}
{
txtBillDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
string P_Str_newBillCode = "";
int P_Int_newBillCode = 0;
if (ds.Tables[0].Rows.Count == 0)
{
txtBillCode.Text = DateTime.Now.ToString("yyyyMMdd") "JH" "1000001";
}
else
{
P_Str_newBillCode = Convert.ToString(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["billcode"]);
P_Int_newBillCode = Convert.ToInt32(P_Str_newBillCode.Substring(10, 7)) 1;
P_Str_newBillCode = DateTime.Now.ToString("yyyyMMdd") "JH" P_Int_newBillCode.ToString();
txtBillCode.Text = P_Str_newBillCode;
}
txtHandle.Focus();
}
{
EMS.SelectDataDialog.frmSelectHandle selecthandle;
selecthandle= new EMS.SelectDataDialog.frmSelectHandle();
selecthandle.buyStock = this; //将新创建的窗体对象设置为同一个窗体类的实例(对象)
selecthandle.M_str_object = "BuyStock"; //用于识别 是那一个窗体调用的selecthandle窗口的
selecthandle.ShowDialog();
}
{
//往来单位和经手人不能为空!
if (txtHandle.Text == string.Empty || txtUnits.Text == string.Empty)
{
MessageBox.Show("供货单位和经手人为必填项!", "错误提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
//列表中数据不能为空
if (Convert.ToString(dgvStockList[3, 0].Value) == string.Empty || Convert.ToString(dgvStockList[4, 0].Value) == string.Empty || Convert.ToString(dgvStockList[5, 0].Value) == string.Empty)
{
MessageBox.Show("请核实列表中数据:‘数量’、‘单价’、‘金额’不能为空!", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//应付金额不能为空
if (txtFullPayment.Text.Trim() == "0")
{
MessageBox.Show("应付金额不能为‘0’!", "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
billinfo.BillCode = txtBillCode.Text;
billinfo.Handle = txtHandle.Text;
billinfo.Units = txtUnits.Text;
billinfo.Summary = txtSummary.Text;
billinfo.FullPayment =Convert.ToSingle(txtFullPayment.Text);
billinfo.Payment = Convert.ToSingle(txtpayment.Text);
//执行添加
baseinfo.AddTableMainWarehouse(billinfo, "tb_warehouse_main");
for (int i = 0; i < dgvStockList.RowCount-1; i )
{
billinfo.BillCode = txtBillCode.Text;
billinfo.TradeCode = dgvStockList[0, i].Value.ToString();
billinfo.FullName = dgvStockList[1, i].Value.ToString();
billinfo.TradeUnit = dgvStockList[2, i].Value.ToString();
billinfo.Qty = Convert.ToSingle(dgvStockList[3, i].Value.ToString());
billinfo.Price = Convert.ToSingle(dgvStockList[4, i].Value.ToString());
billinfo.TSum = Convert.ToSingle(dgvStockList[5, i].Value.ToString());
//执行多行录入数据(添加到明细表中)
baseinfo.AddTableDetailedWarehouse(billinfo, "tb_warehouse_detailed");
//更改库存数量和加权平均价格
DataSet ds = null;
stockinfo.TradeCode=dgvStockList[0, i].Value.ToString();
ds=baseinfo.GetStockByTradeCode(stockinfo, "tb_Stock");
stockinfo.Price =Convert.ToSingle(ds.Tables[0].Rows[0]["price"]);
stockinfo.AveragePrice = Convert.ToSingle(ds.Tables[0].Rows[0]["averageprice"]);
//处理--加权平均价格
if (stockinfo.Price == 0)
{
stockinfo.AveragePrice = billinfo.Price; //第一次进货时,加权平均价格等于进货价格
stockinfo.Price = billinfo.Price;
}
else
{
//加权平均价格=(加权平均价*库存总数量 本次进货价格*本次进货数量)/(库存总数量 本次进货数量)
stockinfo.AveragePrice = ((stockinfo.AveragePrice * stockinfo.Qty billinfo.Price * billinfo.Qty) / (stockinfo.Qty billinfo.Qty));
}
//更新--商品库存数量
stockinfo.Qty = stockinfo.Qty billinfo.Qty;
int d = baseinfo.UpdateStock_QtyAndAveragerprice(stockinfo);
}
//向往来单位明细表--录入数据--这样以来为分析
currentAccount.BillCode = txtBillCode.Text;
currentAccount.ReduceGathering =Convert.ToSingle(txtFullPayment.Text);
currentAccount.FactReduceGathering =Convert.ToSingle(txtpayment.Text);
currentAccount.Balance =Convert.ToSingle(txtBalance.Text);
currentAccount.Units = txtUnits.Text;
//执行添加
int ca = baseinfo.AddCurrentAccount(currentAccount);
MessageBox.Show("进货单--过账成功!","成功提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
this.Close();
}
网友评论
小贴士
感谢您为本站写下的评论,您的评论对其它用户来说具有重要的参考价值,所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙,所以请不要反馈意义不大的重复字符,也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享,对搜索内容的合法性不具有预见性、识别性、控制性,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论平台是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定,若资源存在侵权或相关问题请联系本站客服人员,点此联系我们。关于更多版权及免责申明参见 版权及免责申明
支持(0) 盖楼(回复)