private frmEmp GetEmp() { frmEmp emp = new frmEmp(); emp.emp_id = int.Parse(txtEmpID.Text); emp.empcode = txtEmpCode.Text; emp.emp_lnkh = txtKh1.Text; emp.emp_fnkh = txtKh2.Text; emp.emp_lnen = txtEn1.Text; emp.emp_fnen = txtEn2.Text; emp.gender = cbBGender.SelectedItem.ToString(); emp.idcard = txtIDCard.Text; emp.address = rtxtAddress2.Text; emp.phone = txtPhone.Text; emp.email = txtEmail.Text; emp.pos_id = Helper.ifnull(cbBPos.SelectedValue)?0: Convert.ToInt32(cbBPos.SelectedValue); emp.salary = Helper.ifnull(txtSalary.Text) ? 0 : Convert.ToInt32(txtSalary.Text); emp.join_date = Join_date.Text; MemoryStream mem = new MemoryStream(); if (extensionImg == "jpg") { pictureBox1.Image.Save(mem, System.Drawing.Imaging.ImageFormat.Jpeg); } else { pictureBox1.Image.Save(mem, System.Drawing.Imaging.ImageFormat.Png); } emp.img = mem.ToArray(); return(emp); }
public object InsertScalar(frmEmp emp) { return(base.ExecScalar("INSERT INTO " + "Employee(emplnkh, empfnkh, emplnen, empfnen, gender, idcard, address, phone, email, posid, salary, joindate) " + "OUTPUT INSERTED.empid VALUES(@emplnkh, @empfnkh, @emplnen, @empfnen, @gender, @idcard, @address, @phone, @email, @posid, @salary, @joindate)", GetParameter(emp))); }
public int Insert(frmEmp emp) { return(base.ExecNonQuery("INSERT INTO " + "Employee(emplnkh, empfnkh, emplnen, empfnen, gender, idcard, address, phone, email, posid, salary, joindate,Image) " + "VALUES(@emplnkh, @empfnkh, @emplnen, @empfnen, @gender, @idcard, @address, @phone, @email, @posid, @salary, @joindate,convert(Varbinary(max),@img))", GetParameter(emp))); }
private frmEmp GetEmp() { frmEmp emp = new frmEmp(); emp.emp_id = int.Parse(txtEmpID.Text); emp.empcode = txtEmpCode.Text; emp.emp_lnkh = txtKh1.Text; emp.emp_fnkh = txtKh2.Text; emp.emp_lnen = txtEn1.Text; emp.emp_fnen = txtEn2.Text; emp.gender = cbBGender.SelectedItem.ToString(); emp.idcard = txtIDCard.Text; emp.address = rtxtAddress.Text; emp.phone = txtPhone.Text; emp.email = txtEmail.Text; emp.pos_id = Convert.ToInt32(txtPosID.Text); emp.salary = Convert.ToInt32(txtSalary.Text); emp.join_date = Join_date.Text; return(emp); }
public SqlParameter[] GetParameter(frmEmp emp) { SqlParameter[] param = new SqlParameter[15]; param[0] = new SqlParameter("empid", emp.emp_id); param[1] = new SqlParameter("empcode", emp.empcode); param[2] = new SqlParameter("emplnkh", emp.emp_lnkh); param[3] = new SqlParameter("empfnkh", emp.emp_fnkh); param[4] = new SqlParameter("emplnen", emp.emp_lnen); param[5] = new SqlParameter("empfnen", emp.emp_fnen); param[6] = new SqlParameter("gender", emp.gender); param[7] = new SqlParameter("idcard", emp.idcard); param[8] = new SqlParameter("address", emp.address); param[9] = new SqlParameter("phone", emp.phone); param[10] = new SqlParameter("email", emp.email); param[11] = new SqlParameter("posid", emp.pos_id); param[12] = new SqlParameter("salary", emp.salary); param[13] = new SqlParameter("joindate", emp.join_date); param[14] = new SqlParameter("@img", emp.img); return(param); }
public int Update(frmEmp emp) { return(base.ExecNonQuery("UPDATE Employee " + "SET emplnkh=@emplnkh, empfnkh=@empfnkh, emplnen=@emplnen, empfnen=@empfnen, gender=@gender, idcard=@idcard, address=@address, phone=@phone, email=@email, posid=@posid, salary=@salary, joindate=@joindate,Image=Convert(varbinary(max),@img)" + "WHERE empid=@empid", GetParameter(emp))); }