示例#1
0
        public static string GetTableAlias(string tableName)
        {
            if (__tableNames == null)
            {
                DataSet _data = new DataSet();
                _data.ReadXml(System.Configuration.ConfigurationManager.AppSettings["PathXMLAlias"]);

                __tableNames = new System.Collections.Hashtable();
                foreach (DataRow row in _data.Tables[0].Rows)
                {
                    if (!__tableNames.ContainsKey(row["name"].ToString().ToLower().Trim()))
                    {
                        __tableNames.Add(row["name"].ToString().ToLower().Trim(), row["alias"].ToString());
                    }
                }
            }


            if (__tableNames.ContainsKey(tableName))
            {
                return __tableNames[tableName].ToString();
            }

            return tableName;
        }
示例#2
0
        public bool ContainsDuplicate(int[] nums)
        {
            if (nums == null || nums.Length < 2)
            {
                return false;
            }

            System.Collections.Hashtable ht = new System.Collections.Hashtable();
            bool result = false;

            for (int i = 0; i < nums.Length; i++)
            {
                if (!ht.ContainsKey(nums[i]))
                {
                    ht.Add(nums[i], i);
                }
                else
                {
                    result = true;
                    break;
                }
            }

            return result;
        }
示例#3
0
		public static void  CheckHits_(Query query, System.String defaultFieldName, Searcher searcher, int[] results, TestCase testCase)
		{
            Hits hits = searcher.Search(query);
			
            System.Collections.Hashtable correct = new System.Collections.Hashtable();
            for (int i = 0; i < results.Length; i++)
            {
                correct.Add((System.Int32) results[i], null);
            }
			
            System.Collections.Hashtable actual = new System.Collections.Hashtable();
            for (int i = 0; i < hits.Length(); i++)
            {
                actual.Add((System.Int32) hits.Id(i), null);
            }
			
            //Assert.AreEqual(correct, actual, query.ToString(defaultFieldName));
            if (correct.Count != 0)
            {
                System.Collections.IDictionaryEnumerator iter = correct.GetEnumerator();
                bool status = false;
                while (iter.MoveNext())
                {
                    status = actual.ContainsKey(iter.Key);
                    if (status == false)
                        break;
                }
                Assert.IsTrue(status, query.ToString(defaultFieldName));
            }
        }
示例#4
0
        public int MajorityElement(int[] nums)
        {
            System.Collections.Hashtable ht = new System.Collections.Hashtable();

            for (int i = 0; i < nums.Length; i++)
            {
                if (!ht.ContainsKey(nums[i]))
                {
                    ht.Add(nums[i], 1);
                }
                else
                {
                    ht[nums[i]] = (int)ht[nums[i]] + 1;
                }
            }

            foreach (System.Collections.DictionaryEntry item in ht)
            {
                if ((int)item.Value > nums.Length / 2)
                {
                    return (int)item.Key;
                }
            }

            return 0;
        }
示例#5
0
        public Result Decode(BinaryBitmap image, System.Collections.Hashtable hints)
        {
            DecoderResult decoderResult;

            ResultPoint[] points;
            if (hints?.ContainsKey(DecodeHintType.PURE_BARCODE) == true)
            {
                BitMatrix bits = ExtractPureBits(image.BlackMatrix);
                decoderResult = Decoder.Decode(bits);
                points        = NO_POINTS;
            }
            else
            {
                DetectorResult detectorResult = new Detector(image.BlackMatrix).Detect(hints);
                decoderResult = Decoder.Decode(detectorResult.Bits);
                points        = detectorResult.Points;
            }

            Result result = new Result(decoderResult.Text, decoderResult.RawBytes, points, BarcodeFormat.QR_CODE);

            if (decoderResult.ByteSegments != null)
            {
                result.PutMetadata(ResultMetadataType.BYTE_SEGMENTS, decoderResult.ByteSegments);
            }
            if (decoderResult.ECLevel != null)
            {
                result.PutMetadata(ResultMetadataType.ERROR_CORRECTION_LEVEL, decoderResult.ECLevel.ToString());
            }
            return(result);
        }
示例#6
0
文件: CCTV.cs 项目: ufjl0683/Center
 protected override System.Collections.Hashtable setDisplay(RemoteInterface.HC.FetchDeviceData[] devNames, int maxSegId, MegType megType)
 {
     System.Collections.Hashtable displayht = new System.Collections.Hashtable();
     foreach (RemoteInterface.HC.FetchDeviceData dev in devNames)
     {
         if (!displayht.ContainsKey(dev.DevName))
         {
             displayht.Add(dev.DevName, null);
         }
     }
     return displayht;
 }
        public static string PerformWhois(string WhoisServerHost, int WhoisServerPort, string Host)
        {
            string result="";
            try {
                String strDomain = Host;
                char[] chSplit = {'.'};
                string[] arrDomain = strDomain.Split(chSplit);
                // There may only be exactly one domain name and one suffix
                if (arrDomain.Length != 2) {
                    return "";
                }

                // The suffix may only be 2 or 3 characters long
                int nLength = arrDomain[1].Length;
                if (nLength != 2 && nLength != 3) {
                    return "";
                }

                System.Collections.Hashtable table = new System.Collections.Hashtable();
                table.Add("de", "whois.denic.de");
                table.Add("be", "whois.dns.be");
                table.Add("gov", "whois.nic.gov");
                table.Add("mil", "whois.nic.mil");

                String strServer = WhoisServerHost;
                if (table.ContainsKey(arrDomain[1])) {
                    strServer = table[arrDomain[1]].ToString();
                }
                else if (nLength == 2) {
                    // 2-letter TLD's always default to RIPE in Europe
                    strServer = "whois.ripe.net";
                }

                System.Net.Sockets.TcpClient tcpc = new System.Net.Sockets.TcpClient ();
                tcpc.Connect(strServer, WhoisServerPort);
                String strDomain1 = Host+"\r\n";
                Byte[] arrDomain1 = System.Text.Encoding.ASCII.GetBytes(strDomain1.ToCharArray());
                System.IO.Stream s = tcpc.GetStream();
                s.Write(arrDomain1, 0, strDomain1.Length);
                System.IO.StreamReader sr = new System.IO.StreamReader(tcpc.GetStream(), System.Text.Encoding.ASCII);
                System.Text.StringBuilder strBuilder = new System.Text.StringBuilder();
                string strLine = null;
                while (null != (strLine = sr.ReadLine())) {
                    strBuilder.Append(strLine+"\r\n");
                }
                result = strBuilder.ToString();
                tcpc.Close();
            }catch(Exception exc) {
                result="Could not connect to WHOIS server!\r\n"+exc.ToString();
            }
            return result;
        }
示例#8
0
 /// <summary>
 /// If the hashtable contains the key, the corresponding
 /// hashtable value is returned
 /// </summary>
 /// <param name="key">One of the graphical keys starting with GC_*
 /// </param>
 /// <returns></returns>
 public object GetGraphicAttribute(string key)
 {
     if (_GCSettings.ContainsKey(key))
     {
         return(_GCSettings[key]);
     }
     else
     {
         return(null);
     }
 }
示例#9
0
        public object CustomFunction(int userId, string identifier, System.Collections.Hashtable input, out Library.DTO.Notification notification)
        {
            switch (identifier.ToLower())
            {
            case "getdata":
                if (!input.ContainsKey("ID"))
                {
                    notification = new Library.DTO.Notification()
                    {
                        Type = Library.DTO.NotificationType.Error, Message = "Unknow factory id"
                    };
                    return(null);
                }
                return(bll.GetData(userId, Convert.ToInt32(input["ID"]), out notification));

            case "getsearchfilter":
                return(bll.GetSearchFilter(userId, out notification));

            case "getdetail":
                if (!input.ContainsKey("ID"))
                {
                    notification = new Library.DTO.Notification()
                    {
                        Type = Library.DTO.NotificationType.Error, Message = "Unknow factory id"
                    };
                    return(null);
                }
                return(bll.GetDetail(userId, Convert.ToInt32(input["ID"]), out notification));

            case "getfactoryorderturnover":
                int    pageSize       = input.ContainsKey("PageSize") && input["PageSize"] != null && !string.IsNullOrEmpty(input["PageSize"].ToString()) ? Convert.ToInt32(input["PageSize"].ToString()) : 0;
                int    pageIndex      = input.ContainsKey("PageIndex") && input["PageIndex"] != null && !string.IsNullOrEmpty(input["PageIndex"].ToString()) ? Convert.ToInt32(input["PageIndex"].ToString()) : 0;
                string orderBy        = input.ContainsKey("OrderBy") && input["OrderBy"] != null && !string.IsNullOrEmpty(input["OrderBy"].ToString()) ? input["OrderBy"].ToString() : null;
                string orderDirection = input.ContainsKey("OrderDirection") && input["OrderDirection"] != null && !string.IsNullOrEmpty(input["OrderDirection"].ToString()) ? input["OrderDirection"].ToString() : null;
                int    totalRows      = input.ContainsKey("TotalRows") && input["TotalRows"] != null && !string.IsNullOrEmpty(input["TotalRows"].ToString()) ? Convert.ToInt32(input["TotalRows"].ToString()) : 0;
                return(bll.GetFactoryOrderTurnover(userId, input, pageSize, pageIndex, orderBy, orderDirection, out totalRows, out notification));

            case "exportexcelfactory":
                return(bll.ExportExcelFactory(userId, input, out notification));

            case "getpersonincharge":
                return(bll.GetPersonInCharge(userId, input, out totalRows, out notification));
            }
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Error, Message = "Custom function's identifier not matched"
            };
            return(null);
        }
示例#10
0
        public WebServiceCaller(string webServiceURI, string webMethodName)
            : base()
        {
            this._webServiceURI = webServiceURI;
            this._webMethodName = webMethodName;
            string hashTableKey = this._webServiceURI + "/" + this._webMethodName;

            if (_webServiceWebMethodRequestFormats.ContainsKey(hashTableKey))
            {
                this._requestFormat = (string)_webServiceWebMethodRequestFormats[hashTableKey];
            }
            else
            {
                this._requestFormat = this.GetRequestFormat();
                _webServiceWebMethodRequestFormats.Add(hashTableKey, this._requestFormat);
            }
        }
示例#11
0
        private Color GetColorByIDX(string personLookingAt, System.Collections.Hashtable hashy)
        {
            Color toUse;

            if (hashy.ContainsKey(personLookingAt))
            {
                toUse = (Color)hashy[personLookingAt];
            }
            else
            {
                // get a new color
                toUse = GetNextColor(hashy);
                hashy[personLookingAt] = toUse;
            }

            return(toUse);
        }
示例#12
0
        public object GetDetailProductionItemList(System.Collections.Hashtable filters, out Library.DTO.Notification notification)
        {
            List <DTO.DeliveryNoteDetailSearch> data = new List <DTO.DeliveryNoteDetailSearch>();

            notification = new Library.DTO.Notification {
                Type = Library.DTO.NotificationType.Success
            };

            var deliverynoteID = (filters.ContainsKey("deliveryNoteID") && filters["deliveryNoteID"] != null && !string.IsNullOrEmpty(filters["deliveryNoteID"].ToString())) ? Convert.ToInt32(filters["deliveryNoteID"].ToString()) : 0;

            using (var context = CreateContext())
            {
                var dbItem = context.VanPhatMng_DeliveryNoteDetail_SearchView.Where(o => o.DeliveryNoteID == deliverynoteID).ToList();
                data = converter.DB2DTO_GetListDetail(dbItem);
            }
            return(data);
        }
示例#13
0
        public static string TrackContent(string body, string domain, string dynamicEmailField, bool saveBat, string campaign, string oIdCampaign)
        {
            Campaign oCampaign  = new Campaign(new Guid(oIdCampaign));
            string   newcontent = body;
            // Track content
            Regex           oreg   = new Regex(@"href\s*=\s*(?:""(?<1>[^""]*)""|(?<1>\S+))");
            MatchCollection Result = oreg.Matches(body);

            if (Result.Count > 0) // no need if no link
            {
                // track links
                System.Collections.Hashtable oNewLink = new System.Collections.Hashtable();
                foreach (Match oMatsh in Result)
                {
                    string oUrlTempo = Removehref(oMatsh.Value); string ext = oMatsh.Value.Substring(oMatsh.Value.Length - 4, 4).ToLower();
                    if ((ext != ".jpg") && (ext != ".gif") && (ext != ".jepg") && (ext != ".png") && (oMatsh.Value.IndexOf("mailto") < 0) && (oMatsh.Value.IndexOf("file") < 0))
                    {
                        if (!oNewLink.ContainsKey(oUrlTempo))
                        {
                            oNewLink.Add(oUrlTempo, null);
                        }
                    }
                }
                foreach (string okey in oNewLink.Keys)
                {
                    string newlink = string.Format("https://{0}/Actions/o/{2}/?key={1}", domain, dynamicEmailField, TrackLink(oIdCampaign, okey).ToString());
                    newcontent = newcontent.Replace(okey, newlink);
                }
            }
            string endcontent      = string.Empty;
            int    endbodyposition = newcontent.ToLower().IndexOf("</body>");
            // Add img before /body or at the end
            string TagImg         = string.Format("<img src=\"https://{0}/Actions/op/{1}/?key={2}\" />", oCampaign.Domain, oIdCampaign, dynamicEmailField);
            string TagUnsubscribe = string.Format("<div>To unsubscribe and no longer receive our emails, please use <a href=\"https://{0}/Actions/Unsubscribe/{1}/?key={2}\" > this link</a>.</div>", oCampaign.Domain, oIdCampaign, dynamicEmailField);

            if (endbodyposition > 0)
            {
                endcontent = newcontent.Substring(0, endbodyposition - 1);
                endcontent = string.Concat(endcontent, TagUnsubscribe, TagImg, newcontent.Substring(endbodyposition, (newcontent.Length - (endbodyposition))));
            }
            else
            {
                endcontent = string.Concat(newcontent, TagUnsubscribe, TagImg);
            }
            return(endcontent);
        }
示例#14
0
 public object CustomFunction(int userId, string identifier, System.Collections.Hashtable input, out Library.DTO.Notification notification)
 {
     switch (identifier.ToLower())
     {
     case "getreportdataordered":
         if (!input.ContainsKey("season"))
         {
             throw new Exception("Unknow season");
         }
         return(bll.GetExcelReportData(userId, input["season"].ToString(), out notification));
     }
     notification = new Library.DTO.Notification()
     {
         Type = Library.DTO.NotificationType.Error, Message = "Custom function's identifier not matched"
     };
     return(null);
 }
示例#15
0
        /// <summary>
        /// 移除重复票号
        /// </summary>
        /// <returns></returns>
        public List <TicketNumInfo> MoveRepeatTicketNum(List <TicketNumInfo> TicketNumList)
        {
            System.Collections.Hashtable table           = new System.Collections.Hashtable();
            List <TicketNumInfo>         m_TicketNumList = new List <TicketNumInfo>();
            string key = "";

            foreach (TicketNumInfo item in TicketNumList)
            {
                key = item.PasName + item.TicketNum.Replace("-", "");
                if (!table.ContainsKey(key))
                {
                    table.Add(key, item);
                    m_TicketNumList.Add(item);
                }
            }
            return(m_TicketNumList);
        }
