基本信息
源码名称:C#与sql server超市管理系统源码(含数据库脚本,亲测通过)
源码大小:3.31M
文件格式:.zip
开发语言:C#
更新时间:2018-07-13
   友情提示:(无需注册或充值,赞助后即可获取资源下载链接)

     嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):78630559

本次赞助数额为: 4 元 
   源码介绍
vs2017 sql server 2008/sql server 2012/sql server 2016







using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace SuperMarket
{
    public partial class MainForm : Form
    {
        public MainForm()
        {
            InitializeComponent();
        }
        private void Timer()
        {
            string year = DateTime.Now.Year.ToString();
            string month = DateTime.Now.Month.ToString();
            string day = DateTime.Now.Day.ToString();
            string weeks = DateTime.Now.DayOfWeek.ToString();
            string hour = DateTime.Now.Hour.ToString();
            string minute = DateTime.Now.Minute.ToString();//5^1^a^s^p^x
            string second = DateTime.Now.Second.ToString();
            string minutes = (Convert.ToInt32(minute) < 10) ? "0"   minute : minute;
            string week = "";
            switch (weeks)
            {
                case "Monday": week = "星期一"; break;
                case "Tuesday": week = "星期二"; break;
                case "Wednesday": week = "星期三"; break;
                case "Thursday": week = "星期四"; break;
                case "Friday": week = "星期五"; break;
                case "Saturday": week = "星期六"; break;
                case "Sunday": week = "星期日"; break;

            }
            tlbltime.Text =  hour   "时"   minutes   "分"   second   "秒";
            this.tlblUserID.Text = "  "  LoginDB.user   " "   LoginDB.userStyle "  欢迎操作本系统 ";
            tlbdate.Text = "  今天是:"   year   "年"   month   "月"   day   "日"   " "   week  "  现在是:";
        }
        //返回子窗体
        private Form FindMdiChild(string text)/////////////////////////////////////////////
        {
            foreach (Form form in this.MdiChildren)
            {
                if (form.Text == text)
                {
                    return form;
                }
            }
            return null;
        }
        //如果窗体打开则不再打开
        private bool ActivateMdi(string text)/////////////////////////////////////////////
        {
            Form f = FindMdiChild(text);

            if (f != null)
            {
                f.Activate();
                return true;
            }
            return false;
        }
        private void OpenFormSelectIndex(int page)//////////////////////////////////////
        {
            foreach (Form f in this.MdiChildren)
            {
                if (f.Text.Equals("商品管理"))
                {
                    f.Close();
                }
            }
            MarchMag marchMag = new MarchMag(page);
            marchMag.MdiParent = this;
            marchMag.Show();
        }
        private void QryStaticMemberIndex(int page)///////////////////////////////////////
        {
            foreach (Form f in this.MdiChildren)
            {
                if (f.Text.Equals("会员管理员"))
                {
                    f.Close();
                }
            }
            QryStaticMember qryStaticMember = new QryStaticMember(page);
            qryStaticMember.MdiParent = this;
            qryStaticMember.Show();
        }
        /************************************************************************/
        private void timer1_Tick(object sender, EventArgs e)
        {
            this.Timer();
        }

        private void t_UserMag_Click(object sender, EventArgs e)
        {
            UserMag userMag = new UserMag();
            if (!ActivateMdi("用户管理"))
            {

                userMag.MdiParent = this;
                userMag.Show();
            }
        }

        private void 修改密码ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            UpdatePwd updatePwd = new UpdatePwd();
            if (!ActivateMdi("修改密码"))
            {
                updatePwd.MdiParent = this;
                updatePwd.Show();
            }
        }

        private void 进货管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            InputMarch inputmarch = new InputMarch();
            if (!ActivateMdi("进货管理"))
            {
                inputmarch.MdiParent = this;
                inputmarch.Show();
            }
        }

        private void 库存管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            OpenFormSelectIndex(1);
        }

        private void 销售管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            OpenFormSelectIndex(0);
        }

        private void 会员管理ToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            QryStaticMemberIndex(1);
        }

        private void 会员信息查询和统计ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            QryStaticMemberIndex(0);
        }

        private void 销售信息录入ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (!ActivateMdi("销售信息录入"))
            {
                InputSale inputSale = new InputSale();
                inputSale.MdiParent = this;
                inputSale.Show();
            }
        }

        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (shows.showDialog("欢迎使用本系统!您确定退出本系统吗?"))
            {
                this.Close();
                Application.Exit();
            }
        }

        private void MainForms_Load(object sender, EventArgs e)
        {
            string userStyle = LoginDB.userStyle;
            if (userStyle == "销售人员")
            {
                销售信息录入ToolStripMenuItem.Enabled = true;
                修改密码ToolStripMenuItem.Enabled = true;
                销售信息录入ToolStripMenuItem1.Enabled = true;
                btnSaleInput.Visible = true;
            }
            else if (userStyle == "经理")
            {
                用户管理ToolStripMenuItem.Enabled = true;
                进货管理ToolStripMenuItem.Enabled = true;
                库存管理ToolStripMenuItem.Enabled = true;
                销售管理ToolStripMenuItem.Enabled = true;
                会员信息查询和统计ToolStripMenuItem.Enabled = true;
                会员管理ToolStripMenuItem1.Enabled = true;
                销售信息录入ToolStripMenuItem.Enabled = true;
                修改密码ToolStripMenuItem.Enabled = true;
                /*************************************************/
                btnuserMag.Visible = true;
                btnUpdatePwd.Visible = true;
                btnInputMerch.Visible = true;
                btnStockMag.Visible = true;
                btnMerchMag.Visible = true;
                btnMemberMag.Visible = true;
                btnMemberSearch.Visible = true;
                btnSaleInput.Visible = true;
                /*************************************************/
                用户管理ToolStripMenuItem1.Enabled = true;
                进货管理ToolStripMenuItem1.Enabled = true;
                库存管理ToolStripMenuItem1.Enabled = true;
                会员信息查寻和统计ToolStripMenuItem.Enabled = true;
                会员管理ToolStripMenuItem2.Enabled = true;
                销售信息录入ToolStripMenuItem1.Enabled = true;
                商品管理ToolStripMenuItem1.Enabled = true;
            }
            this.Timer();
        }

        private void 重新登录ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            LoginDB Login = new LoginDB();
            Context.context.MainForm = Login;
            Login.Show();
            this.Close();
        }

        private void 关于ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            About about = new About();
            if (!ActivateMdi("关于"))
            {
                
                about.MdiParent = this;
                about.Show();
            }
        }

    }
}