public void TestSortPlayers() { DataProcess _dataProcess = new DataProcess(); var result = _dataProcess.SortPlayers(players); Assert.IsAssignableFrom <List <Players> >(result); }
private void OnInsert() { var dataSourceUpdate = this.Categorys.Where(c => c.CategoryID <= 0).ToList(); DataProcess <Category> categoryDA = new DataProcess <Category>(); categoryDA.Insert(dataSourceUpdate.ToArray()); }
public static List <BSTerm> GetTerms(TermTypes termType, int iTermCount) { List <BSTerm> terms = new List <BSTerm>(); using (DataProcess dp = new DataProcess()) { string top = iTermCount == 0 ? String.Empty : "TOP " + iTermCount; if (termType != TermTypes.All) { dp.AddParameter("Type", termType.ToString().ToLowerInvariant()); dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms WHERE [Type]=@Type ORDER BY [Name] ASC", top)); } else { dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms ORDER BY [Name] ASC", top)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return(terms); }
public static List <BSTerm> GetTermsBySubID(TermTypes termType, int iSubID) { List <BSTerm> terms = new List <BSTerm>(); using (DataProcess dp = new DataProcess()) { if (termType != TermTypes.All) { dp.AddParameter("Type", termType.ToString().ToLowerInvariant()); dp.AddParameter("SubID", iSubID); dp.ExecuteReader("SELECT * FROM Terms WHERE [Type]=@Type AND [SubID]=@SubID ORDER BY [Name] ASC"); } else { dp.AddParameter("SubID", iSubID); dp.ExecuteReader("SELECT * FROM Terms WHERE [SubID]=@SubID ORDER BY [Name] ASC"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return(terms); }
public static List <BSWidget> GetWidgetsByColumnValue(string column, object value, int widgetCount, string orderBy) { List <BSWidget> widgets = new List <BSWidget>(); using (DataProcess dp = new DataProcess()) { string top = widgetCount > 0 ? "TOP " + widgetCount : String.Empty; if (!String.IsNullOrEmpty(column) && value != null) { dp.AddParameter(column, value); dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] WHERE [{1}]=@{1} {2}", top, column, orderBy)); } else { dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] {1}", top, orderBy)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return(widgets); }
public static List <BSWidget> GetWidgetsByPlaceHolder(string placeHolder, bool visible) { List <BSWidget> widgets = new List <BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("PlaceHolder", placeHolder); dp.AddParameter("Visible", visible); dp.ExecuteReader("SELECT * FROM [Widgets] WHERE [PlaceHolder]=@PlaceHolder AND [Visible]=@Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return(widgets); }
public static List <BSWidget> GetWidgetsBySorted() { List <BSWidget> widgets = new List <BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Visible", true); dp.ExecuteReader("SELECT * FROM Widgets WHERE [Visible] = @Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return(widgets); }
public Plat(string server_addr = "broadcast.eicp.net:55881") { InitializeComponent(); this.buttonLogin.Click += ButtonLogin_Click; this.buttonOffline.Click += Offline_Click; ReadServerConfig(); this.comboBoxServer.DataSource = _dtServer; this.comboBoxServer.DisplayMember = "txt"; this.comboBoxServer.ValueMember = "val"; if (File.Exists("./account.json")) { account = JsonConvert.DeserializeObject <Account>(File.ReadAllText("./account.json")); } //登录信息 this.comboBoxServer.DataBindings.Add("Text", account, "ServerName", false, DataSourceUpdateMode.OnPropertyChanged); this.textBoxUser.DataBindings.Add("Text", account, "Investor", false, DataSourceUpdateMode.OnPropertyChanged); this.textBoxAppID.DataBindings.Add("Text", account, "AppID", false, DataSourceUpdateMode.OnPropertyChanged); this.textBoxAuthCode.DataBindings.Add("Text", account, "AuthCode", false, DataSourceUpdateMode.OnPropertyChanged); this.textBoxProductInfo.DataBindings.Add("Text", account, "ProductInfo", false, DataSourceUpdateMode.OnPropertyChanged); _dataProcess = new DataProcess(server_addr); }
private void loadData() { DataProcess <Category> categoryDA = new DataProcess <Category>(); var dataSource = new ObservableCollection <Category>(categoryDA.Select()); this.Categorys = dataSource; }
private async void Refresh_Click(object sender, RoutedEventArgs e) { contentRing.IsActive = true; var htmlResources = await LNUWebProcess.GetLNUFromLeftRequest(MainPage.LoginClient, currentUri.ToString()); await CacheHelpers.SaveSpecificCacheValue(MainPage.LoginCache.UserID, htmlResources); var nameList = DataProcess.FetchScheduleTableFromHtml(htmlResources); TableGrid.Children.Clear(); // Show the schedule table InitTableView(nameList); var list = DataProcess.FetchScheduleListFromHtml(htmlResources); ScheduleQueue.Clear(); ScheduleQueue.AddRange(list); nameList.ForEach(item => { // finish lecture message into ScheduleQueue items . ScheduleQueue.FindAll(i => i.Title == GetSingleTitle(item.WholeTitle)).ForEach(s => { if (s.Lecturer == null) { s.Lecturer = GetLecturerName(item.WholeTitle); } }); }); CourseListView.ItemsSource = ScheduleQueue; contentRing.IsActive = false; }
private void btn_Go_Click(object sender, EventArgs e) { if (!IsFinishConfig) { OpenSettingDig(); } if (!IsFinishConfig) { MessageBox.Show("未设置组"); return; } UpdateDest(); List <DataTable> ds = new List <DataTable>() { DataProcess.T1(DestInfos), DataProcess.T2(DestInfos), DataProcess.T2_5(DestInfos), DataProcess.T4(DestInfos), DataProcess.T3(DestInfos), DataProcess.T5(DestInfos) }; int index = 0; string[] names = Common.GetConfig("T_Names").Split(','); ds.ForEach(x => x.TableName = names[index++]); NPOIHelper.ExportSimple(ds, "C:\\1q.xlsx"); MessageBox.Show("导出完成"); }
public static List <BSPost> GetPostsByTitle(string title, int iUserId) { List <BSPost> posts = new List <BSPost>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Title", title); if (iUserId == 0) { dp.ExecuteReader("SELECT * FROM [Posts] WHERE [Title] LIKE '%' + @Title + '%' ORDER By [CreateDate] DESC,[Title]"); } else { dp.AddParameter("UserID", iUserId); dp.ExecuteReader("SELECT * FROM [Posts] WHERE [Title] LIKE '%' + @Title + '%' AND [UserID]=@UserID ORDER By [CreateDate] DESC,[Title]"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSPost bsPost = new BSPost(); FillPost(dr, bsPost); posts.Add(bsPost); } } } } return(posts); }
/// <summary> /// 外部调用 /// </summary> /// <param name="applyID"></param> public void PrintPreviewInvoke(string applyID) { DataProcess dp = (DataProcess)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(DataProcess)); DataTable ds = dp.SqlSelect("select * from AR_COMMON_APPLY where ApplyID = " + applyID); this.dr = ds.Rows[0]; }
private async void Pivot_SelectionChanged(object sender, SelectionChangedEventArgs e) { MainPage.Current.BaseListRing.IsActive = true; GridViewResources.Source = null; var args = (sender as Pivot).SelectedItem as BarItemModel; if (args == null) { MainPage.Current.BaseListRing.IsActive = false; return; } MainPage.ChangeTitlePath(3, (sender as Pivot).SelectedIndex == 0 ? null : args.Title); ArgsPathKey = args.PathUri.ToString(); if (IfContainsListInstance(ArgsPathKey)) { GridViewResources.Source = GetListInstance(ArgsPathKey); MainPage.Current.BaseListRing.IsActive = false; return; } if (IfContainsAGVInstance(ArgsPathKey)) { GetAGVInstance(ArgsPathKey).Opacity = 0; } var newList = DataProcess.FetchNewsPreviewFromHtml( (await WebProcess.GetHtmlResources( ArgsPathKey, false)) .ToString()); GridViewResources.Source = newList; GetAGVInstance(ArgsPathKey).Opacity = 1; AddResourcesInDec(ArgsPathKey, newList); MainPage.Current.BaseListRing.IsActive = false; }
protected void BindData() { DataProcess.DepartmentBind(department); DataProcess.PoliticBind(PolDP); DataProcess.XueliBind(XueliDP); if (zpitmid != -1) { YpFbList.DataSource = FTInterviewBLL.ZhaopinFbManage.GetAllZhaopinItem(zpitmid); YpFbList.DataBind(); } YpFbList.Items.Insert(0, new ListItem("请选择", "-1")); if (ypzid != -1) { Yingpinzhe ypz = FTInterviewBLL.YingpinzheManage.GetYingpinzheById(ypzid); name.Value = ypz.Name; SexDP.SelectedValue = ypz.Sex; Birthday.Value = ypz.Birthday; department.SelectedValue = ypz.DepartId + ""; Duty.Value = ypz.PositionName; XueliDP.SelectedValue = ypz.XueliId + ""; join_time.Value = ypz.JoinTime; PolDP.SelectedValue = ypz.PoliticId + ""; //ZhaopinGw zg = FTInterviewBLL.ZhaopinGwManage.GetZhaopinGwByid(ypz.ZpfbId); YpFbList.SelectedValue = ypz.ZpfbId + ""; } }
void Comment_Approved(object sender, EventArgs e) { BSComment bsComment = (BSComment)sender; if (bsComment.Approve) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("PostID", bsComment.PostID); dp.AddParameter("NotifyMe", true); dp.AddParameter("Approve", true); dp.ExecuteReader("SELECT DISTINCT Email FROM Comments WHERE PostID=@PostID AND NotifyMe=@NotifyMe AND Approve=@Approve"); if (dp.Return.Status == DataProcessState.Success) { BSPost bsPost = BSPost.GetPost(bsComment.PostID); using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { string strEmail = (string)dr["Email"]; System.Threading.ThreadPool.QueueUserWorkItem(delegate { BSHelper.SendMail(Language.Get["NewCommentNotice"], Blogsa.Settings["smtp_email"].ToString(), Blogsa.Settings["smtp_name"].ToString() , strEmail, "", Language.Get["NewCommentNoticeDescription"] + "<br><br><a href=\"" + bsPost.Link + "\">" + bsPost.Title + "</a>", true); }); } } } } } }
/// <summary> /// 写入文章的回帖 /// </summary> /// <param name="PostId"></param> /// <returns></returns> public ActionResult WritePoastReply() { try { IdentityTicket user = IdentityManager.GetIdentFromAll(); if (user == null || user.IsLife == false) { //这边应该做一个跳转操作的 -- 待写 //return RedirectToAction("Login", "User"); return(DataProcess.Failure("先登入吧~").ToMvcJson()); } string content = Request.Form["content"]; string pid = Request.Form["pid"]; //如果存在@则代表为二级回复 if (content.Contains('@')) { //pid = pid.Split('@')[1];//由于之前做二级回帖用到 return(PostsContract.WritePoastReplyClone(user.UserId, pid, content).ToMvcJson("yyyy-MM-dd HH:mm:ss")); } else { //PostsContract.WritePoastReply(user.UserId, PostId, content); return(PostsContract.WritePoastReply(user.UserId, pid, content).ToMvcJson("yyyy-MM-dd HH:mm:ss")); } } catch (Exception ex) { return(DataProcess.Failure("写回帖出错了").ToMvcJson()); } }
//获取存档文件,并初始化 public KeepData GetSaveData(bool isInit = false) { //强制初始化,并返回 if (isInit) { InitSaveData(); return(_save); } // 如果save为null if (_save == null) { //如果save不存在,对save文件进行初始化 if (!DataProcess.IsGameDataExist(_SAVE_NAME)) { Debug.Log("不存在存档"); InitSaveData(); return(_save); } //存在存档文件,读取并返回 _save = LoadGameData(); Debug.Log(_save._Gold); return(_save); } //如果存档已存在,直接返回 return(_save); }
private async Task <ItemGroup <BookItem> > FetchMessageFromAPIAsync( string headString, string loc_id = "108288", uint start = 0, uint count = 8, int offset = 0) { var gmodel = default(ItemGroup <BookItem>); try { var minised = (DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc)).TotalMilliseconds; var result = await BeansproutRequestHelper.FetchTypeCollectionList(headString, loc_id, start, count, minised, SubjectType.Music); if (result == null) { ReportWhenGoesWrong("WebActionError"); return(gmodel); } JObject jo = JObject.Parse(result); gmodel = DataProcess.SetGroupResources(jo, gmodel); gmodel = SetSingletonResources(jo, gmodel); } catch { ReportHelper.ReportAttentionAsync(GetUIString("FetchJsonDataError")); } IncrementalLoadingBorder.SetVisibility(false); return(gmodel); }
public FileStreamResult DownAnaysleFile(int id) { string dataPath = GetDataPath(id.ToString()); List <StatsisLib.BaseDataInfo> infos = null; if (!System.IO.File.Exists(dataPath)) { return(null); } else { infos = infos.Deserialize(dataPath); } UnionLib.AnaysleService service = new UnionLib.AnaysleService(); var tb = DataProcess.T1_0(infos); tb.TableName = "调整后的"; string path = GetDataPath_excel(id.ToString()); NPOIHelper.ExportSimple(new List <System.Data.DataTable>() { tb }, path); var fileStream = new FileStream(path, FileMode.Open); return(File(fileStream, "application/octet-stream", Server.UrlEncode(path))); }
private void LoadData() { DataProcess <News_Catagories> daNewCategory = new DataProcess <News_Catagories>(); rptNewsCategory.DataSource = daNewCategory.Select(); rptNewsCategory.DataBind(); }
public static int GetReadCounts(int iPostID) { using (DataProcess dp = new DataProcess()) { if (iPostID > 0) { dp.AddParameter("PostID", iPostID); dp.ExecuteScalar("SELECT SUM([ReadCount]) FROM Posts WHERE [PostID] = @PostID"); } else { dp.ExecuteScalar("SELECT SUM([ReadCount]) FROM Posts"); } if (dp.Return.Status == DataProcessState.Success) { if (dp.Return.Value != DBNull.Value) { return(Convert.ToInt32(dp.Return.Value)); } else { return(0); } } } return(0); }
private void SetID() { if (SaveOldID == "") { DataProcess.SetCanID(txtCanID.Text); DataProcess.SendOrderToCan(AdjustID(1, txtCanID.Text)); } else { if (SaveOldID != txtCanID.Text) { DataProcess.SendOrderToCan(AdjustID(1, txtCanID.Text)); System.Threading.Thread.Sleep(50); DataProcess.SetCanID(txtCanID.Text); } else { DataProcess.SendOrderToCan(AdjustID(1, txtCanID.Text)); DataProcess.SetCanID(txtCanID.Text); } } SaveOldID = txtCanID.Text; DataProcess.SendOrderToCan(AdjustSleep(ComboSleep.SelectedIndex)); DataProcess.SendOrderToCan(Adjustwatchdog(Combowatchdog.SelectedIndex)); // DataProcess.SetCanID(SaveOldID); }
//打开下拉框 private void SerialSclectComBox_DropDownOpened(object sender, EventArgs e) { //每次点击串口选择下拉框时获取当前电脑上的com设备,并判断是否在下拉框中,如果没有,则添加 List <string> ComList = new List <string>(); ComList = DataProcess.GetSerialPortInfo(); try { foreach (string PerCom in ComList) { if (!SerialSclectComBox.DropDownItems.ContainsKey(PerCom)) { ToolStripMenuItem toolStripItem = new ToolStripMenuItem(); toolStripItem.Name = PerCom; toolStripItem.CheckOnClick = true; toolStripItem.Text = PerCom; SerialSclectComBox.DropDownItems.Add(toolStripItem); } } } catch { return; } }
//窗体加载 private void Form1_Load(object sender, EventArgs e) { List <string> ComList = new List <string>(); //窗口初始化首先获取串口连接信息,用于渲染下拉菜单 ComList = DataProcess.GetSerialPortInfo(); try { foreach (string PerCom in ComList) { ToolStripMenuItem toolStripItem = new ToolStripMenuItem(); //新创建一个下拉菜单项 toolStripItem.Name = PerCom; // toolStripItem.CheckOnClick = true; toolStripItem.Text = PerCom; //text SerialSclectComBox.DropDownItems.Add(toolStripItem); //添加到下拉列表中 } } catch { return; } //插入树节点 LoadTreeNodes(); flashToolStripMenuItem.SelectedIndex = 0; }
private void KullaniciAdlariniDoldur() { try { DataTable dt = new DataProcess().GetDataTableFromList(entities.user.ToList()); cboxKadi.DataSource = entities.user.ToList(); cboxKadi.DisplayMember = "name"; cboxKadi.ValueMember = "id"; cboxKadi.Invalidate(); if (cboxKadi.Items.Count > 0) { // int varsayilanId = Convert.ToInt32(Settings.Default.VarsayilanKullanici); int varsayilanId = 1; if (varsayilanId != 1) { cboxKadi.SelectedValue = varsayilanId; } if (cboxKadi.SelectedValue == null || varsayilanId == 1) { cboxKadi.SelectedItem = cboxKadi.Items[0]; } } } catch (Exception ex) { ShowMessage.Error("Lütfen tekrar deneyin. Eğer sorununuz devam ediyorsa sistem yöneticisine başvurmayı deneyin.\n\nAyrıca http://www.kodvizit.com adresinden de destek alabilirsiniz.\n\n" + ex.Message.ToString()); Log.Error("[Veri Çekme Hatası] Kullanıcı isimleri doldurulamadı", ex); } }
//获取当前用户对当前帖子的收藏状态 public ActionResult GetTitleState(string PostId) { try { if (PostId == "" || PostId == null) { return(DataProcess.Failure().ToMvcJson()); } IdentityTicket identtity = IdentityManager.GetIdentFromAll(); if (identtity != null) { if (PostsContract.JudgePostByUserId(identtity.UserId, PostId).Success) { return(PostsContract.GetCollectState(identtity.UserId, PostId).ToMvcJson()); } else { return(DataProcess.Failure().ToMvcJson()); } } else { return(DataProcess.Failure().ToMvcJson()); } } catch (Exception ex) { return(DataProcess.Failure(ex.Message).ToMvcJson()); } }
public string GenerateRefNo(string connectionString, string companyID, string branchID, DateTime requisitionDate, int refNoFor) { DateTime dt = Convert.ToDateTime(requisitionDate); int maxnofromDate; string refno; string SQLStatement; maxnofromDate = 0; refno = clsDateProcess.DateToNumber(requisitionDate); // By Date SQLStatement = "select count(ItemRequisitionNo)+1 as ItemRequisitionMaxNo from ItemRequisitionHeader WHERE RequisitionDate =convert(datetime,'" + requisitionDate + "',103) and CompanyID = " + companyID + " AND BranchID = " + branchID + ""; maxnofromDate = DataProcess.GetMaximumValueUsingSQL(connectionString, SQLStatement); refno = refno + string.Format("{0:00}", maxnofromDate); // By Month SQLStatement = "select count(ItemRequisitionNo)+1 as ItemRequisitionMaxNo from ItemRequisitionHeader WHERE month(RequisitionDate) =" + requisitionDate.Month + " and year(RequisitionDate) =" + requisitionDate.Year + " and CompanyID = " + companyID + " AND BranchID = " + branchID + ""; maxnofromDate = DataProcess.GetMaximumValueUsingSQL(connectionString, SQLStatement); refno = refno + string.Format("{0:0000}", maxnofromDate); return(refno); }
static void Main(string[] args) { Console.Write("Use default StoreId, ItemId and 4 weeks to predict? "); var useDefault = Console.ReadLine().ToUpper() == "Y"; DataProcess dataprocess = new DataProcess(); var predictionList = new List <ForecastingData>(); if (useDefault) { var data = dataprocess.GetProcessedDataForScore(storeID1: 2, itemID2: 1, weeksToPredict: 4); predictionList = data.TakeLast(4).ToList(); } else { // Get values from user to parse dataset. Console.Write("Enter Store Id: "); var storeId = Convert.ToInt32(Console.ReadLine()); Console.Write("Enter Item Id: "); var itemId = Convert.ToInt32(Console.ReadLine()); Console.Write("Enter weeks to predict: "); var weeksToPredict = Convert.ToInt32(Console.ReadLine()); // Get processed data. var data = dataprocess.GetProcessedDataForScore(storeId, itemId, weeksToPredict); predictionList = data.TakeLast(weeksToPredict).ToList(); } //Post to api for predictions InvokeRequestResponseService(predictionList).Wait(); }
public KeepData LoadGameData() { //读取文档 KeepData readGold = DataProcess.LoadGameData(typeof(KeepData), _SAVE_NAME, false) as KeepData; return(readGold); }
void Comment_Approved(object sender, EventArgs e) { BSComment bsComment = (BSComment)sender; if (bsComment.Approve) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("PostID", bsComment.PostID); dp.AddParameter("NotifyMe", true); dp.AddParameter("Approve", true); dp.ExecuteReader("SELECT DISTINCT Email FROM Comments WHERE PostID=@PostID AND NotifyMe=@NotifyMe AND Approve=@Approve"); if (dp.Return.Status == DataProcessState.Success) { BSPost bsPost = BSPost.GetPost(bsComment.PostID); using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { string strEmail = (string)dr["Email"]; System.Threading.ThreadPool.QueueUserWorkItem(delegate { BSHelper.SendMail(Language.Get["NewCommentNotice"], Blogsa.Settings["smtp_email"].ToString(), Blogsa.Settings["smtp_name"].ToString() , strEmail, "", Language.Get["NewCommentNoticeDescription"] + "<br><br><a href=\"" + bsPost.Link + "\">" + bsPost.Title + "</a>", true); }); } } } } } }
public static string GetWidgetState(string FolderName) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("FolderName", FolderName); dp.ExecuteScalar("SELECT WidgetID FROM Widgets WHERE FolderName = @FolderName"); if (dp.Return.Status == DataProcessState.Success) return (string)dp.Return.Value; else return string.Empty; } }
public void SaveData(int ObjectID) { using (DataProcess dp = new DataProcess()) { BSTerm.RemoveTo(TermTypes.Category, ObjectID); for (int i = 0; i < cblCats.Items.Count; i++) { if (cblCats.Items[i].Selected == true) { BSTerm bsTerm = BSTerm.GetTerm(Convert.ToInt32(cblCats.Items[i].Value)); bsTerm.Objects.Add(ObjectID); bsTerm.Save(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (String.IsNullOrEmpty(SearchText)) Response.Redirect("~/"); using (DataProcess dp = new DataProcess()) { try { dp.AddParameter("Content", SearchText); dp.ExecuteReader("SELECT * FROM Posts WHERE Type = 0 AND State = 1 AND (Content LIKE @Content + ' %' OR Content LIKE '% ' + @Content OR Content LIKE '% ' + @Content + ' %')"); int p = 0; int.TryParse(Request["p"], out p); p = p == 0 ? 1 : p; IDataReader dr = dp.Return.Value as IDataReader; List<BSPost> posts = new List<BSPost>(); while (dr.Read()) { BSPost post = new BSPost(); BSPost.FillPost(dr, post); posts.Add(post); } if (posts.Count > 0) { ltResult.Text = String.Format(Language.Get["SearchFoundedItemCount"], String.Format("<b>{0}</b>", posts.Count)); } else ltResult.Text = Language.Get["SearchNotFound"]; ltPaging.Visible = posts.Count > 0; rpSearch.DataSource = Data.Paging(posts, p, ltPaging); rpSearch.DataBind(); } catch (Exception) { } } }
protected void Page_Load(object sender, EventArgs e) { try { List<BSPost> posts = new List<BSPost>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("PostID", BSPost.CurrentPost.PostID); dp.AddParameter("Title", BSPost.CurrentPost.Title); dp.ExecuteReader("SELECT TOP 5 * FROM Posts WHERE [PostID]<>@PostID AND [Type]=0 AND [State]=1 AND ([Title] Like '%'+@Title+'%' OR Content Like '%'+@Title+'%') ORDER BY [CreateDate] DESC"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSPost bsPost = new BSPost(); BSPost.FillPost(dr, bsPost); posts.Add(bsPost); } } } } if (posts.Count > 0) { rpRelatedPosts.DataSource = posts; rpRelatedPosts.DataBind(); } else this.Visible = false; } catch (System.Exception ex) { } }
public bool Save() { using (DataProcess dp = new DataProcess()) { dp.AddParameter("ParentID", this.ParentID); dp.AddParameter("UserID", this.UserID); dp.AddParameter("Code", this.Code); dp.AddParameter("State", this.State); string sql = "INSERT INTO Sites([ParentID],[UserID],[Code],[State]) " + "VALUES(@ParentID,@UserID,@Code,@State);"; if (SiteID != 0) { sql = "UPDATE Settings SET [ParentID]=@ParentID,[UserID]=@UserID,[Code]=@Code,[State]=@State WHERE [SiteID] = @SiteID;"; dp.AddParameter("SiteID", this.SiteID); } dp.ExecuteNonQuery(sql); return dp.Return.Status == DataProcessState.Success; } }
private List<object> GenerateData(object entity, string gridName, List<SoaDataGridColumn> columns) { Dictionary<string, object> dict; using (DataProcess dp = new DataProcess()) { dict = dp.Process(entity, gridName); } List<object> ret = new List<object>(); foreach (SoaDataGridColumn col in columns) { if (dict.ContainsKey(col.Name)) { ret.Add(dict[col.Name]); } else { object o = null; try { o = EntityHelper.GetPropertyValue(entity, col.Name); } catch (Exception) // 不一定有这个属性,例如大写金额 { } ret.Add(o); } } return ret; }
public static List<BSWidget> GetWidgetsByColumnValue(string column, object value, int widgetCount, string orderBy) { List<BSWidget> widgets = new List<BSWidget>(); using (DataProcess dp = new DataProcess()) { string top = widgetCount > 0 ? "TOP " + widgetCount : String.Empty; if (!String.IsNullOrEmpty(column) && value != null) { dp.AddParameter(column, value); dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] WHERE [{1}]=@{1} {2}", top, column, orderBy)); } else { dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] {1}", top, orderBy)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return widgets; }
public static BSSettings GetSettings() { BSSettings settings = new BSSettings(); using (DataProcess dp = new DataProcess()) { dp.ExecuteReader("SELECT * FROM Settings"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSSetting bsSetting = new BSSetting(); FillValue(dr, bsSetting); settings.Add(bsSetting); } } } } return settings; }
public bool Remove() { using (DataProcess dp = new DataProcess()) { //CancelEventArgs cancelEvent = new CancelEventArgs(); //OnDeleting(this, cancelEvent); //if (!cancelEvent.Cancel) //{ dp.AddParameter("MenuGroupID", MenuGroupID); dp.ExecuteNonQuery("DELETE FROM [MenuGroups] WHERE [MenuGroupID] = @MenuGroupID"); if (dp.Return.Status == DataProcessState.Success) { //OnDeleted(this, null); return true; } //} } return false; }
public static BSMenuGroup GetDefault() { using (DataProcess dp = new DataProcess()) { dp.AddParameter("Default", true); dp.ExecuteReader("SELECT * FROM [MenuGroups] WHERE [Default]=@Default"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSMenuGroup menuGroup = new BSMenuGroup(); FillMenuGroup(dr, menuGroup); return menuGroup; } } } } BSMenuGroup defaultMenuGroup = new BSMenuGroup(); return defaultMenuGroup; }
public bool Remove() { using (DataProcess dp = new DataProcess()) { CancelEventArgs cancelEvent = new CancelEventArgs(); OnDeleting(this, cancelEvent); if (!cancelEvent.Cancel) { dp.AddParameter("CommentID", CommentID); dp.ExecuteNonQuery("DELETE FROM Comments WHERE [CommentID] = @CommentID"); if (dp.Return.Status == DataProcessState.Success) { OnDeleted(this, null); return true; } } } return false; }
public static BSMenuGroup GetMenuGroup(string menuCode) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("Code", menuCode); dp.ExecuteReader("SELECT * FROM [MenuGroups] WHERE [Code]=@Code"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSMenuGroup menuGroup = new BSMenuGroup(); FillMenuGroup(dr, menuGroup); return menuGroup; } } } } return null; }
public static List<BSWidget> GetWidgets() { List<BSWidget> widgets = new List<BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.ExecuteReader("SELECT * FROM [Widgets] ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return widgets; }
public bool Save() { bool bReturnValue = false; using (DataProcess dp = new DataProcess()) { dp.AddParameter("UserID", UserID); dp.AddParameter("PostID", PostID); dp.AddParameter("Name", UserName); dp.AddParameter("Comment", Content); dp.AddParameter("Email", Email); dp.AddParameter("WebPage", WebPage); dp.AddParameter("Ip", IP); dp.AddParameter("CreateDate", Date); dp.AddParameter("Approve", Approve); dp.AddParameter("NotifyMe", NotifyMe); if (CommentID != 0) { dp.AddParameter("CommentID", CommentID); dp.ExecuteNonQuery("UPDATE Comments SET [UserID]=@UserID,[PostID]=@PostID,[Name]=@Name,[Comment]=@Comment," + "[Email]=@Email,[WebPage]=@WebPage,[Ip]=@Ip,[CreateDate]=@CreateDate,[Approve]=@Approve,[NotifyMe]=@NotifyMe WHERE [CommentID] = @CommentID"); bReturnValue = dp.Return.Status == DataProcessState.Success; } else { dp.ExecuteNonQuery("INSERT INTO Comments([UserID],[PostID],[Name],[Comment],[Email],[WebPage],[Ip],[CreateDate],[Approve],[NotifyMe]) " + "VALUES(@UserID,@PostID,@Name,@Comment,@Email,@WebPage,@Ip,@CreateDate,@Approve,@NotifyMe)"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { CommentID = Convert.ToInt32(dp.Return.Value); } } } } return bReturnValue; }
public static List<BSMenu> GetMenus(int menuGroupID) { List<BSMenu> menus = new List<BSMenu>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("MenuGroupID", menuGroupID); dp.ExecuteReader("SELECT * FROM [Menus] WHERE [MenuGroupID]=@MenuGroupID ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSMenu menu = new BSMenu(); FillMenu(dr, menu); menus.Add(menu); } } } } return menus; }
public static BSSetting GetSetting(int iSettingID) { BSSetting bsSetting = new BSSetting(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("SettingID", iSettingID); dp.ExecuteReader("SELECT * FROM Settings WHERE SettingID = @SettingID"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr.Read()) { FillValue(dr, bsSetting); return bsSetting; } } } } return null; }
public bool Save() { DataProcess dp = new DataProcess(); string sql = String.Empty; if (SettingID == 0) sql = "INSERT INTO Settings([SiteID],[Name],[Value],[Title],[Description],[Main],[Sort],[Visible]) " + "VALUES(@SiteID,@Name,@Value,@Title,@Description,@Main,@Sort,@Visible);"; else sql = "UPDATE Settings SET [SiteID]=@SiteID,[Name]=@Name,[Value]=@Value,[Title]=@Title,[Description]=@Description,[Main]=@Main,[Sort]=@Sort,[Visible]=@Visible WHERE [SettingID] = @SettingID;"; dp.AddParameter("SiteID", this.SiteID); dp.AddParameter("Name", this.Name); dp.AddParameter("Value", this.Value); dp.AddParameter("Title", this.Title); dp.AddParameter("Description", this.Description); dp.AddParameter("Main", this.Main); dp.AddParameter("Sort", this.Sort); dp.AddParameter("Visible", this.Visible); if (SettingID != 0) dp.AddParameter("SettingID", this.SettingID); dp.ExecuteNonQuery(sql); return dp.Return.Status == DataProcessState.Success; }
public bool Save() { bool bReturnValue = false; using (DataProcess dp = new DataProcess()) { dp.AddParameter("SiteID", this.SiteID); dp.AddParameter("Description", this.Description); dp.AddParameter("FolderName", this.FolderName); dp.AddParameter("PlaceHolder", this.PlaceHolder); dp.AddParameter("Sort", this.Sort); dp.AddParameter("Title", this.Title); dp.AddParameter("Visible", this.Visible); dp.AddParameter("Type", this.Type); dp.AddParameter("LanguageCode", this.LanguageCode); if (WidgetID != 0) { dp.AddParameter("WidgetID", WidgetID); dp.ExecuteNonQuery("UPDATE Widgets SET [SiteID]=@SiteID,[Description]=@Description,[FolderName]=@FolderName,[PlaceHolder]=@PlaceHolder,[Sort]=@Sort," + "[Title]=@Title,[Visible]=@Visible,[Type]=@Type,[LanguageCode]=@LanguageCode WHERE [WidgetID] = @WidgetID"); bReturnValue = dp.Return.Status == DataProcessState.Success; } else { dp.ExecuteNonQuery("INSERT INTO Widgets([SiteID],[Description],[FolderName],[PlaceHolder],[Sort],[Title],[Visible],[Type],[LanguageCode]) " + "VALUES(@SiteID,@Description,@FolderName,@PlaceHolder,@Sort,@Title,@Visible,@Type,@LanguageCode)"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { WidgetID = Convert.ToInt32(dp.Return.Value); } } } } return bReturnValue; }
public bool DoApprove(bool bApprove) { CancelEventArgs eventArgs = new CancelEventArgs(); BSComment bsComment = GetComment(CommentID); OnApproving(bsComment, eventArgs); if (!eventArgs.Cancel) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("Approve", bApprove); dp.AddParameter("CommentID", CommentID); dp.ExecuteNonQuery("UPDATE Comments SET [Approve]=@Approve WHERE [CommentID]=@CommentID"); if (dp.Return.Status == DataProcessState.Success) { bsComment.Approve = bApprove; OnApproved(bsComment, null); return true; } } } return false; }
public static List<BSWidget> GetWidgetsBySorted() { List<BSWidget> widgets = new List<BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Visible", true); dp.ExecuteReader("SELECT * FROM Widgets WHERE [Visible] = @Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return widgets; }
public static List<BSComment> GetCommentsByUserID(int iUserID, CommentStates state) { List<BSComment> comments = new List<BSComment>(); using (DataProcess dp = new DataProcess()) { if (state == CommentStates.All) { dp.AddParameter("UserID", iUserID); dp.ExecuteReader("SELECT * FROM Comments WHERE [UserID]=@UserID ORDER By CreateDate DESC"); } else { dp.AddParameter("UserID", iUserID); dp.AddParameter("Approve", state == CommentStates.Approved); dp.ExecuteReader("SELECT * FROM Comments WHERE [UserID]=@UserID AND [Approve]=@Approve ORDER By CreateDate DESC"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSComment bsComment = new BSComment(); FillComment(dr, bsComment); comments.Add(bsComment); } } } } return comments; }
public static List<BSMenuGroup> GetMenuGroups() { List<BSMenuGroup> menuGroups = new List<BSMenuGroup>(); using (DataProcess dp = new DataProcess()) { dp.ExecuteReader("SELECT * FROM [MenuGroups]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSMenuGroup menuGroup = new BSMenuGroup(); FillMenuGroup(dr, menuGroup); menuGroups.Add(menuGroup); } } } } return menuGroups; }
public static List<BSComment> GetComments(CommentStates state, int iCommentCount) { List<BSComment> comments = new List<BSComment>(); using (DataProcess dp = new DataProcess()) { string top = iCommentCount == 0 ? String.Empty : "TOP " + iCommentCount; if (state == CommentStates.All) { dp.ExecuteReader(String.Format("SELECT {0} * FROM Comments ORDER By CreateDate DESC", top)); } else { dp.AddParameter("Approve", state == CommentStates.Approved); dp.ExecuteReader(String.Format("SELECT {0} * FROM Comments WHERE [Approve]=@Approve ORDER By CreateDate DESC", top)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSComment bsComment = new BSComment(); FillComment(dr, bsComment); comments.Add(bsComment); } } } } return comments; }
public bool Save() { bool bReturnValue = false; using (DataProcess dp = new DataProcess()) { if (this.Default) { dp.AddParameter("Default", false); dp.ExecuteNonQuery("UPDATE [MenuGroups] SET [Default]=@Default"); } dp.AddParameter("SiteID", this.SiteID); dp.AddParameter("Code", this.Code); dp.AddParameter("Description", this.Description); dp.AddParameter("Title", this.Title); dp.AddParameter("Default", this.Default); dp.AddParameter("LanguageCode", this.LanguageCode); if (MenuGroupID != 0) { dp.AddParameter("MenuGroupID", this.MenuGroupID); dp.ExecuteNonQuery("UPDATE [MenuGroups] SET [SiteID]=@SiteID,[Code]=@Code,[Description]=@Description,[Title]=@Title,[Default]=@Default,[LanguageCode]=@LanguageCode WHERE [MenuGroupID] = @MenuGroupID"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { foreach (BSMenu bsMenu in Menu) { bsMenu.Save(); } } } else { dp.ExecuteNonQuery("INSERT INTO [MenuGroups]([SiteID],[Code],[Description],[Title],[Default],[LanguageCode]) VALUES(@SiteID,@Code,@Description,@Title,@Default,@LanguageCode)"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { foreach (BSMenu bsMenu in Menu) { bsMenu.Save(); } dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { MenuGroupID = Convert.ToInt32(dp.Return.Value); } } } } return bReturnValue; }
public static BSComment GetComment(int iCommentID) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("CommentID", iCommentID); dp.ExecuteReader("SELECT * FROM Comments WHERE [CommentID]=@CommentID"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSComment bsComment = new BSComment(); FillComment(dr, bsComment); return bsComment; } } } } return null; }
public static List<BSWidget> GetWidgetsByPlaceHolder(string placeHolder, bool visible) { List<BSWidget> widgets = new List<BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("PlaceHolder", placeHolder); dp.AddParameter("Visible", visible); dp.ExecuteReader("SELECT * FROM [Widgets] WHERE [PlaceHolder]=@PlaceHolder AND [Visible]=@Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return widgets; }
public static void Delete(int iCommentID) { CancelEventArgs eventArgs = new CancelEventArgs(); BSComment bsComment = GetComment(iCommentID); BSComment.OnDeleting(bsComment, eventArgs); if (!eventArgs.Cancel) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("CommentID", iCommentID); dp.ExecuteReader("DELETE FROM Comments WHERE [CommentID]=@CommentID"); if (dp.Return.Status == DataProcessState.Success) { BSComment.OnDeleted(bsComment, EventArgs.Empty); } } } }
public static BSMenu GetMenu(int menuID) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("MenuID", menuID); dp.ExecuteReader("SELECT * FROM [Menus] WHERE [MenuID]=@MenuID"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSMenu menu = new BSMenu(); FillMenu(dr, menu); return menu; } } } } return null; }
public bool Save() { bool bReturnValue = false; using (DataProcess dp = new DataProcess()) { dp.AddParameter("Description", this.Description); dp.AddParameter("MenuGroupID", this.MenuGroupID); dp.AddParameter("MenuType", (short)this.MenuType); dp.AddParameter("ObjectID", this.ObjectID); dp.AddParameter("ObjectType", (short)this.ObjectType); dp.AddParameter("ParentID", this.ParentID); dp.AddParameter("Sort", this.Sort); dp.AddParameter("Target", this.Target); dp.AddParameter("Title", this.Title); dp.AddParameter("Url", this.Url); if (MenuID != 0) { dp.AddParameter("MenuID", MenuID); dp.ExecuteNonQuery("UPDATE [Menus] SET [Description]=@Description,[MenuGroupID]=@MenuGroupID,[MenuType]=@MenuType," + "[ObjectID]=@ObjectID,[ObjectType]=@ObjectType,[ParentID]=@ParentID,[Sort]=@Sort,[Target]=@Target,[Title]=@Title,[Url]=@Url WHERE [MenuID] = @MenuID"); bReturnValue = dp.Return.Status == DataProcessState.Success; } else { dp.ExecuteNonQuery("INSERT INTO [Menus]([Description],[MenuGroupID],[MenuType],[ObjectID],[ObjectType],[ParentID],[Sort],[Target],[Title],[Url]) " + "VALUES(@Description,@MenuGroupID,@MenuType,@ObjectID,@ObjectType,@ParentID,@Sort,@Target,@Title,@Url)"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { MenuID = Convert.ToInt32(dp.Return.Value); } } } } return bReturnValue; }