管理系统开发三： winforml录入界面

本是古典何须时尚 2022-03-08 03:26 208阅读 0赞

1.打开sql server  添加数据库

![20190314104608620.png][]

2.打开VS  创建录入界面

3![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3NTgzMDk4_size_16_color_FFFFFF_t_70][]

3.打开VS  添加新建方法 储存实体类

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    
    namespace Models
    {
        /// <summary>
        /// 社区实体类
        /// </summary>
        public class SeQuDate
        {
            public string SqId { get; set; }
            public string SqName { get; set; }
            public string SqManer { get; set; }
            //将数据库中的18位整数转换成字符串
            public string SqPhone { get; set; }
            public DateTime SqTime { get; set; }
        }
    }

4.添加新建脚本 储存数据访问类

/// <summary>
            /// 添加 社区信息
            /// </summary>
            /// <param name="objsq"></param>
            /// <returns></returns>
            public int AddSeQu(SeQuDate objsq)
            {
                string sql = "insert into SeQu (sqid,sqname,sqmaner,sqphone,sqtime) ";
                sql += "values ('{0}','{1}','{2}','{3}','{4}')";
                sql = string.Format(sql,
                    objsq.SqId,
                    objsq.SqName,
                    objsq.SqManer,
                    objsq.SqPhone,
                    objsq.SqTime);
                try
                {
                    return SQLHelper.Update(sql);
                }
                catch (Exception ex)
                {
    
                    throw new Exception("保存数据出错！" + ex.Message);
                }
            }

5.打开录入界面  双击录入按钮 进入方法

using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;
    using System.Windows.Forms;
    using Models;
    using DAL;
    
    namespace StudentManager
    {
        /// <summary>
        /// 社区信息添加 功能
        /// </summary>
        public partial class My_SeQuAdd : Form
        {
            private SeQuService objSequ = new SeQuService();//数据库后台链接
    
            public My_SeQuAdd()
            {
                InitializeComponent();
            }
            private void My_SeQuAdd_Load(object sender, EventArgs e)
            {
            }
    
    
            //确认添加社区信息
            private void BtnAddOK_Click(object sender, EventArgs e)
            {
                //社区代码验证
                if (this.textBoxid.Text.Trim().Length != 12)
                {
                    MessageBox.Show("社区代码应为12位数字", "验证提示");
                    this.textBoxid.Focus();
                    return;
                }
               
                //验证完毕 上传数据库
                //1.封装对象
                SeQuDate sqdate = new SeQuDate()
                {
                    SqId = this.textBoxid.Text.Trim(),
                    SqName = this.textBoxname.Text.Trim(),
                    SqManer = this.textBoxMan.Text.Trim(),
                    SqPhone = this.textBoxphone.Text.Trim(),
                    SqTime = Convert.ToDateTime(this.dateTimePicker1.Text)
                };
                //2.提交对象
                try
                {
                    int result = objSequ.AddSeQu(sqdate);
                    if (result == 1)
                    {
                        sqlLog.WriteSQLLog(this.textBoxname.Text + "社区信息添加");
                        DialogResult dresult = MessageBox.Show("添加成功！继续添加吗？", "添加询问",
                            MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
                        if (dresult == DialogResult.OK)
                        {
                            //清空当前文本框
                            Cleardate();
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
    
            }
    
            //数据清空
            private void Cleardate()
            {
                this.textBoxid.Text = "";
                this.textBoxMan.Text = "";
                this.textBoxname.Text = ""; ;
                this.textBoxphone.Text = "";
                this.textBoxid.Focus();
            }
    
            //重新输入
            private void button2_Click(object sender, EventArgs e)
            {
                Cleardate();
            }
        }
    }

预祝成功！！！！！！！！！！！

下一章 管理系统开发四： 在主窗体中嵌入子窗体的实现

1.  管理系统开发一： winform连接sql数据库 https://blog.csdn.net/m0\_37583098/article/details/88546146
2.  管理系统开发二： winforml登录界面sql数据查询和修改 https://blog.csdn.net/m0\_37583098/article/details/88547123
3.  管理系统开发三： winforml录入界面 https://blog.csdn.net/m0\_37583098/article/details/88547805
4.  管理系统开发四： 在主窗体中嵌入子窗体的实现 https://blog.csdn.net/m0\_37583098/article/details/88549151
5.  管理开发系统五：winform连接数据库查询 使用DataGridView展示查询结果 https://blog.csdn.net/m0\_37583098/article/details/88549461
6.  管理开发系统六：winform连接数据库修改 https://blog.csdn.net/m0\_37583098/article/details/88550157
7.  管理开发系统七：winform连接数据库删除 https://blog.csdn.net/m0\_37583098/article/details/88578796
8.  管理开发系统八：winform导出excel https://blog.csdn.net/m0\_37583098/article/details/88579043
9.  管理开发系统九：winform带sql数据库导出 https://blog.csdn.net/m0\_37583098/article/details/88580311
10. sql service 常用语句基础https://blog.csdn.net/m0\_37583098/article/details/87876264

[20190314104608620.png]: /images/20220308/7b74d940d92a445da30f20966e83d69a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3NTgzMDk4_size_16_color_FFFFFF_t_70]: /images/20220308/02b2b9579502419ab22e1a6fc1064c24.png