public void AddFunction(string functionName, FunctionArgumentList argList, string expression) { var fc = new FunctionClass { Arguments = argList, Expression = expression, Name = functionName }; var numClass = new NumberClass { NumberType = NumberClass.NumberTypes.Expression, Expression = expression }; EvaluateFunction(numClass, fc); _functions.Add(fc); }
/// <summary> /// 获得指定表单参数的值 /// </summary> /// <param name="strName">表单参数</param> /// <param name="sqlSafeCheck">是否进行SQL安全检查</param> /// <returns>表单参数的值</returns> public static string GetFormString(string strName, bool sqlSafeCheck) { if (HttpContext.Current.Request.Form[strName] == null) { return(""); } if (sqlSafeCheck && !FunctionClass.IsSafeSqlString(HttpContext.Current.Request.Form[strName])) { return("unsafe string"); } return(HttpContext.Current.Request.Form[strName]); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { try { lbServerIP.Text = Request.ServerVariables.Get("Local_Addr").ToString(); lbServerScript.Text = Environment.Version.ToString(); lbServerURL.Text = Request.PhysicalApplicationPath; lbServerOS.Text = Environment.OSVersion.ToString(); lbServerFileSize.Text = FunctionClass.FormatFileSize(FunctionClass.GetDirectoryLength(Request.PhysicalApplicationPath), 2); } catch { } }
protected void btSubmit_Click(object sender, EventArgs e) { string strUserName, strPassWord, strMobile, strTel, strFax, strEMail, strCompany, strAddress, strIsLock, strUserType, strSql; string strQQ, strMemo; strUserName = tbUserName.Text; strPassWord = tbPassWord.Text; strMobile = FunctionClass.ToDBC(tbMobile.Text); strTel = tbTel.Text; strFax = tbFax.Text; strEMail = tbEMail.Text; strCompany = tbCompany.Text; strAddress = tbAddress.Text; strIsLock = cblIsLock.SelectedValue; strUserType = ddlUserType.SelectedValue; strQQ = tbQQ.Text; strMemo = tbMemo.Text; //判断手机号码是否11位 if (strMobile.Length != 11) { FunctionClass.ShowMsgBox("手机号码必须是11位数字!前面请不要加0或其他字符"); Response.End(); } strSql = "insert into T_User (UserName,PassWord,Mobile,Tel,Fax,EMail,Company,Address,IsLock,UserType,QQ,Memo) values " + "(@UserName,@PassWord,@Mobile,@Tel,@Fax,@EMail,@Company,@Address,@IsLock,@UserType,@QQ,@Memo)"; string[] ParamsName = new string[] { "@UserName", "@PassWord", "@Mobile", "@Tel", "@Fax", "@EMail", "@Company", "@Address", "@IsLock", "@UserType", "@QQ", "@Memo" }; string[] ParamsValue = new string[] { strUserName, strPassWord, strMobile, strTel, strFax, strEMail, strCompany, strAddress, strIsLock, strUserType, strQQ, strMemo }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); //判断用户名是否存在 if (myData.CheckDataRowExist("select * from T_User where Mobile like '" + strMobile.Replace("'", "''") + "'", myConn)) { myData.ConnClose(myConn); FunctionClass.ShowMsgBox("手机号码已经能够存在!请换一个!"); Response.End(); } long id = myData.InsertData(strSql, ParamsName, ParamsValue, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("添加成功!", ""); Response.End(); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strSql, strID; strID = Request.QueryString["id"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL地址错误!"); Response.End(); } strSql = "select * from T_ProType order by PID,SID;select * from T_ProType where ID=" + strID; ddlType.Items.Add(new ListItem("无", "0")); DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); myData.InitProTypeList(myDs.Tables[0], 0, ddlType, ""); if (myDs.Tables[1].Rows.Count > 0) { ddlType.SelectedValue = myDs.Tables[1].Rows[0]["PID"].ToString(); tbTypeCalled.Text = myDs.Tables[1].Rows[0]["TypeCalled"].ToString(); if (myDs.Tables[1].Rows[0]["IsShow"].ToString() == "1") { cblIsShow.SelectedValue = "1"; } else { cblIsShow.SelectedValue = "0"; } tbContent.Text = myDs.Tables[1].Rows[0]["Memo"].ToString(); } else { myDs.Dispose(); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("没有找到这条信息!"); Response.End(); } myDs.Dispose(); myData.ConnClose(myConn); }
protected void Page_Load(object sender, EventArgs e) { string strUserID; FunctionClass.CheckAdminLogin(0); lbAdmin_UserName.Text = Session["Admin_UserName"].ToString(); lbAdmin_UserRoleCalled.Text = Session["Admin_UserRoleCalled"].ToString(); lbIP.Text = Request.UserHostAddress.ToString(); strUserID = Session["Admin_UserID"].ToString(); DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); string strSql = "select * from T_AdminMenu where IsShow=1 order by sid,id"; DataSet myDs = myData.GetDataSet(strSql, myConn); DataView myDv = new DataView(myDs.Tables[0], "PID=0 and AdminUser like '%|" + strUserID + "|%'", "", DataViewRowState.CurrentRows); for (int i = 0; i < myDv.Count; i++) { string strTemp = ""; string strTemp1 = ""; strTemp = tbLeftMenu.Text; strTemp = strTemp.Replace("$i$", i.ToString()); strTemp = strTemp.Replace("$link$", myDv[i]["Link"].ToString()); strTemp = strTemp.Replace("$title$", myDv[i]["title"].ToString()); DataView myDv1 = new DataView(myDs.Tables[0], "PID=" + myDv[i]["ID"].ToString() + " and AdminUser like '%|" + strUserID + "|%'", "", DataViewRowState.CurrentRows); for (int j = 0; j < myDv1.Count; j++) { strTemp1 += "<TR><TD height=20><A href=\"" + myDv1[j]["Link"].ToString() + "\" target=main>" + myDv1[j]["title"].ToString() + "</A></TD></TR>"; } myDv1.Dispose(); strTemp = strTemp.Replace("$submenu$", strTemp1); strLeftMenu += strTemp; } myDv.Dispose(); myDs.Dispose(); myData.ConnClose(myConn); }
/// <summary> /// 点击更新排序按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void myTbOrder_Click(object sender, EventArgs e) { string strSql, strTypeID, strKeyWord; strTypeID = Request.QueryString["TypeID"]; strKeyWord = Request.QueryString["KeyWord"]; strSql = "select ID from T_Link where 1=1"; //判断是否有分类参数 if (strTypeID == null || strTypeID == "") { strTypeID = "0";//0表示所有分类 } //判断在不是0的情况下,加条件 if (strTypeID != "0") { strSql += " and TypeID=" + strTypeID;//加分类条件 } //判断是否有关键词 if (FunctionClass.CheckStr(strKeyWord, 0)) { tbKeyWord.Text = strKeyWord; strSql += " and Called like '%" + strKeyWord.Replace("'", "''") + "%'"; } strSql += " order by SID asc,id desc"; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); for (int i = 0; i < myDs.Tables[0].Rows.Count; i++) { string strRowID = myDs.Tables[0].Rows[i]["ID"].ToString(); TextBox myTB = (TextBox)form1.FindControl("SID_" + strRowID); if (myTB != null) { myData.ExecuteSql("update T_Link set SID=" + myTB.Text + " where ID=" + strRowID, myConn); } } myDs.Dispose(); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("更新成功!", ""); Response.End(); }
/// <summary> /// 测试FunctionClass中的mergeList功能,输入节点编号范围均是不连续的编号 /// </summary> static void TestGroup() { List <int> l1 = new List <int> { 10, 20, 30, 40, 50, 70, 80, 90 }; List <string> s1 = new List <string>(); l1.ForEach(x => s1.Add(x.ToString())); var StringList2 = FunctionClass.mergeList(s1, 23); for (int i = 0; i < StringList2.Count; i++) { Console.WriteLine(StringList2[i]); } Console.ReadLine(); }
private void ImportBsicData(string file) { string[] fileSplit = file.Split('\\'); string ExcelTableName = "[Sheet1$A1:Z]"; string[] sqlTableName = (fileSplit[fileSplit.Length - 1]).Split('.'); string sqlCmd = ""; DataTable dt = new DataTable(); sqlCmd = "select * from " + ExcelTableName; dt = FunctionClass.ExcelToDataTable(sqlCmd, file); if (dt.Rows.Count > 0) { try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { con.Open(); using (SqlBulkCopy copy = new SqlBulkCopy(con)) { int columnCount = dt.Columns.Count; for (int i = 0; i < columnCount; i++) { copy.ColumnMappings.Add(i, i); } copy.DestinationTableName = sqlTableName[0].ToString(); copy.WriteToServer(dt); } con.Close(); } System.Windows.Forms.MessageBox.Show("Done", "Message"); } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.ToString(), "Message"); } finally { dt = null; } } else { System.Windows.Forms.MessageBox.Show("No data row found in excel file.", "Message"); } }
/// <summary> /// This is the method that actually does the work. /// </summary> /// <param name="DA">The DA object is used to retrieve from inputs and store in outputs.</param> protected override void SolveInstance(IGH_DataAccess DA) { List <LineObjClass> lineobjs = new List <LineObjClass>(); List <Point3d> points = new List <Point3d>(); double err = 0; int pointsCount = 0; //添加到points列表中点的个数 int pointsNo = 0; //线段端点的索引 DataTree <int> tree = new DataTree <int>(); DA.GetDataList(0, lineobjs); DA.GetData(1, ref err); int num = lineobjs.Count; for (int i = 0; i < num; i++) { List <Point3d> lineV = new List <Point3d>(); List <int> vInd = new List <int>(); GH_Path path = new GH_Path(tree.BranchCount); Point3d p0 = lineobjs[i].Line.PointAt(0); Point3d p1 = lineobjs[i].Line.PointAt(1); lineV.Add(p0); lineV.Add(p1); for (int j = 0; j < lineV.Count; j++) { bool bo; int ind; FunctionClass.BigThanErr(points, lineV[j], err, out bo, out ind); if (bo)//如果点lineV[j]不跟其他点重合 { points.Add(lineV[j]); pointsCount += 1; pointsNo = pointsCount; } else { pointsNo = ind + 1; } vInd.Add(pointsNo); lineobjs[i].Vertices = vInd; tree.Add(vInd[j], path); } } DA.SetDataList(0, points); DA.SetDataList(1, lineobjs); DA.SetDataTree(2, tree); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strID, strSql; strID = Request.QueryString["ID"]; //如果为空,默认第一条 if (strID == null || strID == "") { strID = "1"; } else { laMeno1.Text = ""; laMeno2.Text = ""; } if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL参数格式输入错误!"); Response.End(); } strSql = "select * from T_Info order by SID asc"; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); SqlDataReader myDr = myData.GetSqlDataReader(strSql, myConn); //初始化下拉列表数据 while (myDr.Read()) { ddlType.Items.Add(new ListItem(myDr["Called"].ToString(), myDr["ID"].ToString())); if (strID == myDr["ID"].ToString()) { ddlType.SelectedValue = myDr["ID"].ToString(); tbMemo.Text = myDr["Memo"].ToString(); } } myDr.Close(); myDr.Dispose(); myData.ConnClose(myConn); Session["UserViewURL"] = FunctionClass.PageURL; }
protected void btSubmit_Click(object sender, EventArgs e) { string strPID, strTitle, strLink, strIsShow, strAdminUser, strSql; strPID = ddlPID.SelectedValue; strTitle = tbTitle.Text; strLink = tbLink.Text; strIsShow = cblIsShow.SelectedValue; strAdminUser = ""; //获取选中用户 for (int i = 0; i < cblAdminUser.Items.Count; i++) { if (cblAdminUser.Items[i].Selected) { strAdminUser += "|" + cblAdminUser.Items[i].Value + "|"; } } strSql = "insert into T_AdminMenu (PID,Title,Link,IsShow,AdminUser) values (@PID,@Title,@Link,@IsShow,@AdminUser)"; string[] ParamsName = new string[] { "@PID", "@Title", "@Link", "@IsShow", "@AdminUser" }; string[] ParamsValue = new string[] { strPID, strTitle, strLink, strIsShow, strAdminUser }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); long id = myData.InsertData(strSql, ParamsName, ParamsValue, myConn); //获取选中用户 for (int i = 0; i < cblAdminUser.Items.Count; i++) { if (cblAdminUser.Items[i].Selected) { strSql = "update T_Admin set UserMenu=UserMenu+'|" + id + "|' where ID=" + cblAdminUser.Items[i].Value; } else { strSql = "update T_Admin set UserMenu=Replace(UserMenu,'|" + id + "|','') where ID=" + cblAdminUser.Items[i].Value; } myData.ExecuteSql(strSql, myConn); } myData.ConnClose(myConn); FunctionClass.ShowMsgBox("添加成功!", ""); Response.End(); }
private void regresionClicked(object sender, EventArgs e) { string operatorType = "Linear Regression"; Form dlg1 = new AnalyzeForm(); if (analyzeOption(dlg1)) { List <double[]> xy = new List <double[]>(); for (int i = 0; i < Data.columnChoosen.Length; i++) { if (Data.columnChoosen[i] != -1) { int column = Data.columnChoosen[i]; int miss, dataSize; double[] data; createDataArr(column, out data, out miss, out dataSize); Debug.WriteLine(miss); xy.Add(data); } } double r, rPar, a, aPar, b, bPar; long time, timeSeq; FunctionClass.LinearRegression( xy[0], xy[1], 0, xy[0].Length < xy[1].Length?xy[0].Length:xy[1].Length, out r, out b, out a, out timeSeq); ParallelFunctionClass.LinearRegressionPar( xy[0], xy[1], 0, xy[0].Length < xy[1].Length ? xy[0].Length : xy[1].Length, out rPar, out bPar, out aPar, out time); Debug.WriteLine("regresi linear-nya {2} adalah: Y = {0}X + {1}", a, b, timeSeq); Debug.WriteLine("regresi linearPar-nya {2} adalah: Y = {0}X + {1}", aPar, bPar, time); results.Add("Y = " + a + "X + " + b); DialogResult dialog = new DialogResult(); Form dialogResult = new ResultForm(operatorType); dialog = dialogResult.ShowDialog(); results.Clear(); } else { dlg1.Close(); } }
public ElementFunction(string function, Parameter p) : base() { switch (function) { case "getOne": Function = FunctionClass.GetOneFunction; break; case "maxValue": Function = FunctionClass.MaxValueFunction; break; default: throw new Exception("There is no function with id: " + function); } Parameter = p; }
/// <summary> /// 删除数据 /// </summary> private void DelData() { string strDel; strDel = Request.QueryString["del"]; if (FunctionClass.CheckStr(strDel, 1)) { DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); myData.ExecuteSql("delete from T_PayLog where ID=" + strDel, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("删除成功!", ""); Response.End(); } }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strID; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet("select * from T_PayType order by sid,id;select * from V_PayLog where ID=" + strID, myConn); ddlPayType.DataTextField = "TypeCalled"; ddlPayType.DataValueField = "ID"; ddlPayType.DataSource = myDs; ddlPayType.DataBind(); myDs.Dispose(); ddlPayType.Items.Insert(0, new ListItem("请选择", "0")); //赋值 DataView myDv = new DataView(myDs.Tables[1], "", "", DataViewRowState.CurrentRows); if (myDv.Count > 0) { tbUserName.Text = myDv[0]["UserName"].ToString() + "[" + myDv[0]["Mobile"].ToString() + "]"; tbUserID.Text = myDv[0]["UserID"].ToString(); tbPrice.Text = myDv[0]["Price"].ToString(); ddlPayType.SelectedValue = myDv[0]["PayType"].ToString(); cblIsShow.SelectedValue = myDv[0]["IsShow"].ToString(); } myDv.Dispose(); myData.ConnClose(myConn); tbPrice.Attributes.Add("onKeyUp", "value=value.replace(/[^\\-\\.\\d]/g,'')"); tbUserName.Attributes.Add("onKeyUp", "GetUserList('" + lbUserList.ClientID + "',MM_findObj('" + tbUserName.ClientID + "').value)"); }
/// <summary> /// 绑定和读取数据 /// </summary> private void BindData() { //定义变量 string strSql, strID; //赋值变量 strID = Request.QueryString["ID"]; //判断变量 if (!FunctionClass.CheckStr(strID, 1)) { strID = "3"; } //打开数据库连接 DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); strSql = "select * from T_Info where ID=" + strID; SqlDataReader myDr = myData.GetSqlDataReader(strSql, myConn); if (myDr.Read()) { lbInfo3.Text = myDr["Memo"].ToString(); lbCalled.Text = myDr["Called"].ToString(); hyCalled.Text = myDr["Called"].ToString(); hyCalled.NavigateUrl = "about.aspx?id=" + strID; //判断英文 if (strID == "3") { lbCalled1.Text = "ABOUT US"; } else if (strID == "4") { lbCalled1.Text = "CONTACT US"; } } myDr.Close(); myDr.Dispose(); //关闭数据库连接 myData.ConnClose(myConn); }
public FunctionForm(Form parent, DBRegistrationClass dbReg, List <TableClass> tables, TreeNode tn, ContextMenuStrip cm, StateClasses.EditStateClass.eBearbeiten mode) { InitializeComponent(); this.MdiParent = parent; Cm = cm; Tn = tn; _tables = tables; try { BearbeitenMode = mode; if (BearbeitenMode == StateClasses.EditStateClass.eBearbeiten.eInsert) { FunctionObject = new FunctionClass(); FunctionObject.Name = "NEW_FUNCTION"; } else { FunctionObject = (FunctionClass)tn.Tag; } } catch (Exception ex) { Console.WriteLine(ex.Message); } OldFunctionObject = (FunctionClass)FunctionObject.Clone(); _dbReg = dbReg; _localNotify.Register4Error(Notify_OnRaiseErrorHandler); _localNotify.Register4Info(Notify_OnRaiseInfoHandler); cbDatatype.Items.Clear(); DBTypeList dbList = new DBTypeList(); foreach (DBDataTypes dt in dbList.Values) { cbDatatype.Items.Add(dt); } DoEvents = true; }
protected void btSubmit_Click(object sender, EventArgs e) { string strID, strRealName, strTel, strEMail, strQQ, strIsShow, strTitle, strMemo, strReplyTime, strReply, strSql; string strIsRecommend, strAddress; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } strRealName = tbRealName.Text; strTel = tbTel.Text; strEMail = tbEMail.Text; strQQ = tbQQ.Text; strIsShow = cblIsShow.SelectedValue; strTitle = tbTitle.Text; strMemo = tbMemo.Text; strReplyTime = tbReplyTime.Text; strReply = tbReply.Text; strIsRecommend = rblIsRecommend.SelectedValue; strAddress = tbAddress.Text; strSql = "update T_Book set RealName=@RealName,Tel=@Tel,EMail=@EMail,QQ=@QQ,IsShow=@IsShow,Title=@Title," + "Memo=@Memo,ReplyTime=@ReplyTime,Reply=@Reply,IsRecommend=@IsRecommend,Address=@Address where ID=@ID"; string[] ParamsName = new string[] { "@RealName", "@Tel", "@EMail", "@QQ", "@IsShow", "@Title", "@Memo", "@ReplyTime", "@Reply", "@IsRecommend", "@Address", "@ID" }; string[] ParamsValue = new string[] { strRealName, strTel, strEMail, strQQ, strIsShow, strTitle, strMemo, strReplyTime, strReply, strIsRecommend, strAddress, strID }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); long id = myData.InsertData(strSql, ParamsName, ParamsValue, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("修改成功!", ""); Response.End(); }
/// <summary> /// 添加表格分页显示栏 /// </summary> /// <param name="myTable">输出表</param> /// <param name="intRsCount">数据总数</param> /// <param name="intPageCount">页总数</param> /// <param name="intPage">当前页</param> /// <param name="strURL">当前URL路径</param> private void AddTablePage(Table myTable, int intRsCount, int intPageCount, int intPage, string strURL) { TableRow myTr = new TableRow(); TableCell myTc = new TableCell(); myTc.Text += "<div style=\"width:1004px; background-color:#f7fbff; text-align:center; padding-top:5px; height:35px;\">"; myTc.Text += "总共" + intRsCount + "条信息,共" + intPageCount + "页,当前为第" + intPage + "页,"; myTc.Text += "<a href=\"" + FunctionClass.GetNewURL("page", "1", strURL) + "\">首页</a> "; int intPrevPage = intPage < 2 ? 1 : intPage - 1; myTc.Text += "<a href=\"" + FunctionClass.GetNewURL("page", intPrevPage.ToString(), strURL) + "\">上一页</a> "; int intNextPage = intPage >= intPageCount ? intPageCount : intPage + 1; myTc.Text += "<a href=\"" + FunctionClass.GetNewURL("page", intNextPage.ToString(), strURL) + "\">下一页</a> "; myTc.Text += "<a href=\"" + FunctionClass.GetNewURL("page", intPageCount.ToString(), strURL) + "\">尾页</a> "; myTc.Text += "跳转至<input type=\"text\" name=\"gotoPage\" id=\"gotoPage\" style=\"width:30px;\" value=\"" + intPage + "\" />页</div>"; myTr.Cells.Add(myTc); myTable.Rows.Add(myTr); }
protected void btSubmit_Click(object sender, EventArgs e) { string strUserName, strOldPassWord, strNewPassWord, strSql; bool isTrue = false; strUserName = Session["Admin_UserName"].ToString(); strOldPassWord = tbOldPassWord.Text; strNewPassWord = tbNewPassWord.Text; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); strSql = "select * from T_Admin where Username like '" + strUserName + "' and PassWord like '" + FunctionClass.ToMD5(strOldPassWord) + "'"; SqlDataReader myDr = myData.GetSqlDataReader(strSql, myConn); if (myDr.Read()) { isTrue = true; } myDr.Close(); myDr.Dispose(); if (!isTrue) { FunctionClass.ShowMsgBox("原始密码错误!"); myData.ConnClose(myConn); Response.End(); } strSql = "update T_Admin set PassWord='******' where UserName like '" + strUserName + "'"; myData.ExecuteSql(strSql, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("修改成功!", "index.aspx", true); Session["Admin_UserName"] = null; Session["Admin_PassWord"] = null; Session["Admin_UserRole"] = null; Session["Admin_UserRoleCalled"] = null; Response.End(); }
/// <summary> /// 获得当前页面客户端的IP /// </summary> /// <returns>当前页面客户端的IP</returns> public static string GetIP() { string result = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]; if (string.IsNullOrEmpty(result)) { result = HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; } if (string.IsNullOrEmpty(result)) { result = HttpContext.Current.Request.UserHostAddress; } if (string.IsNullOrEmpty(result) || !FunctionClass.IsIP(result)) { return("127.0.0.1"); } return(result); }
protected void btSubmit_Click(object sender, EventArgs e) { string strPID, strTypeCalled, strIsShow, strSql; strPID = ddlType.SelectedValue; strTypeCalled = tbTypeCalled.Text; strIsShow = cblIsShow.SelectedValue; strSql = "insert into T_NewType (PID,TypeCalled,IsShow) values (@PID,@TypeCalled,@IsShow)"; string[] ParamsName = new string[] { "@PID", "@TypeCalled", "@IsShow" }; string[] ParamsValue = new string[] { strPID, strTypeCalled, strIsShow }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); myData.InsertData(strSql, ParamsName, ParamsValue, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("添加成功!", ""); Response.End(); }
/// <summary> /// 点击删除所选按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void myTbDel_Click(object sender, EventArgs e) { string strSql, strKeyWord; strKeyWord = Request.QueryString["KeyWord"]; strSql = "select ID from T_Admin where 1=1"; //判断是否有关键词 if (FunctionClass.CheckStr(strKeyWord, 0)) { tbKeyWord.Text = strKeyWord; strSql += " and (UserName like '%" + strKeyWord.Replace("'", "''") + "%' or UserRoleCalled like '%" + strKeyWord.Replace("'", "''") + "%')"; } strSql += " order by id"; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); for (int i = 0; i < myDs.Tables[0].Rows.Count; i++) { string strRowID = myDs.Tables[0].Rows[i]["ID"].ToString(); CheckBox myTB = (CheckBox)form1.FindControl("cbSel_" + strRowID); if (myTB != null) { if (myTB.Checked) { myData.ExecuteSql("delete from T_Admin where ID=" + strRowID, myConn); } } } myDs.Dispose(); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("删除成功!", ""); Response.End(); }
// #region 文章查看 public ActionResult ItemView(DiscoverArticleModel model, string ReturnUrl, Nullable <long> myid = 0) { #region 获取来路路径 if (System.Web.HttpContext.Current.Request.UrlReferrer != null) { ViewBag.ReturnUrl = System.Web.HttpContext.Current.Request.UrlReferrer.PathAndQuery; } #endregion ViewBag.Headline = "文章查看"; //栏目主题 // using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作 { if ((myid > 0) && (model.Operate == null)) { long mySelfId = 0; long.TryParse(myid.ToString(), out mySelfId); ViewBag.Headline = "文章查看"; // model.Operate = ""; #region 取出数据 Discover_Article editRecord = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == mySelfId); if (editRecord != null) { model.ArticlId = editRecord.ArticlId; model.MobilePhone = editRecord.MobilePhone; model.ArticleTitle = editRecord.ArticleTitle; model.ArticleImages = FunctionClass.GetFileUrl(editRecord.ArticleImages); model.ArticleVideo = FunctionClass.GetFileUrl(editRecord.ArticleVideo); model.ArticleContent = editRecord.ArticleContent; model.ReadTimes = editRecord.ReadTimes; model.OrderBy = editRecord.OrderBy; model.Status = editRecord.Status; model.Operate = "look"; } #endregion } } // return(View(model)); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strSql, strID; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } strSql = "select * from T_Seo where ID=" + strID; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); if (myDs.Tables[0].Rows.Count > 0) { lbPageName.Text = myDs.Tables[0].Rows[0]["PageName"].ToString(); tbSeo_Title.Text = myDs.Tables[0].Rows[0]["Title"].ToString(); tbSeo_Keywords.Text = myDs.Tables[0].Rows[0]["Keywords"].ToString(); tbSeo_Description.Text = myDs.Tables[0].Rows[0]["Description"].ToString(); tbSeo_Author.Text = myDs.Tables[0].Rows[0]["Author"].ToString(); tbPageNameCalled.Text = myDs.Tables[0].Rows[0]["PageNameCalled"].ToString(); } else { myDs.Dispose(); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("没有找到这条数据记录!"); Response.End(); } myDs.Dispose(); myData.ConnClose(myConn); }
protected void btSubmit_Click(object sender, EventArgs e) { string strSql, strTypeID, strCalled, strLink, strPic, strIsShow, strIsShowOther, strID; strID = Request.QueryString["ID"]; if (!FunctionClass.CheckStr(strID, 1)) { FunctionClass.ShowMsgBox("URL错误!"); Response.End(); } strTypeID = ddlType.SelectedValue; strCalled = tbCalled.Text; strLink = tbLink.Text; strIsShow = cblIsShow.SelectedValue; strIsShowOther = cblIsShowOther.SelectedValue; FunctionClass myFun = new FunctionClass(); strPic = myFun.UploadFile(fuProPic, "../upload/", "jpg|png|gif", 512); strSql = "update T_Link set TypeID=@TypeID,Called=@Called,Link=@Link,IsShow=@IsShow,IsShowOther=@IsShowOther where ID=@ID"; string[] ParamsName = new string[] { "@TypeID", "@Called", "@Link", "@IsShow", "@ID", "@IsShowOther" }; string[] ParamsValue = new string[] { strTypeID, strCalled, strLink, strIsShow, strID, strIsShowOther }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); myData.InsertData(strSql, ParamsName, ParamsValue, myConn); if (strPic != "") { myData.ExecuteSql("update T_Link set Pic='" + strPic + "' where ID=" + strID, myConn); } myData.ConnClose(myConn); FunctionClass.ShowMsgBox("修改成功!", ""); Response.End(); }
private void AlertMessage_Load(object sender, EventArgs e) { showuser_panel.BackColor = Color.FromArgb(100, 255, 255, 255); VisitorClass vc = new VisitorClass(); DataTable visitorOut = vc.checkVititorNotOut(); FunctionClass fn = new FunctionClass(); string Message = ""; if (visitorOut.Rows.Count > 0) { foreach (DataRow v in visitorOut.Rows) { Message = "ชื่อ " + v["visit_name"] + ", เวลาเข้า " + fn.ConvertDate(v["visit_datetime_in"].ToString()) + ", เลขที่ " + v["visit_id"] + "\r\n"; showList.Items.Add(Message); } if (Message != "") { Message = "ยังไม่มีเวลาออก กรุณาตรวจสอบ"; showList.Items.Add(Message); } } }
private void rangeClicked(object sender, EventArgs e) { string operatorType = "Range"; Form dlg1 = new AnalyzeForm(); if (analyzeOption(dlg1)) { for (int i = 0; i < Data.columnChoosen.Length; i++) { if (Data.columnChoosen[i] != -1) { int column = Data.columnChoosen[i]; double[] data; int miss, dataSize; double result, parRes, parRes1, parRes2; long timeSeq, timePar, timePar1, timePar2; createDataArr(column, out data, out miss, out dataSize); Debug.WriteLine(miss); result = FunctionClass.Range(data, miss, dataSize, out timeSeq); parRes = ParallelFunctionClass.RangeParTask1(data, miss, dataSize, out timePar); parRes1 = ParallelFunctionClass.RangeParTask2(data, miss, dataSize, out timePar1); Debug.WriteLine("range-nya adalah " + result + " waktu: " + timeSeq); Debug.WriteLine("range_parallel (1): " + parRes + " waktu: " + timePar); Debug.WriteLine("range_parallel (2): " + parRes1 + " waktu: " + timePar1); results.Add(result.ToString()); } } DialogResult dialog = new DialogResult(); Form dialogResult = new ResultForm(operatorType); dialog = dialogResult.ShowDialog(); results.Clear(); } else { dlg1.Close(); } }
protected void btSubmit_Click(object sender, EventArgs e) { string strTip, strTypeCalled, strMemo, strIsShow, strSql; strTypeCalled = tbTypeCalled.Text; strTip = tbTip.Text; strMemo = tbMemo.Text; strIsShow = cblIsShow.SelectedValue; strSql = "insert into T_PayType (Tip,TypeCalled,IsShow,Memo) values (@Tip,@TypeCalled,@IsShow,@Memo)"; string[] ParamsName = new string[] { "@Tip", "@TypeCalled", "@IsShow", "@Memo" }; string[] ParamsValue = new string[] { strTip, strTypeCalled, strIsShow, strMemo }; DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); myData.InsertData(strSql, ParamsName, ParamsValue, myConn); myData.ConnClose(myConn); FunctionClass.ShowMsgBox("添加成功!", ""); Response.End(); }
/// <summary> /// 绑定数据 /// </summary> private void BindData() { string strNewType, strSql; strSql = "select * from T_NewType order by sid,id desc"; ddlNewType.Items.Add(new ListItem("请选择新闻分类", "0")); DataClass myData = new DataClass(); SqlConnection myConn = myData.ConnOpen(); DataSet myDs = myData.GetDataSet(strSql, myConn); myData.InitProTypeList(myDs.Tables[0], 0, ddlNewType, ""); myDs.Dispose(); myData.ConnClose(myConn); //判断是否有传入参数 strNewType = Request.QueryString["NewType"]; if (FunctionClass.CheckStr(strNewType, 1)) { ddlNewType.SelectedValue = strNewType; } }
private SimplificationReturnValue EvaluateFunction(NumberClass expression, FunctionClass fc, IEnumerable<NumberClass> ncList2) { var parser = new Parser(); var ncList = new List<NumberClass>(ncList2); foreach (var cfr in _customFunctions) parser.AddCustomFunction(cfr.Key, cfr.Value); foreach (var v in _variables) { if (v.Value.NumberType == NumberClass.NumberTypes.Float) { parser.AddVariable(v.Key, v.Value.FloatNumber); } if (v.Value.NumberType == NumberClass.NumberTypes.Integer) { parser.AddVariable(v.Key, v.Value.IntNumber); } if (v.Value.NumberType == NumberClass.NumberTypes.Expression) { parser.AddVariable(v.Key, v.Value.Expression); } } foreach (var f in _functions) { parser.AddFunction(f.Name, f.Arguments, f.Expression); } int ndx = 0; foreach (var a in fc.Arguments) { NumberClass nc = ndx >= ncList.Count ? new NumberClass { NumberType = NumberClass.NumberTypes.Integer, IntNumber = 0 } : ncList[ndx]; if (nc.NumberType == NumberClass.NumberTypes.Float) { try { parser.AddVariable(a, nc.FloatNumber); } catch {} } if (nc.NumberType == NumberClass.NumberTypes.Integer) { try { parser.AddVariable(a, nc.IntNumber); }catch { } } if (nc.NumberType == NumberClass.NumberTypes.Expression) parser.AddVariable(a, nc.Expression); ndx++; } return parser.Simplify(expression.Expression); }
private void EvaluateFunction(NumberClass expression, FunctionClass fc) { EvaluateFunction(expression, fc, new List<NumberClass> { new NumberClass {NumberType = NumberClass.NumberTypes.Integer, IntNumber = 0}}); }