/// <summary> /// 得到一个对象实体 /// </summary> public Model.TaskNotice DataRowToModel(DataRow row) { var model = new Model.TaskNotice(); if (row != null) { if (row["TaskId"] != null && row["TaskId"].ToString() != "") { model.TaskId = long.Parse(row["TaskId"].ToString()); } if (row["DevId"] != null && row["DevId"].ToString() != "") { model.DevId = int.Parse(row["DevId"].ToString()); } if (row["Data"] != null && row["Data"].ToString() != "") { model.Data = (byte[])row["Data"]; } if (row["Length"] != null && row["Length"].ToString() != "") { model.Length = int.Parse(row["Length"].ToString()); } if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.TaskNotice model) { int rowsAffected; IDataParameter[] parameters = { new SqlParameter("@TaskId", SqlDbType.BigInt, 8), new SqlParameter("@DevId", SqlDbType.Int, 4), new SqlParameter("@Data", SqlDbType.Binary, 1000), new SqlParameter("@Length", SqlDbType.Int, 4), new SqlParameter("@UpdateTime", SqlDbType.SmallDateTime) }; parameters[0].Value = model.TaskId; parameters[1].Value = model.DevId; parameters[2].Value = model.Data; parameters[3].Value = model.Length; parameters[4].Value = model.UpdateTime; DbHelperSql.RunProcedure("T_TaskNotice_Update", parameters, out rowsAffected); return(rowsAffected > 0); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.TaskNotice model) { return(_dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.TaskNotice model) { return(_dal.Add(model)); }