示例#16
0
        public virtual void WriteEntry(string message, EventLogEntryType type, int eventID)
        {
            // Make Trace more readable by doing this:
            if (message.Length > 80)
            {
                message += '\n';
            }

            if (type == EventLogEntryType.Error)
            {
                if (this.traceOnError)
                {
                    Trace.WriteLine("ERROR: " + message);
                }
            }
            else if (type == EventLogEntryType.Warning)
            {
                if (this.traceOnWarning)
                {
                    Trace.WriteLine("WARNING: " + message);
                }
            }
            else if (type == EventLogEntryType.Information)
            {
                if (this.traceOnInfo)
                {
                    Trace.WriteLine("INFO: " + message);
                }
            }

            long lastTime = (timeTable.ContainsKey(eventID)) ? (long)timeTable[eventID] : 0;

            if (lastTime < (DateTime.Now.Ticks - ticksBetweenEntry))
            {
                timeTable[eventID] = DateTime.Now.Ticks;

                try
                {
                    eventLog.WriteEntry(message, type, eventID);
                }
                catch
                {
                    // Write to isolated storage, so we can track failed eventlog writes
                }
            }
        }
示例#17
0
        public override SearchFormData GetDataWithFilter(System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
        {
            notification = new Library.DTO.Notification()
            {
                Type = Library.DTO.NotificationType.Success
            };
            SearchFormData data = new SearchFormData();

            data.Data = new List <PurchasingCalendarAppointmentSearchResultDTO>();
            totalRows = 0;

            //try to get data
            try
            {
                using (PurchasingCalendarMngEntities context = CreateContext())
                {
                    string MeetingLocations = null;
                    int    Month            = Convert.ToInt32(filters["month"]);
                    int    Year             = Convert.ToInt32(filters["year"]);
                    if (filters.ContainsKey("locations") && !string.IsNullOrEmpty(filters["locations"].ToString()))
                    {
                        MeetingLocations = string.Empty;
                        foreach (int locationID in Newtonsoft.Json.JsonConvert.DeserializeObject <int[]>(filters["locations"].ToString().Replace("'", "''")))
                        {
                            if (string.IsNullOrEmpty(MeetingLocations))
                            {
                                MeetingLocations += locationID.ToString();
                            }
                            else
                            {
                                MeetingLocations += "," + locationID.ToString();;
                            }
                        }
                    }

                    data.Data = converter.DB2DTO_AppointmentSearchResultDTOList(context.PurchasingCalendarMng_function_SearchPurchasingCalendarAppointment(MeetingLocations, Month, Year).ToList());
                }
            }
            catch (Exception ex)
            {
                notification.Type    = Library.DTO.NotificationType.Error;
                notification.Message = ex.Message;
            }

            return(data);
        }
示例#18
0
        private void button1_Click(object sender, EventArgs e)
        {
            //if (dgv存货档案.SelectedCells.Count != 0)
            //{
            //    MessageBox.Show(dgv存货档案.Rows.IndexOf(dgv存货档案.SelectedCells[0].OwningRow).ToString());
            //    //dgv存货档案.SelectedCells[0].OwningRow.;
            //}
            // 把乘号都变成大写 X
            string            sql = "select ID, 存货代码 from 设置存货档案 ";
            DataTable         dt  = new DataTable("设置存货档案"); //""中的是表名
            SqlDataAdapter    da  = new SqlDataAdapter(string.Format(sql, tb代码q.Text, tb名称q.Text), mySystem.Parameter.conn);
            SqlCommandBuilder cb  = new SqlCommandBuilder(da);

            //da.Fill(dt);
            //foreach (DataRow dr in dt.Rows)
            //{
            //    if (dr["存货代码"].ToString().Contains("×"))
            //    {
            //        System.Console.WriteLine(dr["存货代码"].ToString().Replace("×", "X"));
            //        dr["存货代码"] = dr["存货代码"].ToString().Replace("×", "X");
            //    }
            //}
            //da.Update(dt);
            // 去重
            da.Fill(dt);
            System.Collections.Hashtable ht = new System.Collections.Hashtable();
            foreach (DataRow dr in dt.Rows)
            {
                if (!ht.ContainsKey(dr["存货代码"]))
                {
                    ht.Add(dr["存货代码"], 0);
                }
                int n = (int)ht[dr["存货代码"]];
                ht[dr["存货代码"]] = n + 1;
            }
            foreach (Object h in ht.Keys)
            {
                int n = (int)ht[h];
                if (n > 1)
                {
                    System.Console.WriteLine(h.ToString());
                    System.Console.WriteLine(n);
                    System.Console.WriteLine("*******");
                }
            }
        }
        private void FrmPatientFeeReport_Load(object sender, EventArgs e)
        {
            foreach (object obj in Enum.GetValues(typeof(StatDateType)))
            {
                cboDateType.Items.Add(obj.ToString( ));
            }
            cboDateType.Text = StatDateType.统计日.ToString( );

            foreach (object obj in Enum.GetValues(typeof(OPDBillKind)))
            {
                cboInvoiceType.Items.Add(obj.ToString( ));
            }
            cboInvoiceType.SelectedIndex = 0;


            cboPatType.DisplayMember = "NAME";
            cboPatType.ValueMember   = "PATTYPECODE";
            cboPatType.DataSource    = BaseDataController.BaseDataSet[BaseDataCatalog.病人类型列表];

            dtpFrom.Value = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00");
            dtpEnd.Value  = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59");

            cboCharge.DisplayMember = "NAME";
            cboCharge.ValueMember   = "EMPLOYEE_ID";
            cboCharge.DataSource    = BaseDataController.BaseDataSet[BaseDataCatalog.人员列表];

            cboDept.DisplayMember = "NAME";
            cboDept.ValueMember   = "DEPT_ID";
            cboDept.DataSource    = BaseDataController.BaseDataSet[BaseDataCatalog.科室列表].Select("MZ_FLAG=1 AND TYPE_CODE='001'").CopyToDataTable();

            System.Collections.Hashtable htDoc = new System.Collections.Hashtable();
            DataTable tb = BaseDataController.BaseDataSet[BaseDataCatalog.医生列表];

            foreach (DataRow dr in tb.Rows)
            {
                if (!htDoc.ContainsKey(Convert.ToInt32(dr["EMPLOYEE_ID"])))
                {
                    htDoc.Add(Convert.ToInt32(dr["EMPLOYEE_ID"]), dr["EMP_NAME"].ToString().Trim());
                }
            }
            foreach (object obj in htDoc)
            {
                cboDoc.Items.Add(((System.Collections.DictionaryEntry)obj).Value.ToString());
            }
        }
示例#20
0
 /// <summary>
 /// HN5FZ开奖期号|开奖号
 /// </summary>
 /// <returns></returns>
 public static List <string> HN5FZ(string issue)
 {
     if (!_dicLcItemUpd.ContainsKey($"HN5FZ_{issue}"))
     {
         string code = HN5FZ_my.Analysis();
         _dicLcItemUpd[$"HN5FZ_{issue}"] = $"{issue}|{code}";
         return(new List <string>()
         {
             $"{issue}|{code}"
         });
     }
     else
     {
         return(null);
     }
 }
示例#21
0
        //iniitiate transactionDateAPI api
        public string transactionDateAPI(string merchant_email, string transaction_date)
        {
            System.Collections.Hashtable data = new System.Collections.Hashtable();
            data.Add("key", Key);
            data.Add("merchant_email", merchant_email);
            data.Add("transaction_date", transaction_date);
            // generate hash
            string[] hashVarsSeq = "key|merchant_email|transaction_date".Split('|'); // spliting hash sequence from config
            string   hash_string = "";

            foreach (string hash_var in hashVarsSeq)
            {
                hash_string = hash_string + (data.ContainsKey(hash_var) ? data[hash_var].ToString() : "");
                hash_string = hash_string + '|';
            }
            hash_string += salt;                                            // appending SALT
            gen_hash     = Easebuzz_Generatehash512(hash_string).ToLower(); //generating hash
            data.Add("hash", gen_hash);

            string url     = "https://dashboard.easebuzz.in/transaction/v1/retrieve/date";
            var    request = (HttpWebRequest)WebRequest.Create(url);

            var postData = "merchant_key=" + Key;

            postData += "&merchant_email=" + merchant_email;
            postData += "&transaction_date=" + transaction_date;
            postData += "&hash=" + gen_hash;

            var Ndata = Encoding.ASCII.GetBytes(postData);

            request.Method        = "POST";
            request.ContentType   = "application/x-www-form-urlencoded";
            request.ContentLength = Ndata.Length;

            using (var stream = request.GetRequestStream())
            {
                stream.Write(Ndata, 0, Ndata.Length);
            }

            var response = (HttpWebResponse)request.GetResponse();

            var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd();

            return(responseString);
        }
        private void  encodeBranch(Branch branch)
        {
            writer.writeUI8(branch.code);
            writer.writeUI16(2);
            int pos = writer.Pos;

            if (labels.ContainsKey(branch.target))
            {
                // label came earlier
                writer.writeSI16(getLabelOffset(branch.target) - pos - 2);
            }
            else
            {
                // label comes later. don't know the offset yet.
                updates.Add(new UpdateEntry(pos + 2, pos, branch));
                writer.writeSI16(0);
            }
        }
示例#23
0
 internal static System.Collections.ICollection GetFieldNames(IndexReader.FieldOption fieldNames, IndexReader[] subReaders)
 {
     // maintain a unique set of field names
     System.Collections.Hashtable fieldSet = new System.Collections.Hashtable();
     for (int i = 0; i < subReaders.Length; i++)
     {
         IndexReader reader = subReaders[i];
         System.Collections.IEnumerator names = ((System.Collections.IDictionary)reader.GetFieldNames(fieldNames)).Keys.GetEnumerator();
         while (names.MoveNext())
         {
             if (!fieldSet.ContainsKey(names.Current))
             {
                 fieldSet.Add(names.Current, names.Current);
             }
         }
     }
     return(fieldSet);
 }
示例#24
0
        public BasicEnum(int v, string s, Type type)
        {
            Value = v;
            State = s;
            if (!_hash.ContainsKey(type))
            {
                _hash.Add(type, new System.Collections.Hashtable());
            }
            var isTable = _hash[type] as System.Collections.Hashtable;

            if (isTable.ContainsKey(v))
            {
                throw new Exception("不能有重复的值");
            }
            isTable.Add(v, this);

            System.IO.File.WriteAllLines("enum.txt", new string[] { s, type.ToString() });
        }
示例#25
0
 public override System.Collections.ICollection GetIndexedFieldNames(bool storedTermVector)
 {
     // maintain a unique set of Field names
     System.Collections.Hashtable fieldSet = new System.Collections.Hashtable();
     for (int i = 0; i < subReaders.Length; i++)
     {
         Monodoc.Lucene.Net.Index.IndexReader reader = subReaders[i];
         System.Collections.ICollection       names  = reader.GetIndexedFieldNames(storedTermVector);
         foreach (object item in names)
         {
             if (fieldSet.ContainsKey(item) == false)
             {
                 fieldSet.Add(item, item);
             }
         }
     }
     return(fieldSet);
 }
示例#26
0
        public void SetExecOrder(System.Collections.ArrayList alExecOrder, System.Collections.Hashtable hsPatient)
        {
            this.neuSpread1_Sheet1.Rows.Count = 0;

            int iRowIndex = 0;

            foreach (Neusoft.HISFC.Models.Order.ExecOrder info in alExecOrder)
            {
                Neusoft.HISFC.Models.RADT.PatientInfo p = null;
                if (hsPatient.ContainsKey(info.Order.Patient.ID))
                {
                    p = hsPatient[info.Order.Patient.ID] as Neusoft.HISFC.Models.RADT.PatientInfo;
                }
                else
                {
                    p = info.Order.Patient;
                }

                this.neuSpread1_Sheet1.Rows.Add(iRowIndex, 1);

                this.neuSpread1_Sheet1.Cells[iRowIndex, 0].Text = "[" + p.PVisit.PatientLocation.Bed.ID + "]" + p.Name;

                Neusoft.HISFC.Models.Pharmacy.Item item = (Neusoft.HISFC.Models.Pharmacy.Item)info.Order.Item;
                //商品名称[规格]
                this.neuSpread1_Sheet1.Cells[iRowIndex, 1].Text = item.Name + "[" + item.Specs + "]";
                //组标记
                //每次量
                this.neuSpread1_Sheet1.Cells[iRowIndex, 3].Text = info.Order.DoseOnce.ToString() + info.Order.DoseUnit;
                //频次
                this.neuSpread1_Sheet1.Cells[iRowIndex, 4].Text = info.Order.Frequency.ID;
                //用法
                this.neuSpread1_Sheet1.Cells[iRowIndex, 5].Text = info.Order.Usage.ID;
                //数量
                this.neuSpread1_Sheet1.Cells[iRowIndex, 6].Text = info.Order.Qty.ToString() + info.Order.Unit;
                //备注
                this.neuSpread1_Sheet1.Cells[iRowIndex, 7].Text = info.Memo;
                //组合号
                this.neuSpread1_Sheet1.Cells[iRowIndex, 8].Text = info.Order.Combo.ID + info.DateUse.ToString();

                iRowIndex++;
            }

            HISFC.Components.Order.Classes.Function.DrawCombo(this.neuSpread1_Sheet1, 8, 2);
        }
示例#27
0
        /**
         * Detects common bzip2 suffixes in the given filename.
         *
         * @param filename name of a file
         * @return <code>true</code> if the filename has a common bzip2 suffix,
         *         <code>false</code> otherwise
         */
        public static bool isCompressedFilename(String filename)
        {
            if (uncompressSuffix.Count == 0)
            {
                addToUncompressSuffix();
            }
            String lower = filename.ToLower(System.Globalization.CultureInfo.GetCultureInfoByIetfLanguageTag("en"));
            int    n     = lower.length();

            // Shortest suffix is three letters (.bz), longest is five (.tbz2)
            for (int i = 3; i <= 5 && i < n; i++)
            {
                if (uncompressSuffix.ContainsKey(lower.Substring(n - i)))
                {
                    return(true);
                }
            }
            return(false);
        }
示例#28
0
 /// <summary>
 /// 获得指定类型的默认值
 /// </summary>
 /// <param name="ValueType">数据类型</param>
 /// <returns>默认值</returns>
 public static object GetDefaultValue(Type ValueType)
 {
     if (myDefaultValue == null)
     {
         myDefaultValue = new System.Collections.Hashtable();
         myDefaultValue[typeof(object)]                    = null;
         myDefaultValue[typeof(byte)]                      = (byte)0;
         myDefaultValue[typeof(sbyte)]                     = (sbyte)0;
         myDefaultValue[typeof(short)]                     = (short)0;
         myDefaultValue[typeof(ushort)]                    = (ushort)0;
         myDefaultValue[typeof(int)]                       = (int)0;
         myDefaultValue[typeof(uint)]                      = (uint)0;
         myDefaultValue[typeof(long)]                      = (long)0;
         myDefaultValue[typeof(ulong)]                     = (ulong)0;
         myDefaultValue[typeof(char)]                      = (char)0;
         myDefaultValue[typeof(float)]                     = (float)0;
         myDefaultValue[typeof(double)]                    = (double)0;
         myDefaultValue[typeof(decimal)]                   = (decimal)0;
         myDefaultValue[typeof(bool)]                      = false;
         myDefaultValue[typeof(string)]                    = null;
         myDefaultValue[typeof(DateTime)]                  = DateTime.MinValue;
         myDefaultValue[typeof(System.Drawing.Point)]      = System.Drawing.Point.Empty;
         myDefaultValue[typeof(System.Drawing.PointF)]     = System.Drawing.PointF.Empty;
         myDefaultValue[typeof(System.Drawing.Size)]       = System.Drawing.Size.Empty;
         myDefaultValue[typeof(System.Drawing.SizeF)]      = System.Drawing.SizeF.Empty;
         myDefaultValue[typeof(System.Drawing.Rectangle)]  = System.Drawing.Rectangle.Empty;
         myDefaultValue[typeof(System.Drawing.RectangleF)] = System.Drawing.RectangleF.Empty;
         myDefaultValue[typeof(System.Drawing.Color)]      = System.Drawing.Color.Transparent;
     }
     if (ValueType == null)
     {
         throw new ArgumentNullException("ValueType");
     }
     if (myDefaultValue.ContainsKey(ValueType))
     {
         return(myDefaultValue[ValueType]);
     }
     if (ValueType.IsValueType)
     {
         return(System.Activator.CreateInstance(ValueType));
     }
     return(null);
 }
        /// <summary>
        /// This method simulates the random failure behavior which happens in real world.
        /// We will randomly select a message to fail based on some random number value. To make sure the message processing fails
        /// all the times during subsequent retries, we add the result to the hashtable and retrieve it from there.
        /// </summary>
        /// <param name="receivedMessage"></param>
        /// <returns></returns>
        private static bool ProcessOrder(BrokeredMessage receivedMessage)
        {
            if (hashTable.ContainsKey(receivedMessage.Properties["OrderNumber"]))
            {
                return(false);
            }

            if (new Random().Next() % 2 == 0 ? true : false)
            {
                Console.WriteLine("Received Order {0} with {1} number of items and {2} total", receivedMessage.Properties["OrderNumber"],
                                  receivedMessage.Properties["NumberOfItems"], receivedMessage.Properties["OrderTotal"]);
                return(true);
            }
            else
            {
                hashTable.Add(receivedMessage.Properties["OrderNumber"], false);
                return(false);
            }
        }
示例#30
0
 /// <summary>
 /// 获取配置工艺流程执行信息
 /// </summary>
 /// <returns></returns>
 public static int GetProcessItemList(Control controlCollect, ref System.Collections.Hashtable hsProcess)
 {
     if (controlCollect.Controls.Count == 0 || controlCollect is Neusoft.FrameWork.WinForms.Controls.NeuComboBox)
     {
         if (hsProcess.ContainsKey(controlCollect.Name))
         {
             Neusoft.HISFC.Models.Preparation.Process p = hsProcess[controlCollect.Name] as Neusoft.HISFC.Models.Preparation.Process;
             Function.GetProcessItem(controlCollect, ref p);
         }
     }
     else
     {
         foreach (Control c in controlCollect.Controls)
         {
             Function.GetProcessItemList(c, ref hsProcess);
         }
     }
     return(1);
 }
示例#31
0
        private void _mainWidget_Destroyed(object sender, EventArgs e)
        {
            textEditor.Document.LineChanged   -= OnTextHasChanged;
            textEditor.TextArea.FocusInEvent  -= OnTextBoxEnter;
            textEditor.TextArea.FocusOutEvent -= OnTextBoxLeave;
            _mainWidget.Destroyed             -= _mainWidget_Destroyed;
            textEditor.TextArea.KeyPressEvent -= OnKeyPress;

            intellisense.ContextItemsNeeded -= ContextItemsNeeded;
            intellisense.ItemSelected       -= InsertCompletionItemIntoTextBox;
            intellisense.LoseFocus          -= HideCompletionWindow;
            intellisense.Cleanup();

            // It's good practice to disconnect all event handlers, as it makes memory leaks
            // less likely. However, we may not "own" the event handlers, so how do we
            // know what to disconnect?
            // We can do this via reflection. Here's how it currently can be done in Gtk#.
            // Windows.Forms would do it differently.
            // This may break if Gtk# changes the way they implement event handlers.
            foreach (Widget w in Popup)
            {
                if (w is MenuItem)
                {
                    PropertyInfo pi = w.GetType().GetProperty("AfterSignals", BindingFlags.NonPublic | BindingFlags.Instance);
                    if (pi != null)
                    {
                        System.Collections.Hashtable handlers = (System.Collections.Hashtable)pi.GetValue(w);
                        if (handlers != null && handlers.ContainsKey("activate"))
                        {
                            EventHandler handler = (EventHandler)handlers["activate"];
                            (w as MenuItem).Activated -= handler;
                        }
                    }
                }
            }

            Popup.Destroy();
            accel.Dispose();
            textEditor.Destroy();
            textEditor = null;
            _findForm.Destroy();
            _owner = null;
        }
示例#32
0
        public static void generate(string langname, string root_dir_path)
        {
            create();
            foreach (var doc_item in sates.core.doc_list.get_list())
            {
                string doc_type;
                if (table.ContainsKey(doc_item.doc_type))
                {
                    doc_type = doc_item.doc_type;
                }
                else
                {
                    doc_type = DEFAULT_GEN_NAME;
                }

                writer wr = (writer)table[doc_type];
                wr.write(root_dir_path, doc_item, langname);
            }
        }
示例#33
0
        //-------------------------------------------------------------------
        public void Index(MemManager.Log.Log lg)
        {
            System.Collections.Hashtable cache = new System.Collections.Hashtable(4096);
            int processed = 0;

            System.Text.StringBuilder addresses = new System.Text.StringBuilder();
            addresses.EnsureCapacity(32768);

            // Work out all unique addresses
            for (int i = 0; i < lg.Count; i++)
            {
                int index = lg[i].stackTraceString;
                if (index <= processed)
                    continue;

                processed = index;
                string callstack = lg.GetString(index);
                string[] addrarray = callstack.Split(' ');
                foreach (string s in addrarray)
                {
                    if (!cache.ContainsKey(s))
                    {
                        cache[s] = s;
                        addresses.Append(s);
                        addresses.Append(' ');

                        // Fix issue with nasty command line length issue on win32.
                        if (addresses.Length >= 32000)
                        {
                            Index(addresses.ToString());

                            // Wipe addresses
                            addresses = new System.Text.StringBuilder();
                            addresses.EnsureCapacity(32768);
                        }
                    }
                }
            }

            // Index unique addresses
            if (addresses.Length > 0)
                Index(addresses.ToString());
        }
        public Result decode(BinaryBitmap image, System.Collections.Hashtable hints)
        {
            DecoderResult decoderResult;

            ResultPoint[] points;
            if (hints != null && hints.ContainsKey(DecodeHintType.PURE_BARCODE))
            {
                BitMatrix bits = extractPureBits(image);
                decoderResult = decoder.decode(bits);
                points        = NO_POINTS;
            }
            else
            {
                DetectorResult detectorResult = new Detector(image).detect();
                decoderResult = decoder.decode(detectorResult.Bits);
                points        = detectorResult.Points;
            }
            return(new Result(decoderResult.Text, decoderResult.RawBytes, points, BarcodeFormat.PDF417));
        }
示例#35
0
 /// <summary>
 /// Get a value from the class
 /// </summary>
 /// <param name="Key">The key from which to get the value</param>
 /// <param name="ValueName">The value name in the key</param>
 /// <returns>The value of the value name inside the key</returns>
 public string GetValue(string Key, string ValueName)
 {
     System.Collections.Hashtable KeyTable = (System.Collections.Hashtable)Keys[Key];
     if (KeyTable != null)
     {
         if (KeyTable.ContainsKey(ValueName))
         {
             return((string)KeyTable[ValueName]);
         }
         else
         {
             return(null);
         }
     }
     else
     {
         return(null);
     }
 }
示例#36
0
        private void ApplyItems(object[] items)
        {
            view.BeginUpdate();

            try
            {
                System.Collections.Hashtable oldItems = new System.Collections.Hashtable(items.Length);
                foreach (ListViewItem viewItem in view.Items)
                {
                    object key = GetKeyFromItem(viewItem.Tag);
                    oldItems[key] = viewItem;
                }

                foreach (object item in items)
                {
                    object key = GetKeyFromItem(item);

                    if (oldItems.ContainsKey(key))
                    {
                        ListViewItem viewItem = oldItems[key] as ListViewItem;
                        UpdateListViewItem(viewItem, item);
                        oldItems.Remove(key);
                    }
                    else
                    {
                        ListViewItem viewItem = new ListViewItem();
                        UpdateListViewItem(viewItem, item);
                        view.Items.Add(viewItem);
                    }
                }

                foreach (ListViewItem item in oldItems.Values)
                {
                    view.Items.Remove(item);
                }

                view.Sort();
            }
            finally
            {
                view.EndUpdate();
            }
        }
示例#37
0
 public override System.Collections.ICollection GetFieldNames(IndexReader.FieldOption fieldNames)
 {
     System.Collections.Hashtable fieldSet = new System.Collections.Hashtable();
     for (int i = 0; i < readers.Count; i++)
     {
         IndexReader reader = ((IndexReader)readers[i]);
         System.Collections.ICollection names = reader.GetFieldNames(fieldNames);
         for (System.Collections.IEnumerator iterator = names.GetEnumerator(); iterator.MoveNext();)
         {
             System.Collections.DictionaryEntry fi = (System.Collections.DictionaryEntry)iterator.Current;
             System.String s = fi.Key.ToString();
             if (fieldSet.ContainsKey(s) == false)
             {
                 fieldSet.Add(s, s);
             }
         }
     }
     return(fieldSet);
 }
示例#38
0
 object com_GetReaderData(DBConnect.DataType type, object reader)
 {
     if (type == DBConnect.DataType.Decorators)
     {
         System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
         System.Collections.Hashtable decHT = new System.Collections.Hashtable();
         for (int i = 0; i < dr.FieldCount; i++)
         {
             if (!decHT.ContainsKey(dr.GetName(i))) decHT.Add(dr.GetName(i), dr[i]);
         }
         return decHT;
     }
     else if (type == DBConnect.DataType.LaneCount)
     {
         System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
         System.Collections.Hashtable laneCount = new System.Collections.Hashtable();
         laneCount.Add(0, Convert.ToString(dr[2]));
         laneCount.Add(1, Convert.ToString(dr[3]));
         laneCount.Add(2, Convert.ToString(dr[4]));
         laneCount.Add(3, Convert.ToString(dr[5]));
         laneCount.Add(4, Convert.ToString(dr[6]));
         laneCount.Add(5, Convert.ToString(dr[7]));
         laneCount.Add(6, Convert.ToString(dr[8]));
         laneCount.Add(7, Convert.ToString(dr[9]));
         laneCount.Add(8, Convert.ToString(dr[10]));
         laneCount.Add(9, Convert.ToString(dr[11]));
         laneCount.Add(10, Convert.ToString(dr[12]));
         laneCount.Add(11, Convert.ToString(dr[13]));
         laneCount.Add(12, Convert.ToString(dr[14]));
         laneCount.Add(13, Convert.ToString(dr[15]));
         laneCount.Add(14, Convert.ToString(dr[16]));
         return laneCount;
     }
     else
         return null;
 }
示例#39
0
        private String partial1(String c)
        {
            System.Collections.Hashtable h = new System.Collections.Hashtable();
            h.Add(" ", "11011001100");
            h.Add("!", "11001101100");
            h.Add("\"", "11001100110");
            h.Add("#", "10010011000");
            h.Add("$", "10010001100");
            h.Add("%", "10001001100");
            h.Add("&", "10011001000");
            h.Add("'", "10011000100");
            h.Add("(", "10001100100");
            h.Add(")", "11001001000");
            h.Add("*", "11001000100");
            h.Add("+", "11000100100");
            h.Add(",", "10110011100");
            h.Add("-", "10011011100");
            h.Add(".", "10011001110");
            h.Add("/", "10111001100");
            h.Add("0", "10011101100");
            h.Add("1", "10011100110");
            h.Add("2", "11001110010");
            h.Add("3", "11001011100");
            h.Add("4", "11001001110");
            h.Add("5", "11011100100");
            h.Add("6", "11001110100");
            h.Add("7", "11101101110");
            h.Add("8", "11101001100");
            h.Add("9", "11100101100");
            h.Add(":", "11100100110");
            h.Add(";", "11101100100");
            h.Add("<", "11100110100");
            h.Add("=", "11100110010");
            h.Add(">", "11011011000");
            h.Add("?", "11011000110");
            h.Add("@", "11000110110");
            h.Add("A", "10100011000");
            h.Add("B", "10001011000");
            h.Add("C", "10001000110");
            h.Add("D", "10110001000");
            h.Add("E", "10001101000");
            h.Add("F", "10001100010");
            h.Add("G", "11010001000");
            h.Add("H", "11000101000");
            h.Add("I", "11000100010");
            h.Add("J", "10110111000");
            h.Add("K", "10110001110");
            h.Add("L", "10001101110");
            h.Add("M", "10111011000");
            h.Add("N", "10111000110");
            h.Add("O", "10001110110");
            h.Add("P", "11101110110");
            h.Add("Q", "11010001110");
            h.Add("R", "11000101110");
            h.Add("S", "11011101000");
            h.Add("T", "11011100010");
            h.Add("U", "11011101110");
            h.Add("V", "11101011000");
            h.Add("W", "11101000110");
            h.Add("X", "11100010110");
            h.Add("Y", "11101101000");
            h.Add("Z", "11101100010");
            h.Add("[", "11100011010");
            h.Add(@"\", "11101111010");
            h.Add("]", "11001000010");
            h.Add("^", "11110001010");
            h.Add("_", "10100110000");
            h.Add("`", "10100001100");
            h.Add("a", "10010110000");
            h.Add("b", "10010000110");
            h.Add("c", "10000101100");
            h.Add("d", "10000100110");
            h.Add("e", "10110010000");
            h.Add("f", "10110000100");
            h.Add("g", "10011010000");
            h.Add("h", "10011000010");
            h.Add("i", "10000110100");
            h.Add("j", "10000110010");
            h.Add("k", "11000010010");
            h.Add("l", "11001010000");
            h.Add("m", "11110111010");
            h.Add("n", "11000010100");
            h.Add("o", "10001111010");
            h.Add("p", "10100111100");
            h.Add("q", "10010111100");
            h.Add("r", "10010011110");
            h.Add("s", "10111100100");
            h.Add("t", "10011110100");
            h.Add("u", "10011110010");
            h.Add("v", "11110100100");
            h.Add("w", "11110010100");
            h.Add("x", "11110010010");
            h.Add("y", "11011011110");
            h.Add("z", "11011110110");
            h.Add("{", "11110110110");
            h.Add("|", "10101111000");
            h.Add("}", "10100011110");
            h.Add("~", "10001011110");

            if (h.ContainsKey(c) == true)
            {
                return h[c].ToString();
            }
            return null;
        }
示例#40
0
        /// <summary>
        /// Method LoadViews()
        /// </summary>
        //protected override void LoadViews()
        public void LoadViews()
        {
            this.views = new Collection<View>();
            System.Collections.Hashtable RelatedViews = new System.Collections.Hashtable();

            DataTable viewsTable = GetViewsAsDataTable();
            foreach (DataRow viewRow in viewsTable.Rows)
            {
                View V = new Epi2000.View(viewRow, this);

                // set the is related view attribute
                IDataReader R = this.collectedData.GetTableDataReader(V.Name);
                while(R.Read())
                {

                    if (R["Name"].ToString().ToUpper().StartsWith("RELVIEW"))
                    {
                        if(! RelatedViews.ContainsKey(R["DataTable"].ToString()))
                        {
                            RelatedViews.Add(R["DataTable"].ToString(), R["DataTable"].ToString());
                        }
                    }
                }
                R.Close();

                this.views.Add(V);
            }

            foreach(Epi2000.View V in this.views)
            {
                if (RelatedViews.ContainsKey(V.Name))
                {
                    V.IsRelatedView = true;
                }
            }
        }
示例#41
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (Session["userID"] == null)
                {
                    // Redirect user to login before doing anything else
                    Response.Redirect("~/Login.aspx?redirect=MyAccount.aspx");
                }
                else
                {
                    String myConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
                    SqlConnection myConnection = new SqlConnection(myConnectionString);

                    try
                    {
                        myConnection.Open();

                        /**
                         * Find default address
                         */
                        SqlCommand cmd = new SqlCommand("Select * from [GadgetFox].[dbo].[Addresses], [GadgetFox].[dbo].[ZipCodes] where Addresses.Zip = ZipCodes.Zip and EmailID=@EmailID and IsProfileAddress=@IsProfileAddress", myConnection);
                        cmd.Parameters.AddWithValue("@EmailID", Session["userID"].ToString());
                        cmd.Parameters.AddWithValue("@IsProfileAddress", true);
                        SqlDataReader dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            addressLB.Text = dr["Address Line1"].ToString() + "<br/>";
                            if (dr["Address Line2"].ToString().Length > 0)
                                addressLB.Text += dr["Address Line2"].ToString() + "<br/>";

                            addressLB.Text += dr["City"].ToString() + ", " + dr["State"].ToString() + " " + dr["Zip"].ToString();
                        }
                        dr.Close();

                        /**
                         * Find first and last name
                         */
                        SqlCommand cmd2 = new SqlCommand("Select * from [GadgetFox].[dbo].[Users] where EmailID=@EmailID", myConnection);
                        cmd2.Parameters.AddWithValue("@EmailID", Session["userID"].ToString());
                        SqlDataReader dr2 = cmd2.ExecuteReader();
                        if (dr2.Read())
                        {
                            nameLB.Text = dr2["FirstName"].ToString() + " " + dr2["LastName"].ToString();
                            birthdayLB.Text = DateTime.Parse(dr2["DOB"].ToString()).ToShortDateString();
                        }
                        dr2.Close();

                        /**
                         * Find default credit card
                         */
                        SqlCommand cmd3 = new SqlCommand("Select * from [GadgetFox].[dbo].[CCDetails] where EmailID=@EmailID", myConnection);
                        cmd3.Parameters.AddWithValue("@EmailID", Session["userID"].ToString());
                        SqlDataReader dr3 = cmd3.ExecuteReader();
                        if (dr3.Read())
                        {
                            // Only display last 4 digits
                            String ccType = dr3["CCType"].ToString();
                            String ccNum = dr3["CCNum"].ToString();
                            ccLB.Text = ccType + " ****" + ccNum.Substring(ccNum.Length - 4, 4);
                            ccExpDateLB.Text = dr3["ExpMonth"].ToString() + "/" + dr3["ExpYear"].ToString();
                        }
                        dr3.Close();

                        /**
                         * Find product orders
                         */
                        DataTable Table1 = new DataTable("MyOrders");
                        DataRow Row1 = Table1.NewRow();
                        SqlCommand cmd4 = new SqlCommand("select * from vw_CustomerOrders where EmailID=@EmailID", myConnection); //define SQL query
                        cmd4.Parameters.AddWithValue("@EmailID", Session["userID"]);

                        SqlDataReader dr4 = cmd4.ExecuteReader();

                        // Add colums for each field into the table
                        // EmailID, ProductID, Name, Price, SalePrice, InSale, ImageID, ImageData
                        DataColumn oid = new DataColumn("Order ID");
                        DataColumn status = new DataColumn("Status");
                        DataColumn purchaseDate = new DataColumn("Purchase Date");
                        DataColumn products = new DataColumn("Products");
                        DataColumn tracking = new DataColumn("Tracking #");
                        DataColumn total = new DataColumn("Total");

                        DataColumn actions = new DataColumn("#");

                        oid.DataType = System.Type.GetType("System.String");
                        status.DataType = System.Type.GetType("System.String");
                        purchaseDate.DataType = System.Type.GetType("System.String");
                        products.DataType = System.Type.GetType("System.String");
                        tracking.DataType = System.Type.GetType("System.String");
                        total.DataType = System.Type.GetType("System.String");

                        actions.DataType = System.Type.GetType("System.String");

                        Table1.Columns.Add(oid);
                        Table1.Columns.Add(status);
                        Table1.Columns.Add(purchaseDate);
                        Table1.Columns.Add(products);
                        Table1.Columns.Add(tracking);
                        Table1.Columns.Add(total);

                        Table1.Columns.Add(actions);

                        int orderId = -1;
                        System.Collections.Hashtable orders = new System.Collections.Hashtable();
                        while (dr4.Read())
                        {
                            orderId = int.Parse(dr4["OrderID"].ToString());

                            // Add row when a new order is encountered
                            if (!orders.ContainsKey(orderId))
                            {
                                orders[orderId] += dr4["Quantity"].ToString() + "x " + dr4["Name"].ToString() + ".  ";
                                Row1 = Table1.NewRow();
                                Table1.Rows.Add(Row1);

                                // Insert values into the row from the query
                                Row1["Order ID"] = dr4["OrderID"];
                                Row1["Status"] = dr4["Status"];
                                Row1["Purchase Date"] = DateTime.Parse(dr4["PurchaseDate"].ToString()).ToShortDateString();
                                Row1["Products"] = orders[orderId];
                                Row1["Tracking #"] = dr4["TrackingID"];
                                Row1["Total"] = "$" + string.Format("{0:$#,###.##}", dr4["OrderTotal"].ToString());

                                // Columns to purchase item
                                Row1["#"] = "";  // For cancel order
                            }
                            else
                            {
                                orders[orderId] += dr4["Quantity"].ToString() + "x " + dr4["Name"].ToString() + ".  ";
                                Row1["Products"] = orders[orderId];
                            }
                        }
                        // Add last order
                        dr4.Close();

                        GridView1.DataSource = Table1;
                        GridView1.DataBind();
                    }
                    catch (SqlException ex)
                    {
                        Response.Write("<SCRIPT LANGUAGE='JavaScript'>alert('" + ex.Message + "')</SCRIPT>");
                    }
                    finally
                    {
                        myConnection.Close();
                    }
                }
            }
        }
