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