/// <summary>
/// 更新一条数据
/// </summary>
public void Update(UserPermission.Model.USER_SHARE_COMPANYRELATEMODEL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update USER_SHARE_COMPANYRELATE set ");
strSql.Append("COMPANYTYPE=@COMPANYTYPE,");
strSql.Append("COMPANYNAME=@COMPANYNAME,");
strSql.Append("COMPANYID=@COMPANYID,");
strSql.Append("GROUPID=@GROUPID,");
strSql.Append("PRODUCTIDS=@PRODUCTIDS,");
strSql.Append("COMPANYCODE=@COMPANYCODE,");
strSql.Append("SHARECOMPANYID=@SHARECOMPANYID,");
strSql.Append("STATUS=@STATUS");
strSql.Append(" where CID=@CID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CID", DbType.String, model.CID);
db.AddInParameter(dbCommand, "COMPANYTYPE", DbType.String, model.COMPANYTYPE);
db.AddInParameter(dbCommand, "COMPANYNAME", DbType.String, model.COMPANYNAME);
db.AddInParameter(dbCommand, "COMPANYID", DbType.String, model.COMPANYID);
db.AddInParameter(dbCommand, "GROUPID", DbType.String, model.GROUPID);
db.AddInParameter(dbCommand, "PRODUCTIDS", DbType.String, model.PRODUCTIDS);
db.AddInParameter(dbCommand, "COMPANYCODE", DbType.String, model.COMPANYCODE);
db.AddInParameter(dbCommand, "SHARECOMPANYID", DbType.String, model.SHARECOMPANYID);
db.AddInParameter(dbCommand, "STATUS", DbType.String, model.STATUS);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public UserPermission.Model.USER_SHARE_COMPANYRELATEMODEL ReaderBind(IDataReader dataReader)
{
UserPermission.Model.USER_SHARE_COMPANYRELATEMODEL model = new UserPermission.Model.USER_SHARE_COMPANYRELATEMODEL();
object ojb;
ojb = dataReader["CID"];
if (ojb != null && ojb != DBNull.Value)
{
model.CID = (int)ojb;
}
ojb = dataReader["COMPANYTYPE"];
if (ojb != null && ojb != DBNull.Value)
{
model.COMPANYTYPE = (int)ojb;
}
model.COMPANYNAME = dataReader["COMPANYNAME"].ToString();
ojb = dataReader["COMPANYID"];
if (ojb != null && ojb != DBNull.Value)
{
model.COMPANYID = (int)ojb;
}
ojb = dataReader["GROUPID"];
if (ojb != null && ojb != DBNull.Value)
{
model.GROUPID = (int)ojb;
}
model.PRODUCTIDS = dataReader["PRODUCTIDS"].ToString();
ojb = dataReader["COMPANYCODE"];
if (ojb != null && ojb != DBNull.Value)
{
model.COMPANYCODE = (int)ojb;
}
ojb = dataReader["SHARECOMPANYID"];
if (ojb != null && ojb != DBNull.Value)
{
model.SHARECOMPANYID = (int)ojb;
}
ojb = dataReader["STATUS"];
if (ojb != null && ojb != DBNull.Value)
{
model.STATUS = (int)ojb;
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public UserPermission.Model.USER_SHARE_COMPANYRELATEMODEL GetModel(decimal CID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CID,COMPANYTYPE,COMPANYNAME,COMPANYID,GROUPID,PRODUCTIDS,COMPANYCODE,SHARECOMPANYID,STATUS from USER_SHARE_COMPANYRELATE ");
strSql.Append(" where (COMPANYID=:COMPANYID) ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CID", DbType.String, CID);
UserPermission.Model.USER_SHARE_COMPANYRELATEMODEL model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(UserPermission.Model.USER_SHARE_COMPANYRELATEMODEL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into USER_SHARE_COMPANYRELATE(");
strSql.Append("CID,COMPANYTYPE,COMPANYNAME,COMPANYID,GROUPID,PRODUCTIDS,COMPANYCODE,SHARECOMPANYID,STATUS)");
strSql.Append(" values (");
strSql.Append("@CID,@COMPANYTYPE,@COMPANYNAME,@COMPANYID,@GROUPID,@PRODUCTIDS,@COMPANYCODE,@SHARECOMPANYID,@STATUS)");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CID", DbType.String, model.CID);
db.AddInParameter(dbCommand, "COMPANYTYPE", DbType.String, model.COMPANYTYPE);
db.AddInParameter(dbCommand, "COMPANYNAME", DbType.String, model.COMPANYNAME);
db.AddInParameter(dbCommand, "COMPANYID", DbType.String, model.COMPANYID);
db.AddInParameter(dbCommand, "GROUPID", DbType.String, model.GROUPID);
db.AddInParameter(dbCommand, "PRODUCTIDS", DbType.String, model.PRODUCTIDS);
db.AddInParameter(dbCommand, "COMPANYCODE", DbType.String, model.COMPANYCODE);
db.AddInParameter(dbCommand, "SHARECOMPANYID", DbType.String, model.SHARECOMPANYID);
db.AddInParameter(dbCommand, "STATUS", DbType.String, model.STATUS);
db.ExecuteNonQuery(dbCommand) > 0;
}