示例#42
0
        private static void updateMysql(StringBuilder str, Assembly assembly, Type baseEntityType)
        {
            foreach (Type entityType in assembly.GetTypes())
            {
                bool Table = true;
                if (entityType.GetCustomAttributes(typeof(EntityDefinitionAttribute), false).Length > 0)
                {
                    object obje = (EntityDefinitionAttribute)entityType.GetCustomAttributes(typeof(EntityDefinitionAttribute), false)[0];
                    Table = ((EntityDefinitionAttribute)obje).IsTable;
                }

                if (!entityType.IsClass
                    || !entityType.IsSubclassOf(baseEntityType)
                    || entityType.IsGenericType
                    || entityType.Name.Contains("<") || !Table) continue;

                PropertyInfo[] props =
                    PersistenceStrategyProvider.FindStrategyFor(entityType)
                    .GetPersistentProperties(entityType);

                object[] memberinfo=entityType.GetCustomAttributes(typeof(EntityDefinitionAttribute), true);

                string className = entityType.Name;
                if (TableExistMy(className, Transaction.Instance.GetSchema()))
                {
                    DataTable table = executeSql("select * from " + className + " where Id=-1");
                    DataTable metaTable = Transaction.Instance.MetaTableColumns(className);
                    Dictionary<string, int> metaLengths = new Dictionary<string, int>();
                    foreach (DataRow row in metaTable.Rows)
                    {
                        if ((string)row["DATA_TYPE"] != "varchar") continue;
                        metaLengths[(string)row["COLUMN_NAME"]] = Convert.ToInt32(row["CHARACTER_MAXIMUM_LENGTH"]);
                    }

                    System.Collections.Hashtable fieldDictionary = new System.Collections.Hashtable();
                    foreach (PropertyInfo property in props)
                    {
                        //Derviş Aygün
                        FieldDefinitionAttribute fielddefinition = ReflectionHelper.GetAttribute<FieldDefinitionAttribute>(property);
                        if (fielddefinition != null && fielddefinition.MappingType == FieldMappingType.No)
                            continue;
                        //Derviş aygün
                        FieldDefinitionAttribute definition = DataDictionary.Instance.GetFieldDefinition(className + "." + property.Name);
                        string fieldname = (property.PropertyType.IsSubclassOf(baseEntityType)) ?
                            definition.Name + "_Id" : definition.Name;

                        fieldDictionary[fieldname] = 1;
                        if (!table.Columns.Contains(fieldname))
                        {
                            string sql = "alter table " + className + " add " + fieldname + " " + MapTypeMysql(definition);
                            executeNonQuery(sql);
                            str.Append("New Field: " + fieldname + ", Table: " + className + "<br/>");
                        }
                        else if (!fieldname.EndsWith("_Id")
                            && definition.TypeName != "Boolean"
                            && table.Columns[fieldname].DataType.Name != definition.TypeName)
                        {
                            string sql = "alter table " + className + " modify column " + fieldname + " " + MapTypeMysql(definition);
                            executeNonQuery(sql);
                            str.Append("Alter Field: " + fieldname + ", Table: " + className + "<br/>");
                        }
                        else if (!fieldname.EndsWith("_Id")
                            && definition.TypeName == "Boolean"
                            && table.Columns[fieldname].DataType.Name != "SByte")
                        {
                            string sql = "alter table " + className + " modify column " + fieldname + " " + MapTypeMysql(definition);
                            executeNonQuery(sql);
                            str.Append("Alter Field: " + fieldname + ", Table: " + className + "<br/>");
                        }
                        else if (metaLengths.ContainsKey(fieldname)
                            && definition.Length != metaLengths[fieldname])
                        {
                            string sql = "alter table " + className + " modify column " + fieldname + " " + MapTypeMysql(definition);
                            executeNonQuery(sql);
                            str.Append("Resize Field: " + fieldname + ", Table: " + className + ", Length: " + definition.Length + "<br/>");
                        }
                    }
                    foreach (DataColumn column in table.Columns)
                    {
                        if (!fieldDictionary.ContainsKey(column.ColumnName))
                        {
                            string sql = "alter table " + className + " drop column " + column.ColumnName;
                            executeNonQuery(sql);
                            str.Append("Drop Field: " + column.ColumnName + ", Table: " + className + "<br/>");
                        }
                    }
                }
                else
                {
                    //Hiç özelliği olmayan class lar olabilir
                    if (props.Length == 0)
                    {
                        continue;
                    }

                    StringBuilder s = new System.Text.StringBuilder();
                    s.Append("CREATE TABLE " + className + " (");
                    string pkstr = "";
                    foreach (PropertyInfo property in props)
                    {
                        FieldDefinitionAttribute definition = DataDictionary.Instance.GetFieldDefinition(className + "." + property.Name);
                        string fieldname = (property.PropertyType.IsSubclassOf(baseEntityType)) ?
                            definition.Name + "_Id" : definition.Name;
                        s.Append("`" + fieldname + "` " + MapTypeMysql(definition));
                        if (definition.Name == "Id")
                        {
                            if (memberinfo != null && memberinfo.Length > 0)
                            {
                                EntityDefinitionAttribute attirebute = (EntityDefinitionAttribute)memberinfo[0];
                                if(attirebute.IdMethod==IdMethod.UserSubmitted)
                                    s.Append(" NOT NULL ");
                            }
                            else
                                s.Append(" NOT NULL AUTO_INCREMENT");

                            pkstr = " ,PRIMARY KEY (`Id`)";
                        }

                        s.Append(", ");
                    }
                    s.Remove(s.Length - 2, 2);
                    s.Append(pkstr);
                    s.Append(")");

                    string sql = s.ToString();
                    executeNonQuery(sql);
                    str.Append("New Table: " + className + "<br/>");
                }
            }
        }
