/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.NewPort.Table_plan DataRowToModel(DataRow row) { Maticsoft.Model.NewPort.Table_plan model = new Maticsoft.Model.NewPort.Table_plan(); if (row != null) { if (row["plan_id"] != null) { model.plan_id = row["plan_id"].ToString(); } if (row["plan_name"] != null) { model.plan_name = row["plan_name"].ToString(); } if (row["plan_description"] != null) { model.plan_description = row["plan_description"].ToString(); } if (row["plan_startTime"] != null && row["plan_startTime"].ToString() != "") { model.plan_startTime = DateTime.Parse(row["plan_startTime"].ToString()); } if (row["plan_endTime"] != null && row["plan_endTime"].ToString() != "") { model.plan_endTime = DateTime.Parse(row["plan_endTime"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.NewPort.Table_plan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Table_plan set "); strSql.Append("plan_name=@plan_name,"); strSql.Append("plan_description=@plan_description,"); strSql.Append("plan_startTime=@plan_startTime,"); strSql.Append("plan_endTime=@plan_endTime"); strSql.Append(" where plan_id=@plan_id "); SqlParameter[] parameters = { new SqlParameter("@plan_name", SqlDbType.NVarChar, 20), new SqlParameter("@plan_description", SqlDbType.NVarChar, 200), new SqlParameter("@plan_startTime", SqlDbType.DateTime), new SqlParameter("@plan_endTime", SqlDbType.DateTime), new SqlParameter("@plan_id", SqlDbType.Char, 6) }; parameters[0].Value = model.plan_name; parameters[1].Value = model.plan_description; parameters[2].Value = model.plan_startTime; parameters[3].Value = model.plan_endTime; parameters[4].Value = model.plan_id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.NewPort.Table_plan GetModel(string plan_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 plan_id,plan_name,plan_description,plan_startTime,plan_endTime from Table_plan "); strSql.Append(" where plan_id=@plan_id "); SqlParameter[] parameters = { new SqlParameter("@plan_id", SqlDbType.Char, 6) }; parameters[0].Value = plan_id; Maticsoft.Model.NewPort.Table_plan model = new Maticsoft.Model.NewPort.Table_plan(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }