inwarehouseform.cs

一个超市管理系统,没有错误,非常好,里面什么都有!很使用,很有用

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using DaFanRongMIS.Model.Provider;
using DaFanRongMIS.ViewController.Material;
using DaFanRongMIS.Model.Material;
using DaFanRongMIS.Model.InWarehoures;
using DaFanRongMIS.Model.Sell;
namespace DaFanRongMIS.ViewController.InWarehoures
{
    public partial class InWarehouseForm : Form
    {
        public MaterialEntity ME = new MaterialEntity();
        //int i = 0;
        public string username;
        public string pwd;
        public string status;
        public int flag = 1;

        public InWarehouseForm(string UserName,string Pwd,string Status)
        {
            InitializeComponent();
            //ME = me;
            username = UserName;
            pwd = Pwd;
            status = Status;
        }
       
        public InWarehouseForm()
        {
            InitializeComponent();

        }

        #region 自动生成流水号
        public string AutoID()
        {
            //定义操作类接口，实现接口
            InWareDAO IWD = new InWareDAOImpl();
            DataTable dt=IWD.SelectMaterialMain();
            string strid;

            //判断流水号是否为空

            if (dt.Rows[0][0].ToString() == "")
            {
                //初始化流水号(无店号)

                strid = DateTime.Now.ToString("yyyyMMdd") + "0001";
            }
            else
            {
                string strCode = (Convert.ToInt32(dt.Rows[0][0].ToString().Substring(10)) + 1).ToString("0000");

                //设置流水号值(无店号)

                strid = DateTime.Now.ToString("yyyyMMdd") + strCode;
            }

            //返回自动生成流水号(无店号)

            return strid;
        }
        #endregion

        #region 自动填充CMB（供应商名称）
        public void FillCmbProvider()
        {
            ProviderDAO PD = new ProviderDAOImpl();
            ProviderEntity PE = new ProviderEntity();
            DataTable dt = PD.SelectProvider(PE);
            cboProviderName.DataSource = dt;
            cboProviderName.DisplayMember = dt.Columns[1].ToString();
            cboProviderName.ValueMember = dt.Columns[0].ToString();

        }
        #endregion

        private void textBox1_TextChanged(object sender, EventArgs e)
        {

        }

        private void InWarehouseForm_Load(object sender, EventArgs e)
        {
            this.FillCmbProvider();
            SellOperate SO = new SellOperate();
            DataTable dt = SO.Sel_ShellByShopID(username, pwd, status);
            tsslblShopName.Tag = dt.Rows[0][0].ToString();
            tsslblShopName.Text = dt.Rows[0][1].ToString();
            tsslblOperater.Text = dt.Rows[0][3].ToString();
            
        }

        private void button1_Click(object sender, EventArgs e)
        {

            MaterialForm mf = new MaterialForm(txtMaterialName);
            mf.ShowDialog();

            InWareDAO IWD = new InWareDAOImpl();
            DataTable dt = IWD.SelectStore(txtMaterialName.Tag.ToString());
            //if(dt.Rows[0][2].ToString()!="")
            if (dt.Rows.Count!=0)
            {
                txtMaterialPrice.Text = dt.Rows[0][2].ToString();
            }
            else
            {
                txtMaterialPrice.Text = "0.0";
                flag = 0;
            }
            txtMaterialPrice.Focus();
            txtMaterialPrice.SelectAll();


        }

        private void groupBox1_Enter(object sender, EventArgs e)
        {

        }

        private void txtMaterialPrice_KeyUp(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                txtMaterialNum.Focus();
            }


        }

        private void btnAddDetailInWare_Click(object sender, EventArgs e)
        {
            if (txtMaterialName.Text != "" && txtMaterialNum.Text != "" && txtMaterialPrice.Text != "0.0")
            {
                ListViewItem item = new ListViewItem();
                //方法一
                //if (i != 0)
                //{
                //    i++;
                //    item.SubItems.Add(i.ToString());
                //}
                //else
                //{
                //    item.SubItems.Add((i = i + 1).ToString());
                //}

                
                //方法二
                item.SubItems.Add((LVInWarehoures.Items.Count + 1).ToString());
                
                item.SubItems.Add(txtMaterialName.Text);
                item.SubItems.Add(txtMaterialPrice.Text);
                item.SubItems.Add(txtMaterialNum.Text);
                item.SubItems.Add(txtMaterialName.Tag.ToString());
                LVInWarehoures.Items.Add(item);

                
                txtMaterialName.Text="";
                txtMaterialPrice.Text="";
                txtMaterialNum.Text="";
            }
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            tsslblNowTime.Text = DateTime.Now.ToString();
        }

        private void btnCanel_Click(object sender, EventArgs e)
        {
            txtMaterialName.Text = "";
            txtMaterialNum.Text = "";
            txtMaterialPrice.Text="";
            cboProviderName.Text="";
        }

        private void btnBack_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void btnAddMainAndDetailInWare_Click(object sender, EventArgs e)
        {
            InWareMainEntity IWME = new InWareMainEntity();
             
            #region 材料管理主表赋值
            IWME.ID=tsslblShopName.Tag.ToString()+AutoID();

            IWME.ShopID = tsslblShopName.Tag.ToString();
            IWME.Operator = tsslblOperater.Text;
            IWME.BusinessTime = DateTime.Now.ToString();
            IWME.BusinessType = "入库";
            IWME.Destination = cboProviderName.Text;
            IWME.Memo = "";
            #endregion

           
            
            InWareDetailEntity[] IWDE= new InWareDetailEntity[LVInWarehoures.Items.Count];
            InWareStoreEntity[] IWSE=new InWareStoreEntity[LVInWarehoures.Items.Count];

            for (int i = 0; i < LVInWarehoures.Items.Count; i++)
            {
                #region 材料管理从表赋值
                    IWDE[i] = new InWareDetailEntity();
                    IWDE[i].MainID = tsslblShopName.Tag.ToString()+AutoID();
                    IWDE[i].Materialid = LVInWarehoures.Items[i].SubItems[5].Text;
                    IWDE[i].BusinessCount=Convert.ToDecimal(LVInWarehoures.Items[i].SubItems[4].Text);
                    IWDE[i].MemberPrice=Convert.ToDecimal(LVInWarehoures.Items[i].SubItems[3].Text);
                
                #endregion

                #region 库存赋值
                    IWSE[i] = new InWareStoreEntity();   
                    IWSE[i].MaterialID = LVInWarehoures.Items[i].SubItems[5].Text;
                    IWSE[i].BusinessCount=LVInWarehoures.Items[i].SubItems[4].Text;
                    IWSE[i].MemberPrice=LVInWarehoures.Items[i].SubItems[3].Text;

                #endregion
               
            }
            
            InWareDAO IWD=new InWareDAOImpl();
            IWD.InWare(IWME,IWDE,IWSE,flag);
            LVInWarehoures.Items.Clear();
            cboProviderName.Enabled = true;
            
           

        }

        private void cboProviderName_SelectionChangeCommitted(object sender, EventArgs e)
        {
            cboProviderName.Enabled = false;
        }
    }
}