/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.HIS_MEASURAND_Performance_Evaluation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HIS_MEASURAND_Performance_Evaluation(");
strSql.Append("Indicators,Unit,Y2005,Y2006,Y2007,Y2008,Y2009,Y2010,Y2011,Y2012,Y2013,Y2014,Y2015,Y2016)");
strSql.Append(" values (");
strSql.Append("@Indicators,@Unit,@Y2005,@Y2006,@Y2007,@Y2008,@Y2009,@Y2010,@Y2011,@Y2012,@Y2013,@Y2014,@Y2015,@Y2016)");
SqlParameter[] parameters =
{
new SqlParameter("@Indicators", SqlDbType.NVarChar, 255),
new SqlParameter("@Unit", SqlDbType.NVarChar, 255),
new SqlParameter("@Y2005", SqlDbType.Decimal, 9),
new SqlParameter("@Y2006", SqlDbType.Decimal, 9),
new SqlParameter("@Y2007", SqlDbType.Decimal, 9),
new SqlParameter("@Y2008", SqlDbType.Decimal, 9),
new SqlParameter("@Y2009", SqlDbType.Decimal, 9),
new SqlParameter("@Y2010", SqlDbType.Decimal, 9),
new SqlParameter("@Y2011", SqlDbType.Decimal, 9),
new SqlParameter("@Y2012", SqlDbType.Decimal, 9),
new SqlParameter("@Y2013", SqlDbType.Decimal, 9),
new SqlParameter("@Y2014", SqlDbType.Decimal, 9),
new SqlParameter("@Y2015", SqlDbType.Decimal, 9),
new SqlParameter("@Y2016", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.Indicators;
parameters[1].Value = model.Unit;
parameters[2].Value = model.Y2005;
parameters[3].Value = model.Y2006;
parameters[4].Value = model.Y2007;
parameters[5].Value = model.Y2008;
parameters[6].Value = model.Y2009;
parameters[7].Value = model.Y2010;
parameters[8].Value = model.Y2011;
parameters[9].Value = model.Y2012;
parameters[10].Value = model.Y2013;
parameters[11].Value = model.Y2014;
parameters[12].Value = model.Y2015;
parameters[13].Value = model.Y2016;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.HIS_MEASURAND_Performance_Evaluation GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Indicators,Unit,Y2005,Y2006,Y2007,Y2008,Y2009,Y2010,Y2011,Y2012,Y2013,Y2014,Y2015,Y2016 from HIS_MEASURAND_Performance_Evaluation ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Maticsoft.Model.HIS_MEASURAND_Performance_Evaluation model = new Maticsoft.Model.HIS_MEASURAND_Performance_Evaluation();
DataSet ds = DbHelperSQL.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(Maticsoft.Model.HIS_MEASURAND_Performance_Evaluation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HIS_MEASURAND_Performance_Evaluation set ");
strSql.Append("Indicators=@Indicators,");
strSql.Append("Unit=@Unit,");
strSql.Append("Y2005=@Y2005,");
strSql.Append("Y2006=@Y2006,");
strSql.Append("Y2007=@Y2007,");
strSql.Append("Y2008=@Y2008,");
strSql.Append("Y2009=@Y2009,");
strSql.Append("Y2010=@Y2010,");
strSql.Append("Y2011=@Y2011,");
strSql.Append("Y2012=@Y2012,");
strSql.Append("Y2013=@Y2013,");
strSql.Append("Y2014=@Y2014,");
strSql.Append("Y2015=@Y2015,");
strSql.Append("Y2016=@Y2016");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@Indicators", SqlDbType.NVarChar, 255),
new SqlParameter("@Unit", SqlDbType.NVarChar, 255),
new SqlParameter("@Y2005", SqlDbType.Decimal, 9),
new SqlParameter("@Y2006", SqlDbType.Decimal, 9),
new SqlParameter("@Y2007", SqlDbType.Decimal, 9),
new SqlParameter("@Y2008", SqlDbType.Decimal, 9),
new SqlParameter("@Y2009", SqlDbType.Decimal, 9),
new SqlParameter("@Y2010", SqlDbType.Decimal, 9),
new SqlParameter("@Y2011", SqlDbType.Decimal, 9),
new SqlParameter("@Y2012", SqlDbType.Decimal, 9),
new SqlParameter("@Y2013", SqlDbType.Decimal, 9),
new SqlParameter("@Y2014", SqlDbType.Decimal, 9),
new SqlParameter("@Y2015", SqlDbType.Decimal, 9),
new SqlParameter("@Y2016", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.Indicators;
parameters[1].Value = model.Unit;
parameters[2].Value = model.Y2005;
parameters[3].Value = model.Y2006;
parameters[4].Value = model.Y2007;
parameters[5].Value = model.Y2008;
parameters[6].Value = model.Y2009;
parameters[7].Value = model.Y2010;
parameters[8].Value = model.Y2011;
parameters[9].Value = model.Y2012;
parameters[10].Value = model.Y2013;
parameters[11].Value = model.Y2014;
parameters[12].Value = model.Y2015;
parameters[13].Value = model.Y2016;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.HIS_MEASURAND_Performance_Evaluation DataRowToModel(DataRow row)
{
Maticsoft.Model.HIS_MEASURAND_Performance_Evaluation model = new Maticsoft.Model.HIS_MEASURAND_Performance_Evaluation();
if (row != null)
{
if (row["Indicators"] != null)
{
model.Indicators = row["Indicators"].ToString();
}
if (row["Unit"] != null)
{
model.Unit = row["Unit"].ToString();
}
if (row["Y2005"] != null && row["Y2005"].ToString() != "")
{
model.Y2005 = decimal.Parse(row["Y2005"].ToString());
}
if (row["Y2006"] != null && row["Y2006"].ToString() != "")
{
model.Y2006 = decimal.Parse(row["Y2006"].ToString());
}
if (row["Y2007"] != null && row["Y2007"].ToString() != "")
{
model.Y2007 = decimal.Parse(row["Y2007"].ToString());
}
if (row["Y2008"] != null && row["Y2008"].ToString() != "")
{
model.Y2008 = decimal.Parse(row["Y2008"].ToString());
}
if (row["Y2009"] != null && row["Y2009"].ToString() != "")
{
model.Y2009 = decimal.Parse(row["Y2009"].ToString());
}
if (row["Y2010"] != null && row["Y2010"].ToString() != "")
{
model.Y2010 = decimal.Parse(row["Y2010"].ToString());
}
if (row["Y2011"] != null && row["Y2011"].ToString() != "")
{
model.Y2011 = decimal.Parse(row["Y2011"].ToString());
}
if (row["Y2012"] != null && row["Y2012"].ToString() != "")
{
model.Y2012 = decimal.Parse(row["Y2012"].ToString());
}
if (row["Y2013"] != null && row["Y2013"].ToString() != "")
{
model.Y2013 = decimal.Parse(row["Y2013"].ToString());
}
if (row["Y2014"] != null && row["Y2014"].ToString() != "")
{
model.Y2014 = decimal.Parse(row["Y2014"].ToString());
}
if (row["Y2015"] != null && row["Y2015"].ToString() != "")
{
model.Y2015 = decimal.Parse(row["Y2015"].ToString());
}
if (row["Y2016"] != null && row["Y2016"].ToString() != "")
{
model.Y2016 = decimal.Parse(row["Y2016"].ToString());
}
}
return(model);
}