示例#43
0
        private String partial1(String c)
        {
            System.Collections.Hashtable h = new System.Collections.Hashtable();
            h.Add(" ", "11011001100");
            h.Add("!", "11001101100");
            h.Add("\"", "11001100110");
            h.Add("#", "10010011000");
            h.Add("$", "10010001100");
            h.Add("%", "10001001100");
            h.Add("&", "10011001000");
            h.Add("'", "10011000100");
            h.Add("(", "10001100100");
            h.Add(")", "11001001000");
            h.Add("*", "11001000100");
            h.Add("+", "11000100100");
            h.Add(",", "10110011100");
            h.Add("-", "10011011100");
            h.Add(".", "10011001110");
            h.Add("/", "10111001100");
            h.Add("0", "10011101100");
            h.Add("1", "10011100110");
            h.Add("2", "11001110010");
            h.Add("3", "11001011100");
            h.Add("4", "11001001110");
            h.Add("5", "11011100100");
            h.Add("6", "11001110100");
            h.Add("7", "11101101110");
            h.Add("8", "11101001100");
            h.Add("9", "11100101100");
            h.Add(":", "11100100110");
            h.Add(";", "11101100100");
            h.Add("<", "11100110100");
            h.Add("=", "11100110010");
            h.Add(">", "11011011000");
            h.Add("?", "11011000110");
            h.Add("@", "11000110110");
            h.Add("A", "10100011000");
            h.Add("B", "10001011000");
            h.Add("C", "10001000110");
            h.Add("D", "10110001000");
            h.Add("E", "10001101000");
            h.Add("F", "10001100010");
            h.Add("G", "11010001000");
            h.Add("H", "11000101000");
            h.Add("I", "11000100010");
            h.Add("J", "10110111000");
            h.Add("K", "10110001110");
            h.Add("L", "10001101110");
            h.Add("M", "10111011000");
            h.Add("N", "10111000110");
            h.Add("O", "10001110110");
            h.Add("P", "11101110110");
            h.Add("Q", "11010001110");
            h.Add("R", "11000101110");
            h.Add("S", "11011101000");
            h.Add("T", "11011100010");
            h.Add("U", "11011101110");
            h.Add("V", "11101011000");
            h.Add("W", "11101000110");
            h.Add("X", "11100010110");
            h.Add("Y", "11101101000");
            h.Add("Z", "11101100010");
            h.Add("[", "11100011010");
            h.Add(@"\", "11101111010");
            h.Add("]", "11001000010");
            h.Add("^", "11110001010");
            h.Add("_", "10100110000");

            if (h.ContainsKey(c) == true)
            {
                return h[c].ToString();
            }
            return null;
        }
示例#44
0
 object dbCmd_GetReaderData(DataType type, object reader)
 {
     if (type == DataType.SysAlarmLog)
     {
         System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
         try
         {
             InsertCommand cmd = GetInsertCmd.setIIPEventCmd(dr);
             dbCmd.insert(cmd);
             //ServerMeg.setServerMeg("�[�J�@���۰ʩΥb�۰ʨƥ��tblIIPEvent");
             //if (InsertEvent != null)
             //{
             //    InsertEvent(cmd.RspID);
             //}
         }
         catch //(System.Exception ex)
         {
             //ServerMeg.setAlarmMeg("�[�J�@���۰ʩΥb�۰ʨƥ��tblIIPEvent���~!!");
             throw new Exception("�[�J�@���۰ʩΥb�۰ʨƥ��tblIIPEvent���~!!");
         }
     }
     else if (type == DataType.IIPEvent)
     {
         System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
         //if (InsertEvent != null)
         //{
         //    InsertEvent(dr[0].ToString());
         //}
     }
     else if (type == DataType.EventID)
     {
         System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
         return dr[0];
     }
     else if (type == DataType.Renew)
     {
         System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
         System.Collections.Hashtable ht = new System.Collections.Hashtable();
         for (int i = 0; i < dr.FieldCount; i++)
         {
             if (!ht.ContainsKey(dr.GetName(i))) ht.Add(dr.GetName(i), dr[i]);
         }
         return ht;
     }
     else if (type == DataType.AllMoveEvent)
     {
         System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
         return new MoveData(Convert.ToInt32(dr[39]), dr[16].ToString(), DateTime.Parse(dr[13].ToString()), dr[6].ToString(), dr[7].ToString(), Convert.ToInt32(dr[10]), Convert.ToInt32(dr[11]), dr[25].ToString());
     }
     return null;
 }
示例#45
0
        private void ApplyItems (object[] items)
        {
            view.BeginUpdate ();

            try
            {
                System.Collections.Hashtable oldItems = new System.Collections.Hashtable (items.Length);
                foreach (ListViewItem viewItem in view.Items)
                {
                    object key = GetKeyFromItem (viewItem.Tag);
                    oldItems[key] = viewItem;
                }

                foreach (object item in items)
                {
                    object key = GetKeyFromItem (item);

                    if (oldItems.ContainsKey (key))
                    {
                        ListViewItem viewItem = oldItems[key] as ListViewItem;
                        UpdateListViewItem (viewItem, item);
                        oldItems.Remove (key);
                    }
                    else
                    {
                        ListViewItem viewItem = new ListViewItem ();
                        UpdateListViewItem (viewItem, item);
                        view.Items.Add (viewItem);
                    }
                }

                foreach (ListViewItem item in oldItems.Values)
                    view.Items.Remove (item);

                view.Sort ();
            }
            finally
            {
                view.EndUpdate ();
            }
        }
示例#46
0
		/// <summary>
		/// Was orginally used to update the database with any changed values
		/// 
		/// Roadmap:
		///		1.  Create Variables to hold Splits that have actuall changed
		///			i.	SplitsToDrop		Contain splits that are in the allocation_provider table that have been 
		///									determined to be old/outdated/incorrect or need changed.
		///			ii.	SplitsToWrite		Contain the splits that need to be written to allocation_provider table
		///		2.	Grab all entries from allocation_provider
		///			i.	dt2_AllocTbl		a datatable of the split items as they exist in the allocation_provider table
		///			ii.	htCurrentRecord		a hashtable that is used to determine if the recorded data matches the data in this objects payment ledger items
		///									Also used to determine if entries exist that are no longer a part of opendental. (meaning they have been deleted)
		///		3.	Cycle through this.Payments compare to entries of allocation_provider
		///			i.		Add to SplitsToDrop and SplitsToWrite as appropriate
		///					a.  Checks split count to match
		///					b.	Checks provider count to match
		///					c.	Calcuates provider balances to match (for the split entries only)
		///					d.  If different drop and write (as indicated in 3.i. ) else leave alone
		///			ii.		Marke htCurrentRecord items as "used" if there is an ODEntry corresponding to the record.
		///		4.	Delete entries not used in htCurrentRecord (ie data that has been deleted from OpenDental)
		///			i.		makes use of the key values in htCurrentRecord
		///			ii.		key = [tablenum]-[tableitemnum]
		///		5.	Delete and add entries that are in the SplitsToDrop,SplitsToWrite lists
		/// 
		/// </summary>
		private bool Update2() {
			bool rVal_Successful = true;
			1.ToString(); // Just to break and inspect

			//PU.MB = "Method not implemented. Not Saving Provider Paysplit Data\n\n" + PU.Method;
			List<PP_PaymentItem> SplitsToDrop = new List<PP_PaymentItem>();  // Drop entries that will be needing updating
			List<PP_PaymentItem> SplitsToWrite = new List<PP_PaymentItem>(); // Write all newly allocated splits and any changed entries.

			///////////////////////////////////////////////////////////////////////////////
			//  Find all the payments in the split table currently
			///////////////////////////////////////////////////////////////////////////////
			string cmd2 = "SELECT PayTableSource, PaySourceNum, IsFullyAllocated, Amount, ProvNum FROM "
					+ MyAllocator1_ProviderPayment.TABLENAME
					+ "\nWHERE Guarantor = " + this.GUARANTOR_NUMBER;
			DataTable dt2_AllocTbl = Db.GetTableOld(cmd2);
			System.Collections.Hashtable htCurrentRecord = new System.Collections.Hashtable();
			for(int i = 0;i < dt2_AllocTbl.Rows.Count;i++) {
				// key = [tablesource as int]-[SourceNum]
				string key = dt2_AllocTbl.Rows[i][0].ToString() + "-" + dt2_AllocTbl.Rows[i][1].ToString();
				//if (key == "5-6160")
				//    1.ToString();
				if(!htCurrentRecord.ContainsKey(key))
					htCurrentRecord[key] = "notused";
			}
			// Roadmap -- Check to see if payment key matches pulled string.
			// See if splits are recorded
			// Add splits to SPlitsToWrite  
			// What will be the distinguishing factor between unrecorded and recorded.
			/// 1. Existence of TableSource-SourceNum.  If exists then it has been written.  If not then has not.
			/// 2. If Recorded ProvNum = 0 then split is considered unallocated. 
			/// 3. Need to check if any of the items in payment list have splits = 0;
			/// 
			/// Or
			/// Recreate Payment Items
			/// Check every one for differences.
			/// Write every one.
			/// 
			/// I think the final decision is
			/// 1. Write non existant entries
			/// 2. Only update entries that have provNum =0
			/// 3. Make the de-allocator delete the entries or update to ProvNum = 0;
			/// -- Equalizer is not supposed to change existing allocations.

			//	if (htCurrentRecord.Count != 0)
			for(int i = 0;i < this.Payments.Count;i++) {
				//	DataTable dtv1 = ViewLedgerObject(new LedgerItemTypes[] { LedgerItemTypes.Payment });
				//if (this.Payments[i].PROCNUM == 161218)
				//    1.ToString();
				string key = ((int)this.Payments[i].OD_TABLESOURCE).ToString() + "-" + this.Payments[i].PROCNUM;
				if(!htCurrentRecord.ContainsKey(key)) // if key does not exist then has not been written.
					{
					SplitsToWrite.Add(this.Payments[i]);
				}
				else {

					// Key does exist--meaning a record is recorded in the alloctable for this table and item num
					htCurrentRecord[key] = "used";
					// see if any of these records have provider = 0
					string subsetCondition = "PayTableSource="+ ((int)this.Payments[i].OD_TABLESOURCE).ToString()
							+ " AND PaySourceNum=" + this.Payments[i].PROCNUM.ToString();
					DataRow[] draSubSet = dt2_AllocTbl.Select(subsetCondition);
					// Find split that matches subset item
					// does subset have ProvNum = 0?
					// do we delete all subset entries =0 && AllocateAs in this.Payments?
					// What signifies difference
					//	1. Different number of split entries
					//	2. If some any of entries have different ProvNum, ItemNum, Amount
					// Draw back of this approach is that any payment that is partially allocated will
					//		be droped and reallocated.  Could make a difference.  But getting around this
					//		is another programing logical issue.
					//		Accept the compromise:  
					//	Another Question am I using the IsFullyAllocated Flag effectively?  Wouldn't ProvNum != 0 
					//		Mean the same thing?  Or ProvNum =0 give contion to find Flag.  Probably so but logically
					//		it seems to fit in the puzzle so I am leaving it for now.  Plus for the most part
					//		the Equailizer should equalize the payments equally for the most part.

					if(draSubSet.Length == Payments[i].PAYMENT_SPLITS.Count) //same number of splits
						{
						// check for matches.

						// Does Provider Count Match?
						List<int> ProvsInPayments = new List<int>();
						List<decimal> ProvsInPayments_Balances = new List<decimal>();
						List<int> ProvsInSubSet = new List<int>();
						List<decimal> ProvsInSubSet_Balances = new List<decimal>();
						// Find the Provider Balances in Payments[i] add to ProvsInPayments_Balances
						for(int j = 0;j < Payments[i].PAYMENT_SPLITS.Count;j++) {
							int Provider1 = Payments[i].PAYMENT_SPLITS[j].PROVNUM;
							if(ProvsInPayments.Contains(Provider1))
								ProvsInPayments_Balances[ProvsInPayments.IndexOf(Provider1)] += Payments[i].PAYMENT_SPLITS[j].AMMOUNT;
							else {
								ProvsInPayments.Add(Provider1);
								ProvsInPayments_Balances.Add(0);
								ProvsInPayments_Balances[ProvsInPayments.IndexOf(Provider1)] += Payments[i].PAYMENT_SPLITS[j].AMMOUNT;
							}
						}
						// Find the Provider Balances Recorde in table associated with single payment entry
						for(int k = 0;k < draSubSet.Length;k++) {
							int provider2 = (int)draSubSet[k][4];
							decimal amount = (decimal)draSubSet[k][3];
							if(ProvsInSubSet.Contains(provider2))
								ProvsInSubSet_Balances[ProvsInSubSet.IndexOf(provider2)] += amount;
							else {
								ProvsInSubSet.Add(provider2);
								ProvsInSubSet_Balances.Add(0);
								ProvsInSubSet_Balances[ProvsInSubSet.IndexOf(provider2)] += amount;
							}
						}
						// Determine if they are an exact match
						//    1. Split Count
						//	  2. Provider balances are the same
						bool ExactMatch = ProvsInPayments.Count == ProvsInSubSet.Count; // (don't add Payment to drop/write list)
						if(ExactMatch) {
							for(int k = 0;k < ProvsInPayments.Count;k++) {
								int providerInQuestion = ProvsInPayments[k];
								if(ProvsInSubSet.Contains(providerInQuestion) && ProvsInPayments.Contains(providerInQuestion))
									ExactMatch = ExactMatch && ProvsInPayments_Balances[ProvsInPayments.IndexOf(providerInQuestion)]
												== ProvsInSubSet_Balances[ProvsInSubSet.IndexOf(providerInQuestion)];
								else
									ExactMatch = false;
								if(!ExactMatch)
									k = ProvsInPayments.Count;
							}
						}
						if(!ExactMatch) {
							SplitsToDrop.Add(this.Payments[i]);
							SplitsToWrite.Add(this.Payments[i]);
						}
						// Note if it is an exact match then don't add the payment to the write list.  Just keep what 
						// is in the database.
					} // end if (draSubSet.Length == Payments[i].PAYMENT_SPLITS.Count)
					else // split length does not match
						{
						SplitsToDrop.Add(this.Payments[i]);
						SplitsToWrite.Add(this.Payments[i]);
					}
				}// end else
			}// end for (int i = 0; i < this.Payments.Count; i++)
			#region Delete Items in allocation_provider table that data doesn't exist for in opendental tables
			// Find all the unused items in htCurrentRecord.  These indicate that OD had no data for 
			// the items that were in the allocation provider table.

			List<string> keys2Delete = new List<string>();
			foreach(System.Collections.DictionaryEntry de in htCurrentRecord) {
				string key2 = de.Key.ToString();
				if(de.Value.ToString() == "notused")
					keys2Delete.Add(key2);
			}
			//for (int i = 0; i < htCurrentRecord.Keys.Count; i++)
			//{
			//    string key2 = htCurrentRecord[ htCurrentRecord.Keys.i]];
			//    if (htCurrentRecord[key2].ToString() == "notused")
			//        keys2Delete.Add(key2);
			//}
			try {
				if(keys2Delete.Count != 0) {
					string dropUnusedCommand = "DELETE FROM " + MyAllocator1_ProviderPayment.TABLENAME + " WHERE ";
					for(int i = 0;i < keys2Delete.Count;i++) {

						string[] splitme = keys2Delete[i].Split(new char[] { '-' });
						LedgerItemTypes TableSource = (LedgerItemTypes)Int32.Parse(splitme[0]);
						ulong SourceNum = ulong.Parse(splitme[1]);
						dropUnusedCommand += "( PayTableSource = " + TableSource + " AND "
									+ " PaySourceNum = " + SourceNum + ")";
						if(i < keys2Delete.Count - 1)
							dropUnusedCommand += "\nOR ";
					}
					Db.NonQOld(dropUnusedCommand);
				}
			}
			catch(Exception exc) {
				string s2 = exc.ToString();
			}
			#endregion

			//Write the subset lists to DataBase
			try {
				string cmd = "";
				// Do Required Drops First.  These are drops where the allocation has physically changed.
				if(SplitsToDrop.Count != 0) {
					cmd = "DELETE FROM " + MyAllocator1_ProviderPayment.TABLENAME + " WHERE \n";
					for(int i = 0;i < SplitsToDrop.Count;i++) {
						cmd += "( PayTableSource = " + ((int)SplitsToDrop[i].OD_TABLESOURCE).ToString() + " AND "
								+ " PaySourceNum = " + SplitsToDrop[i].PROCNUM + ")";
						if(i < SplitsToDrop.Count - 1)
							cmd += "\nOR ";
					}
					Db.NonQOld(cmd);
				}
				// Add Spilt to AllocationTable
				if(SplitsToWrite.Count != 0) {
					cmd = MyAllocator1_ProviderPayment.ValueStringHeader() + "\n";
					// Header
					//    (AllocType, Guarantor, ProvNum, "
					//+ "PayTableSource, PaySourceNum, AllocToTableSource, AllocToSourceNum, Amount, IsFullyAllocated)
					for(int i = 0;i < SplitsToWrite.Count;i++) {
						//if (SplitsToWrite[i].PROCNUM == 169218)
						//    1.ToString();
						for(int j = 0;j < SplitsToWrite[i].PAYMENT_SPLITS.Count;j++) {
							cmd += MyAllocator1_ProviderPayment.ValueString(
								MyAllocator1_ProviderPayment.AllocationTypeID,	// AllocType
								SplitsToWrite[i].GUARANTOR,						// Guarantor
								SplitsToWrite[i].PAYMENT_SPLITS[j].PROVNUM,		// ProvNum
								((int)SplitsToWrite[i].OD_TABLESOURCE),			// PayTableSource
								SplitsToWrite[i].PROCNUM,						// PaySourceNum
								((int)SplitsToWrite[i].PAYMENT_SPLITS[j].ALLOCATED_FROM_TABLE),  //AllocToTableSource
								SplitsToWrite[i].PAYMENT_SPLITS[j].ALLOCATED_FROM_NUM,			 //AllocToSourceNum
								SplitsToWrite[i].PAYMENT_SPLITS[j].AMMOUNT,						 //Amount
								SplitsToWrite[i].IS_ALLOCATED);									 //IsFullyAllocated	
							if(j < SplitsToWrite[i].PAYMENT_SPLITS.Count - 1)
								cmd += " , \n  ";
						}
						if(i < SplitsToWrite.Count - 1 && SplitsToWrite[i].PAYMENT_SPLITS.Count != 0)
							cmd += " , \n  ";
					}
					Db.NonQOld(cmd);
				}

			}
			catch(Exception exc) {
				PU.MB = "Error in ProviderAllocation\nMessage: " + exc.Message + "\nMethod: " + PU.Method;
				rVal_Successful = false;
			}
			return rVal_Successful;

		}
		/// <summary>
		/// Generates a Summary Table Outlining the Provider Charges and Revenues
		/// Illustrating Unearned Income
		/// use MinDate and MaxDate to flag all dates
		/// </summary>
		public static DataTable GenerateSummaryTable(int Guarantor,DateTime dtFrom, DateTime dtTo)
		{
			DataTable rValReturnTable = null;
			DataTable dtProviderBalance = Db.GetTableOld(ProviderRevenueByGuarantor(Guarantor,dtFrom,dtTo));
			DataTable dtProvAbbr = Db.GetTableOld("SELECT ProvNum, Abbr FROM Provider");
			if (dtProviderBalance != null && dtProviderBalance.Rows.Count != 0)
			{
				// Get Provider Abbreviations
				System.Collections.Hashtable htAllProvs = new System.Collections.Hashtable();
				for (int i = 0; i < dtProvAbbr.Rows.Count; i++)
					if (!htAllProvs.ContainsKey(dtProvAbbr.Rows[i][0].ToString()))
						htAllProvs[dtProvAbbr.Rows[i][0].ToString()] = dtProvAbbr.Rows[i][1].ToString();
				if (!htAllProvs.ContainsKey("0"))
					htAllProvs["0"] = "Unearned";
				// First establish a list of providers
				System.Collections.ArrayList alProvs = new System.Collections.ArrayList();
				for (int i = 0; i < dtProviderBalance.Rows.Count; i++)
					if (!alProvs.Contains(dtProviderBalance.Rows[i][0].ToString()))
						alProvs.Add(dtProviderBalance.Rows[i][0].ToString());

				// Fill and Create DataTable
				DataTable dtBalancesTable = new DataTable();
				dtBalancesTable.Columns.Add(new DataColumn("Provider", typeof(string)));
				dtBalancesTable.Columns.Add(new DataColumn("Charges", typeof(string)));
				dtBalancesTable.Columns.Add(new DataColumn("Adjustments", typeof(string)));
				dtBalancesTable.Columns.Add(new DataColumn("Revenue", typeof(string)));
				dtBalancesTable.Columns.Add(new DataColumn("Balance", typeof(string)));
				DataRow drWorkingRow = null;
				int ColumnIndex = -1;

				try
				{
					System.Collections.Hashtable htAllProvs_Indexes = new System.Collections.Hashtable();
					for (int i = 0; i < alProvs.Count; i++) // For Each Provider add a Row in the Balances Table
					{
						dtBalancesTable.Rows.Add(dtBalancesTable.NewRow());
						dtBalancesTable.Rows[i][0] = alProvs[i].ToString();
					}

					for (int i = 0; i < dtProviderBalance.Rows.Count; i++)
					{
						drWorkingRow = dtBalancesTable.Rows[alProvs.IndexOf(dtProviderBalance.Rows[i][0].ToString())];
						drWorkingRow[0] = htAllProvs[dtProviderBalance.Rows[i][0].ToString()].ToString(); // the abbreviation

						// Which Column of the Row to add the number to?  Find the column
						// stated in the query's column 2
						string ColumnName_FromQuery = dtProviderBalance.Rows[i][2].ToString();
						ColumnIndex = dtBalancesTable.Columns.IndexOf(ColumnName_FromQuery);
						if (ColumnIndex > 0)
							drWorkingRow[ColumnIndex] = dtProviderBalance.Rows[i][1].ToString(); // note is not cast as number so numeric specifies cannot apply //ToString("F2");
						else
							drWorkingRow[4] = "ERROR!";


						ColumnIndex = -1;
					}
					decimal[] Totals = new decimal[4];
					// Fill in Null and Empty Entries
					for (int j = 0; j < dtBalancesTable.Rows.Count; j++)
						for (int k = 1; k < dtBalancesTable.Columns.Count; k++)
						{
							if (dtBalancesTable.Rows[j][k] == null || dtBalancesTable.Rows[j][k].ToString().Trim() == "")
								dtBalancesTable.Rows[j][k] = "0.00";
							if (k == dtBalancesTable.Columns.Count - 1)
							{
								decimal Balance = decimal.Parse(dtBalancesTable.Rows[j][1].ToString())
								+ decimal.Parse(dtBalancesTable.Rows[j][2].ToString())
								+ decimal.Parse(dtBalancesTable.Rows[j][3].ToString());
								dtBalancesTable.Rows[j][4] = Balance.ToString("F2");
							}
							// Add to the Totals to be placed at the bottom of the Table
							Totals[k - 1] += decimal.Parse(dtBalancesTable.Rows[j][k].ToString());
							// Format the Numbers Better
							dtBalancesTable.Rows[j][k] = decimal.Parse(dtBalancesTable.Rows[j][k].ToString()).ToString("F2");
						}
					DataRow TotalRow = dtBalancesTable.NewRow();
					TotalRow[0] = "Totals-->";
					for (int i = 1; i < dtBalancesTable.Columns.Count; i++)
						TotalRow[i] = Totals[i - 1].ToString("F2");
					dtBalancesTable.Rows.Add(TotalRow);
				}
				catch
				{
				}
				rValReturnTable =  dtBalancesTable; // Set this first becuase SummaryTable_as_Strings() will check for _SummaryTable != null
			//	_SummaryTableHeader = SummaryTable_as_Strings();
			}
			return rValReturnTable;
		}
示例#48
0
        public static CashBackEntity ExportBalanceRoomHistory(CashBackEntity cashBackEntity)
        {
            OracleParameter[] parm ={
                                    new OracleParameter("HOTELID",OracleType.VarChar),
                                    new OracleParameter("ROOMCD",OracleType.VarChar),
                                    new OracleParameter("STARTDT",OracleType.VarChar),
                                    new OracleParameter("ENDDT",OracleType.VarChar)
                                };
            CashBackDBEntity dbParm = (cashBackEntity.CashBackDBEntity.Count > 0) ? cashBackEntity.CashBackDBEntity[0] : new CashBackDBEntity();
            parm[0].Value = dbParm.HotelID;

            if (String.IsNullOrEmpty(dbParm.HRoomList))
            {
                parm[1].Value = DBNull.Value;
            }
            else
            {
                parm[1].Value = dbParm.HRoomList;
            }

            if (String.IsNullOrEmpty(dbParm.InDateFrom))
            {
                parm[2].Value = DBNull.Value;
            }
            else
            {
                parm[2].Value = dbParm.InDateFrom;
            }

            if (String.IsNullOrEmpty(dbParm.InDateTo))
            {
                parm[3].Value = DBNull.Value;
            }
            else
            {
                parm[3].Value = dbParm.InDateTo;
            }

            DataSet dsResult = new DataSet();
            DataSet dsRoomList = HotelVp.Common.DBUtility.DbManager.Query("CashBack", "t_lm_b_balancerom_roomlist", true, parm);
            DataSet dsDataList = HotelVp.Common.DBUtility.DbManager.Query("CashBack", "t_lm_b_balancerom_select", true, parm);

            System.Collections.Hashtable htRoomNm = new System.Collections.Hashtable();
            dsResult.Tables.Add(new DataTable());
            dsResult.Tables[0].Columns.Add("EFFECTDT");
            foreach (DataRow drCol in dsRoomList.Tables[0].Rows)
            {
                dsResult.Tables[0].Columns.Add(drCol["rate_code"].ToString().ToUpper() + "-" + drCol["room_type_code"].ToString().ToUpper());

                if (!htRoomNm.ContainsKey(drCol["rate_code"].ToString().ToUpper() + "-" + drCol["room_type_code"].ToString().ToUpper()))
                {
                    htRoomNm.Add(drCol["rate_code"].ToString().ToUpper() + "-" + drCol["room_type_code"].ToString().ToUpper(), GetColsNameByRoomTypeCode(dbParm.HotelID, drCol["room_type_code"].ToString()));
                }
            }

            string strDate = string.Empty;
            foreach (DataRow drVal in dsDataList.Tables[0].Rows)
            {
                if (!strDate.Equals(drVal["EFFECTDATE"].ToString()))
                {
                    strDate = drVal["EFFECTDATE"].ToString();
                    DataRow[] drList = dsDataList.Tables[0].Select("EFFECTDATE='" + strDate + "'");

                    if (drList.Count() == 0)
                    {
                        continue;
                    }

                    DataRow drRow = dsResult.Tables[0].NewRow();
                    drRow["EFFECTDT"] = strDate;
                    string strColNM = string.Empty;
                    foreach (DataRow drTemp in drList)
                    {
                        strColNM = drTemp["rate_code"].ToString().ToUpper() + "-" + drTemp["room_type_code"].ToString().ToUpper();
                        drRow[strColNM] = ("42".Equals(drTemp["commision_mode"].ToString())) ? drTemp["commision"].ToString() + "%" : drTemp["commision"].ToString() + "元";
                    }
                    dsResult.Tables[0].Rows.Add(drRow);
                }
            }

            dsResult.Tables[0].Columns["EFFECTDT"].ColumnName = "日期/房型";

            for (int i = 1; i < dsResult.Tables[0].Columns.Count; i++)
            {
                dsResult.Tables[0].Columns[i].ColumnName = dsResult.Tables[0].Columns[i].ColumnName.Substring(0, dsResult.Tables[0].Columns[i].ColumnName.IndexOf('-') + 1) + htRoomNm[dsResult.Tables[0].Columns[i].ColumnName].ToString();
            }

            cashBackEntity.QueryResult = dsResult;
            return cashBackEntity;
        }
		/// <summary>
		/// This expects that the last column will be Amount.  If not It will do nothing.
		/// RunDetialReport(Guarantor) query first.  // Adds Provider's abbreviations to Table as well
		/// 
		/// Adds a column to report.TableQ
		/// </summary>
		private static void AddColBalance(ReportSimpleGrid report) //to report.TableQ
		{
			if (report.TableQ != null && report.TableQ.Columns.Count == 10)
				if (report.TableQ.Columns[8].ColumnName == "Amount")
				{

					decimal RunningBalance = 0;
					// Find Provider Abbreviations
					System.Collections.Hashtable htProvs = new System.Collections.Hashtable();
					try
					{
						DataTable dt = Db.GetTableOld("SELECT ProvNum, Abbr FROM Provider");

						if (dt.Rows.Count != 0)
							foreach (DataRow dr in dt.Rows)
								if (!htProvs.ContainsKey(dr[0].ToString()))
									htProvs[dr[0].ToString()] = dr[1].ToString();
						if (!htProvs.ContainsKey("0"))
							htProvs["0"] = "UnEarned";

					}
					catch
					{
					}

					for (int i = 0; i < report.TableQ.Rows.Count; i++)
					{
						try
						{

							decimal amount = 0;
							try
							{
								amount = decimal.Parse(report.TableQ.Rows[i][8].ToString());
							}
							catch { }

							RunningBalance += amount;

							if (amount > 0)
							{
								report.TableQ.Rows[i][5] = amount.ToString("F2");
								report.TableQ.Rows[i][6] = "";
							}
							else
							{
								report.TableQ.Rows[i][5] = "";
								report.TableQ.Rows[i][6] = amount.ToString("F2");
							}
							report.TableQ.Rows[i][7] = RunningBalance.ToString("F2");
							// Fix Provider Column From # to Abreviation,  Need to do it here
							// because Prov# = 0 is undefined
							if (htProvs.Count != 0)
								if (htProvs.ContainsKey(report.TableQ.Rows[i][9].ToString()))
									report.TableQ.Rows[i][4] = htProvs[report.TableQ.Rows[i][9].ToString()].ToString();
							// Change Column 0 Date Display if Date on previous row has been displayed
							if (i > 0)
								if (report.TableQ.Rows[i][0].ToString() == report.TableQ.Rows[i - 1][0].ToString())
									report.TableQ.Rows[i][0] = ""; // makes Dates more readable if not redundant.
						}
						catch
						{
							report.TableQ.Rows[i][7] = "ERROR";
						}
					}


					report.TableQ.Columns.RemoveAt(8);// Remove Amount
					report.TableQ.Columns.RemoveAt(8); // Remove ProvNums
					DataRow dr2 = report.TableQ.NewRow();
					report.TableQ.Rows.Add(dr2); // add blank row
					dr2 = report.TableQ.NewRow();
					dr2[6] = "Total";
					dr2[7] = RunningBalance.ToString("F");
					report.TableQ.Rows.Add(dr2);
				}

		}
    private void RecalculateParameterSet()
    {
      // save old values
      System.Collections.Hashtable byName = new System.Collections.Hashtable();
      for(int i=0;i<_currentParameters.Count;i++)
        byName.Add(_currentParameters[i].Name,_currentParameters[i]);

      // now restore the values
      _currentParameters.Clear();

      for(int i=0;i<_fitEnsemble.NumberOfParameters;i++)
      {
        string name = _fitEnsemble.ParameterName(i);
        if(byName.ContainsKey(name))
          _currentParameters.Add((ParameterSetElement)byName[name]);
        else
          _currentParameters.Add(new ParameterSetElement(name));

      }

      _currentParameters.OnInitializationFinished();
    }
示例#51
0
    // Static void method with same signature as "Main" is always
    // file base name:
    //
    /// <summary>
    /// VTK test Main method
    /// </summary>
    public static void vtkObjectTest(string[] args)
    {
        // Reference a method in the Kitware.VTK assembly:
        //   (forces the Kitware.VTK assembly to load...)
        //
        string version = Kitware.VTK.vtkVersion.GetVTKSourceVersion();

        string assemblyname = "Kitware.VTK";
        bool listAllAssemblies = false;
        bool listAllClasses = false;
        bool collectingClassNames = false;
        System.Collections.Hashtable classnames =
          new System.Collections.Hashtable();
        System.Collections.Hashtable classtypes =
          new System.Collections.Hashtable();

        for (int i = 0; i < args.Length; ++i)
          {
          string s = args[i];

          if (s == "--assemblyname")
        {
        collectingClassNames = false;

        if (i < args.Length - 1)
          {
          assemblyname = args[i + 1];
          }
        else
          {
          throw new System.Exception("--assemblyname used, but no name given");
          }
        }
          else if (s == "--classname")
        {
        collectingClassNames = false;

        if (i < args.Length - 1)
          {
          classnames.Add(args[i + 1], args[i + 1]);
          }
        else
          {
          throw new System.Exception("--classname used, but no name given");
          }
        }
          else if (s == "--classnames")
        {
        collectingClassNames = true;
        }
          else if (s == "--classnames-file")
        {
        if (i < args.Length - 1)
          {
          ReadClassNamesFromFile(classnames, args[i + 1]);
          }
        else
          {
          throw new System.Exception("--classnames-file used, but no filename given");
          }
        }
          else if (s == "--list-all-classes")
        {
        collectingClassNames = false;
        listAllClasses = true;
        }
          else if (s == "--list-all-assemblies")
        {
        collectingClassNames = false;
        listAllAssemblies = true;
        }
          else if (collectingClassNames)
        {
        classnames.Add(s, s);
        }
          }

        if (0 == classnames.Count)
          {
          classnames.Add("vtkObject", "vtkObject");
          }

        // Find the assembly containing the class to instantiate:
        //
        System.Reflection.Assembly[] assemblies =
          System.AppDomain.CurrentDomain.GetAssemblies();
        System.Reflection.Assembly assembly = null;

        foreach (System.Reflection.Assembly a in assemblies)
          {
          System.Reflection.AssemblyName aname = a.GetName();

          if (aname.FullName == assemblyname || aname.Name == assemblyname)
        {
        assembly = a;
        }

          if (listAllAssemblies)
        {
        //System.Console.Error.WriteLine(aname.Name);
        System.Console.Error.WriteLine(aname.FullName);
        }
          }
        if (listAllAssemblies)
          {
          return;
          }

        // Find the type of the class to instantiate:
        //
        if (assembly != null)
          {
          foreach (System.Type et in assembly.GetExportedTypes())
        {
        if (listAllClasses)
          {
          System.Console.Error.WriteLine(et.Name);
          System.Console.Error.WriteLine(et.AssemblyQualifiedName);
          }

        if (classnames.ContainsKey(et.Name))
          {
          classtypes.Add(et.Name, et);
          }
        if (classnames.ContainsKey(et.AssemblyQualifiedName))
          {
          classtypes.Add(et.AssemblyQualifiedName, et);
          }
        }
          if (listAllClasses)
        {
        return;
        }
          }

        if (0 == classtypes.Count)
          {
          throw new System.ArgumentException(System.String.Format(
        "error: did not find any Type objects... Typo in command line args?"));
          }

        // Instantiate and print each type:
        //
        string classname = "";
        System.Type classtype = null;

        System.Console.Error.WriteLine("");
        System.Console.Error.WriteLine("CTEST_FULL_OUTPUT (Avoid ctest truncation of output)");
        System.Console.Error.WriteLine("");
        System.Console.Error.WriteLine(System.String.Format("classtypes.Count: {0}", classtypes.Count));
        System.Console.Error.WriteLine("");
        System.Console.Error.WriteLine(System.String.Format("GetVTKSourceVersion(): '{0}'", version));
        System.Console.Error.WriteLine("");

        foreach (System.Collections.DictionaryEntry entry in classtypes)
          {
          classname = (string) entry.Key;
          classtype = (System.Type) entry.Value;

          // Instantiate via "New" method:
          //
          System.Console.Error.WriteLine("");
          System.Console.Error.WriteLine(
        "==============================================================================");
          System.Console.Error.WriteLine(System.String.Format(
        "Instantiating and printing class '{0}'", classname));
          System.Console.Error.WriteLine("");

          // Look for a New method that takes no parameters:
          //
          System.Reflection.MethodInfo mi = classtype.GetMethod("New", System.Type.EmptyTypes);
          if (null == mi)
        {
        if (classtype.IsAbstract)
          {
          System.Console.Error.WriteLine(System.String.Format(
            "No 'New' method in abstract class '{0}'. Test passes without instantiating or printing an object.",
            classname));
          }
        else
          {
          System.Console.Error.WriteLine(System.String.Format(
            "No 'New' method in concrete class '{0}'. Test passes without instantiating or printing an object.",
            classname));
          //throw new System.ArgumentException(System.String.Format(
          //  "error: could not find 'New' method for concrete class '{0}'",
          //  classname));
          }
        }

          if (null != mi)
        {
        // Assumption: any object we create via a 'New' method will implement
        // the 'IDisposable' interface...
        //
        // 'using' forces an 'o.Dispose' call at the closing curly brace:
        //
        using (System.IDisposable o = (System.IDisposable) mi.Invoke(null, null))
          {
          System.Console.Error.WriteLine(o.ToString());
          }
        }

          System.Console.Error.WriteLine("");

          // Instantiate via public default constructor:
          //
          //System.Type [] ca = new System.Type[0];
          //System.Reflection.ConstructorInfo ci = classtype.GetConstructor(ca);
          //if (null == ci)
          //  {
          //  throw new System.ArgumentException(System.String.Format(
          //    "error: could not find public default constructor for '{0}'",
          //    classname));
          //  }
          //
          //o = ci.Invoke(null);
          //System.Console.Error.WriteLine(o.ToString());
          }
    }
示例#52
0
        object dbCmd_GetReaderData(DataType type, object reader)
        {
            if (type == DataType.SysAlarmLog)
            {
                System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
                try
                {
                    int GpsX =0, GpsY=0;
                    try
                    {
                        if ((int)dr[2] == 49)
                        {
                            getInterchangePoint((string)dr[9], ((string)dr[10])[0].ToString(), (int)dr[7], ref GpsX, ref GpsY);
                        }
                        else
                        {
                            GetNearDevice((string)dr[9], (int)dr[7], ref GpsX, ref GpsY);
                        }
                    }
                    catch
                    {
                        ;
                    }

                    InsertCommand cmd = GetInsertCmd.setIIPEventCmd(dr,GpsX,GpsY);
                    dbCmd.insert(cmd);
                    //ServerMeg.setServerMeg("�[�J�@���۰ʩΥb�۰ʨƥ��tblIIPEvent");
                    //if (InsertEvent != null)
                    //{
                    //    InsertEvent(cmd.RspID);
                    //}
                }
                catch (System.Exception ex)
                {
                    //���X�ҥ~�|�ɭP�Ѯv�}���ɱҰ�CMS�����p�e���~
                    //ServerMeg.setAlarmMeg("�[�J�@���۰ʩΥb�۰ʨƥ��tblIIPEvent���~!!");
                    //throw new Exception("�[�J�@���۰ʩΥb�۰ʨƥ��tblIIPEvent���~!!"  + "EventID=" + dr[18].ToString() + ",alarmclass" + dr[2].ToString()
                    //    + "\r\n" + ex.Message);
                }
            }
            else if (type == DataType.IIPEvent)
            {
                System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
                //if (InsertEvent != null)
                //{
                //    InsertEvent(dr[0].ToString());
                //}
            }
            else if (type == DataType.EventID)
            {
                System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
                return dr[0];
            }
            else if (type == DataType.Renew)
            {
                System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
                System.Collections.Hashtable ht = new System.Collections.Hashtable();
                for (int i = 0; i < dr.FieldCount; i++)
                {
                    if (!ht.ContainsKey(dr.GetName(i))) ht.Add(dr.GetName(i), dr[i]);
                }
                return ht;
            }
            else if (type == DataType.AllMoveEvent)
            {
                System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
                return new MoveData(Convert.ToInt32(dr[39]), dr[16].ToString(), DateTime.Parse(dr[13].ToString()), dr[6].ToString(), dr[7].ToString(), Convert.ToInt32(dr[10]), Convert.ToInt32(dr[11]), dr[25].ToString());
            }
            return null;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["userID"] == null)
            {
                // Redirect user to login before doing anything else
                Response.Redirect("~/Login.aspx?redirect=Orders.aspx");
            }
            else if (Session["userID"] != null && Session["userRole"].Equals("1"))
            {
                // Redirect user to login before doing anything else
                Response.Redirect("~/Home.aspx");
            }

            // Connection setup
            String myConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
            SqlConnection myConnection = new SqlConnection(myConnectionString);

            // Try to connect
            try
            {
                String criteria = Request.QueryString["criteria"];

                DataTable Table1 = new DataTable("MyOrders");
                DataRow Row1 = Table1.NewRow();

                SqlCommand cmd = new SqlCommand();
                cmd.Connection = myConnection;

                if (criteria == null)
                {
                    cmd = new SqlCommand("select * from vw_CustomerOrders", myConnection); // Define SQL query
                }
                else
                {
                    cmd = new SqlCommand("select * from vw_CustomerOrders where OrderID='" + criteria + "' or EmailID='" + criteria + "'", myConnection); // Define SQL query
                }

                myConnection.Open();
                SqlDataReader dr = cmd.ExecuteReader(); // Perform SQL query and store it

                // Add colums for each field into the table
                // EmailID, ProductID, Name, Price, SalePrice, InSale, ImageID, ImageData
                DataColumn oid = new DataColumn("Order ID");
                DataColumn emailId = new DataColumn("Email ID");
                DataColumn status = new DataColumn("Status");
                DataColumn purchaseDate = new DataColumn("Purchase Date");
                DataColumn products = new DataColumn("Products");
                DataColumn total = new DataColumn("Total");
                DataColumn tracking = new DataColumn("Tracking #");

                DataColumn actions = new DataColumn("#");

                oid.DataType = System.Type.GetType("System.String");
                emailId.DataType = System.Type.GetType("System.String");
                status.DataType = System.Type.GetType("System.String");
                purchaseDate.DataType = System.Type.GetType("System.String");
                products.DataType = System.Type.GetType("System.String");
                total.DataType = System.Type.GetType("System.String");
                tracking.DataType = System.Type.GetType("System.String");

                actions.DataType = System.Type.GetType("System.String");

                Table1.Columns.Add(oid);
                Table1.Columns.Add(emailId);
                Table1.Columns.Add(status);
                Table1.Columns.Add(purchaseDate);
                Table1.Columns.Add(products);
                Table1.Columns.Add(total);
                Table1.Columns.Add(tracking);

                Table1.Columns.Add(actions);

                int orderId = -1;
                System.Collections.Hashtable orders = new System.Collections.Hashtable();
                Double orderTotal = 0.00;
                while (dr.Read())
                {
                    orderId = int.Parse(dr["OrderID"].ToString());

                    // Add row when a new order is encountered
                    if (!orders.ContainsKey(orderId))
                    {
                        orders[orderId] += dr["Quantity"].ToString() + "x " + dr["Name"].ToString() + ".  ";
                        Row1 = Table1.NewRow();
                        Table1.Rows.Add(Row1);

                        // Insert values into the row from the query
                        Row1["Order ID"] = dr["OrderID"];
                        Row1["Email ID"] = dr["EmailID"];
                        Row1["Status"] = dr["Status"];
                        Row1["Purchase Date"] = DateTime.Parse(dr["PurchaseDate"].ToString()).ToShortDateString();
                        Row1["Products"] = orders[orderId];

                        orderTotal = Double.Parse(dr["OrderTotal"].ToString()) + Double.Parse(dr["TaxAmount"].ToString()) + Double.Parse(dr["ShipAmount"].ToString());
                        Row1["Total"] = string.Format("{0:$#,###.##}", orderTotal);
                        Row1["Tracking #"] = dr["TrackingID"];

                        // Columns to purchase item
                        Row1["#"] = "";  // For cancel order
                    }
                    else
                    {
                        orders[orderId] += dr["Quantity"].ToString() + "x " + dr["Name"].ToString() + ".  ";
                        Row1["Products"] = orders[orderId];
                    }
                }
                // Add last order
                dr.Close();

                GridView1.DataSource = Table1;
                GridView1.DataBind();
            }
            catch (SqlException ex)
            {
                Response.Write("<SCRIPT LANGUAGE='JavaScript'>alert('" + ex.Message + "')</SCRIPT>");
            }
            finally
            {
                myConnection.Close();
            }
        }
		internal static System.Collections.ICollection GetFieldNames(IndexReader.FieldOption fieldNames, IndexReader[] subReaders)
		{
			// maintain a unique set of field names
			System.Collections.Hashtable fieldSet = new System.Collections.Hashtable();
			for (int i = 0; i < subReaders.Length; i++)
			{
				IndexReader reader = subReaders[i];
                System.Collections.IEnumerator names = reader.GetFieldNames(fieldNames).GetEnumerator();
                while (names.MoveNext())
				{
					if (!fieldSet.ContainsKey(names.Current))
						fieldSet.Add(names.Current, names.Current);
				}
			}
			return fieldSet.Keys;
		}
