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();
}
}
}
