namespace 进销存管理系统 //---------提交修改--------
private void clickedSaveIcon()
{
try
{
//注意:必须先删除进货单明细表中的数据,然后才能再删除进货单中的数据
string sendSQL = "delete 进货单明细";
this.link.UpdateDataBase(sendSQL); //删除进货单明细中的数据
sendSQL = "delete 进货单";
this.link.UpdateDataBase(sendSQL); //删除进货单中的数据
//向进货单中写入数据
int intMaxStockNumberID= 0;
sendSQL = "select 编号 from 进货单历史";
//从进货单明细中读取"编号"列,取它的最大值，以便为新添加的数据编号
DataTable intNumberTable = this.link.SelectDataBase(sendSQL);
for (int i=0;i<intNumberTable.Rows.Count;i++)
{
if (intMaxStockNumberID < System.Int32.Parse(intNumberTable.Rows[i][0].ToString()))
{
intMaxStockNumberID = System.Int32.Parse(intNumberTable.Rows[i][0].ToString());
}
}
sendSQL = "select 编号 from 进货单";
//从进货单明细中读取"编号"列,取它的最大值，以便为新添加的数据编号
intNumberTable = this.link.SelectDataBase(sendSQL);
for (int i=0;i<intNumberTable.Rows.Count;i++)
{
if (intMaxStockNumberID < System.Int32.Parse(intNumberTable.Rows[i][0].ToString()))
{
intMaxStockNumberID = System.Int32.Parse(intNumberTable.Rows[i][0].ToString());
}
}
intMaxStockNumberID++;
string strStokerID =this.cmb_StokerID.Items[0].ToString().Trim();
string strStockDate =this.txt_StockDate.Text.Trim();
string strOperator =this.cmb_Oprater.SelectedItem.ToString().Trim();
string strMaker =this.txt_Maker.Text.Trim();
decimal decTotalCount = Decimal.Parse(this.txt_TotalCount.Text.Trim());
decimal decNoTax = Decimal.Parse(this.txt_NoTax.Text.Trim());
decimal decTax = Decimal.Parse(this.txt_Tax.Text.Trim());
string sendValues = "('" + intMaxStockNumberID +"','"+ strStokerID +"','"+ strStockDate +"','"+ strOperator +"','"+
strMaker +"','"+ decTotalCount +"','"+ decNoTax +"','"+ decTax + "')";
sendSQL = "insert 进货单 (编号,供货商号,进货日期,业务员,制单人,税价合计,不含税价,税额) values " + sendValues;
this.link.UpdateDataBase(sendSQL); //向进货单明细中写入数据
int intMaxNumberID = 0;
sendSQL = "select 编号 from 进货单明细历史";
//从进货单明细中读取"编号"列,取它的最大值，以便为新添加的数据编号
intNumberTable = this.link.SelectDataBase(sendSQL);
for (int i=0;i<intNumberTable.Rows.Count;i++)
{
if (intMaxNumberID < System.Int32.Parse(intNumberTable.Rows[i][0].ToString()))
{
intMaxNumberID = System.Int32.Parse(intNumberTable.Rows[i][0].ToString());
}
}
sendSQL = "select 编号 from 进货单明细";
//从进货单明细中读取"编号"列,取它的最大值，以便为新添加的数据编号
intNumberTable = this.link.SelectDataBase(sendSQL);
for (int i=0;i<intNumberTable.Rows.Count;i++)
{
if (intMaxNumberID < System.Int32.Parse(intNumberTable.Rows[i][0].ToString()))
{
intMaxNumberID = System.Int32.Parse(intNumberTable.Rows[i][0].ToString());
}
}
for (int row=0;row<this.newTable.Rows.Count;row++)
{
//首先判断表中的下一行数据是否为空,如果是则返回,以免因向数据库中写入空行而出错
if(this.newTable.Rows[row][0].ToString() == "")
{
sendSQL = "delete from 进货单 where 编号 = '" + intMaxStockNumberID + "'";
this.link.UpdateDataBase(sendSQL); //首先删除这次在进货单中加入的数据
break;
}
else
{
intMaxNumberID++;
string strWareID = this.dgrd_StockTable[row,0].ToString().Trim();
string strWareCount = this.dgrd_StockTable[row,1].ToString().Trim();
string strWarePrice = this.dgrd_StockTable[row,2].ToString().Trim();
string strStorageID = this.dgrd_StockTable[row,3].ToString().Trim();
decTotalCount = Decimal.Parse(this.dgrd_StockTable[row,6].ToString().Trim());
decTax = Decimal.Parse(this.dgrd_StockTable[row,8].ToString().Trim());
decNoTax = Decimal.Parse(this.dgrd_StockTable[row,9].ToString().Trim());
sendValues = "('" + intMaxNumberID +"','"+intMaxStockNumberID +"','"+ strWareID +"','"+ strWareCount +"','"+ strWarePrice +"','"+
decTotalCount +"','"+ 17 +"','"+ decNoTax +"','"+ decTax +"','"+ strStorageID + "')";
sendSQL = "insert 进货单明细 (编号,进货单号,货号,进货数量,进价,税价合计,税率,不含税价,税额,仓库) values " + sendValues;
this.link.UpdateDataBase(sendSQL);
}
}
MessageBox.Show("数据保存成功!","信息");
}
catch
{
MessageBox.Show("数据保存失败,请确认所有信息输入完整且正确!","提示");
return;
}
} //----------打印报表----------
private void clickedPrintIcon()
{
CrystalReport newCrystalReport_Stock = new CrystalReport();
newCrystalReport_Stock.ShowDialog();
Trash();
} //----------保存历史记录并清除原数据----------
private void Trash()
{
try
{
if (MessageBox.Show("要保存为历史记录吗?","询问",MessageBoxButtons.YesNo) == DialogResult.Yes)
{
this.link.UpdateDataBase("exec sf_进货单"); //调用存储过程
//清除供货商信息
this.cmb_StokerID.Items[0] = "";
this.txt_StokerName.Text = "";
//清除底部金额及税款信息
this.txt_TotalCount.Text = "0.00";
this.txt_NoTax.Text = "0.00";
this.txt_Tax.Text = "0.00";
//清除当前DataGrid中的所有数据
newTable.Clear();
//加入空行保证newTable中不为空，否则删除所有数据行后保存数据和MouseUp函数将引发异常出错
newTable.Rows.Add(newTable.NewRow());
MessageBox.Show("数据成功存入历史表!","信息");
}
}
catch
{
MessageBox.Show("数据存入历史表时出错,请检查数据库!","提示");
}
} //-------------将所选择的货物信息填入表格中---------------
private void selectWareMessage()
{
int intCurrentRowNumber = this.dgrd_StockTable.CurrentCell.RowNumber;
//判断何时需要检索数据库的商品清单,读取商品信息(以免操作数据库次数过多,影响程序性能)
if (this.dgrd_StockTable[intCurrentRowNumber,0].ToString() != "")
{
string strSearchWord = this.dgrd_StockTable[intCurrentRowNumber,0].ToString().Trim();
string sendSQL = "select 货号,品名,单位 from 商品清单 where 货号 = '" + strSearchWord + "'";
DataTable tempDataTable = this.link.SelectDataBase(sendSQL);
if (tempDataTable.Rows.Count>0)
{
inputDataGridArray[0] = tempDataTable.Rows[0][0].ToString().Trim();
inputDataGridArray[1] = tempDataTable.Rows[0][1].ToString().Trim();
inputDataGridArray[2] = tempDataTable.Rows[0][2].ToString().Trim();
this.setWareData();
}
//如果从数据库中没有检索出任何数据
else
{
//inputDataGridArray[0]赋值为当前输入的值,方便用户再次修改输入
inputDataGridArray[0] = this.dgrd_StockTable[intCurrentRowNumber,0].ToString().Trim();
inputDataGridArray[1] = "";
inputDataGridArray[2] = "";
this.setWareData();
}
}
} }
namespace 进销存管理系统
{
/// <summary>
/// StorageSearch 的摘要说明。
/// </summary>
public class StorageSearch : System.Windows.Forms.Form
{
private DataSet ds = new DataSet();
private DataView dv;
private LinkDataBase link = new LinkDataBase();
private string sendTableName = "库存商品";
private string sendStrSQL = "select 进货单明细历史.货号,拼音编码,品名,单位,仓库 " +
"from 进货单明细历史,商品清单 where 进货单明细历史.货号 = 商品清单.货号"+
"select 库存库.库存数量,库存单价,库存金额 " +
"from 库存库,进货单明细历史 where 库存库.库存数量 = 进货单明细历史.进货数量 and 库存库.库存单价 = 进货单明细历史.进价 and 库存库.库存金额 = 进货单明细历史.税价合计";
private System.ComponentModel.Container components = null; public StorageSearch()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
this.selectDataBase();
this.DataGridStateControl();
} /// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
//---------------将查询得到的仓库信息添加到下拉列表框中---------------
private void selectDataBase()
{
this.ds = this.link.SelectDataBase(sendStrSQL ,sendTableName);
this.dv = new DataView(ds.Tables[0]);
this.dgrd_StorageSearch.DataSource = dv;
this.cmb_Storage.Items.Add(""); //首先加入一个空白，以用作查询全部仓库的库存货物
//从库存库中读取所有仓库并排斥性的加入保存仓库号的组合框中
for (int i=0;i<ds.Tables[0].Rows.Count;i++)//外循环是判断库存库中的有多少行
{
for (int j=0;j<this.cmb_Storage.Items.Count;j++)//内循环是判断当前要加进去的仓库号在组合框中是否已存在
{
if (ds.Tables[0].Rows[i][4].ToString().Trim() == this.cmb_Storage.Items[j].ToString())
{
goto END;//如果组合框中已存在当前要加入的仓库号，则转到END标识处，组合框中不加入该仓库号
}
}
//如果组合框中尚不存在该仓库号，则将它加进去
this.cmb_Storage.Items.Add(ds.Tables[0].Rows[i][4].ToString().Trim());
END:{};
}
this.cmb_Storage.SelectedIndex = 0;
} //--------------根据输入查询库存中商品信息--------------
private void btn_Search_Click(object sender, System.EventArgs e)
{
string strRowFilter = "";
string strWareNumFilter ="货号 like '" + txt_WareNum.Text.Trim() + "%'";
string strWareWordFilter ="拼音编码 like '" + txt_WareWord.Text.Trim() + "%'";
int selectedNum = cmb_Storage.SelectedIndex;
string strStorageFilter ="仓库 = '" + cmb_Storage.Items[selectedNum].ToString().Trim()+ "'";
if (txt_WareNum.Text.Trim() != "")
strRowFilter += strWareNumFilter + " and ";
if (txt_WareWord.Text.Trim() != "")
strRowFilter += strWareWordFilter + " and ";
if (cmb_Storage.Items[selectedNum].ToString().Trim() != "")
strRowFilter += strStorageFilter + " and "; if (strRowFilter != "") // 存在查询条件
strRowFilter = strRowFilter.Substring(0,strRowFilter.Length-5);
dv.RowFilter = strRowFilter;
} //-----------设置表格状态--------------
private void DataGridStateControl()
{
DataGridTableStyle ts = new DataGridTableStyle();
DataGridNoActiveCellColumn aColumnTextColumn;
ts.AlternatingBackColor = Color.LightGray;
ts.MappingName = this.ds.Tables[0].TableName;
int numCols = this.ds.Tables[0].Columns.Count;
for (int i = 0;i< numCols;i++)
{
aColumnTextColumn = new DataGridNoActiveCellColumn();
aColumnTextColumn.MappingName = this.ds.Tables[0].Columns[i].ColumnName;
aColumnTextColumn.HeaderText = this.ds.Tables[0].Columns[i].ColumnName;
aColumnTextColumn.NullText = "";
aColumnTextColumn.Format = "D";
ts.GridColumnStyles.Add(aColumnTextColumn);
}
this.dgrd_StorageSearch.TableStyles.Add(ts);
} private void StorageSearch_Load(object sender, EventArgs e)
{ }
}
}