protected void btnAdd_Click(object sender, EventArgs e)
{
strtDsznfmjlb tmp = new strtDsznfmjlb();
tmp.name = txtName.Text;
tmp.sex = Convert.ToInt16(dplSex.SelectedIndex);
tmp.birthday = Convert.ToDateTime(txtBirthday.Text);
tmp.childbirthday = Convert.ToDateTime(txtChildBirthday.Text);
tmp.childsex = Convert.ToInt16(dplChildSex.SelectedIndex);
tmp.familycode = txtfamilyCode.Text;
tmp.isoldinsure = Convert.ToInt16(chkIsOldInsure.Checked); //是否参加养老保险补贴(0 未 1 参加)
tmp.locationcode = txtLocationCode.Text;
tmp.lushi = Convert.ToInt16(chkLushi.Checked ? 1 : 0);
tmp.lushidate = Convert.ToDateTime(txtLushiDate.Text);
tmp.namelocation = txtLocation.Text;
tmp.onechildcardcode = txtOneChildCardCode.Text;
tmp.paydate = Convert.ToDateTime(txtPaydate.Text);
tmp.paynum = Convert.ToDouble(txtPaynum.Text);
tmp.poldcode = txtPoldcode.Text;
tmp.poname = txtPoName.Text;
tmp.shenghe = Convert.ToInt16(dplShenghe.SelectedIndex);
tmp.shenghedate = Convert.ToDateTime(txtShenghedate.Text);
tmp.shenghenoreason = txtShengheNoReason.Text;
tmp.shengheren = txtShengheRen.Text;
tmp.unitname = txtUnitName.Text;
tmp.unitxingzhi = Convert.ToInt16(dplUnitXingzhi.SelectedIndex);
tmp.username = Session["UserName"].ToString();
tmp.inputdate = DateTime.Now;
string strSQL = Table_Dsznfmjlb.GetSQL_Insert(tmp);
rwDB db = new rwDB();
db.ExcuteSQL(strSQL);
}
protected void ImageButton1_Click1(object sender, ImageClickEventArgs e)
{
//string uname = Request["username"];
//string upassword = Request["password"];
//stockClass sc = new stockClass();
//string sqlConStr = "Server=Localhost;Integrated Security=True;DataBase=lydxDB;";
//SqlConnection sqlcon = new SqlConnection(sqlConStr);
//try
//{
// sqlcon.Open();
// //SqlDataAdapter oda = new SqlDataAdapter("select * from [User]", sqlcon);
// //DataSet ds = new DataSet();
// //oda.Fill(ds);
// //GridView1.DataSource = ds;
// //GridView1.DataBind();
// //Response.Write("<script language=javascript>alert('访问成功')</script>");
// string cmdText = "select * from [User] where Name='"
// + username.Text.Trim() +"' and Password ='******'";
// SqlCommand cmd = new SqlCommand(cmdText, sqlcon);
// SqlDataReader dr = cmd.ExecuteReader();
// if(dr.Read())
// {
// //string value = dr["Name"].ToString();
// //Response.Write(value + "<br />");
// Session["UserName"] = username.Text;
// Session["LoginTime"] = DateTime.Now;
// Response.Redirect("default2.aspx");
// }
// else
// {
// Response.Write("<script>alert('用户名或密码错误！');history.back()</script>");
// }
// dr.Close();
//}
//catch (Exception error)
//{
// Response.Write(error.ToString());
// Response.Write("<script>alert('访问失败')</script>");
//}
//finally
//{
// sqlcon.Close();
//}
try
{
string uname = Request["username"];
string upassword = Request["password"];
rwDB db = new rwDB();
string strSQL = "select password from users where user='******' and password='******'";
DataTable dttTmp = db.GetDataTable(strSQL);
if (dttTmp != null && dttTmp.Rows.Count > 0)
{
Session["UserName"] = username.Text;
Session["LoginTime"] = DateTime.Now;
Response.Redirect("default2.aspx");
}
else
{
Response.Write("<script>alert('用户名或密码错误！');history.back()</script>");
}
}
catch (System.Exception )
{
}
}
