/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(yny_003.Model.NewSHMoney model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update NewSHMoney set ");
strSql.Append("NName=@NName,");
strSql.Append("NJCFloat=@NJCFloat,");
strSql.Append("NTotalYJ=@NTotalYJ,");
strSql.Append("NSmallSumYJ=@NSmallSumYJ,");
strSql.Append("NDCount=@NDCount,");
strSql.Append("NMinYJ=@NMinYJ");
strSql.Append(" where NType=@NType ");
SqlParameter[] parameters =
{
new SqlParameter("@NName", SqlDbType.VarChar, 20),
new SqlParameter("@NJCFloat", SqlDbType.Decimal, 9),
new SqlParameter("@NTotalYJ", SqlDbType.Decimal, 9),
new SqlParameter("@NSmallSumYJ", SqlDbType.Decimal, 9),
new SqlParameter("@NDCount", SqlDbType.Int, 4),
new SqlParameter("@NMinYJ", SqlDbType.Decimal, 9),
new SqlParameter("@NType", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.NName;
parameters[1].Value = model.NJCFloat;
parameters[2].Value = model.NTotalYJ;
parameters[3].Value = model.NSmallSumYJ;
parameters[4].Value = model.NDCount;
parameters[5].Value = model.NMinYJ;
parameters[6].Value = model.NType;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(yny_003.Model.NewSHMoney model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into NewSHMoney(");
strSql.Append("NType,NName,NJCFloat,NTotalYJ,NSmallSumYJ,NDCount,NMinYJ)");
strSql.Append(" values (");
strSql.Append("@NType,@NName,@NJCFloat,@NTotalYJ,@NSmallSumYJ,@NDCount,@NMinYJ)");
SqlParameter[] parameters =
{
new SqlParameter("@NType", SqlDbType.VarChar, 10),
new SqlParameter("@NName", SqlDbType.VarChar, 20),
new SqlParameter("@NJCFloat", SqlDbType.Decimal, 9),
new SqlParameter("@NTotalYJ", SqlDbType.Decimal, 9),
new SqlParameter("@NSmallSumYJ", SqlDbType.Decimal, 9),
new SqlParameter("@NDCount", SqlDbType.Int, 4),
new SqlParameter("@NMinYJ", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.NType;
parameters[1].Value = model.NName;
parameters[2].Value = model.NJCFloat;
parameters[3].Value = model.NTotalYJ;
parameters[4].Value = model.NSmallSumYJ;
parameters[5].Value = model.NDCount;
parameters[6].Value = model.NMinYJ;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static yny_003.Model.NewSHMoney DataRowToModel(DataRow row)
{
yny_003.Model.NewSHMoney model = new yny_003.Model.NewSHMoney();
if (row != null)
{
if (row["NType"] != null)
{
model.NType = row["NType"].ToString();
}
if (row["NName"] != null)
{
model.NName = row["NName"].ToString();
}
if (row["NJCFloat"] != null && row["NJCFloat"].ToString() != "")
{
model.NJCFloat = decimal.Parse(row["NJCFloat"].ToString());
}
if (row["NTotalYJ"] != null && row["NTotalYJ"].ToString() != "")
{
model.NTotalYJ = decimal.Parse(row["NTotalYJ"].ToString());
}
if (row["NSmallSumYJ"] != null && row["NSmallSumYJ"].ToString() != "")
{
model.NSmallSumYJ = decimal.Parse(row["NSmallSumYJ"].ToString());
}
if (row["NDCount"] != null && row["NDCount"].ToString() != "")
{
model.NDCount = int.Parse(row["NDCount"].ToString());
}
if (row["NMinYJ"] != null && row["NMinYJ"].ToString() != "")
{
model.NMinYJ = decimal.Parse(row["NMinYJ"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static yny_003.Model.NewSHMoney GetModel(string NType)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 NType,NName,NJCFloat,NTotalYJ,NSmallSumYJ,NDCount,NMinYJ from NewSHMoney ");
strSql.Append(" where NType=@NType ");
SqlParameter[] parameters =
{
new SqlParameter("@NType", SqlDbType.VarChar, 10)
};
parameters[0].Value = NType;
yny_003.Model.NewSHMoney model = new yny_003.Model.NewSHMoney();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
