public sTypeModels GetSTypeModels(sRowsData sRowsData, string cuurip) { database database = new database(); List <dbparam> dbparamlist = new List <dbparam>(); dbparamlist.Add(new dbparam("@formId", sRowsData.formId.TrimEnd())); dbparamlist.Add(new dbparam("@inoper", sRowsData.newid.TrimEnd())); switch (database.checkSelectSql("mssql", "flyformstring", "exec web.searchclimainform @formId,@inoper;", dbparamlist).Rows.Count) { case 0: return(new sTypeModels() { status = "nodata" }); } dbparamlist.Add(new dbparam("@value", sRowsData.value.TrimEnd())); List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); string value = ""; foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchoperationform @value;", dbparamlist).Rows) { value = dr["operationValue"].ToString().TrimEnd(); items.Add(new Dictionary <string, object>() { { "optionPadding", dr["optionPadding"].ToString().TrimEnd() == "1" }, { "value", dr["operationValue"].ToString().TrimEnd() } }); } return(new sTypeModels() { value = value, items = items, status = "istrue" }); }
public sSiteModels GetWebsiteModels(sRowsData sRowsData, string cuurip, string userAgent) { database database = new database(); datetime datetime = new datetime(); string stdate = datetime.sqldate("mssql", "flyformstring"), sttime = datetime.sqltime("mssql", "flyformstring"), original = "", encryption = new sha256().new256("mssql", "flyformstring"), extension = ".jpg"; new WebClient().DownloadFile(sRowsData.value.TrimEnd(), $"{database.connectionString("formFiles")}{original}({encryption}){extension}"); List <dbparam> dbparamlist = new List <dbparam>(); string date = datetime.sqldate("mssql", "flyformstring"), time = datetime.sqltime("mssql", "flyformstring"), cuname = Dns.GetHostEntry(cuurip).HostName.IndexOf('.') == -1 ? Dns.GetHostEntry(cuurip).HostName : Dns.GetHostEntry(cuurip).HostName.Split('.')[0]; dbparamlist.Add(new dbparam("@formId", sRowsData.formId.TrimEnd())); dbparamlist.Add(new dbparam("@website", sRowsData.value.TrimEnd())); dbparamlist.Add(new dbparam("@externip", cuurip)); dbparamlist.Add(new dbparam("@hostname", cuname)); dbparamlist.Add(new dbparam("@browser", new information().browser(userAgent))); dbparamlist.Add(new dbparam("@stdate", stdate)); dbparamlist.Add(new dbparam("@sttime", sttime)); dbparamlist.Add(new dbparam("@eddate", date)); dbparamlist.Add(new dbparam("@edtime", time)); dbparamlist.Add(new dbparam("@indate", date)); dbparamlist.Add(new dbparam("@intime", time)); dbparamlist.Add(new dbparam("@inoper", sRowsData.newid.TrimEnd())); if (database.checkActiveSql("mssql", "flyformstring", "insert into web.websitelog (formId,website,externip,hostname,browser,stdate,sttime,eddate,edtime,indate,intime,inoper) values (@formId,@website,@externip,@hostname,@browser,@stdate,@sttime,@eddate,@edtime,@indate,@intime,@inoper);", dbparamlist) != "istrue") { return(new sSiteModels() { status = "error" }); } switch (File.Exists($"{database.connectionString("formFiles")}{original}({encryption}){extension}")) { case false: return(new sSiteModels() { status = "nodata" }); } return(new sSiteModels() { images = true, videos = false, audios = false, src = $"{original}({encryption}){extension}", imagePath = "http://221.222.222.16:4500/bugimage/", original = original, encryption = encryption, extension = extension, status = "istrue" }); }
public statusModels GetDownloadModels(sRowsData sRowsData, string cuurip, string userAgent) { database database = new database(); datetime datetime = new datetime(); string stdate = datetime.sqldate("mssql", "flyformstring"), sttime = datetime.sqltime("mssql", "flyformstring"); switch (File.Exists(database.connectionString("formFiles") + sRowsData.value.TrimEnd())) { case false: return(new statusModels() { status = "nodata" }); } string date = datetime.sqldate("mssql", "flyformstring"), time = datetime.sqltime("mssql", "flyformstring"), cuname = Dns.GetHostEntry(cuurip).HostName.IndexOf('.') == -1 ? Dns.GetHostEntry(cuurip).HostName : Dns.GetHostEntry(cuurip).HostName.Split('.')[0]; List <dbparam> dbparamlist = new List <dbparam>(); dbparamlist.Add(new dbparam("@formId", sRowsData.formId.TrimEnd())); dbparamlist.Add(new dbparam("@files", sRowsData.value.TrimEnd())); dbparamlist.Add(new dbparam("@externip", cuurip)); dbparamlist.Add(new dbparam("@hostname", cuname)); dbparamlist.Add(new dbparam("@browser", new information().browser(userAgent))); dbparamlist.Add(new dbparam("@stdate", stdate)); dbparamlist.Add(new dbparam("@sttime", sttime)); dbparamlist.Add(new dbparam("@eddate", date)); dbparamlist.Add(new dbparam("@edtime", time)); dbparamlist.Add(new dbparam("@indate", date)); dbparamlist.Add(new dbparam("@intime", time)); dbparamlist.Add(new dbparam("@inoper", sRowsData.newid.TrimEnd())); if (database.checkActiveSql("mssql", "flyformstring", "insert into web.downloadlog (formId,files,externip,hostname,browser,stdate,sttime,eddate,edtime,indate,intime,inoper) values (@formId,@files,@externip,@hostname,@browser,@stdate,@sttime,@eddate,@edtime,@indate,@intime,@inoper);", dbparamlist) != "istrue") { return(new statusModels() { status = "error" }); } return(new statusModels() { status = "istrue" }); }
public sOptonModels GetSoperModels(sRowsData sRowsData, string cuurip) { database database = new database(); List <dbparam> dbparamlist = new List <dbparam>(); dbparamlist.Add(new dbparam("@department", sRowsData.value.TrimEnd())); List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); foreach (DataRow dr in database.checkSelectSql("mssql", "epaperstring", "exec web.searchdertoper @department;", dbparamlist).Rows) { dbparamlist.Clear(); dbparamlist.Add(new dbparam("@formId", sRowsData.formId.TrimEnd())); dbparamlist.Add(new dbparam("@inoper", sRowsData.newid.TrimEnd())); dbparamlist.Add(new dbparam("@newid", dr["newid"].ToString().TrimEnd())); items.Add(new Dictionary <string, object>() { { "newid", dr["newid"].ToString().TrimEnd() }, { "userid", dr["userid"].ToString().TrimEnd() }, { "name", dr["username"].ToString().TrimEnd() }, { "showOper", database.checkSelectSql("mssql", "flyformstring", "exec web.searchoperform @formId,@inoper,@newid;", dbparamlist).Rows.Count > 0 } }); } return(new sOptonModels() { items = items }); }
public sVeriModels GetSVeriModels(sRowsData sRowsData, string cuurip) { database database = new database(); DataTable mainRows = new DataTable(); List <dbparam> dbparamlist = new List <dbparam>(); dbparamlist.Add(new dbparam("@formId", sRowsData.formId.TrimEnd())); dbparamlist.Add(new dbparam("@iid", sRowsData.value.TrimEnd())); dbparamlist.Add(new dbparam("@inoper", sRowsData.newid.TrimEnd())); mainRows = database.checkSelectSql("mssql", "flyformstring", "exec web.searchclisubdeta @formId,@iid,@inoper;", dbparamlist); List <Dictionary <string, object> > typeitems = new List <Dictionary <string, object> >(), operationitems = new List <Dictionary <string, object> >(); switch (mainRows.Rows.Count) { case 0: string type_ = ""; 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_)); 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" }); } switch (mainRows.Rows[0]["verified"].ToString().TrimEnd()) { case "0": return(new sVeriModels() { status = "nodata" }); } dbparamlist.Clear(); foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchtypeform;", dbparamlist).Rows) { typeitems.Add(new Dictionary <string, object>() { { "optionPadding", dr["optionPadding"].ToString().TrimEnd() == "1" }, { "value", dr["value"].ToString().TrimEnd() } }); } dbparamlist.Add(new dbparam("@value", mainRows.Rows[0]["type"].ToString().TrimEnd())); foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchoperationform @value;", dbparamlist).Rows) { operationitems.Add(new Dictionary <string, object>() { { "optionPadding", dr["optionPadding"].ToString().TrimEnd() == "1" }, { "value", dr["operationValue"].ToString().TrimEnd() } }); } return(new sVeriModels() { type_ = mainRows.Rows[0]["type"].ToString().TrimEnd(), typeitems = typeitems, operation = mainRows.Rows[0]["operation"].ToString().TrimEnd(), operationitems = operationitems, status = "istrue" }); }