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