private int SelectLastIdFromBill() { string sql = "select top 1 * from " + Program.DataBaseName + "..MD_Bill order by id desc"; List <SqlParameter> list = new List <SqlParameter>(); return((int)DataAccessUtil.ExecuteScalar(sql, list)); }
private void btnShadowe_ItemClick(object sender, ItemClickEventArgs e) { string sql = "select TOP 1 * from " + Program.DataBaseName + "..MD_BillItem" + " order by id desc"; List <SqlParameter> list = new List <SqlParameter>(); int id = Convert.ToInt32(DataAccessUtil.ExecuteScalar(sql, list)); FillDataToViews(id); }
private void btnNext_ItemClick(object sender, ItemClickEventArgs e) { string sql = "select isnull(min(id),0) from MD_Bill where id >" + _flag + " and BillType_ID=0"; List <SqlParameter> list = new List <SqlParameter>(); object value = DataAccessUtil.ExecuteScalar(sql, list); if (value != null) { int tempId = Convert.ToInt32(value); FillDataToViews(tempId); if (tempId != 0) { _flag = tempId; } } }
private void btnUp_ItemClick(object sender, ItemClickEventArgs e) { string sql = "select isnull(max(id),0) from MD_Bill where id <" + _flag + " and BillType_ID=0"; List <SqlParameter> list = new List <SqlParameter>(); int tempId = Convert.ToInt32(DataAccessUtil.ExecuteScalar(sql, list)); if (tempId > 0) { FillDataToViews(tempId); if (tempId != 0) { _flag = tempId; } } else { MessageBox.Show("当前已经是第一条单据了", "提示!!!", MessageBoxButtons.OK); return; } }
private bool SumGoodsCount(string goodsName, string count) { string sql = "select isnull(sum(bi.count),0) from MD_BillItem as bi inner join MD_Bill as b on bi.Bill_ID=b.ID where bi.GoodsName=" + goodsName + " and b.BillType_ID=1"; List <SqlParameter> list = new List <SqlParameter>(); int inCount = Convert.ToInt32(DataAccessUtil.ExecuteScalar(sql, list)); if (inCount > 0) { int i = inCount + Convert.ToInt32(count); sql = "update MD_BillItem set count=" + i + " where GoodsName=" + goodsName; List <SqlParameter> s = new List <SqlParameter>(); DataAccessUtil.ExecuteNonQuery(sql, s); return(true); } else { return(false); } }
private void CheckFormData() { if (gridView1.RowCount <= 0) { return; } for (int i = 0; i <= gridView1.RowCount - 1; i++) { DataRow row = gridView1.GetDataRow(i); string goodsCode = row["GoodsCode"].ToString(); string goodsName = row["GoodsName"].ToString(); string goodsFromNameId = row["GoodsFromName"].ToString(); string goodsCategoryNameId = row["GoodsCategoryName"].ToString(); string unitPrice = row["UnitPrice"].ToString(); string count = row["Count"].ToString(); if (!string.IsNullOrEmpty(unitPrice) && !string.IsNullOrEmpty(count)) { row["Total"] = Convert.ToDecimal(unitPrice) * Convert.ToDecimal(count); } string total = row["Total"].ToString(); CheckDataIsValid(goodsCode, goodsName, goodsFromNameId, goodsCategoryNameId, unitPrice, count, total); //3,进行更改数据库中的数据 var billItemId = Convert.ToInt32(Tag); var billId = DataAccessUtil.ExecuteScalar("Select Bill_ID from MD_BillItem where ID=" + billItemId, new List <SqlParameter>()); string sqlbi = "update bi set bi.GoodsCode=@code, bi.GoodsName=@gnid," + "bi.GoodsFrom_Id=@gfid, bi.GoodsCategory_ID=@gcid, " + "bi.UnitPrice=@up, bi.Count=@cou, bi.Total=@tol " + // "b.Storehouse_ID=@sid, b.BillType_ID=@bid, " + // "b.Maker=@maker, b.MakeDate=@md, b.Company_ID=@cid, b.BillCode=@bc " + "from MD_BillItem as bi inner join MD_Bill as b" + " on bi.Bill_ID=b.ID where bi.id=" + billItemId; string sqlb = "update b set b.Storehouse_ID=@sid, b.BillType_ID=@bid, " + "b.Maker=@maker,b.MakeDate=@md,b.Company_ID=@cid,b.BillCode=@bc" + " from MD_Bill as b where b.id = " + billId; List <SqlParameter> list = new List <SqlParameter>() { new SqlParameter("@code", goodsCode), new SqlParameter("@gnid", goodsName), new SqlParameter("@gfid", goodsFromNameId), new SqlParameter("@gcid", goodsCategoryNameId), new SqlParameter("@up", unitPrice), new SqlParameter("@cou", count), new SqlParameter("@tol", total), }; List <SqlParameter> listP = new List <SqlParameter>() { new SqlParameter("@sid", lueStorehouse.EditValue), new SqlParameter("@bid", true), //1入库,0出库 new SqlParameter("@maker", txtMaker.Text.Trim()), new SqlParameter("@md", deTime.Text.Trim()), new SqlParameter("@cid", lueCompany.EditValue), new SqlParameter("@bc", txtPurOddNumber.Text.Trim()) }; if (DataAccessUtil.ExecuteNonQuery(sqlbi, list) > 0 && DataAccessUtil.ExecuteNonQuery(sqlb, listP) > 0) { MessageBox.Show("当前修改已经成功..", "提示!!!", MessageBoxButtons.OK); Close(); } } }