📄 start_catch.aspx.cs
字号:
// {
// b = b.Replace(tihuan1[k], tihuan2[k]);
// }
// else
// {
// b = b.Replace(tihuan1[k], tihuan2[0]);
// }
// }
// else
// {
// b = b.Replace(tihuan1[k], "");
// }
// }
// }
//}
if (rule6 != "")
{
string[] tihuan1 = split(rule6, "||||");
string[] tihuan2 = split(rule7, "||||");
for (int n = 0; n < tihuan1.Length; n++)
{
if (rule6 != "")
{
if (rule7 != "")
{
if (tihuan1.Length == tihuan2.Length)
{
Regex myreg = new Regex(tihuan1[n], RegexOptions.Singleline);
a = myreg.Replace(a, tihuan2[n]);
}
else
{
Regex myreg = new Regex(tihuan1[n], RegexOptions.Singleline);
a = myreg.Replace(a, tihuan2[0]);
}
}
else
{
Regex myreg = new Regex(tihuan1[n], RegexOptions.Singleline);
a = myreg.Replace(a, "");
}
}
}
}
savedata.arctitle.Add(endtitle[i].ToString());
savedata.value.Add(a);
}
}
catch
{
}
}
#region 字符串充当分隔符
/// <summary>
/// 字符串充当分隔符，分割字符串
/// </summary>
/// <param name="strinput">字符串</param>
/// <param name="sp">分割符</param>
/// <returns></returns>
public static string[] split(string strinput, string sp)
{
string tmp = "";
int strlen = 0, splen = 0;
int found = 0;
string[] rt = null;//返回数组
try
{
//输入判断
if (strinput == null || sp == null || strinput.Length == 0 || sp.Length == 0) return null;
//初始化一个数组列表（当做动态数组）
System.Collections.ArrayList tmp3 = new ArrayList();
strlen = strinput.Length;//获得输入字符串的长度
splen = sp.Length;//分隔符的长度
for (int i = 0; i < strlen; i++)
{
//查找分隔符
found = strinput.IndexOf(sp, i);
if (found >= 0)
{
tmp = "";
//取分隔符前的字符串
tmp = strinput.Substring(i, found - i);
//添加到数组列表
tmp3.Add(tmp);
i = found + splen - 1;
}
else
{
string tmp2 = "";
//取最后的字符串
tmp2 = strinput.Substring(i);
if (tmp2 != "")
tmp3.Add(tmp2);
break;
}
}
//将动态数组的维数设置成实际存在的元素个数，因为数组列表是以16的倍数递增维数的
tmp3.TrimToSize();
//转换数组列表为字符串数组，并返回。
rt = (string[])tmp3.ToArray(typeof(String));
tmp3.Clear();
}
catch (Exception e)
{
//Console.WriteLine("{0}", e.Message);
throw e;
}
return rt;
}
#endregion
protected void Button3_Click(object sender, EventArgs e)
{
if (this.DropDownList1.SelectedItem.Text == "MYSQL")
{
string sql = string.Format("show tables");
DataSet mysqlds = getmysqldata(sql);
for (int i = 0; i < mysqlds.Tables[0].Rows.Count; i++)
{
this.DropDownList2.Items.Add(mysqlds.Tables[0].Rows[i][0].ToString());
}
for (int i = 0; i < mysqlds.Tables[0].Rows.Count; i++)
{
this.DropDownList3.Items.Add(mysqlds.Tables[0].Rows[i][0].ToString());
}
this.Panel4.Visible = true;
}
if (this.DropDownList1.SelectedItem.Text == "SQLSERVER")
{
string sql = string.Format("select name from sysobjects where type='u'");
DataSet sqlds = getsqldata(sql);
for (int i = 0; i < sqlds.Tables[0].Rows.Count; i++)
{
this.DropDownList2.Items.Add(sqlds.Tables[0].Rows[i][0].ToString());
}
for (int i = 0; i < sqlds.Tables[0].Rows.Count; i++)
{
this.DropDownList3.Items.Add(sqlds.Tables[0].Rows[i][0].ToString());
}
this.Panel4.Visible = true;
}
}
protected void Button4_Click(object sender, EventArgs e)
{
try
{
if (this.TextBox13.Text == "catch")
{
if (this.DropDownList1.SelectedItem.Text == "MYSQL")
{
if (this.TextBox14.Text.Trim() != "")
{
for (int i = 0; i < savedata.value.Count; i++)
{
string strHostIP = "";
IPHostEntry oIPHost = Dns.Resolve(Environment.MachineName);
if (oIPHost.AddressList.Length > 0)
strHostIP = oIPHost.AddressList[0].ToString();
DateTime DateTime1970 = new DateTime(1970, 1, 1);
TimeSpan t = DateTime.Now.AddHours(-8) - DateTime1970;
string stringvalue = string.Format(ConfigurationManager.AppSettings["mysql"].ToString(), DropDownList2.SelectedItem.Value, this.TextBox14.Text.Trim(), this.TextBox16.Text.Trim(), this.TextBox17.Text.Trim(), savedata.arctitle[i].ToString(), ((int)t.TotalSeconds).ToString(), ((int)t.TotalSeconds).ToString(), this.TextBox16.Text.Trim(), "4");
setinsertdata(stringvalue);
DataSet mydsfid = getmysqlnum(string.Format(ConfigurationManager.AppSettings["sql"].ToString(), this.DropDownList2.SelectedItem.Text.Trim()));
string stringvalue1 = string.Format(ConfigurationManager.AppSettings["mysqlone"].ToString(), this.DropDownList3.SelectedItem.Text.Trim(), this.TextBox14.Text.Trim(), int.Parse(mydsfid.Tables[0].Rows[0][0].ToString()), this.TextBox16.Text.Trim(), this.TextBox17.Text.Trim(), savedata.arctitle[i].ToString(), ((int)t.TotalSeconds).ToString(), savedata.value[i].ToString(), strHostIP);
setinsertdata(stringvalue1);
}
Response.Write("<script>alert('入库完成')</script>");
this.Panel1.Visible = false;
this.Panel2.Visible = false;
this.Panel3.Visible = false;
this.Panel4.Visible = false;
}
else
{
Response.Write("<script>alert('请填写入库ID')</script>");
}
}
if (this.DropDownList1.SelectedItem.Text == "SQLSERVER")
{
if (this.TextBox14.Text.Trim() != "")
{
for (int i = 0; i < savedata.value.Count; i++)
{
string strHostIP = "";
IPHostEntry oIPHost = Dns.Resolve(Environment.MachineName);
if (oIPHost.AddressList.Length > 0)
strHostIP = oIPHost.AddressList[0].ToString();
DateTime DateTime1970 = new DateTime(1970, 1, 1);
TimeSpan t = DateTime.Now.AddHours(-8) - DateTime1970;
string stringvalue = string.Format(ConfigurationManager.AppSettings["mysql"].ToString(), DropDownList2.SelectedItem.Value, this.TextBox14.Text.Trim(), this.TextBox16.Text.Trim(), this.TextBox17.Text.Trim(), savedata.arctitle[i].ToString(), ((int)t.TotalSeconds).ToString(), ((int)t.TotalSeconds).ToString(), this.TextBox16.Text.Trim(), "4");
setsqlserver(stringvalue);
DataSet mydsfid = getnum(string.Format(ConfigurationManager.AppSettings["sql"].ToString(), this.DropDownList2.SelectedItem.Text.Trim()));
string stringvalue1 = string.Format(ConfigurationManager.AppSettings["mysqlone"].ToString(), this.DropDownList3.SelectedItem.Text.Trim(), this.TextBox14.Text.Trim(), int.Parse(mydsfid.Tables[0].Rows[0][0].ToString()), this.TextBox16.Text.Trim(), this.TextBox17.Text.Trim(), savedata.arctitle[i].ToString(), ((int)t.TotalSeconds).ToString(), savedata.value[i].ToString(), strHostIP);
setsqlserver(stringvalue1);
}
Response.Write("<script>alert('入库完成')</script>");
this.Panel1.Visible = false;
this.Panel2.Visible = false;
this.Panel3.Visible = false;
this.Panel4.Visible = false;
}
else
{
Response.Write("<script>alert('请填写入库ID')</script>");
}
}
}
if (this.TextBox13.Text == "shanxihu")
{
if (this.DropDownList1.SelectedItem.Text == "MYSQL")
{
if (this.TextBox14.Text.Trim() != "")
{
for (int i = 0; i < savedata.value.Count; i++)
{
if (savedata.value[i].ToString() != "")
{
string strHostIP = "";
IPHostEntry oIPHost = Dns.Resolve(Environment.MachineName);
if (oIPHost.AddressList.Length > 0)
strHostIP = oIPHost.AddressList[0].ToString();
DateTime DateTime1970 = new DateTime(1970, 1, 1);
TimeSpan t = DateTime.Now.AddHours(-8) - DateTime1970;
string stringvalue = string.Format(ConfigurationManager.AppSettings["shanxihusql"].ToString(), DropDownList2.SelectedItem.Value, this.TextBox14.Text.Trim(), this.TextBox16.Text.Trim(), this.TextBox17.Text.Trim(), savedata.arctitle[i].ToString(), ((int)t.TotalSeconds).ToString(), ((int)t.TotalSeconds).ToString(), this.TextBox16.Text.Trim());
setinsertdata(stringvalue);
DataSet mydsfid = getmysqlnum(string.Format(ConfigurationManager.AppSettings["sql"].ToString(), this.DropDownList2.SelectedItem.Text.Trim()));
string stringvalue1 = string.Format(ConfigurationManager.AppSettings["mysqlone"].ToString(), this.DropDownList3.SelectedItem.Text.Trim(), this.TextBox14.Text.Trim(), int.Parse(mydsfid.Tables[0].Rows[0][0].ToString()), this.TextBox16.Text.Trim(), this.TextBox17.Text.Trim(), savedata.arctitle[i].ToString(), ((int)t.TotalSeconds).ToString(), savedata.value[i].ToString(), strHostIP);
setinsertdata(stringvalue1);
}
}
Response.Write("<script>alert('入库完成')</script>");
this.Panel1.Visible = false;
this.Panel2.Visible = false;
this.Panel3.Visible = false;
this.Panel4.Visible = false;
}
else
{
Response.Write("<script>alert('请填写入库ID')</script>");
}
}
if (this.DropDownList1.SelectedItem.Text == "SQLSERVER")
{
if (this.TextBox14.Text.Trim() != "")
{
for (int i = 0; i < savedata.value.Count; i++)
{
if (savedata.value[i].ToString() != "")
{
string strHostIP = "";
IPHostEntry oIPHost = Dns.Resolve(Environment.MachineName);
if (oIPHost.AddressList.Length > 0)
strHostIP = oIPHost.AddressList[0].ToString();
DateTime DateTime1970 = new DateTime(1970, 1, 1);
TimeSpan t = DateTime.Now.AddHours(-8) - DateTime1970;
string stringvalue = string.Format(ConfigurationManager.AppSettings["shanxihusql"].ToString(), DropDownList2.SelectedItem.Value, this.TextBox14.Text.Trim(), this.TextBox16.Text.Trim(), this.TextBox17.Text.Trim(), savedata.arctitle[i].ToString(), ((int)t.TotalSeconds).ToString(), ((int)t.TotalSeconds).ToString(), this.TextBox16.Text.Trim(), "4");
setsqlserver(stringvalue);
DataSet mydsfid = getnum(string.Format(ConfigurationManager.AppSettings["sql"].ToString(), this.DropDownList2.SelectedItem.Text.Trim()));
string stringvalue1 = string.Format(ConfigurationManager.AppSettings["mysqlone"].ToString(), this.DropDownList3.SelectedItem.Text.Trim(), this.TextBox14.Text.Trim(), int.Parse(mydsfid.Tables[0].Rows[0][0].ToString()), this.TextBox16.Text.Trim(), this.TextBox17.Text.Trim(), savedata.arctitle[i].ToString(), ((int)t.TotalSeconds).ToString(), savedata.value[i].ToString(), strHostIP);
setsqlserver(stringvalue1);
}
}
Response.Write("<script>alert('入库完成')</script>");
this.Panel1.Visible = false;
this.Panel2.Visible = false;
this.Panel3.Visible = false;
this.Panel4.Visible = false;
}
else
{
Response.Write("<script>alert('请填写入库ID')</script>");
}
}
}
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
this.Panel3.Visible = true;
this.Panel4.Visible = false;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -