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