protected void btnAction_Click(object sender, EventArgs e)
{
/*if (ddlfield.SelectedIndex == 0)
* {
* labTips.Text = "请选择条件字段";
* Timer1.Enabled = true;
* return;
* }*/
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
DataSet _ds = _bll.selectData(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value), ddlfield.SelectedValue, txtWhere.Text, chkLike.Checked);
if (_ds != null)
{
panSelect1.Visible = true;
gdSelectView.DataSource = _ds;
gdSelectView.DataBind();
}
else
{
panSelect1.Visible = false;
labTips.Text = "条件输入不正确！";
Timer1.Enabled = true;
}
gdSelectView.Visible = true;
}
//获取数据库列表
private DataSet getDatabase()
{
if (connectID != -1 && Session["Server"] != null && Session["mConn"] != null)
{
if (connectID >= 0)
{
ToolBll bll = new ToolBll(Session["mConn"].ToString());
if (bll.TestConnect()) //测试连接状态
{
return(bll.getDatabaseList());
}
else
{
return(null);
}
}
else
{
return(null);
}
}
else
{
return(null);
}
}
protected void btnUSelect_Click(object sender, EventArgs e)
{
int count = 0;
txtUpdateHWhere.Text = txtUpdateWhere.Text;
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
if (_bll.getTmpDateCount(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value), ddlUpdateFiled.SelectedValue, txtUpdateHWhere.Text, out count))
{
gdUpdateView.Visible = true;
gdUpdateView.DataSource = _bll.getUpdateFiled(hidTablesName.Value, hidSchemasName.Value, ddlUpdateFiled.SelectedValue, txtUpdateHWhere.Text);
gdUpdateView.DataBind();
panUpdateButton.Visible = true;
gdUpdateView.Focus();
if (count > 1)
{
litUpdateTips.Text = "您当前的更改可能会影响到" + count + "条数据";
litUpdateTips.Visible = true;
btnDUpdate.OnClientClick = "return confirm('此更新可能会影响" + count + "条数据，请做好列的排除工作，确定更新这些数据吗？')";
}
else
{
litUpdateTips.Text = "";
btnDUpdate.OnClientClick = "return confirm('确定要更新该数据吗？')";
}
}
else
{
labUpdate.Text = "没有记录！";
panUpdateButton.Visible = false;
Timer1.Enabled = true;
}
}
protected void btnDUpdate_Click(object sender, EventArgs e)
{
string[] strs = new string[gdUpdateView.Rows.Count];
List <SqlParameter> paras = new List <SqlParameter>();
for (int i = 0; i < gdUpdateView.Rows.Count; i++)
{
if (((TextBox)gdUpdateView.Rows[i].FindControl("txtDataUpdateValue")).Enabled)
{
//Changed on 2015.06.04
strs[i] = ("[" + ((Label)gdUpdateView.Rows[i].FindControl("labUpdateColumn")).Text + "]=@value" + i);
paras.Add(new SqlParameter("@value" + i, ((TextBox)gdUpdateView.Rows[i].FindControl("txtDataUpdateValue")).Text));
}
else
{
strs[i] = "";
}
}
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
int rows;
if (_bll.updateViewData(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value), strs, ddlUpdateFiled.SelectedValue, txtUpdateHWhere.Text, paras, out rows))
{
labUpdate.Text = "修改成功，" + rows + "条数据被修改！";
//panUpdateButton.Visible = false;
}
else
{
labUpdate.Text = "修改失败，请检查输入的数据类型是否匹配！";
}
Timer1.Enabled = true;
}
protected void btnProcExecAction_Click(object sender, EventArgs e)
{
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
DataSet ds;
try
{
labProcExec.Text = "";
if (hidProcExec.Value.Trim().Equals(""))
{
ds = _bll.execProc(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value));
}
else
{
ds = _bll.execProc(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value), hidProcExec.Value.Split(','), txtProcExec.Text);
}
if (ds != null)
{
panProcExecData.Visible = true;
gdProcedureData.DataSource = ds;
gdProcedureData.DataBind();
}
}
catch (Exception er)
{
panProcExecData.Visible = false;
labProcExec.Text = er.Message;
}
}
protected void btnInsertAction_Click(object sender, EventArgs e)
{
string[] filds = new string[gdInsertView.Rows.Count];
string[] strs = new string[gdInsertView.Rows.Count];
for (int i = 0; i < gdInsertView.Rows.Count; i++)
{
//Changed 2015.06.04
//strs[i] = ((TextBox)gdInsertView.Rows[i].FindControl("txtDataValue")).Text;
if (((TextBox)gdInsertView.Rows[i].FindControl("txtDataValue")).Enabled)
{
filds[i] = ((Label)gdInsertView.Rows[i].FindControl("labInsertColumn")).Text;
strs[i] = ((TextBox)gdInsertView.Rows[i].FindControl("txtDataValue")).Text;
}
else
{
filds[i] = "";
}
}
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
if (_bll.InsertValue(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value), filds, strs))
{
litInsertTip.Text = "新增成功！";
litDetail.Text = _bll.getTableCount(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value));
}
else
{
litInsertTip.Text = "新增失败，请检查输入的数据类型是否匹配！";
}
Timer1.Enabled = true;
}
protected void lnkDeleteDatabase_Click(object sender, EventArgs e)
{
getSconn();
_bll = new ToolBll(Session["mConn"].ToString());
_bll.deleteDatabase(labDataBase.Text);
closeSelect();
panMessage.Visible =
panTabControl.Visible =
panToolBar.Visible = false;
showDatabase();
}
static void CopyDirectory(DirectoryInfo source, DirectoryInfo destination)
{
try
{
ToolBll bll = new ToolBll();
if (!destination.Exists)
{
destination.Create();
}
// Copy all files.
FileInfo[] files = source.GetFiles();
MessageBox.Show("Tong so file : ", files.Length.ToString());
if (files.Length == 0)
{
MessageBox.Show("Không có file nào!", "Mess", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
foreach (FileInfo file in files)
{
string pos = destination + file.Name.Substring(11, 4);
string tmcha = pos + @"\" + file.Name.Substring(17, 4).Trim();
string tmcon = tmcha + @"\" + file.Name.Substring(17, 6).Trim();
bll.TaoThuMuc(pos);
bll.TaoThuMuc(tmcha);
bll.TaoThuMuc(tmcon);
if (!Directory.Exists(tmcon))
{
MessageBox.Show("Không có thư mục : " + tmcon, "Thông báo", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
if (!File.Exists(tmcon + @"\" + file.Name))
{
file.MoveTo(tmcon + @"\" + file.Name);
}
//MessageBox.Show("File tồn tại : " + tmcon + @"\" + file.Name, "Thông báo", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
MessageBox.Show("Move OK!", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Warning);
//// Process subdirectories.
//DirectoryInfo[] dirs = source.GetDirectories();
//foreach (DirectoryInfo dir in dirs)
//{
// // Get destination directory.
// string destinationDir = Path.Combine(destination.FullName, dir.Name);
// // Call CopyDirectory() recursively.
// CopyDirectory(dir, new DirectoryInfo(destinationDir));
//}
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
protected void btnNewData_Click(object sender, EventArgs e)
{
if (!panInsert.Visible)
{
closeSelect();
labHeaderName.Text = "新增数据";
panInsert.Visible = true;
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
gdInsertView.DataSource = _bll.getInsertFiled(hidTablesName.Value, hidSchemasName.Value);
gdInsertView.DataBind();
}
}
protected void btnNewSelect_Click(object sender, EventArgs e)
{
if (!panSelect0.Visible)
{
ddlfield.Items.Clear();
closeSelect();
labHeaderName.Text = "查询数据";
//strs_sys = new ListItemCollection();
//strs_sys.Add("请选择");
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
panSelect0.Visible = true;
foreach (DataRow row in _bll.getDatatablefield(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value)).Tables["field"].Rows)
{
ddlfield.Items.Add(new ListItem(row[0].ToString(), "[" + row[0].ToString() + "]"));
}
}
}
private void reConnected()
{
ConnectionStrings dlconn = new ConnectionStrings(txtConnection.Text.Trim('"'));
Session["Server"] = dlconn.server;//2016.1.4 Changed
Session["mConn"] = dlconn.OriginalConnectionString;
if (!showDatabase())
{
labReConnect.Text = "连接失败，请重试！";
imgReConnect.Visible = false;
labServer.Text = dlconn.server;
return;
}
labServer.Text = dlconn.server;
int index = ExsitDatabase(ddlDatabase.Items, dlconn.database);
if (index >= 0 && !dlconn.database.Equals("master"))
{
ddlDatabase.SelectedIndex = index;
Session["Database"] = dlconn.database = ddlDatabase.SelectedValue;
labDataBase.Text = Session["Database"].ToString();
dlconn.correctConnectString();//2015.6.19 Changed
Session["sConn"] = dlconn.connection;
_bll = new ToolBll(dlconn.connection);
lsbDataTable.Items.Clear();
BindDataList(TYPE_TABLE);
txtConnection.Text = dlconn.connection;
//Changed to 2015.06.04
panMessage.Visible = false;
//closeSelect();
lnkDelete.Visible = false;
lnkDeleteDatabase.Visible = !findAnyString(SYSTEM_DB, labDataBase.Text);
}
else
{
labReConnect.Text = "连接成功！";
}
if (!linkExit.Visible && linkBack.Visible)
{
linkExit.Visible = true;
linkBack.Visible = false;
}
imgReConnect.Visible = false;
}
protected void btnDDelete_Click(object sender, EventArgs e)
{
int count = 0;
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
if (_bll.deleteViewData(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value), ddlUpdateFiled.SelectedValue, txtUpdateHWhere.Text, out count))
{
labUpdate.Text = count + "条数据成功删除！";
litDetail.Text = _bll.getTableCount(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value));
Timer1.Enabled = true;
panUpdateButton.Visible = gdUpdateView.Visible = false;
}
else
{
labUpdate.Text = "删除失败！";
Timer1.Enabled = true;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (!panUpdate.Visible)
{
closeSelect();
ddlUpdateFiled.Items.Clear();
labHeaderName.Text = "修改&删除数据";
panUpdate.Visible = true;
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
//绑定列名列表
//strs_sys = new ListItemCollection();
foreach (DataRow row in _bll.getDatatablefield(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value)).Tables["field"].Rows)
{
//Changed on 2015.06.04
ddlUpdateFiled.Items.Add(new ListItem(row[0].ToString(), "[" + row[0].ToString() + "]"));
}
}
}
protected void lsbDataTable_SelectedIndexChanged(object sender, EventArgs e)
{
panMessage.Visible = true;
lsbDataView.SelectedIndex = -1;
lsbProcedures.SelectedIndex = -1;
labTableName.Text = "表名：" + lsbDataTable.SelectedItem.Text;
hidTabType.Value = TYPE_TABLE;
lnkDelete.OnClientClick = "return confirm('确定要删除该表？（删除后将无法恢复）');";
stables = lsbDataTable.SelectedValue.Split('.');
hidSchemasName.Value = stables[0];
hidTablesName.Value = stables[1];
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
litDetail.Text = _bll.getTableCount(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value));
btnShowTop100.NavigateUrl = "DataList.aspx?table=" + hidTablesName.Value + "&schemas=" + hidSchemasName.Value;
closeSelect();
panTableCount.Visible = lnkDelete.Visible = btnShowTop100.Visible = btnNewSelect.Visible = btnNewData.Visible = btnUpdate.Visible = btnDelete.Visible = true;
btnProcparam.Visible = btnProcAction.Visible = btnDefine.Visible = false;
}
protected void lnkDelete_Click(object sender, EventArgs e)
{
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
switch (hidTabType.Value)
{
case TYPE_TABLE:
{
if (lsbDataTable.SelectedIndex >= 0 && lsbDataTable.SelectedValue != null)
{
_bll.deleteTable(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value));
}
break;
}
case TYPE_VIEW:
{
if (lsbDataView.SelectedIndex >= 0 && lsbDataView.SelectedValue != null)
{
_bll.deleteView(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value));
}
break;
}
case TYPE_PROC:
{
if (lsbProcedures.SelectedIndex >= 0 && lsbProcedures.SelectedValue != null)
{
_bll.deleteProcedure(getAbsoluteTableName(hidSchemasName.Value, hidTablesName.Value));
}
break;
}
}
//Changed on 2015.06.04
BindDataList(hidTabType.Value);
panToolBar.Visible = true;
panMessage.Visible = false;
lnkDelete.Visible = false;
closeSelect();
}
private void InitBind(string table)
{
if (Session["sConn"] == null)
{
return;
}
ToolBll _bll = new ToolBll(Session["sConn"].ToString());
DataSet ds = _bll.getDataTopList(table);
if (ds != null)
{
gvDataList.DataSource = ds.Tables[0];
gvDataList.DataBind();
litName.Text = tName + mName;
if (gvDataList.PageCount > 1)
{
litPage.Text = "页码：" + (gvDataList.PageIndex + 1) + "/" + gvDataList.PageCount;
}
hidTableName.Value = table;
}
}
protected void btnTest_Click(object sender, EventArgs e)
{
if (txtServerName.Text.Trim().Length < 1)
{
Common.regesterScript(this, "ser", "alert('请输入服务器名！');");
txtServerName.Focus();
}
else if (txtUserName.Text.Trim().Length < 1 && rdbSql.Checked)
{
Common.regesterScript(this, "usr", "alert('请输入用户名！');");
txtUserName.Focus();
}
else
{
ToolBll bll;
string sql = "Data Source=" + txtServerName.Text + ";Initial Catalog=master;Integrated Security=True";
string conn = "Server=" + txtServerName.Text + ";Database=master; UID=" + txtUserName.Text + "; PWD=" + txtPsd.Text + "; Connection Timeout=4500;Pooling=True;";
if (rdbSql.Checked)
{
bll = new ToolBll(conn);
Session["mConn"] = conn;
}
else
{
bll = new ToolBll(sql);
Session["mConn"] = sql;
}
if (bll.TestConnect())
{
Common.regesterScript(this, "test", "alert('连接成功！');");
Session["LinkID"] = 1;
}
else
{
Common.regesterScript(this, "loos", "alert('连接失败！');");
Session["LinkID"] = -2;
}
}
}
private List <DataProcedure> getParameter()
{
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
List <DataProcedure> _list = _bll.getProcedureParam(hidSchemasName.Value, hidTablesName.Value);
hidProcExec.Value = "";
if (_list.Count > 0)
{
string parast = "";
tmpProcParam = new string[_list.Count];
for (int i = 0; i < _list.Count; i++)
{
tmpProcParam[i] = _list[i].ParaName;
}
foreach (string tmpStr in tmpProcParam)
{
parast += tmpStr + ",";
}
hidProcExec.Value = parast.Trim(',');
}
return(_list);
}
protected void btnExec_Click(object sender, EventArgs e)
{
if (txtMuSql.Text.Trim().Length > 0)
{
if (Session["eConn"] != null || txtMuSql.Text.Trim().StartsWith("use", true, CultureInfo.CurrentCulture) || txtMuSql.Text.Trim().StartsWith("create database", true, CultureInfo.CurrentCulture))
{
string[] sqls = txtMuSql.Text.Trim().Split(SQL_GO, StringSplitOptions.RemoveEmptyEntries);
string results = "";
bool conti = true;
tables = new List <DataTable>();
foreach (string _sql in sqls)
{
if (!conti)
{
results += "<span class='err'>已终止执行</span><br/>";
break;
}
string sql = _sql.Trim();
if (sql.StartsWith("use", true, CultureInfo.CurrentCulture))
{
string[] data = sql.Split(' ');
if (data[0].ToLower().Equals("use") && data.Length > 1)
{
bool db = true;
foreach (ListItem item in ddlDatabase.Items)
{
if (item.Text.ToLower().Equals(data[1].ToLower()))
{
ddlDatabase.SelectedValue = item.Value;
Session["eConn"] = Session["mConn"].ToString().Replace("master", ddlDatabase.SelectedValue);
results += "<span>切换成功</span><br/>";
db = false;
break;
}
}
if (db)
{
results += "<span class='err'>未找到数据库</span><br/>";
conti = false;
}
}
}
else
{
try
{
ToolBll bll;
switch (getSQLType(sql))
{
case SQL_TYPE.SELECT:
bll = new ToolBll(Session["eConn"].ToString());
tables.Add(bll.executeQueryToSelect(sql, tables.Count));
results += "<span>查询成功</span><br/>";
break;
case SQL_TYPE.UPDATE:
bll = new ToolBll(Session["eConn"].ToString());
results += "<span class='blue'>" + bll.executeQueryToUdate(sql) + "行受影响</span><br/>";
break;
case SQL_TYPE.OBJECT:
bll = new ToolBll(Session["eConn"].ToString());
results += bll.executeQueryToObj(sql);
break;
case SQL_TYPE.NEWDB:
bll = new ToolBll(Session["mConn"].ToString());
bll.executeQueryToObj(sql);
results = "<span>新增成功</span><br/>";
showDatabase();
break;
}
}
catch (Exception er)
{
results += "<span class='err'>" + er.Message + "</span><br/>";
conti = false;
}
}
}
txtResoult.InnerHtml = results;
if (tables.Count > 0)
{
divData.Visible = true;
ddlDataTable.DataSource = tables;
ddlDataTable.DataBind();
gdDataTable.DataSource = tables[0];
gdDataTable.DataBind();
}
else
{
divData.Visible = false;
}
}
else
{
Common.regesterAlertScript(this, "err", "请选择一个数据库");
}
}
else
{
Common.regesterAlertScript(this, "err", "请输入SQL脚本");
}
}
private void getProcDefine()
{
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
txtProcDefine.Text = _bll.getProcDefine(hidSchemasName.Value, hidTablesName.Value);
}
private void BindDataList(string type)
{
DataSet ds;
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
ds = _bll.getDataTableList();
if (ds == null)
{
panToolBar.Visible =
panTabControl.Visible = false;
return;
}
lsbDataTable.Items.Clear();
lsbDataView.Items.Clear();
lsbProcedures.Items.Clear();
btnSelectTable.CssClass = "btn_tab";
foreach (DataRow row in ds.Tables["datatable"].Rows)
{
lsbDataTable.Items.Add(new ListItem(row["name"].ToString(), row["schemas"].ToString() + "." + row["name"].ToString()));
}
ds = _bll.getDataViewList();
if (ds.Tables["datatable"].Rows.Count > 0)
{
btnSelectView.Visible = true;
btnSelectView.CssClass = "btn_tab";
foreach (DataRow row in ds.Tables["datatable"].Rows)
{
lsbDataView.Items.Add(new ListItem(row["name"].ToString(), row["schemas"].ToString() + "." + row["name"].ToString()));
}
}
else
{
btnSelectView.Visible = false;
if (type == TYPE_VIEW)
{
type = TYPE_TABLE;
}
}
ds = _bll.getDataProcedureList();
if (ds.Tables["datatable"].Rows.Count > 0)
{
btnSelectProcedures.Visible = true;
btnSelectProcedures.CssClass = "btn_tab";
foreach (DataRow row in ds.Tables["datatable"].Rows)
{
lsbProcedures.Items.Add(new ListItem(row["name"].ToString(), row["schemas"].ToString() + "." + row["name"].ToString()));
}
}
else
{
btnSelectProcedures.Visible = false;
if (type == TYPE_PROC)
{
type = TYPE_TABLE;
}
}
switch (type)
{
case TYPE_TABLE:
{
mlvList.SetActiveView(viewTable);
hidTabType.Value = TYPE_TABLE;
btnSelectTable.CssClass = "btn_tab_pause";
break;
}
case TYPE_VIEW:
{
mlvList.SetActiveView(viewView);
hidTabType.Value = TYPE_VIEW;
btnSelectView.CssClass = "btn_tab_pause";
break;
}
case TYPE_PROC:
{
mlvList.SetActiveView(viewProcedure);
hidTabType.Value = TYPE_PROC;
btnSelectProcedures.CssClass = "btn_tab_pause";
break;
}
default:
{
mlvList.SetActiveView(viewTable);
hidTabType.Value = TYPE_TABLE;
btnSelectTable.CssClass = "btn_tab_pause";
break;
}
}
panToolBar.Visible =
panTabControl.Visible = true;
}
protected void btnNewTable_Click(object sender, EventArgs e)
{
if ((!rdbNewProc.Checked && !rdbCustom.Checked) && txtNewTable_Name.Text.Trim().Length == 0)
{
labNewTableTip.Text = "请输入表名";
Timer1.Enabled = true;
return;
}
if (txtColumnList.Text.Trim().Length < 1)
{
labNewTableTip.Text = "请输入定义或SQL脚本";
Timer1.Enabled = true;
return;
}
getSconn();
_bll = new ToolBll(Session["sConn"].ToString());
labNewTableTip.Text = "正在执行";
if (rdbNewTable.Checked)
{
if (_bll.createTable(txtNewTable_Name.Text.Trim(), txtColumnList.Text.Trim()))
{
labNewTableTip.Text = "新增成功";
BindDataList(hidTabType.Value);
panToolBar.Visible = true;
panMessage.Visible = false;
lnkDelete.Visible = false;
txtNewTable_Name.Text = txtColumnList.Text = string.Empty;
}
else
{
labNewTableTip.Text = "新增失败，请检查输入是否有误";
}
}
else if (rdbNewView.Checked)
{
if (_bll.createView(txtNewTable_Name.Text.Trim(), txtColumnList.Text.Trim()))
{
labNewTableTip.Text = "新增成功";
BindDataList(hidTabType.Value);
panToolBar.Visible = true;
panMessage.Visible = false;
lnkDelete.Visible = false;
txtNewTable_Name.Text = txtColumnList.Text = string.Empty;
}
else
{
labNewTableTip.Text = "新增失败，请检查输入是否有误";
}
}
else if (rdbNewProc.Checked || rdbCustom.Checked)
{
if (!txtColumnList.Text.StartsWith("create", true, CultureInfo.CurrentCulture))
{
labNewTableTip.Text = "只能执行create语句";
}
else if (_bll.createProcedure(txtColumnList.Text))
{
labNewTableTip.Text = "新增成功";
BindDataList(hidTabType.Value);
panToolBar.Visible = true;
panMessage.Visible = false;
lnkDelete.Visible = false;
txtNewTable_Name.Text = txtColumnList.Text = string.Empty;
}
else
{
labNewTableTip.Text = "执行失败，请检查输入是否有误";
}
}
Timer1.Enabled = true;
}
