public void leesRekeningen()
{
string connString = ConfigurationManager
.ConnectionStrings["ReserveringenConnectionStringSQL"]
.ConnectionString;
sqlConnection dbConnection = new sqlConnection(connString);
}
public bool CreateUser(createUser createUser)
{
SqlCommand cmd = new SqlCommand();
sqlConnection obj_con = new sqlConnection();
int noOfRows = 0;
if (obj_con.con.State == ConnectionState.Closed)
{
obj_con.con.Open();
}
try
{
cmd.CommandText = "sign_up_insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = obj_con.con;
cmd.Parameters.AddWithValue("@firstName", createUser.firstName);
cmd.Parameters.AddWithValue("@lastName", createUser.lastName);
cmd.Parameters.AddWithValue("@password", Utility.Encryptpassword(createUser.password));
cmd.Parameters.AddWithValue("@emailId", createUser.emailId);
cmd.Parameters.AddWithValue("@phoneNo", createUser.phoneNo);
cmd.Parameters.AddWithValue("@isAdmin", createUser.isAdmin == true?1:0);
noOfRows = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
cmd.Dispose();
obj_con.con.Close();
obj_con.con.Dispose();
}
return(noOfRows > 0 ? true : false);
}
public bool DeleteEmployee(int id)
{
SqlCommand cmd = new SqlCommand();
sqlConnection obj_con = new sqlConnection();
int noOfRows = 0;
if (obj_con.con.State == ConnectionState.Closed)
{
obj_con.con.Open();
}
try
{
cmd.CommandText = "delete_emp_info";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = obj_con.con;
cmd.Parameters.AddWithValue("@id", id);
noOfRows = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
cmd.Dispose();
obj_con.con.Close();
obj_con.con.Dispose();
}
return(noOfRows > 0 ? true : false);
}
public string selectEncryptPassword(string username)
{
SqlCommand cmd = new SqlCommand();
sqlConnection obj_con = new sqlConnection();
string pswrd = "";
if (obj_con.con.State == ConnectionState.Closed)
{
obj_con.con.Open();
}
try
{
cmd.CommandText = "select_encryt_pswrd";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = obj_con.con;
cmd.Parameters.AddWithValue("@userName", username);
cmd.Parameters.AddWithValue("@password", pswrd);
cmd.Parameters["@password"].Direction = ParameterDirection.Output;
cmd.Parameters["@password"].SqlDbType = SqlDbType.VarChar;
cmd.Parameters["@password"].Size = 100;
cmd.ExecuteScalar();
pswrd = cmd.Parameters["@password"].Value.ToString();;
}
catch (Exception ex)
{
}
finally
{
cmd.Dispose();
obj_con.con.Close();
obj_con.con.Dispose();
}
return(pswrd);
}
public bool UpdateEmployee(EmployeeInfo employeeInfo)
{
SqlCommand cmd = new SqlCommand();
sqlConnection obj_con = new sqlConnection();
int noOfRows = 0;
if (obj_con.con.State == ConnectionState.Closed)
{
obj_con.con.Open();
}
try
{
cmd.CommandText = "emp_info_update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = obj_con.con;
cmd.Parameters.AddWithValue("@id", employeeInfo.id);
cmd.Parameters.AddWithValue("@userName", employeeInfo.Empname);
cmd.Parameters.AddWithValue("@designation", employeeInfo.Designation);
cmd.Parameters.AddWithValue("@location", employeeInfo.Location);
noOfRows = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
cmd.Dispose();
obj_con.con.Close();
obj_con.con.Dispose();
}
return(noOfRows > 0 ? true : false);
}
public bool UpdateSalary(EmpSal empSal)
{
SqlCommand cmd = new SqlCommand();
sqlConnection obj_con = new sqlConnection();
int noOfRows = 0;
if (obj_con.con.State == ConnectionState.Closed)
{
obj_con.con.Open();
}
try
{
cmd.CommandText = "update_sal_info";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = obj_con.con;
cmd.Parameters.AddWithValue("@id", empSal.Id);
cmd.Parameters.AddWithValue("@basic", empSal.Basic);
cmd.Parameters.AddWithValue("@hra", empSal.Hra);
cmd.Parameters.AddWithValue("@ta", empSal.Ta);
cmd.Parameters.AddWithValue("@sa", empSal.Sa);
cmd.Parameters.AddWithValue("@total", empSal.Salary);
noOfRows = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
cmd.Dispose();
obj_con.con.Close();
obj_con.con.Dispose();
}
return(noOfRows > 0 ? true : false);
}
public DataTable getData2(string proc)
{
DataTable dt = new DataTable("test");
sqlConnection sql = new sqlConnection();
dt = sql.getData2(proc);
return(dt);
}
void LearnSuccess()
{
sqlConnection sql = new sqlConnection();
sql.Learned(Data.id[0]);
sql.Learned(Data.id[1]);
sql.Learned(Data.id[2]);
sql.Learned(Data.id[3]);
sql.Learned(Data.id[4]);
}
private void button1_Click(object sender, EventArgs e)
{
sqlConnection sc = new sqlConnection();
string[] saveData = new string[] {
textBox1_D_Kth.Text.Trim().ToString(),
textBox2_E.Text.Trim().ToString(),
textBox3_KC_max.Text.Trim().ToString(),
textBox4_KC_min.Text.Trim().ToString(),
textBox5_Kc.Text.Trim().ToString(),
textBox1_a0.Text.Trim().ToString()
};
JudgeInputText Judge = new JudgeInputText();
for (int i = 0; i < saveData.Length; i++)
{
if (Judge.judge(saveData[i]) == false)
{
MessageBox.Show("输入的内容为空或者不是数字数字，请检查！！");
return;
}
}
sc.Save_SQL_Data(saveData, "ExpandVelocity");
double E = Convert.ToDouble(textBox2_E.Text);
double D_kth = Convert.ToDouble(textBox1_D_Kth.Text),
Kc = Convert.ToDouble(textBox5_Kc.Text),
KCmax = Convert.ToDouble(textBox3_KC_max.Text),
KCmin = Convert.ToDouble(textBox4_KC_min.Text),
D_KC, D_K, R;
R = KCmax / KCmin;
double a0, a1; //积分上下
a0 = Convert.ToDouble(textBox1_a0.Text);
a1 = (1 / Math.PI) * Math.Pow((Kc / (1.12 * KCmax)), 2);
double H; //步长
double sum = 0;
H = Math.Abs(a0 - a1) / 10000;
D_KC = KCmax - KCmin;
for (double i = 0; i < 10000; i++)
{
double a = a0 + H * (i + 0.5);
D_K = D_KC * Math.Sqrt(Math.PI * a);
double s1 = H * (Math.Pow(E, 2) / 48 * Math.Pow(D_K + D_kth, -0.5) * Math.Pow((1 / D_K - 1 / ((1 - R) * Kc)), 1.5));
sum += s1;
}
label1.Text = Convert.ToString(sum / 0.01) + "\n------说明-----\n:此结构还可\n承受" + Convert.ToString((int)(sum / 0.01)) + "次冲击";
}
public LoginInfo OnLogin(LoginInfo loginInfo)
{
SqlCommand cmd = new SqlCommand();
sqlConnection obj_con = new sqlConnection();
if (obj_con.con.State == ConnectionState.Closed)
{
obj_con.con.Open();
}
try
{
cmd.CommandText = "check_login_new";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = obj_con.con;
cmd.Parameters.AddWithValue("@userName", loginInfo.userName);
cmd.Parameters.AddWithValue("@password", Utility.CheckPassword(loginInfo.password, selectEncryptPassword(loginInfo.userName)));
cmd.Parameters.AddWithValue("@msg", loginInfo.msg);
cmd.Parameters["@msg"].Direction = ParameterDirection.Output;
cmd.Parameters["@msg"].SqlDbType = SqlDbType.VarChar;
cmd.Parameters["@msg"].Size = 100;
cmd.Parameters.AddWithValue("@userid", loginInfo.userId);
cmd.Parameters["@userid"].Direction = ParameterDirection.Output;
cmd.Parameters["@userid"].SqlDbType = SqlDbType.Int;
cmd.Parameters["@userid"].Size = 100;
cmd.Parameters.AddWithValue("@status", loginInfo.userId);
cmd.Parameters["@status"].Direction = ParameterDirection.Output;
cmd.Parameters["@status"].SqlDbType = SqlDbType.Int;
cmd.Parameters["@status"].Size = 100;
cmd.ExecuteScalar();
loginInfo.msg = cmd.Parameters["@msg"].Value.ToString();
loginInfo.userId = Convert.ToInt32(cmd.Parameters["@userid"].Value);
loginInfo.status = Convert.ToInt32(cmd.Parameters["@status"].Value);
}
catch (Exception ex)
{
loginInfo.msg = ex.Message;
loginInfo.status = 0;
}
finally
{
cmd.Dispose();
obj_con.con.Close();
obj_con.con.Dispose();
}
return(loginInfo);
}
public List <EmployeeInfo> GetEmployeeById(int id)
{
SqlCommand cmd = new SqlCommand();
sqlConnection obj_con = new sqlConnection();
List <EmployeeInfo> empList = new List <EmployeeInfo>();
if (obj_con.con.State == ConnectionState.Closed)
{
obj_con.con.Open();
}
try
{
cmd.CommandText = "select_employee_info";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = obj_con.con;
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
EmployeeInfo emp = new EmployeeInfo
{
id = (int)dr[0],
Empname = dr[1].ToString(),
Designation = dr[2].ToString(),
Location = dr[3].ToString(),
Userid = (int)dr[4],
Basic = (int)dr[8],
Hra = (int)dr[9],
Ta = (int)dr[10],
Sa = (int)dr[11],
Salary = (int)dr[12],
};
empList.Add(emp);
}
}
catch (Exception ex)
{
}
finally
{
cmd.Dispose();
obj_con.con.Close();
obj_con.con.Dispose();
}
return(empList);
}
private void Add_Click(object sender, EventArgs e)
{
{
if (textBox1.Text == "")
{
MessageBox.Show("请选择数据目录");
return;
}
try
{
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + textBox1.Text + ";" +
"Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
//实例化一个Oledbconnection类(实现了IDisposable,要using)
using (OleDbConnection ole_conn = new OleDbConnection(sConnectionString))
{
ole_conn.Open();
DataSet ds = new DataSet();
using (OleDbCommand ole_cmd = ole_conn.CreateCommand())
{
//类似SQL的查询语句这个[Sheet1$对应Excel文件中的一个工作表]
ole_cmd.CommandText = "select * from [Sheet1$]";
OleDbDataAdapter adapter = new OleDbDataAdapter(ole_cmd);
adapter.Fill(ds, "Sheet1");
dataGridView2.DataSource = ds.Tables[0].DefaultView;
sqlConnection sqlstring = new sqlConnection();
string str = sqlstring.getconn();
SqlConnection con = new SqlConnection(str); //创建连接对象
con.Open(); //打开连接
SqlBulkCopy bulkcopy = new SqlBulkCopy(con);
bulkcopy.DestinationTableName = "dbo.LData";
bulkcopy.WriteToServer(ds.Tables[0]);
MessageBox.Show("添加信息成功！");
}
}
RefreshDataGridView();
}
catch (Exception E)
{
MessageBox.Show("添加未成功:" + E);
}
}
}
private void KuoZhanSuLv_Load(object sender, EventArgs e)
{
sqlConnection sc = new sqlConnection();
string[] ReadData = sc.Read_SQL_Data("ExpandVelocity");
if (ReadData[1] != null)
{
int i = 0;
try
{
textBox1_D_Kth.Text = ReadData[i++];
textBox2_E.Text = ReadData[i++];
textBox3_KC_max.Text = ReadData[i++];
textBox4_KC_min.Text = ReadData[i++];
textBox5_Kc.Text = ReadData[i++];
textBox1_a0.Text = ReadData[i++];
}
catch (Exception EE)
{
}
}
}
public EmpSal GetSalaryById(int id)
{
SqlCommand cmd = new SqlCommand();
sqlConnection obj_con = new sqlConnection();
EmpSal emp = new EmpSal();
if (obj_con.con.State == ConnectionState.Closed)
{
obj_con.con.Open();
}
try
{
cmd.CommandText = "select_sal_info";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = obj_con.con;
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
emp.Id = (int)dr[0];
emp.Basic = (int)dr[1];
emp.Hra = (int)dr[2];
emp.Ta = (int)dr[3];
emp.Sa = (int)dr[4];
emp.Salary = (int)dr[5];
}
}
catch (Exception ex)
{
}
finally
{
cmd.Dispose();
obj_con.con.Close();
obj_con.con.Dispose();
}
return(emp);
}
private void btDangnhap_Click(object sender, EventArgs e)
{
if (cbAuthentication.SelectedIndex == 0)
{
LOP.XL_BANG.Chuoi_lien_ket = "Data Source=" + txtServerName.Text + ";Initial Catalog=QLTHUVIEN;Intergrated Scurity=True";
}
else
{
LOP.XL_BANG.Chuoi_lien_ket = "Data Source=" + txtServerName.Text + ";Initial Catalog=QLTHUVIEN;User ID=" + txtUserName.Text + ";Password="******"Ket noi thanh cong!");
cnn.Close();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void dataSelect()
{
sqlConnection sqlstring = new sqlConnection();
ConnectionString = sqlstring.getconn();
try
{
ds = new DataSet();
conn = new SqlConnection(ConnectionString);
conn.Open();
sql = "SELECT * FROM LData ";
string condition = "";
//if (dateTimePicker1.Text != "" && dateTimePicker2.Text != "")
//{
// condition = " LaunchTime BETWEEN " + "'" + dateTimePicker1.Value.Date.ToString("yyyy/MM/dd") + "'" + "AND" + "'" + dateTimePicker2.Value.Date.ToString("yyyy/MM/dd") + "'";
//}
if (Combo_insert_times.Text != "")
{
condition = " LaunchTime BETWEEN " + "'" + Convert.ToDateTime(Combo_insert_times.Text).Date.ToString("yyyy/MM/dd") + "'" + "AND" + "'" + Convert.ToDateTime(Combo_insert_times.Text).Date.AddDays(1).ToString("yyyy/MM/dd") + "'";
//condition = " LaunchTime = " + "'" + Convert.ToDateTime(Combo_insert_times.Text).Date.ToString("yyyy/MM/dd") + "'";
}
if (comboBox3.Text != "" && comboBox3.Text != "全部")
{
if (condition.Length > 0)
{
condition += " AND AddOrFly = " + "'" + comboBox3.Text + "'";
}
else
{
condition = " AddOrFly = " + "'" + comboBox3.Text + "'";
}
}
if (condition != "")
{
sql += " where " + condition;
}
da = new SqlDataAdapter(sql, conn);
// 创建一个数据集对象并填充数据，然后将数据显示在DataGrid控件中
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
dataGridView1.Sort(dataGridView1.Columns[1], ListSortDirection.Ascending);
for (int Bui = 0; Bui < dataGridView1.Columns.Count; Bui++)
{
dataGridView1.Columns[Bui].SortMode = DataGridViewColumnSortMode.NotSortable;
if (Bui < 2)
{
dataGridView1.Columns[Bui].HeaderCell.Value = titleName[Bui];
}
String old_columns_name = Convert.ToString(dataGridView1.Columns[Bui].HeaderCell.Value);
if (old_columns_name.Substring(0, 1) == "S")
{
dataGridView1.Columns[Bui].HeaderCell.Value = "测点" + old_columns_name.Substring(1) + "-应力";
}
else if (old_columns_name.Substring(0, 1) == "T")
{
dataGridView1.Columns[Bui].HeaderCell.Value = "测点" + old_columns_name.Substring(1) + "-温度";
}
else if (old_columns_name.Substring(0, 2) == "ZD")
{
dataGridView1.Columns[Bui].HeaderCell.Value = "测点" + old_columns_name.Substring(2) + "-震动";
}
else if (old_columns_name.Substring(0, 2) == "BX")
{
dataGridView1.Columns[Bui].HeaderCell.Value = "测点" + old_columns_name.Substring(2) + "-变形";
}
}
conn.Close();
}
catch (Exception E)
{
MessageBox.Show("查找数据库时发生错误：" + E.Message + "", "错误", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
List <String> item_set = new List <String>();
for (int i = 0; i < dataGridView1.RowCount; i++)
{
String time_item = Convert.ToString(Convert.ToDateTime(dataGridView1.Rows[i].Cells[1].Value).ToString("yyyy/MM/dd"));
if (item_set.Count == 0)
{
item_set.Add(time_item);
}
bool flag = false;
for (int t = 0; t < item_set.Count; t++)
{
if (time_item == item_set[t])
{
flag = true;
}
}
if (flag == false)
{
item_set.Add(time_item);
}
}
//Combo_insert_times.Items.Clear();
List <String> list_a = new List <string>();
for (int i = 0; i < Combo_insert_times.Items.Count; i++)
{
list_a.Add(Combo_insert_times.Items[i].ToString());
}
List <String> list_temp = item_set.Except(list_a).ToList();
//list_a.AddRange(list_temp);
foreach (String y in list_temp)
{
Combo_insert_times.Items.Add(y);
}
}
