コード例 #1
0
        /// <summary>
        /// 從訂單資料抓出來型體尺碼訊息
        /// </summary>
        /// <param name=></param>
        /// <returns></returns>
        public List <MODEL.doc_StyleSize> GetStyleSizefromOrder(string yyyymm)
        {
            string       sql = @"
  select   StyleBase, Style  , Size ,min(OrderDate) OrderDate  from
( 
  select  distinct  Style,StyleBase,a.Name,d.Size,d.SizeID, a.OrderDate from doc_StyleBase  a
  left join(     
	  select  b.Name ,c.Size,OrderDate,c.SizeID  from T_StyleCodeInfo  b
	  right join (
    select SizeID, Size, T_StyleCodeInfoGuid from T_Sizi  ) c on b.Guid = c.T_StyleCodeInfoGuid     
		) d on a.Name=d.Name	
)g
where OrderDate>=@OrderDate
Group by StyleBase,Style,g.Size
                ";
            SqlParameter p   = new SqlParameter("OrderDate", yyyymm);
            DataTable    dt  = SqlHelper.ExcuteTable(sql, p);
            List <MODEL.doc_StyleSize> lists = null;

            if (dt.Rows.Count > 0)
            {
                lists = new List <MODEL.doc_StyleSize>();
                foreach (DataRow row in dt.Rows)
                {
                    MODEL.doc_StyleSize c = new MODEL.doc_StyleSize();
                    LoadDataToList(row, c);
                    lists.Add(c);
                }
            }
            return(lists);
        }
コード例 #2
0
 /// <summary>
 /// 加载行数据到对象--集合
 /// </summary>
 /// <param name="dr"></param>
 /// <param name="classes"></param>
 public void LoadDataToList(DataRow dr, MODEL.doc_StyleSize stylesize)
 {
     stylesize.Style     = (String)SqlHelper.FromDbValue(dr["Style"]);
     stylesize.StyleBase = (String)SqlHelper.FromDbValue(dr["StyleBase"]);
     stylesize.Size      = (String)SqlHelper.FromDbValue(dr["Size"]);
     stylesize.OrderDate = (String)SqlHelper.FromDbValue(dr["OrderDate"]);
 }
コード例 #3
0
        /// <summary>
        ///
        /// </summary>
        /// <param name=></param>
        /// <returns></returns>
        public List <MODEL.doc_StyleSize> GetAllStyleSize1(string yyyymm)
        {
            string sql = @"
                select * from  doc_StyleSize where OrderDate=@OrderDate
            ";

            SqlParameter[] ps =
            {
                new SqlParameter("@OrderDate", yyyymm)
            };

            DataTable dt = SqlHelper.ExcuteTable(sql, ps);
            List <MODEL.doc_StyleSize> lists = null;

            if (dt.Rows.Count > 0)
            {
                lists = new List <MODEL.doc_StyleSize>();
                foreach (DataRow row in dt.Rows)
                {
                    MODEL.doc_StyleSize c = new MODEL.doc_StyleSize();
                    LoadDataToList1(row, c);
                    lists.Add(c);
                }
            }
            return(lists);
        }