示例#55
0
		public override System.Collections.ICollection GetIndexedFieldNames(Field.TermVector tvSpec)
		{
			System.Collections.Hashtable fieldSet = new System.Collections.Hashtable();
			for (int i = 0; i < readers.Count; i++)
			{
				IndexReader reader = ((IndexReader) readers[i]);
				System.Collections.ICollection names = reader.GetIndexedFieldNames(tvSpec);
                for (System.Collections.IEnumerator iterator = names.GetEnumerator(); iterator.MoveNext(); )
                {
                    System.Collections.DictionaryEntry fi = (System.Collections.DictionaryEntry) iterator.Current;
                    System.String s = fi.Key.ToString();
                    if (fieldSet.ContainsKey(s) == false)
                    {
                        fieldSet.Add(s, s);
                    }
                }
            }
			return fieldSet;
		}
示例#56
0
		/// <summary> Walk the file list looking for name collisions.
		/// If we find one, then we remove it
		/// </summary>
		internal virtual System.Collections.ArrayList trimFileList(System.Collections.ArrayList files)
		{
			System.Collections.Hashtable names = new System.Collections.Hashtable();
			System.Collections.ArrayList list = new System.Collections.ArrayList();
			
			int size = files.Count;
			for (int i = 0; i < size; i++)
			{
				bool addIt = false;
				
				SourceFile fi = (SourceFile) files[i];
				// no filter currently in place so we add the file as long
				// as no duplicates exist.  We use the original Swd full
				// name for matching.
				String fName = fi.RawName;
				if (m_swfFilter == null)
				{
					// If it exists, then we don't add it!
					if (!names.ContainsKey(fName))
						addIt = true;
				}
				else
				{
					// we have a filter in place so, see
					// if the source file is in our currently
					// selected swf.
					addIt = m_swfFilter.containsSource(fi);
				}
				
				// did we mark this one to add?
				if (addIt)
				{
					names[fName] = fName;
					list.Add(fi);
				}
			}
			return list;
		}
