1973计算机毕业设计asp.net外卖接单配送管理系统VS开发sqlserver数据库web结构c#编程计算机网页源码项目

最新推荐文章于 2024-07-20 20:04:43 发布

qq_251836457

最新推荐文章于 2024-07-20 20:04:43 发布

阅读量560

点赞数 8

分类专栏： asp.net类文章标签：数据库课程设计 asp.net

本文链接：https://blog.csdn.net/qq_41221322/article/details/140086514

版权

asp.net类专栏收录该内容

227 篇文章 22 订阅

订阅专栏

一、源码特点
asp.net外卖接单配送管理系统是一套完善的web设计管理系统，系统具有完整的源代码和数据库，系统主要采用B/S模式开发。

asp.net校园外卖接单配送管理系统

二、功能介绍
(1)管理员管理：对管理员信息进行添加、删除、修改和查看
(2)外卖员管理：对外卖员信息进行添加、删除、修改和查看
(3)商家管理：对商家信息进行添加、删除、修改和查看
(4)用户管理：对用户信息进行添加、删除、修改和查看
(5)楼栋管理：对楼栋信息进行添加、删除、修改和查看
(6)配送范围管理：对配送范围信息进行添加、删除、修改和查看
(7)订单管理：对订单信息进行添加、删除、修改和查看
(8)配送信息管理：对配送信息信息进行添加、删除、修改和查看

数据库设计

BEGIN
CREATE TABLE [dbo].[gly]([glyid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gly', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gly', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gly', @level2type=N'COLUMN', @level2name=N'xm'
BEGIN
CREATE TABLE [dbo].[wmy]([wmyid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[lxdh] [VARCHAR](40),
[lxdz] [VARCHAR](40),
[zt] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wmy', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wmy', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wmy', @level2type=N'COLUMN', @level2name=N'xm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wmy', @level2type=N'COLUMN', @level2name=N'lxdh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wmy', @level2type=N'COLUMN', @level2name=N'lxdz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wmy', @level2type=N'COLUMN', @level2name=N'zt'
BEGIN
CREATE TABLE [dbo].[shangjia]([sjid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[dz] [VARCHAR](40),
[ld] [VARCHAR](40),
[lxdh] [VARCHAR](40),
[jynr] [VARCHAR](40),
[tp] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangjia', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangjia', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangjia', @level2type=N'COLUMN', @level2name=N'xm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangjia', @level2type=N'COLUMN', @level2name=N'dz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'楼栋' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangjia', @level2type=N'COLUMN', @level2name=N'ld'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangjia', @level2type=N'COLUMN', @level2name=N'lxdh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'经营内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangjia', @level2type=N'COLUMN', @level2name=N'jynr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangjia', @level2type=N'COLUMN', @level2name=N'tp'
BEGIN
CREATE TABLE [dbo].[yonghu]([yhid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[ld] [VARCHAR](40),
[zz] [VARCHAR](40),
[dh] [VARCHAR](40),
[zcsj] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'xm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'楼栋' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'ld'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'住址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'zz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'dh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'注册时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'zcsj'
BEGIN
CREATE TABLE [dbo].[loudong]([ldid] [int] IDENTITY(1,1) NOT NULL,
[ld] [VARCHAR](40),
) ON [PRIMARY]
END

代码设计

   protected void Button1_Click(object sender, EventArgs e)
    {
	//添加配送范围信息 操作

		string wmy=this.wmy.Text;//外卖员
string ld=this.ld.Text;//楼栋

		if(wmy.Length==0){
MessageBox.Show(this.Page,"外卖员不能为空");
return ;
}

if(ld.Length==0){
MessageBox.Show(this.Page,"楼栋不能为空");
return ;
}
string sql = "select count(1) as num  from psfw where wmy='" + wmy + "' and ld='"+ld+"' ";

int num = 0;
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
    //是在线用户
    num = int.Parse(dt.Rows[0]["num"].ToString()); //获取用户数s


}
if (num > 0)
{
    MessageBox.Show(this.Page, "数据重复");
    return;
}
     

     
         sql = "insert into psfw (wmy,ld ) values ('"+wmy+"','"+ld+"')";//添加配送范围信息的sql语句
        int row = 0;
        try
        {
            row = DBHelper.ExecuteCommand(sql);//执行添加配送范围 
        }
        catch (Exception ex)
        {//异常捕获
            MessageBox.ShowAndRedirect(this.Page, ex.Message, "psfwadd.aspx");
      
        }
        MessageBox.ShowAndRedirect(this.Page, "添加成功", "psfwadd.aspx");//页面提示并跳转
    }

三、注意事项
1、管理员账号：admin 密码：admin
2、开发环境为vs2010，数据库为sqlserver2008，使用c#语言开发。
3、数据库文件名aspnetwmjd.mdf
4.系统首页地址：login.aspx

四系统实现

需要源码其他的定制服务下方联系卡片↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ 或者私信作者

qq_251836457

关注

8
点赞
踩
1

收藏

觉得还不错? 一键收藏
打赏
0
评论
1973计算机毕业设计asp.net外卖接单配送管理系统VS开发sqlserver数据库web结构c#编程计算机网页源码项目

(6)配送范围管理：对配送范围信息进行添加、删除、修改和查看。(8)配送信息管理：对配送信息信息进行添加、删除、修改和查看。(1)管理员管理：对管理员信息进行添加、删除、修改和查看。(2)外卖员管理：对外卖员信息进行添加、删除、修改和查看。(3)商家管理：对商家信息进行添加、删除、修改和查看。(4)用户管理：对用户信息进行添加、删除、修改和查看。(5)楼栋管理：对楼栋信息进行添加、删除、修改和查看。(7)订单管理：对订单信息进行添加、删除、修改和查看。1、管理员账号：admin 密码：admin。
复制链接

扫一扫