コード例 #4
0
        /// <summary>
        /// 增加人员信息
        /// </summary>
        /// <param name="addStyle"></param>
        /// <returns></returns>
        public int AddStyleSize(MODEL.doc_StyleSize addStyleSize)
        {
            string sql = "";

            sql = @"		insert into doc_StyleSize(Guid,Style,StyleBase,OrderDate,Section,Size,BoxSize,Weight,L,W,H ,Unit,NewCode) 
	            values(@Guid,@Style,@StyleBase,@OrderDate,@Section,@Size,@BoxSize,@Weight,@L,@W,@H ,@Unit,@NewCode) "    ;


            SqlParameter[] ps =
            {
                new SqlParameter("@Guid", SqlDbType.UniqueIdentifier)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.Guid)
                },
                new SqlParameter("@Style", SqlDbType.NVarChar)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.Style)
                },
                new SqlParameter("@StyleBase", SqlDbType.NVarChar)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.StyleBase)
                },
                new SqlParameter("@OrderDate", SqlDbType.NVarChar)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.OrderDate)
                },
                new SqlParameter("@Section", SqlDbType.NVarChar)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.Section)
                },
                new SqlParameter("@Size", SqlDbType.NVarChar)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.Size)
                },
                new SqlParameter("@BoxSize", SqlDbType.NVarChar)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.BoxSize)
                },
                new SqlParameter("@Unit", SqlDbType.NVarChar)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.Unit)
                },
                new SqlParameter("@Weight", SqlDbType.Float)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.Weight)
                },
                new SqlParameter("@Range", SqlDbType.Float)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.Range)
                },
                new SqlParameter("@L", SqlDbType.Float)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.L)
                },
                new SqlParameter("@W", SqlDbType.Float)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.W)
                },
                new SqlParameter("@H", SqlDbType.Float)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.H)
                },
                new SqlParameter("@NewCode", SqlDbType.NVarChar)
                {
                    Value = SqlHelper.ToDbValue(addStyleSize.NewCode)
                }
            };
            return(SqlHelper.ExecuteNonQuery(sql, ps));
        }
コード例 #5
0
 /// <summary>
 /// 增加人员信息
 /// </summary>
 /// <param name="addStyle"></param>
 /// <returns></returns>
 public int AddStyleSize(MODEL.doc_StyleSize addStyleSize)
 {
     return(ss.AddStyleSize(addStyleSize));
 }
