/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(GoodsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Goods_Service set ");
strSql.Append("serviceName=@serviceName,");
strSql.Append("serviceContext=@serviceContext,");
strSql.Append("orderby=@orderby,");
strSql.Append("remark=@remark");
strSql.Append(" where serviceId=@serviceId");
SqlParameter[] parameters =
{
new SqlParameter("@serviceName", SqlDbType.VarChar, 50),
new SqlParameter("@serviceContext", SqlDbType.VarChar, 100),
new SqlParameter("@orderby", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.VarChar, 500),
new SqlParameter("@serviceId", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.serviceName;
parameters[1].Value = model.serviceContext;
parameters[2].Value = model.orderby;
parameters[3].Value = model.remark;
parameters[4].Value = model.serviceId;
int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public GoodsModel DataRowToModel(DataRow row)
{
GoodsModel model = new GoodsModel();
if (row != null)
{
if (row["serviceId"] != null && row["serviceId"].ToString() != "")
{
model.serviceId = row["serviceId"].ToString();
}
if (row["serviceName"] != null)
{
model.serviceName = row["serviceName"].ToString();
}
if (row["serviceContext"] != null)
{
model.serviceContext = row["serviceContext"].ToString();
}
if (row["orderby"] != null && row["orderby"].ToString() != "")
{
model.orderby = int.Parse(row["orderby"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(GoodsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Goods_Service(");
strSql.Append("serviceId,serviceName,serviceContext,orderby,remark)");
strSql.Append(" values (");
strSql.Append("@serviceId,@serviceName,@serviceContext,@orderby,@remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@serviceId", SqlDbType.VarChar, 50),
new SqlParameter("@serviceName", SqlDbType.VarChar, 50),
new SqlParameter("@serviceContext", SqlDbType.VarChar, 100),
new SqlParameter("@orderby", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.serviceId;
parameters[1].Value = model.serviceName;
parameters[2].Value = model.serviceContext;
parameters[3].Value = model.orderby;
parameters[4].Value = model.remark;
int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public GoodsModel GetModel(string serviceId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 serviceId,serviceName,serviceContext,orderby,remark from T_Goods_Service ");
strSql.Append(" where serviceId=@serviceId");
SqlParameter[] parameters =
{
new SqlParameter("@serviceId", SqlDbType.VarChar, 50)
};
parameters[0].Value = serviceId;
GoodsModel model = new GoodsModel();
DataSet ds = adoHelper.ExecuteSqlDataset(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(GoodsModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(GoodsModel model)
{
return(dal.Add(model));
}
