/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.ST_FORECAST_F GetModel(string STCD, DateTime YMDH, DateTime FYMDH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 STCD,YMDH,FYMDH,CODMn,NH3_N,TP,TN,flow,UNITNAME,PLCD from ST_FORECAST_F ");
strSql.Append(" where STCD=@STCD and YMDH=@YMDH and FYMDH=@FYMDH ");
SqlParameter[] parameters =
{
new SqlParameter("@STCD", SqlDbType.Char, 8),
new SqlParameter("@YMDH", SqlDbType.DateTime),
new SqlParameter("@FYMDH", SqlDbType.DateTime)
};
parameters[0].Value = STCD;
parameters[1].Value = YMDH;
parameters[2].Value = FYMDH;
Maticsoft.Model.ST_FORECAST_F model = new Maticsoft.Model.ST_FORECAST_F();
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 Maticsoft.Model.ST_FORECAST_F DataRowToModel(DataRow row)
{
Maticsoft.Model.ST_FORECAST_F model = new Maticsoft.Model.ST_FORECAST_F();
if (row != null)
{
if (row["STCD"] != null)
{
model.STCD = row["STCD"].ToString();
}
if (row["YMDH"] != null && row["YMDH"].ToString() != "")
{
model.YMDH = DateTime.Parse(row["YMDH"].ToString());
}
if (row["FYMDH"] != null && row["FYMDH"].ToString() != "")
{
model.FYMDH = DateTime.Parse(row["FYMDH"].ToString());
}
if (row["CODMn"] != null && row["CODMn"].ToString() != "")
{
model.CODMn = decimal.Parse(row["CODMn"].ToString());
}
if (row["NH3_N"] != null && row["NH3_N"].ToString() != "")
{
model.NH3_N = decimal.Parse(row["NH3_N"].ToString());
}
if (row["TP"] != null && row["TP"].ToString() != "")
{
model.TP = decimal.Parse(row["TP"].ToString());
}
if (row["TN"] != null && row["TN"].ToString() != "")
{
model.TN = decimal.Parse(row["TN"].ToString());
}
if (row["flow"] != null && row["flow"].ToString() != "")
{
model.flow = decimal.Parse(row["flow"].ToString());
}
if (row["UNITNAME"] != null)
{
model.UNITNAME = row["UNITNAME"].ToString();
}
if (row["PLCD"] != null)
{
model.PLCD = row["PLCD"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.ST_FORECAST_F model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ST_FORECAST_F set ");
strSql.Append("CODMn=@CODMn,");
strSql.Append("NH3_N=@NH3_N,");
strSql.Append("TP=@TP,");
strSql.Append("TN=@TN,");
strSql.Append("flow=@flow,");
strSql.Append("UNITNAME=@UNITNAME,");
strSql.Append("PLCD=@PLCD");
strSql.Append(" where STCD=@STCD and YMDH=@YMDH and FYMDH=@FYMDH ");
SqlParameter[] parameters =
{
new SqlParameter("@CODMn", SqlDbType.Decimal, 5),
new SqlParameter("@NH3_N", SqlDbType.Decimal, 5),
new SqlParameter("@TP", SqlDbType.Decimal, 5),
new SqlParameter("@TN", SqlDbType.Decimal, 5),
new SqlParameter("@flow", SqlDbType.Decimal, 9),
new SqlParameter("@UNITNAME", SqlDbType.Char, 30),
new SqlParameter("@PLCD", SqlDbType.Char, 20),
new SqlParameter("@STCD", SqlDbType.Char, 8),
new SqlParameter("@YMDH", SqlDbType.DateTime),
new SqlParameter("@FYMDH", SqlDbType.DateTime)
};
parameters[0].Value = model.CODMn;
parameters[1].Value = model.NH3_N;
parameters[2].Value = model.TP;
parameters[3].Value = model.TN;
parameters[4].Value = model.flow;
parameters[5].Value = model.UNITNAME;
parameters[6].Value = model.PLCD;
parameters[7].Value = model.STCD;
parameters[8].Value = model.YMDH;
parameters[9].Value = model.FYMDH;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.ST_FORECAST_F model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ST_FORECAST_F(");
strSql.Append("STCD,YMDH,FYMDH,CODMn,NH3_N,TP,TN,flow,UNITNAME,PLCD)");
strSql.Append(" values (");
strSql.Append("@STCD,@YMDH,@FYMDH,@CODMn,@NH3_N,@TP,@TN,@flow,@UNITNAME,@PLCD)");
SqlParameter[] parameters =
{
new SqlParameter("@STCD", SqlDbType.Char, 8),
new SqlParameter("@YMDH", SqlDbType.DateTime),
new SqlParameter("@FYMDH", SqlDbType.DateTime),
new SqlParameter("@CODMn", SqlDbType.Decimal, 5),
new SqlParameter("@NH3_N", SqlDbType.Decimal, 5),
new SqlParameter("@TP", SqlDbType.Decimal, 5),
new SqlParameter("@TN", SqlDbType.Decimal, 5),
new SqlParameter("@flow", SqlDbType.Decimal, 9),
new SqlParameter("@UNITNAME", SqlDbType.Char, 30),
new SqlParameter("@PLCD", SqlDbType.Char, 20)
};
parameters[0].Value = model.STCD;
parameters[1].Value = model.YMDH;
parameters[2].Value = model.FYMDH;
parameters[3].Value = model.CODMn;
parameters[4].Value = model.NH3_N;
parameters[5].Value = model.TP;
parameters[6].Value = model.TN;
parameters[7].Value = model.flow;
parameters[8].Value = model.UNITNAME;
parameters[9].Value = model.PLCD;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.ST_FORECAST_F DataRowToModel(DataRow row)
{
Maticsoft.Model.ST_FORECAST_F model=new Maticsoft.Model.ST_FORECAST_F();
if (row != null)
{
if(row["STCD"]!=null)
{
model.STCD=row["STCD"].ToString();
}
if(row["YMDH"]!=null && row["YMDH"].ToString()!="")
{
model.YMDH=DateTime.Parse(row["YMDH"].ToString());
}
if(row["FYMDH"]!=null && row["FYMDH"].ToString()!="")
{
model.FYMDH=DateTime.Parse(row["FYMDH"].ToString());
}
if(row["CODMn"]!=null && row["CODMn"].ToString()!="")
{
model.CODMn=decimal.Parse(row["CODMn"].ToString());
}
if(row["NH3_N"]!=null && row["NH3_N"].ToString()!="")
{
model.NH3_N=decimal.Parse(row["NH3_N"].ToString());
}
if(row["TP"]!=null && row["TP"].ToString()!="")
{
model.TP=decimal.Parse(row["TP"].ToString());
}
if(row["TN"]!=null && row["TN"].ToString()!="")
{
model.TN=decimal.Parse(row["TN"].ToString());
}
if(row["flow"]!=null && row["flow"].ToString()!="")
{
model.flow=decimal.Parse(row["flow"].ToString());
}
if(row["UNITNAME"]!=null)
{
model.UNITNAME=row["UNITNAME"].ToString();
}
if(row["PLCD"]!=null)
{
model.PLCD=row["PLCD"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.ST_FORECAST_F GetModel(string STCD,DateTime YMDH,DateTime FYMDH)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 STCD,YMDH,FYMDH,CODMn,NH3_N,TP,TN,flow,UNITNAME,PLCD from ST_FORECAST_F ");
strSql.Append(" where STCD=@STCD and YMDH=@YMDH and FYMDH=@FYMDH ");
SqlParameter[] parameters = {
new SqlParameter("@STCD", SqlDbType.Char,8),
new SqlParameter("@YMDH", SqlDbType.DateTime),
new SqlParameter("@FYMDH", SqlDbType.DateTime) };
parameters[0].Value = STCD;
parameters[1].Value = YMDH;
parameters[2].Value = FYMDH;
Maticsoft.Model.ST_FORECAST_F model=new Maticsoft.Model.ST_FORECAST_F();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
