public sFoorModels GetSearchModels(userData userData, string cuurip) { List <Dictionary <string, object> > opticonitems = new List <Dictionary <string, object> >(); foreach (DataRow dr in new database().checkSelectSql("mssql", "flyformstring", "exec web.searchitemform;", new List <dbparam>()).Rows) { opticonitems.Add(new Dictionary <string, object>() { { "opticonPadding", false }, { "icon", dr["icon"].ToString().TrimEnd() }, { "value", dr["value"].ToString().TrimEnd() } }); } List <Dictionary <string, object> > answeritems = new List <Dictionary <string, object> >(); answeritems.Add(new Dictionary <string, object>() { { "id", 1 }, { "value", "" }, { "showAnswer", false }, { "ansrDelete", false } }); List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); items.Add(new Dictionary <string, object>() { { "iid", 1 }, { "showLine", false }, { "title", "" }, { "showOut", false }, { "showVeri", false }, { "showDrop", false }, { "showFile", false }, { "outValue", "text" }, { "type_", "" }, { "showType", false }, { "typeitems", new List <Dictionary <string, object> >().ToArray() }, { "operation", "" }, { "showOperation", false }, { "operationitems", new List <Dictionary <string, object> >().ToArray() }, { "area", "" }, { "eror", "" }, { "showCheck", false }, { "showMore", false }, { "opticonitems", opticonitems.ToArray() }, { "answeritems", answeritems.ToArray() }, { "itemDelete", false } }); List <Dictionary <string, object> > settitems = new List <Dictionary <string, object> >(); settitems.Add(new Dictionary <string, object>() { { "stdate", "" }, { "sttime", "" }, { "endate", "" }, { "entime", "" }, { "showExam", false }, { "randOption", false }, { "randSubtile", false }, { "showRestart", false }, { "showLimit", false }, { "dertitems", new List <Dictionary <string, object> >().ToArray() }, { "number", "" } }); return(new sFoorModels() { items = items, settitems = settitems }); }
public itemsModels GetBadgeModels(userData userData, string cuurip) { database database = new database(); DataTable mainRows = new DataTable(); List <dbparam> dbparamlist = new List <dbparam>(); dbparamlist.Add(new dbparam("@inoper", userData.userid.TrimEnd())); mainRows = database.checkSelectSql("mssql", "epaperstring", "exec web.updatenoticeform @inoper;", dbparamlist); switch (mainRows.Rows.Count) { case 0: return(new itemsModels() { showItem = false }); } List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); foreach (DataRow dr in mainRows.Rows) { items.Add(new Dictionary <string, object>() { { "link", dr["link"].ToString().TrimEnd() }, { "name", dr["username"].ToString().TrimEnd().Substring(0, 1) }, { "value", dr["value"].ToString().TrimEnd() }, { "datetime", $"{dr["indate"].ToString().TrimEnd()} {dr["intime"].ToString().TrimEnd()}" } }); } return(new itemsModels() { showItem = true, items = items }); }
public sVeriModels GetSVeriModels(userData userData, string cuurip) { database database = new database(); List <dbparam> dbparamlist = new List <dbparam>(); string type_ = ""; List <Dictionary <string, object> > typeitems = new List <Dictionary <string, object> >(); foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchtypeform;", dbparamlist).Rows) { type_ = dr["value"].ToString().TrimEnd(); typeitems.Add(new Dictionary <string, object>() { { "optionPadding", dr["optionPadding"].ToString().TrimEnd() == "1" }, { "value", dr["value"].ToString().TrimEnd() } }); } string operation = ""; dbparamlist.Add(new dbparam("@value", type_)); List <Dictionary <string, object> > operationitems = new List <Dictionary <string, object> >(); foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchoperationform @value;", dbparamlist).Rows) { operation = dr["operationValue"].ToString().TrimEnd(); operationitems.Add(new Dictionary <string, object>() { { "optionPadding", dr["optionPadding"].ToString().TrimEnd() == "1" }, { "value", dr["operationValue"].ToString().TrimEnd() } }); } return(new sVeriModels() { type_ = type_, typeitems = typeitems, operation = operation, operationitems = operationitems, status = "istrue" }); }
public itemModels GetSearchModels(userData userData, string cuurip) { database database = new database(); List <dbparam> dbparamlist = new List <dbparam>(); int itemCount = int.Parse(database.checkSelectSql("mssql", "flyformstring", "exec web.countmainform;", dbparamlist).Rows[0]["itemcount"].ToString().TrimEnd()); DataTable mainRows = new DataTable(); dbparamlist.Add(new dbparam("@inoper", userData.userid.TrimEnd())); mainRows = database.checkSelectSql("mssql", "flyformstring", "exec web.searchmainform @inoper;", dbparamlist); switch (mainRows.Rows.Count) { case 0: return(new itemModels() { status = "nodata" }); } List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); foreach (DataRow dr in mainRows.Rows) { items.Add(new Dictionary <string, object>() { { "id", dr["formId"].ToString().TrimEnd() }, { "tile", dr["tile"].ToString().TrimEnd() }, { "datetime", dr["indate"].ToString().TrimEnd() }, { "showOther", false }, { "showFinish", dr["finish"].ToString().TrimEnd() == "1" } }); } return(new itemModels() { itemCount = itemCount, items = items, status = "istrue" }); }
public itemsModels GetRecordModels(userData userData, string cuurip) { DataTable mainRows = new DataTable(); List <dbparam> dbparamlist = new List <dbparam>(); dbparamlist.Add(new dbparam("@newid", userData.userid.TrimEnd())); mainRows = new database().checkSelectSql("mssql", "epaperstring", "exec web.searchrecordform @newid;", dbparamlist); switch (mainRows.Rows.Count) { case 0: return(new itemsModels() { showItem = false }); } List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); foreach (DataRow dr in mainRows.Rows) { items.Add(new Dictionary <string, object>() { { "link", dr["link"].ToString().TrimEnd() }, { "icon", dr["icon"].ToString().TrimEnd() }, { "value", dr["value"].ToString().TrimEnd() } }); } return(new itemsModels() { showItem = true, items = items }); }
public loginModels GetLoginFormModels(userData userData, string cuurip, string userAgent) { switch (string.IsNullOrWhiteSpace(userData.userid)) { case true: return(new loginModels() { status = "errorFormLogin" }); } database database = new database(); DataTable loginRows = new DataTable(); List <dbparam> dbparamlist = new List <dbparam>(); dbparamlist.Add(new dbparam("@newid", userData.userid.TrimEnd())); dbparamlist.Add(new dbparam("@externip", cuurip)); dbparamlist.Add(new dbparam("@status", "1")); loginRows = database.checkSelectSql("mssql", "epaperstring", "exec web.checkformlogin @newid,@externip,@status;", dbparamlist); switch (loginRows.Rows.Count) { case 0: return(new loginModels() { status = "nodata" }); } if (loginRows.Rows[0]["isused"].ToString().TrimEnd() == "1" && loginRows.Rows[0]["islogin"].ToString().TrimEnd() == "1") { datetime datetime = new datetime(); information information = new information(); string date = datetime.sqldate("mssql", "epaperstring"), time = datetime.sqltime("mssql", "epaperstring"); dbparamlist.Add(new dbparam("@cpu", "")); dbparamlist.Add(new dbparam("@os", information.osystem(userAgent))); dbparamlist.Add(new dbparam("@internip", "")); dbparamlist.Add(new dbparam("@indate", date)); dbparamlist.Add(new dbparam("@intime", time)); switch (database.checkActiveSql("mssql", "epaperstring", "update web.sitelog set cpu = @cpu,os = @os,internip = @internip,indate = @indate,intime = @intime where newid = @newid and externip = @externip and islogin = @status;", dbparamlist)) { case "istrue": return(new loginModels() { newid = loginRows.Rows[0]["newid"].ToString().TrimEnd(), name = loginRows.Rows[0]["username"].ToString().TrimEnd().Substring(0, 1), allname = loginRows.Rows[0]["username"].ToString().TrimEnd(), status = "istrue" }); } return(new loginModels() { status = "error" }); } return(new loginModels() { status = "islock" }); }
public sOptonModels GetSlimitModels(userData userData, string cuurip) { List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); foreach (DataRow dr in new database().checkSelectSql("mssql", "epaperstring", "exec web.searchdistinctdert;", new List <dbparam>()).Rows) { items.Add(new Dictionary <string, object>() { { "showPanel", false }, { "dertment", dr["department"].ToString().TrimEnd() }, { "operitems", new List <Dictionary <string, object> >().ToArray() }, { "dertModify", false } }); } return(new sOptonModels() { items = items }); }
public sOptonModels GetAddModels(userData userData, string cuurip) { List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); foreach (DataRow dr in new database().checkSelectSql("mssql", "flyformstring", "exec web.searchitemform;", new List <dbparam>()).Rows) { items.Add(new Dictionary <string, object>() { { "opticonPadding", false }, { "icon", dr["icon"].ToString().TrimEnd() }, { "value", dr["value"].ToString().TrimEnd() } }); } return(new sOptonModels() { items = items }); }
public permissModels GetPermissModels(userData userData, string cuurip) { DataTable mainRows = new DataTable(); List <dbparam> dbparamlist = new List <dbparam>(); dbparamlist.Add(new dbparam("@newid", userData.userid.TrimEnd())); mainRows = new database().checkSelectSql("mssql", "epaperstring", "exec web.searchallmissform @newid;", dbparamlist); switch (mainRows.Rows.Count) { case 0: return(new permissModels() { insert = false, update = false, delete = false, export = false }); } return(new permissModels() { insert = mainRows.Rows[0]["isinsert"].ToString().TrimEnd() == "1", update = mainRows.Rows[0]["ismodify"].ToString().TrimEnd() == "1", delete = mainRows.Rows[0]["isdelete"].ToString().TrimEnd() == "1", export = mainRows.Rows[0]["isexport"].ToString().TrimEnd() == "1" }); }
public statusModels GetSearchModels(userData userData, string cuurip) { /*database database = new database(); * DataTable mainRows = new DataTable(); * List<dbparam> dbparamlist = new List<dbparam>(); * mainRows = database.checkSelectSql("mssql", "epaperstring", "select value,icon from web.qaitemform where inoper = @inoper;", dbparamlist); * switch (mainRows.Rows.Count) * { * case 0: * return new sItemsModels() { status = "nodata" }; * } * List<Dictionary<string, object>> items = new List<Dictionary<string, object>>(); * foreach (DataRow dr in mainRows.Rows) * { * items.Add(new Dictionary<string, object>() { { "icon", dr["icon"].ToString().TrimEnd() }, { "value", dr["value"].ToString().TrimEnd() } }); * }*/ return(new statusModels() { status = "istrue" }); }
public userModels GetUserModels(userData userData, string cuurip) { switch (string.IsNullOrWhiteSpace(userData.userid)) { case true: return(new userModels() { status = "errorUserid" }); } database database = new database(); DataTable userRows = new DataTable(); List <dbparam> dbparamlist = new List <dbparam>(); dbparamlist.Add(new dbparam("@userid", userData.userid.TrimEnd())); dbparamlist.Add(new dbparam("@status", "1")); userRows = database.checkSelectSql("mssql", "epaperstring", "exec web.checksiteber @userid,@status;", dbparamlist); switch (userRows.Rows.Count) { case 0: return(new userModels() { status = "nodata" }); } switch (userRows.Rows[0]["isused"].ToString().TrimEnd()) { case "1": return(new userModels() { newid = userRows.Rows[0]["newid"].ToString().TrimEnd(), status = "istrue" }); } return(new userModels() { status = "islock" }); }
public statusModels GetCheckNewModels(userData userData, string cuurip) { switch (string.IsNullOrWhiteSpace(userData.userid)) { case true: return(new statusModels() { status = "nodata" }); } DataTable checkRows = new DataTable(); List <dbparam> dbparamlist = new List <dbparam>(); dbparamlist.Add(new dbparam("@newid", userData.userid.TrimEnd())); dbparamlist.Add(new dbparam("@status", "1")); checkRows = new database().checkSelectSql("mssql", "epaperstring", "exec web.checkformnewid @newid,@status;", dbparamlist); switch (checkRows.Rows.Count) { case 0: return(new statusModels() { status = "nodata" }); } switch (checkRows.Rows[0]["isused"].ToString().TrimEnd()) { case "1": return(new statusModels() { status = "istrue" }); } return(new statusModels() { status = "islock" }); }