C# Model.Dictionary類代碼示例

 /// <summary> 激活/作廢
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 void UCPurchasePlanOrderView_InvalidOrActivationEvent(object sender, EventArgs e)
 {
     string strmsg = string.Empty;
     List<SysSQLString> listSql = new List<SysSQLString>();
     SysSQLString sysStringSql = new SysSQLString();
     sysStringSql.cmdType = CommandType.Text;
     Dictionary<string, string> dic = new Dictionary<string, string>();//參數
     dic.Add("purchase_order_yt_id", purchase_order_yt_id);//單據ID
     dic.Add("update_by", GlobalStaticObj.UserID);//修改人Id
     dic.Add("update_name", GlobalStaticObj.UserName);//修改人姓名
     dic.Add("update_time", Common.LocalDateTimeToUtcLong(DateTime.Now).ToString());//修改時間               
     if (orderstatus != Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
     {
         strmsg = "作廢";
         dic.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString());//單據狀態編號
         dic.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.Invalid, true));//單據狀態名稱
     }
     else
     {
         strmsg = "激活";
         string order_status = string.Empty;
         string order_status_name = string.Empty;
         DataTable dvt = DBHelper.GetTable("獲得宇通采購訂單的前一個狀態", "tb_parts_purchase_order_2_BackUp", "order_status,order_status_name", "purchase_order_yt_id='" + purchase_order_yt_id + "'", "", "order by update_time desc");
         if (dvt != null && dvt.Rows.Count > 0)
         {
             DataRow dr = dvt.Rows[0];
             order_status = CommonCtrl.IsNullToString(dr["order_status"]);
             if (order_status == Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
             {
                 DataRow dr1 = dvt.Rows[1];
                 order_status = CommonCtrl.IsNullToString(dr1["order_status"]);
                 order_status_name = CommonCtrl.IsNullToString(dr1["order_status_name"]);
             }
         }
         order_status = !string.IsNullOrEmpty(order_status) ? order_status : Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString();
         if (order_status == Convert.ToInt32(DataSources.EnumAuditStatus.NOTAUDIT).ToString())
         { order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.NOTAUDIT, true); }
         else if (order_status == Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString())
         { order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.DRAFT, true); }
         dic.Add("order_status", order_status);//單據狀態
         dic.Add("order_status_name", order_status_name);//單據狀態名稱
     }
     sysStringSql.sqlString = "update tb_parts_purchase_order_2 set [email protected]_status,[email protected]_status_name,[email protected]_by,[email protected]_name,[email protected]_time where [email protected]_order_yt_id";
     sysStringSql.Param = dic;
     listSql.Add(sysStringSql);
     if (MessageBoxEx.Show("確認要" + strmsg + "嗎?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
     {
         return;
     }
     if (DBHelper.BatchExeSQLStringMultiByTrans("更新單據狀態為" + strmsg + "", listSql))
     {
         MessageBoxEx.Show("" + strmsg + "成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
         uc.BindgvYTPurchaseOrderList();
         deleteMenuByTag(this.Tag.ToString(), uc.Name);
     }
     else
     {
         MessageBoxEx.Show("" + strmsg + "失敗！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }

        void UCSalePlanView_SaveEvent(object sender, EventArgs e)
        {
            try
            {
                gvPurchasePlanList.EndEdit();
                List<SysSQLString> listSql = new List<SysSQLString>();
                SysSQLString sysStringSql = new SysSQLString();
                sysStringSql.cmdType = CommandType.Text;
                Dictionary<string, string> dic = new Dictionary<string, string>();//參數

                string sql1 = string.Format(@" Update tb_parts_sale_plan Set [email protected]_suspend,[email protected]_reason,[email protected]_by,
                [email protected]_name,[email protected]_time,[email protected],[email protected]_name where [email protected]_plan_id;");
                dic.Add("is_suspend", chkis_suspend.Checked ? "0" : "1");//選中(中止)：0,未選中(不中止)：1
                dic.Add("suspend_reason", txtsuspend_reason.Caption.Trim());
                dic.Add("update_by", GlobalStaticObj.UserID);
                dic.Add("update_name", GlobalStaticObj.UserName);
                dic.Add("update_time", Common.LocalDateTimeToUtcLong(DateTime.Now).ToString());
                dic.Add("operators", GlobalStaticObj.UserID);
                dic.Add("operator_name", GlobalStaticObj.UserName);
                dic.Add("sale_plan_id", planId);
                sysStringSql.sqlString = sql1;
                sysStringSql.Param = dic;
                listSql.Add(sysStringSql);
                foreach (DataGridViewRow dr in gvPurchasePlanList.Rows)
                {
                    string is_suspend = "1";
                    if (dr.Cells["is_suspend"].Value == null)
                    { is_suspend = "1"; }
                    if ((bool)dr.Cells["is_suspend"].EditedFormattedValue)
                    { is_suspend = "0"; }
                    else
                    { is_suspend = "1"; }

                    sysStringSql = new SysSQLString();
                    sysStringSql.cmdType = CommandType.Text;
                    dic = new Dictionary<string, string>();
                    dic.Add("is_suspend", is_suspend);
                    dic.Add("sale_plan_id", planId);
                    dic.Add("parts_code", dr.Cells["parts_code"].Value.ToString());
                    string sql2 = "Update tb_parts_sale_plan_p set [email protected]_suspend where [email protected]_plan_id and [email protected]_code;";
                    sysStringSql.sqlString = sql2;
                    sysStringSql.Param = dic;
                    listSql.Add(sysStringSql);
                }
                if (DBHelper.BatchExeSQLStringMultiByTrans("修改采購計劃單", listSql))
                {
                    MessageBoxEx.Show("保存成功！");
                    uc.BindgvSalePlanList();
                    deleteMenuByTag(this.Tag.ToString(), uc.Name);
                }
                else
                {
                    MessageBoxEx.Show("保存失敗！");
                }
            }
            catch (Exception ex)
            {
                MessageBoxEx.Show("操作失敗！");
            }
        }

 public FolderInfo()
 {
     dicVectorFile = new Dictionary<string, string>();
     UploadResult = new StringBuilder();
     WaitUploadFilesCount = 0;
     SucessfulUploadFilesCount = 0;
 }

		private static void Main(string[] args)
		{
			if (args.Length != 1)
			{
				Console.WriteLine("Usage: Importer [directory to process]");
				return;
			}
			string directory = args[0];
			if (!Directory.Exists(directory))
			{
				Console.WriteLine("{0} does not exists", directory);
				return;
			}
			Dictionary<Guid, Post> posts = new Dictionary<Guid, Post>();
			IDictionary<string, Category> categories = new Dictionary<string, Category>();
			List<Comment> comments = new List<Comment>();
			AddPosts(categories, directory, posts);
			foreach (string file in Directory.GetFiles(directory, "*feedback*.xml"))
			{
				IList<Comment> day_comments = ProcessComments(file, posts);
				comments.AddRange(day_comments);
			}
			Console.WriteLine("Found {0} posts in {1} categories with {2} comments", posts.Count, categories.Count, comments.Count);
			SaveToDatabase(categories, posts.Values, comments);
		}

        public static Dictionary<int, List<Visit>> GetVisitData(string path)
        {
            Dictionary<int, List<Visit>> data = new Dictionary<int, List<Visit>>();
            Random r = new Random();

            foreach (string row in File.ReadLines(path))
            {
                string[] split = row.Split(',');

                if (split.Length > 0)
                {
                    int id = int.Parse(split[0]);
                    Visit visit = new Visit(id, r.Next(1, 10), int.Parse(split[2]), DateTime.Parse(split[1]));

                    if (data.ContainsKey(id))
                    {
                        data[id].Add(visit);
                    }
                    else
                    {
                        data.Add(id, new List<Visit>(){visit});
                    }
                }
            }

            return data;
        }

		private void Load()
		{
			this.UiTypes = new Dictionary<UIType, IUIFactory>();

			Assembly[] assemblies = Game.EntityEventManager.GetAssemblies();
			foreach (Assembly assembly in assemblies)
			{
				Type[] types = assembly.GetTypes();
				foreach (Type type in types)
				{
					object[] attrs = type.GetCustomAttributes(typeof(UIFactoryAttribute), false);
					if (attrs.Length == 0)
					{
						continue;
					}

					UIFactoryAttribute attribute = attrs[0] as UIFactoryAttribute;
					if (this.UiTypes.ContainsKey(attribute.Type))
					{
						throw new GameException($"已經存在同類UI Factory: {attribute.Type}");
					}
					IUIFactory iIuiFactory = Activator.CreateInstance(type) as IUIFactory;
					if (iIuiFactory == null)
					{
						throw new GameException("UI Factory沒有繼承IUIFactory");
					}
					this.UiTypes.Add(attribute.Type, iIuiFactory);
				}
			}
		}

        /// <summary>
        /// 查詢主表
        /// </summary> 
        public JsonResult QueryMain(string OrderNoOrGoodsCode, DateTime CheckTimeS, DateTime CheckTimeE)
        {
            int page = int.Parse(Request["page"].ToString());
            int rows = int.Parse(Request["rows"].ToString());
            int total = 0;
            VenderUser model = (VenderUser)Session["UserInfo"];
            string where = "  rt.flag in(20 ,40,90,100) ";//and rt.venderid=" + model.VENDERID;

            //管理員測試數據放開
            if (model.VUSERCODE != "system")
            {
                where += " and rt.venderid=" + model.VENDERID;
            }

            if (!string.IsNullOrEmpty(OrderNoOrGoodsCode))
            {
                where += " and rt.sheetid='" + OrderNoOrGoodsCode + "'";
            }
            if (CheckTimeS != null)
            {
                where += " and rt.EditDate> to_date('" + CheckTimeS + "','yyyy-mm-dd hh24:mi:ss')";
            }
            if (CheckTimeE != null)
            {
                where += " and rt.EditDate< to_date('" + CheckTimeE + "','yyyy-mm-dd hh24:mi:ss')";
            }
            BPurchaseOut ogc = new BPurchaseOut();
            var result = ogc.GetPurchaseInMain(page, rows, out total, where);

            Dictionary<string, object> json = new Dictionary<string, object>();
            json.Add("total", total);
            json.Add("rows", result);
            return Json(json, JsonRequestBehavior.AllowGet);
        }

        public async Task<Photoset> GetCoverPhotoAsync(User user, Preferences preferences, bool onlyPrivate) {
            var extraParams = new Dictionary<string, string> {
                {
                    ParameterNames.UserId, user.UserNsId
                }, {
                    ParameterNames.SafeSearch, preferences.SafetyLevel
                }, {
                    ParameterNames.PerPage, "1"
                }, {
                    ParameterNames.Page, "1"
                }, {
                    ParameterNames.PrivacyFilter, onlyPrivate ? "5" : "1"
                    // magic numbers: https://www.flickr.com/services/api/flickr.people.getPhotos.html
                }
            };

            var photosetsResponseDictionary = (Dictionary<string, object>)
                await this._oAuthManager.MakeAuthenticatedRequestAsync(Methods.PeopleGetPhotos, extraParams);

            var photo = photosetsResponseDictionary.GetPhotosResponseFromDictionary(false).Photos.FirstOrDefault();

            return photo != null
                ? new Photoset(null, null, null, null, 0, 0, 0,
                    onlyPrivate ? "All Photos" : "All Public Photos", "",
                    onlyPrivate ? PhotosetType.All : PhotosetType.Public,
                    photo.SmallSquare75X75Url)
                : null;
        }

        public async Task<PhotosResponse> GetPhotosAsync(Photoset photoset, User user, Preferences preferences, int page,
                                                         IProgress<ProgressUpdate> progress) {
            var progressUpdate = new ProgressUpdate {
                OperationText = "Getting list of photos...",
                ShowPercent = false
            };
            progress.Report(progressUpdate);

            var methodName = GetPhotosetMethodName(photoset.Type);

            var extraParams = new Dictionary<string, string> {
                {
                    ParameterNames.UserId, user.UserNsId
                }, {
                    ParameterNames.SafeSearch, preferences.SafetyLevel
                }, {
                    ParameterNames.PerPage,
                    preferences.PhotosPerPage.ToString(CultureInfo.InvariantCulture)
                }, {
                    ParameterNames.Page, page.ToString(CultureInfo.InvariantCulture)
                }
            };

            var isAlbum = photoset.Type == PhotosetType.Album;
            if (isAlbum) {
                extraParams.Add(ParameterNames.PhotosetId, photoset.Id);
            }

            var photosResponse = (Dictionary<string, object>)
                await this._oAuthManager.MakeAuthenticatedRequestAsync(methodName, extraParams);

            return photosResponse.GetPhotosResponseFromDictionary(isAlbum);
        }

 public int AddDictionary(Dictionary model)
 {
     string cmdText = @"
     DECLARE @NEWID INT
     INSERT INTO [Dictionary] (Cname,ParentId,IsChild,Remarks) values (@Cname,@ParentId,@IsChild,@Remarks)
     SET @[email protected]@IDENTITY
     SELECT @NEWID";
     SqlParameter[] parameters =
     {
         SqlParamHelper.MakeInParam("@Cname",SqlDbType.VarChar,100,model.Cname),
         SqlParamHelper.MakeInParam("@ParentId",SqlDbType.Int,4,model.ParentId),
         SqlParamHelper.MakeInParam("@IsChild",SqlDbType.Bit,1,model.IsChild),
         SqlParamHelper.MakeInParam("@Remarks",SqlDbType.VarChar,120,model.Remarks)
     };
     int id = 0;
     using (IDataReader dataReader = SqlHelper.ExecuteReader(WriteConnectionString,CommandType.Text,cmdText,parameters)){
         if(dataReader.Read()){
             object obj = dataReader[0];
             if(obj != null && obj != DBNull.Value){
                 id = Convert.ToInt32(obj);
             }
         }
     }
     return id;
 }

        public static List<Movie> GetRecommendations(List<Movie> all, Dictionary<int, int> newRanks, List<Tuple<int, int, float>> oldRanks)
        {
            int newUserId = 0;
            Ratings ratings = new Ratings();

            foreach (var r in oldRanks)
            {
                ratings.Add(r.Item1, r.Item2, r.Item3);
                if (r.Item1 > newUserId) newUserId = r.Item1;
            }

            // this makes us sure that the new user has a unique id (bigger than all other)
            newUserId = newUserId + 1;

            foreach (var k in newRanks)
            {
                ratings.Add(newUserId, k.Key, (float)k.Value);
            }

            var engine = new BiPolarSlopeOne();

            // different algorithm:
            // var engine = new UserItemBaseline();

            engine.Ratings = ratings;

            engine.Train(); // warning: this could take some time!

            return all.Select(m =>
                                {
                                    m.Rank = engine.Predict(newUserId, m.Id); // do the prediction!
                                    return m;
                                }).ToList();
        }

        public IAnswer AskAnswer(IQuestion question)
        {
            var j = 0;

            var choices = new Dictionary<char,IChoice>();
            question.Choices.ForEach(c => choices.Add((char)('a' + j++), c));

            var answerChar = '\0';

            do
            {
                Console.Clear();
                Console.WriteLine("Question: {0}", question.QuestionString);

                foreach (var choice in choices)
                {
                    Console.WriteLine("{0}. {1}", choice.Key, choice.Value.ChoiceText);
                }

                Console.Write("\nAnswer: ");
                var readLine = Console.ReadLine();
                if (readLine == null) continue;

                if (new[] { "back", "b", "oops", "p", "prev" }.Contains(readLine.ToLower()))
                {
                    return question.CreateAnswer(Choice.PREVIOUS_ANSWER);
                }

                answerChar = readLine[0];
            } while (!choices.ContainsKey(answerChar));

            return question.CreateAnswer(choices[answerChar]);
        }

        public static Dictionary<SiteType, IEnumerable<string>> GetIPSiteTypeDictionary()
        {
            Dictionary<SiteType, IEnumerable<string>> dic = new Dictionary<SiteType, IEnumerable<string>>();
            List<string> tpolist = new List<string>();
            List<string> weclist = new List<string>();
            List<string> cdwlist = new List<string>();
            foreach (EnvironmentSettings a in EnvironmentConfigSection.EnvironmentSettingCollection)
            {
                if (!string.IsNullOrEmpty(a.TPO))
                {
                    tpolist.Add(a.TPO);
                }
                if (!string.IsNullOrEmpty(a.WebCenter))
                {
                    weclist.Add(a.WebCenter);
                }
                if (!string.IsNullOrEmpty(a.ConsumerDirect))
                {
                    cdwlist.Add(a.ConsumerDirect);
                }
            }
            dic.Add(SiteType.TPO, tpolist);
            dic.Add(SiteType.WBC, weclist);
            dic.Add(SiteType.CDW, cdwlist);

            return dic;
        }

 public CreatedAtRouteNegotiatedContentResult<IEnumerable<Figure>> GetCreatedAtRouteNegotiatedContentResult()
 {
     IDictionary<string, object> route = new Dictionary<string, object>();
     route["controller"] = "Figure";
     route["action"] = "GetAll";
     return new CreatedAtRouteNegotiatedContentResult<IEnumerable<Figure>>("DefaultApi", route, FigureManager.Figures, this);
 }

        public async Task<PhotosetsResponse> GetPhotosetsAsync(string methodName, User user, Preferences preferences, int page,
                                                               IProgress<ProgressUpdate> progress) {
            var progressUpdate = new ProgressUpdate {
                OperationText = "Getting list of albums...",
                ShowPercent = false
            };
            progress.Report(progressUpdate);

            var extraParams = new Dictionary<string, string> {
                {
                    ParameterNames.UserId, user.UserNsId
                }, {
                    ParameterNames.SafeSearch, preferences.SafetyLevel
                }, {
                    ParameterNames.PerPage, "21"
                }, {
                    ParameterNames.Page, page.ToString(CultureInfo.InvariantCulture)
                }
            };

            var photosetsResponseDictionary = (Dictionary<string, object>)
                await this._oAuthManager.MakeAuthenticatedRequestAsync(methodName, extraParams);

            return photosetsResponseDictionary.GetPhotosetsResponseFromDictionary();
        }