示例#57
0
		/// <seealso cref="IndexReader#GetFieldNames(IndexReader.FieldOption)">
		/// </seealso>
		public override System.Collections.ICollection GetFieldNames(IndexReader.FieldOption fieldNames)
		{
			// maintain a unique set of field names
			System.Collections.Hashtable fieldSet = new System.Collections.Hashtable();
			for (int i = 0; i < subReaders.Length; i++)
			{
				IndexReader reader = subReaders[i];
				System.Collections.ICollection names = reader.GetFieldNames(fieldNames);
                for (System.Collections.IEnumerator iterator = names.GetEnumerator(); iterator.MoveNext(); )
                {
                    System.Collections.DictionaryEntry fi = (System.Collections.DictionaryEntry) iterator.Current;
                    System.String s = fi.Key.ToString();
                    if (fieldSet.ContainsKey(s) == false)
                    {
                        fieldSet.Add(s, s);
                    }
                }
            }
			return fieldSet;
		}
示例#58
0
        private static void updateMs(StringBuilder str, Assembly assembly, Type baseEntityType)
        {
            foreach (Type entityType in assembly.GetTypes())
            {

                bool Table = true;
                if (entityType.GetCustomAttributes(typeof(EntityDefinitionAttribute), false).Length > 0)
                {
                    object obje = (EntityDefinitionAttribute)entityType.GetCustomAttributes(typeof(EntityDefinitionAttribute), false)[0];
                    Table = ((EntityDefinitionAttribute)obje).IsTable;
                }

                if (!entityType.IsClass
                    || !entityType.IsSubclassOf(baseEntityType)
                    || entityType.IsGenericType
                    || entityType.Name.Contains("<")  || !Table) continue;

                PropertyInfo[] props =
                    PersistenceStrategyProvider.FindStrategyFor(entityType)
                    .GetPersistentProperties(entityType);
                object[] memberinfo = entityType.GetCustomAttributes(typeof(EntityDefinitionAttribute), true);

                string className = entityType.Name;
                if (Configuration.GetValue("DbType")!= "System.Data.Sqlite"&&TableExistMs(className))
                {
                    DataTable table = executeSql("select * from " + className + " where Id=-1");

                    System.Collections.Hashtable fieldDictionary = new System.Collections.Hashtable();
                    foreach (PropertyInfo property in props)
                    {
                        //Derviş Aygün
                        FieldDefinitionAttribute fielddefinition = ReflectionHelper.GetAttribute<FieldDefinitionAttribute>(property);
                        if (fielddefinition != null && fielddefinition.MappingType == FieldMappingType.No)
                            continue;
                        //Derviş Aygün

                        FieldDefinitionAttribute definition = DataDictionary.Instance.GetFieldDefinition(className + "." + property.Name);
                        string fieldname = (property.PropertyType.IsSubclassOf(baseEntityType)) ?
                            definition.Name + "_Id" : definition.Name;

                        fieldDictionary[fieldname] = 1;
                        if (!table.Columns.Contains(fieldname))
                        {
                            string sql = "alter table " + className + " add " + fieldname + " " + MapType(definition);
                            executeNonQuery(sql);
                            str.Append("New Field: " + fieldname + ", Table: " + className + "<br/>");
                        }
                        else if (!fieldname.EndsWith("_Id") && table.Columns[fieldname].DataType.Name != definition.TypeName)
                        {
                            string sql = "alter table " + className + " alter column " + fieldname + " " + MapType(definition);
                            executeNonQuery(sql);
                            str.Append("Alter Field: " + fieldname + ", Table: " + className + "<br/>");
                        }
                    }
                    foreach (DataColumn column in table.Columns)
                    {
                        if (!fieldDictionary.ContainsKey(column.ColumnName))
                        {
                            string sql = "alter table " + className + " drop column " + column.ColumnName;
                            executeNonQuery(sql);
                            str.Append("Drop Field: " + column.ColumnName + ", Table: " + className + "<br/>");
                        }
                    }
                }
                else
                {
                    //Hiç özelliği olmayan class lar olabilir
                    if (props.Length == 0)
                    {
                        continue;
                    }

                    StringBuilder s = new System.Text.StringBuilder();
                    s.Append("CREATE TABLE " + className + " (");
                    foreach (PropertyInfo property in props)
                    {
                        FieldDefinitionAttribute definition = DataDictionary.Instance.GetFieldDefinition(className + "." + property.Name);
                        string fieldname = (property.PropertyType.IsSubclassOf(baseEntityType)) ?
                            definition.Name + "_Id" : definition.Name;
                        s.Append(fieldname + " " + MapType(definition));
                        if (definition.Name == "Id")
                        {
                            if (memberinfo != null && memberinfo.Length > 0)
                            {
                                EntityDefinitionAttribute attirebute = (EntityDefinitionAttribute)memberinfo[0];
                                if (attirebute.IdMethod == IdMethod.UserSubmitted)
                                    if (Configuration.GetValue("DbType")!= "System.Data.Sqlite")
                                        s.Append("  CONSTRAINT PK_" + className + "_Id PRIMARY KEY CLUSTERED");
                                    else
                                        s.Append("  PRIMARY KEY");
                            }
                            else
                                s.Append(" IDENTITY(1,1) CONSTRAINT PK_" + className + "_Id PRIMARY KEY CLUSTERED");
                        }
                        s.Append(", ");
                    }
                    s.Remove(s.Length - 2, 2);
                    s.Append(")");

                    string sql = s.ToString();
                    executeNonQuery(sql);
                    str.Append("New Table: " + className + "<br/>");
                }

                System.Collections.Hashtable fields = new System.Collections.Hashtable();
                Dictionary<string, List<string>> uniqueGroup = new Dictionary<string, List<string>>();
                Dictionary<string, List<string>> nonUniqueGroup = new Dictionary<string, List<string>>();
                foreach (PropertyInfo property in props)
                {
                    FieldDefinitionAttribute definition = DataDictionary.Instance.GetFieldDefinition(className + "." + property.Name);
                    string fieldname = (property.PropertyType.IsSubclassOf(baseEntityType)) ?
                        definition.Name + "_Id" : definition.Name;

                    if (!string.IsNullOrEmpty(definition.UniqueIndexGroup))
                    {
                        if (!uniqueGroup.ContainsKey(definition.UniqueIndexGroup))
                            uniqueGroup[definition.UniqueIndexGroup] = new List<string>();

                        uniqueGroup[definition.UniqueIndexGroup].Add(fieldname);
                    }
                    if (!string.IsNullOrEmpty(definition.NonUniqueIndexGroup))
                    {
                        if (!nonUniqueGroup.ContainsKey(definition.NonUniqueIndexGroup))
                            nonUniqueGroup[definition.NonUniqueIndexGroup] = new List<string>();

                        nonUniqueGroup[definition.NonUniqueIndexGroup].Add(fieldname);
                    }
                }
                foreach (string indexGroup in uniqueGroup.Keys)
                {
                    executeNonQuery(CreateIndex(className, true, indexGroup, uniqueGroup[indexGroup]));
                }
                foreach (string indexGroup in nonUniqueGroup.Keys)
                {
                    executeNonQuery(CreateIndex(className, false, indexGroup, nonUniqueGroup[indexGroup]));
                }
            }
        }
