/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.AccessDataBase.Model.BlackListCardInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BlackListCardInfo("); strSql.Append("CardID,CardVersion,CardDeactiveDateTime,UserName,MarkBListReason,BListStateFlag)"); strSql.Append(" values ("); strSql.Append("@CardID,@CardVersion,@CardDeactiveDateTime,@UserName,@MarkBListReason,@BListStateFlag)"); SqlParameter[] parameters = { new SqlParameter("@CardID", SqlDbType.NVarChar, 10), new SqlParameter("@CardVersion", SqlDbType.NVarChar, 10), new SqlParameter("@CardDeactiveDateTime", SqlDbType.NVarChar, 10), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@MarkBListReason", SqlDbType.NVarChar, 100), new SqlParameter("@BListStateFlag", SqlDbType.NVarChar, 1) }; parameters[0].Value = model.CardID; parameters[1].Value = model.CardVersion; parameters[2].Value = model.CardDeactiveDateTime; parameters[3].Value = model.UserName; parameters[4].Value = model.MarkBListReason; parameters[5].Value = model.BListStateFlag; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.AccessDataBase.Model.BlackListCardInfo DataRowToModel(DataRow row) { KryptonAccessController.AccessDataBase.Model.BlackListCardInfo model = new KryptonAccessController.AccessDataBase.Model.BlackListCardInfo(); if (row != null) { if (row["CardID"] != null) { model.CardID = row["CardID"].ToString(); } if (row["CardVersion"] != null) { model.CardVersion = row["CardVersion"].ToString(); } if (row["CardDeactiveDateTime"] != null) { model.CardDeactiveDateTime = row["CardDeactiveDateTime"].ToString(); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["MarkBListReason"] != null) { model.MarkBListReason = row["MarkBListReason"].ToString(); } if (row["BListStateFlag"] != null) { model.BListStateFlag = row["BListStateFlag"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KryptonAccessController.AccessDataBase.Model.BlackListCardInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BlackListCardInfo set "); strSql.Append("CardVersion=@CardVersion,"); strSql.Append("CardDeactiveDateTime=@CardDeactiveDateTime,"); strSql.Append("UserName=@UserName,"); strSql.Append("MarkBListReason=@MarkBListReason,"); strSql.Append("BListStateFlag=@BListStateFlag"); strSql.Append(" where CardID=@CardID "); SqlParameter[] parameters = { new SqlParameter("@CardVersion", SqlDbType.NVarChar, 10), new SqlParameter("@CardDeactiveDateTime", SqlDbType.NVarChar, 10), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@MarkBListReason", SqlDbType.NVarChar, 100), new SqlParameter("@BListStateFlag", SqlDbType.NVarChar, 1), new SqlParameter("@CardID", SqlDbType.NVarChar, 10) }; parameters[0].Value = model.CardVersion; parameters[1].Value = model.CardDeactiveDateTime; parameters[2].Value = model.UserName; parameters[3].Value = model.MarkBListReason; parameters[4].Value = model.BListStateFlag; parameters[5].Value = model.CardID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.AccessDataBase.Model.BlackListCardInfo GetModel(string CardID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 CardID,CardVersion,CardDeactiveDateTime,UserName,MarkBListReason,BListStateFlag from BlackListCardInfo "); strSql.Append(" where CardID=@CardID "); SqlParameter[] parameters = { new SqlParameter("@CardID", SqlDbType.NVarChar, 10) }; parameters[0].Value = CardID; KryptonAccessController.AccessDataBase.Model.BlackListCardInfo model = new KryptonAccessController.AccessDataBase.Model.BlackListCardInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.AccessDataBase.Model.BlackListCardInfo DataRowToModel(DataRow row) { KryptonAccessController.AccessDataBase.Model.BlackListCardInfo model=new KryptonAccessController.AccessDataBase.Model.BlackListCardInfo(); if (row != null) { if(row["CardID"]!=null) { model.CardID=row["CardID"].ToString(); } if(row["CardVersion"]!=null) { model.CardVersion=row["CardVersion"].ToString(); } if(row["CardDeactiveDateTime"]!=null) { model.CardDeactiveDateTime=row["CardDeactiveDateTime"].ToString(); } if(row["UserName"]!=null) { model.UserName=row["UserName"].ToString(); } if(row["MarkBListReason"]!=null) { model.MarkBListReason=row["MarkBListReason"].ToString(); } if(row["BListStateFlag"]!=null) { model.BListStateFlag=row["BListStateFlag"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.AccessDataBase.Model.BlackListCardInfo GetModel(string CardID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 CardID,CardVersion,CardDeactiveDateTime,UserName,MarkBListReason,BListStateFlag from BlackListCardInfo "); strSql.Append(" where CardID=@CardID "); SqlParameter[] parameters = { new SqlParameter("@CardID", SqlDbType.NVarChar,10) }; parameters[0].Value = CardID; KryptonAccessController.AccessDataBase.Model.BlackListCardInfo model=new KryptonAccessController.AccessDataBase.Model.BlackListCardInfo(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }