/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Devs model) { int rowsAffected; IDataParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@DevCode", SqlDbType.VarChar, 20), new SqlParameter("@StatId", SqlDbType.VarChar, 20), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@PreEndTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@DevStatus", SqlDbType.TinyInt, 1), new SqlParameter("@VideoURL", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Id; parameters[1].Value = model.DevCode; parameters[2].Value = model.StatId; parameters[3].Value = model.StartTime; parameters[4].Value = model.PreEndTime; parameters[5].Value = model.EndTime; parameters[6].Value = model.DevStatus; parameters[7].Value = model.VideoUrl; DbHelperSql.RunProcedure("T_Devs_Update", parameters, out rowsAffected); return(rowsAffected > 0); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Devs DataRowToModel(DataRow row) { var model = new Model.Devs(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["DevCode"] != null) { model.DevCode = row["DevCode"].ToString(); } if (row["StatId"] != null && row["StatId"].ToString() != "") { model.StatId = int.Parse(row["StatId"].ToString()); } if (row["StartTime"] != null && row["StartTime"].ToString() != "") { model.StartTime = DateTime.Parse(row["StartTime"].ToString()); } if (row["PreEndTime"] != null && row["PreEndTime"].ToString() != "") { model.PreEndTime = DateTime.Parse(row["PreEndTime"].ToString()); } if (row["EndTime"] != null && row["EndTime"].ToString() != "") { model.EndTime = DateTime.Parse(row["EndTime"].ToString()); } if (row["DevStatus"] != null && row["DevStatus"].ToString() != "") { model.DevStatus = int.Parse(row["DevStatus"].ToString()); } if (row["VideoURL"] != null) { model.VideoUrl = row["VideoURL"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Devs model) { return(_dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Devs model) { return(_dal.Add(model)); }