示例#1
0
        public byte[] getPhoto(string DocTreeID)
        {
            T_StyleCodeInfoDAL StyleCodeInfodal = new T_StyleCodeInfoDAL();

            byte[] imgBytes = StyleCodeInfodal.getPhoto(DocTreeID);
            return(imgBytes);
        }
示例#2
0
        public DataTable GetT_StyleCodeSizeRun(string DocTreeID, string osmDocTreeID)
        {
            T_StyleCodeInfoDAL StyleCodeInfodal = new T_StyleCodeInfoDAL();

            DataTable SizeRunTable = StyleCodeInfodal.GetT_StyleCodeSizeRun(DocTreeID, osmDocTreeID);

            return(SizeRunTable);
        }
示例#3
0
        public DataTable GetT_Size(string CustomStyleCode)
        {
            T_StyleCodeInfoDAL StyleCodeInfodal = new T_StyleCodeInfoDAL();

            DataTable SizeRunTable = StyleCodeInfodal.GetT_Size(CustomStyleCode);

            return(SizeRunTable);
        }
示例#4
0
        public string GetCountByosmDocTreeID(string CustomStyleCode)
        {
            T_StyleCodeInfoDAL StyleCodeInfodal = new T_StyleCodeInfoDAL();
            string             guid             = StyleCodeInfodal.GetCountByosmDocTreeID(CustomStyleCode);

            return(guid);
            //  if (t == 0)
            // {
            //   StyleCodeInfodal.updataFromDV(dvsytleinfo, guid);
            //  }
        }
示例#5
0
        public void updataFromsinfoDV(T_StyleCodeInfo dvsytleinfo, string guid)
        {
            T_StyleCodeInfoDAL StyleCodeInfodal = new T_StyleCodeInfoDAL();

            //int t = 0;
            //t = StyleCodeInfodal.GetCountByosmDocTreeID(dvsytleinfo.CustomStyleCode);
            //if (t == 0)
            //{
            StyleCodeInfodal.updataFromsinfoDV(dvsytleinfo, guid);
            //}
        }
示例#6
0
        public T_StyleCodeInfo[] GetStyleCodeInfos(List <string> whereList, List <string> whereListText, string type)
        {
            T_StyleCodeInfoDAL StyleCodeInfodal = new T_StyleCodeInfoDAL();

            //先找本地庫的
            T_StyleCodeInfo[] StyleCodeInfos = StyleCodeInfodal.GetT_StyleCodeInfo(whereList, whereListText, type);

            //if (StyleCodeInfos.Length <= 0)
            //{
            //    //找ERP數據庫里的
            //     StyleCodeInfos = StyleCodeInfodal.GetT_StyleCodeInfo(whereList, whereListText, type);
            //}
            return(StyleCodeInfos);
        }
示例#7
0
        public void updataFromSize(string infoguid, string osmDocTreeID)
        {
            T_StyleCodeInfoDAL StyleCodeInfodal = new T_StyleCodeInfoDAL();
            Guid guid = new Guid(infoguid);

            T_Sizi[] SizeRun = StyleCodeInfodal.GetSizeRun(osmDocTreeID, guid);
            for (int i = 0; i < SizeRun.Count(); i++)
            {
                //  int t=0;
                //  t = StyleCodeInfodal.GetCountByosmDocTreeID(osmDocTreeID, SizeRun[i].SizeID);
                //  if (t == 0)
                // {
                StyleCodeInfodal.updataFromSizeRun(SizeRun[i]);
                //  }



                //Guid guid = Guid.NewGuid();
                //Guid T_StyleCodeInfoGuid = SizeRun[i].T_StyleCodeInfoGuid;
                //string DocTreeID = SizeRun[i].DocTreeID;
                //string CustomStyleCode = SizeRun[i].CustomStyleCode;
                //string SizeID = SizeRun[i].SizeID;
                //string Size = SizeRun[i].Size;
                //string Ccount = SizeRun[i].Ccount
            }
            //创建本地表
            //DataTable table = new DataTable();
            //table.Columns.Add("Guid", typeof(SqlGuid));
            //table.Columns.Add("T_StyleCodeInfoGuid", typeof(SqlGuid));
            //table.Columns.Add("DocTreeID");
            //table.Columns.Add("CustomStyleCode");
            //table.Columns.Add("SizeID");
            //table.Columns.Add("Size");
            //table.Columns.Add("Ccount");

            //for (int i = 1; i < SizeRun.Count(); i++)
            //{

            //    Guid guid = Guid.NewGuid();
            //    Guid T_StyleCodeInfoGuid = SizeRun[i].T_StyleCodeInfoGuid;
            //    string DocTreeID = SizeRun[i].DocTreeID;
            //    string CustomStyleCode = SizeRun[i].CustomStyleCode;
            //    string SizeID = SizeRun[i].SizeID;
            //    string Size = SizeRun[i].Size;
            //    string Ccount = SizeRun[i].Ccount;


            //    ////本地表加入数据  Unique
            //    DataRow row = table.NewRow();
            //    row["Guid"] = guid;
            //    row["T_StyleCodeInfoGuid"] = T_StyleCodeInfoGuid;
            //    row["DocTreeID"] = DocTreeID;
            //    row["CustomStyleCode"] = CustomStyleCode;
            //    row["SizeID"] = SizeID;
            //    row["Size"] = Size;
            //    row["Ccount"] = Ccount;
            //    table.Rows.Add(row);


            //    StyleCodeInfodal.sqlbulkcopy(table);

            //}
        }
示例#8
0
        public void UpdateFromERP()
        {
            T_StyleCodeInfoDAL StyleCodeInfodal = new T_StyleCodeInfoDAL();

            StyleCodeInfodal.UpdateFromERPDB();
        }