示例#59
0
        /// <summary>
        /// Emulates the behavior of a SAX parser, it realizes the callback events of the parser.
        /// </summary>
        private void DoParsing()
        {
            System.Collections.Hashtable prefixes = new System.Collections.Hashtable();
            System.Collections.Stack stackNameSpace = new System.Collections.Stack();
            locator = new XmlSaxLocatorImpl();
            try
            {
                UpdateLocatorData(this.locator, (System.Xml.XmlTextReader)(this.reader));
                if (this.callBackHandler != null)
                    this.callBackHandler.setDocumentLocator(locator);
                if (this.callBackHandler != null)
                    this.callBackHandler.startDocument();
                while (this.reader.Read())
                {
                    UpdateLocatorData(this.locator, (System.Xml.XmlTextReader)(this.reader));
                    switch (this.reader.NodeType)
                    {
                        case System.Xml.XmlNodeType.Element:
                            bool Empty = reader.IsEmptyElement;
                            System.String namespaceURI = "";
                            System.String localName = "";
                            if (this.namespaceAllowed)
                            {
                                namespaceURI = reader.NamespaceURI;
                                localName = reader.LocalName;
                            }
                            System.String name = reader.Name;
                            SaxAttributesSupport attributes = new SaxAttributesSupport();
                            if (reader.HasAttributes)
                            {
                                for (int i = 0; i < reader.AttributeCount; i++)
                                {
                                    reader.MoveToAttribute(i);
                                    System.String prefixName = (reader.Name.IndexOf(":") > 0) ? reader.Name.Substring(reader.Name.IndexOf(":") + 1, reader.Name.Length - reader.Name.IndexOf(":") - 1) : "";
                                    System.String prefix = (reader.Name.IndexOf(":") > 0) ? reader.Name.Substring(0, reader.Name.IndexOf(":")) : reader.Name;
                                    bool IsXmlns = prefix.ToLower().Equals("xmlns");
                                    if (this.namespaceAllowed)
                                    {
                                        if (!IsXmlns)
                                            attributes.Add(reader.NamespaceURI, reader.LocalName, reader.Name, "" + reader.NodeType, reader.Value);
                                    }
                                    else
                                        attributes.Add("", "", reader.Name, "" + reader.NodeType, reader.Value);
                                    if (IsXmlns)
                                    {
                                        System.String namespaceTemp = "";
                                        namespaceTemp = (namespaceURI.Length == 0) ? reader.Value : namespaceURI;
                                        if (this.namespaceAllowed && !prefixes.ContainsKey(namespaceTemp) && namespaceTemp.Length > 0)
                                        {
                                            stackNameSpace.Push(name);
                                            System.Collections.Stack namespaceStack = new System.Collections.Stack();
                                            namespaceStack.Push(prefixName);
                                            prefixes.Add(namespaceURI, namespaceStack);
                                            if (this.callBackHandler != null)
                                                ((IXmlSaxContentHandler)this.callBackHandler).startPrefixMapping(prefixName, namespaceTemp);
                                        }
                                        else
                                        {
                                            if (this.namespaceAllowed && namespaceTemp.Length > 0 && !((System.Collections.Stack)prefixes[namespaceTemp]).Contains(reader.Name))
                                            {
                                                ((System.Collections.Stack)prefixes[namespaceURI]).Push(prefixName);
                                                if (this.callBackHandler != null)
                                                    ((IXmlSaxContentHandler)this.callBackHandler).startPrefixMapping(prefixName, reader.Value);
                                            }
                                        }
                                    }
                                }
                            }
                            if (this.callBackHandler != null)
                                this.callBackHandler.startElement(namespaceURI, localName, name, attributes);
                            if (Empty)
                            {
                                if (this.NamespaceAllowed)
                                {
                                    if (this.callBackHandler != null)
                                        this.callBackHandler.endElement(namespaceURI, localName, name);
                                }
                                else
                                    if (this.callBackHandler != null)
                                        this.callBackHandler.endElement("", "", name);
                            }
                            break;

                        case System.Xml.XmlNodeType.EndElement:
                            if (this.namespaceAllowed)
                            {
                                if (this.callBackHandler != null)
                                    this.callBackHandler.endElement(reader.NamespaceURI, reader.LocalName, reader.Name);
                            }
                            else
                                if (this.callBackHandler != null)
                                    this.callBackHandler.endElement("", "", reader.Name);
                            if (this.namespaceAllowed && prefixes.ContainsKey(reader.NamespaceURI) && ((System.Collections.Stack)stackNameSpace).Contains(reader.Name))
                            {
                                stackNameSpace.Pop();
                                System.Collections.Stack namespaceStack = (System.Collections.Stack)prefixes[reader.NamespaceURI];
                                while (namespaceStack.Count > 0)
                                {
                                    System.String tempString = (System.String)namespaceStack.Pop();
                                    if (this.callBackHandler != null)
                                        ((IXmlSaxContentHandler)this.callBackHandler).endPrefixMapping(tempString);
                                }
                                prefixes.Remove(reader.NamespaceURI);
                            }
                            break;

                        case System.Xml.XmlNodeType.Text:
                            if (this.callBackHandler != null)
                                this.callBackHandler.characters(reader.Value.ToCharArray(), 0, reader.Value.Length);
                            break;

                        case System.Xml.XmlNodeType.Whitespace:
                            if (this.callBackHandler != null)
                                this.callBackHandler.ignorableWhitespace(reader.Value.ToCharArray(), 0, reader.Value.Length);
                            break;

                        case System.Xml.XmlNodeType.ProcessingInstruction:
                            if (this.callBackHandler != null)
                                this.callBackHandler.processingInstruction(reader.Name, reader.Value);
                            break;

                        case System.Xml.XmlNodeType.Comment:
                            if (this.lexical != null)
                                this.lexical.comment(reader.Value.ToCharArray(), 0, reader.Value.Length);
                            break;

                        case System.Xml.XmlNodeType.CDATA:
                            if (this.lexical != null)
                            {
                                lexical.startCDATA();
                                if (this.callBackHandler != null)
                                    this.callBackHandler.characters(this.reader.Value.ToCharArray(), 0, this.reader.Value.ToCharArray().Length);
                                lexical.endCDATA();
                            }
                            break;

                        case System.Xml.XmlNodeType.DocumentType:
                            if (this.lexical != null)
                            {
                                System.String lname = this.reader.Name;
                                System.String systemId = null;
                                if (this.reader.AttributeCount > 0)
                                    systemId = this.reader.GetAttribute(0);
                                this.lexical.startDTD(lname, null, systemId);
                                this.lexical.startEntity("[dtd]");
                                this.lexical.endEntity("[dtd]");
                                this.lexical.endDTD();
                            }
                            break;
                    }
                }
                if (this.callBackHandler != null)
                    this.callBackHandler.endDocument();
            }
            catch (System.Xml.XmlException e)
            {
                throw e;
            }
        }
