/// <summary> /// /// </summary> /// <param name="info"></param> /// <returns></returns> public int UpdateSysModel(SysModel info) { string strSql = ""; if (this.Sql.GetSql("Manager.SysModelManager.UpdateSysModel", ref strSql) == -1) { return(-1); } try { strSql = string.Format(strSql, info.SysCode, info.SysName, info.SortId, this.Operator.ID); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(-1); } try { return(this.ExecNoQuery(strSql)); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(-1); } }
/// <summary> /// /// </summary> public ArrayList LoadAll() { string sqlstring = PrepareSQL("Manager.SysModelManager.LoadAll", null); ArrayList SysModels = new ArrayList(); if (sqlstring == string.Empty) { return(SysModels); } try { this.ExecQuery(sqlstring); while (this.Reader.Read()) { SysModel info = PrepareData(); if (info != null) { SysModels.Add(info); } } } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; SysModels.Clear(); } return(SysModels); }
protected void Page_Load(object sender, EventArgs e) { DataEntities ent = new DataEntities(); #region 阅读统计 int model = WS.RequestInt("m"); int id = WS.RequestInt("id"); SysModel sm = //SysModelView.GetModelByID(model.ToS()); (from l in ent.SysModel where l.ID == model select l).FirstOrDefault(); if (sm.ID < 0) { return; } if (id < 0) { return; } string tableName = sm.TableName; string str_sql = string.Format("update {0} set ClickCount=ClickCount+1 where ID={1}; select ClickCount from {0} where ID={1}", tableName, id); Response.Clear(); Response.Write(string.Format("document.write('{0}')", GetHelper().ExecuteScalar(CommandType.Text, str_sql))); //Response.End(); #endregion #region 阅读历史记录 //string bookids = ""; //if (Voodoo.Cookies.Cookies.GetCookie("history") != null) //{ // bookids = Voodoo.Cookies.Cookies.GetCookie("history").Value; //} //string[] ids = bookids.Split(','); //var tids = ids.ToList(); //tids.Add(id.ToS()); //tids = tids.Distinct(p => p).ToList(); //tids = tids.Where(p => p.Trim().Length > 0).ToList(); //tids = tids.Take(5).ToList(); //bookids = ""; //foreach (string str in tids) //{ // if (str.Trim().Length > 0) // { // bookids += str + ","; // } //} //bookids=bookids.TrimEnd(','); //HttpCookie cookie = new HttpCookie("history", bookids); //Voodoo.Cookies.Cookies.SetCookie(cookie); #endregion ent.Dispose(); }
public ActionResult Edit(int id = 0) { SysModel sysmodel = db.SysModels.Find(id); if (sysmodel == null) { return(HttpNotFound()); } return(View(viewFolder + "Edit.cshtml", sysmodel)); }
private SysModel PrepareData() { SysModel info = new SysModel(); info.SysCode = this.Reader[0].ToString(); info.SysName = this.Reader[1].ToString(); info.SortId = FrameWork.Function.NConvert.ToInt32(this.Reader[2]); return(info); }
public ActionResult Index(SysModel sm) { int pageNO = 1; if (Request.Form["pageNum"] != null) { int.TryParse(Request.Form["pageNum"], out pageNO); } List <SysModel> list = GetSysModelList(pageNO, sm); return(View(viewFolder + "Index.cshtml", list)); }
public string Edit(SysModel sysmodel) { try { db.Entry(sysmodel).State = EntityState.Modified; db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "修改成功", "", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "修改失败!" + ex.Message, "", "", CallBackType.none, "")); } }
public string Create(SysModel sysmodel) { try { sysmodel.IsFlag = true; db.SysModels.Add(sysmodel); db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "添加成功", "", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "添加失败!" + ex.Message, "", "", CallBackType.none, "")); } }
public static SysModelDto ToDto(this SysModel model) { if (model == null) { return(null); } return(new SysModelDto { CreatedAt = model.CreatedAt, CreatedBy = model.CreatedBy, ModifiedAt = model.ModifiedAt, ModifiedBy = model.ModifiedBy }); }
/// <summary> /// 获取用户开户行列表 /// </summary> /// <param name="currentPage">当前页码</param> /// <param name="uBank">查询实体</param> /// <returns></returns> private List <SysModel> GetSysModelList(int currentPage, SysModel model) { var smList = db.SysModels.Where(sm => sm.IsFlag == true).AsQueryable(); if (model != null) { if (model.SysModelClassID > 0) { smList = smList.Where(sm => sm.SysModelClassID == model.SysModelClassID); } } SetPagerOptions(smList.Count(), currentPage); List <SysModel> list = smList.OrderBy(b => b.ID).Skip((currentPage - 1) * pageSize).Take(pageSize).OrderBy(sm => sm.SysModelClassID).ToList(); return(list); }
/// <summary> /// DataTable转换为list /// </summary> /// <param name="dt"></param> /// <returns></returns> protected static List <SysModel> DataTableToList(DataTable dt) { List <SysModel> Ms = new List <SysModel>(); for (int i = 0; i < dt.Rows.Count; i++) { SysModel M = new SysModel(); M.ID = dt.Rows[i]["ID"].ToInt32(); M.ModelName = dt.Rows[i]["ModelName"].ToString(); M.TableName = dt.Rows[i]["TableName"].ToString(); M.SonClass = dt.Rows[i]["SonClass"].ToString(); Ms.Add(M); } return(Ms); }
public string DeleteConfirmed() { try { string ids = Request["ids"] ?? ""; int[] idList = WebComm.GetIntArrayByString(ids); foreach (int id in idList) { SysModel bank = db.SysModels.Find(id); bank.IsFlag = false; db.Entry(bank).State = EntityState.Modified; } db.SaveChanges(); return(WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "删除成功", "", "", CallBackType.none, "")); } catch (Exception ex) { return(WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "删除失败!" + ex.Message, "", "", CallBackType.none, "")); } }
public async Task <string> downloadStockData() { DownloadModel downloadModel = new DownloadModel(); SysModel sysModel = new SysModel(); DateTime date = sysModel.getsysConfigstockUpdate(); string totalmsg = ""; while (date <= DateTime.Now) { string datetime = date.ToString("yyyy-MM-dd"); string msg = await downloadModel.DownloadStock(datetime); totalmsg += msg + "<br/>"; DateTime nextdate = date.AddDays(1); int count = sysModel.updatesysConfigstockUpdate(nextdate); date = nextdate; Thread.Sleep(5000); } return(totalmsg); }
/// <summary> /// 根据条件语句取得第一个实体 /// </summary> /// <param name="m_where">条件语句,不包含“where”</param> /// <returns></returns> public static SysModel Find(string m_where) { IDbHelper Sql = GetHelper(); SysModel M = new SysModel(); DbDataReader Rs = Sql.ExecuteReader(CommandType.Text, "select [ID],[ModelName],[TableName],[SonClass] from [SysModel] where " + m_where, true); if (!Rs.Read()) { M.ID = 0; } else { M.ID = Rs["ID"].ToInt32(); M.ModelName = Rs["ModelName"].ToString(); M.TableName = Rs["TableName"].ToString(); M.SonClass = Rs["SonClass"].ToString(); } Rs.Close(); Rs = null; return(M); }
public async Task <JsonResult> DownloadOtcData() { bool status = true; string msg = ""; try { DownloadModel downloadModel = new DownloadModel(); SysModel sysModel = new SysModel(); DateTime date = sysModel.getsysConfigotcUpdate(); int count = 0; while (date <= DateTime.Now) { DateTime taiwandatetime = date.AddYears(-1911); string datetime = taiwandatetime.ToString("yyyy/MM/dd"); string s = await downloadModel.DownloadOtc(datetime); msg += s + "<br/>"; DateTime nextdate = date.AddDays(1); count = sysModel.updatesysConfigotcUpdate(nextdate); date = nextdate; Thread.Sleep(5000); } } catch (Exception e) { status = false; msg += e.Message; } return(Json(new Results <DBNull> { Success = status, Message = msg, Data = null, TotalCount = status ? 1 : 0 })); }
/// <summary> /// 将修改过的实体修改到数据库 /// </summary> /// <param name="M">赋值后的实体</param> /// <returns></returns> public static int Update(SysModel M) { IDbHelper Sql = GetHelper(); StringBuilder sb = new StringBuilder(); sb.Append("update [SysModel] set "); sb.Append("[ModelName]=N'" + M.ModelName + "'"); sb.Append(","); sb.Append("[TableName]=N'" + M.TableName + "'"); sb.Append(","); sb.Append("[SonClass]=N'" + M.SonClass + "'"); sb.Append(" where ID='" + M.ID + "'"); sb.Append(""); if (DataBase.CmsDbType == DataBase.DbType.SqlServer) { sb.Append(";select @@ROWCOUNT"); } if (DataBase.CmsDbType == DataBase.DbType.SQLite) { sb.Append(";select 0"); } if (DataBase.CmsDbType == DataBase.DbType.MySql) { sb.Append(";SELECT ROW_COUNT()"); } if (DataBase.CmsDbType == DataBase.DbType.Access) { sb.Append(";select 0"); } if (DataBase.CmsDbType == DataBase.DbType.Oracle) { sb.Append(";select SQL%ROWCOUNT"); } return(Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32()); }
public async Task <string> downloadOtcData() { DownloadModel downloadModel = new DownloadModel(); SysModel sysModel = new SysModel(); DateTime date = sysModel.getsysConfigotcUpdate(); string totalmsg = ""; while (date <= DateTime.Now) { DateTime taiwandatetime = date.AddYears(-1911); string datetime = taiwandatetime.ToString("yyyy/MM/dd"); string msg = await downloadModel.DownloadOtc(datetime); totalmsg += msg + "<br/>"; DateTime nextdate = date.AddDays(1); int count = sysModel.updatesysConfigotcUpdate(nextdate); date = nextdate; Thread.Sleep(5000); } return(totalmsg); }
/// <summary> /// 将数据插入表 /// </summary> /// <param name="M">赋值后的实体</param> /// <returns></returns> public static void Insert(SysModel M) { IDbHelper Sql = GetHelper(); StringBuilder sb = new StringBuilder(); sb.Append("insert into [SysModel]([ModelName],[TableName],[SonClass]) values("); sb.Append("N'" + M.ModelName + "'"); sb.Append(","); sb.Append("N'" + M.TableName + "'"); sb.Append(","); sb.Append("N'" + M.SonClass + "'"); sb.Append(")"); if (DataBase.CmsDbType == DataBase.DbType.SqlServer) { sb.Append(";select @@Identity"); } if (DataBase.CmsDbType == DataBase.DbType.SQLite) { sb.Append(";select last_insert_rowid()"); } if (DataBase.CmsDbType == DataBase.DbType.MySql) { sb.Append(";select LAST_INSERT_ID()"); } if (DataBase.CmsDbType == DataBase.DbType.Access) { sb.Append(";select max(ID) from SysModel"); } if (DataBase.CmsDbType == DataBase.DbType.Oracle) { sb.Append(";select LAST_INSERT_ID()"); } M.ID = Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32(); }
public int Delete(SysModel info) { return(Delete(info.SysCode)); }
public void AddToSysModel(SysModel sysModel) { base.AddObject("SysModel", sysModel); }
public static SysModel CreateSysModel(int id) { SysModel sysModel = new SysModel(); sysModel.ID = id; return sysModel; }