Beispiel #1
0
        /// <summary>
        /// 根据一批入库记录作为初始化的库存
        /// </summary>
        /// <param name="PaperInData"></param>
        /// <returns></returns>
        public static DataTable InitStoreList(DataTable PaperInData, int year, int month)
        {
            if (PaperInData != null)
            {
                List <Store_month> StoreList = new List <Store_month>();
                List <Paper_Store> PaperList = Paper_Store.GetAllPaperList();
                //List<Paper_Store> NeedSavePaperList = new List<Paper_Store>();
                List <Paper_In> DataList = DataSource.ORMHelper.TbToModelList <Paper_In>(PaperInData);

                for (int i = 0; i < PaperList.Count; i++)
                {
                    Store_month st = new Store_month();
                    st.PaperId   = PaperList[i].PaperId;
                    st.PaperName = PaperList[i].PaperName;
                    int index = -1;
                    for (int j = 0; j < DataList.Count; j++)
                    {
                        if (DataList[j].PaperId == PaperList[i].PaperId)
                        {
                            index         = j;
                            st.LastNum   += DataList[index].Num;
                            st.LastMoney += DataList[index].Money;
                        }
                    }
                    st.Year         = year;
                    st.Month        = month;
                    st.OrderNo      = year * 100 + month;
                    st.CalTime      = DateTime.Now;
                    st.CurrentMoney = st.LastMoney;
                    st.CurrentNum   = st.LastNum;
                    if (st.CurrentNum != 0)
                    {
                        st.CurrentPrice = Math.Abs(Math.Round(st.LastMoney / st.LastNum, 2));
                    }
                    else
                    {
                        st.CurrentPrice = 0;
                    }
                    //清除原来所有的当前库存;
                    //if (PaperList[i].Num != 0 || PaperList[i].TaxiMoney != 0 || PaperList[i].TaxiPrice != 0)
                    //{
                    //    PaperList[i].Num = 0;
                    //    PaperList[i].TaxiMoney = 0;
                    //    PaperList[i].TaxiPrice = 0;
                    //    NeedSavePaperList.Add(PaperList[i]);
                    //}
                    StoreList.Add(st);
                }
                return(DataSource.ORMHelper.ModelListToTb <Store_month>(StoreList));
            }
            return(null);
        }
Beispiel #2
0
        public static Store_month GetPaperMonthStore(int year, int month, int PaperId)
        {
            string where = " Year='" + year.ToString() + "' and Month='" + month.ToString() + "' and PaperId='" + PaperId.ToString() + "'";
            DataTable dt = GetDataTable(where);

            if (dt != null && dt.Rows.Count > 0)
            {
                Store_month result = DataSource.ORMHelper.RowToModel <Store_month>(dt.Rows[0]);
                if (result != null)
                {
                    return(result);
                }
            }
            return(null);
        }
Beispiel #3
0
        public static DataTable MakeNewStore(int year, int month)
        {
            List <Store_month> StoreList = new List <Store_month>();
            List <Paper_Store> PaperList = Paper_Store.GetAllPaperList();

            List <Paper_In>  InList  = Paper_In.GetYearMonthList(year, month);
            List <Paper_Out> OutList = Paper_Out.GetYearMonthList(year, month);

            List <Store_month> Lastlist;

            Store_month total = new Store_month();

            if (month == 1)
            {
                Lastlist = GetMonthStoreList(year - 1, 12);
            }
            else
            {
                Lastlist = GetMonthStoreList(year, month - 1);
            }
            for (int i = 0; i < PaperList.Count; i++)
            {
                Store_month st = new Store_month();
                st.PaperId   = PaperList[i].PaperId;
                st.PaperName = PaperList[i].PaperName;
                int index = -1;
                if (InList != null)
                {
                    for (int j = 0; j < InList.Count; j++)
                    {
                        if (InList[j].PaperId == PaperList[i].PaperId)
                        {
                            index       = j;
                            st.InNum   += InList[index].Num;
                            st.InMoney += InList[index].Money;
                        }
                    }
                }
                if (OutList != null)
                {
                    for (int j = 0; j < OutList.Count; j++)
                    {
                        if (OutList[j].PaperId == PaperList[i].PaperId)
                        {
                            index        = j;
                            st.OutNum   += OutList[index].Num;
                            st.OutMoney += OutList[index].Money;
                        }
                    }
                }
                if (Lastlist != null)
                {
                    for (int j = 0; j < Lastlist.Count; j++)
                    {
                        if (Lastlist[j].PaperId == PaperList[i].PaperId)
                        {
                            index        = j;
                            st.LastNum   = Lastlist[index].CurrentNum;
                            st.LastMoney = Lastlist[index].CurrentMoney;
                        }
                    }
                }
                st.Year         = year;
                st.Month        = month;
                st.OrderNo      = year * 100 + month;
                st.CalTime      = DateTime.Now;
                st.CurrentNum   = PaperList[i].Num;
                st.CurrentPrice = PaperList[i].TaxiPrice;
                st.CurrentMoney = PaperList[i].TaxiMoney;
                StoreList.Add(st);
                total.LastNum      += st.LastNum;
                total.LastMoney    += st.LastMoney;
                total.InNum        += st.InNum;
                total.InMoney      += st.InMoney;
                total.OutNum       += st.OutNum;
                total.OutMoney     += st.OutMoney;
                total.CurrentNum   += st.CurrentNum;
                total.CurrentMoney += st.CurrentMoney;
            }
            total.PaperName = "汇总";
            StoreList.Add(total);
            return(DataSource.ORMHelper.ModelListToTb <Store_month>(StoreList));
        }
Beispiel #4
0
 public static int Update(Store_month paper)
 {
     return(DataSource.ORMHelper.UpdateModelById <Store_month>(paper));
 }