asp.net教程基本操作,asp.net项目实战开发入门

首页 > 教育 > 作者:YD1662024-05-20 23:37:03

一、效果图

asp.net教程基本操作,asp.net项目实战开发入门(1)


二、实现过程

1、model实体类

using System; using System.Collections.Generic; using System.Linq; using System.Text; ​ namespace guolei.Model { public class title { public int id { get; set; } public string tb_title { get; set; } public DateTime add_time { get; set; } } }

2、dal数据访问

/// <summary> /// 增加数据,首先要添加引用Model层 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Model.title model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into title("); strSql.Append("tb_title,add_time)"); strSql.Append(" values ("); strSql.Append("@title,@add_time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.NVarChar,50), new SqlParameter("@add_time", SqlDbType.DateTime)}; parameters[0].Value = model.tb_title; parameters[1].Value = model.add_time; //添加主表数据 object obj = new SqlHelper().ExecuteScalar(strSql.ToString(), parameters, CommandType.Text); model.id = Convert.ToInt32(obj); return model.id; }

3、web后台代码

#region 增加操作================================= private bool DoAdd() { bool result = false; Model.title model = new Model.title(); model.tb_title = txtTb_title.Text.Trim(); model.add_time = Utils.StrToDateTime(txtAdd_time.Text.Trim(), DateTime.Now); if (new DAL.title().Add(model) > 0) { result = true; } ​ return result; } #endregion ​ //保存 protected void btnSubmit_Click(object sender, EventArgs e) { if (!DoAdd()) { Response.Write("<script>alert('错误!');</script>"); return; } else { Response.Write("<script>alert('增加成功!');</script>"); } }

4、sqlhelper数据访问助手类的相关代码

//带参数的获取第1行1列的数据 public object ExecuteScalar(string cmdText, SqlParameter[] paras, CommandType ct) { using (cmd = new SqlCommand(cmdText, Getconn())) { cmd.CommandType = ct; cmd.Parameters.AddRange(paras); object val = cmd.ExecuteScalar(); return val; } }

5、文本转日期格式的代码

using System; using System.Collections.Generic; using System.Linq; using System.Text; ​ namespace guolei.Common { public class Utils { public static DateTime StrToDateTime(string str, DateTime defValue) { if (!string.IsNullOrEmpty(str)) { DateTime dateTime; if (DateTime.TryParse(str, out dateTime)) return dateTime; } return defValue; } } } ​

栏目热文

文档排行

本站推荐

Copyright © 2018 - 2021 www.yd166.com., All Rights Reserved.