/// <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;
}
