/// <summary>
/// 增加一条数据
/// </summary>
public void Add(RestaurantMIS.Model.Buy model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Buy(");
strSql.Append("[Saler],[Product],[Type],[Price],[Unit],[Num],[Money],[Category],[LogDate],[Memo])");
strSql.Append(" values (");
strSql.Append("@Saler,@Product,@Type,@Price,@Unit,@Num,@Money,@Category,@LogDate,@Memo)");
OleDbParameter[] parameters =
{
new OleDbParameter("@Saler", OleDbType.VarChar, 255),
new OleDbParameter("@Product", OleDbType.VarChar, 255),
new OleDbParameter("@Type", OleDbType.VarChar, 255),
new OleDbParameter("@Price", OleDbType.Decimal),
new OleDbParameter("@Unit", OleDbType.VarChar, 255),
new OleDbParameter("@Num", OleDbType.Decimal),
new OleDbParameter("@Money", OleDbType.Decimal),
new OleDbParameter("@Category", OleDbType.VarChar, 255),
new OleDbParameter("@LogDate", OleDbType.Date),
new OleDbParameter("@Memo", OleDbType.VarChar, 255)
};
parameters[0].Value = model.Saler;
parameters[1].Value = model.Product;
parameters[2].Value = model.Type;
parameters[3].Value = model.Price;
parameters[4].Value = model.Unit;
parameters[5].Value = model.Num;
parameters[6].Value = model.Money;
parameters[7].Value = model.Category;
parameters[8].Value = model.LogDate;
parameters[9].Value = model.Memo;
DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public RestaurantMIS.Model.Buy GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,Saler,Product,Type,Price,Unit,Num,Money,Category,LogDate,Memo from Buy ");
strSql.Append(" where ID=@ID ");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
RestaurantMIS.Model.Buy model = new RestaurantMIS.Model.Buy();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.Saler = ds.Tables[0].Rows[0]["Saler"].ToString();
model.Product = ds.Tables[0].Rows[0]["Product"].ToString();
model.Type = ds.Tables[0].Rows[0]["Type"].ToString();
if (ds.Tables[0].Rows[0]["Price"].ToString() != "")
{
model.Price = decimal.Parse(ds.Tables[0].Rows[0]["Price"].ToString());
}
model.Unit = ds.Tables[0].Rows[0]["Unit"].ToString();
if (ds.Tables[0].Rows[0]["Num"].ToString() != "")
{
model.Num = decimal.Parse(ds.Tables[0].Rows[0]["Num"].ToString());
}
if (ds.Tables[0].Rows[0]["Money"].ToString() != "")
{
model.Money = decimal.Parse(ds.Tables[0].Rows[0]["Money"].ToString());
}
model.Category = ds.Tables[0].Rows[0]["Category"].ToString();
if (ds.Tables[0].Rows[0]["LogDate"].ToString() != "")
{
model.LogDate = DateTime.Parse(ds.Tables[0].Rows[0]["LogDate"].ToString());
}
model.Memo = ds.Tables[0].Rows[0]["Memo"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(RestaurantMIS.Model.Buy model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Buy set ");
strSql.Append("[Saler]=@Saler,");
strSql.Append("[Product]=@Product,");
strSql.Append("[Type]=@Type,");
strSql.Append("[Price]=@Price,");
strSql.Append("[Unit]=@Unit,");
strSql.Append("[Num]=@Num,");
strSql.Append("[Money]=@Money,");
strSql.Append("[Category]=@Category,");
strSql.Append("[LogDate]=@LogDate,");
strSql.Append("[Memo]=@Memo");
strSql.Append(" where [ID]=@ID ");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.BigInt),
new OleDbParameter("@Saler", OleDbType.VarChar, 255),
new OleDbParameter("@Product", OleDbType.VarChar, 255),
new OleDbParameter("@Type", OleDbType.VarChar, 255),
new OleDbParameter("@Price", OleDbType.Decimal),
new OleDbParameter("@Unit", OleDbType.VarChar, 255),
new OleDbParameter("@Num", OleDbType.Decimal),
new OleDbParameter("@Money", OleDbType.Decimal),
new OleDbParameter("@Category", OleDbType.VarChar, 255),
new OleDbParameter("@LogDate", OleDbType.Date),
new OleDbParameter("@Memo", OleDbType.VarChar, 255)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Saler;
parameters[2].Value = model.Product;
parameters[3].Value = model.Type;
parameters[4].Value = model.Price;
parameters[5].Value = model.Unit;
parameters[6].Value = model.Num;
parameters[7].Value = model.Money;
parameters[8].Value = model.Category;
parameters[9].Value = model.LogDate;
parameters[10].Value = model.Memo;
DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
}
