/// <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; } }