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 is_suspend=@is_suspend,suspend_reason=@suspend_reason,update_by=@update_by, update_name=@update_name,update_time=@update_time,operators=@operators,operator_name=@operator_name where sale_plan_id=@sale_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 is_suspend=@is_suspend where sale_plan_id=@sale_plan_id and parts_code=@parts_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("操作失败!"); } }
/// <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); }
/// <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 order_status=@order_status,order_status_name=@order_status_name,update_by=@update_by,update_name=@update_name,update_time=@update_time where purchase_order_yt_id=@purchase_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); } }
public Dictionary<string, string> ToDictionary() { Dictionary<string, string> dict = new Dictionary<string, string>(); dict.Add("LayerThickness", layer_thickness.ToString()); dict.Add("LayerMaterialName", layer_material_name); dict.Add("LayerMaterialType", layer_material_type); return dict; }
public void Add(string remarks) { Dictionary<string, object> data = new Dictionary<string, object>(); data.Add("@userid", _userid); data.Add("@action", "Created A New Record"); data.Add("@entrydate", DateTime.Now); data.Add("@remarks", remarks); SpWithParam("add_audit_trail", data); }
public void Get_ViewModelShouldCollaborate_WithGenresRetriever() { var testGenres = new Dictionary<string, string>(); testGenres.Add("genres/123", "aaa"); testGenres.Add("genres/234", "aaa"); testGenres.Add("genres/345", "bbb"); genreRetriever.Stub(r => r.GetAll()).Return(testGenres); var result = endpoint.Get(new UpdateBookLinkModel() {Id = "Irrelevant"}); result.ShouldHaveGenres(testGenres); }
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; }
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 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); }
// sets parameters for insert/update private Dictionary<string, object> SetParams(Roles department) { Dictionary<string, object> result = new Dictionary<string, object>(); result.Add("@departmentName", department.Name); return result; }
protected override IReadOnlyDictionary<string, ScimSchema> CreateSchemas() { var schemas = new Dictionary<string, ScimSchema>(); foreach (var std in ServerConfiguration.GetSchemaTypeDefinitions(ScimVersion.One)) { var attributeDefinitions = new List<ScimAttributeSchema>(); foreach (var ad in std.AttributeDefinitions.Values) { attributeDefinitions.Add(ad.ToScimAttributeSchema()); } schemas.Add( std.Name, SetResourceVersion( new ScimSchema1( std.Schema + ":" + std.Name, std.Name, std.Description, attributeDefinitions))); var rtd = std as IScimResourceTypeDefinition; if (rtd != null) { foreach (var extension in rtd.SchemaExtensions) { attributeDefinitions = new List<ScimAttributeSchema>(); foreach (var ad in extension.ExtensionDefinition.AttributeDefinitions.Values) { attributeDefinitions.Add(ad.ToScimAttributeSchema()); } schemas.Add( extension.Schema, SetResourceVersion( new ScimSchema1( extension.Schema, extension.ExtensionDefinition.Name, extension.ExtensionDefinition.Description, attributeDefinitions))); } } } return schemas; }
public static void Initialize() { VideoMedias = new ObservableCollection<IMedia>(); AudioMedias = new ObservableCollection<IMedia>(); ImageMedias = new ObservableCollection<IMedia>(); loadFolder(Environment.GetFolderPath(Environment.SpecialFolder.CommonPictures)); loadFolder(Environment.GetFolderPath(Environment.SpecialFolder.CommonMusic)); loadFolder(Environment.GetFolderPath(Environment.SpecialFolder.CommonVideos)); loadFolder(Environment.GetFolderPath(Environment.SpecialFolder.MyMusic)); loadFolder(Environment.GetFolderPath(Environment.SpecialFolder.MyVideos)); loadFolder(Environment.GetFolderPath(Environment.SpecialFolder.MyPictures)); all = new Dictionary<Medias, ObservableCollection<IMedia>>(); all.Add(Medias.VIDEO, VideoMedias); all.Add(Medias.AUDIO, AudioMedias); all.Add(Medias.IMAGE, ImageMedias); }
public ActionResult Index() { ViewBag.Origem = new Origem().Lista(null); ViewBag.Origem.Insert(0, new OrigemModel() { Id = 0, Nome = "" }); ViewBag.Profissao = new Profissao().Lista(null); ViewBag.Profissao.Insert(0, new ProfissaoModel() { Id = 0, Nome = "" }); Dictionary<int, string> lista = new Dictionary<int, string>(); lista.Add(0, ""); lista.Add(1, "Sim"); lista.Add(2, "Não"); ViewBag.SimNaoTodos = lista; PF pfData = new PF(); List<PFModel> model = pfData.Filtro50(null, null, null, null, null); return View(model); }
public static string _host = ".kerlaii.com";//从数据库动态获取 public void OnActionExecuting(ActionExecutingContext filterContext) { bool isajax = filterContext.HttpContext.Request.IsAjaxRequest(); UserPC user = filterContext.HttpContext.Session["user"] as UserPC; string host = filterContext.HttpContext.Request.Url.Host; string key = host.Replace(_host, ""); //本地调试,模拟e0001企业 opera if (host.ToLower() == "localhost") { key = "e0001"; } EnterpriseBll bll = new EnterpriseBll(); string[] keys = bll.GetAllEnteriseKey(); if (key !="opera" && !keys.Contains(key)) { filterContext.Result = new HttpNotFoundResult(); return; //没有该企业 } filterContext.HttpContext.Session["enterpriseKey"] = key; if (check) { if (user == null) { ReturnData<string> ret = new ReturnData<string>(); if (isajax) { ret.Status = false; Dictionary<string, object> Identify = new Dictionary<string, object>(); Identify.Add("expired", true); ret.Identify = Identify; filterContext.Result = new ContentResult() { Content = ret.GetJson() }; return; } //跳转页面 filterContext.Result = new ContentResult() { Content = "<script>window.top.location.href ='/';</script>" }; return ; } LogAdapter.Write(user.UserBasic.EnterpriseID+" "+key, LogAdapter.LogMode.ERROR); //当前用户不是当前企业 if (user.UserBasic.EnterpriseID != key) { filterContext.HttpContext.Response.Redirect("/Login"); } } }
public Dictionary<string, ChannelAliasModel> GetAliasList() { var res = new Dictionary<string, ChannelAliasModel>(); foreach (var item in ItemList) { var temp = item.GetAlias(); res.Add(temp.ChannelName, temp); } return res; }
public ClearanceViewModel Fetch(string studentNumber) { ClearanceViewModel vm = new ClearanceViewModel(); Dictionary<string, string> departmentList = new Dictionary<string, string>(); List<Department> departments = dbDeparment.GetAllDepartment.ToList(); List<Accountability> accountabilities = dbAccountability.Fetch.Where(a => a.StudentNumber == studentNumber && a.Status == true).ToList(); vm.Student = dbStudent.GetAllStudent.FirstOrDefault(s => s.StudentNumber == studentNumber); int count = accountabilities.Count; if (count <= 0) { foreach (Department item in departments) { departmentList.Add(item.Name, "Cleared"); } vm.Clearance = departmentList; } else { foreach (Department dept in departments) { foreach (Accountability acct in accountabilities) { if (dept.ID == acct.DepartmentID) { departmentList.Add(dept.Name, acct.Description); } else { departmentList.Add(dept.Name, "Cleared"); } } } vm.Clearance = departmentList; } return vm; }
public void loadData(int[] runId, int displayFormat) { Dictionary<int, IXPathNavigable> data = new Dictionary<int, IXPathNavigable>(); if (runId != null && runId.Length > 0) { for (int i = 0; i < runId.Length; i++) { data.Add(runId[i], this.assessmentController.GetSimRunData(runId[i])); } this.loadTableData(data, displayFormat); } }
public void Process(DirectoryInfo directory, ref Dictionary<string, package> packages) { foreach (var fileToProcess in directory.GetFiles("*.nuspec", SearchOption.AllDirectories)) { var p = new package(); new FileProcessor().Process(fileToProcess, ref p); packages.Add(fileToProcess.DirectoryName, p); } new PackageListProcessor().Process(packages); }
public JsonResult QueryDetailData(string sheetid) { BPurchaseOut ogc = new BPurchaseOut(); var result = ogc.GetPurchaseInDetail(sheetid); Dictionary<string, object> json = new Dictionary<string, object>(); //json.Add("total", total); json.Add("rows", result); return Json(json, JsonRequestBehavior.AllowGet); }
public static Dictionary<int, Dictionary<string, ClassLine>> GetBalanceSheet() { //OUTPUT Dictionary<int, Dictionary<string, ClassLine>> output = new Dictionary<int, Dictionary<string, ClassLine>>(); //STABLISH PRIMAVERA COMMUNICATION if (!InitializeCompany()) return output; StdBELista balanceSheetQuery = PriEngine.Engine.Consulta("SELECT * FROM AcumuladosContas ORDER BY Ano DESC"); //COMPLETE OUTPUT Dictionary<string, ClassLine> year_balance = new Dictionary<string, ClassLine>(); int past_year = 0; while (!balanceSheetQuery.NoFim()) { ClassLine line = new ClassLine(); line.ano = balanceSheetQuery.Valor("Ano"); //CHECK IF IT IS A NEW YEAR TO CREATE A NEW BALANCE if (line.ano != past_year && past_year != 0) //in the first case the years are different but we want to continue { output.Add(past_year, year_balance); year_balance = new Dictionary<string, ClassLine>(); } processLine(balanceSheetQuery, line); if (line.tipoLancamento == "000") year_balance.Add(line.conta.ToString(), line); past_year = line.ano; balanceSheetQuery.Seguinte(); } //if there are no more lines the cycle will end, so we have to add the data outside output.Add(past_year, year_balance); return output; }
protected override SelectQuery ProcessQuery(SelectQuery selectQuery) { if (selectQuery.IsInsert && selectQuery.Insert.Into.Name == "Parent") { var expr = new QueryVisitor().Find(selectQuery.Insert, e => { if (e.ElementType == QueryElementType.SetExpression) { var se = (SelectQuery.SetExpression)e; return ((SqlField)se.Column).Name == "ParentID"; } return false; }) as SelectQuery.SetExpression; if (expr != null) { var value = ConvertTo<int>.From(((IValueContainer)expr.Expression).Value); if (value == 555) { var tableName = "Parent1"; var dic = new Dictionary<IQueryElement,IQueryElement>(); selectQuery = new QueryVisitor().Convert(selectQuery, e => { if (e.ElementType == QueryElementType.SqlTable) { var oldTable = (SqlTable)e; if (oldTable.Name == "Parent") { var newTable = new SqlTable(oldTable) { Name = tableName, PhysicalName = tableName }; foreach (var field in oldTable.Fields.Values) dic.Add(field, newTable.Fields[field.Name]); return newTable; } } IQueryElement ex; return dic.TryGetValue(e, out ex) ? ex : null; }); } } } return selectQuery; }
public Dictionary<Helper.Point, Pokemon> getPokemons() { var _pokemonsperarea = new Dictionary<Helper.Point, Pokemon>(); for (int x = _map.AshIndex.x - 4; x < _map.AshIndex.x + 4; x++) for (int y = _map.AshIndex.y - 4; y < _map.AshIndex.y + 4; y++) { Tile pokemonTile = _map.GetTile(x, y) ; if (pokemonTile != null && pokemonTile.Pokemon != null) _pokemonsperarea.Add(new Helper.Point(x, y), pokemonTile.Pokemon ); } return _pokemonsperarea; }
public ActionResult Login(UserPC model, bool isAuto = false) { ReturnData<string> ret = new ReturnData<string>(); //Bll实例化放action里面 为了不让每次都实例化 产生废代码 UserPCBll bll = new UserPCBll(); //只要找得到记住的密码就去匹配记住的密码 if (Request.Cookies["remember"] != null) { if (Request.Cookies["remember"]["uname"] != "" && model.PassWord == "********") { model.Status = 99; model.PassWord = Request.Cookies["remember"]["pwd"]; } } //ReturnData 是值类型 不需要ref来赋值传递 当传入方法里时返回时还是带有值的 var user = bll.Login(ret, model, EnterpriseKey); if (user != null) { //登录成功了 才记住用户名和密码 if (isAuto) { Response.Cookies["remember"]["uname"] = user.UserName; Response.Cookies["remember"]["pwd"] = Convert.ToBase64String(YYYCommon.Encryption.SymmetricEncryption.Encrypt(user.PassWord + "\r" + DateTime.Now.ToString())); Response.Cookies["remember"].Expires = DateTime.Now.AddDays(7); } else { Response.Cookies["remember"]["uname"] = ""; } //保存登录信息 Session["user"] = user; //设置跳转路径 Dictionary<string, object> Identify = new Dictionary<string, object>(); if (EnterpriseKey.ToLower() == "opera") { Identify.Add("url", "/Operate/Areas/Index"); } else { //return RedirectToAction("WellCome"); Identify.Add("url", "/Login/Welcome"); } ret.Identify = Identify; } return Content(ret.GetJson()); }
public string RetrieveConfirmationCode(string studentNumber) { Dictionary<string, object> result = new Dictionary<string, object>(); result.Add("@studentNo", studentNumber); string code = StoredProc("get_code", result); if (code != "") { return code; } else { ExecuteNonQuery(QueryBuilder.Insert("tblconfirmation", TargetFields), SetParams(studentNumber)); return StoredProc("get_code", result); } }
public SuggestedMoves GetPath(Color[,] board) { //Get the farthest nodes TreeNode head = MapBuilder.BuildTree(board); ISet<TreeNode> farthestNodes = new HashSet<TreeNode>(); int highestDepth = 0; foreach (TreeNode node in head.BFS()) //DFS would be better { int depth = GetDepth(node); if (depth > highestDepth) { highestDepth = depth; farthestNodes.Clear(); farthestNodes.Add(node); } else if (depth == highestDepth) { farthestNodes.Add(node); } } Console.Write("Farthest nodes are "); farthestNodes.Select(n => n.Color).ToList().ForEach(c => Console.Write(c + ", ")); Console.WriteLine("\r\nFarthest node is " + GetDepth(farthestNodes.First()) + " away from the current"); //get the color that would step towards each color IDictionary<Color, int> tally = new Dictionary<Color, int>(); foreach (TreeNode farthestNode in farthestNodes) { TreeNode currentNode = farthestNode; while (currentNode.Parent != head) { currentNode = currentNode.Parent; } if (!tally.ContainsKey(currentNode.Color)) { tally.Add(currentNode.Color, 1); } else { tally[currentNode.Color]++; } } SuggestedMoves suggestedMoves = new SuggestedMoves(); suggestedMoves.AddFirst(new SuggestedMove(tally.OrderByDescending(kvp => kvp.Value).Select(n => n.Key))); return suggestedMoves; }
public static void InsertRecEntity(string guid,IssueRecEntity entity) { if (recEntity.Count == 0) { Init(capacity); } Dictionary<string, IssueRecEntity> dict = new Dictionary<string, IssueRecEntity>(); dict.Add(guid,entity); recEntity[looper] = dict; looper += 1; if (looper > capacity - 1) { looper = 0; } }
public string SavePath(HttpPostedFileBase file) { Dictionary<string, string> dic = new Dictionary<string, string>(); dic.Add("渠道ID", "Id"); dic.Add("渠道类型(必填)", "Type"); dic.Add("渠道或者门店名称(必填)", "Name"); dic.Add("所属代理商(必填)", "AgentID"); dic.Add("所属省(必填)", "ProvinceID"); dic.Add("所属市(必填)", "CityID"); dic.Add("所属区/县(必填)", "CountryID"); dic.Add("联系人(必填)", "Contact"); dic.Add("注册手机号码(必填)", "Tel"); DataTable dt = file.GetDataTable(dic); DataTable newDt = new ShopInfoBll().InsertShopInfoFromExcel(LoginUser.UserBasic.EnterpriseID, dt); long timer = DateTime.Now.Ticks; if (dt.Rows.Count > 0) { Session["loadFile"] = newDt; return new { status = false }.GetJson(); } return new { status = true }.GetJson(); }
public MainViewModel() { // please adjust this to meet your system layout ... // obviously this should be changed to load file dialog usage :) try { _movies = DataLoader.ReadItemLabels("u.item"); _trainData = DataLoader.ReadTrainingData("u.data"); } catch (Exception) { MessageBox.Show("Error loading data files! Please check ViewModel.cs for file location!", "Error loading files", MessageBoxButton.OK, MessageBoxImage.Error); Application.Current.Shutdown(); } Movies = new ObservableCollection<Movie>(_movies.OrderBy(m=>m.Title)); NewRank = 1; RaisePropertyChanged(() => NewRank); SelectedMovie = Movies.First(); RaisePropertyChanged(() => SelectedMovie); Ranking = new Dictionary<int, int>(); AddRankCommand = new RelayCommand(() => { if (!Ranking.ContainsKey(SelectedMovie.Id)) { Log += string.Format("{0} - rank: {1}\n", SelectedMovie, NewRank); RaisePropertyChanged(() => Log); Ranking.Add(SelectedMovie.Id, NewRank); Movies.Remove(SelectedMovie); SelectedMovie = Movies.First(); RaisePropertyChanged(() => SelectedMovie); } var rec = Engine.GetRecommendations(_movies, Ranking, _trainData); var foo = rec.OrderByDescending(e => e.Rank);//.Where(e => !Ranking.ContainsKey(e.Id)); Recomendations =new ObservableCollection<Movie>(foo); this.RaisePropertyChanged(() => Recomendations); }); }
/// <summary> /// 添加sql语句 -图片 /// </summary> /// <param name="listSql">listSql</param> /// <param name="partID">用户id</param> /// <param name="path">图片id</param> /// <returns></returns> private List<SQLObj> AddPhoto(List<SQLObj> listSql, string partID, string path) { if (path != string.Empty) { SQLObj sqlObj = new SQLObj(); sqlObj.cmdType = CommandType.Text; Dictionary<string, ParamObj> dic = new Dictionary<string, ParamObj>(); dic.Add("att_path", new ParamObj("att_path", path, SysDbType.VarChar, 40)); sqlObj.Param = dic; if (photoID.Length == 0) { dic.Add("att_name", new ParamObj("att_name", "用户图片", SysDbType.NVarChar, 15)); dic.Add("att_type", new ParamObj("att_type", "图片", SysDbType.NVarChar, 15)); photoID = Guid.NewGuid().ToString(); dic.Add("is_main", new ParamObj("is_main", (int)DataSources.EnumYesNo.Yes, SysDbType.VarChar, 5)); dic.Add("relation_object", new ParamObj("relation_object", "tb_parts", SysDbType.NVarChar, 30)); dic.Add("relation_object_id", new ParamObj("relation_object_id", partID, SysDbType.VarChar, 40)); dic.Add("enable_flag", new ParamObj("enable_flag", (int)DataSources.EnumEnableFlag.USING, SysDbType.VarChar, 5)); dic.Add("create_by", new ParamObj("create_by", GlobalStaticObj.UserID, SysDbType.NVarChar, 40)); dic.Add("create_time", new ParamObj("create_time", DateTime.UtcNow.Ticks, SysDbType.BigInt)); sqlObj.sqlString = @"insert into [attachment_info] ([att_id],[att_name],[att_type],[att_path],[relation_object],[relation_object_id],[enable_flag],[create_by],[create_time],[is_main]) values (@att_id,@att_name,@att_type,@att_path,@relation_object,@relation_object_id,@enable_flag,@create_by,@create_time,@is_main);"; } else { dic.Add("update_by", new ParamObj("update_by", GlobalStaticObj.UserID, SysDbType.NVarChar, 40)); dic.Add("update_time", new ParamObj("update_time", DateTime.UtcNow.Ticks, SysDbType.BigInt)); sqlObj.sqlString = "update [attachment_info] set [att_path]=@att_path,[update_by]=@update_by,[update_time]=@update_time where [att_id]=@att_id;"; } dic.Add("att_id", new ParamObj("att_id", photoID, SysDbType.VarChar, 40)); listSql.Add(sqlObj); } return listSql; }
/// <summary> /// 保存 /// </summary> void UCPersonnelAddOrEdit_SaveEvent(object sender, EventArgs e) { string msg = string.Empty; bool bln = Validator(ref msg); if (!bln) { return; } string newGuid = string.Empty; string currUser_id = ""; string keyName = string.Empty; string keyValue = string.Empty; string opName = "新增人员信息"; Dictionary<string, string> dicFileds = new Dictionary<string, string>(); dicFileds.Add("user_name", txtuser_name.Caption.Trim());//人员姓名 //账号 if (cbois_operator.SelectedValue.ToString() == DataSources.EnumYesNo.Yes.ToString("d")) { dicFileds.Add("land_name", txtland_name.Caption.Trim()); } else { dicFileds.Add("land_name", ""); } dicFileds.Add("user_phone", txtuser_phone.Caption.Trim());//手机 dicFileds.Add("user_telephone", txtuser_telephone.Caption.Trim());//固话 dicFileds.Add("org_id", txcorg_name.Tag.ToString().Trim());//组织id dicFileds.Add("sex", cbosex.SelectedValue.ToString());//性别 dicFileds.Add("user_fax", txtuser_fax.Caption.Trim());//传真 dicFileds.Add("is_operator", cbois_operator.SelectedValue.ToString());//是否操作员 dicFileds.Add("idcard_type", cboidcard_type.SelectedValue.ToString());//证件类型 dicFileds.Add("user_email", txtuser_email.Caption.Trim());//邮箱 dicFileds.Add("idcard_num", txtidcard_num.Caption.Trim());//证件号码 dicFileds.Add("user_address", txtuser_address.Caption.Trim());//联系地址 dicFileds.Add("remark", txtremark.Caption.Trim());//备注 //密码 if (cbois_operator.SelectedValue.ToString() == DataSources.EnumYesNo.Yes.ToString("d")) { dicFileds.Add("password", txtPassWord.Caption.Trim()); } else { dicFileds.Add("password", "");//密码 } dicFileds.Add("nation", cbonation.SelectedValue.ToString());//民族 dicFileds.Add("graduate_institutions", txtgraduate_institutions.Caption.Trim());//毕业学校 dicFileds.Add("technical_expertise", txttechnical_expertise.Caption.Trim());//技术特长 dicFileds.Add("user_height", txtuser_height.Caption.Trim());//身高 dicFileds.Add("native_place", txtnative_place.Caption.Trim());//籍贯 dicFileds.Add("specialty", txtspecialty.Caption.Trim());//专业 dicFileds.Add("entry_date", Common.LocalDateTimeToUtcLong(dtpentry_date.Value).ToString());// 入职日期 dicFileds.Add("user_weight", txtuser_weight.Caption.Trim());//体重 dicFileds.Add("register_address", txtregister_address.Caption.Trim());//户籍所在地 dicFileds.Add("graduate_date", Common.LocalDateTimeToUtcLong(dtpgraduate_date.Value).ToString());// 毕业时间 dicFileds.Add("wage", txtwage.Caption.Trim());// 工资 dicFileds.Add("birthday", Common.LocalDateTimeToUtcLong(dtpbirthday.Value).ToString());// 出生日期 dicFileds.Add("education", cboeducation.SelectedValue.ToString());//学历 dicFileds.Add("position", cboposition.SelectedValue.ToString());//岗位 dicFileds.Add("political_status", txtpolitical_status.Caption.Trim());//政治面貌 dicFileds.Add("level", cbolevel.SelectedValue.ToString());//级别 dicFileds.Add("health", cbojkzk.SelectedValue.ToString());//健康状况 string nowUtcTicks = Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(); dicFileds.Add("update_by", HXCPcClient.GlobalStaticObj.UserID); dicFileds.Add("update_time", nowUtcTicks); string crmId = string.Empty; if (wStatus == WindowStatus.Add || wStatus == WindowStatus.Copy) { dicFileds.Add("user_code", CommonUtility.GetNewNo(SYSModel.DataSources.EnumProjectType.User));//人员编码 newGuid = Guid.NewGuid().ToString(); currUser_id = newGuid; dicFileds.Add("user_id", newGuid);//新ID dicFileds.Add("create_by", HXCPcClient.GlobalStaticObj.UserID); dicFileds.Add("create_time", nowUtcTicks); dicFileds.Add("enable_flag", SYSModel.DataSources.EnumEnableFlag.USING.ToString("d"));//1为未删除状态 dicFileds.Add("status", SYSModel.DataSources.EnumStatus.Start.ToString("d"));//启用 dicFileds.Add("data_sources", Convert.ToInt16(SYSModel.DataSources.EnumDataSources.SELFBUILD).ToString());//来源 自建 } else if (wStatus == WindowStatus.Edit) { keyName = "user_id"; keyValue = id; currUser_id = id; newGuid = id; crmId = dr["cont_crm_guid"].ToString(); opName = "更新人员管理"; } bln = DBHelper.Submit_AddOrEdit(opName, "sys_user", keyName, keyValue, dicFileds); string photo = string.Empty; if (picuser.Tag != null) { photo = Guid.NewGuid().ToString() + Path.GetExtension(picuser.Tag.ToString()); if (!FileOperation.UploadFile(picuser.Tag.ToString(), photo)) { return; } } List<SQLObj> listSql = new List<SQLObj>(); listSql = AddPhoto(listSql, currUser_id, photo); ucAttr.TableName = "sys_user"; ucAttr.TableNameKeyValue = currUser_id; listSql.AddRange(ucAttr.AttachmentSql); DBHelper.BatchExeSQLMultiByTrans(opName, listSql); if (bln) { if (wStatus == WindowStatus.Add || wStatus == WindowStatus.Edit) { var cont = new tb_contacts_ex { cont_id = CommonCtrl.IsNullToString(newGuid),//id cont_name = CommonCtrl.IsNullToString(this.txtuser_name.Caption.Trim()),//name cont_post = CommonCtrl.IsNullToString(""),//post cont_phone = CommonCtrl.IsNullToString(this.txtuser_phone.Caption.Trim()), nation = CommonCtrl.IsNullToString(this.cbonation.SelectedValue.ToString()), parent_customer = CommonCtrl.IsNullToString(""), sex = UpSex(), status = CommonCtrl.IsNullToString(SYSModel.DataSources.EnumStatus.Start.ToString("d")), cont_post_remark = CommonCtrl.IsNullToString(""), cont_crm_guid = CommonCtrl.IsNullToString(crmId), contact_type = "02" }; Update.BeginInvoke("上传服务站工作人员", SYSModel.EnumWebServFunName.UpLoadCcontact, cont, null, null); //DBHelper.WebServHandlerByFun("上传服务站工作人员", SYSModel.EnumWebServFunName.UpLoadCcontact, cont); } if (this.RefreshDataStart != null) { this.RefreshDataStart(); } LocalCache._Update(CacheList.User); MessageBoxEx.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.None); deleteMenuByTag(this.Tag.ToString(), this.parentName); } else { MessageBoxEx.Show("保存失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }