static void Country(string CountryID)
{
_CountryID = CountryID;
Data.DataTable srs;
srs = SQLTools.GetDataTable("Select CountryName from Country Where CountryID = " + _CountryID);
_CountryName = srs.Rows[0][CountryName];
}
private void MainWindow_Load(object sender, EventArgs e)
{
Landed load = new Landed();
load.Owner = this;
load.Show();
//动态生成按钮
for (int i = 0; i < 20; i++)
{
btn[i] = new Button();
btn[i].Width = 75;
btn[i].Height = 30;
btn[i].Top = 30 * (i / 10) + 400;
btn[i].Left = 75 * (i % 10) + 22;
btn[i].Text = "第" + (i + 1) + "题";
btn[i].Tag = i.ToString();
btn[i].Click += btn_Click;
btn[i].BackColor = Color.Red;
this.Controls.Add(btn[i]);
}
//获取题目
dt = SQLTools.getDT();
//默认加载第一题（第一个按钮）
btn_Click(btn[0], e);
//题目装载
for (int i = 0; i < 20; i++)
{
DataRow dr = data.NewRow();
dr["ID"] = dt.Rows[i][0];
data.Rows.Add(dr);
}
}
protected void SetColors()
{
var dt = new DataTable();
dt = SQLTools.GetDataTable("SELECT SignInFormControl, SignInFormColor FROM SignInFormColor");
foreach (DataRow row in dt.Rows)
{
string myControl = row["SignInFormControl"].ToString();
if (myControl == "Page Background")
{
pagebody.Attributes.Add("bgcolor", row["SignInFormColor"].ToString());
}
else
{
this.Session[myControl + "Color"] = row["SignInFormColor"].ToString();
}
}
PhotoPanel.BackColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section BackgroundColor"].ToString());
PhotoPanel.BorderColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section BorderColor"].ToString());
PersonalInfoPanel.BackColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section BackgroundColor"].ToString());
PersonalInfoPanel.BorderColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section BorderColor"].ToString());
AddressPanel.BackColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section BackgroundColor"].ToString());
AddressPanel.BorderColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section BorderColor"].ToString());
lblPersonalInfoPanel.ForeColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section Header TextColor"].ToString());
lblAddressPanel.ForeColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section Header TextColor"].ToString());
cbCertifiedDiver.ForeColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section TextColor"].ToString());
}
// To Displays the employee list using SQLTools class file
public ActionResult EmpList()
{
SQLTools.connect();
DataTable dt = SQLTools.ExecuteSelect("Select * from EmployeeDetails");
SQLTools.CloseConnection();
return(View(dt));
}
//交卷按钮
private void button3_Click(object sender, EventArgs e)
{
if (MessageBox.Show("是否提交？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
SQLTools.doInsert(data);
MessageBox.Show("提交成功！");
this.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
Insurance.LabelAttributes.Add("ID", "lblInsurance");
CountryID.DataBind();
EmergencyCountryID.DataBind();
HowHearTextID.DataBind();
WhereStayID.DataBind();
DiveLevelID.DataBind();
DiveOrgID.DataBind();
LanguageID.DataBind();
//Add blank item at index 0
CountryID.Items.Insert(0, new ListItem("--Select--", "0"));
CountryID.SelectedIndex = -1;
EmergencyCountryID.Items.Insert(0, new ListItem("--Select--", "0"));
EmergencyCountryID.SelectedIndex = -1;
Gender.Items.Insert(0, new ListItem("--Select--", "0"));
DiveOrgID.Items.Insert(0, new ListItem("--Select--", "0"));
DiveLevelID.Items.Insert(0, new ListItem("--Select--", "0"));
WhereStayID.Items.Insert(0, new ListItem("--Select--", "0"));
HowHearTextID.Items.Insert(0, new ListItem("--Select--", "0"));
LanguageID.Items.Insert(0, new ListItem("--Select--", "0"));
//
var Termsdt = new DataTable();
Termsdt = SQLTools.GetDataTable("SELECT TermsText, ShowTerms, [Language] FROM GlobalSettings, [Language] WHERE GlobalSettings.LanguageID = [Language].LanguageID");
if (Termsdt.Rows[0]["ShowTerms"] == "True")
{
this.Session["ShowTerms"] = true;
pTerms.InnerHtml = Termsdt.Rows[0]["TermsText"].ToString().Replace(System.Environment.NewLine, "<br />");
}
else
{
this.Session["ShowTerms"] = false;
}
string language = Termsdt.Rows[0]["Language"].ToString();
optLanguage.SelectedValue = language;
var sectionsdt = new DataTable();
var fieldsdt = new DataTable();
sectionsdt = SQLTools.GetDataTable("SELECT * FROM RegisterFormSection");
this.Session["sectionsdt"] = sectionsdt;
fieldsdt = SQLTools.GetDataTable("SELECT * FROM RegisterFormField WHERE RegisterFormSectionID in (Select RegisterFormSectionID From RegisterFormSection WHERE Display=True)");
this.Session["fieldsdt"] = fieldsdt;
SetColors();
ChangeForm();
if (useCamera == "Yes")
{
FileUploadValidator.Enabled = false;
}
}
}
//插入数据
private void button4_Click(object sender, EventArgs e)
{
int flag = SQLTools.setData(textBox5.Text, textBox6.Text, textBox7.Text);
if (flag != 0)
{
label5.Text = "操作成功完成";
}
else
{
label5.Text = "操作失败！";
}
}
//更新数据
private void button2_Click(object sender, EventArgs e)
{
int flag = SQLTools.updateData(textBox2.Text, textBox3.Text, comboBox1.SelectedItem.ToString(), textBox8.Text);
if (flag != 0)
{
label5.Text = "操作成功完成";
}
else
{
label5.Text = "操作失败！";
}
}
//删除数据
private void button3_Click(object sender, EventArgs e)
{
int flag = SQLTools.removeData(textBox4.Text);
if (flag != 0)
{
label5.Text = "操作成功完成";
}
else
{
label5.Text = "操作失败！";
}
}
//窗口加载事件
private void Form1_Load(object sender, EventArgs e)
{
//设置修改部分的下拉菜单
string[] data = SQLTools.getColumn();
foreach (string str in data)
{
comboBox1.Items.Add(str);
}
comboBox1.SelectedIndex = 0;
radioButton1.Checked = true;
comboBox2.Visible = false;
comboBox3.Visible = false;
}
private void button1_Click(object sender, EventArgs e)
{
bool flag = SQLTools.isLoad(textBox1.Text, textBox2.Text);
if (flag)
{
Owner.Show();
this.Close();
}
else
{
MessageBox.Show("登陆失败，请检查！");
}
}
//复选框 系部 被点击
private void checkBox1_MouseClick(object sender, MouseEventArgs e)
{
radioButton1.Checked = false;
//控制下拉菜单的隐藏显示
if (checkBox1.Checked)
{
comboBox2.Visible = true;
//给系部添加数据
addCombo(SQLTools.getMenu(0), comboBox2);
}
else
{
comboBox2.Visible = false;
}
}
//复选框 专业 被点击
private void checkBox2_MouseClick(object sender, MouseEventArgs e)
{
radioButton1.Checked = false;
if (checkBox2.Checked)
{
comboBox3.Visible = true;
}
else
{
comboBox3.Visible = false;
}
//判断系部是否被选择，不被选择添加所有数据
if (!checkBox1.Checked)
{
addCombo(SQLTools.getMenu(1), comboBox3);
}
}
static void Customer(int CustomerID)
{
string constring = "System.Configuration.ConfigurationManager.ConnectionStrings['" + "ConnectionString" + "'].ConnectionString";
srs = SQLTools.GetDataTable("Select * FROM Customer WHERE CustomerID = " + CustomerID.ToString());
_CusomterID = srs.Rows[0][CustomerID];
_FirstName = srs.Rows[0][FirstName];
_LastName = srs.Rows[0][LastName];
_BirthDate = srs.Rows[0][BirthDate];
_Email = srs.rows[0][Email];
_Gender = srs.Rows[0][Gender];
_Address1 = srs.Rows[0][Address1];
if (srs.Rows[0][Address2] != System.DBNull.Value)
{
_Address2 = srs.Rows[0][Address2];
}
_City = srs.Rows[0][City];
_PostalCode = srs.Rows[0][PostalCode];
_Country = Country.FindCountryByCountryID(srs.Rows[0][CountryID]);
if (srs.Rows[0][StateID] != System.DBNull.Value)
{
_State = State(srs.Rows[0][StateID]);
}
_Phone = srs.Rows[0][Phone];
_PassportNum = srs.Rows[0][PassportNum];
_HowHearTextID = srs.Rows[0][HowHearTextID];
_HowHearSpecific = srs.Rows[0][HowHearSpecific];
_WhereStayID = srs.Rows[0][WhereStayID];
_RoomOther = srs.Rows[0][RoomOther];
_RoomNo = srs.Rows[0][RoomNo];
_EmergencyName = srs.Rows[0][EmergencyName];
_Relationship = srs.Rows[0][Relationship];
_EmergencyNumber = srs.Rows[0][EmergencyNumber];
_EmergencyEmail = srs.Rows[0][EmergencyEmail];
_EmergencyCountry = Country.FindCountryByCountryID(srs.Rows[0][EmergencyCountryID]);
_DiveLevelID = srs.Rows[0][DiveLevelID];
_DiveOrgID = srs.Rows[0][DiveOrgID];
_NumberOfDives = srs.Rows[0][NumberOfDives];
_Insurance = srs.Rows[0][Insurance];
_InsuranceName = srs.Rows[0][InsuranceName];
_Image = srs.Rows[0][Image];
}
private bool DoValidate()
{
try
{
if (txtDetailQuery.Text.Trim().Length == 0)
{
throw new InPutValidationException("Some query text must be specified!", txtDetailQuery);
}
if (!SQLTools.TSQLValid(txtDetailQuery.Text))
{
throw new InPutValidationException("SQL statements may not contain certain keywords (e.g. update, delete, create etc!", txtDetailQuery);
}
return(true);
}
catch (InPutValidationException ex)
{
MessageBox.Show(ex.Message, "Input Validation", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
}
//点击附加查询
private void button6_Click(object sender, EventArgs e)
{
//单选框是否被选中
if (radioButton1.Checked)
{
DataTable dt = SQLTools.findData("' or 1=1;--");
addGrid(dt);
}
else if (checkBox1.Checked && checkBox2.Checked)
{
DataTable dt = SQLTools.getDT(comboBox3.SelectedItem.ToString(), comboBox2.SelectedItem.ToString());
addGrid(dt);
}
else if (checkBox2.Checked) //只有专业被选中
{
DataTable dt = SQLTools.getDT(comboBox3.SelectedItem.ToString(), "");
addGrid(dt);
}
else //系部被选中
{
DataTable dt = SQLTools.getDT("", comboBox2.SelectedItem.ToString());
addGrid(dt);
}
}
private bool DoValidate()
{
try
{
if (txtName.Text.Length == 0)
{
throw new InPutValidationException("Name must be specified!", txtName);
}
if (txtServer.Text.Length == 0)
{
throw new InPutValidationException("The sql server name must be specified!", txtServer);
}
if (txtDatabase.Text.Length == 0)
{
throw new InPutValidationException("The database name must be specified!", txtDatabase);
}
if (!chkIntegratedSec.Checked && txtUserName.Text.Length == 0)
{
throw new InPutValidationException("The user name must be specified when not using integrated security!", txtUserName);
}
if (txtStateQuery.Text.Trim().Length == 0)
{
throw new InPutValidationException("The summary query must be specified!", txtStateQuery);
}
if (!SQLTools.TSQLValid(txtStateQuery.Text))
{
throw new InPutValidationException("SQL statements may not contain certain keywords (e.g. update, delete, create etc!", txtStateQuery);
}
if ((cboSuccessValue.Text == "[null]" && cboWarningValue.Text == "[null]") ||
(cboSuccessValue.Text == "[null]" && cboErrorValue.Text == "[null]") ||
(cboWarningValue.Text == "[null]" && cboErrorValue.Text == "[null]"))
{
throw new InPutValidationException("Only one value can be [null]!", cboSuccessValue);
}
if ((cboSuccessValue.Text == "[any]" && cboWarningValue.Text == "[any]") ||
(cboSuccessValue.Text == "[any]" && cboErrorValue.Text == "[any]") ||
(cboWarningValue.Text == "[any]" && cboErrorValue.Text == "[any]"))
{
throw new InPutValidationException("Only one value can be [any]!", cboSuccessValue);
}
if (cboReturnType.SelectedIndex != 0)
{
if (cboReturnType.SelectedIndex == 3)
{
chkReturnValueNotInverted.Checked = true;
}
//if (cboReturnType.SelectedIndex == 0 && cboSuccessValue.Text != "[null]" && cboSuccessValue.Text != "[any]" && !cboSuccessValue.Text.IsLong())
// throw new InPutValidationException("Success value must be a valid integer!\r\n(or predefined values [any] or [null])", cboSuccessValue);
//else
if (cboWarningValue.Text != "[null]" && cboWarningValue.Text != "[any]" && !cboWarningValue.Text.IsLong())
{
throw new InPutValidationException("Warning value must be a valid integer!\r\n(or predefined values [any] or [null])", cboWarningValue);
}
else if (cboErrorValue.Text != "[null]" && cboErrorValue.Text != "[any]" && !cboErrorValue.Text.IsLong())
{
throw new InPutValidationException("Error value must be a valid integer!\r\n(or predefined values [any] or [null])", cboErrorValue);
}
else if (chkReturnValueNotInverted.Checked)
{
//if (cboSuccessValue.Text != "[null]" && cboSuccessValue.Text != "[any]" &&
// cboWarningValue.Text != "[null]" && cboWarningValue.Text != "[any]" &&
// long.Parse(cboSuccessValue.Text) >= long.Parse(cboWarningValue.Text))
// throw new InPutValidationException("Success value must smaller than Warning value", cboSuccessValue);
//else
if (cboWarningValue.Text != "[null]" && cboWarningValue.Text != "[any]" &&
cboErrorValue.Text != "[null]" && cboErrorValue.Text != "[any]" &&
int.Parse(cboWarningValue.Text) >= long.Parse(cboErrorValue.Text))
{
throw new InPutValidationException("Warning value must smaller than Error value", cboWarningValue);
}
}
else if (!chkReturnValueNotInverted.Checked)
{
if (cboSuccessValue.Text != "[null]" && cboSuccessValue.Text != "[any]" &&
cboWarningValue.Text != "[null]" && cboWarningValue.Text != "[any]" &&
long.Parse(cboSuccessValue.Text) <= long.Parse(cboWarningValue.Text))
{
throw new InPutValidationException("Success value must bigger than Warning value", cboSuccessValue);
}
else if (cboWarningValue.Text != "[null]" && cboWarningValue.Text != "[any]" &&
cboErrorValue.Text != "[null]" && cboErrorValue.Text != "[any]" &&
long.Parse(cboWarningValue.Text) <= long.Parse(cboErrorValue.Text))
{
throw new InPutValidationException("Warning value must bigger than Error value", cboWarningValue);
}
}
}
if (txtDetailQuery.Text.Trim().Length == 0)
{
throw new InPutValidationException("The detail query must be specified!", txtDetailQuery);
}
if (!SQLTools.TSQLValid(txtDetailQuery.Text))
{
throw new InPutValidationException("SQL statements may not contain certain keywords (e.g. update, delete, create etc!", txtDetailQuery);
}
return(true);
}
catch (InPutValidationException ex)
{
MessageBox.Show(ex.Message, "Input Validation", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
if (ex.ValidatedObject is Control)
{
Control theControl = ((Control)ex.ValidatedObject);
if (theControl.Parent != null && theControl.Parent is TabPage)
{
tabControlConfig.SelectedTab = (TabPage)theControl.Parent;
}
((Control)ex.ValidatedObject).Focus();
}
return(false);
}
}
//显示所有数据的按钮
private void button5_Click(object sender, EventArgs e)
{
DataTable dt = SQLTools.findData("' or 1=1;--");
addGrid(dt);
}
//系部被下拉选择
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
//给专业设置相应数据 形成联动
addCombo(SQLTools.getMenu(comboBox2.SelectedItem.ToString()), comboBox3);
}
//普通查找
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = SQLTools.findData(textBox1.Text);
addGrid(dt);
}
