/// <summary>
/// 增加一条数据
/// </summary>
public void Add(RestaurantMIS.Model.PayOrder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PayOrder(");
strSql.Append("ID,RoomID,Category,FoodSum,WineSum,CigaretteSum,OtherSum,TotalSum,RealSum,LogDate)");
strSql.Append(" values (");
strSql.Append("@ID,@RoomID,@Category,@FoodSum,@WineSum,@CigaretteSum,@OtherSum,@TotalSum,@RealSum,@LogDate)");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4),
new OleDbParameter("@RoomID", OleDbType.Integer, 4),
new OleDbParameter("@Category", OleDbType.VarChar, 255),
new OleDbParameter("@FoodSum", OleDbType.Decimal),
new OleDbParameter("@WineSum", OleDbType.Decimal),
new OleDbParameter("@CigaretteSum", OleDbType.Decimal),
new OleDbParameter("@OtherSum", OleDbType.Decimal),
new OleDbParameter("@TotalSum", OleDbType.Decimal),
new OleDbParameter("@RealSum", OleDbType.Decimal),
new OleDbParameter("@LogDate", OleDbType.Date)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.RoomID;
parameters[2].Value = model.Category;
parameters[3].Value = model.FoodSum;
parameters[4].Value = model.WineSum;
parameters[5].Value = model.CigaretteSum;
parameters[6].Value = model.OtherSum;
parameters[7].Value = model.TotalSum;
parameters[8].Value = model.RealSum;
parameters[9].Value = model.LogDate;
DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(RestaurantMIS.Model.PayOrder model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PayOrder set ");
strSql.Append("ID=@ID,");
strSql.Append("RoomID=@RoomID,");
strSql.Append("Category=@Category,");
strSql.Append("FoodSum=@FoodSum,");
strSql.Append("WineSum=@WineSum,");
strSql.Append("CigaretteSum=@CigaretteSum,");
strSql.Append("OtherSum=@OtherSum,");
strSql.Append("TotalSum=@TotalSum,");
strSql.Append("RealSum=@RealSum,");
strSql.Append("LogDate=@LogDate");
strSql.Append(" where ID=@ID ");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4),
new OleDbParameter("@RoomID", OleDbType.Integer, 4),
new OleDbParameter("@Category", OleDbType.VarChar, 255),
new OleDbParameter("@FoodSum", OleDbType.Decimal),
new OleDbParameter("@WineSum", OleDbType.Decimal),
new OleDbParameter("@CigaretteSum", OleDbType.Decimal),
new OleDbParameter("@OtherSum", OleDbType.Decimal),
new OleDbParameter("@TotalSum", OleDbType.Decimal),
new OleDbParameter("@RealSum", OleDbType.Decimal),
new OleDbParameter("@LogDate", OleDbType.Date)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.RoomID;
parameters[2].Value = model.Category;
parameters[3].Value = model.FoodSum;
parameters[4].Value = model.WineSum;
parameters[5].Value = model.CigaretteSum;
parameters[6].Value = model.OtherSum;
parameters[7].Value = model.TotalSum;
parameters[8].Value = model.RealSum;
parameters[9].Value = model.LogDate;
DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public RestaurantMIS.Model.PayOrder GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,RoomID,Category,FoodSum,WineSum,CigaretteSum,OtherSum,TotalSum,RealSum,LogDate from PayOrder ");
strSql.Append(" where ID=@ID ");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
RestaurantMIS.Model.PayOrder model = new RestaurantMIS.Model.PayOrder();
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());
}
if (ds.Tables[0].Rows[0]["RoomID"].ToString() != "")
{
model.RoomID = int.Parse(ds.Tables[0].Rows[0]["RoomID"].ToString());
}
model.Category = ds.Tables[0].Rows[0]["Category"].ToString();
if (ds.Tables[0].Rows[0]["FoodSum"].ToString() != "")
{
model.FoodSum = decimal.Parse(ds.Tables[0].Rows[0]["FoodSum"].ToString());
}
if (ds.Tables[0].Rows[0]["WineSum"].ToString() != "")
{
model.WineSum = decimal.Parse(ds.Tables[0].Rows[0]["WineSum"].ToString());
}
if (ds.Tables[0].Rows[0]["CigaretteSum"].ToString() != "")
{
model.CigaretteSum = decimal.Parse(ds.Tables[0].Rows[0]["CigaretteSum"].ToString());
}
if (ds.Tables[0].Rows[0]["OtherSum"].ToString() != "")
{
model.OtherSum = decimal.Parse(ds.Tables[0].Rows[0]["OtherSum"].ToString());
}
if (ds.Tables[0].Rows[0]["TotalSum"].ToString() != "")
{
model.TotalSum = decimal.Parse(ds.Tables[0].Rows[0]["TotalSum"].ToString());
}
if (ds.Tables[0].Rows[0]["RealSum"].ToString() != "")
{
model.RealSum = decimal.Parse(ds.Tables[0].Rows[0]["RealSum"].ToString());
}
if (ds.Tables[0].Rows[0]["LogDate"].ToString() != "")
{
model.LogDate = DateTime.Parse(ds.Tables[0].Rows[0]["LogDate"].ToString());
}
return(model);
}
else
{
return(null);
}
}
