/// <summary> /// 增加一条数据 /// </summary> public bool Add(XHD.Model.ecs_total_plan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ecs_total_plan("); strSql.Append("plan_task,plan_divide,plan_jan,plan_feb,plan_mar,plan_apr,plan_may,plan_jun,plan_jul,plan_aug,plan_sep,plan_oct,plan_nov,plan_dec)"); strSql.Append(" values ("); strSql.Append("@plan_task,@plan_divide,@plan_jan,@plan_feb,@plan_mar,@plan_apr,@plan_may,@plan_jun,@plan_jul,@plan_aug,@plan_sep,@plan_oct,@plan_nov,@plan_dec)"); MySqlParameter[] parameters = { new MySqlParameter("@plan_task", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_divide", MySqlDbType.Int32, 2), new MySqlParameter("@plan_jan", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_feb", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_mar", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_apr", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_may", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_jun", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_jul", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_aug", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_sep", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_oct", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_nov", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_dec", MySqlDbType.VarChar, 100) }; parameters[0].Value = model.plan_task; parameters[1].Value = model.plan_divide; parameters[2].Value = model.plan_jan; parameters[3].Value = model.plan_feb; parameters[4].Value = model.plan_mar; parameters[5].Value = model.plan_apr; parameters[6].Value = model.plan_may; parameters[7].Value = model.plan_jun; parameters[8].Value = model.plan_jul; parameters[9].Value = model.plan_aug; parameters[10].Value = model.plan_sep; parameters[11].Value = model.plan_oct; parameters[12].Value = model.plan_nov; parameters[13].Value = model.plan_dec; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.ecs_total_plan GetModel(int plan_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select plan_id,plan_task,plan_divide,plan_jan,plan_feb,plan_mar,plan_apr,plan_may,plan_jun,plan_jul,plan_aug,plan_sep,plan_oct,plan_nov,plan_dec from ecs_total_plan "); strSql.Append(" where plan_id=@plan_id"); MySqlParameter[] parameters = { new MySqlParameter("@plan_id", MySqlDbType.Int32) }; parameters[0].Value = plan_id; XHD.Model.ecs_total_plan model = new XHD.Model.ecs_total_plan(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.ecs_total_plan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ecs_total_plan set "); strSql.Append("plan_task=@plan_task,"); strSql.Append("plan_divide=@plan_divide,"); strSql.Append("plan_jan=@plan_jan,"); strSql.Append("plan_feb=@plan_feb,"); strSql.Append("plan_mar=@plan_mar,"); strSql.Append("plan_apr=@plan_apr,"); strSql.Append("plan_may=@plan_may,"); strSql.Append("plan_jun=@plan_jun,"); strSql.Append("plan_jul=@plan_jul,"); strSql.Append("plan_aug=@plan_aug,"); strSql.Append("plan_sep=@plan_sep,"); strSql.Append("plan_oct=@plan_oct,"); strSql.Append("plan_nov=@plan_nov,"); strSql.Append("plan_dec=@plan_dec"); strSql.Append(" where plan_id=@plan_id"); MySqlParameter[] parameters = { new MySqlParameter("@plan_task", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_divide", MySqlDbType.Int32, 2), new MySqlParameter("@plan_jan", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_feb", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_mar", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_apr", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_may", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_jun", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_jul", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_aug", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_sep", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_oct", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_nov", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_dec", MySqlDbType.VarChar, 100), new MySqlParameter("@plan_id", MySqlDbType.Int32, 10) }; parameters[0].Value = model.plan_task; parameters[1].Value = model.plan_divide; parameters[2].Value = model.plan_jan; parameters[3].Value = model.plan_feb; parameters[4].Value = model.plan_mar; parameters[5].Value = model.plan_apr; parameters[6].Value = model.plan_may; parameters[7].Value = model.plan_jun; parameters[8].Value = model.plan_jul; parameters[9].Value = model.plan_aug; parameters[10].Value = model.plan_sep; parameters[11].Value = model.plan_oct; parameters[12].Value = model.plan_nov; parameters[13].Value = model.plan_dec; parameters[14].Value = model.plan_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.ecs_total_plan DataRowToModel(DataRow row) { XHD.Model.ecs_total_plan model = new XHD.Model.ecs_total_plan(); if (row != null) { if (row["plan_id"] != null && row["plan_id"].ToString() != "") { model.plan_id = int.Parse(row["plan_id"].ToString()); } if (row["plan_task"] != null) { model.plan_task = row["plan_task"].ToString(); } if (row["plan_divide"] != null && row["plan_divide"].ToString() != "") { model.plan_divide = int.Parse(row["plan_divide"].ToString()); } if (row["plan_jan"] != null) { model.plan_jan = row["plan_jan"].ToString(); } if (row["plan_feb"] != null) { model.plan_feb = row["plan_feb"].ToString(); } if (row["plan_mar"] != null) { model.plan_mar = row["plan_mar"].ToString(); } if (row["plan_apr"] != null) { model.plan_apr = row["plan_apr"].ToString(); } if (row["plan_may"] != null) { model.plan_may = row["plan_may"].ToString(); } if (row["plan_jun"] != null) { model.plan_jun = row["plan_jun"].ToString(); } if (row["plan_jul"] != null) { model.plan_jul = row["plan_jul"].ToString(); } if (row["plan_aug"] != null) { model.plan_aug = row["plan_aug"].ToString(); } if (row["plan_sep"] != null) { model.plan_sep = row["plan_sep"].ToString(); } if (row["plan_oct"] != null) { model.plan_oct = row["plan_oct"].ToString(); } if (row["plan_nov"] != null) { model.plan_nov = row["plan_nov"].ToString(); } if (row["plan_dec"] != null) { model.plan_dec = row["plan_dec"].ToString(); } } return(model); }