public void showPre()
{
Dong.BLL.SaleInfo bSaleInfo = new Dong.BLL.SaleInfo();
Dong.Model.SaleInfo mSaleInfo = new Dong.Model.SaleInfo();
mSaleInfo = bSaleInfo.GetPreModel(Dong.Model.GlobalsInfo.UserName);
lblPreBillNo.Text = mSaleInfo.Pid;
lblPreBillCash.Text = string.Format("{0:F2}", mSaleInfo.Price.ToString());
lblPreTime.Text = mSaleInfo.IDate.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dong.Model.SaleInfo DataRowToModel(DataRow row)
{
Dong.Model.SaleInfo model = new Dong.Model.SaleInfo();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["Pid"] != null)
{
model.Pid = row["Pid"].ToString();
}
if (row["GoodsCode"] != null)
{
model.GoodsCode = row["GoodsCode"].ToString();
}
if (row["Counts"] != null && row["Counts"].ToString() != "")
{
model.Counts = int.Parse(row["Counts"].ToString());
}
if (row["Price"] != null && row["Price"].ToString() != "")
{
model.Price = double.Parse(row["Price"].ToString());
}
if (row["PriceSum"] != null && row["PriceSum"].ToString() != "")
{
model.Price = double.Parse(row["PriceSum"].ToString());
}
if (row["VipCode"] != null && row["VipCode"].ToString() != "")
{
model.VipCode = row["VipCode"].ToString();
}
if (row["IDate"] != null && row["IDate"].ToString() != "")
{
model.IDate = DateTime.Parse(row["IDate"].ToString());
}
if (row["Oper"] != null)
{
model.Oper = row["Oper"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Dong.Model.SaleInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SaleInfo set ");
strSql.Append("GoodsCode=@GoodsCode,");
strSql.Append("Counts=@Counts,");
strSql.Append("Price=@Price,");
strSql.Append("IDate=@IDate,");
strSql.Append("Oper=@Oper");
strSql.Append(" where Pid=@Pid ");
OleDbParameter[] parameters =
{
new OleDbParameter("@GoodsCode", OleDbType.VarChar, 50),
new OleDbParameter("@Counts", OleDbType.Integer, 4),
new OleDbParameter("@Price", OleDbType.Integer, 4),
new OleDbParameter("@IDate", OleDbType.Date),
new OleDbParameter("@Oper", OleDbType.VarChar, 50),
new OleDbParameter("@Id", OleDbType.Integer, 4),
new OleDbParameter("@Pid", OleDbType.VarChar, 50)
};
parameters[0].Value = model.GoodsCode;
parameters[1].Value = model.Counts;
parameters[2].Value = model.Price;
parameters[3].Value = model.IDate;
parameters[4].Value = model.Oper;
parameters[5].Value = model.Id;
parameters[6].Value = model.Pid;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Dong.Model.SaleInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SaleInfo(");
strSql.Append("Pid,GoodsCode,Counts,Price,PriceSum,VipCode,IDate,Oper)");
strSql.Append(" values (");
strSql.Append("@Pid,@GoodsCode,@Counts,@Price,@PriceSum,@VipCode,@IDate,@Oper)");
OleDbParameter[] parameters =
{
new OleDbParameter("@Pid", OleDbType.VarChar, 50),
new OleDbParameter("@GoodsCode", OleDbType.VarChar, 50),
new OleDbParameter("@Counts", OleDbType.Integer, 4),
new OleDbParameter("@Price", OleDbType.Double, 4),
new OleDbParameter("@PriceSum", OleDbType.Double, 4),
new OleDbParameter("@VipCode", OleDbType.VarChar, 50),
new OleDbParameter("@IDate", OleDbType.Date),
new OleDbParameter("@Oper", OleDbType.VarChar, 50)
};
parameters[0].Value = model.Pid;
parameters[1].Value = model.GoodsCode;
parameters[2].Value = model.Counts;
parameters[3].Value = model.Price;
parameters[4].Value = model.PriceSum;
parameters[5].Value = model.VipCode;
parameters[6].Value = model.IDate;
parameters[7].Value = model.Oper;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void Cash()
{
if (tbZL.Text.Trim() == "")
{
tbZL.Text = string.Format("{0:F2}", (double.Parse(tbSSJE.Text.Trim()) - double.Parse(tbYS.Text.Trim())));
}
else
{
Dong.BLL.GoodsInfo bGoods = new Dong.BLL.GoodsInfo();
Dong.BLL.SaleInfo bSale = new Dong.BLL.SaleInfo();
Dong.Model.SaleInfo mSale = new Dong.Model.SaleInfo();
frmCash frmP = (frmCash)this.Owner;
DataGridView dgv = (DataGridView)frmP.Controls.Find("dGV", true)[0];
for (int i = 0; i < dgv.Rows.Count; i++)
{
//添加销售记录
double price = double.Parse(dgv.Rows[i].Cells[4].Value.ToString());
mSale.Pid = Dong.Model.GlobalsInfo.bill;
mSale.GoodsCode = dgv.Rows[i].Cells[0].Value.ToString();
mSale.Counts = int.Parse(dgv.Rows[i].Cells[3].Value.ToString());
mSale.Price = price;
mSale.PriceSum = double.Parse(tbYS.Text);
mSale.VipCode = Dong.Model.GlobalsInfo.vipCode;
mSale.Oper = Dong.Model.GlobalsInfo.UserName;
mSale.IDate = DateTime.Now;
bSale.Add(mSale);
//减少货物质量
bGoods.UpdateCount(int.Parse(dgv.Rows[i].Cells[3].Value.ToString()), dgv.Rows[i].Cells[0].Value.ToString());
}
frmP.ClearForm();
frmP.showPre();
this.Close();
}
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* OleDbParameter[] parameters = {
* new OleDbParameter("@tblName", OleDbType.VarChar, 255),
* new OleDbParameter("@fldName", OleDbType.VarChar, 255),
* new OleDbParameter("@PageSize", OleDbType.Integer),
* new OleDbParameter("@PageIndex", OleDbType.Integer),
* new OleDbParameter("@IsReCount", OleDbType.Boolean),
* new OleDbParameter("@OrderType", OleDbType.Boolean),
* new OleDbParameter("@strWhere", OleDbType.VarChar,1000),
* };
* parameters[0].Value = "SaleInfo";
* parameters[1].Value = "Pid";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperOleDb.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 得到一个最新一个对象
/// </summary>
public Dong.Model.SaleInfo GetPreModel(string Oper)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from SaleInfo ");
strSql.Append(" where Oper=@Oper order by id desc");
OleDbParameter[] parameters =
{
new OleDbParameter("@Oper", OleDbType.VarChar, 50)
};
parameters[0].Value = Oper;
Dong.Model.SaleInfo model = new Dong.Model.SaleInfo();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dong.Model.SaleInfo GetModel(string Pid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,Pid,GoodsCode,Counts,Price,IDate,Oper from SaleInfo ");
strSql.Append(" where Pid=@Pid ");
OleDbParameter[] parameters =
{
new OleDbParameter("@Pid", OleDbType.VarChar, 50)
};
parameters[0].Value = Pid;
Dong.Model.SaleInfo model = new Dong.Model.SaleInfo();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}