public int AuthUpdate(tb_authorinfo tb_aut)
{
int intResult = 0;
try
{
getConnection getCon = new getConnection();
oledCon = getCon.OledCon();
oledCon.Open();
string strAdd = "update tb_authorinfo set ";
strAdd += "authorName='" + tb_aut.strauthorName + "',authorSex='" + tb_aut.strauthorSex + "',authorbirthday ='" + tb_aut.daauthorbirthday + "',";
strAdd += "authorGenre='" + tb_aut.strauthorGenre + "',authorcompany='" + tb_aut.strauthorcompany + "',authorRecma ='" + tb_aut.strauthorRecma + "',";
strAdd += "authorzjm='" + tb_aut.strauthorzjm + "',RdateTime='" + tb_aut.daRdateTime + "' where authorId='" + tb_aut.intauthorId + "'";
oledcmd = new SqlCommand(strAdd, oledCon);
intResult = oledcmd.ExecuteNonQuery();
return(intResult);
}
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
return(intResult);
}
}
public int AuthAdd(tb_authorinfo tb_aut)
{
int intResult = 0;
try
{
getConnection getCon = new getConnection();
oledCon = getCon.OledCon();
oledCon.Open();
string strAdd = "insert into tb_authorinfo values( ";
strAdd += "'" + tb_aut.intauthorId + "','" + tb_aut.strauthorName + "','" + tb_aut.strauthorSex + "','" + tb_aut.daauthorbirthday + "',";
strAdd += "'" + tb_aut.strauthorGenre + "','" + tb_aut.strauthorcompany + "','" + tb_aut.strauthorRecma + "',";
strAdd += "'" + tb_aut.strauthorzjm + "','" + tb_aut.daRdateTime + "')";
oledcmd = new SqlCommand(strAdd, oledCon);
intResult = oledcmd.ExecuteNonQuery();
return(intResult);
}
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
return(intResult);
}
}
