private bool insertUser()
{
bool f = false;
string sqlstr = "INSERT INTO T_employeeInfo (username, englishname, usertypeid, userpowerid, birthday, cardtype, idcardno, sex, employeeno, joindate, onjob, email, pwd, outdate) values(?username,?englishname,?usertypeid,?userpowerid,?birthday,?cardtype,?idcardno,?sex,?employeeno,?joindate,?onjob,?email,?pwd,?outdate)";
MySqlParameter[] para = new MySqlParameter[14];
//para[0] = new MySqlParameter("?userid",MySqlDbType.int
para[0] = new MySqlParameter("?username", MySqlDbType.VarChar, 50);
para[1] = new MySqlParameter("?englishname", MySqlDbType.VarChar, 50);
para[2] = new MySqlParameter("?usertypeid", MySqlDbType.Int16);
para[3] = new MySqlParameter("?userpowerid", MySqlDbType.Int16);
para[4] = new MySqlParameter("?birthday", MySqlDbType.Date);
para[5] = new MySqlParameter("?cardtype", MySqlDbType.Int16);
para[6] = new MySqlParameter("?idcardno", MySqlDbType.VarChar, 30);
para[7] = new MySqlParameter("?sex", MySqlDbType.Int16);
para[8] = new MySqlParameter("?employeeno", MySqlDbType.Int16);
para[9] = new MySqlParameter("?joindate", MySqlDbType.Date);
para[10] = new MySqlParameter("?onjob", MySqlDbType.Int16);
para[11] = new MySqlParameter("?email", MySqlDbType.VarChar, 100);
para[12] = new MySqlParameter("?pwd", MySqlDbType.VarChar, 200);
para[13] = new MySqlParameter("?outdate", MySqlDbType.Date);
para[0].Value = Username;
para[1].Value = Englishname;
para[2].Value = Usertypeid;
para[3].Value = Userpowerid;
para[4].Value = Birthday.ToShortDateString();
para[5].Value = Cardtype;
para[6].Value = Idcardno;
para[7].Value = Sex;
para[8].Value = Employeeno;
para[9].Value = Joindate.ToShortDateString();
para[10].Value = Onjob;
para[11].Value = Email;
para[12].Value = Pwd;
para[13].Value = Outdate.ToShortDateString();
if (ExecuteNonQuery(sqlstr, para) > 0)
{
f = true;
}
else
{
f = false;
}
return(f);
}
private bool updateUser()
{
bool f = false;
string sqlstr = @"UPDATE T_employeeInfo SET
username = ?username
,englishname = ?englishname
,usertypeid = ?usertypeid
,userpowerid = ?userpowerid
,birthday = ?birthday
,cardtype = ?cardtype
,idcardno = ?idcardno
,sex = ?sex
,employeeno = ?employeeno
,joindate = ?joindate
,outdate = ?outdate
,onjob = ?onjob
,email = ?email
WHERE userid = ?userid";
MySqlParameter[] para = new MySqlParameter[14];
//para[0] = new MySqlParameter("?userid",MySqlDbType.int
para[0] = new MySqlParameter("?username", MySqlDbType.VarChar, 50);
para[1] = new MySqlParameter("?englishname", MySqlDbType.VarChar, 50);
para[2] = new MySqlParameter("?usertypeid", MySqlDbType.Int16);
para[3] = new MySqlParameter("?userpowerid", MySqlDbType.Int16);
para[4] = new MySqlParameter("?birthday", MySqlDbType.Date);
para[5] = new MySqlParameter("?cardtype", MySqlDbType.Int16);
para[6] = new MySqlParameter("?idcardno", MySqlDbType.VarChar, 30);
para[7] = new MySqlParameter("?sex", MySqlDbType.Int16);
para[8] = new MySqlParameter("?employeeno", MySqlDbType.Int16);
para[9] = new MySqlParameter("?joindate", MySqlDbType.Date);
para[10] = new MySqlParameter("?outdate", MySqlDbType.Date);
para[11] = new MySqlParameter("?onjob", MySqlDbType.Int16);
para[12] = new MySqlParameter("?email", MySqlDbType.VarChar, 100);
para[13] = new MySqlParameter("?userid", MySqlDbType.Int16);
para[0].Value = Username;
para[1].Value = Englishname;
para[2].Value = Usertypeid;
para[3].Value = Userpowerid;
para[4].Value = Birthday.ToShortDateString();
para[5].Value = Cardtype;
para[6].Value = Idcardno;
para[7].Value = Sex;
para[8].Value = Employeeno;
para[9].Value = Joindate.ToShortDateString();
para[10].Value = Outdate.ToShortDateString();
para[11].Value = Onjob?1:0;
para[12].Value = Email;
para[13].Value = Userid;
if (ExecuteNonQuery(sqlstr, para) > 0)
{
f = true;
}
else
{
f = false;
}
xuxSeecion.ERRMESSAGE = "修改人员信息出错";
return(f);
}