示例#60
0
		/// <summary>Creates a new instance of ProfileName </summary>
		/// <param name="profileName">the name of the profile
		/// </param>
		/// <param name="profileStructureType">The Profile Structure Type for this Name. The
		/// Profile Structure Type is prepended to each class in the class hierarchy
		/// both for clarity and to avoid name collisions.
		/// </param>
		/// <param name="nameMap">a list of all the children in ProfileName
		/// </param>
		/// <param name="parentName">the name of the parent to the child 
		/// </param>
		private ProfileName(System.String profileName, int profileStructureType, System.Collections.Hashtable nameMap, System.String parentName)
		{
			this.profileName = new System.Text.StringBuilder(profileName).ToString();
			this.profileStructureType = profileStructureType;
			this.nameMap = nameMap;
			this.parentName = parentName;
			
			// TODO: These are workarounds.. These should probably be resolved somehow.
			if (profileName.Equals("Acknowledgment Code"))
				this.profileName = "Acknowledgement Code";
			if (this.parentName != null && this.parentName.Equals("NK1") && profileName.Equals("Name"))
				this.profileName = "NKName";
			
			// Append a number to the name if there is already a ProfileName with this particular name
			int i = 1;
			while (nameMap.ContainsKey(this.profileStructureType + this.profileName))
			{
				i++;
				this.profileName = new System.Text.StringBuilder(profileName + i).ToString();
			}
			
			// Store the new name in the hashmap 
			nameMap[this.profileStructureType + this.profileName] = null;
		}