コード例 #6
0
ファイル: FrmStyleBase.cs プロジェクト: eric33230/wrjitnew
        private void btnALLStyle_Click(object sender, EventArgs e)
        {
            #region ----------------StyleBase
            int aa = 0;
            ///*
            // 从订单中提出形体大类需要的资讯 ,使用唯一的Code 工厂型体捉出订单中大类的其他栏位
            sblist = od.GetOrdertolStyle(YearMounth.Text);
            MODEL.doc_StyleBase sb = new MODEL.doc_StyleBase();

            for (int k = 0; k < sblist.Count; k++)
            {
                test.Clear();
                sb.Guid       = System.Guid.NewGuid();
                sb.Style      = sblist[k].Style;
                sb.StyleBase  = sblist[k].StyleBase;
                sb.Name       = sblist[k].Name;
                sb.CustomName = sblist[k].CustomName;
                //    sb.CustomNameS = sblist[k].CustomNameS;
                sb.GoodsTypeName = sblist[k].GoodsTypeName;
                sb.ModelNo       = sblist[k].ModelNo;
                sb.RBcode        = sblist[k].RBcode;
                sb.MDcode        = sblist[k].MDcode;
                sb.Editionhandle = sblist[k].Editionhandle;
                sb.Innor         = sblist[k].Editionhandle;
                sb.OrderDate     = sblist[k].OrderDate;
                sb.NewCode       = sblist[k].NewCode;
                test.AppendText("型体大类" + "\r\n" + sb.Style + sb.OrderDate + "\r\n" + (k + 1).ToString() + "/" + sblist.Count.ToString());
                if (sbm.IsStyleBaseExisits(sblist[k].Name) < 1)
                {
                    //     MessageBox.Show("自动增加" + sb.Name);
                    sbm.AddStyleBase(sb);
                    aa = aa + 1;
                }
                ;
            }
            //*/
            MessageBox.Show(aa.ToString() + "筆新型體新增");
            #endregion


            #region ----- add  StyleBase newcode
            ///*
            BLL.doc_StyleBaseManager sbm1 = new BLL.doc_StyleBaseManager();
            sblist1 = sbm.GetAllStyleBase();

            for (int l = 0; l < sblist1.Count; l++)
            {
                test.Clear();
                //   MessageBox.Show(sblist1[l].Name);
                string mycode = "";
                mycode = sbm.GetSBNewCode(YearMounth.Text, sblist1[l].Name);
                test.AppendText("型体日期" + "\r\n" + mycode + "\r\n" + (l + 1).ToString() + "/" + sblist1.Count.ToString());
                sbm1.updateStylebaseNewCode(sblist1[l].Name, mycode);
            }

            sblist1 = sbm.GetAllStyleBase();
            this.dgvStyleBase.DataSource = sblist1;

            ///*/
            #endregion -----end add new code


            #region ----------------Style
            // /*
            int myadd = 0;
            odlist = od.GetAllCode(YearMounth.Text);
            List <MODEL.doc_Style> lists = null;
            lists = new List <MODEL.doc_Style>();
            for (int b = 0; b < odlist.Count; b++)
            {
                test.Clear();
                MODEL.doc_Style c = new MODEL.doc_Style();
                c.Code = odlist[b].Code;
                string[] mycode = odlist[b].Code.Split('/');
                c.Style = mycode[0].Trim();
                c.Guid  = new Guid();

                //判断如果没有/ 那么长度就会为1(一段)
                // if (odlist[j].Code.Length > mycode[0].Length)
                if (mycode.Length > 1)
                {
                    c.Color = mycode[1].Trim();
                }
                ;

                c.OrderDate = odlist[b].OrderDate;
                test.AppendText("型体配色" + "\r\n" + "c.Style" + "\r\n" + (b + 1).ToString() + "/" + odlist.Count.ToString());
                lists.Add(c);

                if (sm.IsCodeExisits(odlist[b].Code) < 1)
                {
                    sm.AddStyle(c);
                    myadd++;
                }
            }

            MessageBox.Show(myadd.ToString() + "筆新配色新增");
            //*/
            #endregion
            #region ----- add style newcode
            ///*
            BLL.doc_StyleManager sm1 = new BLL.doc_StyleManager();
            slist1 = sm1.GetAllStyle();

            for (int c = 0; c < slist1.Count; c++)
            {
                test.Clear();
                //   MessageBox.Show(sblist1[l].Name);
                string mycode1 = "";
                mycode1 = sm.GetSNewCode(YearMounth.Text, slist1[c].Code);
                test.AppendText("型体配色日期" + "\r\n" + mycode1 + "\r\n" + (c + 1).ToString() + "/" + slist1.Count.ToString());
                sm1.updateStyleNewCode(slist1[c].Code, mycode1);
            }
            //*/
            #endregion -----end add new code


            #region -------stylesize
            int sscount = 0;
            //*
            sslist = null;
            sslist = ssm.GetStyleSizefromOrder(YearMounth.Text);
            List <MODEL.doc_StyleSize> sslists = null;
            sslists = new List <MODEL.doc_StyleSize>();

            for (int a = 0; a < sslist.Count; a++)
            {
                test.Clear();
                MODEL.doc_StyleSize ss = new MODEL.doc_StyleSize();
                ss.Guid      = System.Guid.NewGuid();
                ss.Style     = sslist[a].Style;
                ss.StyleBase = sslist[a].StyleBase;
                // 取消sStyleBase
                ss.OrderDate = sslist[a].OrderDate;
                // 取消OrderDate 由於Code 不規範 (有些中間會有空格) ,所以OrderDate會多筆
                ss.Size = sslist[a].Size;

                ss.NewCode = "";
                ss.BoxSize = "";
                ss.Section = "";
                ss.Unit    = "cm";
                ss.Weight  = 0;
                ss.Range   = null;
                ss.L       = null;
                ss.W       = null;
                ss.H       = null;
                test.AppendText("型体尺码" + "\r\n" + ss.Style + "\r\n" + (a + 1).ToString() + "/" + sslist.Count.ToString());
                sslists.Add(ss);
                if (ssm.IsStyleSizeExisits(ss.Style, ss.Size) < 1)
                {
                    ssm.AddStyleSize(ss);
                    sscount++;
                }
                ;
                sslists.Clear();
            }


            // */
            MessageBox.Show(sscount.ToString() + "筆型體尺碼新增");

            #endregion
            #region ----- add stylesize new code
            ///*
            BLL.doc_StyleSIzeManager ssm1 = new BLL.doc_StyleSIzeManager();
            sslist1 = ssm1.GetAllStyleSize();

            for (int c = 0; c < sslist1.Count; c++)
            {
                test.Clear();
                //   MessageBox.Show(sblist1[l].Name);
                string mycode2 = "";
                mycode2 = ssm1.GetSBNewCodeToSS(YearMounth.Text, sslist1[c].Style);
                test.AppendText("型体尺码日期" + "\r\n" + mycode2 + "\r\n" + (c + 1).ToString() + "/" + sslist1.Count.ToString());
                ssm1.updateStyleSizeNewCode(sslist1[c].Style, mycode2);
            }
            //*/
            MessageBox.Show("更新完毕");

            #endregion -----end add stylesize new code
        }
