public static List <TrdType> GetMyTrdType() { TrdType condition = new TrdType(); TrdType value = new TrdType(); condition.ExhibitionID = AdminMethod.ExhibitionID; List <TrdType> list = TableOperate <TrdType> .Select(value, condition); return(list); }
protected void Page_Load(object sender, EventArgs e) { TrdType condition = new TrdType(); TrdType value = new TrdType(); string title = GetstringKey("name"); if (title != "") { condition.TradeType = "%" + title + "%"; condition.AddAttach("TradeType", "like"); } condition.ExhibitionID = AdminMethod.ExhibitionID; m_tableManageList = TableOperate <TrdType> .SelectByPage(value, condition, "order by OrderID asc", PageSize, PageIndex, ref Count); DataBind(); name.Value = title; }
protected void AddLog(string ids) { TrdType condition = new TrdType(); TrdType value = new TrdType(); condition.AddConditon(" and id in(" + ids + ")"); List <TrdType> list = TableOperate <TrdType> .Select(value, condition); if (list.Count > 0) { string deltitle = ""; for (int i = 0; i < list.Count; i++) { deltitle += list[i].TradeType + ","; } deltitle = deltitle.TrimEnd(','); if (deltitle != "") { string logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "删除了【" + deltitle + "】的行业"; Lognet.AddLogin(logbrief); } } }
protected void Page_Load(object sender, EventArgs e) { string action = GetstringKey("action"); int ID = GetIntKey("ID"); TrdType condition = new TrdType(); TrdType v = new TrdType(); if (ID == 0) { Response.Write(""); return; } condition.ID = ID; TrdType myView = TableOperate <TrdType> .GetRowData(v, condition); if (myView.ID == 0) { Response.Write(""); return; } TrdType condition2 = new TrdType(); TrdType V2 = new TrdType(); condition2.AddConditon(" and ID<>'" + condition.ID + "'"); condition2.ExhibitionID = AdminMethod.ExhibitionID; string strOrder = string.Empty; condition2.OrderID = myView.OrderID; if (action == "up") { //向上,现在是时间越早越在上面 condition2.AddAttach("OrderID", "<"); strOrder = " order by OrderID DESC"; //时间从大到小 } else { condition2.AddAttach("OrderID", ">"); strOrder = " order by OrderID ASC"; } List <TrdType> desOrderMdl = TableOperate <TrdType> .Select(V2, condition2, 1, strOrder); if (desOrderMdl.Count != 1) { Response.Write(""); return; } TrdType conditionU = new TrdType(); conditionU.ID = myView.ID; conditionU.OrderID = desOrderMdl[0].OrderID; TableOperate <TrdType> .Update(conditionU); TrdType conditionU2 = new TrdType(); conditionU2.ID = desOrderMdl[0].ID; conditionU2.OrderID = myView.OrderID; TableOperate <TrdType> .Update(conditionU2); Response.StatusCode = 200; Response.Write(conditionU2.ID); }
protected void Page_Load(object sender, EventArgs e) { string action = GetstringKey("action"); if (action != "save") { if (!string.IsNullOrEmpty(this.Request["iD"])) { int _iD = Convert.ToInt32(this.Request["iD"]); TrdType condition = new TrdType(); condition.ID = _iD; news = TableOperate <TrdType> .GetRowData(condition); iD.Value = Convert.ToString(news.ID); } DataBind(); } else { Result result = new Result(); string logbrief = ""; TrdType newChannelNews = new TrdType(); newChannelNews.ID = 0; newChannelNews.AutoForm(this.Page); string Title = newChannelNews.TradeType; int _iD; if (!string.IsNullOrEmpty(this.Request["iD"])) { _iD = Convert.ToInt32(this.Request["iD"]); TableOperate <TrdType> .Update(newChannelNews); result.msg = "编辑成功,等待返回列表"; logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "编辑了为【" + Title + "】的行业"; } else { newChannelNews.AddTime = DateTime.Now; newChannelNews.AddID = AdminMethod.AdminID; newChannelNews.ExhibitionID = AdminMethod.ExhibitionID; newChannelNews.OrderID = CloudSQL.GetNowTime(); _iD = TableOperate <TrdType> .InsertReturnID(newChannelNews); result.msg = "添加成功,等待返回列表"; logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "添加了为【" + Title + "】的行业"; } if (_iD > 0) { result.isOk = true; Lognet.AddLogin(logbrief); } else { result.msg = "操作失败"; } Response.ContentType = "text/json"; Response.Write(new JavaScriptSerializer().Serialize(result)); Response.End(); } DataBind(); }
public Field(int tag, TrdType value) : this(tag, ((int)value).ToString()) { }