/// <summary>
/// 编辑分页脚本
/// </summary>
/// <param name="sender">事件发送者</param>
/// <param name="e">事件参数</param>
private void bEditScript_Click(object sender, EventArgs e)
{
Node currentNode = guideTree.SelectedNode;
string id = currentNode.Tag as string;
string scriptText = "";
SqlCommand cmd;
string sqlString;
byte[] buffer;
try
{
OpenConnection();
cmd = conn.CreateCommand();
sqlString = string.Format("SELECT Script FROM {0} WHERE ID = {1}",
tabTableName, id);
cmd.CommandText = sqlString;
object executeResult = cmd.ExecuteScalar();
if (executeResult != null && !(executeResult is DBNull))
{
buffer = executeResult as byte[];
scriptText = Encoding.Unicode.GetString(buffer);
}
}
catch (SqlException ex)
{
PrintExceptionMessage(ex);
}
finally
{
CloseConnection();
}
ScriptEditForm scriptEditForm = new ScriptEditForm(scriptText);
if (scriptEditForm.ShowDialog() == DialogResult.OK)
{
scriptText = scriptEditForm.ScriptText;
buffer = Encoding.Unicode.GetBytes(scriptText);
try
{
OpenConnection();
cmd = conn.CreateCommand();
SqlParameter sqlParameter = new SqlParameter("@data", buffer);
cmd.Parameters.Add(sqlParameter);
sqlString = string.Format("UPDATE {0} SET Script = @data WHERE ID = {1}",
tabTableName, id);
cmd.CommandText = sqlString;
cmd.ExecuteScalar();
}
catch (SqlException ex)
{
PrintExceptionMessage(ex);
}
finally
{
CloseConnection();
}
}
}
/// <summary>
/// 编辑分页脚本
/// </summary>
/// <param name="sender">事件发送者</param>
/// <param name="e">事件参数</param>
private void bEditScript_Click(object sender, EventArgs e)
{
Node currentNode = guideTree.SelectedNode;
string id = currentNode.Tag as string;
string scriptText = "";
SqlCommand cmd;
string sqlString;
byte[] buffer;
try
{
OpenConnection();
cmd = conn.CreateCommand();
sqlString = string.Format("SELECT Script FROM {0} WHERE ID = {1}",
tabTableName, id);
cmd.CommandText = sqlString;
object executeResult = cmd.ExecuteScalar();
if (executeResult != null && !(executeResult is DBNull))
{
buffer = executeResult as byte[];
scriptText = Encoding.Unicode.GetString(buffer);
}
}
catch (SqlException ex)
{
PrintExceptionMessage(ex);
}
finally
{
CloseConnection();
}
ScriptEditForm scriptEditForm = new ScriptEditForm(scriptText);
if (scriptEditForm.ShowDialog() == DialogResult.OK)
{
scriptText = scriptEditForm.ScriptText;
buffer = Encoding.Unicode.GetBytes(scriptText);
try
{
OpenConnection();
cmd = conn.CreateCommand();
SqlParameter sqlParameter = new SqlParameter("@data", buffer);
cmd.Parameters.Add(sqlParameter);
sqlString = string.Format("UPDATE {0} SET Script = @data WHERE ID = {1}",
tabTableName, id);
cmd.CommandText = sqlString;
cmd.ExecuteScalar();
}
catch(SqlException ex)
{
PrintExceptionMessage(ex);
}
finally
{
CloseConnection();
}
}
}