コード例 #7
0
ファイル: FrmOrderIn.cs プロジェクト: eric33230/wrjitnew
        // BLL.doc_StyleBaseManager stm = new BLL.doc_StyleBaseManager();


        private void btnALLStyle_Click(object sender, EventArgs e)
        {
            //----------------StyleBase

            // 从订单中提出形体大类需要的资讯 ,使用唯一的Code 工厂型体捉出订单中大类的其他栏位
            stylist = od.GetOrdertolStyle(YearMounth.Text);
            MODEL.doc_StyleBase sb = new MODEL.doc_StyleBase();
            int aa = 0;

            for (int k = 0; k < stylist.Count; k++)
            {
                test.Clear();
                sb.Guid          = System.Guid.NewGuid();
                sb.Style         = stylist[k].Style;
                sb.StyleBase     = stylist[k].StyleBase;
                sb.Name          = stylist[k].Name;
                sb.CustomName    = stylist[k].CustomName;
                sb.GoodsTypeName = stylist[k].GoodsTypeName;
                sb.ModelNo       = stylist[k].ModelNo;
                sb.RBcode        = stylist[k].RBcode;
                sb.MDcode        = stylist[k].MDcode;
                sb.Editionhandle = stylist[k].Editionhandle;
                sb.Innor         = stylist[k].Editionhandle;
                sb.OrderDate     = stylist[k].OrderDate;
                sb.NewCode       = stylist[k].NewCode;
                test.AppendText("型体大类" + "\r\n" + sb.Style + sb.OrderDate + "\r\n" + (k + 1).ToString() + "/" + stylist.Count.ToString());
                if (sbm.IsStyleBaseExisits(stylist[k].Name) < 1)
                {
                    //     MessageBox.Show("自动增加" + sb.Name);
                    sbm.AddStyleBase(sb);
                    aa = aa + 1;
                }
                ;
            }
            MessageBox.Show(aa.ToString() + "筆新型體新增");
            //    List<MODEL.doc_StyleBase> stybase = null;
            //      stybase = stm.GetAllStyleBase();
            //        this.dgvStyleBase.DataSource = stybase;

            //----------------Style

            int myadd = 0;

            odlist = od.GetAllCode(YearMounth.Text);

            List <MODEL.doc_Style> lists = null;

            lists = new List <MODEL.doc_Style>();
            for (int j = 0; j < odlist.Count; j++)
            {
                test.Clear();
                MODEL.doc_Style c = new MODEL.doc_Style();
                c.Code = odlist[j].Code;
                string[] mycode = odlist[j].Code.Split('/');
                c.Style = mycode[0].Trim();
                c.Guid  = new Guid();

                //判断如果没有/ 那么长度就会为1(一段)

                // if (odlist[j].Code.Length > mycode[0].Length)
                if (mycode.Length > 1)
                {
                    c.Color = mycode[1].Trim();
                }
                ;
                c.OrderDate = odlist[j].OrderDate;
                test.AppendText("型体" + "\r\n" + c.Style + c.OrderDate + "\r\n" + (j + 1).ToString() + "/" + odlist.Count.ToString());


                lists.Add(c);
                if (sm.IsCodeExisits(odlist[j].Code) < 1)
                {
                    sm.AddStyle(c);
                    myadd++;
                }
            }

            MessageBox.Show(myadd.ToString() + "筆新配色新增");


            //-------stylesize
            sslist = null;
            sslist = ssm.GetStyleSizefromOrder(YearMounth.Text);
            List <MODEL.doc_StyleSize> sslists = null;

            sslists = new List <MODEL.doc_StyleSize>();
            int sscount = 0;

            for (int j = 0; j < sslist.Count; j++)
            {
                test.Clear();
                MODEL.doc_StyleSize ss = new MODEL.doc_StyleSize();
                ss.Guid      = System.Guid.NewGuid();
                ss.Style     = sslist[j].Style;
                ss.StyleBase = sslist[j].StyleBase;
                // 取消sStyleBase
                ss.OrderDate = sslist[j].OrderDate;
                // 取消OrderDate 由於Code 不規範 (有些中間會有空格) ,所以OrderDate會多筆
                ss.Size    = sslist[j].Size;
                ss.NewCode = "";
                ss.BoxSize = "";
                ss.Section = "";
                ss.Unit    = "cm";
                ss.Weight  = null;
                ss.Range   = null;
                ss.L       = null;
                ss.W       = null;
                ss.H       = null;
                test.AppendText("型体尺码" + "\r\n" + ss.Style + ss.Size + "\r\n" + (j + 1).ToString() + "/" + sslist.Count.ToString());
                sslists.Add(ss);
                if (ssm.IsStyleSizeExisits(ss.Style, ss.Size) < 1)
                {
                    ssm.AddStyleSize(ss);
                    sscount++;
                }
                ;
                sslists.Clear();
            }
            MessageBox.Show(sscount.ToString() + "筆型體尺碼新增");

            //------- inneer Box
            //獲得該月訂單年月的型體尺碼數量
            solist = null;
            solist = ibm.GetInnerfromOrder(YearMounth.Text);
            //    MessageBox.Show(solist.Count.ToString());
            string show    = solist.Count.ToString();
            int    ibcount = 0;
            List <MODEL.doc_InnerBox> iblists = null;

            iblists = new List <MODEL.doc_InnerBox>();
            // doc_innorbox 沒有尺碼的增加 ,使用 name , size, color 判斷
            for (int j = 0; j < solist.Count; j++)
            {
                test.Clear();
                MODEL.doc_InnerBox ib = new MODEL.doc_InnerBox();
                ib.Guid         = System.Guid.NewGuid();
                ib.InnerBarcode = "";
                ib.Name         = solist[j].Name.Trim();
                ib.Style        = solist[j].Style.Trim();
                ib.Color        = solist[j].Color.Trim();
                ib.Size         = solist[j].Size.Trim();
                test.AppendText("内盒资料" + "\r\n" + ib.Name + ib.Color + ib.Size + "\r\n" + (j + 1).ToString() + "/" + solist.Count.ToString());
                ib.CustomName = solist[j].CustomName;
                ib.Type       = "";
                ib.StyleCode  = solist[j].Name + "." + solist[j].Color;
                ib.NewCode    = "";
                iblists.Add(ib);
                if (ibm.IsInnerBoxExisits(ib.Name, ib.Color, ib.Size) < 1)
                {
                    ibm.AddInnerBox(ib);
                    ibcount++;
                }
            }

            MessageBox.Show(ibcount.ToString() + "筆內盒資料新增");
        }