コード例 #1
0
ファイル: MysqlPrize.cs プロジェクト: 454240357/SmartLaw
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public SmartLaw.Model.Prize DataRowToModel(DataRow row)
        {
            SmartLaw.Model.Prize model = new SmartLaw.Model.Prize();
            if (row != null)
            {
                if (row["AutoID"] != null)
                {
                    model.AutoID = long.Parse(row["AutoID"].ToString());
                }
                if (row["PrizeName"] != null && row["PrizeName"].ToString() != "")
                {
                    model.PrizeName = row["PrizeName"].ToString();
                }
                if (row["PrizeUnit"] != null && row["PrizeUnit"].ToString() != "")
                {
                    model.PrizeUnit = row["PrizeUnit"].ToString();
                }
                if (row["Points"] != null)
                {
                    model.Points =int.Parse( row["Points"].ToString());
                }
                if (row["Registrant"] != null && row["Registrant"].ToString() != "")
                {
                    model.Registrant = row["Registrant"].ToString();
                }
                if (row["Stock"] != null)
                {
                    model.Stock = long.Parse( row["Stock"].ToString());
                }
                if (row["Remarks"] != null && row["Remarks"].ToString() != "")
                {
                    model.Remarks = row["Remarks"].ToString();
                }
                if (row["RegTime"] != null && row["RegTime"].ToString() != "")
                {
                    model.RegTime = DateTime.Parse(row["RegTime"].ToString());
                }
                if (row["Picture"] != null && row["Picture"].ToString() != "")
                {
                    model.Picture = row["Picture"].ToString();
                }

            }
            return model;
        }
コード例 #2
0
ファイル: MysqlPrize.cs プロジェクト: 454240357/SmartLaw
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public SmartLaw.Model.Prize GetModel(long AutoID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select AutoID,PrizeName,PrizeUnit,Points,Registrant,Stock,Remarks,RegTime,Picture from Prize");
            strSql.Append(" where AutoID=@AutoID limit 1");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@AutoID", MySqlDbType.Int64)
            };
            parameters[0].Value = AutoID;

            SmartLaw.Model.Prize model = new SmartLaw.Model.Prize();
            DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }