/// <summary>
/// 添加订单
/// </summary>
public void Insert(WorkerStaffOrderMealDetailInfo csInfo)
{
var parameters = GetSqlParameter(csInfo);
using (var dr = SQLHelper.ExecuteReader(SQLHelper.ConnString, CommandType.Text, CONST_SQL_INSERT, parameters))
{
dr.Read();
csInfo.Id = Convert.ToInt32(dr[0]);
dr.Close();
}
}
/// <summary>
/// 获取订单
/// </summary>
public WorkerStaffOrderMealDetailInfo Select(int csId)
{
WorkerStaffOrderMealDetailInfo ret = null;
using (var dr = SQLHelper.ExecuteReader(SQLHelper.ConnString, CommandType.Text, CONST_SQL_SELECT, new SqlParameter("@WorkerStaffOrderMealId", csId)))
{
if (dr.Read())
{
ret = this.BuildModel(dr);
}
dr.Close();
}
return(ret);
}
public override WorkerStaffOrderMealDetailInfo BuildModel(IDataReader dr)
{
var ret = new WorkerStaffOrderMealDetailInfo
{
Id = int.Parse(dr["Id"].ToString()),
WorkerStaffOrderMealId = int.Parse(dr["WorkerStaffOrderMealId"].ToString()),
CookbookId = int.Parse(dr["CookbookId"].ToString()),
CookbookName = dr["CookbookName"].ToString(),
CreatedByName = dr["CreatedByName"].ToString(),
CreatedByID = int.Parse(dr["CreatedByID"].ToString()),
CreatedDate = DateTime.Parse(dr["CreatedDate"].ToString()),
LastUpdByID = int.Parse(dr["LastUpdByID"].ToString()),
LastUpdByName = dr["LastUpdByName"].ToString(),
LastUpdDate = DateTime.Parse(dr["LastUpdDate"].ToString())
};
return(ret);
}
private SqlParameter[] GetSqlParameter(WorkerStaffOrderMealDetailInfo csInfo)
{
return(new[] {
new SqlParameter("@Id", csInfo.Id),
new SqlParameter("@WorkerStaffOrderMealId", csInfo.WorkerStaffOrderMealId),
new SqlParameter("@CookbookId", csInfo.CookbookId),
new SqlParameter("@CookbookName", csInfo.CookbookName),
new SqlParameter("@CreatedByName", csInfo.CreatedByName),
new SqlParameter("@CreatedByID", csInfo.CreatedByID),
new SqlParameter("@CreatedDate", csInfo.CreatedDate),
new SqlParameter("@LastUpdByID", csInfo.LastUpdByID),
new SqlParameter("@LastUpdByName", csInfo.LastUpdByName),
new SqlParameter("@LastUpdDate", csInfo.LastUpdDate)
});
}
/// <summary>
/// 修改订单
/// </summary>
public void Update(WorkerStaffOrderMealDetailInfo csInfo)
{
var parameters = this.GetSqlParameter(csInfo);
SQLHelper.ExecuteNonQuery(SQLHelper.ConnString, CommandType.Text, CONST_SQL_UPDATE, parameters);
}
/// <summary>
/// 修改订单
/// </summary>
public void ModifyOrderMealDetail(WorkerStaffOrderMealDetailInfo csInfo)
{
WorkerOrdermealDetailDAL.Update(csInfo);
}
/// <summary>
/// 添加订单
/// </summary>
public void AddOrderMealDetail(WorkerStaffOrderMealDetailInfo csInfo)
{
WorkerOrdermealDetailDAL.Insert(csInfo);
}
