public Boolean insertPromoted(enPromoted enPromoted) { try { str = "INSERT INTO promoted (personalID,updateDate,oldSalary,newSalary,oldPositionID,oldPositionDetail,newPositionID,newPositionDetail,remark)VALUES(@personalID,@updateDate,@oldSalary,@newSalary,@oldPositionID,@oldPositionDetail,@newPositionID,@newPositionDetail,@remark);"; Dbcmd = db.GetSqlStringCommand(str); db.AddInParameter(Dbcmd, "@personalID", DbType.Int32, enPromoted.personalID); db.AddInParameter(Dbcmd, "@updateDate", DbType.DateTime, enPromoted.updateDate); db.AddInParameter(Dbcmd, "@oldSalary", DbType.Double, enPromoted.oldSalary); db.AddInParameter(Dbcmd, "@newSalary", DbType.Double, enPromoted.newSalary); db.AddInParameter(Dbcmd, "@oldPositionID", DbType.Int32, enPromoted.oldPositionID); db.AddInParameter(Dbcmd, "@oldPositionDetail", DbType.String, enPromoted.oldPositionDetail); db.AddInParameter(Dbcmd, "@newPositionID", DbType.Int32, enPromoted.newPositionID); db.AddInParameter(Dbcmd, "@newPositionDetail", DbType.String, enPromoted.newPositionDetail); db.AddInParameter(Dbcmd, "@remark", DbType.String, enPromoted.remark); db.ExecuteNonQuery(Dbcmd); return true; } catch (Exception ex) { throw new Exception(ex.Message); } }
public Boolean updatePromoted(enPromoted enPromoted) { try { str = "UPDATE promoted SET personalID=@personalID,updateDate=@updateDate,oldSalary=@oldSalary,newSalary=@newSalary,oldPositionID=@oldPositionID,oldPositionDetail=@oldPositionDetail,newPositionID=@newPositionID,newPositionDetail=@newPositionDetail,remark=@remark WHERE promotedID=@promotedID;"; Dbcmd = db.GetSqlStringCommand(str); db.AddInParameter(Dbcmd, "@personalID", DbType.Int32, enPromoted.personalID); db.AddInParameter(Dbcmd, "@updateDate", DbType.DateTime, enPromoted.updateDate); db.AddInParameter(Dbcmd, "@oldSalary", DbType.Double, enPromoted.oldSalary); db.AddInParameter(Dbcmd, "@newSalary", DbType.Double, enPromoted.newSalary); db.AddInParameter(Dbcmd, "@oldPositionID", DbType.Int32, enPromoted.oldPositionID); db.AddInParameter(Dbcmd, "@oldPositionDetail", DbType.String, enPromoted.oldPositionDetail); db.AddInParameter(Dbcmd, "@newPositionID", DbType.Int32, enPromoted.newPositionID); db.AddInParameter(Dbcmd, "@newPositionDetail", DbType.String, enPromoted.newPositionDetail); db.AddInParameter(Dbcmd, "@remark", DbType.String, enPromoted.remark); db.AddInParameter(Dbcmd, "@promotedID", DbType.Int32, enPromoted.promotedID); db.ExecuteNonQuery(Dbcmd); return true; } catch (Exception ex) { throw new Exception(ex.Message); } }