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