/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(SOSOshop.Model.Service.Orders.yw_xsdjhzb model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into yw_xsdjhzb(");
strSql.Append("djid,jgid,jjid,rq,djbh,djbs,dwid,ywyid,lxrid,jsfsid,hsje,name,url,is_kp)");
strSql.Append(" values (");
strSql.Append("@djid,@jgid,@jjid,@rq,@djbh,@djbs,@dwid,@ywyid,@lxrid,@jsfsid,@hsje,@name,@url,@is_kp)");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "djid", DbType.String, model.djid);
db.AddInParameter(dbCommand, "jgid", DbType.String, model.jgid);
db.AddInParameter(dbCommand, "jjid", DbType.String, model.jjid);
db.AddInParameter(dbCommand, "rq", DbType.String, model.rq);
db.AddInParameter(dbCommand, "djbh", DbType.String, model.djbh);
db.AddInParameter(dbCommand, "djbs", DbType.String, model.djbs);
db.AddInParameter(dbCommand, "dwid", DbType.String, model.dwid);
db.AddInParameter(dbCommand, "ywyid", DbType.String, model.ywyid);
db.AddInParameter(dbCommand, "lxrid", DbType.String, model.lxrid);
db.AddInParameter(dbCommand, "jsfsid", DbType.String, model.jsfsid);
db.AddInParameter(dbCommand, "hsje", DbType.String, model.hsje);
db.AddInParameter(dbCommand, "name", DbType.String, model.name);
db.AddInParameter(dbCommand, "url", DbType.String, model.url);
db.AddInParameter(dbCommand, "is_kp", DbType.String, model.is_kp);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(false);
}
return(true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SOSOshop.Model.Service.Orders.yw_xsdjhzb model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update yw_xsdjhzb set ");
strSql.Append("djid=@djid,");
strSql.Append("jgid=@jgid,");
strSql.Append("jjid=@jjid,");
strSql.Append("rq=@rq,");
strSql.Append("djbh=@djbh,");
strSql.Append("djbs=@djbs,");
strSql.Append("dwid=@dwid,");
strSql.Append("ywyid=@ywyid,");
strSql.Append("lxrid=@lxrid,");
strSql.Append("jsfsid=@jsfsid,");
strSql.Append("hsje=@hsje,");
strSql.Append("name=@name,");
strSql.Append("url=@url,");
strSql.Append("is_kp=@is_kp");
strSql.Append(" where djid=@djid ");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "djid", DbType.String, model.djid);
db.AddInParameter(dbCommand, "jgid", DbType.String, model.jgid);
db.AddInParameter(dbCommand, "jjid", DbType.String, model.jjid);
db.AddInParameter(dbCommand, "rq", DbType.String, model.rq);
db.AddInParameter(dbCommand, "djbh", DbType.String, model.djbh);
db.AddInParameter(dbCommand, "djbs", DbType.String, model.djbs);
db.AddInParameter(dbCommand, "dwid", DbType.String, model.dwid);
db.AddInParameter(dbCommand, "ywyid", DbType.String, model.ywyid);
db.AddInParameter(dbCommand, "lxrid", DbType.String, model.lxrid);
db.AddInParameter(dbCommand, "jsfsid", DbType.String, model.jsfsid);
db.AddInParameter(dbCommand, "hsje", DbType.String, model.hsje);
db.AddInParameter(dbCommand, "name", DbType.String, model.name);
db.AddInParameter(dbCommand, "url", DbType.String, model.url);
db.AddInParameter(dbCommand, "is_kp", DbType.String, model.is_kp);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public SOSOshop.Model.Service.Orders.yw_xsdjhzb ReaderBind(IDataReader dataReader)
{
SOSOshop.Model.Service.Orders.yw_xsdjhzb model = new SOSOshop.Model.Service.Orders.yw_xsdjhzb();
object ojb;
ojb = dataReader["djid"];
if (ojb != null && ojb != DBNull.Value)
{
model.djid = (decimal)ojb;
}
ojb = dataReader["jgid"];
if (ojb != null && ojb != DBNull.Value)
{
model.jgid = (decimal)ojb;
}
ojb = dataReader["jjid"];
if (ojb != null && ojb != DBNull.Value)
{
model.jjid = (decimal)ojb;
}
ojb = dataReader["rq"];
if (ojb != null && ojb != DBNull.Value)
{
model.rq = (DateTime)ojb;
}
model.djbh = dataReader["djbh"].ToString();
model.djbs = dataReader["djbs"].ToString();
ojb = dataReader["dwid"];
if (ojb != null && ojb != DBNull.Value)
{
model.dwid = (decimal)ojb;
}
ojb = dataReader["ywyid"];
if (ojb != null && ojb != DBNull.Value)
{
model.ywyid = (decimal)ojb;
}
ojb = dataReader["lxrid"];
if (ojb != null && ojb != DBNull.Value)
{
model.lxrid = (decimal)ojb;
}
ojb = dataReader["jsfsid"];
if (ojb != null && ojb != DBNull.Value)
{
model.jsfsid = (decimal)ojb;
}
ojb = dataReader["hsje"];
if (ojb != null && ojb != DBNull.Value)
{
model.hsje = (decimal)ojb;
}
model.name = dataReader["name"].ToString();
model.url = dataReader["url"].ToString();
ojb = dataReader["is_kp"];
if (ojb != null && ojb != DBNull.Value)
{
model.is_kp = (decimal)ojb;
}
return(model);
}
