/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(XHD.Model.dms_set_rating model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dms_set_rating(");
strSql.Append("plan_year,plan_task,plan_jan,plan_feb,plan_mar,plan_apr,plan_may,plan_jun,plan_jul,plan_aug,plan_sep,plan_oct,plan_nov,plan_dec,kf_rname,kf_uname)");
strSql.Append(" values (");
strSql.Append("@plan_year,@plan_task,@plan_jan,@plan_feb,@plan_mar,@plan_apr,@plan_may,@plan_jun,@plan_jul,@plan_aug,@plan_sep,@plan_oct,@plan_nov,@plan_dec,@kf_rname,@kf_uname)");
MySqlParameter[] parameters =
{
new MySqlParameter("@plan_year", MySqlDbType.VarChar, 4),
new MySqlParameter("@plan_task", MySqlDbType.VarChar, 100),
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("@kf_rname", MySqlDbType.VarChar, 100),
new MySqlParameter("@kf_uname", MySqlDbType.VarChar, 100)
};
parameters[0].Value = model.plan_year;
parameters[1].Value = model.plan_task;
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.kf_rname;
parameters[15].Value = model.kf_uname;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.dms_set_rating GetModel(int plan_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select plan_id,plan_year,plan_task,plan_jan,plan_feb,plan_mar,plan_apr,plan_may,plan_jun,plan_jul,plan_aug,plan_sep,plan_oct,plan_nov,plan_dec,kf_rname,kf_uname from dms_set_rating ");
strSql.Append(" where plan_id=@plan_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@plan_id", MySqlDbType.Int32)
};
parameters[0].Value = plan_id;
XHD.Model.dms_set_rating model = new XHD.Model.dms_set_rating();
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.dms_set_rating model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dms_set_rating set ");
strSql.Append("plan_year=@plan_year,");
strSql.Append("plan_task=@plan_task,");
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("kf_rname=@kf_rname,");
strSql.Append("kf_uname=@kf_uname");
strSql.Append(" where plan_id=@plan_id");
MySqlParameter[] parameters =
{
new MySqlParameter("@plan_year", MySqlDbType.VarChar, 4),
new MySqlParameter("@plan_task", MySqlDbType.VarChar, 100),
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("@kf_rname", MySqlDbType.VarChar, 100),
new MySqlParameter("@kf_uname", MySqlDbType.VarChar, 100),
new MySqlParameter("@plan_id", MySqlDbType.Int32, 10)
};
parameters[0].Value = model.plan_year;
parameters[1].Value = model.plan_task;
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.kf_rname;
parameters[15].Value = model.kf_uname;
parameters[16].Value = model.plan_id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.dms_set_rating DataRowToModel(DataRow row)
{
XHD.Model.dms_set_rating model = new XHD.Model.dms_set_rating();
if (row != null)
{
if (row["plan_id"] != null && row["plan_id"].ToString() != "")
{
model.plan_id = int.Parse(row["plan_id"].ToString());
}
if (row["plan_year"] != null)
{
model.plan_year = row["plan_year"].ToString();
}
if (row["plan_task"] != null)
{
model.plan_task = row["plan_task"].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();
}
if (row["kf_rname"] != null)
{
model.kf_rname = row["kf_rname"].ToString();
}
if (row["kf_uname"] != null)
{
model.kf_uname = row["kf_uname"].ToString();
}
}
return(model);
}
